Database Setup Complete

Inserting Data
cinchdb.com/{privatekey}/insert/{col1}/{col2}/{col3}/...
privatekeyYour private key can be found above. It is unique to your database and should be kept hidden.
colYou may specify data for up to ten columns. Each column can store 256 characters of text.
Two Column Insert
Add a new score of 150 for John into the database.
cinchdb.com/abcde/insert/john/150/
Quick Delete
Add a new promotion code to the database with the specified type, start date and end date.
cinchdb.com/abcde/insert/kgshtmtq/freeshipping/2020-01-01/2020-02-01/
Deleting Data
cinchdb.com/{privatekey}/delete/{condition}
privatekeyYour private key can be found above. It is unique to your database and should be kept hidden.
conditionDetermines which records will be affected. Columns in the database are labeled col1 to col10. Valid operators are [ = | != | > | < | >= | <= ]. Multiple conditions can be specified using AND or OR. For example: col1=MYVALUE AND col2>50.
Standard Delete
Delete all values in the database where the first column is equal to 'Alice'.
cinchdb.com/abcde/delete/Alice/
Quick Delete
Delete all records where the second column is equal to 1000 and the third column is greater than 500.
cinchdb.com/abcde/delete/col2=1000 AND col3>500
Updating Data
cinchdb.com/{privatekey}/update/{condition}/{newval1}/{newval2}/...
privatekeyYour private key can be found above. It is unique to your database and should be kept hidden.
condition [Optional]Determines which records will be affected. Columns in the database are labeled col1 to col10. Valid operators are [ = | != | > | < | >= | <= ]. Multiple conditions can be specified using AND or OR. For example: col1=MYVALUE AND col2>50.
newvalue [Optional]Each updated value should be specified after a forward slash. For example: /col1=50/col8=FOO/ will update both the first and eighth column.
Simple Update
Update all values in the database where the first column is equal to 'Alice'.
cinchdb.com/abcde/update/col1=Alice/col1=Sarah
Compound Update
Update all entries where the first column is 'Alice' and the second column is less than 500. Set the third column in those entries to 20 and the fourth column to 50.
cinchdb.com/abcde/update/col1=Alice AND col2<500/col3=20;col4=50;
Quick Update
Find all entries where the first column is equal to 'Alice' and update the second column to '100'.
cinchdb.com/abcde/update/Alice/100
Retrieving Data
cinchdb.com/{publickey}/retrieve/{format}/{condition}/{count}/{order}
publickeyYour public key can be found above. Your private key will also work here, but you should not use it when users can easily view application source code (e.g. client-side JavaScript).
format [Optional]Determines how the retrieved data will be formatted. Valid options are [ CSV | JSON | BSV].
condition [Optional]Determines which records will be returned. Columns in the database are labeled col1 to col10. Valid operators are [ = | != | > | < | >= | <= ]. Multiple conditions can be specified using AND or OR. For example: col1=MY VALUE AND col2>50.
count [Optional]The maximum number of records to be returned. If no number is specified, all matching records are returned.
order [Optional]The order in which records should be sorted. Either asc or desc.
Retrieve All
Retrieves all information stored in the database.
cinchdb.com/abcde/retrieve/csv
Retrieve Matching Data
Retrieves all information stored in the database matching a given condition.
cinchdb.com/abcde/retrieve/csv/col1>1000
Retrieve Ordered Data
Retrieves all information stored in the database matching a given condition.
cinchdb.com/abcde/retrieve/csv/col1>1000/order=col3-desc/count=10