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.

Pure Life Tribe

Jun 10

SQL Explorer: Run Full SQL on CSV, Parquet & JSONL Files in Your Browser

#showdev #database #sql #tooling

2 min read

soy

Jun 9

DuckDB Delta Lake Writes, Cross-DB Query Planning, and Pterocos SQLite/DuckDB Editor

#database #sql #sqlite

3 min read

umzzil nng

Jun 10

PostgreSQL 2201X Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql

3 min read

ts5432

Jun 10

Delete record using JooqTemplate

#database #java #sql #tutorial

1 min read

Jun 9

SQL Formatting Best Practices: A Practical Guide for Engineers

#sql #database #webdev #productivity

4 min read

Jun 8

REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them

#dotnet #postgres #sql #opensource

20 min read

Jun 9

QN : Ingest and transform data in a lakehouse

#architecture #database #dataengineering #sql

2 min read

soy

Jun 8

DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

#database #sql #sqlite

4 min read

ts5432

Jun 9

Update record using JooqTemplate

#database #java #sql #tutorial

1 min read

Zenovay

Jun 8

Retention cohort analysis with plain SQL

#sql #analytics #database #webdev

2 min read

umzzil nng

Jun 9

PostgreSQL 22013 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql

3 min read

Jun 8

T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

#backend #database #postgres #sql

1 min read

Tzvi Gregory Kaidanov

Jun 8

Dynamically Generating SQL Joins for Tables Based on a Common Column

#dba #sql #tutorial #productivity

7 min read

Jun 8

Running Real SQL on DynamoDB: How It Actually Works

#programming #sql #dynamodb #aws

8 min read

Lê Đình Phú

Jun 8

Why Big Tech is Migrating from Traditional Databases to NewSQL

#bigdata #dataengineering #database #sql

1 min read

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