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.
Why Transactional Databases Matter: Concepts, Use Cases, and Examples
rizkytegar profile

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

#sql #database
2
Comments 2
3 min read
Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping
driessamyn profile

Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping

#java #kotlin #sql #kapper
Comments 1
4 min read
Substring from a Column of Strings — From SQL to SPL #25
judith677 profile

Substring from a Column of Strings — From SQL to SPL #25

#programming #database #sql #esprocspl
5
Comments 1
2 min read
🛡️ Examining the Database in SQL Injection Attacks
onyxwizard profile

🛡️ Examining the Database in SQL Injection Attacks

#sql #hacktoberfest #cybersecurity #webdev
Comments 1
4 min read
Total under Recursive Relationship — From SQL to SPL #33
judith677 profile

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl
7
Comments 1
2 min read
Navigating the Landscape of Data-Modeling – A Comprehensive Guide
chaets profile

Navigating the Landscape of Data-Modeling – A Comprehensive Guide

#database #datamodel #dataworld #sql
Comments 3
4 min read
Read-Only Session in Oracle AI Database 26ai
vahidusefzadeh profile

Read-Only Session in Oracle AI Database 26ai

#news #database #security #sql
Comments
1 min read
How to install PostgreSQL on macOS: Step-by-Step Instructions
saif_uddin profile

How to install PostgreSQL on macOS: Step-by-Step Instructions

#sql #postgressql #programming #database
Comments
1 min read
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App
aomuiz profile

Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

#webdev #reactnative #react #sql
2
Comments
4 min read
Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)
mandarg13 profile

Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)

#sql #postgres #database #softwareengineering
Comments
7 min read
How to Handle Millions of Rows in SQL Without Killing Performance
jhonifaber profile

How to Handle Millions of Rows in SQL Without Killing Performance

#database #sql #performance
29
Comments 1
2 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference
op3ratordec profile

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

#postgres #mysql #sql #database
5
Comments 1
4 min read
Open-source Node.js blogging engine with newsletter functionality
maxim-fin profile

Open-source Node.js blogging engine with newsletter functionality

#webdev #node #javascript #sql
1
Comments
1 min read
DuckDB 1.20 Released! Exploring the New Features
nk_maker profile

DuckDB 1.20 Released! Exploring the New Features

#duckdb #sql #csv
Comments
4 min read
#34 50 Advanced SQL Queries Every Developer Should Know
flnzba profile

#34 50 Advanced SQL Queries Every Developer Should Know

#sql #database #dataengineering
2
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.