June 13, 2026
#Database
March 5, 2026
9 Advanced PostgreSQL Features I Wish I Knew Sooner
GENERATED columns, EXCLUDE constraints, DISTINCT ON, Foreign Data Wrappers… PostgreSQL has powerful features you might not know about. Here are my favorites.
SQL Window Functions and PARTITION BY in Practice
Sharing our experience with window functions in a recent client project involving historical data management
January 19, 2026
VizSQL - Visualize SQLite Schemas Instantly Online
Drop your .sqlite file to generate interactive ER diagrams. No login, 100% private, runs entirely in your browser.
Not sure about security here, although it states it runs entirely in your browser. Wish there’s a selfhosted alternative instead.
November 19, 2025
Velld Database Backup
A database backup management and automation tool.
November 14, 2025
PocketBase vs. TrailBase
Comparing TrailBase & PocketBase.
October 4, 2025
September 20, 2025
Visual DB — Web front end for your database
Visual DB empowers business users to create data entry forms, sheets and reports using a drag-and-drop interface.
VisualDB positions itself as an Airtable alternative, but with more. I need to find time to explore its features.
August 25, 2025
Pocketbase n8n node
This is a n8n community node. It lets you use PocketBase in your n8n workflows.
PocketBase is an open source backend consisting of embedded database (SQLite) with realtime subscriptions, built-in auth management, convenient dashboard UI and simple REST-ish API.
March 3, 2025
Docker DB Backup
Backup multiple database types on a scheduled basis with many customizable options.
Stumbled upon this when checking out Flarum. Perhaps I can use this to several of my MySQL/MariaDB and Postgres containers.