Slippi DB ingests Slippi replays and puts the data into a SQLite database for easier parsing.
The primary goal of this project is to make it easier to analyze large amounts of Slippi data. Its end goal is to create something similar to Ballchasing.com but for Melee.
USAGE: slippi-db [OPTIONS]
... ARGS: ... Directories to search for .slp files in FLAGS: -h, --help Prints help information -V, --version Prints version information OPTIONS: -o, --output-db Set output database file [default: slippi.db]
The easiest way to install is to download the executable for your system from releases.
$ git clone https://github.com/mtimkovich/slippi-db $ cd slippi-db $ cargo build --release
There's some examples of what is possible in the
examples/ directory. This is good starting point, especially if you're not familiar with SQL. These can be run via:
$ sqlite3 slippi.db < examples/hours_played.sql
If you come up with a cool query, make a PR and I'll add it to the examples!
- Write data to SQLite DB.
- Check the filelist for new files.
- Save player data.
- Create more SQL examples.
- Detect the winner(s).
- Discard short matches (<30s).
- Handle tiebreaks.
- Detect rage-quits and assign them losses.
- Create releases.
- Create even more SQL examples.
This project follows the all-contributors specification. Contributions of any kind welcome!