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.
♻️🐘 Disposable local Postgres databases (without containers!)
monacoremo profile

♻️🐘 Disposable local Postgres databases (without containers!)

#showdev #sql #postgres #database
23
Comments
6 min read
Writing SQL for humans with Literate SQL
monacoremo profile

Writing SQL for humans with Literate SQL

#showdev #sql #database #postgres
46
Comments 4
7 min read
Programming Paradigm
matheusgomes062 profile

Programming Paradigm

#todayilearned #computerscience #sql #javascript
86
Comments 9
4 min read
Hierarchical JSON with SQLite / RediSQL
siscia_ profile

Hierarchical JSON with SQLite / RediSQL

#json #sqlite #redis #sql
9
Comments
4 min read
Remove duplicates rows with SQL
michelc profile

Remove duplicates rows with SQL

#sql #snippet
10
Comments
1 min read
Popular SQL interview question met in practice
rodiongork profile

Popular SQL interview question met in practice

#sql #interview #optimization #tutorial
10
Comments 1
3 min read
Paradigmas de Programação
matheusgomes062 profile

Paradigmas de Programação

#todayilearned #computerscience #sql #javascript
19
Comments 3
4 min read
SQL Indexes 101
ielgohary profile

SQL Indexes 101

#sql #database
20
Comments
3 min read
Multiple SQL Inserts and Transactions with Objection Js
eperedo profile

Multiple SQL Inserts and Transactions with Objection Js

#javascript #node #database #sql
12
Comments
4 min read
PostgreSQL Pro Tip: Beware of BETWEEN
billbabeaux profile

PostgreSQL Pro Tip: Beware of BETWEEN

#sql #postgres #database
12
Comments 2
1 min read
8 New SQL Tools That Will Change How You Work in 2020
realtrevorfaux profile

8 New SQL Tools That Will Change How You Work in 2020

#sql #productivity #postgres #database
163
Comments 7
6 min read
Would you like to have better XML support in SQL Server?
peledzohar profile

Would you like to have better XML support in SQL Server?

#sql #database #sqlserver
5
Comments
1 min read
SQL: Timestamps
wendisha profile

SQL: Timestamps

#mysql #postgres #timestamp #sql
41
Comments 4
2 min read
Why is My SQL Server Query So Slow
rionmonster profile

Why is My SQL Server Query So Slow

#sql #troubleshooting #debugging #performance
13
Comments 1
6 min read
Building Dynamic React Apps with Database Data
jerodimusprime profile

Building Dynamic React Apps with Database Data

#react #sql #webdev #database
23
Comments
9 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.