I love Rust and I love SQLite, so you can guess. Iwas pretty excited when I lerned that "SQLite was rewritten in Rust" What is SQLite, actually? 2 things: a

A SQLite extension that adds graph database capabilities with Cypher query language support and built-in graph algorithms. - colliery-io/graphqlite: A SQLite extension that adds graph database ca...

A blog mostly about Clojure programming

SQLite Graph Extension. Contribute to agentflare-ai/sqlite-graph development by creating an account on GitHub.

Since June 2023, I’ve been running a service written in Ruby (Sinatra) that provides several Bluesky custom feeds (initially built with a feed for the iOS/Mac developers community in mind, later expanded to many other feeds). If you don’t know much about Bluesky feeds, you make them by basically running a server which somehow collects and picks existing posts from Bluesky using some kind of algorithm (chronological or by popularity, based on keyword matching, personal likes, whatever you want), and then exposes a specific API endpoint. The Bluesky AppView (API server) then calls your service passing some request parameters, and your service responds with a list of URIs of posts (which the API server then turns into full post JSON and returns to the client app). This lets you share such feed with anyone on the platform, so they can add it to their app and use it like any built-in feed. (If you’re interested, check out my example feed service project.)

This post was originally given as a talk for Friendly.rb. The slides are also available. Between Litestack and the Rails 8 trifecta of Solid Cable, Solid Cache, and Solid Queue, it’s easier than ever to spin up a Rails app that doesn’t need a database service, or a redis service, or a file storage service. It’s great to simplify things, but even after 20 years of deploying Rails apps I was still caught out by some of the ways things are different.

A TUI SQLite Viewer and Editor . Contribute to driscollis/squall development by creating an account on GitHub.

Base is the SQLite database editor Mac users love. Designed for everyone, with a comfortable interface that makes database work so much nicer.

Nithin Bekal's blog about programming - Ruby, Rails, Vim, Elixir.

We’re launching the first alpha of Turso. A Rust-based, cloud-native rewrite of SQLite with modern concurrency, async APIs, vector search, and unmatched reliability powered by advanced testing and open-source collaboration.

PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite

Dumping a SQLite database to a text file can make it much smaller, which means you can download it faster.

LiveStore is a next-generation state management framework based on reactive SQLite and built-in sync engine. - livestorejs/livestore

LiveStore is a state management framework based on SQLite and event-sourcing. It’s designed for demanding applications and based on years of research.

LiveStore is a next-generation state management framework based on reactive SQLite and built-in sync engine. - livestorejs/livestore

Bringing in what we learned from LiteFS

This post walks through backing up a SQLite database inside a Docker container on a remote server, specifically for a Ruby on Rails application deployed with Kamal. We'll begin with the basic commands, then convert them into a reusable shell script and a Rake task for convenience.

Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them. - QuadrupleA/sqlite-page-explorer

An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in some situations. By the way, the talk about the system that made me me to explore SQLite in anger can now be seen here. Normally it is your Ruby (or Python, or Go, or whatever) program which calls SQLite to make it “do stuff”. Most calls will be mapped to a native call like sqlite3_exec() which will do “SQLite things” and return you a result, converted into data structures accessible to your runtime. But there is another possible direction here - SQLite can actually call your code instead.

A free, open source, multi-platform SQLite database manager. - pawelsalawa/sqlitestudio

Unlock the full potential of your SQLite databases with our latest blog! Learn advanced techniques for query tuning, index optimization, and database design improvements to ensure faster and more efficient data handling. Dive into practical examples and enhance your database performance today!

SQLite works great as an in-app database but can require some configuration to achieve optimal performance. This post covers 10 SQLite optimizations that can help maintain blazingly fast performance.

Some of the interesting and insane facts I learned about SQLite

Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite. - tursodatabase/limbo

Sensible SQLite defaults