DEV Community

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

Reactions 2 Comments
10 min read
SQL - NOT REALLY LANGUAGE.

SQL - NOT REALLY LANGUAGE.

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

CS50x 2021 - WEEK 7 (SQL)

Reactions 2 Comments
2 min read
Understanding Data and Databases 101

Understanding Data and Databases 101

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

How to Run Spark SQL on Encrypted Data

Reactions 4 Comments
6 min read
Additional Column for Incremental Numbering in SQL

Additional Column for Incremental Numbering in SQL

Reactions 5 Comments 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

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

Reactions 6 Comments
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

Reactions 4 Comments
8 min read
SQL Injection in Java

SQL Injection in Java

Reactions 5 Comments
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

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

SQL Server Recovery Models: A Quick Guide

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

The Art of Mapping Globals to Classes 1 of 3

Reactions 3 Comments
7 min read
Types of organization of records in files

Types of organization of records in files

Reactions 2 Comments
1 min read
Musings about Database Indexes

Musings about Database Indexes

Reactions 5 Comments
4 min read
My Favorite Free SQL Courses for Beginners

My Favorite Free SQL Courses for Beginners

Reactions 42 Comments
12 min read
Airbnb Properties in Australia

Airbnb Properties in Australia

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

Create a Query Builder with PHP and SQL

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

SQL & database monthly wrap up - July 2021

Reactions 17 Comments 1
2 min read
jOOQ on YugabyteDB

jOOQ on YugabyteDB

Reactions 2 Comments
5 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

Reactions 2 Comments
6 min read
SQL query builders

SQL query builders

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

Creating a CRUD App using Flask and SqlAlchemy

Reactions 2 Comments 2
8 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

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

Common Table Expressions(CTE) in SQL Server

Reactions 4 Comments
12 min read
SQL Performance - composite indexes

SQL Performance - composite indexes

Reactions 5 Comments
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)? 😇🎉

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

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

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

Data behind parking tickets in New York City

Reactions 3 Comments
7 min read
SQL queries through REST available now!

SQL queries through REST available now!

Reactions 5 Comments
1 min read
Boost your queries in Laravel

Boost your queries in Laravel

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

How to create table in SQL?

Reactions 7 Comments
1 min read
Load Testing SQL Databases with k6

Load Testing SQL Databases with k6

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

SQL Injection vs. Your Applications in the Modern Age

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

Level Up Your dbt Schema Tests in 4 Easy Steps

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

How to build internal tools on Stripe with SQL

Reactions 4 Comments
19 min read
Alter SQL Server Temporal Table

Alter SQL Server Temporal Table

Reactions 4 Comments
1 min read
SQL, NoSQL and beyond

SQL, NoSQL and beyond

Reactions 7 Comments
4 min read
Postgres pg_stat_statement setup via docker

Postgres pg_stat_statement setup via docker

Reactions 4 Comments
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?

Reactions 2 Comments
2 min read
Exploit Website Databases Using SQLmap

Exploit Website Databases Using SQLmap

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

A Next-Generation ORM: Prisma

Reactions 62 Comments 1
6 min read
Running SSIS Packages with Python

Running SSIS Packages with Python

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

Different Ways to Load Data From CSV Files in PostgreSQL

Reactions 5 Comments
3 min read
Constraints in SQL

Constraints in SQL

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

Utilizing BigQuery as a Data Warehouse in a distributed application

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

Anvil Platform : Build Full-Stack Apps with only Python

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

Five classic SQL & database posts - July 2021

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

pg_hint_plan and single-table cardinality correction

Reactions 7 Comments
8 min read
Which database to choose for your project

Which database to choose for your project

Reactions 18 Comments 4
5 min read
SQL Server Temporal Tables

SQL Server Temporal Tables

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

Security vulnerabilities – how to find and fix them

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

Using Dapper over EntityFramework for database operations in .NET Core

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

SQL & database monthly wrap up - June 2021

Reactions 24 Comments 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

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

What I Learned This Week: Database Constraints

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

Installing Microsoft SQL Server on your Mac with docker

Reactions 2 Comments
1 min read
Know Your Indices

Know Your Indices

Reactions 4 Comments
26 min read
Querying ActiveStorage Attachments

Querying ActiveStorage Attachments

Reactions 14 Comments 1
1 min read
My favourite backend tools

My favourite backend tools

Reactions 7 Comments
7 min read
loading...