A small database engine in php. Perfect for small ARM devices and low usage.
Go to file
dfstorm 07e5b80278 init'ish 2020-06-29 17:39:16 +02:00
LICENSE Initial commit 2020-06-29 15:32:11 +00:00
README.md init'ish 2020-06-29 17:39:16 +02:00
api_keys.json.exemple init'ish 2020-06-29 17:39:16 +02:00
index.php init'ish 2020-06-29 17:39:16 +02:00

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"})