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.
தரவுத்தளம் எவ்வாறு உருவானது, அதன் தேவை என்ன? How did the database come about, What is its need?

தரவுத்தளம் எவ்வாறு உருவானது, அதன் தேவை என்ன? How did the database come about, What is its need?

Comments
1 min read
When and Why to Use JSON Columns in SQL Databases

When and Why to Use JSON Columns in SQL Databases

Comments
3 min read
How to Execute a SQL Statement on a Different Type of Database #eg74

How to Execute a SQL Statement on a Different Type of Database #eg74

5
Comments
1 min read
Three Tier Architecture. Overview and Each tier explained.

Three Tier Architecture. Overview and Each tier explained.

Comments
3 min read
Compound Trigger in Oracle SQL

Compound Trigger in Oracle SQL

Comments
3 min read
How to Create and Configure a Multi-VM Vagrant Setup for Web and Database Servers

How to Create and Configure a Multi-VM Vagrant Setup for Web and Database Servers

Comments
4 min read
Why should you use Docker

Why should you use Docker

1
Comments
3 min read
EXPLAIN PLAN & DBMS_PROFILER Explanation

EXPLAIN PLAN & DBMS_PROFILER Explanation

5
Comments
2 min read
ACID Properties in Databases: A Key to Data Integrity and Reliability

ACID Properties in Databases: A Key to Data Integrity and Reliability

Comments
4 min read
Unleash the Power of Data: The Hottest AWS Database Trends of 2024

Unleash the Power of Data: The Hottest AWS Database Trends of 2024

Comments
5 min read
Deep Dive into Dremio's File-based Auto Ingestion into Apache Iceberg Tables

Deep Dive into Dremio's File-based Auto Ingestion into Apache Iceberg Tables

Comments
13 min read
Effective Strategies for Writing Unit Tests with External Dependencies like Databases and APIs

Effective Strategies for Writing Unit Tests with External Dependencies like Databases and APIs

Comments
7 min read
Interview Questions | 10 most important distinctions between concepts in Oracle SQL

Interview Questions | 10 most important distinctions between concepts in Oracle SQL

Comments
2 min read
Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Comments
7 min read
CouchDB’s Favourite File Systems

CouchDB’s Favourite File Systems

Comments
3 min read
Move Data from Oracle to ClickHouse in Minutes

Move Data from Oracle to ClickHouse in Minutes

Comments
4 min read
The Prisma ORM: A Brief Overview and Introduction

The Prisma ORM: A Brief Overview and Introduction

3
Comments
9 min read
GBase数据库 | Understanding Cursor Variables in GBase 8s: Enhancing Database Operation Efficiency

GBase数据库 | Understanding Cursor Variables in GBase 8s: Enhancing Database Operation Efficiency

Comments
3 min read
GBase 数据库 | GBase 8a MPP Cluster Automatic Log Cleanup Implementation

GBase 数据库 | GBase 8a MPP Cluster Automatic Log Cleanup Implementation

Comments
2 min read
Using GenAI to Tackle Complex Prisma Model Migrations

Using GenAI to Tackle Complex Prisma Model Migrations

1
Comments 1
2 min read
Looking at How Replit Agent Handles Databases

Looking at How Replit Agent Handles Databases

Comments
7 min read
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

5
Comments
3 min read
Query optimization techniques in Short | Best Explanation

Query optimization techniques in Short | Best Explanation

Comments
1 min read
Postgres can do that? No surprise Postgres is everywhere

Postgres can do that? No surprise Postgres is everywhere

Comments
9 min read
OLAP (Online Analytical Processing)

OLAP (Online Analytical Processing)

9
Comments
3 min read
How to Run MongoDB in Docker

How to Run MongoDB in Docker

5
Comments
2 min read
Build your own Dynamo-like key/value database - Part 1 - TCP Server

Build your own Dynamo-like key/value database - Part 1 - TCP Server

1
Comments
8 min read
💡 Database Development: It’s Not Just About Querying!

💡 Database Development: It’s Not Just About Querying!

Comments
2 min read
Inside Database Management Tool

Inside Database Management Tool

Comments
4 min read
Customer Support RAG Assistant

Customer Support RAG Assistant

Comments
1 min read
GBASE数据库 | GBase 8c Enterprise Database Feature: Compatibility

GBASE数据库 | GBase 8c Enterprise Database Feature: Compatibility

Comments
4 min read
What you should know about CIDR in clear terms

What you should know about CIDR in clear terms

Comments
3 min read
Code Archeologist: AI-Powered Git Repository Analysis with PostgreSQL

Code Archeologist: AI-Powered Git Repository Analysis with PostgreSQL

Comments
4 min read
Sound Scape

Sound Scape

Comments
2 min read
GBASE数据库 | Introduction to GBase 8a Cluster Transparent Gateway and DBLINK Usage

GBASE数据库 | Introduction to GBase 8a Cluster Transparent Gateway and DBLINK Usage

5
Comments
15 min read
open-contribution

open-contribution

Comments
1 min read
GitCone.com: Chat with all the repositories from this challenge, or with any other repository

GitCone.com: Chat with all the repositories from this challenge, or with any other repository

Comments
2 min read
Master Advanced LINQ in C#: Writing Ultra-Efficient Queries for Massive Datasets

Master Advanced LINQ in C#: Writing Ultra-Efficient Queries for Massive Datasets

Comments
3 min read
Buddy Fit: The Ultimate AI Weightlifting Companion Powered by Dr. Mike Israetel and Jeff Nippard

Buddy Fit: The Ultimate AI Weightlifting Companion Powered by Dr. Mike Israetel and Jeff Nippard

Comments
6 min read
StarSense - new way of interacting with repos

StarSense - new way of interacting with repos

Comments
2 min read
Database Sharding: Simplifying Data Scalability

Database Sharding: Simplifying Data Scalability

Comments
7 min read
Data Pipeline Filters 101: Choosing Between Static and Dynamic Approaches

Data Pipeline Filters 101: Choosing Between Static and Dynamic Approaches

Comments
1 min read
Making the Ivorian Labor Code Accessible and Understandable through the RAG System

Making the Ivorian Labor Code Accessible and Understandable through the RAG System

Comments
2 min read
How I Went From Being a DBA to DevOps Engineer

How I Went From Being a DBA to DevOps Engineer

Comments
1 min read
GBASE数据库 | GBase 8a MPP Cluster Cluster Management Tool (2)

GBASE数据库 | GBase 8a MPP Cluster Cluster Management Tool (2)

9
Comments
11 min read
Code Review Assistant using Open Source AI Challenge with pgai and Ollama