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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.