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.
Parsing Data with Just SQL

Parsing Data with Just SQL

5
Comments
7 min read
Intro

Intro

4
Comments 4
1 min read
Redis helps avoiding racing conditions

Redis helps avoiding racing conditions

10
Comments
5 min read
Indexes | SQL

Indexes | SQL

4
Comments
5 min read
SQL JOIN IN SQL

SQL JOIN IN SQL

6
Comments
1 min read
Brace yourself: Using BigQuery as an operational backend

Brace yourself: Using BigQuery as an operational backend

13
Comments 2
4 min read
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

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 ?

How prepared statement prevent SQL Injection ?

5
Comments
1 min read
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 15: Deleting records from a table

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

7
Comments
2 min read
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
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.

Create Nested Tree View with Only One Query.

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

How I created a mini ORM with python?

6
Comments
4 min read
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

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

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
loading...