Re:SQL.js: SQLite Compiled to JavaScript
by bob1029 on Friday November 06, 2020 @05:12PM
(#25011656)
What if SSDs just had an alternative interface that talked SQL? Presumably you could bake SQLite into the microcontroller and optimize perfectly for the storage scenario. Having your journaling aware of how long your supercapacitor will last in the worst case could open the door for some wild optimizations.
[ Parent
| on HN ]
Re:SQL.js: SQLite Compiled to JavaScript
by wtallis on Friday November 06, 2020 @05:47PM
(#25011863)
There have been some projects to develop SSDs that natively present a key-value storage interface, and standardization of that is pretty far along. So those drives can function as a backend for eg. a RocksDB substitute with a minimal software frontend.
But a full SQL database engine on the SSD would fall under the umbrella of computational storage, and so far everyone with the resources to put any of that into production has datasets that don't fit on a single drive. So there's less utility in having the drive speaking proper SQL, but a lot of active research into how to usefully offload some of the DB work onto compute resources that reside on the SSD itself.
(Also, microcontroller is a bit odd to use to refer to the main controller chip inside a SSD, especially a high-end enterprise SSD. It gives a completely misleading indication of scale.)
Re:SQL.js: SQLite Compiled to JavaScript
by bob1029 on Friday November 06, 2020 @06:18PM
(#25012053)
I do remember reading about Samsung making some of these types of drives. Key-value is a pretty powerful foundation for any sort of database.
https://www.anandtech.com/show/14839/samsung-announces-stand...
Re:SQL.js: SQLite Compiled to JavaScript
by slaymaker1907 on Saturday November 07, 2020 @12:48AM
(#25013416)
Key/value is already kind of used by SSDs anyway since they use virtual addressing.