#database Development Tutorials & Tips | Roast Dev

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

Local MongoDB in Flutter 😱🤯

FlutterDB FlutterDB is a lightweight, SQLite-based document database for Flutter applications. It provides a MongoDB-like API for managing collections and documents while leveraging the perfo...

05.05.2025 0 Read More

What’s Really Running in MySQL? Use SHOW PROCESSLIST to Find Out

Monitoring MySQL database processes often feels like solving a puzzle in motion. For DBAs, maintaining optimal performance starts with tackling key challenges such as tracking client connections, diag...

05.05.2025 0 Read More

How fsync and synchronous_commit Affect PostgreSQL Performance

While diving into PostgreSQL's configuration options, two settings caught my attention: fsync and synchronous_commit. At first glance, they might seem like minor toggles, but a closer look reveals the...

05.05.2025 0 Read More

Substring from a Column of Strings — From SQL to SPL #25

Problem description & analysis: The database table tbl has a string field DESCRIPTION.Task: Now we need to retrieve the word ‘EN’ and the subsequent string of numbers from the DESCRIP...

05.05.2025 0 Read More

Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles

In relational databases like MySQL, indexes are the foundation of efficient data retrieval. Among various indexing strategies, composite indexes — those spanning multiple columns — offer significa...

06.05.2025 0 Read More

NestJS + Neo4j + GraphQL Setup

GraphQL Schema NestJS Server Configuration GraphQL Module Codegen GitHub Repo: https://github.com/HuakunShen/nestjs-neo4j-graphql-demoI haven't found a good update-to-date example of using N...

13.03.2025 0 Read More

Build a free ip info cache with PocketBase

GitHub Repo: https://github.com/HuakunShen/ip-info-cache-pbIn some of my projects, I need to visualize IP addresses on a map, thus I will need to get the longitude and latitude of the IP address.IP in...

13.03.2025 0 Read More

Navigating PostgreSQL - Index, Index Only and Bitmap Index Scans Explained

Index Scan The index scan is one of the most fundamental access methods in PostgreSQL. Unlike a sequential scan that reads the entire table, an index scan leverages a pre-built index structur...

13.03.2025 0 Read More

Key Concepts in Databases: Tables, Rows, Columns, and Keys

Introduction Relational databases organize data into tables, which makes it easy to store, retrieve, and manipulate information. In this post, we’ll explore these fundamental building blocks and the...

13.03.2025 0 Read More

DBMS_DEVELOPER.GET_METADATA in Oracle 23ai(23.7)

In an Oracle database, to extract object metadata, we can use the DBMS_METADATA package. It provides many useful procedures and functions, such as GET_DDL, GET_DEPENDENT_DDL, and SET_TRANSFORM_PARAM. ...

13.03.2025 0 Read More

Local MongoDB in Flutter 😱🤯

What’s Really Running in MySQL? Use SHOW PROCESSLIST to Find Out

How fsync and synchronous_commit Affect PostgreSQL Performance

Substring from a Column of Strings — From SQL to SPL #25

Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles

NestJS + Neo4j + GraphQL Setup

Build a free ip info cache with PocketBase

Navigating PostgreSQL - Index, Index Only and Bitmap Index Scans Explained

Key Concepts in Databases: Tables, Rows, Columns, and Keys

DBMS_DEVELOPER.GET_METADATA in Oracle 23ai(23.7)

#reading

#popular