Posted inMySQL
MySQL 8 Dual Password: Smooth Password Rotation Without Downtime
Changing MySQL passwords without triggering Access Denied errors? Explore the Dual Password feature in MySQL 8 to keep your system online 24/7 during maintenance.
Posted inDatabase
Mastering Prisma ORM with Node.js & TypeScript: Say Goodbye to Type-safety and Migration Woes
Upgrade your Node.js workflow with Prisma ORM. A detailed guide from setup to advanced techniques for absolute type-safe queries and professional database management.
Posted inDatabase
Installing FerretDB: How to Run MongoDB on PostgreSQL to Simplify Your Infrastructure
Install FerretDB to run MongoDB on PostgreSQL: The perfect solution to save resources, simplify DevOps workflows, and escape MongoDB SSPL licensing hurdles.
Posted inCentos
Installing PostgreSQL 16 on CentOS Stream 9: A Survival Guide for Production Environments
A production-ready guide for installing PostgreSQL 16 on CentOS Stream 9. This article focuses on SELinux, Firewalld security, and practical performance tuning tips.
Posted inFedora
Installing and Configuring MariaDB on Fedora Server: Production Database Deployment with SELinux and firewalld
A complete guide to getting MariaDB production-ready on Fedora Server: securing the installation with mysql_secure_installation, opening ports correctly with firewalld rich rules, handling SELinux context for custom datadirs, and debugging refused connections. Includes basic performance tuning and a final production checklist.
Posted inDatabase
SurrealDB Tutorial: A Database to Replace PostgreSQL, Redis, and Neo4j?
Forget about installing Postgres, Redis, and Neo4j all at once. Discover SurrealDB - a Multi-model database written in Rust that optimizes real-time applications and simplifies backend architecture.
Posted inDatabase
PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch
Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.
Posted inDatabase
Deploying MariaDB Galera Cluster: A Multi-master High Availability Solution for Production
A detailed guide on setting up a 3-node MariaDB Galera Cluster. This synchronous multi-master solution ensures your database system stays online and secure against hardware failures.
Posted inDatabase
Meilisearch: A “Lightning-Fast” Search Engine to Replace Elasticsearch for Small and Mid-sized Projects
Meilisearch is a high-speed search solution and a perfect alternative to Elasticsearch for small to medium websites. This article covers setup, configuration, and practical insights from 6 months of production use.
Posted inDatabase
Valkey Installation Guide: The Perfect Open Source Redis Alternative
Valkey is a fully open-source fork of Redis created after its license change. Here is a detailed guide to installing Valkey on Docker and Ubuntu for developers.