th0th v1.1.0-beta – PostgreSQL Migration & Core Refactor

[S1LV4]

Th0th v1.1.0 (Beta)

This is a beta release for the next major version of th0th.
It includes significant architectural changes, performance improvements, and ongoing stabilization work.

Some features are still missing and additional polishing is expected before the final release.

---

⚠️ Breaking Changes

• Infrastructure

  • Migrated to PostgreSQL + pgvector as the primary relational/vector backend
  • Replaces the previous SQLite-first default (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

• Core Architecture

  • Replaced singleton-style services with factory-based access for:

    • Vector store
    • Keyword search
    • Symbol repository
    • Cache
    • Analytics (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

• Configuration / Docs

  • Updated OpenCode MCP config:

    • mcpServers/env ➜ mcp/environment

  • Reflects the new schema for modern setups (Update README mcp config example #17)

---

Bug Fixes

• API Client

  • Fixed query parameter typing (now string tuples)
  • Prevents request serialization issues (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

• Tests

  • PostgreSQL integration tests are now skipped when DB is not configured
  • Avoids false negatives in CI/local runs (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

• Memory / Search

  • Improved:

    • Project-level memory deletion
    • Query handling consistency (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

---

Refactors & Performance Improvements

• Graph System

  • Optimized indexes and queries for faster traversal and lookups (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)
  • Eliminated N+1 query pattern in BFS traversal (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

• Checkpoint System

  • Implemented lazy deserialization for checkpoint listing (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

• Metrics

  • Added unified token metrics with pricing mapping support (feat: PostgreSQL migration, async factory backends and embeddings rate limiting #18)

---

Documentation

• Updated README:

  • MCP/OpenCode configuration examples aligned with the new schema
  • Improved onboarding clarity (Update README mcp config example #17)

---

New Contributors

• Welcome @Altamir for their first contribution! 🎉
  • Update README mcp config example #17

---

Full Changelog

v.1.0.1...v1.1.0

---

This discussion was created from the release th0th v1.1.0-beta – PostgreSQL Migration & Core Refactor.