Browsing Tag
sql
93 posts
MySQL & MindsDB Unlocks Intelligent Content Discovery For Web CMS with Knowledge Bases and Cursor
Written by Chandre Van Der Westhuizen, Community & Marketing Co-ordinator at MindsDB Content teams run on data —…
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…