Databases & Storage

Add MySQL, PostgreSQL, MongoDB or Redis to your bot or app, and connect from every language.

Create a managed MySQL, PostgreSQL, or MongoDB database from your server's Databases page — one that stays up even when your server doesn't.

Connect your app to a database

Take the connection string from the Databases page and turn it into working queries — in Node, Python, and beyond.

Run your own database server

MongoDB, PostgreSQL, and Redis can each run as a full server application inside your own container — when that's the right call, and when a managed database is safer.

Caching with Redis

Run Redis as its own Falix server, then cache from your app — cooldowns, rate limits, and sessions with self-expiring keys — plus the honest rule about what never to keep there.

Designing tables for your bot

The handful of table shapes almost every Discord bot needs — per-user, per-guild, per-guild-per-user, and event logs — with the right keys, why Discord IDs are always text, and when to split data into a second table.

Just enough SQL

The five commands that do 90% of the work — SELECT, INSERT, UPDATE, DELETE, and JOIN — with small, runnable examples you can paste into phpMyAdmin, a bot, or the sqlite tool.

Change your schema without losing data

Your tables will change — a new column, a new table. Versioned migrations make each change run exactly once and keep old data intact, driven by SQLite's built-in user_version counter (with the plain schema_version table for MySQL and PostgreSQL).

phpMyAdmin: manage MySQL in your browser

Open phpMyAdmin from the Databases page — already signed in — and browse rows, run SQL, change table structure, and import or export a dump, all without writing a line of connection code.

PostgreSQL from Node with pg

Point Node at a PostgreSQL database with the pg driver — connect from the panel's connection string, run parameterized queries safely, upsert with ON CONFLICT, and use a pool for a long-running bot or web app.

MongoDB from Node

Connect Node to MongoDB with the official driver — including the panel's authSource connection string — and do the full CRUD: insert, find, update with $inc, and delete, with one reusable client.

MongoDB from Python with PyMongo

Connect Python to MongoDB with PyMongo — the panel's authSource connection string, one reusable client, and the full CRUD: insert_one, find, update_one with $inc, and delete_one.

SQLite in depth

SQLite is a whole database in one file next to your code — no server to run. Turn on WAL mode for safe concurrent writes, back it up properly, know its real limits, and learn the one line that tells you when to move to a managed database instead.

Redis from Python

The Python half of caching with Redis — connect with redis-py, store self-expiring keys, and build cooldowns and rate limits in a few lines, mirroring the Node guide.

ORMs on Falix, honestly

Prisma, Sequelize, and Drizzle all work on the Node.js application — but each needs one Falix-specific step to survive the way servers start. Here's the tested truth for all three, and which to pick.

Backing up your databases

Managed databases have their own backups, separate from server file backups — take them from the Databases page, export SQL dumps from phpMyAdmin, and practise the restore before you need it.

Connection pooling

A long-running bot or web server should hold a small pool of database connections, not one fragile connection and not a new one per query. Here's the pattern for mysql2, pg, and mongo — and when a single connection is genuinely fine.

Cleaning up old data

Databases grow forever unless you tell them not to. Set TTLs where the store supports them, delete old rows on a schedule where it doesn't, and always back up before a mass delete.

Choosing between Redis, SQLite, MySQL and Mongo

Four database shapes, one honest chooser. Match your data to key/value, single-file SQL, managed SQL, or documents — and know why on Falix "where it runs" matters as much as "what shape it is".