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.
usql on YugabyteDB

usql on YugabyteDB

2
Comments
4 min read
ORM's x Query Builder's x Raw SQL

ORM's x Query Builder's x Raw SQL

13
Comments
6 min read
SQL Query into Pandas DataFrame - Part 1

SQL Query into Pandas DataFrame - Part 1

7
Comments
2 min read
How do you number SELECT query results using SQL?

How do you number SELECT query results using SQL?

3
Comments
5 min read
Entenda como nossa base de Diretórios Brasileiros facilita sua vida

Entenda como nossa base de Diretórios Brasileiros facilita sua vida

6
Comments
4 min read
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
Tutorial on How to connect to a Linked Server

Tutorial on How to connect to a Linked Server

3
Comments
3 min read
Designing Hotel Management System With RADZEN Blazor Web Assembly Part 1 (Database Design)

Designing Hotel Management System With RADZEN Blazor Web Assembly Part 1 (Database Design)

3
Comments
1 min read
How to Run Spark SQL on Encrypted Data

How to Run Spark SQL on Encrypted Data

4
Comments
6 min read
SQL Performance Resources

SQL Performance Resources

5
Comments
10 min read
Pausing Dedicated SQL Pools with Synapse Pipelines

Pausing Dedicated SQL Pools with Synapse Pipelines

4
Comments
3 min read
Additional Column for Incremental Numbering in SQL

Additional Column for Incremental Numbering in SQL

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

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

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

3
Comments
7 min read
SQL Performance - composite indexes

SQL Performance - composite indexes

6
Comments
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
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

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

Common Table Expressions(CTE) in SQL Server

6
Comments 2
12 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)? 😇🎉

6
Comments
3 min read
Postgres pg_stat_statement setup via docker

Postgres pg_stat_statement setup via docker

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?

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

A Next-Generation ORM: Prisma

63
Comments 1
6 min read
Running SSIS Packages with Python

Running SSIS Packages with Python

6
Comments
3 min read
Constraints in SQL

Constraints in SQL

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

4
Comments
9 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
SQL queries through REST available now!

SQL queries through REST available now!

5
Comments
1 min read
How to create table in SQL?

How to create table in SQL?

5
Comments
1 min read
pg_hint_plan and single-table cardinality correction

pg_hint_plan and single-table cardinality correction

5
Comments
8 min read
Which database to choose for your project

Which database to choose for your project

24
Comments 5
5 min read
Security vulnerabilities – how to find and fix them

Security vulnerabilities – how to find and fix them

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

How to build internal tools on Stripe with SQL

5
Comments
19 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
Different Ways to Load Data From CSV Files in PostgreSQL

Different Ways to Load Data From CSV Files in PostgreSQL

6
Comments
3 min read
GitHub Stargazers over time using Google Charts

GitHub Stargazers over time using Google Charts

3
Comments
4 min read
Querying ActiveStorage Attachments

Querying ActiveStorage Attachments

13
Comments 2
1 min read
Know Your Indices

Know Your Indices

4
Comments
26 min read
My favourite backend tools

My favourite backend tools

7
Comments
7 min read
What is Cost-based Optimization?

What is Cost-based Optimization?

3
Comments
5 min read
How to connect to an Azure SQL Database from C# using Azure AD

How to connect to an Azure SQL Database from C# using Azure AD

3
Comments
8 min read
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

26
Comments 9
3 min read
Introducing DataStation, the open-source data IDE for developers

Introducing DataStation, the open-source data IDE for developers

2
Comments
2 min read
loading...