4 ms·
Related: https://duckdb.org/ https://duckdb.org/ It's OLAP, not OLTP like SQLite.
by iagovar 6y ago
Related: https://duckdb.org/ https://duckdb.org/
It's OLAP, not OLTP like SQLite.
- jolux 6y agoDoes OLAP vs OLTP describe a real technological difference or just a description of the use cases a specific tool is trying to address?
- gigatexal 6y agoGenerally OLAP databases are columnar or otherwise optimized for batch and aggregations.
- pm90 6y agoYes it does describe a technological difference. Specifically, the kind of tasks that they are good for. My very crude shorthand is that olap == optimized for time series (usually column oriented) and oltp == optimized for transactional processing (row oriented).
- CharlesW 6y agoThe "description of the uses cases" answer can also be a reasonable shorthand for databases which support both, which allows the DBA to optimize on a table-by-table (and even column-by-column) basis.
- Hahalolomg 6y agoAre you guys % sure about downloading? It said for me haha you now have a virus and then it logged me out of my phone for 6 minutes, I was like why did they do that. Please do not download this GitHub app!!!
- runningmike 6y ago...
- Hahalolomg 6y agoHi
- brandmeyer 6y agoIf a table is constructed WITHOUT ROWID, then its spatial locality will reflect the consecutive order implied by the primary key. Range-delimited queries are extremely fast. In effect, SQLite already is both an OLTP and OLAP database.
- sanxiyn 6y agoAs you pointed out, SQLite does implement clustered index, but it is not columnar.