{"repo":"pouriamoosavi/LittleDB","free":true,"listed":false,"github":"https://github.com/pouriamoosavi/LittleDB","clone":"git clone https://github.com/pouriamoosavi/LittleDB.git","description":"Little Sql like Database for ESP32 boards","language":"C++","stars":38,"topics":["database","esp32","sqlite","littlefs","esp","sql","embedded","microcontroller"],"license":"MIT","category":"databases-storage","readme_excerpt":"Little Sql like Database for ESP32 boards A little Sql like database, which runs on esp32. This library works with esp32 file system with help of LittleFS which is a great library to manage fs in embed boards and esp. Queries Execute a query by calling execQuery function with one of these queries as input. execQuery will return a number which indicates the result of operation (refer to Responses). - #### CREATE DB create db [DB NAME] Creates a database with this name, Databases are directories inside root file system. - #### DROP DB drop db [DB NAME] (Caution) Drop a database (Delete it's directory). - #### CONNECT DB use db [DB NAME] Connect to a DB,Must be called before all bellow queries - #### CREATE TBL create table [TABLE NAME] ([SCHEMA]) Create a table with this schema. Schema must have only valid column types. Tables are files inside DB directory. - #### DROP TBL drop table [TABLE NAME] (Caution) Drop a table (Delete it's file). - #### ALTER TBL alter table [TABLE NAME] (Not yet implemented) Not yet implemented. - #### SELECT select from [TABLE NAME] where [COLUMN NAME][OPERATOR][CONDITION] Selects one row and write result into memory. A global variable with name selectedRows and type SelectedRows t will be created and declared with corresponding row(s). OPERATIONS are = , = , and < (not equal). Although it is possible to select base on any COLUMN NAME, selecting by id is more optimal both on memory and time. - #### UPDATE update [TABLE NAME] set [COLUMN NAME]=[VALUE]","default_branch":null,"files":null,"tree":[],"storefront":"/r/pouriamoosavi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pouriamoosavi/LittleDB/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}