3 ms·
> SQLite [...] assumes a POSIX filesystem that would have to be emulated. No it does not. It has a pluggable storage interface that makes no such assumption: h
by cafxx 6y ago
> SQLite [...] assumes a POSIX filesystem that would have to be emulated.
No it does not. It has a pluggable storage interface that makes no such assumption: https://www.sqlite.org/vfs.html https://www.sqlite.org/vfs.html
- scribu 6y agoIndeed: > test_onefile.c - This file implements a demonstration VFS named "fs" that shows how SQLite can be used on an embedded device that lacks a filesystem.
- earthboundkid 6y agoCame here to say that SQLite for WASM already exists. Odd to just assume it’d be impossible.
- carry_bit 6y agoAbout a couple years ago I used sql.js [1] in an internal tool to provide the user the ability to execute SQL queries against the data they had loaded. It worked just fine. [1] https://github.com/sql-js/sql.js https://github.com/sql-js/sql.js
- EuAndreh 6y agoThanks for the correction, I've amended the text. https://euandre.org/2020/08/31/the-database-i-wish-i-had.html#fn:posix-sqlite https://euandre.org/2020/08/31/the-database-i-wish-i-had.htm...