What's this ?
litesql is a tiny library easing developpement with sqlite databases.
work was based upon the massive-js library. massivejs is a nodejs module and provides an intuitive interface over raw Mysql and Postgre modules.
basically, litesql intends to brings the same interface into sqlite database. undeway the module use the sqlite3 module, meaning you can access all the functions it offers.
Of course you may also use the additional facilities this module offers (otherwise, you wouldn't be here, right?)
npm install litesql
then use it
var litesql = ;var db = litesql;db
So basically, it works always the way you've seen it
- Construct a query via helper methods and classes
- then execute the query using methods like you are used to ( run, get, all, each )
We've already seen insert; following how to update an existing record given its primary key; usually (but not necessary) an 'id' column;
You can also update by another condition; here we update all records with num <= 5
Another way to insert a new record is via the #save method
You can use #save to update an existing record as well. Just include the pk field
We use #remove to delete an existing record; below we remove by the pk field
As you may have already guessed, you can call #remove with more conditions; below we remove all tasks with completed=true
Schema helper methods