SQLDataStore

Datastores. SQLDataStore

A general purpose datastore that uses an SQL server as backend. This datastore registers as the type "sql". No specific limit on number of named properties per concept as long as their names are shorter than 62 chars

Feature	Remark
Property Lengths	Max 64KB string length
Concept Instances	Max 4294967295 total (including deleted ones)
Properties / Instance
Performance	Searching for strings that "equals"/"startWith" is really fas Good at combining multiple search requirements Creating instances and setting properties is fairly fast if no reads are performed in-between

Options inherited from GigaVarv

"serverURL" - The URL to the server on the form "ws(s)://yourserver/sql". Note that secure websockets (wss) may be required on some sites.
"storageName" - The name of the data bucket you intend to use

Constructor

new SQLDataStore()

Source:

datastores/sql/SQLDataStore.js, line 64

Example

{
  "dataStores": { 
     "myDataStore": {
         "type": "sql", 
         "options": {
             "serverURL":"wss://someserver.com/sql",
             "storageName": "mybucketname"
         }
     },
     ...
 },
 ...