Complete guide to multi-tenancy database patterns
Multi-tenancy is a fundamental architectural pattern for SaaS applications, allowing multiple customers (tenants) to share the same application infrastructure while maintaining data isolation.
Complete security guide - data at rest, in transit, at runtime
When data is the a valuable asset, securing it has never been more critical. From the moment information is created to the point it’s discarded, its journey is fraught with risks - whether stored, transferred, or actively used.
Quick reference to postgresql
A quick reference for day‑to‑day PostgreSQL work: connections, SQL syntax, psql meta-commands, performance, JSON, window functions, and more.
A practical, code-heavy look on ORMs in GO
Most prominent ORMs for GO are GORM, Ent, Bun and sqlc. Here is a little comparison of them with examples of CRUD operations in pure GO.
Choosing best tool to write selects and do backups
New Linux Ubuntu 24.04 desktop edition has offered me to install Beekeeper Studio as SQL Editor and DB Manager tool. I was previously using DBeaver. OK. Let’s Compare DBeaver with Beekeeper Studio.
With the release of new pg driver AutoMigrate is throwing errors...
In my new Go project that was using GORM I started getting error:
pq: got 2 parameters but the statement requires 1
Free database management tool in Linux and Windows
DBeaver is a universal database management tool and SQL client designed for developers, database administrators, analysts, and anyone who works with data professionally.
GORM vs sqlc vs Ent vs Bun
Go’s ecosystem offers a range of ORM (Object-Relational Mapping) tools and database libraries, each with its own philosophy. Here is a comprehensive comparison of four major solutions for using PostgreSQL in Go: GORM, sqlc, Ent, and Bun.
Essential SQL commands and operations
Here’s a concise SQL cheatsheet covering the most essential commands and operations:
