4 ms·
Where can you use SQLite? Embedded Systems: Yes Raspberry Pi : Yes Mobile Apps. : Yes Desktop Apps : Yes Browsers : No Servers :
by me551ah 6y ago
Where can you use SQLite?
Embedded Systems: Yes
Raspberry Pi : Yes
Mobile Apps. : Yes
Desktop Apps : Yes
Browsers : No
Servers : Yes
Supercomputers : Yes
- mcpherrinm 6y agoWebSQL was an attempt at supporting sqlite in the browser. Now, you can use it via wasm!
- tehbeard 6y agoNo it was an attempt at supporting SQL in the browser. It fell through because everyone choose SQLite as the implementation, and having one implementation means it's quirks would be enshrined as the standard. Really speaks to SQLite's quality that major vendors would just reach for it without considering making their own.
- bouk 6y agoBrowsers: yes https://github.com/sql-js/sql.js https://github.com/sql-js/sql.js
- me551ah 6y agoIt's a sqlite browser port which doesn't persist data. I think that's kind of essential for a database.
- lsb 6y agoSure it does! You can `POST` the buffer that backs the database to your favorite blob store, and read it back when you're done. You can write to it as much as you like when the page is active.
- zubairq 6y agoYou can actually partially persist data on the client side in SQLite, as you can embed the data in you html, which is exactly what we do with our product
- goto11 6y agoThere was an attempt to add SQLite to browsers at some point, but it was abandoned because we would never get two independent implementations. https://www.w3.org/TR/webdatabase/ https://www.w3.org/TR/webdatabase/
- wayneftw 6y agoYou can thank Mozilla and Microsoft for that. They had the swing votes on that issue - https://nolanlawson.com/2014/04/26/web-sql-database-in-memoriam/ https://nolanlawson.com/2014/04/26/web-sql-database-in-memor...
- me551ah 6y agoThat was a brilliant read!