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.
Avoiding Hard Coding and Magic Strings in code and databases

Avoiding Hard Coding and Magic Strings in code and databases

38
Comments 1
3 min read
Exterminate! 🤖 (or Destroying Associated Records in Rails)

Exterminate! 🤖 (or Destroying Associated Records in Rails)

25
Comments 5
4 min read
The best free courses to learn about Databases and SQL for Beginners

The best free courses to learn about Databases and SQL for Beginners

38
Comments
4 min read
♻️🐘 Disposable local Postgres databases (without containers!)

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

24
Comments
6 min read
Writing SQL for humans with Literate SQL

Writing SQL for humans with Literate SQL

46
Comments 4
7 min read
Programming Paradigm

Programming Paradigm

86
Comments 9
4 min read
Hierarchical JSON with SQLite / RediSQL

Hierarchical JSON with SQLite / RediSQL

9
Comments
4 min read
Remove duplicates rows with SQL

Remove duplicates rows with SQL

10
Comments
1 min read
Popular SQL interview question met in practice

Popular SQL interview question met in practice

10
Comments 1
3 min read
Paradigmas de Programação

Paradigmas de Programação

19
Comments 3
4 min read
SQL Indexes 101

SQL Indexes 101

20
Comments
3 min read
Multiple SQL Inserts and Transactions with Objection Js

Multiple SQL Inserts and Transactions with Objection Js

12
Comments
4 min read
PostgreSQL Pro Tip: Beware of BETWEEN

PostgreSQL Pro Tip: Beware of BETWEEN

12
Comments 2
1 min read
8 New SQL Tools That Will Change How You Work in 2020

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

163
Comments 7
6 min read
Would you like to have better XML support in SQL Server?

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

5
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.