osuDB

Project I made so that anyone can have easy access to the 170k+ ranked maps currently in osu. Used in conjunction with osdbParser to create the json files to be processed.

• Full Text Search with GIN indexing for fast search results
• Maps ranked by playcount for accurate and relevant results
• Still working on the README (lot of steps I need to add)

Setup

1. Clone repo

https://github.com/JonathanJia05/osuDB.git
cd osuDB

2. Install Postgres

3. Setup Postgres database

psql -U postgres
CREATE DATABASE osudb;
exit

4. Install requirements

Run:

pip install -r requirements.txt

5. Create database.ini

Create a database.ini file and put it in the root directory In the file:

[postgresql]
host=localhost
database=osudb
user=YourUsername
password=YourPassword

Replace YourUsername and YourPassword with your credentials that you setup postgres with.

6. Connect to the database

In the root directory run:

python -m app.database.connect.py

7. Create tables

In the root directory run:

python -m app.database.create_tables

8. Load database with maps

In the root directory run:

python -m app.scripts.parser