Is CrossDB really faster than SQLite?

Yes, CrossDB's benchmarks demonstrate significant performance gains over SQLite for random access with 1,000,000 rows, but real-world results depend on specific workloads and configurations.

How to set up replication in CrossDB?

CrossDB supports source-replica and multi-source replication; detailed steps are in the documentation, but note that logical replication is still under development (TBD).

What programming languages work with CrossDB?

Current bindings include C, C++, Python, Go, and Rust, with more planned. Check the README for updates, as some language support is marked as TBD.

Can I use CrossDB for embedded IoT devices?

Yes, its lightweight footprint and support for server-less modes make it suitable for embedded systems, though ensure the feature set meets your needs given its early stage.

Does CrossDB handle JSON data effectively?

Yes, it includes JSON as a native data type, allowing storage and querying within SQL, which is useful for applications mixing relational and document data.

CrossDB or SQLite for a new embedded project?

Choose CrossDB if you need higher performance and features like replication, but stick with SQLite for proven stability and broader ecosystem support until CrossDB matures.

CrossDB

MPL-2.0C0.14.0

An ultra high-performance lightweight embedded and server OLTP relational database management system written in C.

Visit Website GitHub

258 stars20 forks0 contributors

What is CrossDB?

CrossDB is an ultra high-performance lightweight relational database management system designed for both embedded and server OLTP (Online Transaction Processing) workloads. It provides ACID compliance, SQL support with MySQL extensions, and multiple storage models including in-memory and on-disk options. The project aims to deliver exceptional performance while maintaining a small footprint suitable for resource-constrained environments.

Target Audience

Developers and engineers building applications that require a high-performance, lightweight database for embedded systems, edge computing, or server applications where SQLite or similar embedded databases are insufficient. System architects needing flexible deployment options from embedded to standalone server modes.

Value Proposition

CrossDB offers significantly higher performance than SQLite while maintaining a lightweight architecture, with additional enterprise features like replication, MVCC concurrency control, and hybrid storage models. Its C implementation and cross-platform support make it ideal for performance-critical applications across diverse hardware environments.

Overview

Ultra High-performance Lightweight Embedded and Server OLTP RDBMS✨

Use Cases

Best For

Related Projects

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub

Embedded systems requiring a high-performance SQL database
Server applications needing lightweight OLTP database with replication
Edge computing deployments where resource efficiency is critical
Applications requiring hybrid in-memory and on-disk storage strategies
Projects migrating from SQLite that need better performance and more features
Systems requiring cross-platform database support (Linux, Windows, macOS, FreeBSD)

Not Ideal For

Production systems requiring mature stability and extensive third-party tooling
Applications dependent on foreign key constraints or PostgreSQL-style MVCC, as these features are still in development
Workflows needing XML data support or advanced data partitioning methods

Pros & Cons

Pros

Benchmarked High Performance

Shows significant speed advantages over SQLite and C++ STL containers in random access benchmarks, making it ideal for OLTP workloads.

Versatile Deployment Modes

Supports server-less, embedded server, and standalone server modes across Linux, Windows, macOS, and FreeBSD, enabling flexible use from embedded to server environments.

Hybrid Storage Flexibility

Allows per-table designation for in-memory, on-disk, or RamDisk storage, providing fine-grained control over performance and persistence strategies.

MySQL-Compatible SQL

Implements SQL with extensions from MySQL and supports data types like JSON, INET, and MAC addresses, easing migration for users familiar with MySQL.

Cons

Early Development Instability

The README explicitly states the project is in early stages and lacks stability, with many features marked as TBD, making it risky for production use.

Incomplete Feature Set

Key features like foreign keys, row-level locks, additional language bindings, and user management are not yet implemented, limiting its utility for complex applications.

Cumbersome Windows Build

Building on Windows requires installing MINGW64, CMake, and make, adding setup complexity compared to simpler, more established databases.

Frequently Asked Questions

Home

C/C++

LevelDB

LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.

Stars39,096

Forks8,197

Last commit2 months ago

RocksDB

A library that provides an embeddable, persistent key-value store for fast storage.

Minimalistic C client for Redis >= 1.2

Stars6,651

Forks1,846

Last commit2 months ago

Infinity

The AI-native database built for LLM applications, providing incredibly fast hybrid search of dense vector, sparse vector, tensor (multi-vector), and full-text.

Stars4,540

Forks423

Last commit7 days ago