Hacker News Reader

This. If you’re looking for something portable, DuckDB is hard to beat. It’s pretty much the SQLite for analytics.

I’ve had good experience with ClickHouse, too, but it feels a bit more like Postgres rather than SQLite in terms of portability.

Take a look at chDB and clickhouse-local. Clickhouse can do a lot even without running it as a server.

Thanks for this...I'd never heard of DuckDB.

I'm writing in PHP, so it looks like that's a nonstarter for now, but _very_ interested to see if a PHP extension pops up for this in the future.

There was a great talk[0] recently from Laravel core team member about ClickHouse, Probably you will enjoy watching it.

You should look at ClickHouse which has good PHP client

afaiu appending to parquet files is not cheap, you basically have to re-write the file.

Do you mean periodically flushing a queue of logs into a new parquet file (e.g. named with a timestamp)?