oneup
JSON database class built and working 100%, in under 200 lines of code. Ability to create/remove tables and add/get/update/delete rows based on search criteria in familiar MySQL syntax.

$db = new db();
$db->table_getRow($table, 'column1', 'column1_data'); // in MySQL: select * from table where column1=column1_data
Jan 21, 2017 at 5:44pmWeb
Show threadMitchell UrgeroJan 21, 2017
@chu So is it 1 table per file, or 1 db per file? Because on a big DB, that can slow down pretty quick...
Show threadoneupJan 21, 2017
@mitchell currently it is 1 db per file. I know with scaling this can be a problematic approach, which is why the db format will shortly be 1 table ROW per file ;)
Show threadMitchell UrgeroJan 21, 2017
@chu 1 table per row would be fine, as any programmer with common sense doing a scalable project would just use MySQL, CouchDB, or something other than just flat file. ;) but nice bro
Show threadoneupJan 21, 2017
@mitchell no, 1 table ROW per file. I.e. /var/database/main/table1/rows/0 === row 1 in table 1
Show threadMitchell UrgeroJan 21, 2017
@chu Yea No that would be nice, but remember that gets HUGE quickly too ;) Don't forget to allow compression if wanted!
Show threadoneupJan 21, 2017
@mitchell My main concern is database corruption. PHP and its array system are responsible for speed of "query execution".
Show threadMitchell UrgeroJan 21, 2017
@chu Corruption wont be a problem because PHP can "Queue" file read and write operations.