Plus Spanish translation, support, community stuff
2024-07-29 21139, 2024
reosarevok[m]
That's about it for me, go LupinIII (IRC) !
2024-07-29 21143, 2024
LupinIII
Arararara~! hi!
2024-07-29 21154, 2024
LupinIII
doing picard translations! I finished the norw installer and am now working on the website!
2024-07-29 21154, 2024
LupinIII
otherwise it seems we're actually getting some sun this week so trying to actually go out and such. doing other offline things like fix windows and cut grass at a community garden thing.
2024-07-29 21126, 2024
LupinIII
fin, next can be jasje?
2024-07-29 21101, 2024
BobSwift[m] joined the channel
2024-07-29 21117, 2024
LupinIII
ok maybe pranav
2024-07-29 21130, 2024
jasje joined the channel
2024-07-29 21133, 2024
jasje
heyy
2024-07-29 21104, 2024
jasje
nothing much to report last week, its been a very busy week.
2024-07-29 21114, 2024
jasje
thats it for me
2024-07-29 21139, 2024
jasje
list please
2024-07-29 21150, 2024
reosarevok[m]
On my list today: pranav, atj
2024-07-29 21110, 2024
jasje
pranav: go
2024-07-29 21126, 2024
LupinIII
pranav seems not to be here 🤷‍♂️
2024-07-29 21132, 2024
monkey[m]
pas nav
2024-07-29 21140, 2024
reosarevok[m]
Oh well
2024-07-29 21149, 2024
reosarevok[m]
Last call for pranav and atj
2024-07-29 21109, 2024
LupinIII
:D
2024-07-29 21108, 2024
reosarevok[m]
Ok, I don't think either is here
2024-07-29 21138, 2024
reosarevok[m]
Nothing else in the agenda either
2024-07-29 21141, 2024
reosarevok[m]
So thanks everyone!
2024-07-29 21149, 2024
reosarevok[m]
See you in a week
2024-07-29 21152, 2024
reosarevok[m]
</BANG>
2024-07-29 21134, 2024
reosarevok[m]
lucifer: can you make a chatbrainz account for LupinIII (IRC) so he can see how much he hates it? :D
<061zeka> hey guys, i'm creating a web app for my final thesis; is it possible to merge the postgres dataset with my current database without going through the steps for musicbrainz-docker? i just need a decent sized dataset to start with to add to my current postgre database.
2024-07-29 21113, 2024
bitmap[m]
1zeka: nope, you can't merge a database dump with the contents of your existing database; you have to either re-import everything from scratch, or have a mirror server setup that receives the hourly replication packets as updates
2024-07-29 21123, 2024
discordbrainz
<061zeka> in that case, what would you suggest that i do? if i cannot read the database dump, what are some other ways that i can get a dataset that i can insert into my database?
2024-07-29 21141, 2024
discordbrainz
<061zeka> i pretty much just need a decent set of artists and albums, for everything else i'll just use the API
2024-07-29 21158, 2024
discordbrainz
<061zeka> maybe reading the JSON is my best bet?
2024-07-29 21130, 2024
bitmap[m]
if you're familiar with postgres it's not impossible, the files inside the dump are in postgresql's COPY text format
2024-07-29 21155, 2024
bitmap[m]
the JSON dumps are another option, yes
2024-07-29 21144, 2024
discordbrainz
<061zeka> i'm not that familiar with postgres, i've only started using it now, trying to move away from mysql
2024-07-29 21107, 2024
bitmap[m]
but yeah, you could technically create the tables you want by hand (without foreign keys), extract the dump, and then use postgres's COPY command
2024-07-29 21124, 2024
discordbrainz
<061zeka> do you have any pointers for fetching the data from the postgres dump?
2024-07-29 21135, 2024
bitmap[m]
after you extract it there is an mbdump/ directory inside with one file per table
2024-07-29 21105, 2024
theflash__ has quit
2024-07-29 21124, 2024
bitmap[m]
then it's just COPY artist FROM 'path/to/artist'; in psql, IIRC, assuming you've created the artist table. the table definitions are in admin/sql/CreateTables.sql in the musicbrainz-server repo
2024-07-29 21134, 2024
discordbrainz
<061zeka> i extracted the dump fully, so i just create the tables i need using the CreateTables.sql definitions, and then use the COPY x from 'path/to/x' to copy that data over to my empty table?
2024-07-29 21100, 2024
bitmap[m]
yes, something like that should work, it's basically what the import scripts are doing
2024-07-29 21112, 2024
bitmap[m]
there won't be any indexes on the tables, but you could create your own that are suitable for the type of queries you're doing
2024-07-29 21152, 2024
discordbrainz
<061zeka> do you know if i could create the tables using spring's @Entity implementation? it basically reads the java class and creates the table based off the fields.
2024-07-29 21146, 2024
bitmap[m]
I'm not familiar with that, but it's fine as long as the columns exactly match the CREATE TABLE statement in the file I mentioned
2024-07-29 21101, 2024
atj[m] has quit
2024-07-29 21117, 2024
discordbrainz
<061zeka> alright, thanks for your help man
2024-07-29 21115, 2024
jasje has quit
2024-07-29 21112, 2024
aerozol[m]
ansh: lucifer monkey : There are multiple reports of the last.fm importer failing/hitting the rate limit (on Discord). I think this is a critical issue for us, since a lot (most?) of our users are probably last.fm migrants/dual citizens. If they can’t import they wont be staying, is my assumption
2024-07-29 21117, 2024
aerozol[m]
I found a number of existing tickets, which I have linked to a central ticket, LB-974. I added the specific feedback and screenshots, from when I asked for more details on Discord, to LB-1314
