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.
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
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
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
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
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
BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL
jedidah_ondiso_887753d76e profile

BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

#backend #database #sql #tutorial
1
Comments
5 min read
Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning
ameer_abdullah_68d48c8496 profile

Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

#sql #datascience #software #saas
1
Comments
3 min read
SQLite vs PostgreSQL: Choosing the Right Database
qingluan profile
qing

SQLite vs PostgreSQL: Choosing the Right Database

#database #sql #tutorial #programming
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.