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.
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

15
Comments
4 min read
How To Convert a SQL Query Into C# LINQ

How To Convert a SQL Query Into C# LINQ

6
Comments
8 min read
ClickHouse is fast, esProc SPL is faster

ClickHouse is fast, esProc SPL is faster

1
Comments
10 min read
Build a micro-blogging app with Tigris Database & Search, tRPC and Next.js - Part 1

Build a micro-blogging app with Tigris Database & Search, tRPC and Next.js - Part 1

Comments
20 min read
Exposing Databases to the Internet: Seriously?

Exposing Databases to the Internet: Seriously?

32
Comments 4
5 min read
How to get Started with Data And Help Your Community

How to get Started with Data And Help Your Community

2
Comments
5 min read
Aurora Serverless V1 to V2 Migration

Aurora Serverless V1 to V2 Migration

1
Comments
3 min read
Install and use Postgres in WSL

Install and use Postgres in WSL

67
Comments 7
3 min read
Avoid a Malicious Attack MongoDB: How It Happened and What We Did About It.

Avoid a Malicious Attack MongoDB: How It Happened and What We Did About It.

7
Comments 6
2 min read
Use Prisma with an SQLite DATETIME datatype

Use Prisma with an SQLite DATETIME datatype

1
Comments
4 min read
Exploring the Postgres Internals: A Guide for Database Admins and System Developers (Part 1)

Exploring the Postgres Internals: A Guide for Database Admins and System Developers (Part 1)

2
Comments
3 min read
Optimizing performance with Apache AGE

Optimizing performance with Apache AGE

4
Comments 1
2 min read
AWS Data Migration Service (DMS) - MySQL to S3 Bucket services

AWS Data Migration Service (DMS) - MySQL to S3 Bucket services

3
Comments
7 min read
How use the gem 'run_database_backup'

How use the gem 'run_database_backup'

2
Comments
3 min read
SQLite Renaissance

SQLite Renaissance

Comments 1
12 min read
Conectando PowerAutomate + Teams + ChatGPT

Conectando PowerAutomate + Teams + ChatGPT

4
Comments 3
6 min read
Insert/read SQL-Server images with EF Core, Dapper and SqlClient

Insert/read SQL-Server images with EF Core, Dapper and SqlClient

12
Comments
4 min read
Beyond the Basics: Windowing in Apache Kafka

Beyond the Basics: Windowing in Apache Kafka

3
Comments
5 min read
Join the Free Database Training Course From Backendless

Join the Free Database Training Course From Backendless

2
Comments
14 min read
5 Exciting Careers in the Field of Data Analytics

5 Exciting Careers in the Field of Data Analytics

1
Comments
5 min read
Tutorial part 4: key-value store - data streams

Tutorial part 4: key-value store - data streams

2
Comments
5 min read
PostgreSQL Process and Memory Architecture: (CHAPTER 2: THE INTERNALS OF PostgreSQL)

PostgreSQL Process and Memory Architecture: (CHAPTER 2: THE INTERNALS OF PostgreSQL)

2
Comments
2 min read
How We Built an Application to Test Student Docker Images for Database Systems University Course

How We Built an Application to Test Student Docker Images for Database Systems University Course

3
Comments
15 min read
Creating a Graph Database for a Social Network with Apache AGE

Creating a Graph Database for a Social Network with Apache AGE

2
Comments
4 min read
SQL query to find second highest salary using dens_rank function ?

SQL query to find second highest salary using dens_rank function ?

1
Comments
1 min read
Write Faster Django Queries

Write Faster Django Queries

20
Comments 1
18 min read
From Court to Computer: Using Apache AGE to Dive into NBA Player Stats

From Court to Computer: Using Apache AGE to Dive into NBA Player Stats

1
Comments
5 min read
ReductStore Client SDK for C++ v1.3.0 with Labels Support

ReductStore Client SDK for C++ v1.3.0 with Labels Support

2
Comments
2 min read
Data Migration: Strategy, Steps and Best Practices

Data Migration: Strategy, Steps and Best Practices

1
Comments 1
6 min read
MTG Card Data Storage Made Easy: A Tutorial on Using Apache AGE

