Database

This document details the configuration settings for the database system.

Database Type Settings

Database Type

Field	Value
Type	String
Description	Specifies the type of database to use
Default	"sqlite"
Valid Values	"sqlite", "mysql"

SQLite Configuration

SQLite Database Path

Field	Value
Type	String
Description	File path for the SQLite database
Default	"Skynomi.sqlite3"
Required	Only when Database Type is "sqlite"
Example	"SQLite Database Path": "Skynomi.sqlite3"

MySQL Configuration

MySqlHost

Field	Value
Type	String
Description	Host address and port for MySQL server
Default	"localhost:3306"
Required	Only when Database Type is "mysql"
Format	"hostname:port"

MySqlDbName

Field	Value
Type	String
Description	Name of the MySQL database
Default	"" (empty string)
Required	Only when Database Type is "mysql"

MySqlUsername

Field	Value
Type	String
Description	Username for MySQL authentication
Default	"" (empty string)
Required	Only when Database Type is "mysql"

MySqlPassword

Field	Value
Type	String
Description	Password for MySQL authentication
Default	"" (empty string)
Required	Only when Database Type is "mysql"

Example Configurations

SQLite Configuration Example

Database.json

{
  "Database Type": "sqlite",
  "SQLite Database Path": "Skynomi.sqlite3",
  "MySqlHost": "localhost:3306",
  "MySqlDbName": "",
  "MySqlUsername": "",
  "MySqlPassword": ""
}

MySQL Configuration Example

Database.json

{
  "Database Type": "mysql",
  "SQLite Database Path": "",
  "MySqlHost": "localhost:3306",
  "MySqlDbName": "skynomi_db",
  "MySqlUsername": "skynomi_user",
  "MySqlPassword": "your_secure_password"
}

Security Best Practices

1. Use strong passwords for MySQL authentication

2. Keep database credentials secure and never share them

3. Regularly backup your database

4. Use appropriate file permissions for SQLite database files

5. Consider using environment variables for sensitive information

Configuration Notes

• Only fill in the credentials for the database type you're using

• Ensure proper network connectivity for MySQL connections

• Verify database user permissions

• Keep regular backups of your database

• Monitor database performance and storage usage