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
mrcaption49 profile

Statement Level Trigger vs Row Level Trigger

#sql #webdev #database #devops
5
Comments
2 min read
The Amazing SQL Recursive Queries
freakynit profile

The Amazing SQL Recursive Queries

#sql #recursive #awesome
Comments
3 min read
How to Install PostgreSQL on Ubuntu 22.04 LTS
aditi_b profile

How to Install PostgreSQL on Ubuntu 22.04 LTS

#postgres #database #sql #webdev
3
Comments
10 min read
AI-Driven SQL Query Optimization and Big Data Integration
dishantsinghdev profile

AI-Driven SQL Query Optimization and Big Data Integration

#ai #sql #ainsql #query
2
Comments
3 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
grahamthedev profile

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

#mysql #sql #webdev #programming
35
Comments 7
4 min read
Day 2 of SQL Series || Basic Commands
akshat0610 profile

Day 2 of SQL Series || Basic Commands

#sql #tutorial #beginners #mysql
9
Comments
3 min read
TrailBase: Building an App with UI, Admin Dash and Vector Search in ~100 Lines
trailbase profile

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

#sql #programming #typescript #rust
Comments
6 min read
Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications
dishantsinghdev profile

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

#tutorial #sql #sqlcompiler #sqlserver
1
Comments
4 min read
Populating a Vertica Database with Random Data
dm8ry profile

Populating a Vertica Database with Random Data

#database #devops #sql #productivity
Comments
4 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤
grahamthedev profile

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

#mysql #webdev #sql #programming
34
Comments 9
13 min read
ACID Transactions in System Design
jaiminbariya profile

ACID Transactions in System Design

#systemdesign #database #sql #career
3
Comments 1
5 min read
Exploring Microsoft SQL Server: Powering Enterprise Data Management
jing_li profile

Exploring Microsoft SQL Server: Powering Enterprise Data Management

#sql #opensource #ai #chatgpt
Comments
10 min read
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON
adityabhuyan profile

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

#sql #mysql #json #bestpractices
Comments
5 min read
Day 1 SQL Series || Introduction to SQL
akshat0610 profile

Day 1 SQL Series || Introduction to SQL

#webdev #database #sql #beginners
17
Comments 1
3 min read
lowCalAlt_update1
itsizakb profile

lowCalAlt_update1

#database #learning #python #sql
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.