SQLite CRUD Extension

Database plugin that make SQLite's prepared statements available to blueprints. It helps you to continuously persist your actors in an easy and systematic way.

Video: Link

With just a basic understanding of SQL you can specify your data objects with a simple structure, that does auto-creation of database tables and prepared statements based, and blueprint code to use the statements. Prepared Objects are offering seven already prepared create read update delete, short CRUD-like, operations:

• Create - INSERT row with auto-increment integer primary key
• CreateOrUpdate - INSERT OR REPLACE row with all columns
• Read - SELECT by primary key
• Update - UPDATE by primary key
• Delete - DELETE by primary key
• Iterate - SELECT all columns row by row.
• IteratePK - SELECT primary keys row by row

A prepared statement is a database feature used to execute the same SQL statements repeatedly with much higher efficiency than a non-prepared statement. Even most Low-level SQL is hidden, it is still accessible through execution of bare SQL or custom prepared statements. The included example project show you how to store location and rotation of actors of a multi-player game in a database on the server.