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.
What is the CASE Statement in sql?
rashtech profile

What is the CASE Statement in sql?

#sql #database #analyst #programming
5
Comments
2 min read
Spring JDBC: Where Java Meets the Database, with a Dash of Humor!
tyagi_data_wizard profile

Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

#tutorial #springboot #database #java
6
Comments
3 min read
Easy tips to reduce MongoDB database size in no time
mknasiecki profile

Easy tips to reduce MongoDB database size in no time

#mongodb #database #json #nosql
1
Comments
4 min read
PostgreSQL Internals: A Deep Dive into the Inner Workings of a Powerful Relational Database
k1hara profile

PostgreSQL Internals: A Deep Dive into the Inner Workings of a Powerful Relational Database

#postgres #sql #database
11
Comments
3 min read
How to prevent database problems from hitting production?
adammetis profile

How to prevent database problems from hitting production?

#sql #database #postgres
Comments
10 min read
Foreign Keys on Distributed SQL: don't worry, it scales
franckpachot profile

Foreign Keys on Distributed SQL: don't worry, it scales

#yugabytedb #distributed #postgres #database
2
Comments
6 min read
Indexes 101: What They Are, Why They Matter, and How to Use Them in PostgreSQL
adii9 profile

Indexes 101: What They Are, Why They Matter, and How to Use Them in PostgreSQL

#database #performance #sql #coding
2
Comments
6 min read
Data Modelling In AGE:Common Data Modelling Mistakes To Avoid
namsi profile

Data Modelling In AGE:Common Data Modelling Mistakes To Avoid

#database #postgres #apacheage #graphdatabase
Comments
2 min read
Triggers in SQL database to extend its declarative data logic (but not business logic)
franckpachot profile

Triggers in SQL database to extend its declarative data logic (but not business logic)

#yugabytedb #distributed #sql #database
1
Comments
5 min read
CAP Theorem
aldoportillo profile

CAP Theorem

#systemdesign #database #mongodb #distributedsystems
3
Comments 1
2 min read
How To Write SQL Statements That Are Migratable Between Databases
jbx1279 profile

How To Write SQL Statements That Are Migratable Between Databases

#sql #database #appllication #webdev
5
Comments
4 min read
PostgreSQL's Emerging Role in Decentralized Applications(DApps)
pawnsapprentice profile

PostgreSQL's Emerging Role in Decentralized Applications(DApps)

#postgres #apacheage #database
3
Comments 1
3 min read
PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore
pawnsapprentice profile

PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

#postgres #database #apacheage
2
Comments
3 min read
Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries
k1hara profile

Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

#postgres #database #apacheage #sql
Comments
2 min read
PostgreSQL: script to connect to DB, and get tables, their records number and size.
dm8ry profile

PostgreSQL: script to connect to DB, and get tables, their records number and size.

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