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.
LLaVA-o1: Transforming How We Think with Visual Language Models (VLMs)

LLaVA-o1: Transforming How We Think with Visual Language Models (VLMs)

1
Comments
6 min read
How to import excel into access only 1 step

How to import excel into access only 1 step

Comments
2 min read
Amazon Redshift now supports refresh interval in a zero-ETL integration

Amazon Redshift now supports refresh interval in a zero-ETL integration

1
Comments
2 min read
Vector Search and Semantic Search in Depth

Vector Search and Semantic Search in Depth

25
Comments
2 min read
Filament Database Notification Sound

Filament Database Notification Sound

Comments
1 min read
The Most Common Types of Databases in IT Today

The Most Common Types of Databases in IT Today

Comments
8 min read
AWS Database - Part 1: AWS RDS

AWS Database - Part 1: AWS RDS

3
Comments
9 min read
In-Memory Databases vs. Relational Databases: Key Advantages and Use Cases

In-Memory Databases vs. Relational Databases: Key Advantages and Use Cases

Comments
7 min read
Mastering Data Analytics: The Ultimate Guide to Data Analysis

Mastering Data Analytics: The Ultimate Guide to Data Analysis

Comments
5 min read
Overcoming MongoDB Limitations with Fauna

Overcoming MongoDB Limitations with Fauna

Comments
6 min read
How to choose the right database?

How to choose the right database?

Comments
4 min read
MongoDB Atlas

MongoDB Atlas

1
Comments
2 min read
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 min read
Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

Comments 1
4 min read
Benchmarking Crunchy Data for latency

Benchmarking Crunchy Data for latency

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

The Prisma ORM: A Brief Overview and Introduction

4
Comments
9 min read
SQL Queries Execution Order

SQL Queries Execution Order

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

When and Why to Use JSON Columns in SQL Databases

1
Comments
3 min read
What's behind the Call Home option?

What's behind the Call Home option?

1
Comments
2 min read
Working of SQL*Loader

Working of SQL*Loader

5
Comments
2 min read
Compound Trigger in Oracle SQL

Compound Trigger in Oracle SQL

5
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

1
Comments
4 min read
OLAP (Online Analytical Processing)

OLAP (Online Analytical Processing)

5
Comments
3 min read
How to Run MongoDB in Docker

How to Run MongoDB in Docker

3
Comments
2 min read
Bloom Filters

Bloom Filters

Comments
4 min read
EXPLAIN PLAN & DBMS_PROFILER Explanation

EXPLAIN PLAN & DBMS_PROFILER Explanation

5
Comments
2 min read
Inside Database Management Tool

Inside Database Management Tool

Comments
4 min read
Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Comments
3 min read
Visualizing Data with Amazon QuickSight

Visualizing Data with Amazon QuickSight

Comments
3 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
T-SQL

T-SQL

Comments
2 min read
ChartDB: From Zero to 1.5K GitHub Stars in 3 Days - Here’s How 🚀⭐️

ChartDB: From Zero to 1.5K GitHub Stars in 3 Days - Here’s How 🚀⭐️

213
Comments 29
3 min read
Freeware: Java Utility Package (Version 2024.10.26) released

Freeware: Java Utility Package (Version 2024.10.26) released

1
Comments
1 min read
Geolocation in web apps made easy with haversine

Geolocation in web apps made easy with haversine

2
Comments
4 min read
From LEGO Bricks to Data Blocks: Adventures with PromptQL

From LEGO Bricks to Data Blocks: Adventures with PromptQL

29
Comments 2
7 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

1
Comments
13 min read
Ollama chatbot with vercel ai with pgai, pgvector.

Ollama chatbot with vercel ai with pgai, pgvector.

14
Comments
4 min read
DearBook: Create Magical Illustrated Children's Stories with AI

DearBook: Create Magical Illustrated Children's Stories with AI

48
Comments 3
5 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 1
7 min read
Technical Interview Questions - Part 4 - Git + SQL vs noSQL

Technical Interview Questions - Part 4 - Git + SQL vs noSQL

3
Comments
3 min read
Data Lake Architecture: Building Flexible, Scalable Data Solutions

Data Lake Architecture: Building Flexible, Scalable Data Solutions

2
Comments
9 min read
CouchDB’s Favourite File Systems

CouchDB’s Favourite File Systems

Comments
3 min read
GBase数据库 | Quick Setup Guide for GBase 8s SSC Shared Storage Cluster

GBase数据库 | Quick Setup Guide for GBase 8s SSC Shared Storage Cluster

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

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

6
Comments
2 min read
SQL: The Backbone of Modern Data Management

SQL: The Backbone of Modern Data Management

Comments
5 min read
Getting positions of members according to primary key values #eg58

Getting positions of members according to primary key values #eg58

6
Comments
1 min read
Simplify serverless scaling and data management with Fauna and Cloudflare Workers

Simplify serverless scaling and data management with Fauna and Cloudflare Workers

2
Comments
4 min read
Unlock the Power of Database Management: 8 Free Tutorials for Aspiring Data Professionals

Unlock the Power of Database Management: 8 Free Tutorials for Aspiring Data Professionals

Comments
3 min read
Looking at How Replit Agent Handles Databases

Looking at How Replit Agent Handles Databases

2
Comments
7 min read
SQL for Data Validation: Implementing Business Rules and Constraints

SQL for Data Validation: Implementing Business Rules and Constraints

1
Comments
5 min read
Infamous N+1 Query Problem with Entity Framework Core

Infamous N+1 Query Problem with Entity Framework Core

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

Postgres can do that? No surprise Postgres is everywhere

1
Comments
9 min read
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

Comments
5 min read
Statement Timeout in PostgreSQL

Statement Timeout in PostgreSQL

Comments
4 min read
GBase 8c Distributed Cluster Backup Principles and Impact

GBase 8c Distributed Cluster Backup Principles and Impact

Comments
4 min read
Introduction to GBase 8s Locking and Concurrency Transaction Scheduling

Introduction to GBase 8s Locking and Concurrency Transaction Scheduling

Comments
5 min read
UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

10
Comments
3 min read
Build a Scalable AMQP-Based Messaging Framework on MongoDB in 5 Steps

Build a Scalable AMQP-Based Messaging Framework on MongoDB in 5 Steps

Comments
5 min read
[PT_BR] Repositório Genérico com Dapper.Contrib

[PT_BR] Repositório Genérico com Dapper.Contrib

Comments
4 min read
Code Structure with Dapper and Dapper.Contrib

Code Structure with Dapper and Dapper.Contrib

Comments
3 min read
loading...