Re:SQLite as a Document Database
by pupdogg on Friday November 27, 2020 @02:49PM
(#25232012)
LiteStore looks fantastic! Do you have any performance metrics (specifically limits) for the various use cases you mention in the documentation? Considering it's written in Nim, I wouldn't be surprised if it actually outperformed bulk of the other documentDB solutions that currently exist out there.
[ Parent
| on HN ]
Not published unfortunately but I should, really!
In the past I tested importing dumps of the full HTML and CSS documentation docset from MDN and: - Importing files in a directory is relatively fast: I import batches and it can import hundreds of pages in a few seconds - sadly there's no bulk operation yet to insert arbitrary json documents (unless they are stored as files in a folder), so that's quite slow. - full text search and querying indexed (JSON) properties is fast (double-digit milliseconds for searching several hundred of relatively large documents with paged results)
I do need to do some compared benchmarks with similar data stores though.
Re:SQLite as a Document Database
by throwaway888abc on Saturday November 28, 2020 @12:09AM
(#25235451)
Just discovered from parent. Great project! Thank you