Production Status

PyPI version Status License

FraiseQL is production-ready and actively maintained

Current Status

✅

Production-Ready

Stable API surface with comprehensive test coverage and real-world usage validation

🚀

Active Development

Regular releases with new features, performance improvements, and bug fixes

🛡️

Enterprise Patterns

Built-in support for multi-tenancy, APQ, CQRS architecture, and audit logging

Feature Maturity

Feature Status Production Use Notes
APQ with Multi-Tenant Isolation Stable ✅ Production Sub-5ms cached responses
Hybrid Table Optimization Stable ✅ Production 10-100x faster queries
(vs traditional ORM JOINs)
Rust Pipeline Performance Stable ✅ Production 7-10x faster JSON transformation
(Rust vs Python processing)
Database-First CQRS Stable ✅ Production PostgreSQL Views & Functions
Specialized PostgreSQL Types Stable ✅ Production IPv4/IPv6, LTree, DateRange, etc.
LLM-Optimized Patterns Stable ✅ Production Claude/Copilot friendly
Advanced Filtering (38+ Operators) Stable ✅ Production Full-text search, JSONB, arrays, regex
Security Architecture Stable ✅ Production Explicit contracts, audit trails
AI-Native Development Stable ✅ Production LLM-friendly patterns & contracts
GraphQL Subscriptions Stable ✅ Production WebSocket support, filtering, caching
pgvector Integration

Native vector similarity search with 9+ distance operators

 Stable ✅ Production Details →
GraphQL Cascade

Automatic cache invalidation with mutation side effects

 Stable ✅ Production Details →
LangChain Integration

Build RAG applications with LangChain + FraiseQL

 Stable ✅ Production Details →
LlamaIndex Integration

Build RAG applications with LlamaIndex + FraiseQL

 Stable ✅ Production Details →

Production Deployment Guidance

✅ Recommended For Production

  • ✓ Multi-tenant SaaS applications
  • ✓ High-performance APIs (sub-10ms requirements)
  • ✓ PostgreSQL-first architectures
  • ✓ Teams using FastAPI with async/await
  • ✓ Projects requiring enterprise patterns (APQ, CQRS, audit logs)
  • ✓ Development teams using AI coding assistants

⚠️ Consider Alternatives If

  • • You need multi-database support (MySQL, MongoDB, etc.)
  • • Using Django (integration possible but not first-class)
  • • Simple CRUD with no performance requirements
  • • Cannot use Python 3.13+ (framework requirement)

See Hasura or Strawberry GraphQL for alternatives.

Requirements & Compatibility

Python

3.13+

Required for modern type system features and performance optimizations

PostgreSQL

13+

Uses JSONB, Functions, Views, and specialized types extensively

FastAPI

0.115+

Async-first integration with dependency injection

Release History & Changelog

For detailed release notes, version history, and breaking changes, see:

GitHub Releases CHANGELOG.md PyPI History