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 to Transform SQL Queries to Crosstabs in PostgreSQL

How to Transform SQL Queries to Crosstabs in PostgreSQL

Comments
6 min read
Redis OM Spring is 10x faster — How I contributed to this open source repository maintained by Redis

Redis OM Spring is 10x faster — How I contributed to this open source repository maintained by Redis

1
Comments
8 min read
Basics of PostgreSQL (Part2)

Basics of PostgreSQL (Part2)

1
Comments
2 min read
What is "Agens-Graph"?

What is "Agens-Graph"?

3
Comments
2 min read
Apache-age: The best Open Source Graph Database Solution

Apache-age: The best Open Source Graph Database Solution

2
Comments
3 min read
Four Pitfalls of SQL Processing with Null Values

Four Pitfalls of SQL Processing with Null Values

Comments
7 min read
Bidirectional replication in PostgreSQL using pglogical

Bidirectional replication in PostgreSQL using pglogical

4
Comments
9 min read
Graph Database and Apache AGE

Graph Database and Apache AGE

4
Comments
1 min read
DorisSummit2022: MPP Query Execution Model&Vectorized Execution&Adaptive Execution&Memory Management 37:02

DorisSummit2022: MPP Query Execution Model&Vectorized Execution&Adaptive Execution&Memory Management

2
Comments
1 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
2 min read
Tencent Data Engineer: Why We Go from ClickHouse to Apache Doris?

Tencent Data Engineer: Why We Go from ClickHouse to Apache Doris?

1
Comments
11 min read
A First Look at Neon: A Postgres Database That Branches

A First Look at Neon: A Postgres Database That Branches

9
Comments
7 min read
How to Configure SSL on PostgreSQL

How to Configure SSL on PostgreSQL

4
Comments
1 min read
PostgreSQL Process Architecture

PostgreSQL Process Architecture

7
Comments
3 min read
Xata Plus OpenAI: ChatGPT on Your Data

Xata Plus OpenAI: ChatGPT on Your Data

10
Comments
5 min read
Data Business Logic In Java: jOOQ VS SPL

Data Business Logic In Java: jOOQ VS SPL

3
Comments
4 min read
Here's Why Authentication Should Not Be Rocket Science

Here's Why Authentication Should Not Be Rocket Science

2
Comments
6 min read
A Practical Guide to SQL Dates with DuckDB.

A Practical Guide to SQL Dates with DuckDB.

Comments 2
9 min read
ShortId Factory

ShortId Factory

3
Comments
1 min read
Playing with ChatGPT to generate dummy/fake data.

Playing with ChatGPT to generate dummy/fake data.

7
Comments
3 min read
Streamline your edge computing workflows with ReductStore, now available on Snap

Streamline your edge computing workflows with ReductStore, now available on Snap

3
Comments
1 min read
Hacking 101: Common Attacks and How to Stop Them

Hacking 101: Common Attacks and How to Stop Them

1
Comments
5 min read
Arel and Ruby on Rails

Arel and Ruby on Rails

10
Comments
3 min read
Saving your data

Saving your data

Comments
3 min read
DBeaver + SSH + Bastion Host + Google Authenticator : 🤝How to connect

DBeaver + SSH + Bastion Host + Google Authenticator : 🤝How to connect

3
Comments 2
3 min read
Replicate AWS RDS Aurora to AWS RDS MySQL

Replicate AWS RDS Aurora to AWS RDS MySQL

8
Comments 1
2 min read
Connect C# to PostgreSQL

Connect C# to PostgreSQL

Comments
6 min read
Installing age-viewer (Part3: Installing apache and PSQL from Source)

Installing age-viewer (Part3: Installing apache and PSQL from Source)

2
Comments
3 min read
Initialization of the cluster, Creating a graph, and Adding a node (PART 2: Installing Apache and PSQL from source)

Initialization of the cluster, Creating a graph, and Adding a node (PART 2: Installing Apache and PSQL from source)

2
Comments
2 min read
Useful SQL Commands

Useful SQL Commands

3
Comments
4 min read
How To Hash Password with PostgreSQL Function in Nodejs

How To Hash Password with PostgreSQL Function in Nodejs

1
Comments
2 min read
AWS Redshift advantages and use cases

AWS Redshift advantages and use cases

9
Comments
6 min read
Connect to a PostgreSQL database(python).

Connect to a PostgreSQL database(python).

29
Comments 1
2 min read
Practical Backward Compatibility example

Practical Backward Compatibility example

5
Comments
2 min read
What to test in the backend ?

What to test in the backend ?

29
Comments
2 min read
Postgres as Rest

Postgres as Rest

5
Comments
5 min read
How to create a Newsletter feedback form using React and Supabase

How to create a Newsletter feedback form using React and Supabase

5
Comments
6 min read
Finding missing data in your database with QuestDB

Finding missing data in your database with QuestDB

Comments
7 min read
Database for Kemal server in Crystal lang

Database for Kemal server in Crystal lang

5
Comments
3 min read
What is indexing in DB?

What is indexing in DB?

7
Comments
2 min read
SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

1
Comments 1
7 min read
Want to level up your skills and unlock the power of Databases?

Want to level up your skills and unlock the power of Databases?

2
Comments
3 min read
Aumentando a performance do Dapper

Aumentando a performance do Dapper

4
Comments 2
3 min read
Replicating data from other databases to CrateDB with Debezium and Kafka

Replicating data from other databases to CrateDB with Debezium and Kafka

2
Comments
7 min read
Outer Join Optimization

Outer Join Optimization

4
Comments
5 min read
Math for devs - Relational Algebra

Math for devs - Relational Algebra

21
Comments 1
7 min read
The Five Best Online Database Builders 2023

The Five Best Online Database Builders 2023

2
Comments
12 min read
Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

8
Comments
6 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

16
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

76
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

5
Comments 1
2 min read
loading...