봄 크리에이터 세일이 4월 18일 오후 10시 59분에 종료됩니다!

SQLite CRUD Extension

Database plugin that make SQLite's prepared statements available to blueprints. It offers auto-creation of tables and statements based on a simple blueprint structure and CRUD-principle (create, read, update and delete).

  • 지원 플랫폼
  • 지원 엔진 버전
    5.1 - 5.3
  • 다운로드 유형
    엔진 플러그인
    이 제품은 코드 플러그인과 함께 미리 빌드한 바이너리와 언리얼 엔진에 통합되는 모든 소스 코드를 포함하고 있으며 원하시는 엔진 버전에 설치하여 프로젝트에 따라 활성화할 수 있습니다.

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.

기술적 세부사항

Features:

  • Over 60 Blueprint nodes.
  • Auto-generated CRUD and Table operations based on a simple specification (struct), where you just select datatype, primary key and
  • Support for custom prepared statements (including queries).
  • Execution of SQL command strings (no queries).
  • Binding and query support for Unreal primitive types (8) by index or name. Precalculated Index Mapping.
  • Pass-through of target in many nodes for a tidier layout.
  • TimedQueues: class, blueprints and macros to gracefully encounter server I/O overload.
  • Sample Macros for schema version management.
  • Automatic folder creation upon database file creation.
  • Example includes sample code for all CRUD operations and overload handling in chaotic situations (caused in a physical simulation).


Code Module:

  •  SQLiteExt (Runtime)

Number of Blueprints: 3

Number of C++ Classes: 4

Network Replicated: No

Supported Development Platforms: Win64

Supported Target Build Platforms: Win64

Documentation: Link (v5.3.37)

Example Project (without plugin) for 5.3: Link.

Additional Notes:

  • The code plugin uses the database of SQLite Core (shipped with the engine)
  • Made for use in Blueprints only. No support for asynchronous use.
  • Discord-Link