Re:DuckDB: Querying JSON files as if they were tables
by sidpatil on Friday March 03, 2023 @01:47PM
(#35013493)
> Using DuckDB or SQLite's CSV/JSON support gets you the best of both worlds (minus indices)
DuckDB automatically creates indexes for all general-purpose columns. However, they're not persisted.
For a dataset that size, I'd probably use SQLite to avoid having to manage a persistent MySQL process, especially when it's being used as an alternative to CSV files. That is, unless there's a MySQL/Postgres server already running I can just create a new database on.