Accessing data from the postgresql server

MusicBrainz Development
, ,
1

I apologise in advance for the very simple question, I am very inexperienced in with databases.

I have the PostgreSQL sever installed with docker compose, I am working with this data for a reserach paper. Would it be better if i converted the data into a sqllite database and then used it or would it be better to use it as postgresql

Also, I can’t seem to find a way to convert it, and trying ot access the data directly through postgresql has me very confused. Can anyone suggest any resources or help me with this problem
Once again, I am really sorry for the very trivial question

1 Like
2

Have a look at GitHub - metabrainz/musicbrainz-docker: Docker Compose project for the MusicBrainz Server with replication, search, and development setup

3

I followed this whole guide, where do i go from there?

4

(It might make sense for an admin to merge this into your earlier thread at https://community.metabrainz.org/t/converting-data-to-a-sqllite3-database/708651.)

I agree with the earlier comment that trying to get the data into SQLite will be a ton of work. It’ll be easier to just use PostgreSQL, especially if you already have it set up.

IIRC, you should be able to run something like this in your musicbrainz-docker checkout to get a psql prompt:

sudo docker-compose run musicbrainz psql postgres -U musicbrainz -h db

After that, you should be able to query it like you would any SQL database. There are a lot of pages online describing PostgreSQL-specific commands. A few from a search:

If there’s something specific that you’re trying to do and having problems with, please describe it.

2 Likes
5

You can open the port to your PostgreSQL database (running inside docker) with these instructions.

Then you can access the database with the usual tools for PostgreSQL like
https://dbeaver.io/
or any other tool that support PostgreSQL.

The database schema is not easy to understand and even more complicated to convert to another format. I would not suggest to go the convert-way.

4 Likes