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.
How many rows would have been there without that LIMIT clause?

How many rows would have been there without that LIMIT clause?

12
Comments
6 min read
Understanding Data and Databases 101

Understanding Data and Databases 101

6
Comments
4 min read
JSON + MariaDB: How Hybrid Data Models Allow You to Have Your Cake and Eat It Too

JSON + MariaDB: How Hybrid Data Models Allow You to Have Your Cake and Eat It Too

11
Comments
10 min read
Create a Query Builder with PHP and SQL

Create a Query Builder with PHP and SQL

8
Comments 7
3 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

2
Comments
6 min read
SQL Performance - composite indexes

SQL Performance - composite indexes

7
Comments 1
2 min read
AzureFunBytes Reminder - @Azure SQL with @StevenMurawski - 7/1/2021

AzureFunBytes Reminder - @Azure SQL with @StevenMurawski - 7/1/2021

5
Comments
4 min read
Load Testing SQL Databases with k6

Load Testing SQL Databases with k6

11
Comments 1
9 min read
HASH or RANGE in distributed databases

HASH or RANGE in distributed databases

1
Comments
11 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

14
Comments
5 min read
Horizontal Scaling vs. Vertical Scaling for SQL: What's the Difference?

Horizontal Scaling vs. Vertical Scaling for SQL: What's the Difference?

3
Comments
2 min read
A Next-Generation ORM: Prisma

A Next-Generation ORM: Prisma

63
Comments 1
6 min read
Anvil Platform : Build Full-Stack Apps with only Python

Anvil Platform : Build Full-Stack Apps with only Python

52
Comments 5
2 min read
Which database to choose for your project

Which database to choose for your project

24
Comments 5
5 min read
Using Dapper over EntityFramework for database operations in .NET Core

Using Dapper over EntityFramework for database operations in .NET Core

9
Comments 2
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.