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.
Stop Optimizing the Wrong Things: Practical Database Optimization Techniques Every Backend Developer Should Know
alihaider8014 profile

Stop Optimizing the Wrong Things: Practical Database Optimization Techniques Every Backend Developer Should Know

#database #queryoptimization #webdev #performance
Comments
3 min read
UNDERSTANDING DATA MODELING, SCHEMAS, RELATIONSHIPS, AND JOINS.
magichu_njoroge_9123627a6 profile

UNDERSTANDING DATA MODELING, SCHEMAS, RELATIONSHIPS, AND JOINS.

#beginners #database #microsoft #tutorial
1
Comments
6 min read
Article on Modelling, Joins, Relationships and Different Schemas In Power BI
waithakajoseph profile

Article on Modelling, Joins, Relationships and Different Schemas In Power BI

#analytics #architecture #data #database
Comments
3 min read
Can Databricks LTAP Actually Run OLTP and OLAP at the Same Time?
itay_waisman_fc21bb7d2a3a profile

Can Databricks LTAP Actually Run OLTP and OLAP at the Same Time?

#ltap #database #postgressql #distributedsystems
Comments
5 min read
Day 50 - How to Migrate Data from MySQL to ClickHouse®: A Step-by-Step Guide
kanishga_subramani_49ad73 profile

Day 50 - How to Migrate Data from MySQL to ClickHouse®: A Step-by-Step Guide

#clickhouse #devops #database #dataengineering
1
Comments
5 min read
Credit Billing Without Transactions: 4 Race Conditions I Hit on Serverless Postgres
xiaojun_mao_c154743594bc9 profile

Credit Billing Without Transactions: 4 Race Conditions I Hit on Serverless Postgres

#postgres #webdev #saas #database
Comments 3
6 min read
My first SQL interaction
mohammad_meezan profile

My first SQL interaction

#beginners #codenewbie #database #sql
Comments
2 min read
From My Machine to the Cloud: Connecting Power BI to SQL Databases; PostgreSQL (Local vs Aiven)
neema_kirui profile

From My Machine to the Cloud: Connecting Power BI to SQL Databases; PostgreSQL (Local vs Aiven)

#postgres #database #analytics #datascience
1
Comments
3 min read
Co-locating Data and Application Code for a 4.5x Performance Gain
kamleshbambarde profile

Co-locating Data and Application Code for a 4.5x Performance Gain

#architecture #database #performance #datastardev
Comments
6 min read
Correlated Subqueries Explained: From Confusing to Intuitive
saamiabbaskhan profile

Correlated Subqueries Explained: From Confusing to Intuitive

#sql #database #mysql #leetcode
6
Comments 2
12 min read
How I built an offline semantic photo search app (Python + Vector DB)
sreegeetheshdhananjayan profile

How I built an offline semantic photo search app (Python + Vector DB)

#showdev #ai #database #python
Comments
1 min read
Stop Double-Booking: Optimistic Locking in Laravel
iprajapatiparesh profile

Stop Double-Booking: Optimistic Locking in Laravel

#laravel #database #architecture #backend
Comments
3 min read
🗄️ How Does a Database Work for Multiple Users? A Beginner's Guide
charan_gutti_cf60c6185074 profile

🗄️ How Does a Database Work for Multiple Users? A Beginner's Guide

#database #beginners #architecture #learning
1
Comments
3 min read
I Built a Global Opinion Platform in 72 Hours — Here Is What Actually Went Wrong
hafiz_muhammadsalman_f28 profile

I Built a Global Opinion Platform in 72 Hours — Here Is What Actually Went Wrong

#showdev #architecture #aws #database
Comments
4 min read
Built-in authentication and authorization for Manticore Search
sanikolaev profile

Built-in authentication and authorization for Manticore Search

#backend #database #search #security
3
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.