Hacker News new | ask | show | jobs
The Fastest Embedded Database in the World: CrossDB vs. SQLite3 Benchmark (crossdb.org)
4 points by jcwang 1094 days ago
5 comments

i feel compelled to point out that comparing CrossDB with SQLite3 is like comparing apples and oranges. CrossDB is essentially a highly specialized (de)serialization framework for C/C++... and _only_ C/C++. It cannot be extended to work in arbitrary script languages because it requires compile-time mappings of C structs to its database records. That makes it impossible to extend from higher-level languages like scripting engines, C#, Java, etc.

That isn't to say that CrossDB is uninteresting (it is interesting), it's just not _really_ an SQLite competitor because it's only useful in a small fraction of the cases where SQLite is (namely non-C programming languages).

You're right, it's designed for C/C++ at beginning and is not SQL oriented. I plan to develop SQL interface and can be used by many languages. Thanks for the support anyway:)
@OP just FYI: SQLit3 (sic) is misspelled at least 4 times and version 3.31 is ancient history.
Thank you very much, I've corrected the typo. 3.31 is the official library on Ubuntu 20.04 server. I'll do test on new version later.
CrossDB is the Fastest Embedded Database in the world. It's a new RDBMS, optimized for maximum performance. Welcome to do benchmark vs any existing open-source or commercial database.
On your repo, it is Apache-Licensed.

Where's the sources? Will you be releasing source-code version of this?

Can you share some details as to why it’s allegedly so much faster?
It's a new designed RDBMS Arch based on memory map with optimized HASH as the Primary Index and use Native APIs to access with user Struct efficiently. There're lots of optimization methods used to improve performance.