News for hackers. Stuff that matters.
Re:DuckDB: Querying JSON files as if they were tables by nkh on Friday March 03, 2023 @02:20PM (#35013830)
DuckDB is "column oriented" vs "row oriented". I have found it 10x* faster for queries on data your size compared to SQLite or MySQL or Postgres. The added advantage of it being a single file is very nice as well.

*I use the HoneySQL (clojure) library to programmatically build up queries and execute them via the JDBC driver.

There are no comments on this comment yet.