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.
Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)
franckpachot profile

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

#postgres #json #sql #mongodb
3
Comments
5 min read
SQL: The Secret Weapon Behind Data Analytics and Data Science
joseph_hinga_mwangi profile

SQL: The Secret Weapon Behind Data Analytics and Data Science

#datascience #database #sql
4
Comments 3
4 min read
Connect Any Postgres to Real-Time Analytics
tigerdata_dev profile

Connect Any Postgres to Real-Time Analytics

#postgres #datascience #performance #sql
1
Comments
7 min read
What's New in MySQL 9 🧐 - a DBA's Perspective đŸ„ž
op3ratordec profile

What's New in MySQL 9 🧐 - a DBA's Perspective đŸ„ž

#mysql #database #sql #tooling
8
Comments
9 min read
Best 7 Logical Database Design Tools in 2025
roxana_haidiner profile

Best 7 Logical Database Design Tools in 2025

#database #sql #productivity #architecture
10
Comments 2
5 min read
PostgreSQL aborts the transactions on error
franckpachot profile

PostgreSQL aborts the transactions on error

#postgres #sql #database #savepoint
2
Comments
3 min read
SQL Tutorial Made Easy: From Basics to Advanced Queries
tpointtech profile

SQL Tutorial Made Easy: From Basics to Advanced Queries

#programming #beginners #tutorial #sql
1
Comments
3 min read
# PostgreSQL Tutorial: What Really Happens When You Add and Drop Columns 2000 Times in PostgreSQL
mangesh28 profile

# PostgreSQL Tutorial: What Really Happens When You Add and Drop Columns 2000 Times in PostgreSQL

#opensource #postgres #sql
6
Comments 2
2 min read
Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story
mattluo profile

Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story

#typescript #database #sql #webdev
1
Comments
7 min read
Node.js uchun ORM tanlaymiz!
zayniddindev profile

Node.js uchun ORM tanlaymiz!

#orm #node #sql
14
Comments 6
2 min read
Introduction to SQL Using PostreSQL
lucy_joan_b56ae069a2a9f17 profile

Introduction to SQL Using PostreSQL

#sql #database #datascience #devops
4
Comments
9 min read
Oracle AI Database 26ai : Group By and Having using Column Aliases
vahidusefzadeh profile

Oracle AI Database 26ai : Group By and Having using Column Aliases

#oracle26ai #data #sql #programming
Comments
2 min read
Text-to-SQL: A Developer’s Zero-to-Hero Guide
tigerdata_dev profile

Text-to-SQL: A Developer’s Zero-to-Hero Guide

#sql #postgres #nlp #ai
7
Comments
9 min read
Get the Records after and before the Searched One — From SQL to SPL #18
judith677 profile

Get the Records after and before the Searched One — From SQL to SPL #18

#programming #sql #esprocspl #dataengineering
7
Comments 2
2 min read
I am Learning SQL(mysql) in 2025.
tahir_rafique profile

I am Learning SQL(mysql) in 2025.

#learning #sql #sqlserver #database
4
Comments 2
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.