SchemafreeSQL

Free Trial

Create a SFSQL Cloud Datastore.
Free for 7 days (credit card not required).

This trial will launch a SFSQL Cloud Object Store and VM.

Your SFSQL VM endpoint will be accessible for 7 days. Your Data will persist for the life of the trial. Trial VMs are "stopped" every 30 minutes and will wake on demand (around 300 ms start up time). At the end of the trial the VM and Object store will be will be destroyed along with any data.

Trials are restricted to 2 requests per second and 500 MB of data.

Enter Your Credentials here to enable the SFSQL Workbench, Object Explorer, and Example Demos for a currently active Trial or Paid Cloud SFSQL Object Store.

Create/Update/Set/Append Objects

SFSQL's modify command will accetp any valid JSON (nested arrays not supported) within its child "data" object and create the appropriate Object instances. It the has three sub commands:

"#update" is used to edit an Object Attribute Values, if the Object to update is not found or if more than one is found matching the where clause an error will be returned.
"#set" is similar to "update" except if an Object is not found a new Object will be created.
"#append" creates one or more new Objects.

Request

Response

Copy. Req.

Copy. Resp.

Payload Parameters

Reflective Parameters are returned (reflected) back within a Command Response. Reflective Parameters are underscore-prefixed useful for extracting results when multiple queries are issued in a payload. Payload Scoped Parameters have all the qualities of Reflexive Parameters with the addition of being available to all other Commands within the same Request Payload. Payload Scoped Parameters are Double-underscore-prefixed

Request

Response

Copy. Req.

Copy. Resp.

Create and Query Nested Attribute Structures

Request

Response

Copy. Req.

Copy. Resp.

Object References

Objects may be referenced with the use of the "#ref" command.
Referenced Objects may be updated in place

Request

Response

Copy. Req.

Copy. Resp.

Customer Order with Object References

Modeling Order Objects with references to Customer and Line Items objects. No data duplications.

Request

Response

Copy. Req.

Copy. Resp.

Modify Complex Attribute Structures

Request

Response

Copy. Req.

Copy. Resp.

Modify Arrays

Request

Response

Copy. Req.

Copy. Resp.

Game of Thrones Graph

Graph Data Structures (Nodes and Edges) can be created and queried with SFSQL. In the example below we create a Graph of the Game Of Thrones Characters (Nodes) and their Connections with one another (Edges).
(Data used from Kaggle book4.csv)

Request

Response

Copy. Req.

Copy. Resp.

Bulk Import (Clinical Trials)

SchemafreeSQL has a built-in feature that allows bulk importing of JSON files.
In this example a subset of the Clinical Trials JSON documents from clinicaltrials.gov are imported and queried.
(Local import is not available on Cloud SFSQL, "Import" is thus not operational. A remote import is being worked on.
"Modify/Append/Query" and "CT Attribute Structure" are functional

Request

Response

Copy. Req.

Copy. Resp.