Forem

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.
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
Cover image for Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

6
Comments 1
2 min read
DuckDB 🦆 : Libérez le puissant moteur de Requêtes
Cover image for DuckDB 🦆 : Libérez le puissant moteur de Requêtes

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

Comments
8 min read
SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

1
Comments
6 min read
What’s a database anyway?? A blog post for kids
Cover image for What’s a database anyway?? A blog post for kids

What’s a database anyway?? A blog post for kids

10
Comments
14 min read
Get the Initial Date Using the Total — From SQL to SPL #35
Cover image for Get the Initial Date Using the Total — From SQL to SPL #35

Get the Initial Date Using the Total — From SQL to SPL #35

6
Comments 3
2 min read
SQL Query Optimization for Data Engineers

SQL Query Optimization for Data Engineers

11
Comments
3 min read
Understanding Data Anomalies and the Power of Database Normalization
Cover image for Understanding Data Anomalies and the Power of Database Normalization

Understanding Data Anomalies and the Power of Database Normalization

1
Comments 2
2 min read
How Indexes Really Work
Cover image for How Indexes Really Work

How Indexes Really Work

Comments
5 min read
What is SQL? A Simple Guide to Databases and Queries
Cover image for What is SQL? A Simple Guide to Databases and Queries

What is SQL? A Simple Guide to Databases and Queries

1
Comments
1 min read
SQL and I Had Beef 😂So I Built a Trigger
Cover image for SQL and I Had Beef 😂So I Built a Trigger

SQL and I Had Beef 😂So I Built a Trigger

1
Comments 1
2 min read
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
Cover image for 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
Annotations in Oracle Database 23ai

Annotations in Oracle Database 23ai

2
Comments
2 min read
DuckDB: When You Don’t Need Spark (But Still Need SQL)
Cover image for 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
Cover image for 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
Cover image for The Five Levels Of SQL

The Five Levels Of SQL

1
Comments 3
3 min read
Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL
Cover image for 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 23ai — Read-Only User Feature

Oracle 23ai — Read-Only User Feature

Comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
Cover image for 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)
Cover image for 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)

5
Comments 1
3 min read
loading...