Excited to share Linkmarks – a native #iOS and #macOS app I recently built with #SwiftUI and #TCA! Effortlessly save and organize your web links, with #SQLite for local storage and seamless #iCloud sync across devices. #indiedev #BuildInPublic

Try it out: https://linkmarks.darrarski.pl/

What is the proper setup for installing Drupal on Ubuntu 24.04 LTS? #postgresql #sqlite #drupal

https://askubuntu.com/q/1547669/612

It feels good to finally make a new #release of another #OpenSource C++ library whose maintenance I've inherited: SOCI provides API for accessing different kinds of databases in the same way, see https://soci.sourceforge.net/ for more information and the announcement post (in which I've managed to make a typo, of course...) at
https://sourceforge.net/p/soci/mailman/message/59183493/ for the details about the changes in the latest version.

The #bliki I've been working on now can store file uploads inside #sqlite. The code is horrible and took me more time than I would have liked to. https://git.sr.ht/~puercopop/bliki/commit/05e294ec1604ffb7207ba47e5ce7a7b304427c36

do you have a preferred sqlite3 library? #golang #sqlite

Gmail to SQLite

https://github.com/marcboeker/gmail-to-sqlite

Leanpub book LAUNCH! Northwind Elixir Traders: Learn Elixir and database modeling with Ecto and SQLite, all in one project by Isaak Tsalicoglou https://youtu.be/LtzBS9hb1Go #books #leanpublishing #selfpublishing #booklaunch #ElixirLang #FunctionalProgramming #IndieHacker #Ecto #SQLite #SoftwareDevelopment #OpenSource #FullStackDev #LearnToCode #LeanpubPodcast

AnuDB– Backed on RocksDB, 279x Faster Than SQLite in Parallel Workloads

https://github.com/hash-anu/AnuDB

I've worked quite a bit on internal logic the past weeks and now we can finally unlock support for facetting in #loupe. Your #php and #sqlite only search engine will soon reach yet another level https://github.com/loupe-php/loupe/pull/184

What I really liked about RealmDB is the ability to subscribe to DB change.

Whats the best way to replicate this with Swift Concurrency? AsyncStream + SQLite Triggers?
#sqlite #swift #iosdev #macosdev

oh boy, `spatialite` doesn't use a geographic index? You need to do this complicated nested queries to use it?

Maybe I need to switch to #postgis
#sqlite #gis #spatialite

A faster way to copy SQLite databases between computers

https://alexwlchan.net/2025/copying-sqlite-databases/

DB-Engines Ranking climbers of the month:

#PostgreSQL

#Snowflake

#SQLite

https://db-engines.com/en/ranking

@risottobias

What may be interesting is to look at https://data-star.dev, a #hypermedia library (that blows #htmx out of the water), with a back-end in #golang that can potentially replace an entire typical Rube Goldberg front-end stack, depending on the use case.

The maintainers have very interesting talks on YT to highlight the innovative approach, which involve #SSE. The maintainer uses a bootstrap that by default has #SQLite (and #NATS, which recently announced relicensing to #BUSL).

Thank you!
In #SQLite: LIKE is case-insensitive by default for ASCII characters (like normal English letters A–Z).

tinysparql (https://tracker.gnome.org/) as an rdf foundation to #localfirst ... i'd watch a whole talk on that. this feels like a fun way to get away from the pain shoehorning sync engines into sql dbs.