Hacker News Reader

Comment by otoolep | Hacker News Reader

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-...

View on HN

"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/

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

I believe Ben got the idea from me - I was also his first ever office hours appointment once he started :)

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.

Cool. Did you use read-only nodes, by any chance?

https://github.com/rqlite/rqlite/blob/master/DOC/READ_ONLY_N...

Reply on news.ycombinator.com