#database Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Mastering Redis : The In-Memory Data Structure Store You Need to Know 🚀

Redis (Remote Dictionary Server) is a powerful, open-source, in-memory data store that can be used as a database, cache, message broker, and queue. It is known for its high performance, rich data stru...

05.04.2025 0 Read More

One-click import of Excel to database

At work, we often need to import Excel data into the database, but for database novices, this may not be an easy task; for database experts, this may be very cumbersome.This article will introduce how...

05.04.2025 0 Read More

🚀 Introducing PSQLab – Your In-Browser PostgreSQL Playground

Imagine running a full PostgreSQL database directly in your browser without any server setup—pure, instant, and local. Meet PSQLab, an innovative UI built on pglite, that lets you experiment with Po...

06.04.2025 0 Read More

The effect of frequent values on histogram_bounds in PostgreSQL

In a recent blog post, I explored statistics in PostgreSQL, with a focus on how the database engine builds histogram bounds during the ANALYZE process. These histograms are critical for query planning...

06.04.2025 0 Read More

Designing Time-Series Data In DynamoDB

DynamoDB is excellent at efficiently storing and querying time-series data.However, the efficiency remains entirely dependent on your ability to model your data properly to support the access patterns...

06.04.2025 0 Read More

How to Export Twitter Followers: A Step-by-Step Guide

Introduction Do you want to export Twitter followers for analysis, outreach, or audience segmentation? If you’ve ever tried to capture your Twitter export list of followers manually, you kn...

06.04.2025 0 Read More

Postgres: Index Scans

Using an index to help improve query performance is common practice. An index is a structure organized in such a way to help make it cheaper to access data records stored on disk. One example of such ...

06.04.2025 0 Read More

Where SQL joins struggle but MongoDB documents shine

Claims such as "Joins are slow" or "Joins don't scale" often prompt me to showcase how efficiently rows can be joined in a SQL database (here, here, or here). However, user perception of slowness pers...

06.04.2025 0 Read More

14 Rules for Designing MySQL Tables

1. Include These Common Fields When Designing a Table Generally, a table should include the following fields: id: Primary key. Every table must have a primary key — no exceptions. create_...

06.04.2025 0 Read More

AI in Warehouses: Because Human Errors Are Too Expensive

Warehouses are the backbone of logistics, ensuring that products move smoothly from manufacturers to customers. But as demand grows, traditional warehouse management systems are struggling to keep up....

07.04.2025 0 Read More

Mastering Redis : The In-Memory Data Structure Store You Need to Know 🚀

One-click import of Excel to database

🚀 Introducing PSQLab – Your In-Browser PostgreSQL Playground

The effect of frequent values on histogram_bounds in PostgreSQL

Designing Time-Series Data In DynamoDB

How to Export Twitter Followers: A Step-by-Step Guide

Postgres: Index Scans

Where SQL joins struggle but MongoDB documents shine

14 Rules for Designing MySQL Tables

AI in Warehouses: Because Human Errors Are Too Expensive

#reading

#popular