canonical/dqlite on Hacker News

…ocs/faq/#does-rqlite-support-transactions [1] https://github.com/letsdiscodev/python-dqlite-dbapi [2] https://github.com/canonical/dqlite/issues/882 opened by my friend, https://github.com/canonical/dqlite/issues/908 ,…

comment by gregsadetsky · 2026-10-24 · in Twelve years of distributed SQLite

Have you tried https://github.com/canonical/dqlite/pull/909 ?

comment by gregsadetsky · 2026-10-24 · in Twelve years of distributed SQLite

Loads of '500 database locked' errors. https://github.com/canonical/dqlite/issues/908

comment by esafak · 2026-10-24 · in Twelve years of distributed SQLite

…that still seem to be actively maintained, although I've only used rqlite myself before: - https://github.com/canonical/dqlite - https://github.com/rqlite/rqlite - https://github.com/Expensify/Bedrock

comment by capableweb · 2023-09-22 · in I'm all-in on server-side SQLite (2022)

…* https://github.com/rqlite/rqlite <-- more of a "distributed database using RAFT" type of thing * https://github.com/canonical/dqlite

comment by justinclift · 2023-05-11 · in Ask HN: It's 2023, how do you choose between MySQL and Postgres?

I'd be curious for a similar tuning with Dqlite: https://github.com/canonical/dqlite

comment by withinboredom · 2023-04-13 · in SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s

…than litefs). [0]: https://github.com/superfly/litefs [1]: https://github.com/rqlite/rqlite [2]: https://github.com/canonical/dqlite

comment by tekacs · 2022-09-10 · in Transcending Posix: The End of an Era?

I presume you're familiar with https://github.com/canonical/dqlite (made by my employer) and https://github.com/rqlite/rqlite (unrelated)? How will mvsqlite compare to those?

comment by benhoyt · 2022-08-16 · in SQLite is not a toy database (2021)

How about dqlite? https://github.com/canonical/dqlite

comment by e19293001 · 2022-05-17 · in Ask HN: Free and open source distributed database written in C++ or C

https://github.com/rqlite/rqlite https://github.com/canonical/dqlite

comment by thegeekpirate · 2021-12-13 · in The Session Extension

There already exists some distributed SQLite: https://github.com/canonical/dqlite https://github.com/rqlite/rqlite https://github.com/Expensify/Bedrock https://datacadamia.com/dit/kafka/connector/sqlite_distribut...

comment by xet7 · 2021-11-15 · in Durable Objects now Generally Available

…that should be scaling vertically instead of horizontally). Anyway here's some cool SQLite stuff: - https://github.com/CanonicalLtd/dqlite - https://github.com/rqlite/rqlite - https://datasette.readthedocs.io/en/stable/ -…

comment by hardwaresofton · 2021-04-15 · in SQLite the only database you will ever need in most cases

…just the wire protocol from dqlite to make a network connected, but not Raft replicated, sqlite. https://github.com/canonical/dqlite

comment by tyingq · 2021-03-25 · in SQLite is not a toy database

…like you can now distribute SQLite at the: Stmt level: https://github.com/rqlite/rqlite VFS Level: https://github.com/canonical/dqlite Block Level: https://github.com/benbjohnson/litestream Really cool enhancements to an awesome project!

comment by mech422 · 2021-01-22 · in Rqlite: The lightweight, distributed relational database built on SQLite

Dqlite replicates at the VFS layer of sqlite, which sounds like what you're looking for. https://github.com/canonical/dqlite

comment by tyingq · 2021-01-22 · in Rqlite: The lightweight, distributed relational database built on SQLite

…embeddable and replicated SQL database engine with high-availability and automatic failover." [1] https://github.com/canonical/dqlite

comment by fasteo · 2021-01-22 · in Rqlite: The lightweight, distributed relational database built on SQLite

Dqlite might be interesting to look at. They used the Sqlite VFS to front their raft cluster backend. https://github.com/canonical/dqlite

comment by tyingq · 2021-01-20 · in Serverless SQLite

I wonder if dqlite ( https://github.com/canonical/dqlite ) or rqlite ( https://github.com/rqlite/rqlite ) are enough to help prevent this.

comment by arminiusreturns · 2020-01-20 · in How to Corrupt a SQLite Database File

…dqlite and rqlite exist. There are also previous threads discussing them but here's one[1]. [0]: https://github.com/CanonicalLtd/dqlite [1]: https://news.ycombinator.com/item?id=20836331

comment by hardwaresofton · 2019-10-05 · in Sqlite 3.30.0

Interesting nugget about golang from their FAQ: https://github.com/canonical/dqlite/blob/master/doc/faq.md Why C? The first prototype implementation of dqlite was in Go, leveraging the hashicorp/raft implementation of the Raft algorithm.…

comment by bb88 · 2019-08-30 · in Dqlite – High-Availability SQLite

https://github.com/canonical/dqlite/blob/master/doc/faq.md#a... http://man7.org/linux/man-pages/man2/io_submit.2.html

comment by brennebeck · 2019-08-30 · in Dqlite – High-Availability SQLite

Based on the following header file, it would seem that they are using this unsupported module. https://github.com/canonical/dqlite/blob/master/src/vfs.h

comment by rockwotj · 2019-08-30 · in Dqlite – High-Availability SQLite

…"surely they didn't just remove this information" but didn't look hard enough at all. Direct link: https://github.com/canonical/dqlite/blob/master/doc/faq.md#h...

comment by hardwaresofton · 2019-08-30 · in Dqlite – High-Availability SQLite

> dqlite is/was WAL frame-based...maybe this isn't the case any more According to https://github.com/canonical/dqlite/blob/master/doc/faq.md this is still the case.

comment by rlpb · 2019-08-30 · in Dqlite – High-Availability SQLite

…[1]: https://webcache.googleusercontent.com/search?q=cache:p1XBgh... [2]: https://github.com/canonical/dqlite/commit/35ea7cd56e93a36c5...

comment by hardwaresofton · 2019-08-30 · in Dqlite – High-Availability SQLite

https://github.com/canonical/dqlite/blob/master/doc/faq.md#w...

comment by free-ekanayaka · 2019-08-30 · in Dqlite – High-Availability SQLite

…half, but we released v1.0.0 just yesterday. I added answers to your other questions to the FAQ: https://github.com/canonical/dqlite/blob/master/doc/faq.md#w... https://github.com/canonical/dqlite/blob/master/doc/faq.md#w...…

comment by free-ekanayaka · 2019-08-30 · in Dqlite – High-Availability SQLite

…(e.g. you can use time()) - Frame-based replication instead of statement-based replication [1] https://github.com/canonical/dqlite/blob/master/doc/faq.md

comment by duiker101 · 2019-08-30 · in Dqlite – High-Availability SQLite

I was reading through the docs and this FAQ is worth checking out: https://github.com/canonical/dqlite/blob/master/doc/faq.md In includes an answer about the difference with rqlite. To me reading the docs it seems like dqlite has been…

comment by Scorpiion · 2019-08-30 · in Dqlite – High-Availability SQLite

…a good match for the stated purpose of k3s. https://github.com/lxc/lxd/blob/master/doc/database.md https://github.com/CanonicalLtd/dqlite

comment by tyingq · 2019-02-27 · in K3s – Lightweight Kubernetes

It exists: https://github.com/CanonicalLtd/dqlite

comment by captn3m0 · 2018-08-16 · in SQLite – The “server-process-edition” branch