Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

沈欢

Apr 12

Parse Oracle SQL in VS Code with Gudu SQL Omni

#database #sql #tooling #vscode

3 min read

May 15

ORM library Ujorm 3.0 is released

#news #database #java #sql

1 min read

soy

Apr 10

PostgreSQL O(delta) MV Refreshes, pg_lake for Data Lakes, & ADBC for Columnar Data

#database #sql #sqlite

3 min read

Ashish Srivastava

Apr 10

🚀 DB Explorer 3.0.1 — The AI‑First SQL Editor You’ll Want to Try

#sql #database #postgres #dataengineering

1 min read

Philip McClarence

Apr 10

PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search

#database #performance #postgres #sql

4 min read

rgt0

Apr 10

hi all!

#ai #programming #cobol #sql

1 min read

Novice Mk

Apr 14

The Restart Challenge: Day 02

#devjournal #django #learning #sql

1 min read

soy

Apr 9

SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

#database #sql #sqlite

3 min read

Apr 9

🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

#beginners #database #mysql #sql

2 min read

May 13

We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime

#dotnet #sql #postgres #architecture

5 min read

Apr 9

System Design Learning Journey — Week 2: Storage & Retrieval

#systemdesign #sql #database #scala

3 min read

Philip McClarence

Apr 9

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql

4 min read

Apr 9

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

#beginners #database #mysql #sql

2 min read

Apr 22

UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

#sql #database #python #beginners

2 min read

May 12

Set-Based Updates in Rails: 4 Hours to 8 Seconds

#rails #sql #performance #ruby

5 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.