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

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

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)

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

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

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)

5
Comments 1
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
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

SQL: The Secret Weapon Behind Data Analytics and Data Science

4
Comments 3
4 min read
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 🥸

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

Conditional Grouping — From SQL to SPL #37

6
Comments 4
2 min read
loading...