Console’s review
· Reviewed by David Mytton
What we like
Designed for very fast data analysis, particularly where whole tables or large joins are involved. Simple to operate - no dependencies and nothing to install because it runs in the host process, thereby increasing performance. Supports complex SQL queries. Fast loading of data from CSV, Parquet, Postgres, SQLite, read/write data from S3.
Tradeoffs
Not designed for high volume transactional queries or where the database needs to be written to from multiple processes.