Philip O'Toole

@Duderichy @Drk8_ rqlite creator here, happy to answer any questions.

@Drk8_ What’s your review?

How to pick a DB: Do you need users and multiple thread access? yes -> postgres no -> sqlite

@DeBrosOfficial Tip: always run the most recent release!

@general_order24 thank you sir. we experimented with several others but rqlite does the job. You have done excellent work with it we believe. Any tips?

Massive updates at DeBros Network—we're shipping decentralized primitives daily: IPFS storage, rqlite DB, Olric caching, built-in DNS, libp2p P2P bus, and TS SDK + HTTP gateway (Web2 feel, Web3 power). Not “AWS 2.0”—we're redefining dev with default decentralization & privacy. Mission: Seamlessly onboard millions of Web2 devs to Web3. Coming soon: Rebrand, docs, tutorials. Jump in—the future's easy. Stay tuned! debros.network

@uthman_dev @pipe_dev rqlite creator here, happy to answer any questions.

@pipe_dev Damn this is impressive.

@GoTotus @_devJNS rqlite creator here, happy to answer any questions!

@_devJNS Rqlite (and others)

what database do you use?

rqlite, the distributed database built on SQLite. 9.0 released - major upgrade. rqlite now supports Change Data Capture, allowing you to stream database changes to other systems #sqlite #golang #distributedsystems philipotoole.com/rqlite-9-0-rea…

New blog post on how rqlite handles the CAP Theorem. philipotoole.com/consistency-ov…

rqlite, the lightweight distributed database build on SQLite, now supporting automatic backup-and-restore to Google Cloud Storage. Improved Disaster Recovery options. philipotoole.com/rqlite-gcs-bac…

rqlite turns 10 this summer. philipotoole.com/rqlite-turns-1…

@DidierDemoniere @catalinmpit People have already done it. philipotoole.com/replicated-pos…

@catalinmpit That’s crazy, i was there like last week and ended up fitting to a real backend framework (feathersjs) inside the fullstack one (solid start). it feel so great I’m considering moving from Postgres to rqlite. Am I crazy ?

Separating the backend from the frontend isn't worth it. NextJS frustrated me so much that I didn't want to hear about it ever again. So, I built the backend for my course app separate from the frontend to get away from NextJS. It was a mistake! My backend isn't very complex, and a full-stack web framework like React Router 7 or TanStack Start would have handled it perfectly. Separating the two just to use JavaScript on the backend didn't make sense either. In the future, I'll stick to a full-stack web framework and only consider a separate backend if the app becomes very complex.

@AdrianHesketh Nice. Have you got any more details on how you used rqlite?

The talk demos building a self hosted retrieval augmented generation tool using Ollama (written in Go), rqlite (Go) and sql_vec. Ollama and rqlite build on top of llamacpp and SQLite respectively. The frontend uses templ with @htmx for its brilliant SSE support. No custom JS.

Thanks for having me!

Faster Reads, Same Guarantees: adding Linearizable Reads to rqlite, the lightweight distributed database built on #sqlite @golang #distributedsystems philipotoole.com/faster-reads-s…

Now you can insert BLOB data directly as byte arrays, through the API, using parameterized queries. #blob-data" target="_blank" rel="nofollow noopener">rqlite.io/docs/api/api/#…

rqlite -- the lightweight, user-friendly distributed database built on #SQLite, Raft consensus and @golang -- rqlite 8.31 is out now with improved support for BLOB data. rqlite.io philipotoole.com/rqlite-8-31-0-…

Great video by @stephenlb on rqlite -- the lightweight distributed database built on #SQLite. youtube.com/watch?v=vI7flZ…

rqlite -- the lightweight, user-friendly distributed database built on @golang , Raft consensus, and SQLite -- release 8.29 is out now with more baked-in SQLite extensions, and even easier Extension management. github.com/rqlite/rqlite/…

rqlite -- the lightweight, user-friendly distributed database built on SQLite -- release8.28: Enhanced Docker Support for Seamless SQLite Extension Loading philipotoole.com/rqlite-828-enh…

Spin up a highly-available Vector Search engine in seconds with the latest rqlite Docker image! Loading sqlite-vec is now super-easy at Docker launch. Thanks @agarcia_me #docker" target="_blank" rel="nofollow noopener">rqlite.io/docs/guides/ex…

@agarcia_me Thanks! Yeah, I'm a big believer in trying to remove every piece of possible end-user-friction from the software I write.

SQLite extensions, including sqlite-vec, are now supported in rqlite! (I like how you can just pass in a zip or tar.gz file instead of unpacking it manually)

rqlite now supports loadable SQLite extensions - check out release 8.27, and the demo of rqlite running sqlean from @ohmypy and sqlite-vec from @agarcia_me . philipotoole.com/rqlite-8-27-lo…