You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
07e5b80278
|
3 years ago | |
|---|---|---|
| LICENSE | 3 years ago | |
| README.md | 3 years ago | |
| api_keys.json.exemple | 3 years ago | |
| index.php | 3 years ago | |
README.md
small-memory
A small database engine in php. Perfect for small ARM devices and low usage. NOT SECURE.
Usage
Call the script with a GET parameter "query" (by default). The value must be in Base64. There is no "access control".
Create Database
CREATE DATABASE mydatabase
Create Table
CREATE TABLE mytable IN mydatabase (field1,field2,[...])
Insert
INSERT INTO mytable IN mydatabase ({"key":"value"})
Select
SELECT mytable IN mydatabase (*)
OR
SELECT mytable IN mydatabase ({"key":"value"})
Update
UPDATE mytable IN mydatabase ({"UnidID":"UniqID_Value","key":"new_value"})
Delete
DELETE mytable IN mydatabase ({"UnidID":"UniqID_Value"})