Database Guides
-
How to enable Remote access to your MariaDB/MySQL database on Ubuntu Focal / MariaDB > v10.6
In this article we show how you can easily enable remote access to a new database in Webdock..
Last updated: November 10th 2022
-
How to enable Remote access to your MariaDB/MySQL database on Ubuntu Bionic or MariaDB < v10.6
In this article we show how you can easily enable remote access to a new database in Webdock or alternatively how to perform the process manually if you need fine-grained access control
Last updated: December 28th 2022
-
How to back up your MariaDB/MySQL database
An article on backing up your database and enabling binary log.
Last updated: February 12th 2025
-
A Step-by-Step Guide to Installing PostgreSQL on Ubuntu
A detailed guide on how to install PostgreSQL database server on Ubuntu
Last updated: March 6th 2024
-
Beginner's Guide: SQL Index: Why and How?
An intro for beginners on what SQL index is, and why use it.
Last updated: February 3rd 2025
-
Beginner's Guide: Clustered vs Non-clustered Index
Short article on Clustered and Non-clustered indexes
Last updated: February 3rd 2025
-
Analyze SQL queries with the Query Planner for PostgreSQL
An article on analyzing SQL queries with the query planner
Last updated: February 5th 2025
-
Database Partitioning in PostgreSQL
Instructions on creating partitions in PostgreSQL
Last updated: February 5th 2025
-
Build Your Own In-memory Database From Scratch
A guide to bulid your own in-memory database
Last updated: February 10th 2025
-
Rate Limiting with Redis and Node.js: Under the Hood
Rate-limiting with Redis and NodeJS
Last updated: February 10th 2025