Build the DB from Scratch

Building the DB from scratch

(1) Download the repo

git clone --depth=1 https://github.com/digitalpalidictionary/dpd-db.git

(2) Navigate into the directory

cd dpd-db

(3) Download the submodules from Github

git submodule init && git submodule update

(4) Install nodejs for your operating system

(5) Install go for your operating system

(6) Install uv for your operating system

curl -LsSf https://astral.sh/uv/install.sh | sh

(7) Install all the dependencies with uv

uv sync

(8) Having at least 20 GB of RAM can be helpful. If you have less, consider increasing the swap memory..

(9) Run this once to initialize the project

uv run bash scripts/bash/initial_setup_run_once.sh

(10) Build the database, this can take up to an hour the first time.

uv run bash scripts/bash/initial_build_db.sh

That should create an SQLite database dpd.db in the root folder which can be accessed with DB Browser, DBeaver, through SQLAlechmy or your preferred method.

For a quick tutorial on how to access any information in the db with SQLAlchemy, see Using the db

---

Additional configuration

There are some additional dependencies in different parts of the project that may need to be installed depending on your use case.

1. The GoldenDict exporter requires dictzip

2. Running the GUI requires tkinter

3. The database tests may require pyperclip dependencies.