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.
Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7
soytuber profile
soy

Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7

#database #sql #sqlite #opensource
Comments
4 min read
How to write a cohort retention query in SQL (that actually runs)
sofrito profile

How to write a cohort retention query in SQL (that actually runs)

#sql #analytics #database #datascience
Comments
3 min read
Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It
srmadscience profile

Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It

#database #search #sql
2
Comments 4
9 min read
Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics
alexcrazy74 profile

Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics

#ai #sql #programming #rdbms
Comments 1
4 min read
Tracking Tableau Server Storage Over Time with PostgreSQL
jungalung profile

Tracking Tableau Server Storage Over Time with PostgreSQL

#postgres #sql #tableau #datavisualiszation
Comments
2 min read
SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows
michaelnocito profile

SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows

#sql #database #tutorial #beginners
Comments 1
17 min read
That VARCHAR(255) Was Never a Decision. It Was a Default.
speccoding profile

That VARCHAR(255) Was Never a Decision. It Was a Default.

#database #sql #postgres #programming
Comments 1
4 min read
SQL Aliases: How to Read a Query Out Loud
michaelnocito profile

SQL Aliases: How to Read a Query Out Loud

#sql #database #tutorial #beginners
Comments
13 min read
Solon Data SQL: Three Layers of Data Access Without the Bloat
solonjava profile

Solon Data SQL: Three Layers of Data Access Without the Bloat

#architecture #database #java #sql
Comments 3
5 min read
Why schema drift goes undetected
eggletric profile

Why schema drift goes undetected

#database #postgres #devops #sql
Comments 2
7 min read
SQL vs NoSQL: A Simple Guide to Picking the Right Database
danishrazabangash profile

SQL vs NoSQL: A Simple Guide to Picking the Right Database

#systemdesign #database #sql #mongodb
Comments
2 min read
Building SaarDB, Part 6: How SQL Queries Become Key-Value Operations
gagandeepahuja09 profile

Building SaarDB, Part 6: How SQL Queries Become Key-Value Operations

#architecture #database #go #sql
2
Comments
9 min read
Data Types and So much more
jomiedu profile

Data Types and So much more

#backend #database #sql
Comments
2 min read
Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)
azhadsuhaimi profile

Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)

#sql #database #performance
Comments 1
2 min read
How to compare two PostgreSQL schemas
eggletric profile

How to compare two PostgreSQL schemas

#postgres #database #sql #bash
1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.