Tip
If you already have a MariaDB instance running, skip the steps to install MariaDB, start it, load data, and stop it.
-
Install Node.js (version 22 or later)
-
Start a MariaDB instance:
docker run -d --rm --name some-mariadb -e MARIADB_ROOT_PASSWORD=my-secret-pw -p 3306:3306 mariadb
-
Create a table in MariaDB and load data into it:
cat games.sql | docker exec -i some-mariadb mariadb --user=root --password=my-secret-pw
-
Install the MariaDB ADBC driver:
dbc install mariadb
-
Install dependencies:
npm --prefix .. install
-
Customize the script
main.jsas needed- Change the connection arguments in
databaseOptions- Format
uriaccording to the driver documentation, or keep it as is to use the data included with this example
- Format
- If you changed which database you're connecting to, also change the SQL SELECT statement in
conn.query()
- Change the connection arguments in
-
Run the script:
Node.js:
node main.js
Bun:
bun run main.js
Deno:
deno run --allow-ffi --allow-env main.js
Stop the Docker container running MariaDB:
docker stop some-mariadb