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.
The main tasks of a Database Administrator (DBA) by 2025
Cover image for The main tasks of a Database Administrator (DBA) by 2025

The main tasks of a Database Administrator (DBA) by 2025

5
Comments
27 min read
5 Steps to Optimize MySQL Deep Pagination
Cover image for 5 Steps to Optimize MySQL Deep Pagination

5 Steps to Optimize MySQL Deep Pagination

Comments
4 min read
Building Trust in a Digital World: Why Transparency is Your Greatest Asset
Cover image for Building Trust in a Digital World: Why Transparency is Your Greatest Asset

Building Trust in a Digital World: Why Transparency is Your Greatest Asset

Comments
4 min read
I turned CSS in a SQL Database
Cover image for I turned CSS in a SQL Database

I turned CSS in a SQL Database

Comments 3
3 min read
📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

2
Comments
2 min read
Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘
Cover image for Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

Comments
2 min read
TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY
Cover image for TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

2
Comments
2 min read
🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches
Cover image for 🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

1
Comments
2 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers
Cover image for MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

Comments
2 min read
Mangle: Google's Bold Take on Database Programming

Mangle: Google's Bold Take on Database Programming

5
Comments 1
2 min read
Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead
Cover image for Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

Comments
3 min read
Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀
Cover image for Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀

Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀

6
Comments
3 min read
Database Indexing: The Hidden Key to Application Speed
Cover image for Database Indexing: The Hidden Key to Application Speed

Database Indexing: The Hidden Key to Application Speed

1
Comments
2 min read
🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡
Cover image for 🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡

🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡

18
Comments 10
7 min read
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures
Cover image for Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

1
Comments
11 min read
CRUD Operations in MongoDB for Beginners
Cover image for CRUD Operations in MongoDB for Beginners

CRUD Operations in MongoDB for Beginners

4
Comments
2 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
DataPump : Disabling the Use of Symbolic Links When Creating a Directory

DataPump : Disabling the Use of Symbolic Links When Creating a Directory

Comments
2 min read
From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL
Cover image for From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

Comments
4 min read
Handle Large PostgreSQL Schemas with a GUI Tool
Cover image for Handle Large PostgreSQL Schemas with a GUI Tool

Handle Large PostgreSQL Schemas with a GUI Tool

6
Comments
3 min read
Qantler interview Questions

Qantler interview Questions

5
Comments
1 min read
concat() vs Group_concat()

concat() vs Group_concat()

1
Comments
1 min read
SQLite dot commands: change directory command

SQLite dot commands: change directory command

1
Comments
1 min read
SQLite Scalar function: 3 valued iif and if scalar function

SQLite Scalar function: 3 valued iif and if scalar function

Comments
3 min read
Working with Cursors and Triggers in Oracle Live SQL

Working with Cursors and Triggers in Oracle Live SQL

3
Comments
2 min read
loading...