LessDB

LessDB a serverless SQLite service designed to simplify the use of cloud-based MySQL, PostgreSQL, and other databases. The project is still in the planning stage, and the planned features include.

• HTTP JSON API
• Optimizing Security
• Sqlite Cli
• S3 Object Storage
• Asynchronously Execute SQL for Eventual Consistency
• Local Cache File
• Compatible with MySQL Protocol
• Support Uploading Various Data Formats and Converting them into SQLite Files
• Prometheus Metrics Data
• Optimizing WebUI

Installation

go get github.com/linkxzhou/LessDB

OR

git clone git@github.com:linkxzhou/LessDB.git
cd LessDB/cmd/http
go build .

Startup：

cd LessDB/cmd/http
./http

Architecture

HTTP JSON API

（1）create databases

POST http://localhost:18090/api/v1/createdb
Content-Type: application/json
{
"list": [
{
"cmd": "CREATE TABLE IF NOT EXISTS foo1 (id text NOT NULL PRIMARY KEY,title text)",
"args": []
},
{
"cmd": "CREATE TABLE IF NOT EXISTS foo2 (id text NOT NULL PRIMARY KEY,title text)",
"args": []
},
{
"cmd": "INSERT INTO foo1 (id, title) values (?, ?)",
"args": [415, "romantic-swell"]
},
{
"cmd": "INSERT INTO foo2 (id, title) values (?, ?)",
"args": [415, "romantic-swell"]
}
]
}

（2）query tables

GET http://localhost:18090/api/v1/{readkey}/tables?limit=10&offset=0
Content-Type: application/json

（3）query rows

GET http://localhost:18090/api/v1/{readkey}/tables/foo1/rows?limit=100&offset=0
Content-Type: application/json

（4）execute sql: asynchronously execute SQL

POST http://localhost:18090/api/v1/{readkey}/execute
Content-Type: application/json
{
"list": [
{
"cmd": "CREATE TABLE IF NOT EXISTS foo1 (id text NOT NULL PRIMARY KEY,title text)",
"args": []
},
{
"cmd": "CREATE TABLE IF NOT EXISTS foo2 (id text NOT NULL PRIMARY KEY,title text)",
"args": []
},
{
"cmd": "INSERT INTO foo1 (id, title) values (?, ?)",
"args": [1, "unique-title-1"]
},
{
"cmd": "INSERT INTO foo1 (id, title) values (?, ?)",
"args": [2, "unique-title-2"]
}
],
"writekey": "{writekey}"
}

（5）execute sql for query data

POST http://localhost:18090/api/v1/{readkey}/query
Content-Type: application/json
{
"list": [
{
"cmd": "select * from foo1"
},
{
"cmd": "select * from foo2"
}
]
}

（6）query asynchronously log

POST http://localhost:18090/api/v1/{readkey}/executelog
Content-Type: application/json
{
"seqid": "{seqid}"
}

Goal

Serve small and medium-sized developers, reducing the cost of cloud services.

Quotation

[1] https://github.com/rqlite/rqlite
[2] https://github.com/psanford/sqlite3vfs
[3] https://github.com/mattn/go-sqlite3
[4] https://github.com/kahing/goofys
[5] https://github.com/turbobytes/infreqdb
[6] https://github.com/rclone/rclone
[7] https://ieeexplore.ieee.org/abstract/document/9101371
[8] https://dl.acm.org/doi/abs/10.1145/1376616.1376645
[9] https://github.com/nalgeon/redka