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.
Tối ưu hóa cơ sở dữ liệu SQL trên máy chủ mã nguồn mở: Nghệ thuật của sự tinh giản
phantam38 profile

Tối ưu hóa cơ sở dữ liệu SQL trên máy chủ mã nguồn mở: Nghệ thuật của sự tinh giản

#sql #server
Comments
8 min read
Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)
joy_mbugua_f9c6ecc05289ef profile

Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)

#sql #postgres #database #github
2
Comments
3 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles
kostyabartashevich profile

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles

#azure #database #sql #architecture
Comments
5 min read
How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses
zubair_iftikhar profile

How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses

#javascript #productivity #python #sql
2
Comments
8 min read
The Fastest Way to Add Reporting to Your Internal Tool
vivekdraxlr profile

The Fastest Way to Add Reporting to Your Internal Tool

#sql #database #webdev #productivity
1
Comments
6 min read
SQL Design & Query Reference
andreimerlescu profile

SQL Design & Query Reference

#webdev #sql #tutorial #ai
1
Comments 1
35 min read
The Afternoon We Put Magento's Schema on SQL Server
andreimerlescu profile

The Afternoon We Put Magento's Schema on SQL Server

#sql #beginners #webdev #programming
1
Comments
40 min read
Top N per group is the query `LIMIT` can't write
omer_hochman profile

Top N per group is the query `LIMIT` can't write

#sql #database #webdev
Comments
3 min read
Український лематизатор тепер вбудовано в Manticore Search
sanikolaev profile

Український лематизатор тепер вбудовано в Manticore Search

#news #database #nlp #sql
Comments
1 min read
Building an Analytics Layer on Top of Your Existing Database
vivekdraxlr profile

Building an Analytics Layer on Top of Your Existing Database

#sql #database #analytics #webdev
Comments
5 min read
Stop Pasting Your Database Schema Into Every AI Prompt
siddharth_pandey_27 profile

Stop Pasting Your Database Schema Into Every AI Prompt

#opensource #typescript #ai #sql
1
Comments 2
5 min read
Why I Built a Free SSMS Extension to Stop Destructive Queries
manuelenzo profile

Why I Built a Free SSMS Extension to Stop Destructive Queries

#database #security #sql #tools
Comments 2
3 min read
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive
soytuber profile
soy

DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive

#database #sql #sqlite
Comments
3 min read
PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.
polliog profile

PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.

#postgres #database #performance #sql
17
Comments 3
7 min read
ERD-First Database Design: One 60-Entity Schema, Sketch to Production
tbson87 profile

ERD-First Database Design: One 60-Entity Schema, Sketch to Production

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