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.
Como a SQL lida com valores NULL

Como a SQL lida com valores NULL

2
Comments
1 min read
Maintain a duplicate covering index in a region

Maintain a duplicate covering index in a region

7
Comments
7 min read
A Bit of Advanced ActiveRecord Querying - With Benchmarks

A Bit of Advanced ActiveRecord Querying - With Benchmarks

19
Comments 2
9 min read
SQL Basics (Zero to Hero)- Part 01

SQL Basics (Zero to Hero)- Part 01

11
Comments 1
3 min read
8 Great Data Engineering Youtube Channels

8 Great Data Engineering Youtube Channels

24
Comments
6 min read
Quick 📊 on 🐘 active SQL from pg_stat_activity

Quick 📊 on 🐘 active SQL from pg_stat_activity

15
Comments
5 min read
Apache ShardingSphere 5.0.0: Upgraded Federation Execution Engine

Apache ShardingSphere 5.0.0: Upgraded Federation Execution Engine

6
Comments
4 min read
Using Materialize and Redpanda to Analyze Raspberry Pi Temperature Data

Using Materialize and Redpanda to Analyze Raspberry Pi Temperature Data

11
Comments
6 min read
PostgreSQL lock trees

PostgreSQL lock trees

8
Comments
6 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

11
Comments 2
4 min read
JDBC Tutorial Part 2: Running SQL Queries

JDBC Tutorial Part 2: Running SQL Queries

8
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 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

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

7
Comments
2 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

7
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
What are the top 9 SQL Queries for freshers?

What are the top 9 SQL Queries for freshers?

5
Comments 1
2 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
Importing Large SQL File

Importing Large SQL File

4
Comments
2 min read
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
String Operations On Phone Numbers In SQL

String Operations On Phone Numbers In SQL

11
Comments
7 min read
Simple overview of MySQL (Relational Database)

Simple overview of MySQL (Relational Database)

9
Comments
2 min read
TEMPLATE: Relational Data And Custom Codeless APIs (App Blueprint)

TEMPLATE: Relational Data And Custom Codeless APIs (App Blueprint)

2
Comments
6 min read
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

6
Comments
3 min read
Airbyte: Data Integration / CDC Solution for Modern Data Teams!

Airbyte: Data Integration / CDC Solution for Modern Data Teams!

6
Comments
12 min read
🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

5
Comments 2
15 min read
Using Constants in PostgreSQL queries

Using Constants in PostgreSQL queries

2
Comments
2 min read
Data structures in SQL: the definitive guide

Data structures in SQL: the definitive guide

16
Comments
7 min read
How to read / make sense this multiple JOINS SQL query properly?

How to read / make sense this multiple JOINS SQL query properly?

3
Comments 1
1 min read
How to write SQL recursive CTE in 5 steps

How to write SQL recursive CTE in 5 steps

55
Comments 8
7 min read
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

7
Comments
3 min read
Creating Tables and Associations using Ruby/Active Record/Rake

Creating Tables and Associations using Ruby/Active Record/Rake

6
Comments
5 min read
Fun times with MySQL upgrade

Fun times with MySQL upgrade

4
Comments
5 min read
Getting started with Redshift

Getting started with Redshift

10
Comments
5 min read
My week three experience as an intern at TaskForce4.0

My week three experience as an intern at TaskForce4.0

4
Comments
2 min read
SQL Basics Tutorial for Beginners (Practice SQL Queries)

SQL Basics Tutorial for Beginners (Practice SQL Queries)

3
Comments 1
1 min read
Seven URL Shortener

Seven URL Shortener

6
Comments 1
10 min read
What Is Trino And Why Is It Great At Processing Big Data

What Is Trino And Why Is It Great At Processing Big Data

19
Comments
7 min read
Extracting example SQL statements from a log

Extracting example SQL statements from a log

3
Comments
3 min read
SQL Server Interview Questions

SQL Server Interview Questions

11
Comments 4
2 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements

Quick 📸 on 🐘 active SQL from pg_stat_statements

8
Comments
3 min read
loading...