Databases & NoSQL

11 articles

Articles

Redis Data Structures Beyond Caching — Leaderboards, Rate Limits, Pub/Sub, Streams

Most developers meet Redis as a cache, but its data structures solve a whole set of other problems in a few lines of code. This guide shows ten of those pattern...

686Updated 30 Sept 2026

Read article

Choosing Between PostgreSQL, MySQL, SQLite, and MongoDB (2026)

Pick the wrong database early and you pay for it for years. This guide helps you choose between PostgreSQL, MySQL/MariaDB, SQLite and MongoDB based on the shape...

Advanced10 min2,161Updated 30 Sept 2026

PostgreSQL Performance Tuning: Indexing, Vacuum, Partitioning, and pgBadger

PostgreSQL's defaults are safe on any hardware, which also means they leave a lot of a modern server unused. This guide walks through the changes that make the ...

Advanced9 min965Updated 30 Sept 2026

Prisma A Complete Practical Guide (NestJS Next.js Postgres Docker)

Prisma is a type-safe ORM for Node.js and TypeScript. You describe your data model in a schema file, Prisma turns it into SQL migrations, and it generates a cli...

Advanced10 min4,901Updated 23 Sept 2026

MySQL Version Lock Policy for Production Stability

Pinning a database version stops a routine dnf update or apt upgrade from installing a release you haven't tested. That can protect a production server, but a p...

Advanced8 min1,071Updated 24 Sept 2026

How to Check, Repair and Optimise MySQL or MariaDB Tables

MySQL and MariaDB databases need a little care: an occasional check for damaged tables, a repair when something breaks, and sensible settings so queries stay fa...

Advanced10 min4,453Updated 3 Oct 2026

MySQL Performance Optimization: Diagnosing & Fixing Slow Queries

A slow database makes every page slow, and on shared hosting it also holds PHP requests open until your account runs into its limits. Most slow queries have the...

Advanced9 min3,765Updated 23 Sept 2026

Understanding MySQLs bind-address Setting: A Comprehensive Guide

bind-address is the MySQL and MariaDB setting that decides which network addresses the database server listens on. It is the first thing to check when a remote ...

Advanced9 min14,465Updated 1 weeks ago

SQL Essentials: Mastering Database Operations

SQL is the language you use to create, read, change and protect data in a relational database such as MySQL, MariaDB or PostgreSQL. A small set of commands cove...

Advanced8 min1,990Updated 24 Sept 2026

MySQL Features Explained: Transactions, Joins and Indexes

MySQL, and its close relative MariaDB, is the database behind most PHP websites, including WordPress, WooCommerce and many custom apps. Knowing a few of its fea...

Advanced9 min2,818Updated 3 Oct 2026

Unlocking MongoDB and Mongoose: Your Comprehensive Guide to NoSQL Databases, Scalability, and Advanced Features

MongoDB is a document database: instead of rows in fixed tables, it stores flexible, JSON-like documents. Mongoose is the Node.js library most developers use on...

Advanced9 min3,224Updated 23 Sept 2026

About this category

Articles

Topics

Updated 30 Sept 2026

Other categories

🚀

App Platform (PaaS)

Getting Started

Shared Hosting (cPanel)

Shared Hosting (DirectAdmin)

Windows Hosting (Plesk)

Webuzo Hosting

All categories

Can't find what you need?

Our support team is available 24/7 to help.

Submit a Ticket Browse All Articles