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.
Understanding the Difference Between Tables and Views (Bite-size Article)

Understanding the Difference Between Tables and Views (Bite-size Article)

Comments
4 min read
The main tasks of a Database Administrator (DBA) by 2025

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

Comments
27 min read
SQLite dot commands: Output mode

SQLite dot commands: Output mode

Comments
9 min read
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
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

6
Comments
5 min read
Automating Old Partition Cleanup in Oracle with PL/SQL

Automating Old Partition Cleanup in Oracle with PL/SQL

6
Comments
3 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

Comments
2 min read
Building SW: Lessons from the Backend

Building SW: Lessons from the Backend

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

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

Comments
3 min read
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

1
Comments
11 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
Associações polimórficas no Rails: como fazer, prós e contras

Associações polimórficas no Rails: como fazer, prós e contras

16
Comments 3
4 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
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

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

1
Comments
4 min read
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
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

2
Comments
8 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
From SQL to Python: Uniting Stored Power with Functional Flexibility

From SQL to Python: Uniting Stored Power with Functional Flexibility

Comments
5 min read
Choosing Between On-Premises and Cloud SQL Hosting: What Businesses Should Consider

Choosing Between On-Premises and Cloud SQL Hosting: What Businesses Should Consider

Comments
2 min read
🔥 Stop Wasting Time With REST – Build Real-Time Apps with SQL Over WebSockets!

🔥 Stop Wasting Time With REST – Build Real-Time Apps with SQL Over WebSockets!

Comments
4 min read
loading...