Browsing Tag
sql
92 posts
Dear Developer: Your Database Isn’t a File Cabinet!
Hey guys! I’m an Engineering Manager, and I’m sharing some notes deep from the development trenches. I wanted…
Versioning Your Database with SQLAlchemy and Alembic: From Models to Safe Migrations
SQLAlchemy and Alembic give you a safer, more controlled way to evolve your schema over time. In the…
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic The useful question…
Similarities Between a Stored Procedure in SQL and a Function in Python
Both SQL stored procedures and Python functions are powerful tools used to automate tasks, structure code, and enhance…
Mastering Postgres Window Functions for Data Analysis in Supabase
Postgres window functions are a powerful SQL feature that lets you perform calculations across rows related to the…
Beyond Functional: Writing Professional and Performant SQL Queries
Structured Query Language (SQL) is one of the most widely used languages for interacting with databases, yet even…
Essential Adjacent References
Data analysis often involves cross-row calculations, such as Link Relative Ratio (LRR), Year-over-Year (YoY) and moving averages. Implementing…
How to Design a PostgreSQL Schema Visually (Step-by-Step)
1. What is a Schema? In PostgreSQL, a schema is just a folder inside your database where you…
Vectors in AI: A Bridge Between Code and Business
Vectors in AI: A Bridge Between Code and Business Note from the series “About AI for Yourself and…
Become a SQL Scientist: Explore Every Layer of Table Metadata in SQL Server
Become a SQL Scientist: Explore Every Layer of Table Metadata in SQL Server “If you want to master…
