Browsing Tag
sql
88 posts
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…
SQL Server Stored Procedure Design for Flexible Record Lookup
Using CTEs and JSON to Support Multiple Matching Strategies When working with data I often run into situations…
Best Oracle Database Design Tools in 2025
When you’re looking for a database design tool, it’s not just for fun – you actually need one!…
MySQL vs MongoDB – Visual Design with Real Data Models
When you’re starting learning databases, one of the first questions is: What are the differences between MySQL and…
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)
This guide covers a range of commonly used commands for interacting with and managing your PostgreSQL databases, from…
