The Wayback Machine - https://web.archive.org/web/20210813204043/https://dev.to/t/sql

DEV Community

DEV Community is a community of 673,673 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create new account Log in
loading...

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
SQL Performance Resources

SQL Performance Resources

2
10 min read
SQL - NOT REALLY LANGUAGE.

SQL - NOT REALLY LANGUAGE.

3
2 min read
CS50x 2021 - WEEK 7 (SQL)

CS50x 2021 - WEEK 7 (SQL)

2
2 min read
Understanding Data and Databases 101

Understanding Data and Databases 101

6
4 min read
How to Run Spark SQL on Encrypted Data

How to Run Spark SQL on Encrypted Data

4
6 min read
Additional Column for Incremental Numbering in SQL

Additional Column for Incremental Numbering in SQL

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

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

2
1 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

6
10 min read
Rapidly Build Prototypes With Your Team Using Repl.it, Airtable, and Sync Inc

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

4
8 min read
SQL Injection in Java

SQL Injection in Java

5
2 min read
Security Checklist - More than 70 security items to validate your database

Security Checklist - More than 70 security items to validate your database

12
2 min read
SQL Server Recovery Models: A Quick Guide

SQL Server Recovery Models: A Quick Guide

4
7 min read
The Art of Mapping Globals to Classes 1 of 3

The Art of Mapping Globals to Classes 1 of 3

3
7 min read
Types of organization of records in files

Types of organization of records in files

2
1 min read
Musings about Database Indexes

Musings about Database Indexes

5
4 min read
My Favorite Free SQL Courses for Beginners

My Favorite Free SQL Courses for Beginners

42
12 min read
Airbnb Properties in Australia

Airbnb Properties in Australia

5
7 min read
Create a Query Builder with PHP and SQL

Create a Query Builder with PHP and SQL

3 3
3 min read
SQL & database monthly wrap up - July 2021

SQL & database monthly wrap up - July 2021

17 1
2 min read
jOOQ on YugabyteDB

jOOQ on YugabyteDB

2
5 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

2
6 min read
SQL query builders

SQL query builders

3 2
5 min read
Creating a CRUD App using Flask and SqlAlchemy

Creating a CRUD App using Flask and SqlAlchemy

2 2
8 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

7
5 min read
Common Table Expressions(CTE) in SQL Server

Common Table Expressions(CTE) in SQL Server

4
12 min read
SQL Performance - composite indexes

SQL Performance - composite indexes

5
2 min read
What is the difference between SQL and SQL Server (and similar tools)? 😇🎉

What is the difference between SQL and SQL Server (and similar tools)? 😇🎉

5
3 min read
AzureFunBytes Reminder - @Azure SQL with @StevenMurawski - 7/1/2021

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

5
4 min read
Data behind parking tickets in New York City

Data behind parking tickets in New York City

3
7 min read
SQL queries through REST available now!

SQL queries through REST available now!

5
1 min read
Boost your queries in Laravel

Boost your queries in Laravel

3 1
2 min read
How to create table in SQL?

How to create table in SQL?

7
1 min read
Load Testing SQL Databases with k6

Load Testing SQL Databases with k6

5
9 min read
SQL Injection vs. Your Applications in the Modern Age

SQL Injection vs. Your Applications in the Modern Age

4
7 min read
Level Up Your dbt Schema Tests in 4 Easy Steps

Level Up Your dbt Schema Tests in 4 Easy Steps

2
3 min read
How to build internal tools on Stripe with SQL

How to build internal tools on Stripe with SQL

4
19 min read
Alter SQL Server Temporal Table

Alter SQL Server Temporal Table

4
1 min read
SQL, NoSQL and beyond

SQL, NoSQL and beyond

7
4 min read
Postgres pg_stat_statement setup via docker

Postgres pg_stat_statement setup via docker

4
2 min read
Horizontal Scaling vs. Vertical Scaling for SQL: What's the Difference?

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

2
2 min read
Exploit Website Databases Using SQLmap

Exploit Website Databases Using SQLmap

2
2 min read
A Next-Generation ORM: Prisma

A Next-Generation ORM: Prisma

62 1
6 min read
Running SSIS Packages with Python

Running SSIS Packages with Python

5
3 min read
Different Ways to Load Data From CSV Files in PostgreSQL

Different Ways to Load Data From CSV Files in PostgreSQL

5
3 min read
Constraints in SQL

Constraints in SQL

3
1 min read
Utilizing BigQuery as a Data Warehouse in a distributed application

Utilizing BigQuery as a Data Warehouse in a distributed application

3
9 min read
Anvil Platform : Build Full-Stack Apps with only Python

Anvil Platform : Build Full-Stack Apps with only Python

44 2
2 min read
Five classic SQL & database posts - July 2021

Five classic SQL & database posts - July 2021

24 3
2 min read
pg_hint_plan and single-table cardinality correction

pg_hint_plan and single-table cardinality correction

7
8 min read
Which database to choose for your project

Which database to choose for your project

18 4
5 min read
SQL Server Temporal Tables

SQL Server Temporal Tables

6
1 min read
Security vulnerabilities – how to find and fix them

Security vulnerabilities – how to find and fix them

4
4 min read
Using Dapper over EntityFramework for database operations in .NET Core

Using Dapper over EntityFramework for database operations in .NET Core

6 2
4 min read
SQL & database monthly wrap up - June 2021

SQL & database monthly wrap up - June 2021

24 3
2 min read
How to Query in SQFLite using Flutter Apps | Flutter SQFLite Tutorials for beginners #2

How to Query in SQFLite using Flutter Apps | Flutter SQFLite Tutorials for beginners #2

4
1 min read
What I Learned This Week: Database Constraints

What I Learned This Week: Database Constraints

5
2 min read
Installing Microsoft SQL Server on your Mac with docker

Installing Microsoft SQL Server on your Mac with docker

2
1 min read
Know Your Indices

Know Your Indices

4
26 min read
Querying ActiveStorage Attachments

Querying ActiveStorage Attachments

14 1
1 min read
My favourite backend tools

My favourite backend tools

7
7 min read
loading...