50 lines
736 B
Markdown
50 lines
736 B
Markdown
# 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"})
|
|
```
|