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 between INT, VARCHAR, FLOAT, or BOOLEAN. 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.