small-memory/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"})
```