Re:Dqlite – High-Availability SQLite
by usgroup on Friday August 30, 2019 @04:58AM
(#20836896)
I'm not brimming with ideas of where this would be a good fit tbh. Is anyone using it or considering it for anything?
[ Parent
| on HN ]
It's sort of like a SQL version of etcd, so maybe some of the use cases for etcd would be similar: https://github.com/etcd-io/etcd/blob/master/Documentation/pr...
Re:Dqlite – High-Availability SQLite
by Quarrelsome on Friday August 30, 2019 @09:29AM
(#20838368)
anywhere where you cba to run up a full database server and don't necessarily mind losing a few features.
Historically sqlite has been THE solution for data storage in embedded (think IOT), so in this case imagine an IOT configuration with multiple nodes.
So an easy use-case that springs to mind is any sort of distributed IOT device that need to track state. So any industrial or consumer monitoring system with a centralised controller that would use this for data storage. Specifically, that this enables the use of multiple nodes for high throughput imagine many, many, many sensors and a central controller streaming real-time data.
Depending on some details, it would be perfect for storing state for a libvirt cluster management tool I'm working on. Concerns are I can read the data on disk using the regular sqlite3 cli tool, and lack of rust bindings.
Re:Dqlite – High-Availability SQLite
by regularfry on Friday August 30, 2019 @07:45AM
(#20837618)
8 years ago or so I was involved in building a cloud platform. The very first version of the design for keeping the VM and storage allocation metadata synced across the cluster involved syncing sqlite databases (which we moved off once we realised we'd pretty much have to invent something a lot like raft to make it work). If this had existed then, we'd just have picked it off the shelf.
Re:Dqlite – High-Availability SQLite
by reacharavindh on Friday August 30, 2019 @02:53PM
(#20841464)
I’m curious about the libvirt management tool ypu’re Working on. Any chance it is open source?