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.
Performant script in updating a large table🚀
jimmyyeung profile

Performant script in updating a large table🚀

#django #database #sql #productivity
10
Comments
3 min read
Databases: Important Theoretical Concepts
fahidlatheef profile

Databases: Important Theoretical Concepts

#sql #postgres #database
16
Comments
4 min read
10 Ways to optimise your Database queries
ktnl profile

10 Ways to optimise your Database queries

#sql #postgres #database
24
Comments 2
7 min read
SQL Injection 101
yongdev profile

SQL Injection 101

#sql #security #php #server
14
Comments 3
5 min read
UUID or cached sequences?
franckpachot profile

UUID or cached sequences?

#database #postgres #sql #yugabytedb
16
Comments
7 min read
I'm building a modern spreadsheet
stephensisk profile

I'm building a modern spreadsheet

#showdev #sql #tooling #spreadsheet
7
Comments 1
9 min read
Querying SQL Databases Declaratively [Video]
alejandro_du profile

Querying SQL Databases Declaratively [Video]

#java #jakartaee #sql #vaadin
1
Comments
4 min read
Index Only Scan on Functional Indexes
franckpachot profile

Index Only Scan on Functional Indexes

#postgres #sql #database
20
Comments 2
4 min read
A kind of flashback query in PostgreSQL
franckpachot profile

A kind of flashback query in PostgreSQL

#postgres #database #sql
13
Comments
3 min read
How immutable data can benefit your data-driven application.
cassidymountjoy profile

How immutable data can benefit your data-driven application.

#database #sql #blockchain #security
15
Comments
2 min read
Beware the Performance Dangers of MySQL Views
jamiemcmanus profile

Beware the Performance Dangers of MySQL Views

#mysql #sql #database
21
Comments 1
4 min read
How To Use SQL Subqueries
rettx profile

How To Use SQL Subqueries

#guide #beginners #sql
8
Comments
3 min read
usql on YugabyteDB
franckpachot profile

usql on YugabyteDB

#yugabytedb #sql #database
2
Comments
4 min read
ORM's x Query Builder's x Raw SQL
pedrocardoz0 profile

ORM's x Query Builder's x Raw SQL

#discuss #beginners #database #sql
16
Comments
6 min read
Entenda como nossa base de Diretórios Brasileiros facilita sua vida
crislane profile

Entenda como nossa base de Diretórios Brasileiros facilita sua vida

#database #datascience #sql #braziliandevs
7
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.