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
TurboRouter (Pre-compiled Queries) Stable ✅ Production 4-10x faster execution
Hybrid Table Optimization Stable ✅ Production 10-100x faster indexed queries
Database-First CQRS Stable ✅ Production PostgreSQL Views & Functions
Specialized PostgreSQL Types Stable ✅ Production IPv4/IPv6, LTree, DateRange, etc.
FastAPI Integration Stable ✅ Production Async-first, type-safe
LLM-Optimized Patterns Stable ✅ Production Claude/Copilot friendly
GraphQL Subscriptions Planned 🔜 Roadmap Targeted for future release

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.)
  • • GraphQL subscriptions are critical for your use case
  • • 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