The local db is a special kind of source, it’s a connector to Postgres. Its goal is to provide a “cache” which can be requested with parameters.
An easy way to picture and understand why you might find yourself wanting to do this, imagine a very large CSV file. It makes sense to want to store and access the data in a simpler and less manual way than opening a file with millions of rows and searching through it.
For cases like these, Wapixir offers the local db & populators as a solution.
Each field has a
namecan be anything, so long as it reflects the data contained in the field
typeallows you to select between
BOOLEAN. All common field types for database tables.
sizerepresents how much information can be stored in this particular field.
Do NOT set the value of
sizeunless you’re already familiar with sizing variables in this context.
defaultis the value you want the field to default to.
The local db source kind allows you to specify two types of fields:
- The primary key, which must be a unique identifier, represents each row’s unique way to be identified.
- Columns describe each field within the rows.