Database
Core
- PostgreSQL 15+ as the primary database
- PgBouncer for connection pooling
- Elixir for realtime functionality (Phoenix framework)
- Logical replication for change data capture
- WAL (Write-Ahead Logging) for streaming
- TypeScript/Python SDKs
Extensions
- pgvector for vector embeddings
- postgis for geospatial
- pg_graphql for GraphQL
- pg_net for HTTP requests