# tymly-pg-plugin
Description
Replace Tymly's out-the-box memory storage with PostgreSQL
# Links
# State Resources
| Name | Description |
|---|---|
| auditTrail | No description! 😦 |
| exportingCsvDeltaFile | Outputs change-only-update CSV files (or “delta” files) that contain all the necessary actions required to re-synchronize rows in a cloned table - just a thin wrapper over pg-delta-file (opens new window) |
| getCurrentValueFromSequence | Gets the current value from the specified sequence, returning it as the value of the value property |
| getNextValueFromSequence | Gets the next value from the specified sequence, returning it as the value of the value property |
| importingCsvFiles | Takes a specifically-named directory structure of CSV files and conjures bulk insert, update and delete statements and applies them to a PostgreSQL database - just a thin wrapper over Supercopy (opens new window) |
| resetSequence | Resets the specified sequence |
| synchronizingTable | Takes the contents of one PostgreSQL table, applies a transformation function to each row and ensures a target table is kept in sync - just a thin wrapper over pg-telepods (opens new window) |
# Blueprint directories
| Directory | Description |
|---|---|
/models | One JSON file per model (contents to be a JSON schema for defining the model's data structure) |
# Services
| Name | Description |
|---|---|
| audit | PG Audit Service |
| pgScript | PG Script Service |
| storage | Replaces the default in-memory storage solution with a Postgresql-backed alternative |