PostgreSQL
PostgreSQL support for Blueprint projects that need SQL reads, writes, image storage, and clean result parsing.
Product Overview
PostgreSQL lets Blueprint users connect with host, database, login, password, and port fields, then run queries and receive results through Blueprint events. It is a good fit when your project already uses PostgreSQL or needs image data stored in the database.
Core Capabilities
PostgreSQL Features
Blueprint Connection Setup
Fill in server, database, login, password, and port fields directly in Blueprint.
PostgreSQL Options
Use advanced fields for SSL, timeouts, and project-specific connection needs when required.
Query Status Events
Update UI, loading states, and retry flows when connection, select, or update actions finish.
Readable Result Tables
Read rows, columns, and values in Blueprint so results can be shown in UMG or saved into game data.
Runtime Read and Write
Run leaderboard, account, inventory, analytics, or admin-style select/update queries from Blueprint.
Image Data Support
Store and read image data through the PostgreSQL Blueprint flow when your project needs database-backed images.
Blueprint Setup Flow
- 1Add the connection component or reference the connection actor.
- 2Fill in the PostgreSQL connection fields in Blueprint.
- 3Bind connection and query events before opening the connection.
- 4Call CreateConnection, then run SelectDataFromQuery or UpdateDataFromQuery.
- 5Read rows from the returned Blueprint data table and update your UI.
Setup Notes
- Use the default PostgreSQL port unless your server is configured differently.
- Use advanced connection fields only when your database server requires them.
- Keep SQL permissions limited to what your Blueprint flow needs.
Shared Database Features
Blueprint Nodes for All Databases
Use the same Blueprint-style flow to connect, check status, run queries, and close the connection.
Async Runtime Queries
Run select, insert, update, and delete SQL from gameplay or editor tools without freezing the project.
Easy Result Reading
Read query output as Blueprint-friendly rows and columns for UI tables, save data, and admin screens.
Blueprint-First Workflow
Place the actor or add the component, fill in connection fields, bind events, connect, and run queries from Blueprint.
Status Events
Show loading, success, failure, and retry states in your UI with Blueprint events.
Advanced Connection Fields
Use optional fields for SSL, timeouts, custom ports, or full connection strings when your project needs them.