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.
Advanced SQL: Mastering CTEs and Window Functions
rahmanfrr profile
Rahman

Advanced SQL: Mastering CTEs and Window Functions

#sql #database #programming #tutorial
Comments
3 min read
pg_anon caught 1 of my 8 PII columns. My schema isn't in English.
efraingaray profile

pg_anon caught 1 of my 8 PII columns. My schema isn't in English.

#postgres #database #security #programming
Comments
3 min read
Detecting Ceph LARGE_OMAP_OBJECTS Before Deep Scrub Finds It
vexsx profile

Detecting Ceph LARGE_OMAP_OBJECTS Before Deep Scrub Finds It

#database #devops #infrastructure #sre
Comments
19 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)
zgl20053779 profile

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)

#automation #database #opensource #sql
Comments
5 min read
Track your GCP bill from your own dashboard: billing export plus two SQL queries
takahiro_hashito_a1f3f0dc profile

Track your GCP bill from your own dashboard: billing export plus two SQL queries

#googlecloud #database #devops
Comments
3 min read
How to Query CSV Files with Natural Language Locally (No Cloud Uploads)
veilanalytics profile

How to Query CSV Files with Natural Language Locally (No Cloud Uploads)

#webdev #database #python #privacy
Comments
2 min read
Auditing 857,655 Open Food Facts labels with pandas: how many nutrition facts contradict themselves?
leanapp profile

Auditing 857,655 Open Food Facts labels with pandas: how many nutrition facts contradict themselves?

#data #database #python
Comments
3 min read
I Replaced My Entire Dependency Tree With the Standard Library (And Built a Quant Database)
rishi_bharadwaj_bf8a76182 profile

I Replaced My Entire Dependency Tree With the Standard Library (And Built a Quant Database)

#rust #database #performance #systems
6
Comments
7 min read
AI-Assisted Database Development: Real Stats, Tools, and Tactics 2026
nlocoding profile

AI-Assisted Database Development: Real Stats, Tools, and Tactics 2026

#ai #database
Comments
5 min read
Text to SQL Without Sending Data to OpenAI (Local DuckDB & Ollama Setup)
veilanalytics profile

Text to SQL Without Sending Data to OpenAI (Local DuckDB & Ollama Setup)

#database #privacy #javascript #ai
Comments
2 min read
I Built My Own Budget Tracker - Because I Didn't Want to Pay a Monthly Subscription
rishikumar_yadav profile

I Built My Own Budget Tracker - Because I Didn't Want to Pay a Monthly Subscription

#webdev #database #programming #php
Comments
6 min read
Building an Interactive Excel Dashboard for E-commerce Product Analysis , A Jumia case Study
david_gitonga_2983 profile

Building an Interactive Excel Dashboard for E-commerce Product Analysis , A Jumia case Study

#analytics #git #opensource #database
Comments
3 min read
Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion
zgl20053779 profile

Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion

#automation #database #opensource #sql
1
Comments 1
2 min read
A compaction strategy is a bet about your workload
saqibameen86 profile

A compaction strategy is a bet about your workload

#cassandra #performance #database #operations
Comments
3 min read
Repair at 1,000 nodes: why we stopped running nodetool repair by hand
saqibameen86 profile

Repair at 1,000 nodes: why we stopped running nodetool repair by hand

#cassandra #operations #distributed #database
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.