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.
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

2
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
How to simplify nested SQL in applications with esProc

How to simplify nested SQL in applications with esProc

11
Comments
4 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)

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

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

2
Comments
5 min read
Collation in Database - What you need to know

Collation in Database - What you need to know

Comments
3 min read
SQL: The Secret Weapon Behind Data Analytics and Data Science
Cover image for SQL: The Secret Weapon Behind Data Analytics and Data Science

SQL: The Secret Weapon Behind Data Analytics and Data Science

4
Comments 3
4 min read
Connect Any Postgres to Real-Time Analytics
Cover image for Connect Any Postgres to Real-Time Analytics

Connect Any Postgres to Real-Time Analytics

1
Comments
7 min read
What's New in MySQL 9 🧐 - a DBA's Perspective 🥸
Cover image for What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

8
Comments
9 min read
Build a Secure Login System with PHP and MySQL: Step-by-Step Guide"

Build a Secure Login System with PHP and MySQL: Step-by-Step Guide"

2
Comments
2 min read
Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.

Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.

Comments
16 min read
Conditional Grouping — From SQL to SPL #37
Cover image for Conditional Grouping — From SQL to SPL #37

Conditional Grouping — From SQL to SPL #37

6
Comments 4
2 min read
Best 7 Logical Database Design Tools in 2025
Cover image for Best 7 Logical Database Design Tools in 2025

Best 7 Logical Database Design Tools in 2025

10
Comments 2
5 min read
SQLAchemy-iris with the latest version Python driver

SQLAchemy-iris with the latest version Python driver

Comments
6 min read
Filtering and Exporting SQL Stored Procedures with PowerShell
Cover image for Filtering and Exporting SQL Stored Procedures with PowerShell

Filtering and Exporting SQL Stored Procedures with PowerShell

Comments
4 min read
PostgreSQL aborts the transactions on error

PostgreSQL aborts the transactions on error

1
Comments
3 min read
loading...