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.
The Syntax of Discreteness - Using SQL as an Example

The Syntax of Discreteness - Using SQL as an Example

6
Comments
4 min read
Efficiently Managing Data with SELECT During INSERT Queries

Efficiently Managing Data with SELECT During INSERT Queries

1
Comments
2 min read
Could Batched Nested Loop improve PostgreSQL like it does for YugabyteDB?

Could Batched Nested Loop improve PostgreSQL like it does for YugabyteDB?

Comments
24 min read
Here comes big data technology that rivals clusters on a single machine

Here comes big data technology that rivals clusters on a single machine

6
Comments
6 min read
Understanding PostgreSQL and MongoDB Databases: Know When to Use Each

Understanding PostgreSQL and MongoDB Databases: Know When to Use Each

4
Comments 3
3 min read
Web Vulnerabilities: SQL Injections

Web Vulnerabilities: SQL Injections

1
Comments 4
3 min read
Why you should never use an UUID as the primary key in SQL Databases

Why you should never use an UUID as the primary key in SQL Databases

104
Comments 66
2 min read
MySQL: Everything You Need To Know

MySQL: Everything You Need To Know

15
Comments
2 min read
Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

9
Comments 1
4 min read
SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

3
Comments 2
2 min read
Surrogate Key vs Primary Key: What's the Difference?

Surrogate Key vs Primary Key: What's the Difference?

1
Comments
11 min read
How to store and calculate historical big data with lower usage frequency

How to store and calculate historical big data with lower usage frequency

6
Comments
4 min read
`OR` Filter on Two Tables, and Batched Nested Loops

`OR` Filter on Two Tables, and Batched Nested Loops

1
Comments
6 min read
Set-oriented Syntax – Using SQL as an Example

Set-oriented Syntax – Using SQL as an Example

6
Comments 1
4 min read
Communicate with Microsoft SQL Server that works on Flutter app compiled for multiple platforms

Communicate with Microsoft SQL Server that works on Flutter app compiled for multiple platforms

21
Comments 1
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.