Working with Datastore

Datastore provides Summit applications with access to a read/write database. The database is not a SQL-like relational DB; instead, is a key/value store, although the values can be certain complex types.

Creating a Table

NOTE: Tables can only be created from the Summit account UI (though they can be modified from within an application). Table types cannot be changed, so make sure you select the correct type when creating your table.

Tables are tied to a specific Summit application. To create a table, log into your account, then go to Applications -> Datastore. Select the application you want to use your datastore with from the dropdown list, then click the plus sign next to "Tables." Give your table a name and select which type of table this will be.

Table Types

Datastore uses four types of tables: String, Map, List, and Set.

String

String is the most simple type of table: it simply stores a string. String tables can have unlimited keys, but only one value per key.

Usage Example: Building a simple phone directory.

Map

Maps allow you to created unlimited keys whose values are sets of key/value pairs.

Usage Example:

  • Table: Holiday Greetings
    • Key: Christmas
      • Value: "English": "We are closed for Christmas."
      • Value: "Spanish": "Nuestro negocio está cerrado para la Navidad."
    • Key: Thanksgiving
      • Value: "English": "We are closed for Thanksgiving."
      • Value: "Spanish":"Nuestro negocio está cerrado para la acción de gracias."

List

Lists allow you to store an ordered, non-unique list of values. Lists are the only table type in which you can count on the order of values.

Usage Example: Building "follow me" app. First, ring my desk phone, then ring my cell phone, then go to voicemail.

Set

Sets allow for unordered, unique sets of values. Set tables can have unlimited keys, and unlimited values for those keys.

Usage Example: Office locations and the employees who work at those locations.

Value Helpers

Datastore can be particularly useful in letting non-developers work with the data used in your application. We know that one of the struggles of data entry is making sure that the proper format is used for your application to recognize. We've created "Helpers" that make correctly formatting data easy. Date and Datetime allow for intuitive date and time entry, which will automatically be converted to a consistent format that can be used in your applications.

Using Datastore in your Applications

Visit our API Documentation to learn about reading from and writing to Datastore tables in your applications.