Sign inSign up

pionono/db_isla

By pionono

•Updated 6 months ago

DB_ISLA: Free Database Server API HTTP . Excel/Power BI Web Connector http://x:5500/tables/mytable

Image
Databases & storage
0

10K+

pionono/db_isla repository overview

⁠Database Server ISLA https://buymeacoffee.com/pionono⁠

Free lightweight database server listening HTTP on port 5500

Manage million of rows
Select / Insert / Upadte / Delete / Where / Count

⁠Help

curl "http://1.2.3.4:5500/help"

Tables mytable and mytable2 pre-created

⁠Connect from Excel, Power BI or other applications

Use a simple HTTP WEB Connect URL:

http://host_name:5500/tables/mytable

⁠Examples

⁠DB_ISLA HTTP API examples

Base URL:

http://host_name:5500

⁠Precreated Tables: mytable and mytable2

Columns:

id, date, country, city, category, product, channel, salesperson, units, amount, discount
⁠Create table
curl -X POST "http://host_name:5500/tables/mytable/create?cols=id,date,country,city,category,product,channel,salesperson,units,amount,discount"
⁠Insert rows
curl -X POST "http://host_name:5500/tables/mytable/insert?values=1,2024-01-10,Spain,Madrid,Technology,Laptop,Online,Ana,5,4500,10"
curl -X POST "http://host_name:5500/tables/mytable/insert?values=2,2024-01-12,Spain,Barcelona,Technology,Tablet,Store,Luis,8,3200,5"
curl -X POST "http://host_name:5500/tables/mytable/insert?values=3,2024-01-15,Portugal,Lisbon,Home,VacuumCleaner,Online,Maria,6,1500,8"
⁠Show all rows
curl "http://host_name:5500/tables/mytable"
⁠Count rows
curl "http://host_name:5500/tables/mytable/count"
⁠Select rows by field
curl "http://host_name:5500/tables/mytable/select?whereField=country&whereValue=Spain"
curl "http://host_name:5500/tables/mytable/select?whereField=city&whereValue=Madrid"
curl "http://host_name:5500/tables/mytable/select?whereField=category&whereValue=Technology"
curl "http://host_name:5500/tables/mytable/select?whereField=product&whereValue=Laptop"
curl "http://host_name:5500/tables/mytable/select?whereField=channel&whereValue=Online"
curl "http://host_name:5500/tables/mytable/select?whereField=salesperson&whereValue=Ana"
⁠Get one row by first column value

Note: /row/<id> uses the first column of the table.
For this table, the first column is id.

curl "http://host_name:5500/tables/mytable/row/1"
curl "http://host_name:5500/tables/mytable/row/2"
⁠Update rows
curl -X PUT "http://host_name:5500/tables/mytable/update?whereField=id&whereValue=1&setField=amount&setValue=4700"
curl -X PUT "http://host_name:5500/tables/mytable/update?whereField=city&whereValue=Madrid&setField=country&setValue=Spain"
curl -X PUT "http://host_name:5500/tables/mytable/update?whereField=salesperson&whereValue=Ana&setField=channel&setValue=Distributor"
curl -X PUT "http://host_name:5500/tables/mytable/update?whereField=product&whereValue=Tablet&setField=discount&setValue=7"
⁠Delete rows
curl -X DELETE "http://host_name:5500/tables/mytable/delete?whereField=id&whereValue=3"
curl -X DELETE "http://host_name:5500/tables/mytable/delete?whereField=country&whereValue=Germany"
curl -X DELETE "http://host_name:5500/tables/mytable/delete?whereField=salesperson&whereValue=Carlos"
⁠Drop table
curl -X DELETE "http://host_name:5500/tables/mytable"

⁠Table: mytable2

Columns:

id, date, country, city, category, product, channel, salesperson, units, amount, discount
⁠Create table
curl -X POST "http://host_name:5500/tables/mytable2/create?cols=id,date,country,city,category,product,channel,salesperson,units,amount,discount"
⁠Insert rows
curl -X POST "http://host_name:5500/tables/mytable2/insert?values=1,2024-01-10,Spain,Madrid,Technology,Laptop,Online,Ana,5,4500,10"
curl -X POST "http://host_name:5500/tables/mytable2/insert?values=2,2024-01-12,Spain,Barcelona,Technology,Tablet,Store,Luis,8,3200,5"
curl -X POST "http://host_name:5500/tables/mytable2/insert?values=3,2024-01-15,Portugal,Lisbon,Home,VacuumCleaner,Online,Maria,6,1500,8"
⁠Show all rows
curl "http://host_name:5500/tables/mytable2"
⁠Count rows
curl "http://host_name:5500/tables/mytable2/count"
⁠Select rows by field
curl "http://host_name:5500/tables/mytable2/select?whereField=country&whereValue=Portugal"
curl "http://host_name:5500/tables/mytable2/select?whereField=city&whereValue=Lisbon"
curl "http://host_name:5500/tables/mytable2/select?whereField=category&whereValue=Home"
curl "http://host_name:5500/tables/mytable2/select?whereField=product&whereValue=VacuumCleaner"
curl "http://host_name:5500/tables/mytable2/select?whereField=channel&whereValue=Store"
curl "http://host_name:5500/tables/mytable2/select?whereField=salesperson&whereValue=Maria"
⁠Get one row by first column value

Note: /row/<id> uses the first column of the table.
For this table, the first column is id.

curl "http://host_name:5500/tables/mytable2/row/1"
curl "http://host_name:5500/tables/mytable2/row/2"
⁠Update rows
curl -X PUT "http://host_name:5500/tables/mytable2/update?whereField=id&whereValue=1&setField=amount&setValue=4800"
curl -X PUT "http://host_name:5500/tables/mytable2/update?whereField=city&whereValue=Barcelona&setField=country&setValue=Spain"
curl -X PUT "http://host_name:5500/tables/mytable2/update?whereField=salesperson&whereValue=Luis&setField=channel&setValue=Online"
curl -X PUT "http://host_name:5500/tables/mytable2/update?whereField=product&whereValue=Laptop&setField=discount&setValue=12"
⁠Delete rows
curl -X DELETE "http://host_name:5500/tables/mytable2/delete?whereField=id&whereValue=2"
curl -X DELETE "http://host_name:5500/tables/mytable2/delete?whereField=country&whereValue=France"
curl -X DELETE "http://host_name:5500/tables/mytable2/delete?whereField=salesperson&whereValue=Erik"
⁠Drop table
curl -X DELETE "http://host_name:5500/tables/mytable2"

⁠List all tables

curl "http://host_name:5500/tables"

⁠Built-in help

curl "http://host_name:5500/help"

⁠Count rows

curl "http://10.4.2.145:5500/tables/t1/count"

Tag summary

Content type

Image

Digest

sha256:b961a336d…

Size

175.5 MB

Last updated

6 months ago

docker pull pionono/db_isla