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.
Why uber ditched postgres for mysql: What every developer can learn from it
dev_tips profile

Why uber ditched postgres for mysql: What every developer can learn from it

#webdev #programming #postgres #sql
2
Comments
46 min read
The Five Levels Of SQL
mendy_kevin_94ec1db73e1df profile

The Five Levels Of SQL

#sql #data #database #postgres
2
Comments 3
3 min read
Oracle AI Database 26ai — Read-Only User Feature
vahidusefzadeh profile

Oracle AI Database 26ai — Read-Only User Feature

#oracle #sql #linux #database
Comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
judith677 profile

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl
5
Comments 1
2 min read
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.