I've tried SQLite for this usecase but the query falls down when querying millions of rows.
I know there is parquet file format but I'm wondering if there is like a SQL engine that can sit on top of something like that similar to SQLite
I've tried SQLite for this usecase but the query falls down when querying millions of rows.
I know there is parquet file format but I'm wondering if there is like a SQL engine that can sit on top of something like that similar to SQLite