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

28
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

8
Comments
2 min read
Quiz: SQL query

Quiz: SQL query

8
Comments 7
1 min read
Azure SQL Database Tools Part 4: Other Platform Tools

Azure SQL Database Tools Part 4: Other Platform Tools

4
Comments
3 min read
loading...