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.
JDBC Tutorial Part 2: Running SQL Queries
alejandro_du profile

JDBC Tutorial Part 2: Running SQL Queries

#java #sql #database #beginners
9
Comments
6 min read
SQL vs NoSQL Database – A Complete Comparison
backendless profile

SQL vs NoSQL Database – A Complete Comparison

#sql #database #architecture #mongodb
16
Comments
8 min read
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right
ifierygod profile

Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right

#sql #learning #database #programming
10
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table
ifierygod profile

Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table

#sql #learning #database #programming
7
Comments
2 min read
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table
ifierygod profile

Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table

#sql #beginners #database #programming
7
Comments
3 min read
Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL
franckpachot profile

Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

#postgres #sql #database #serializable
7
Comments
10 min read
Scaling Token Buckets Rate limiting with YugabyteDB
franckpachot profile

Scaling Token Buckets Rate limiting with YugabyteDB

#yugabytedb #sql #distributed #database
7
Comments
7 min read
YugabyteDB JDBC Smart Driver for proxyless HA/LB
franckpachot profile

YugabyteDB JDBC Smart Driver for proxyless HA/LB

#yugabytedb #distributed #sql #database
7
Comments
18 min read
MySQL/MariaDB character sets and collations explained – why utf8 is not UTF-8
flokoe profile

MySQL/MariaDB character sets and collations explained – why utf8 is not UTF-8

#database #sql #devops #mysql
11
Comments 2
6 min read
PostgreSQL Bitmap Scan with GIN indexes on Array or Secondary Table with Index Only Scan
franckpachot profile

PostgreSQL Bitmap Scan with GIN indexes on Array or Secondary Table with Index Only Scan

#postgres #sql #database #array
8
Comments
4 min read
JDBC Tutorial Part 1: Connecting to a Database
alejandro_du profile

JDBC Tutorial Part 1: Connecting to a Database

#java #sql #programming #database
9
Comments
7 min read
Rate limiting with PostgreSQL / YugabyteDB (token buckets function)
franckpachot profile

Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

#yugabytedb #sql #distributed #postgres
9
Comments 1
7 min read
SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀
franckpachot profile

SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

#postgres #yugabytedb #sql #database
8
Comments 2
5 min read
100 Languages Speedrun: Episode 39: SQLite
taw profile

100 Languages Speedrun: Episode 39: SQLite

#sql #sqlite
7
Comments
8 min read
🦸 Become a Super Hero by Learning SQL!
mistval profile

🦸 Become a Super Hero by Learning SQL!

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