storage
0.000001 USD
Count records in a table
tablestring
specify the table name
countnumber
the number of records in the table
Request
Response
{
"count": 31
}0.0001 USD
Create a record in the database. Optionally include an "id" field otherwise it's set automatically.
idstring
optional record id to use
recordobject
JSON encoded record or records (can be array or object)
tablestring
Optional table name. Defaults to 'default'
idstring
The id of the record (either specified or automatically created)
Request
Response
{
"id": "1"
}0.000001 USD
Delete a record in the database by id.
idstring
id of the record
tablestring
Optional table name. Defaults to 'default'
Request
Response
{}0.000001 USD
Drop a table in the DB
tablestring
Request
Response
{}0.000001 USD
List tables in the DB
tablesarray
list of tables
Request
Response
{
"tables": [
"example",
"example2"
]
}0.000001 USD
Read data from a table. Lookup can be by ID or via querying any field in the record.
idstring
Read by id. Equivalent to 'id == "your-id"'
limitnumber
Maximum number of records to return. Default limit is 25. Maximum limit is 1000. Anything higher will return an error.
offsetnumber
orderstring
'asc' (default), 'desc'
orderBystring
field name to order by
querystring
Examples: 'age >= 18', 'age >= 18 and verified == true' Comparison operators: '==', '!=', '<', '>', '<=', '>=' Logical operator: 'and' Dot access is supported, eg: 'user.age == 11' Accessing list elements is not supported yet.
tablestring
Optional table name. Defaults to 'default'
recordsarray
JSON encoded records
Request
Response
{
"records": [
{
"id": "1",
"name": "Jane",
"age": 43,
"isActive": true
}
]
}0.000001 USD
Rename a table
fromstring
current table name
tostring
new table name
Request
Response
{}0.000001 USD
Truncate the records in a table
tablestring
Request
Response
{}0.0001 USD
Update a record in the database. Include an "id" in the record to update.
idstring
The id of the record. If not specified it is inferred from the 'id' field of the record
recordobject
record, JSON object
tablestring
Optional table name. Defaults to 'default'
Request
Response
{}