playing with sqlite3

basic usage

.tables
.schema TABLE_NAME

insert & update

e.g. vsphere-esxi-rescue-encrypted

resources

basic usage

http://geeksforgeeks.org/sqlite/sqlite-describe-table/

insert

https://sqlite.org/lang_insert.html

https://www.w3resource.com/sqlite/sqlite-insert-into.php

https://stackoverflow.com/questions/1609637/how-to-insert-multiple-rows-in-sqlite

misc

https://webmasters.stackexchange.com/questions/492/what-potential-issues-do-i-need-to-be-aware-of-in-a-multi-server-clustered-envir

https://sqlite.org/forum/forumpost/0d899a2fd01776e3?raw