All dependencies are cross-platform, open source with permissive licenses so that developers and data analysts do not need to procure or purchase any tools.
- Download
Deno
Javascript runtime and put it in your
PATH
. - Download DuckDB 0.9+ for data
orchestration operations and put it in your
PATH
. - Download SQLite embedded database and
put it in your
PATH
. - Download SQLPage SQL browser,
call it
sqlpage
on Linux/MacOS (not the defaultsqlpage.bin
) orsqlpage.exe
on Windows and put it in yourPATH
.- SQLPage is not strictly required but highly recommended for easier
diagnostics. See Manage GitHub binaries with
eget
for an easy way to manage GitHub binaries.
- SQLPage is not strictly required but highly recommended for easier
diagnostics. See Manage GitHub binaries with
The utilities mentioned above are cross-platform single-file binaries and will run on Windows, MacOS, or Linux. Please be sure to get the proper binaries for your platform.
You can run deno task doctor
(see below) to see if dependencies are installed
properly.
A good way to get binaries from GitHub (e.g. SQLPage, et. al.) you should download and use eget.
- Create a directory called
D:\bin
orC:\Program Files\qe-cs
(or anywhere you want), grab theeget.exe
binary and store it inD:\bin
. - Add
D:\bin
orC:\Program Files\qe-cs
(or whatever you created in step #1) to yourPATH
. - Create an
D:\bin\eget.toml
file (orC:\Program Files\qe-cs\eget.toml
) and add the following content. Be sure to settarget = "X"
where X is eitherD:\\bin
orC:\\Program Files\\qe-cs
(or whatever you created in step #1).
[global]
target = "D:\\bin"
["lovasoa/SQLpage"]
On Windows you can also use scoop to install binaries such as SQLPage:
$ scoop install sqlpage
- CD into
D:\bin
(orC:\\Program Files\\qe-cs
or whatever you created in step #1) and runeget /D
to download all required binaries.