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.
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
Automating API endpoint testing with Spin
jasminempa profile

Automating API endpoint testing with Spin

#api #sql #github
1
Comments
5 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance
sshamza profile

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

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

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

#java #beginners #sql #hibernate
8
Comments
2 min read
Factory Design Pattern - Creational Design Pattern
aryaglekshmi profile

Factory Design Pattern - Creational Design Pattern

#design #designpatterns #backend #sql
Comments
3 min read
How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4
op3ratordec profile

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

#programming #productivity #database #sql
10
Comments
10 min read
Database Normalization
aryaglekshmi profile

Database Normalization

#database #sql #postgres #mysql
2
Comments
4 min read
Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚
mrchike profile

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

#django #react #sql #webdev
Comments
6 min read
Entity Relationship Diagram[ERD]
aryaglekshmi profile

Entity Relationship Diagram[ERD]

#entity #backend #sql #programming
1
Comments
2 min read
How to Secure Web Applications: Top Security Practices
patoliyainfotech profile

How to Secure Web Applications: Top Security Practices

#web #xss #api #sql
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.