MTG Card Data Storage Made Easy: A Tutorial on Using Apache AGE

4
Comments 1
4 min read
Data Platform Architecture Types

Data Platform Architecture Types

3
Comments
9 min read
Polymorphic associations in Active Record

Polymorphic associations in Active Record

5
Comments
6 min read
Introduction to SQL Timestamp, Date and Time Data Types.

Introduction to SQL Timestamp, Date and Time Data Types.

1
Comments
5 min read
An easy guide to understanding databases

An easy guide to understanding databases

6
Comments
8 min read
Unleashing the Power of Data Mining: Unlocking Hidden Insights in Your Database

Unleashing the Power of Data Mining: Unlocking Hidden Insights in Your Database

1
Comments 2
2 min read
Why ACID properties matter in database transactions

Why ACID properties matter in database transactions

1
Comments
3 min read
Using Tigris as an open source MongoDB Atlas alternative for Go applications

Using Tigris as an open source MongoDB Atlas alternative for Go applications

Comments
4 min read
Deduping Customers Quick and Dirty - with SQL and Graphs

Deduping Customers Quick and Dirty - with SQL and Graphs

5
Comments
6 min read
Implementing Joins in MongoDB using the $lookup operator

Implementing Joins in MongoDB using the $lookup operator

8
Comments
5 min read
Remote database replication

Remote database replication

4
Comments
7 min read
Amazon Redshift: What, Why, and How

Amazon Redshift: What, Why, and How

2
Comments 1
5 min read
Web APIs : CRUD with .Net and EF Core

Web APIs : CRUD with .Net and EF Core

6
Comments
10 min read
CLI Client for ReductStore v0.7.0 has been released

CLI Client for ReductStore v0.7.0 has been released

3
Comments
1 min read
Soft delete: Implementation issues in Prisma and solution in ZenStack

Soft delete: Implementation issues in Prisma and solution in ZenStack

11
Comments
6 min read
Introducing PolygonDB: A Modern and Flexible Alternative to MongoDB with Advanced Data Management Features

Introducing PolygonDB: A Modern and Flexible Alternative to MongoDB with Advanced Data Management Features

5
Comments
3 min read
What is AWS RDS and RDS Pricing?(Part-1) (In Burmese)

What is AWS RDS and RDS Pricing?(Part-1) (In Burmese)

10
Comments
1 min read
What are Sql and NoSql Databases?

What are Sql and NoSql Databases?

2
Comments 1
5 min read
Introduction to SQL for Data Analysis

Introduction to SQL for Data Analysis

3
Comments
3 min read
SQL101: Introduction to SQL for Data Analysis

SQL101: Introduction to SQL for Data Analysis

1
Comments 1
9 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

15
Comments
4 min read
SQL 101: Introduction to SQL

SQL 101: Introduction to SQL

3
Comments
8 min read
PostgreSQL Database Cluster, Databases, and Tables: A Beginner's Guide

PostgreSQL Database Cluster, Databases, and Tables: A Beginner's Guide

10
Comments
4 min read
Breaking the Mold: Creating a Unique Dating App with Apache AGE and PostgreSQL

Breaking the Mold: Creating a Unique Dating App with Apache AGE and PostgreSQL

6
Comments 3
5 min read
SQL101: Introduction to SQL for Data Analysis

SQL101: Introduction to SQL for Data Analysis

6
Comments
10 min read
Here's How To Learn Data Science For Free đź’Ż In 2023

Here's How To Learn Data Science For Free đź’Ż In 2023

3
Comments
2 min read
Using Mongoose's Populate in Next.Js

Using Mongoose's Populate in Next.Js

6
Comments 2
3 min read
SQL101: Introduction to SQL

SQL101: Introduction to SQL

Comments 2
14 min read
Optimizing DBT Modeling Code: A Guide to DBT Setup and Hand-on commands

Optimizing DBT Modeling Code: A Guide to DBT Setup and Hand-on commands

5
Comments
4 min read
Logged, Unlogged and Temporary Tables in PostgreSQL

Logged, Unlogged and Temporary Tables in PostgreSQL

3
Comments
12 min read
SeaweedFS vs JuiceFS

SeaweedFS vs JuiceFS

5
Comments
6 min read
loading...