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.
DrizzleORM v0.11 | 18 months into development

DrizzleORM v0.11 | 18 months into development

9
Comments 3
3 min read
Hibernate: Roteiro básico de implementação

Hibernate: Roteiro básico de implementação

4
Comments
4 min read
Distributed query execution in CrateDB: What you need to know

Distributed query execution in CrateDB: What you need to know

1
Comments
7 min read
MariaDB with Replication in Docker

MariaDB with Replication in Docker

9
Comments 2
2 min read
Where are those CloudTrail IP addresses coming from?

Where are those CloudTrail IP addresses coming from?

14
Comments
3 min read
MariaDB Quick-tip #5 - Create a sequence of date and time

MariaDB Quick-tip #5 - Create a sequence of date and time

9
Comments 2
2 min read
Advanced SQL: Going beyond the Basics

Advanced SQL: Going beyond the Basics

11
Comments
11 min read
DB Migration using SQLgateway

DB Migration using SQLgateway

7
Comments
3 min read
Anonymiser les données de PrestaShop

Anonymiser les données de PrestaShop

3
Comments
2 min read
SQL: CRUD for Newbies

SQL: CRUD for Newbies

2
Comments
3 min read
find the partition key with a duplicate covering index local read

find the partition key with a duplicate covering index local read

10
Comments 2
8 min read
Using Flink SQL and Redpanda for stream processing

Using Flink SQL and Redpanda for stream processing

Comments
5 min read
access the local partition only in 🚀 YugabyteDB geo-partitioned tables

access the local partition only in 🚀 YugabyteDB geo-partitioned tables

12
Comments
4 min read
Get Started with Directus Standard Cloud using our pay-as-you-go hourly pricing.

Get Started with Directus Standard Cloud using our pay-as-you-go hourly pricing.

4
Comments
1 min read
Yet Another Post About N + 1 Queries

Yet Another Post About N + 1 Queries

9
Comments
3 min read
Follow Friday: SQL Edition (8 July 2022)

Follow Friday: SQL Edition (8 July 2022)

26
Comments 5
1 min read
Video Game DB PostgreSQL

Video Game DB PostgreSQL

7
Comments 2
1 min read
MariaDb Quick-tip #4 - Random int for each row

MariaDb Quick-tip #4 - Random int for each row

Comments
1 min read
How to Import Data in Oracle SQL Developer Web

How to Import Data in Oracle SQL Developer Web

6
Comments
3 min read
SQL Safety question

SQL Safety question

8
Comments
1 min read
I learned how to use Python to do backend stuff with my frontend experience.

I learned how to use Python to do backend stuff with my frontend experience.

Comments
5 min read
Golang social network explained

Golang social network explained

7
Comments
1 min read
ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples

ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples

6
Comments
10 min read
The 4 Types of NoSQL Databases You Need to Know

The 4 Types of NoSQL Databases You Need to Know

2
Comments
6 min read
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

211
Comments 31
2 min read
SQL: The basics and beyond

SQL: The basics and beyond

7
Comments
7 min read
ShardingSphere-JDBC Driver Released: A JDBC Driver That Requires No Code Modifications

ShardingSphere-JDBC Driver Released: A JDBC Driver That Requires No Code Modifications

3
Comments
5 min read
Speeding Up Bulk Loading in PostgreSQL

Speeding Up Bulk Loading in PostgreSQL

27
Comments 1
4 min read
Security vs. Performance in the SQL World

Security vs. Performance in the SQL World

5
Comments
7 min read
O que Ă© ACID?

O que Ă© ACID?

9
Comments
6 min read
MariaDB Quick-tip #3 - Prepending zeros

MariaDB Quick-tip #3 - Prepending zeros

7
Comments
1 min read
Database Mesh 2.0: Database Governance in a Cloud Native Environment

Database Mesh 2.0: Database Governance in a Cloud Native Environment

3
Comments
9 min read
Optimizing Nested Loop joins on YugabyteDB with jOOQ

Optimizing Nested Loop joins on YugabyteDB with jOOQ

8
Comments
4 min read
OWASP Vulnerability: SQL Injection | iFour Technolab

OWASP Vulnerability: SQL Injection | iFour Technolab

7
Comments
7 min read
Filter database records without SQL

Filter database records without SQL

13
Comments
1 min read
MariaDB Quick-tip #1 - Range of int

MariaDB Quick-tip #1 - Range of int

8
Comments 2
1 min read
How To Install SQL Server on Ubuntu

How To Install SQL Server on Ubuntu

6
Comments
2 min read
Quiz: SQL query

Quiz: SQL query

8
Comments 7
1 min read
geo-distribution with 🚀 YugabyteDB tablespaces

geo-distribution with 🚀 YugabyteDB tablespaces

9
Comments
4 min read
How To Restore A PostgreSQL Database Using Command Line

How To Restore A PostgreSQL Database Using Command Line

5
Comments
3 min read
The best way to learn SQL?

The best way to learn SQL?

3
Comments 9
1 min read
How to import JSON file into SQL Server Database

How to import JSON file into SQL Server Database

5
Comments 1
3 min read
MariaDB Quick-tip #2 - Randomize rows

MariaDB Quick-tip #2 - Randomize rows

3
Comments
1 min read
2 steps to display cache tables data on the web by using jquery datatable and embedded python

2 steps to display cache tables data on the web by using jquery datatable and embedded python

5
Comments
2 min read
MindsDB: Predicting Supply Chain Demand with Machine Learning using SQL

MindsDB: Predicting Supply Chain Demand with Machine Learning using SQL

8
Comments
7 min read
Local reads from 🚀YugabyteDB raft followers

Local reads from 🚀YugabyteDB raft followers

11
Comments 1
6 min read
Local reads from 🚀YugabyteDB Read Replicas

Local reads from 🚀YugabyteDB Read Replicas

8
Comments
7 min read
Brincando com Ecto.Query

Brincando com Ecto.Query

6
Comments 2
4 min read
Wait, I changed my mind.

Wait, I changed my mind.

14
Comments 3
5 min read
Just Finished my 1st #100daysOfCode Challenge

Just Finished my 1st #100daysOfCode Challenge

7
Comments 7
1 min read
Updating the Collation of an Existing MSSQL Database

Updating the Collation of an Existing MSSQL Database

3
Comments
7 min read
Database Reindexing (MSSQL)

Database Reindexing (MSSQL)

3
Comments
2 min read
Get data from Cloud SQL with Python

Get data from Cloud SQL with Python

5
Comments
6 min read
4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale

4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale

7
Comments
10 min read
🚀 hash+hash partitioning+sharding

🚀 hash+hash partitioning+sharding

10
Comments
6 min read
Heterogeneous migration: reducing Dangdang’s customer system RTO 60x and increasing speed by 20%

Heterogeneous migration: reducing Dangdang’s customer system RTO 60x and increasing speed by 20%

6
Comments
6 min read
Deep Insight Into Open Source Databases

Deep Insight Into Open Source Databases

16
Comments
5 min read
Keeping track of database schema changes

Keeping track of database schema changes

18
Comments 3
5 min read
Notes on PostgreSQL: Common Table Expressions

Notes on PostgreSQL: Common Table Expressions

8
Comments
7 min read
SQL meet Data Science (Pandas) cheat sheet

SQL meet Data Science (Pandas) cheat sheet

13
Comments 2
1 min read
loading...