otoolep

17 ms·

211.
by otoolep 4y ago
Actually, they added a unit test in a follow-on change: https://www.sqlite.org/src/info/dc7dd2d3e50e7cc4
212.
by otoolep 4y ago
rqlite[1] author here. To be clear rqlite is using SQLite in a completely conventional manner. Nothing about the distributed nature of rqlite impacts on SQLite, since each rqlite node runs its own complete copy of SQLite. This bug can affec
213.
I found a bug in SQLite(philipotoole.com)
584 points by otoolep 4y ago|157 comments
214.
by otoolep 4y ago
rqlite author here, happy to answer any questions. The rqlite FAQ[1] might be useful to you. [1] https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md
215.
by otoolep 4y ago
Sure, would be happy to consider.
216.
by otoolep 4y ago
No idea.
217.
by otoolep 4y ago
rqlite author here, happy to answer any questions.
218.
by otoolep 4y ago
Many thanks to the team at Replicated[1] -- their feedback and input has made rqlite much better. [1] https://www.replicated.com/
219.
Replacing Postgres with rqlite, the lightweight, distributed DB built on SQLite(philipotoole.com)
12 points by otoolep 4y ago|2 comments
220.
by otoolep 4y ago
rqlite[1] author here, happy to answer any questions about it if it helps. rqlite will give you HA, but won't help with load (rqlite replicates for reliability, not for write performance). But I like to think the it'll give you so
221.
by otoolep 4y ago
A system made of multiple distinct components, while it can be complicated, is not a distributed system. A SoC is not a distributed system. For the system you describe to have the practical challenges of a distributed system it would also n
222.
by otoolep 4y ago
Basically agree, yeah.
223.
by otoolep 4y ago
I've written about the same comparison, but came to a somewhat different conclusion. In my experience Embedded Software development was poor preparation for my later distributed-systems work (I wrote Embedded Software for 10 years, the
224.
by otoolep 4y ago
Congrats to the team at InfluxDB - great to see this released.
225.
by otoolep 4y ago
And benbjohnson wrote the SQL parser[1] rqlite uses to do all this. So you see, the man is everywhere. :-) [1] https://github.com/rqlite/sql
226.
by otoolep 4y ago
Actually rqlite release 7.7.0[1] adds support for RANDOM(). Timestamp functions support will be added to an upcoming release. It does this by statement-rewriting[2] before sending the SQL to the Raft log. [1] https://www.philipot
227.
by otoolep 4y ago
As for rqlite.... see this FAQ entry: https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md#why-...
228.
by otoolep 4y ago
Nope, as explained in my other comment. It is, as you say, built on top of SQLite.
229.
by otoolep 4y ago
rqlite[1] author here. I wouldn't consider rqlite a fork in any sense, just so we're clear. That rqlite uses plain vanilla SQLite is one of its key advantages IMHO. Users have no concerns they're not running real SQLite sourc
230.
by otoolep 4y ago
And good luck with your project, welcome to the distributed SQLite space. :-)
231.
by otoolep 4y ago
Can only speak for rqlite: https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md#why-...
232.
by otoolep 4y ago
Correct. What I meant by the reference to Consul is that rqlite uses the Raft implementation at its center and repurposes for use by rqlite. I can make that clearer.
233.
by otoolep 4y ago
Exactly. Providing write-scalability is big deal, don't get me wrong, and this project looks interesting. The biggest misconception folks have about rqlite is that it increases SQLite write performance, when it's about providing f
234.
by otoolep 4y ago
rqlite author here. There are a couple of statements on that page I disagree with. "mvsqlite is a distributed database, while dqlite and rqlite are replicated databases" I disagree with this statement, and consider its definition
235.
Star Trek made me a bad Engineering Manager(philipotoole.com)
4 points by otoolep 4y ago|0 comments
236.
by otoolep 4y ago
rqlite author here, thanks for the mention, happy to answer any questions.
237.
by otoolep 4y ago
rqlite author here, happy to answer any questions.
238.
by otoolep 4y ago
rqlite creator here, happy to answer any questions about it.
239.
by otoolep 4y ago
Agreed. In the real world actually operating the database is just as important as its intrinsic query functionality.
240.
by otoolep 4y ago
rqlite author here, happy to answer any questions.

More ›