<commit_before>## Windows portable

Install from zip http://www.enterprisedb.com/products/pgbindownload.do

Link via https://www.postgresql.org/download/windows/

Unpack zip and extracted `/path/to/psql/bin` to `PATH` env.

## Init

```shell
./start.sh
./database_and_user.sh
./populate.sh
```

You can run `./status.sh` to see db status.

## http server in WSL2, PostgreSQL in Windows host

I could not connect to database.

## Ubuntu in WSL2

Haven't checked if it works.

`sudo apt install postgresql`

- https://help.ubuntu.com/community/PostgreSQL#Installation
- https://skmcloughlin.github.io/configuring_postgresql_for_wsl2
- https://www.reddit.com/r/bashonubuntuonwindows/comments/glds15/how_to_use_postgres_with_wsl2/<commit_msg>db: Ubuntu WSL2<commit_after>## Windows portable

Install from zip http://www.enterprisedb.com/products/pgbindownload.do

Link via https://www.postgresql.org/download/windows/

Unpack zip and extracted `/path/to/psql/bin` to `PATH` env.

## Init

```shell
./start.sh
./database_and_user.sh
./populate.sh
```

You can run `./status.sh` to see db status.

## Ubuntu

`sudo apt install postgresql`

- https://help.ubuntu.com/community/PostgreSQL#Installation
- https://skmcloughlin.github.io/configuring_postgresql_for_wsl2
- https://www.reddit.com/r/bashonubuntuonwindows/comments/glds15/how_to_use_postgres_with_wsl2/

## Ubuntu WSL2

http and PostgreSQL servers have to be run in WSL2.
{'fraction_non_alphanumeric': 0.12649332396345747, 'fraction_numerical': 0.009135628952916374, 'mean_word_length': 4.393939393939394, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 8, 'lorem ipsum': 0, 'www.': 6, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6362925', 'n_tokens_mistral': 546, 'n_tokens_neox': 514, 'n_words': 112}