3 ms·
What would be your choice?
by adamnemecek 5y ago
What would be your choice?
- einpoklum 5y agoIf you don't do any joins, Clikhouse is worth a try. Otherwise, MonetDB (or even MonetDB embedded) if you want FOSS. Commercial offerings - Actian Vector, or maybe HyperDB. The big corporate ones are probably pretty good, but it's always difficult to tell because there's this taboo on any proper benchmarking against them. If you just want to browse what other people are using, and not go by the recommendations of a random commenter, try: https://db-engines.com/en/ranking https://db-engines.com/en/ranking but note that's a joint ranking both for transaction-focused and analytics-focused DBMSes. If it's time series data there are some more specialized offerings and I'm (even) less of an expert there.
- einpoklum 5y agoAh, I forgot a newer option: DuckDB. It self-styles as "SQLite for analytics"... https://duckdb.org/ https://duckdb.org/