Is there a way to get a list of all the databases/annotation projects as well as where the databases are saved on the disk?

[mrxiaohe]

Hello,

I have been having trouble getting a full list of all the annotation projects/databases that have been created, as well as the directories in which they are stored. Any guidance would be very appreciated.

Thanks, and stay safe and healthy!

-X

[ines (Ines Montani)]

Hi! There's typically only ever one database – if you're using the built-in configuration, that's either SQLite (default, stored as a file on disk) or MySQL or PostgreSQL. By default, SQLite writes to a file prodigy.db in your Prodigy home directory (.prodigy in your user home, unless you change it). But you can also customise the location and file name.

If you mean the datasets in the database, you can use the prodigy stats command with -l set to list all datasets present in the database. It will also show you the location of your Prodigy home directory that contains the database file. To export datasets as JSONL, you can run db-out.

If you want, you can also interact with the database programmatically – see here for details:

programmatic way to get stats

Yes, check out the Database API: https://prodi.gy/docs/api-database#database For example, here's how you would connect, get all dataset names and get all annotations of a given dataset: from prodigy.components.db import connect db = connect() all_dataset_names = db.datasets examples = db.get_dataset("my_dataset") The source of the stats command/recipe is also shipped with Prodigy, so you can always check it out in recipes/commands.py and see how it's done there.