░█▀█░█▄█░█▀█░█▀▀░█▀▄░█▀█░█▀▀░█▀▀░█▀▄░█░█░█▀▀░█▀▄
░█▀█░█░█░█░█░█▀▀░█▀▄░█▀█░▀▀█░█▀▀░█▀▄░▀▄▀░█▀▀░█▀▄
░▀░▀░▀░▀░▀▀▀░▀▀▀░▀▀░░▀░▀░▀▀▀░▀▀▀░▀░▀░░▀░░▀▀▀░▀░▀
- Define columns runtime
- Export to file
- Export to csv
- Pretty print preview in browser
Initialize a new table (all columns are varchar)
/init/col_1,col_2,...
Single Insert
- Implicit:
insert/col1, col2 - For empty values:
/insert/col1,None
Bulk Insert
- Explicit:
/insert/(col1, col2),(col1, col2), (col1, col2),... - Implicit Bulk Insert:
/insert/col1, col2, col1, col2, col1, col2,...- For 3 columns:
/insert/col1, col2, col3, col1, col2, col3,...and so on for n columns.
- For 3 columns:
- Empty columns should be clearly specified:
/insert/col1,,col2,,col2,...- Or using:
/insert/(col1,),(col1,col2),(,col2),...
View:
/
Export:
/download(sqlite file to hard disk)/csv(csv string in browser)