Local DB
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 name
, type
, size
and default value
.
-
name
can be anything, so long as it reflects the data contained in the field -
type
allows you to select betweenINT
,VARCHAR
,FLOAT
, orBOOLEAN
. All common field types for database tables. -
size
represents how much information can be stored in this particular field.
Do NOT set the value of
size
unless you’re already familiar with sizing variables in this context.
-
default
is 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.