Tag: sqlite
-
OLAP Databases
Oct 5, 2020
Recently, I came across a new embedded analytics database, DuckDB which I found inspired from two of my favorite ones SQLite and ClickHouse. DuckDB looked very interesting since I find that it fill...
-
SQLite: WAL Mode
Oct 5, 2020
From SQLite v3.7.0, write-ahead logging (WAL) mode is available which has the following advantages: It is significantly faster. It enables more concurrency as readers don't block writers and vice...
-
DuckDB: Query SQLite and PostgreSQL Data
Oct 4, 2020
DuckDB can query data stored in SQLite and PostgreSQL using SQLiteScanner and PostgresScanner respectively. DuckDB claims reads via DuckDB client will be faster than reads via their respective data...
-
SQLite: Index Recommendations
Oct 4, 2020
For databases, most of the read performance depends on indexing. SQLite has expert command which recommends the appropriate index creation based on the query.