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.
SQL Date & Time Functions: A Practical Guide for Real-World Queries
vivekdraxlr profile

SQL Date & Time Functions: A Practical Guide for Real-World Queries

#sql #database #postgres #mysql
Comments
7 min read
Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.
braeson_nyahera profile

Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.

#sql #postgres #data #analytics
1
Comments
2 min read
PostgreSQL Query Rewriting Techniques
philip_mcclarence_2ef9475 profile

PostgreSQL Query Rewriting Techniques

#database #performance #postgres #sql
Comments 1
9 min read
Subqueries vs. CTEs in SQL: What They Are and When to Use Each.
samkaruri profile

Subqueries vs. CTEs in SQL: What They Are and When to Use Each.

#subqueries #ctes #database #sql
Comments
7 min read
Codd's Connection Trap and Oracle's JOIN TO ONE
franckpachot profile

Codd's Connection Trap and Oracle's JOIN TO ONE

#sql #relational #database #oracle
Comments
8 min read
The bug your Typescript compiler and SQL migration both miss
equality_modehouse_9897e profile

The bug your Typescript compiler and SQL migration both miss

#typescript #sql #database #webdev
Comments
1 min read
Postgres Extensions Cheat Sheet: Replace 7 Databases With SQL
tigerdata_dev profile

Postgres Extensions Cheat Sheet: Replace 7 Databases With SQL

#postgres #postgresqlextensions #database #sql
Comments
7 min read
How Databricks Genie Turns Plain English Into SQL Code
lucy1 profile
Lucy

How Databricks Genie Turns Plain English Into SQL Code

#databricks #dataengineering #sql #ai
5
Comments
11 min read
I built a 57-line asyncpg wrapper because SQLAlchemy was driving me insane
kernz profile
kernz

I built a 57-line asyncpg wrapper because SQLAlchemy was driving me insane

#sql #python #sqlalchemy #postgres
5
Comments
2 min read
I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)
dattasable profile

I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)

#sql #python #dataengineering #tutorial
2
Comments 1
3 min read
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database
dattasable profile

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

#sql #database #dataengineering #programming
Comments 1
3 min read
DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace
soytuber profile
soy

DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace

#database #sql #sqlite
Comments
3 min read
Four Ways to Use AI With Your Database in VS Code
mike_burgh profile

Four Ways to Use AI With Your Database in VS Code

#vscode #database #ai #sql
Comments 1
2 min read
PostgreSQL WHERE Clause Optimization
philip_mcclarence_2ef9475 profile

PostgreSQL WHERE Clause Optimization

#database #performance #postgres #sql
Comments
9 min read
NPI Number Validation: How to Clean and Enrich Provider Data in Your Database
season_mudbhary_7856e4083 profile

NPI Number Validation: How to Clean and Enrich Provider Data in Your Database

#healthcare #sql #dataengineering #database
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.