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.
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

6
Comments 1
2 min read
SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

4
Comments 1
1 min read
VERSE.DB V3 (ANNOUNCEMENT)🔥

VERSE.DB V3 (ANNOUNCEMENT)🔥

4
Comments
1 min read
The filesystem - a quick & dirty way to store temp data in your API

The filesystem - a quick & dirty way to store temp data in your API

Comments
2 min read
Are SQL Joins Expensive?

Are SQL Joins Expensive?

5
Comments
2 min read
𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

Comments
1 min read
Trust But Verify: Evaluating Security When Choosing Data Infrastructure Tools

Trust But Verify: Evaluating Security When Choosing Data Infrastructure Tools

Comments
8 min read
Postgres Is All You Need

Postgres Is All You Need

95
Comments 9
4 min read
How to test Umbraco against a real database

How to test Umbraco against a real database

1
Comments
5 min read
Mastering SQLite: Efficient Database Management Tips

Mastering SQLite: Efficient Database Management Tips

2
Comments
3 min read
🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

7
Comments
2 min read
TiDB Serverless vs PlanetScale: The Ultimate Cloud Database Showdown

TiDB Serverless vs PlanetScale: The Ultimate Cloud Database Showdown

Comments
3 min read
TiDB Serverless vs Amazon RDS: The Ultimate Cloud Database Showdown

TiDB Serverless vs Amazon RDS: The Ultimate Cloud Database Showdown

Comments
3 min read
Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

1
Comments
8 min read
Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.