3 ms·
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
by bob1029 6y ago
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.
- wtallis 6y agoThere 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.)
- bob1029 6y agoI 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.snia.org/keyvalue https://www.snia.org/keyvalue https://www.anandtech.com/show/14839/samsung-announces-standardscompliant-keyvalue-ssd-prototype https://www.anandtech.com/show/14839/samsung-announces-stand...
- slaymaker1907 6y agoKey/value is already kind of used by SSDs anyway since they use virtual addressing.