3 ms·
SQLite fits one generic model, and is a row level data store. DuckDB is a column store, and other DBs are designed to operate for specific use cases. This is op
by samwillis 4y ago
SQLite fits one generic model, and is a row level data store. DuckDB is a column store, and other DBs are designed to operate for specific use cases. This is open to all options.
The point is that SQLite is a brilliant genetic option, but should not be the only option. WASM and OPFS is the right route forward to enable application developers to use the best data store architecture for their use case.
Even within SQLite there are extension that would never have been an available to WebSQL that with this design are.
- treis 4y agoBut we have 0 options now and 1 is better than 0.