This simple Unreal Engine plugin writes to a SQLite DB using Epic Games built in plugin (UE5.6) It is built as a subsystem - SQLiteWriterSubsystem.
This is what is written when AddUserData() is called from Blueprint:
INSERT INTO UserData (UserId, TimeStamp, ExperimentNumber, ExperimentType, HeartRate, SyncScore, Beat)
The SQLiteWriterSubsystem is an Unreal Engine subsystem for writing user data to SQLite databases. It provides a simple interface for creating databases, defining tables, and inserting user data, including support for position and experiment metadata.
- Create and open SQLite databases in your project’s
Content/Databases/directory. - Create tables for user data.
- Insert user data and experiment information.
The SQLite DBs can be read easily. E.g. using tools like https://sqliteviewer.app/ or https://sqlitebrowser.org/
To create (or open) a database and ensure the required table exists:
Insert user data with experiment info:
