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.
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
Rapidly Build Prototypes With Your Team Using Repl.it, Airtable, and Sequin

Rapidly Build Prototypes With Your Team Using Repl.it, Airtable, and Sequin

7
Comments
8 min read
Types of organization of records in files

Types of organization of records in files

2
Comments
1 min read
Musings about Database Indexes

Musings about Database Indexes

5
Comments
4 min read
Airbnb Properties in Australia

Airbnb Properties in Australia

6
Comments
7 min read
SQL - NOT REALLY LANGUAGE.

SQL - NOT REALLY LANGUAGE.

4
Comments
2 min read
Create a Query Builder with PHP and SQL

Create a Query Builder with PHP and SQL

8
Comments 7
3 min read
Data cleaning null values -- SQL or Code?

Data cleaning null values -- SQL or Code?

1
Comments
11 min read
SQL Injection in Java

SQL Injection in Java

5
Comments
2 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

2
Comments
6 min read
SQL query builders

SQL query builders

3
Comments 2
5 min read
Want to convert any SQL Query to Mongo DB Query - Shortcut

Want to convert any SQL Query to Mongo DB Query - Shortcut

3
Comments
1 min read
CS50x 2021 - WEEK 7 (SQL)

CS50x 2021 - WEEK 7 (SQL)

2
Comments
2 min read
The Art of Mapping Globals to Classes 1 of 3

The Art of Mapping Globals to Classes 1 of 3

4
Comments
7 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
jOOQ on YugabyteDB

jOOQ on YugabyteDB

2
Comments
5 min read
Data behind parking tickets in New York City

Data behind parking tickets in New York City

5
Comments
7 min read
Boost your queries in Laravel

Boost your queries in Laravel

3
Comments 1
2 min read
Load Testing SQL Databases with k6

Load Testing SQL Databases with k6

11
Comments 1
9 min read
SQL Injection vs. Your Applications in the Modern Age

SQL Injection vs. Your Applications in the Modern Age

7
Comments
7 min read
HASH or RANGE in distributed databases

HASH or RANGE in distributed databases

1
Comments
11 min read
MySQL CRUD Basics - Creating a Database

MySQL CRUD Basics - Creating a Database

1
Comments
4 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

13
Comments
5 min read
loading...