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.
#Database
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
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.
January 28, 2025
SQLook - SQLite Database Viewer and Generator
SQLook - A free online SQLite database manager with visual query builder. Create, view, and query SQLite databases directly in your browser. Features include visual table generation, sample data population, query assistance, and database visualization.
SQLook is a powerful web-based SQLite database manager that runs entirely in your browser. No installation or server required - just open your SQLite databases and start working with them immediately.
September 9, 2024
Adminer SQLite
Use adminer with a local sqlite database. Contribute to fluidblue/adminer-sqlite development by creating an account on GitHub.
This lets you connect Adminer to SQLite database.