DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
ForgeSQL: one diagram, real SQL, real Docker
thiago_rosadasilva_0688 profile

ForgeSQL: one diagram, real SQL, real Docker

#showdev #database #docker #sql
Comments
1 min read
SQL Cheatsheet
krutidb profile

SQL Cheatsheet

#sql #cheatsheet #beginners #interview
1
Comments
2 min read
Star Schema vs. Snowflake Schema: When to Use Each
alexmercedcoder profile

Star Schema vs. Snowflake Schema: When to Use Each

#architecture #database #dataengineering #sql
Comments
4 min read
SQLite as a Vector Database — Yes, Really
zrcic profile
Zrcic

SQLite as a Vector Database — Yes, Really

#ai #database #rag #sql
1
Comments
7 min read
🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)
githinji_victormaina_627 profile

🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)

#sql #database #datascience #beginners
2
Comments 1
3 min read
Introducing the (experimental!) Stainless SQL SDK generator
cjav_dev profile

Introducing the (experimental!) Stainless SQL SDK generator

#sql #webdev #openai #database
Comments
6 min read
The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know
datatechbridge profile

The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know

#dataengineering #learning #sql #tutorial
1
Comments
40 min read
COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere
baldwin_apps profile

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

#sql #database #programming #dataengineering
Comments
2 min read
SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It
wangeci_ndovu profile

SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It

#beginners #database #sql #tutorial
1
Comments
3 min read
Real world considerations: MS-SQL vs PostgreSQL vs MySQL
marko_mgi_b8a9b2bc90838b profile

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

#sql #mysql #postgres
2
Comments
12 min read
SQLite as an MCP context saver: stop cramming raw API data into your LLM
richardbaxter profile

SQLite as an MCP context saver: stop cramming raw API data into your LLM

#ai #mcp #sql
40
Comments 7
9 min read
PostgreSQL global statistics on partitionned table require a manual ANALYZE
franckpachot profile

PostgreSQL global statistics on partitionned table require a manual ANALYZE

#postgres #sql #database #partitioning
6
Comments
8 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”
sonia_bobrik_1939cdddd79d profile

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre
Comments
6 min read
Why SQL Makes You Stand Ahead of Most Candidates
tanushreep profile

Why SQL Makes You Stand Ahead of Most Candidates

#sql #analytics #database #datascience
Comments
2 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely
mickelsamuel profile

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend
3
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.