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.
Efficiently Managing Data with SELECT During INSERT Queries

Efficiently Managing Data with SELECT During INSERT Queries

1
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
4 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
MySQL: Everything You Need To Know

MySQL: Everything You Need To Know

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

102
Comments 66
2 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 1
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
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

15
Comments
7 min read
Simple Database Software For MySQL

Simple Database Software For MySQL

Comments
8 min read
Isolation Levels - part XII: To go further

Isolation Levels - part XII: To go further

Comments 2
2 min read
Slash Slow Queries by Rewriting OR to UNION

Slash Slow Queries by Rewriting OR to UNION

Comments 1
3 min read
How To Execute A Query In SQL: Using Queries And Data Views

How To Execute A Query In SQL: Using Queries And Data Views

Comments
5 min read
SQL - Handle NULL Values Safely in Queries

SQL - Handle NULL Values Safely in Queries

2
Comments
1 min read
Importing Data From Multiple MS Access Files To SQL Server

Importing Data From Multiple MS Access Files To SQL Server

1
Comments
5 min read
SQL to Python Pandas: A SQL User's Quick Guide

SQL to Python Pandas: A SQL User's Quick Guide

3
Comments
11 min read
Distributed PostgreSQL without sharding constraint for SQL joins

Distributed PostgreSQL without sharding constraint for SQL joins

Comments
4 min read
My "solution" to integrate ChatGPT into any database

My "solution" to integrate ChatGPT into any database

11
Comments
2 min read
SQL - Use Subqueries for Complex Data Retrieval

SQL - Use Subqueries for Complex Data Retrieval

Comments
1 min read
Alembic with Async SQLAlchemy

Alembic with Async SQLAlchemy

58
Comments 6
3 min read
SQL Stored Procedures - Na visão de um estudante.

SQL Stored Procedures - Na visão de um estudante.

Comments
6 min read
loading...