Category
Databases
Choosing and using databases: PostgreSQL, MySQL and SQLite, serverless options like Neon and Turso, ORMs such as Prisma and Drizzle, GUI clients and migrations.
-
Apr 23, 2026
Why Use Spreadsheets as a Database? A Technical Deep Dive into ‘Flat-File’ Data
When a spreadsheet works as a database: quick prototypes and internal tools, the spreadsheet-as-backend architecture, and its real limits.
-
Apr 23, 2026
The Best Open Source BI Tools for Postgres: A Developer’s Guide to Data Visualization
Open-source BI tools for PostgreSQL: Metabase, Superset, Grafana and Redash compared, how to connect them safely, and which one to choose.
-
Apr 23, 2026
How to Connect PostgreSQL to Google Sheets Automatically: A Complete Guide
Sync PostgreSQL to Google Sheets automatically: no-code connectors, Google Apps Script and Python with the Sheets API, plus security tips.
-
Apr 23, 2026
Using DuckDB for Business Intelligence: A Deep Dive into In-Process Analytics
Use DuckDB for business intelligence: in-process analytics on Parquet and CSV, fast queries without a warehouse, and where it reaches its limits.
-
Apr 23, 2026
Grist vs Airtable Comparison: Which Relational Spreadsheet Wins for Developers?
Grist vs Airtable for developers: open-source, Python formulas and self-hosting against a polished SaaS. Features, pricing and limits.
-
Apr 23, 2026
Baserow vs Airtable for Developers: Open Source Freedom or Polished Ecosystem?
Baserow vs Airtable for developers: open-source self-hosting and API freedom against Airtable's polished ecosystem. Features and pricing.