Database
Learn about databases and how to use them with your applications.
Some applications require a database connection to function. This page explains what databases are and how to use them with LBC.
Databases Are Not Included
Databases are not included by default with any product, even if your application requires one. You will need to purchase a database application separately or use file-based storage alternatives.
What is a Database
A database is a structured storage system that organizes your data efficiently. Think of it like a digital filing cabinet where information is stored in organized tables with rows and columns, similar to a spreadsheet.
Do You Need a Database?
Not all applications require a dedicated database server. There are several ways to store data:
- File-based storage (JSON, YAML, etc.): Simple to set up, good for configuration data or small amounts of information. Works without any additional purchase.
- SQLite: A lightweight database stored as a single file. Works without a dedicated database server and is suitable for many applications.
- MySQL, MariaDB, PostgreSQL: Full database servers for structured data that needs to be accessed quickly, handles large datasets and concurrent connections.
- Redis: In-memory data store for caching, sessions, and real-time data.
If your application supports SQLite or file-based storage, you can use those options without purchasing a database application. Many applications work perfectly fine with these alternatives.
Getting a Database
If your application requires a full database server like MySQL or Redis, you have two options:
-
Purchase from LBC: Buy a database application from our store. Once purchased, you have full control over your database server and can create as many databases as your resources allow.
-
Self-host: If you have the technical knowledge, you can host your own database server elsewhere and connect your LBC applications to it.
Using Your Database Application
Once you have a database application, you can access its management panel to:
- Create and manage multiple databases
- View connection information
- Monitor resource usage
Since you own the entire database server, you're not limited to a single database. You can create as many databases as your allocated resources allow.
Connection Information
To connect your applications to a database, you'll need:
- Database host address and port
- Database name
- Username and password
Some applications use the JDBC (Java Database Connectivity) format for connection strings. You can find all connection details in your database application's panel.
Database Management
LBC does not provide tools to migrate or manipulate database contents. You will need to use external tools like phpMyAdmin, MySQL Workbench, DBeaver, or command-line utilities to manage your database data.