- Ensure you have
node (16)
installed locally - Run
./your_sqlite3.sh
to run your program, which is implemented inapp/main.js
.
./your_sqlite3.sh companies.db "SELECT id, name FROM companies WHERE country = 'eritrea'"
There are 3 databases:
sample.db
:- This is a very small database.
- It contains two table:
apples and oranges
.
superheroes.db
:- This is a small version of the test database used in the table-scan stage.
- It contains one table:
superheroes
. - It is ~1MB in size.
companies.db
:- It contains one table:
companies
, and one index:idx_companies_country
- It is ~1GB in size.
- It contains one table: