DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
SQLite doesn't enforce foreign keys by default, and it cost us three bugs
enderyentar profile

SQLite doesn't enforce foreign keys by default, and it cost us three bugs

#postgres #testing #python #database
Comments
4 min read
Data Modelling, Relationships & Joins in Power BI
9ichia profile

Data Modelling, Relationships & Joins in Power BI

#analytics #data #database
Comments 1
18 min read
Never Use a Display Name for Authorization: Secure Anonymous Editing
janarthanan_soundararajan profile

Never Use a Display Name for Authorization: Secure Anonymous Editing

#webdev #nextjs #database #architecture
2
Comments 1
5 min read
LazyDB is a terminal ui database client.
yelog profile

LazyDB is a terminal ui database client.

#tui #database #mcp #neovim
1
Comments
1 min read
Power BI Technical Article: Data Modelling, Relationships & Joins
sam_manox profile

Power BI Technical Article: Data Modelling, Relationships & Joins

#data #database #performance
1
Comments 1
12 min read
Practical SQL Query Optimization: From Slow Scans to Efficient Indexes
lucas_ventavele profile

Practical SQL Query Optimization: From Slow Scans to Efficient Indexes

#sql #database #backend #performance
Comments
5 min read
SQL Functions: Data Analysis just got better
ron-njuguna profile

SQL Functions: Data Analysis just got better

#data #database #sql
Comments
2 min read
SQL Subqueries and CTEs: Writing More Powerful Queries
ron-njuguna profile

SQL Subqueries and CTEs: Writing More Powerful Queries

#backend #database #sql #tutorial
Comments
2 min read
Local-First Sync, Done Right: Inside the SQLite Sync Stack
shivaysinghrajput profile

Local-First Sync, Done Right: Inside the SQLite Sync Stack

#sqlite #database #python #opensource
1
Comments 1
7 min read
Valkey 9.1's memory saving stops at 97 bytes, not the 128 in the release notes
remdore profile

Valkey 9.1's memory saving stops at 97 bytes, not the 128 in the release notes

#valkey #redis #database #performance
6
Comments
6 min read
DDL and DML
elizabeth_njoroge_7c850b9 profile

DDL and DML

#database #learning
Comments
3 min read
Redis in Production: What I Actually Configure
parsaaftabi profile

Redis in Production: What I Actually Configure

#redis #backend #devops #database
Comments
4 min read
Why Fast-Growing Products Develop Slow Databases
mick_michaels_b9eb profile

Why Fast-Growing Products Develop Slow Databases

#database #productgrowth #web3 #datamodel
Comments
7 min read
1,750 Pluses Later: The Query That Could Kill Every Connection at Once
aniket_3001 profile

1,750 Pluses Later: The Query That Could Kill Every Connection at Once

#showdev #rust #hackathonraptors #database
Comments
7 min read
Moving MultiXactOffset to 64 Bits in Postgres
islamov profile

Moving MultiXactOffset to 64 Bits in Postgres

#postgres #postgressql #database #opensource
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.