Looked at #sqlite full text search today, stuffing it full of markdown. Would like to have a minimalist search engine as companion to a static site generator. My search for one resulted in such relevant hits as "you can use google".

Found another TUI for your sysadmin toolbox

**jdbrowser** — A terminal SQLite database browser.

Supports displaying tables, copying to clipboard & more!

Written in Rust & built with @ratatui_rs

GitHub: https://github.com/Jkeyuk/JDbrowser

Test Postgres in Python Like SQLite : A #Python testing library that provides seamless integration between PGlite and Python test suites. Get the full power of PostgreSQL in your tests without the overhead of a full PostgreSQL installation.

https://github.com/wey-gu/py-pglite

#Roundcube 1.5.10 (#LTS) has been released (#Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #LongTermSupport) https://roundcube.net/

#Roundcube 1.6.11 (stable) has been released (#Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL) https://roundcube.net/

I want to make my partner a simple database (~3 tables, i think), because I think that's the "right" thing to use (as opposed to excel / google sheets). But, I've never had to create a database thingy before.

Seeing this as an opportunity to learn some #DuckDB or #SQLite.

Seeking #recommendations for a simple (GUI) interface for interacting with the tables.

#LibreOffice Base or something else?

#suggestions welcome
#database #db #help

I'm looking for people to try out a new version of Base, my SQLite editor for macOS.

If you'd like to give it a go, send me a private message with your email address (only used for TestFlight, no junk).

Boosts appreciated.

First post might as well be my pinned post! A link to my web projects and a blog, which is mostly about webdev and gaming.

https://scott.itsasite.uk

I discovered Mastodon though editing my profile on Itch.io lol. Now I can fill in that field, yay xD.

What's the NoSQL equivalent of SQLite?

I realize MongoDB is webscale, but I'm after something small and local and embeddable.

Heya lovely people
For #SciOp we (@SafeguardingResearch) are looking for dev contributions. There are a couple of bite-/morsel-sized tasks, e.g.:
- Make Publisher independent table https://codeberg.org/Safeguarding/sciop/issues/341
- Improve SearchableMixin to support full text search on joined items https://codeberg.org/Safeguarding/sciop/issues/182
- and more: https://codeberg.org/Safeguarding/sciop/projects/17078

The stack is #python (fastapi) + htmx, #sqlite (sqlmodel), "low-fi, standards-compliant html and almost no js"

Be a part of #SafeguardingResearch, join us!

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

GitHub - splitbrain/meh: Meh... another comment system https://github.com/splitbrain/meh #alternative #integration #OpenSource #comments #mastodon #node.js #website #GitHub #sqlite #static #blog #PHP

How-To Geek: How I Track My Music Collection With an Easy SQLite Database. “If you’re a music fan, you probably have shelves of records or CDs. How do you keep track of them? You could use a database, but aren’t they complicated to set up? SQLite is a powerful tool that lets you set up SQL databases without a server. It’s surprisingly easy to set up. Here’s how I did it, despite having a […]

https://rbfirehose.com/2025/03/17/how-to-geek-how-i-track-my-music-collection-with-an-easy-sqlite-database/

#SQLite was designed as an #TCL extension. There are ~trillion SQLite databases in active use. SQLite heavily relies on #TCL: C code generation via mksqlite3c.tcl, C code isn't edited directly by the SQLite developers, and for testing , and for doc generation). The devs use a custom editor written in Tcl/Tk called "e" to edit the source! There's a custom versioning system Fossil, a custom chat-room written in Tcl/Tk!

https://www.tcl-lang.org/community/tcl2017/assets/talk93/Paper.html

PersistDict

A persistent dictionary implementation backed by an #LMDB database. PersistDict looks and acts like a #Python dictionary but persists data to disk, making it ideal for caching and persistent storage needs.

PersistDict makes it simple to add persistent caching to any Python application. While earlier versions (before 2.0.0) used #SQLite, the current version leverages LMDB for better performance and reliability in concurrent environments.

https://pypi.org/project/PersistDict/

He ampliado algunos puntos de mi curso de SQL.
https://programadorwebvalencia.com/cursos/sql/
Todo feedback es bien recibido.
#sql #sqlite #anuncio

Go and Rust for the Small Web: How We Build Faster, Simpler Apps

https://limeleaf.coop/blog/webdev-tech/

brb, throwing the entire company's observability into a couple of #sqlite https://boyter.org/posts/searchcode-bigger-sqlite-than-you/ (mind the stack shrinkage and simplification over the years)

#Development #Launches
SQL Noir · A game to learn SQL by solving crimes https://ilo.im/162ciw

_____
#OpenSource #Game #Database #SQL #MySQL #SQLite #PostgreSQL #Npm #WebDev #Backend

A nice tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them:

https://github.com/QuadrupleA/sqlite-page-explorer