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
Cover image for JDBC Tutorial Part 2: Running SQL Queries

JDBC Tutorial Part 2: Running SQL Queries

9
Comments
6 min read
SQL vs NoSQL Database – A Complete Comparison
Cover image for SQL vs NoSQL Database – A Complete Comparison

SQL vs NoSQL Database – A Complete Comparison

16
Comments
8 min read
100 Days of Learning - Day 6

100 Days of Learning - Day 6

2
Comments
2 min read
How prepared statement prevent SQL Injection ?
Cover image for How prepared statement prevent SQL Injection ?

How prepared statement prevent SQL Injection ?

5
Comments
1 min read
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right
Cover image for Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right

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

10
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table
Cover image for Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table

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

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table
Cover image for Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table

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

7
Comments
2 min read
Import database to docker with terminal
Cover image for Import database to docker with terminal

Import database to docker with terminal

5
Comments
2 min read
Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

7
Comments
10 min read
Scaling Token Buckets Rate limiting with YugabyteDB

Scaling Token Buckets Rate limiting with YugabyteDB

7
Comments
7 min read
Create Nested Tree View with Only One Query.
Cover image for Create Nested Tree View with Only One Query.

Create Nested Tree View with Only One Query.

7
Comments
2 min read
How I created a mini ORM with python?
Cover image for How I created a mini ORM with python?

How I created a mini ORM with python?

6
Comments 1
4 min read
Improving performance with SQL aggregate functions
Cover image for Improving performance with SQL aggregate functions

Improving performance with SQL aggregate functions

7
Comments
7 min read
MySQL/MariaDB character sets and collations explained – why utf8 is not UTF-8
Cover image for MySQL/MariaDB character sets and collations explained – why utf8 is not UTF-8

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

11
Comments 2
6 min read
YugabyteDB JDBC Smart Driver for proxyless HA/LB

YugabyteDB JDBC Smart Driver for proxyless HA/LB

7
Comments
18 min read
Please How can I convert the following object oriented PDO fetch_assoc to MYsqli Format below.

Please How can I convert the following object oriented PDO fetch_assoc to MYsqli Format below.

2
Comments
1 min read
PostgreSQL Bitmap Scan with GIN indexes on Array or Secondary Table with Index Only Scan

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

8
Comments
4 min read
JDBC Tutorial Part 1: Connecting to a Database
Cover image for JDBC Tutorial Part 1: Connecting to a Database

JDBC Tutorial Part 1: Connecting to a Database

9
Comments
7 min read
Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

9
Comments 1
7 min read
SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

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

8
Comments 2
5 min read
What are the top 9 SQL Queries for freshers?

What are the top 9 SQL Queries for freshers?

5
Comments 1
2 min read
Importing Large SQL File

Importing Large SQL File

4
Comments
2 min read
MySQL- RDBMS
Cover image for MySQL- RDBMS

MySQL- RDBMS

6
Comments
3 min read
100 Languages Speedrun: Episode 39: SQLite

100 Languages Speedrun: Episode 39: SQLite

7
Comments
8 min read
🦸 Become a Super Hero by Learning SQL!

🦸 Become a Super Hero by Learning SQL!

7
Comments
4 min read
loading...