5 ms·

I'm not sure how folks use it, but I think the sweet spot is for simple-to-run relational storage for a smallish set of data. Some people don't use it for the

I'm not sure how folks use it, but I think the sweet spot is for simple-to-run relational storage for a smallish set of data. Some people don't use it for the distribution, but just like a HTTP API in front of SQLite. https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md#why-would-i-use-this-versus-some-other-replicated-database https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md#why-...

thomasmarcelis 5y ago
Thats close to our use case. We use it to sync a small amount of configuration data across a small amount of servers (2-50, depending client). RQlite was perfect as our software is an addon for a legacy platform. We needed an easy low-access way of installing a distributed datastore.
- otoolep 5y ago
  Cool. Did you use read-only nodes, by any chance? https://github.com/rqlite/rqlite/blob/master/DOC/READ_ONLY_NODES.md https://github.com/rqlite/rqlite/blob/master/DOC/READ_ONLY_N...
simonw 5y ago
"I'm not sure how folks use it" Suggestion: have you considered running office hours and inviting your users to chat to you about what they're doing with it? I've been doing that for six months for my Datasette project and I've had over 60 conversations now, it's been a revelation - it almost completely solved the "I don't know how people are using this" problem for me, and gave me a ton of ideas for future directions for the project. I wrote more about that here: https://simonwillison.net/2021/Feb/19/office-hours/ https://simonwillison.net/2021/Feb/19/office-hours/
- otoolep 5y ago
  Interesting! An old colleague of mine, Ben Johnson, also does the same thing for litestream, his latest SQLite replication project. I thought it was just him. Now that I know two folks do it, I'll have to give it serious thought. Thanks for the blog post ref https://github.com/benbjohnson/litestream https://github.com/benbjohnson/litestream
  - simonw 5y ago
    I believe Ben got the idea from me - I was also his first ever office hours appointment once he started :)

thomasmarcelis 5y ago

Thats close to our use case. We use it to sync a small amount of configuration data across a small amount of servers (2-50, depending client). RQlite was perfect as our software is an addon for a legacy platform. We needed an easy low-access way of installing a distributed datastore.

otoolep 5y ago
Cool. Did you use read-only nodes, by any chance? https://github.com/rqlite/rqlite/blob/master/DOC/READ_ONLY_NODES.md https://github.com/rqlite/rqlite/blob/master/DOC/READ_ONLY_N...

simonw 5y ago

"I'm not sure how folks use it" Suggestion: have you considered running office hours and inviting your users to chat to you about what they're doing with it? I've been doing that for six months for my Datasette project and I've had over 60 conversations now, it's been a revelation - it almost completely solved the "I don't know how people are using this" problem for me, and gave me a ton of ideas for future directions for the project. I wrote more about that here: https://simonwillison.net/2021/Feb/19/office-hours/ https://simonwillison.net/2021/Feb/19/office-hours/

otoolep 5y ago
Interesting! An old colleague of mine, Ben Johnson, also does the same thing for litestream, his latest SQLite replication project. I thought it was just him. Now that I know two folks do it, I'll have to give it serious thought. Thanks for the blog post ref https://github.com/benbjohnson/litestream https://github.com/benbjohnson/litestream
- simonw 5y ago
  I believe Ben got the idea from me - I was also his first ever office hours appointment once he started :)