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.
Statement Level Trigger vs Row Level Trigger

Statement Level Trigger vs Row Level Trigger

6
Comments
2 min read
The Amazing SQL Recursive Queries

The Amazing SQL Recursive Queries

Comments
3 min read
How to Install PostgreSQL on Ubuntu 22.04 LTS

How to Install PostgreSQL on Ubuntu 22.04 LTS

3
Comments
10 min read
AI-Driven SQL Query Optimization and Big Data Integration

AI-Driven SQL Query Optimization and Big Data Integration

1
Comments
3 min read
A Comparison of Top Private and Browser Based SQL on CSV Tools

A Comparison of Top Private and Browser Based SQL on CSV Tools

1
Comments
3 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

34
Comments 7
4 min read
Day 2 of SQL Series || Basic Commands

Day 2 of SQL Series || Basic Commands

9
Comments
3 min read
TrailBase: Building an App with UI, Admin Dash and Vector Search in ~100 Lines

TrailBase: Building an App with UI, Admin Dash and Vector Search in ~100 Lines

Comments
6 min read
Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Comments
4 min read
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 min read
ACID Transactions in System Design

ACID Transactions in System Design

3
Comments 1
5 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

33
Comments 9
13 min read
Exploring Microsoft SQL Server: Powering Enterprise Data Management

Exploring Microsoft SQL Server: Powering Enterprise Data Management

Comments
10 min read
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Comments
5 min read
Day 1 SQL Series || Introduction to SQL

Day 1 SQL Series || Introduction to SQL

17
Comments 1
3 min read
lowCalAlt_update1

lowCalAlt_update1

Comments
1 min read
Automating API endpoint testing with Spin

Automating API endpoint testing with Spin

1
Comments
5 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 min read
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

Comments
3 min read
Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

1
Comments
2 min read
Factory Design Pattern - Creational Design Pattern

Factory Design Pattern - Creational Design Pattern

Comments
3 min read
How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

10
Comments
10 min read
Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Comments
6 min read
How to Secure Web Applications: Top Security Practices

How to Secure Web Applications: Top Security Practices

Comments
3 min read
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 min read
loading...