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.
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
UUID or cached sequences?
franckpachot profile

UUID or cached sequences?

#database #postgres #sql #yugabytedb
16
Comments
7 min read
SQL Injection 101
yongdev profile

SQL Injection 101

#sql #security #php #server
14
Comments 3
5 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
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
How many rows would have been there without that LIMIT clause?
dspsolves profile

How many rows would have been there without that LIMIT clause?

#database #sql #mysql #postgres
12
Comments
6 min read
Understanding Data and Databases 101
alexmercedcoder profile

Understanding Data and Databases 101

#sql #cql #database
6
Comments
4 min read
JSON + MariaDB: How Hybrid Data Models Allow You to Have Your Cake and Eat It Too
probablyrealrob profile

JSON + MariaDB: How Hybrid Data Models Allow You to Have Your Cake and Eat It Too

#mariadb #json #sql #rdbms
11
Comments
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.