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.
23ai - Series Part2 - CLOB vs JSON | Stress Testing with Exhaustive Weather JSON Payloads

23ai - Series Part2 - CLOB vs JSON | Stress Testing with Exhaustive Weather JSON Payloads

Comments
71 min read
23ai - Series Part 1 - CLOB to JSON Migration Essentials

23ai - Series Part 1 - CLOB to JSON Migration Essentials

Comments
13 min read
Como bancos de dados realmente salvam os dados

Como bancos de dados realmente salvam os dados

Comments
3 min read
NoSQL vs. SQL: Which One to Use

NoSQL vs. SQL: Which One to Use

Comments
3 min read
Why I Built USPL: Helping GPT Understand Multi-Table SQL

Why I Built USPL: Helping GPT Understand Multi-Table SQL

Comments 1
2 min read
Behind the Query: The Secret Life of Database Indexes

Behind the Query: The Secret Life of Database Indexes

Comments
8 min read
DuckDB: When You Don’t Need Spark (But Still Need SQL)

DuckDB: When You Don’t Need Spark (But Still Need SQL)

Comments
2 min read
Why uber ditched postgres for mysql: What every developer can learn from it

Why uber ditched postgres for mysql: What every developer can learn from it

2
Comments
46 min read
The Five Levels Of SQL

The Five Levels Of SQL

2
Comments 3
3 min read
Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

3
Comments
3 min read
Oracle AI Database 26ai — Read-Only User Feature

Oracle AI Database 26ai — Read-Only User Feature

Comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

5
Comments 1
2 min read
Comprehensive SQL Guide for Freshers and Intermediate Learners

Comprehensive SQL Guide for Freshers and Intermediate Learners

Comments
9 min read
Using SQLite in the Browser with WebAssembly and React (Local-First Apps with No Backend)

Using SQLite in the Browser with WebAssembly and React (Local-First Apps with No Backend)

6
Comments 2
3 min read
Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

3
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.