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.
Propagated Transactions for Node.js Applications

Propagated Transactions for Node.js Applications

18
Comments
4 min read
How Change Data Capture (CDC) Works with Streaming Database

How Change Data Capture (CDC) Works with Streaming Database

8
Comments
8 min read
Why SQL is right for Infrastructure Management

Why SQL is right for Infrastructure Management

1
Comments 1
24 min read
Get started with libSQL, a next-gen fork of SQLite

Get started with libSQL, a next-gen fork of SQLite

7
Comments
13 min read
Movie rating web application

Movie rating web application

Comments
7 min read
Simulating Streaming Data for Fraud Detection with Datagen CLI

Simulating Streaming Data for Fraud Detection with Datagen CLI

28
Comments 1
5 min read
Updating timestamps automatically in Supabase

Updating timestamps automatically in Supabase

19
Comments
1 min read
SQL for data analysis

SQL for data analysis

1
Comments 1
3 min read
Everything you wanted to know about Auto Increment but were afraid to ask

Everything you wanted to know about Auto Increment but were afraid to ask

4
Comments
6 min read
SQL Indexes Basics in Rails

SQL Indexes Basics in Rails

4
Comments
4 min read
🏺Database Architecture - History Over State

🏺Database Architecture - History Over State

8
Comments 1
8 min read
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

1
Comments
4 min read
Jazz up a CLI project with color and sound!

Jazz up a CLI project with color and sound!

1
Comments
4 min read
SQL fundamentals: understanding Join Tables

SQL fundamentals: understanding Join Tables

1
Comments
6 min read
Python to SQL and back again... an Object-Relational Mapping tale.

Python to SQL and back again... an Object-Relational Mapping tale.

Comments
3 min read
How to compose SQL queries based on values from CSV file?

How to compose SQL queries based on values from CSV file?

Comments
2 min read
IN Subquery Optimization

IN Subquery Optimization

Comments
5 min read
Make your Ruby on Rails app 80x faster with SQL

Make your Ruby on Rails app 80x faster with SQL

2
Comments
9 min read
Problem solving with SQL: Case Study #1 — Danny’s Diner

Problem solving with SQL: Case Study #1 — Danny’s Diner

18
Comments 2
9 min read
How to delete large records in batches

How to delete large records in batches

5
Comments
3 min read
Securely connect to an Amazon RDS via PrivateLink using SQL

Securely connect to an Amazon RDS via PrivateLink using SQL

Comments
3 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
3 min read
Simple query to remove duplicates from table

Simple query to remove duplicates from table

2
Comments
2 min read
SQL Server Performance Tuning

SQL Server Performance Tuning

2
Comments
2 min read
Cypher on PostgreSQL: A Reason to Use Apache AGE

Cypher on PostgreSQL: A Reason to Use Apache AGE

4
Comments
2 min read
loading...