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.
Postgres on a Budget: 3 Free Solutions You Should Know
engroso profile

Postgres on a Budget: 3 Free Solutions You Should Know

#database #postgres #sql #mysql
2
Comments
2 min read
Outer Join Optimization: Proven Performance Gains
rebooter_s profile

Outer Join Optimization: Proven Performance Gains

#sql #database #nl2sql #programming
Comments
5 min read
A Survey of SQL Equivalence Verification Methods
rebooter_s profile

A Survey of SQL Equivalence Verification Methods

#sql #database #ai #llm
Comments 1
4 min read
Demystifying SQL Indexes: A Beginner-to-Advanced Guide with Real-Life Examples
rupinder_kaur_6730d267d5f profile

Demystifying SQL Indexes: A Beginner-to-Advanced Guide with Real-Life Examples

#sql #performance #beginners #database
2
Comments
3 min read
SQL ORDER BY: Quick Sorting Examples and Tips
dbvismarketing profile

SQL ORDER BY: Quick Sorting Examples and Tips

#sql #mysql
Comments 1
2 min read
"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing
devmatsu profile

"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing

#sql #index #performance
Comments
2 min read
How to Configure MariaDB 🦦 SSL Connection 🔌
op3ratordec profile

How to Configure MariaDB 🦦 SSL Connection 🔌

#ssl #mariadb #database #sql
12
Comments 1
4 min read
Postgres SQL FILTER: A Smarter CASE and CTE Alternative
mayallo profile

Postgres SQL FILTER: A Smarter CASE and CTE Alternative

#postgres #sql #database
21
Comments 4
5 min read
How to Use JSONB in PostgreSQL
roxana_haidiner profile

How to Use JSONB in PostgreSQL

#postgres #sql #json #postgressql
7
Comments 4
4 min read
How to Get the Raw SQL Query from Laravel Query Builder
ankitvermaonline profile

How to Get the Raw SQL Query from Laravel Query Builder

#laravel #sql #php #beginners
1
Comments
1 min read
🧠 "It Wasn’t the Code That Broke—It Was the Database" How to Design Scalable Databases That Grow with Your App
okoye_ndidiamaka_5e3b7d30 profile

🧠 "It Wasn’t the Code That Broke—It Was the Database" How to Design Scalable Databases That Grow with Your App

#databasedesign #webdev #sql #nosql
2
Comments
3 min read
Amazon Aurora DSQL is GA
vijaykodam profile

Amazon Aurora DSQL is GA

#aws #sql #distributedsystems #database
Comments
1 min read
Design Better Databases - Best Practices
roxana_haidiner profile

Design Better Databases - Best Practices

#database #sql #design #datastructures
17
Comments 1
8 min read
Mastering SQL Join Queries: HR Worker Data Analysis
jemmyasjd profile

Mastering SQL Join Queries: HR Worker Data Analysis

#sql #dbms #database #tutorial
Comments
10 min read
Mastering SQL Basic : (Part : 1)
jemmyasjd profile

Mastering SQL Basic : (Part : 1)

#sql #database #tutorial #beginners
Comments
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.