I learned what I can say about SQLite and UnQLite, but there are a few more things that I haven't answered yet. UnQLite seems to have been released over the past few years, which explains the lack of benchmarks. "Performance" (read / write speed, query, average database size to a significant slowdown, etc.). There may be several apples with oranges.
Of all that I have seen, they have very few differences relative to the words, namely that SQLite is a relational database, and UnQLite is a key and document database (via Jx9). They are both portable, cross-platform and 32/64-bit, and can have unidirectional and multi-channel connections. Very little can be found in UnQLite tests, while SQLite has quite a few different implementations in different languages (scripts). SQLite has several different characteristics in in-memory databases , indexed data, and read / write modes with different data sizes . In general, SQLite looks fast and reliable.
Everything I can find on UnQLite is unreliable and confusing . I can't seem to find anything useful. What read / write speeds do UnQLite seem to peak at? What languages are recommended when using UnQLite? What are some known flaws and errors?
If this helps explain my intrigue at all, I am developing a network utility that will read and process hot-swappable packets between network interfaces. Since connections can, although unlikely, reach speeds of up to 1 Gbit / s, a lot of raw data will be written to the database. It is still in the early stages of development, and I need to find a way to balance performance. There are many factors, such as missing packages, how large each record size is, how fast it can process and move data, how much an organization needs, how many tables are needed, if I can implement multiprocessing, how much they depend on each other, the database is on hard drives etc. etc. My data will require tables,but whether to keep them as relational is still in the air. Seeing how they add up with their pros and cons (besides the usual discussions on KVP vs Relational), can push me to one or, if I'm crazy enough, a combination of both