Why FauxDB
Dual-Protocol Support
MongoDB AND MySQL wire protocols simultaneously! Connect with mongosh OR mysql client—access the SAME data through both protocols.
MongoDB Wire Protocol
Full MongoDB compatibility. Use mongosh, PyMongo, Node.js driver, and all MongoDB clients with zero changes.
MySQL Wire Protocol
Standard MySQL protocol support via msql-srv. Connect with mysql client, Tableau, PowerBI, and all MySQL tools.
SQL Query Translator
Automatic MySQL → PostgreSQL query translation. Handles backticks, data types, functions, LIMIT syntax, and 20+ patterns.
Rust Performance
Built in Rust for memory safety and concurrency. 10,000+ ops/sec MongoDB throughput, 5,000+ ops/sec MySQL throughput.
Pure PostgreSQL Backend
Native JSONB storage with PostgreSQL power. ACID transactions, data integrity, and enterprise features. Zero external dependencies.
Production Ready
Enterprise-grade monitoring, Prometheus metrics, Grafana dashboards, health checks, and comprehensive logging.
Advanced Features
Transactions, geospatial queries (PostGIS), aggregation pipeline, change streams, and connection pooling.
Cross-Protocol Consistency
Insert via MongoDB, query via MySQL. Write via MySQL, read via MongoDB. Always consistent with PostgreSQL ACID.
| Capability | Description | Performance | Status |
|---|---|---|---|
| Dual-Protocol | MongoDB AND MySQL protocols simultaneously on ports 27018 + 3306 | 10K+ MongoDB ops/sec, 5K+ MySQL ops/sec | ✓ |
| MongoDB Protocol | Full wire protocol, mongosh, PyMongo, Node.js driver | P50 < 5ms, P99 < 50ms | ✓ |
| MySQL Protocol | Standard MySQL protocol, mysql client, Tableau, PowerBI | msql-srv library | ✓ |
| SQL Translator | MySQL → PostgreSQL query translation (700+ lines) | 20+ translation patterns | ✓ |
| PostgreSQL Backend | Native JSONB storage, ACID transactions, zero dependencies | PostgreSQL 17+ | ✓ |
| Monitoring | Prometheus metrics, Grafana dashboards, health checks | Per-protocol tracking | ✓ |
| Feature | FauxDB | FerretDB | MongoDB | MySQL |
|---|---|---|---|---|
| MongoDB Wire Protocol | ✔️ Port 27018 | ✔️ | ✔️ | ✗ |
| MySQL Wire Protocol | ✔️ Port 3306 | ✗ | ✗ | ✔️ |
| Dual-Protocol (Both) | ✔️ Unique! | ✗ | ✗ | ✗ |
| PostgreSQL Backend | ✔️ JSONB | ✔️ | ✗ | ✔️ |
| ACID Transactions | ✔️ | ✔️ | ✔️ | ✔️ |
| Geospatial Queries | ✔️ | Limited | ✔️ | ✔️ |
| Aggregation Pipeline | ✔️ | Partial | ✔️ | Limited |
| Advanced Indexing | ✔️ | ✔️ | ✔️ | ✔️ |
| Rust Performance | ✔️ | Go | ✗ | ✗ |
| PostgreSQL Storage | ✔️ | ✔️ | ✗ | ✔️ |
| Multi-Document Transactions | ✔️ | Partial | ✔️ | Limited |
| Production Ready | ✔️ | ✔️ | ✔️ | ✔️ |
Deploy Dual-Protocol Database
Install FauxDB and access your PostgreSQL data through both MongoDB and MySQL protocols simultaneously with zero downtime migration.