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
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
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
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
Data Types and So much more
jomiedu profile

Data Types and So much more

#backend #database #sql
Comments
2 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
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
AWS retired its free database migration assessment tool. The reason should change how you build developer tools.
sajjasudhakararao profile

AWS retired its free database migration assessment tool. The reason should change how you build developer tools.

#database #python #sql #opensource
Comments 5
10 min read
Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.
votiakov profile

Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

#bigquery #gcp #dataengineering #sql
Comments 1
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.