Centralized Database Manager V2.0

Centralized Database Manager V2.0

V2.0.0.0

Major Changes:

– Complete rebranding: DBAPI becomes SILODB (modDesc, scripts, console commands and API).

– Transition to ORM: Introduction of a structured data management system (CRUD: Create, Update, Delete, Find).

– Query Engine: Added QueryEngine (filtering, sorting, pagination) and SchemaValidator.

Breaking Changes:

– Removal of Key-Value: The old getValue, setValue, deleteValue and listKeys methods are removed.

– New Export: Scripts must now call SILODB instead of DBAPI.

Improvements:

– Updated ExampleDbUsage.lua with error handling.

Centralized Storage & VS Code Tooling for Modders

FS25_DBAPI is a streamlined persistence layer for Farming Simulator 25 mods. It replaces fragmented data handling with a centralized, JSON-backed FlatDB and provides a simple global API (g_globalMods[“FS25_DBAPI”].DBAPI) for namespaced key/value storage.

To supercharge your workflow, it comes with a dedicated VS Code extension featuring IntelliSense, snippets, and a live tree view to inspect your database files directly in the editor.

Why use FS25_DBAPI?

– Zero Overhead: A minimal, savegame-safe persistence layer that requires no external database engines.

– Intuitive API: Clean methods for getValue, setValue, listKeys, and deleteValue.

– Developer Velocity: Drastically speed up coding with autocomplete, snippets, and workspace visualization.

– Cross-Mod Compatibility: Simplify data sharing between mods and streamline migrations between savegames.

– Scalable: Lightweight enough for tiny utility mods, yet robust enough for complex modpacks.

Quick Start for Developers

Install the Mod

Drop the release ZIP into your mods/ folder and load your savegame to initialize the API.

Setup the VS Code Extension

Navigate to the vscode-extension directory and run:

Bash

npm run compile

npm run package

Install the resulting .vsix via VS Code (Extensions → Install from VSIX…).

Code Examples

Set a configuration value:

Lua

local DBAPI = g_globalMods[“FS25_DBAPI”]
DBAPI.setValue(“MyMod”, “config.playerSpeed”, 12.5)

Read with a fallback default:

Lua

local DBAPI = g_globalMods[“FS25_DBAPI”]
local speed = DBAPI.getValue(“MyMod”, “config.playerSpeed”, 10)

Get Involved

We’re looking for feedback! Whether you want to report a bug, request a feature, or propose an integration, join the conversation on GitHub.

Author: LeGrizzly