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.
#SQL na unha: manipulando dados

#SQL na unha: manipulando dados

7
Comments
6 min read
PostgreSQL WAL activities

PostgreSQL WAL activities

7
Comments 2
5 min read
Quill- Most efficient Scala driver for Apache Cassandra and Spark

Quill- Most efficient Scala driver for Apache Cassandra and Spark

2
Comments
4 min read
Quick start with Postgres ⚡

Quick start with Postgres ⚡

12
Comments 1
3 min read
Import a CSV file into a MySQL database using PHP PDO (fast af) 🚀

Import a CSV file into a MySQL database using PHP PDO (fast af) 🚀

5
Comments
2 min read
Database concurrency as simple as possible

Database concurrency as simple as possible

10
Comments
5 min read
#SQL na unha: definindo estrutura do banco

#SQL na unha: definindo estrutura do banco

2
Comments
4 min read
#SQL na unha: banco de dados e primeiros comandos

#SQL na unha: banco de dados e primeiros comandos

4
Comments 2
4 min read
Improving performance with SQL aggregate functions

Improving performance with SQL aggregate functions

6
Comments
7 min read
PostgreSQL temp files usage

PostgreSQL temp files usage

15
Comments 19
5 min read
Supabase Vs Firebase Pricing and When To Use Which

Supabase Vs Firebase Pricing and When To Use Which

20
Comments 6
3 min read
SQL Beginner Friendly Cheatsheet

SQL Beginner Friendly Cheatsheet

10
Comments
2 min read
5 ways to implement case-insensitive search in SQLite with full Unicode support

5 ways to implement case-insensitive search in SQLite with full Unicode support

6
Comments 1
10 min read
SQL JOIN IN SQL

SQL JOIN IN SQL

6
Comments
1 min read
SQL Server Primary Keys

SQL Server Primary Keys

6
Comments 1
6 min read
End-To-End Type Safety: What, Why and How

End-To-End Type Safety: What, Why and How

7
Comments 4
15 min read
100 Languages Speedrun: Episode 63: CSVQ

100 Languages Speedrun: Episode 63: CSVQ

6
Comments
5 min read
Postgres UNNEST cheat sheet for bulk operations

Postgres UNNEST cheat sheet for bulk operations

10
Comments
3 min read
MindsDB: Creating machine learning predictive models using SQL.

MindsDB: Creating machine learning predictive models using SQL.

17
Comments 4
8 min read
Apache ShardingSphere 5.0.0 Kernel: API Adjustments

Apache ShardingSphere 5.0.0 Kernel: API Adjustments

6
Comments
6 min read
How Covid changed the way we work with SQL

How Covid changed the way we work with SQL

2
Comments
4 min read
MindsDB: Your introduction to creating machine learning predictive models.

MindsDB: Your introduction to creating machine learning predictive models.

6
Comments
8 min read
Interview Questions of the SQL

Interview Questions of the SQL

4
Comments 1
1 min read
Interview Questions of the SQL

Interview Questions of the SQL

3
Comments
1 min read
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
8 Great Data Engineering Youtube Channels

8 Great Data Engineering Youtube Channels

23
Comments
6 min read
SQL Basics (Zero to Hero)- Part 01

SQL Basics (Zero to Hero)- Part 01

9
Comments 1
3 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

7
Comments
6 min read
Intro

Intro

4
Comments 4
1 min read
Redis helps avoiding racing conditions

Redis helps avoiding racing conditions

8
Comments
5 min read
Indexes | SQL

Indexes | SQL

4
Comments
5 min read
Brace yourself: Using BigQuery as an operational backend

Brace yourself: Using BigQuery as an operational backend

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

6
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

6
Comments
4 min read
JDBC Tutorial Part 1: Connecting to a Database

JDBC Tutorial Part 1: Connecting to a Database

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

Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

7
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 🐘 🚀

7
Comments 2
5 min read
Importing Large SQL File

Importing Large SQL File

4
Comments
2 min read
MySQL- RDBMS

MySQL- RDBMS

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

100 Languages Speedrun: Episode 39: SQLite

7
Comments
8 min read
loading...