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.
Getting Started with SQL: The Language of Data
doreen_jerotich_0c02c93c8 profile

Getting Started with SQL: The Language of Data

#programming #data #sql
1
Comments
3 min read
Clean SQL with Comments: Syntax and Practices for All Engines
dbvismarketing profile

Clean SQL with Comments: Syntax and Practices for All Engines

#sql
Comments
1 min read
Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs
cristiansifuentes profile

Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

#sql #database #backend #dataengineering
Comments
3 min read
Optimizing SQL queries for your AI Agents.
sten profile

Optimizing SQL queries for your AI Agents.

#ai #sql #python #database
2
Comments
4 min read
Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK
cristiansifuentes profile

Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

#sql #database #backend #dataengineering
Comments
2 min read
Taxi Drivers Efficiency Analysis with SQL & Tableau
omeiza_mayaki profile

Taxi Drivers Efficiency Analysis with SQL & Tableau

#sql #tableau #data #bigquery
2
Comments
3 min read
Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery
cristiansifuentes profile

Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

#database #sql #backend #dataengineering
Comments
2 min read
DB_DEVELOPER_ROLE Role in Oracle Database 23ai
vahidusefzadeh profile

DB_DEVELOPER_ROLE Role in Oracle Database 23ai

#oracle #database #linux #sql
Comments
3 min read
Slow SQL? Diagnose & Fix Bottlenecks Fast!
jing_li profile
Jing for Chat2DB

Slow SQL? Diagnose & Fix Bottlenecks Fast!

#mysql #database #sql #postgres
Comments
6 min read
ORM vs ODM: What's the Difference and When to Use Them?
himanshudevgupta profile

ORM vs ODM: What's the Difference and When to Use Them?

#programming #sql #mongodb #tutorial
6
Comments
1 min read
10 SQL Anti-Patterns You Must Avoid in Production
cristiansifuentes profile

10 SQL Anti-Patterns You Must Avoid in Production

#sql #database #performance #advancedsql
1
Comments
2 min read
Integration testing tRPC and in memory MySQL database.
pietro_palmesi_b8b68ba0f6 profile

Integration testing tRPC and in memory MySQL database.

#t3 #nextjs #vitest #sql
1
Comments
5 min read
Which LLM writes the best SQL?
tbperegrine profile

Which LLM writes the best SQL?

#ai #analytics #database #sql
Comments
10 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26
judith677 profile

Create Columns from Distinct Values of a Column — From SQL to SPL #26

#programming #esprocspl #database #sql
6
Comments 1
1 min read
What’s a database anyway?? A blog post for kids
dave_macleod_c21bf713723a profile

What’s a database anyway?? A blog post for kids

#database #children #sql #programming
Comments
14 min read
What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective
op3ratordec profile

What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

#sql #postgres #database #productivity
5
Comments
5 min read
Substring from a Column of Strings — From SQL to SPL #25
judith677 profile

Substring from a Column of Strings — From SQL to SPL #25

#programming #database #sql #esprocspl
5
Comments 1
2 min read
Oracle Object List - Demo 00:58
abhilash8 profile

Oracle Object List - Demo

#oracle #oci #plsql #sql
Comments
1 min read
NoSQL vs. SQL: Which One to Use
turalsuleymani profile

NoSQL vs. SQL: Which One to Use

#nosql #sql #volume #velocity
Comments
3 min read
Behind the Query: The Secret Life of Database Indexes
umangmittal profile

Behind the Query: The Secret Life of Database Indexes

#database #mongodb #sql #performance
Comments
8 min read
How to install PostgreSQL on macOS: Step-by-Step Instructions
saif_uddin profile

How to install PostgreSQL on macOS: Step-by-Step Instructions

#sql #postgressql #programming #database
Comments
1 min read
DuckDB: When You Don’t Need Spark (But Still Need SQL)
konstantinas_mamonas profile

DuckDB: When You Don’t Need Spark (But Still Need SQL)

#database #sql #productivity #programming
Comments
2 min read
Oracle 23ai — Read-Only User Feature
vahidusefzadeh profile

Oracle 23ai — Read-Only User Feature

#oracle #sql #linux #database
Comments
2 min read
Open-source Node.js blogging engine with newsletter functionality
maxim-fin profile

Open-source Node.js blogging engine with newsletter functionality

#webdev #node #javascript #sql
1
Comments
1 min read
DuckDB 1.20 Released! Exploring the New Features
nk_maker profile

DuckDB 1.20 Released! Exploring the New Features

#duckdb #sql #csv
Comments
4 min read
loading...