#database Development Tutorials & Tips | Roast Dev

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

What Makes Data AI-Ready?

TL;DR: Your AI scaling bottleneck isn't models, it's inconsistent enterprise data—solve it with graph-based pipelines like FalkorDB & GraphRAG. Gartner: 60% of AI projects fail due to poor-quali...

27.03.2025 0 Read More

Collation in Database - What you need to know

What is Collation? Collation refers to a set of rules that determine how data is sorted and compared. Collation settings specify the correct character sequence, case sensitivity, accent marks...

27.03.2025 0 Read More

Why We Killed 276K Lines of C++ Code: Migrating a Cloud Database to Rust Saved Our Startup

TL;DR We replaced C++ with Rust to rebuild our database project. This article covers why, the challenges we faced, and when Rust is the right choice for a production-grade project. RisingWave...

27.03.2025 0 Read More

What is Geo-Redundancy? A Comprehensive Guide

Geo-redundancy is the practice of replicating and storing your critical IT infrastructure and data across multiple locations strategically. Why Geo-Redundancy is Needed? The main aim is to e...

27.03.2025 0 Read More

Applications in prod. How to handle skyrocket growth with caching.

We are lucky, and the company we work at has skyrocketed. In the previous steps, we set up the Postgres database(s) well, set up monitoring and alerting, optimized our data and queries, and even switc...

28.03.2025 0 Read More

Learning PostgreSQL

Why did I learn PostgreSQL Simple, I needed to expand my knowledge of DBA tools, and PostreSQL in my honest opinion is a way better tool than Microsoft SQL Server. I'm currently a student in ...

04.05.2025 0 Read More

Importing Excel with multiple headers into a database

This article will explain how to import this kind of complex multi-level header Excel table into the database like this:Determine the data area Start importing Open the DiLu Converter, select ...

04.05.2025 0 Read More

Import a large CSV more than 1G into a database quickly

This article will introduce how to quickly import csv or txt files larger than 1g into the database.Here, we prepared a CSV file with 10 million rows x 30 columns x 4GB. At first, I tried to import it...

04.05.2025 0 Read More

Think Twice Before Migrating Between PostgreSQL and MySQL

Photo by benjamin lehman on Unsplash Hidden Trade-Offs in Database Migration Switching from MySQL to PostgreSQL or the other way around might seem like an upgrade, but have you considered the ...

28.03.2025 0 Read More

Building an Efficient and Cost-Effective Business Data Analytics System with Databend Cloud

With the rise of large AI models such as OpenAI's ChatGPT, DeepL, and Gemini, the traditional machine translation field is being disrupted. Unlike earlier tools that often produced rigid translations ...

28.03.2025 0 Read More

What Makes Data AI-Ready?

Collation in Database - What you need to know

Why We Killed 276K Lines of C++ Code: Migrating a Cloud Database to Rust Saved Our Startup

What is Geo-Redundancy? A Comprehensive Guide

Applications in prod. How to handle skyrocket growth with caching.

Learning PostgreSQL

Importing Excel with multiple headers into a database

Import a large CSV more than 1G into a database quickly

Think Twice Before Migrating Between PostgreSQL and MySQL

Building an Efficient and Cost-Effective Business Data Analytics System with Databend Cloud

#reading

#popular