mayhem[m], bitmap, yvanzo, reosarevok: reminder that we have OAuth stuff meeting in ~3hrs from now.
mayhem[m] nods
yellowhatpro
@yvanzo I was able to generate 765 entities using sql-gen. For now, I just created simple enums for cube and point. These two were the only unknown types for me, and the ones that I may have to alter later. Now what should be the next step?
Should we work on postgres functions?
Also `select count(*) from information_schema.tables;` told there are 719 entities.
pranavkonidena[m joined the channel
pranavkonidena[m uploaded an image: (3186KiB) < https://matrix.moviebrainz.org/_matrix/media/v3/download/matrix.org/qlRwQmWAOSBTLbsJgOnoadbk/ima_1e43671.jpeg >
pranavkonidena[m
Hi , I had a doubt.. is the Dialogs function kinda like a snack bar management system?
jasje (IRC): ^
yvanzo
yellowhatpro: Isn’t it already providing some functions for reading/writing the database?
yellowhatpro: What can be the extra structs then?
jasje
pranavkonidena[m: kinda but not exactly
pranavkonidena[m
jasje (IRC): oh, ok ! Also how r we using the same fn name for the compostable widget and then calling it again inside the same fn? Isn’t that a bad practice?
pranavkonidena[m uploaded an image: (2222KiB) < https://matrix.moviebrainz.org/_matrix/media/v3/download/matrix.org/mwdFgqFjeZkJMdxZvbFDFsQh/ima_ec16be5.jpeg >
I'm working on LB-1488, and can't test how YouTube video works on BrainzPlayer. How can I enable the YouTube videos? I tried almost every song, but it gives me the error "Not enough info to search on Youtube
We are missing a track title, artist, or album name to search on Youtube"
kubrimskii: i wonder if that error is misleading. do you have a youtube api key available locally?
also i would suggest to join using matrix so that you can stay connected.
kubrimskii
Im still figuring out how to connect to matrix, since when i checked it said that it is no longer available for Libera.Chat (?? pls correct me if i am mistaken)
lucifer I am trying to play youtube videos on the website itself, not locally actually
jasje: i was reviewing it a few days ago but then forgot, will do and let you know.
yellowhatpro
@yvanzo, on checking again, I found that 719 are the total entities regardless of the schema, containing `event_art_archive`,`wikidocs`,`pg_catalog`, `cover_art_archive`, `musicbrainz`, `statistics`, `report`, `documentation`, `json_dump`, `information_schema`, `sitemaps`. I generated entities of musicbrainz type, which contains 382 tables.
sql-gen creates 2 files for each entity, one has the struct, the other one has methods
Should I generate schema for types other than musicbrainz as well?
yellowhatpro: It’s good to focus on `musicbrainz` schema (or even just a small part of it) for now, but binding some other schemas too can be considered later on.
yellowhatpro: Did you start thinking about how many hours you would like to dedicate to it? (90/175/350)
yellowhatpro
Ok musicbrainz schema it is then for now.
No not yet, I was currently exploring rust and databases, and this was a great plaything. I'll have to explore the project a bit more to tell the hours tho
is a*
yvanzo
Also it would be more interesting to build a small app on it rather than just having a binding that isn’t used at all.
1. Do we migrate users before OAuth apps or vice versa or do we do both together?
2. Depending on the route we intend to take, discuss changes needed in the MB server.
3. How does local development adapt to OAuth changes?
starting off with 1.
yvanzo
yellowhatpro: Picking from other ideas, there are a lot of background tasks that can do: creating subscription emails, generating data reports…
lucifer
eventually we want to have both user registration and oauth app registration in MeB.org (with the data being stored in MeB db as well).
pinkman_[m] has quit
we can do users first, oauth later or the reverse or both together. the doc lists the steps needed for each briefly.
bitmap
migrating users will be an MB schema change, FWIW, so unless we plan to delay things, then probably migrate them after?
lucifer
we could probably do it without schema change i think.
mayhem[m] joined the channel
mayhem[m]
schema change yes, but those tables are not replicated, yes?
lucifer
would need additional handling in the application layer.
bitmap
editor is not replicated
lucifer
we could migrate users by copying the data from MB to MeB DB and then making MB read the user data from MeB db if a certain flag is set?
so that you could do it independently of a schema change
bitmap
yeah, that is an option
yvanzo
editor public data is not replicated but it is dumped still
(and exported)
mayhem
I *think* and this is not a strong opinion, like option 2 better. The idea of having the lesser used projects pave the way for MB as well as having OAuth reviewed seems pretty smart.
bitmap
but they will be in separate DB's, and MB makes use of many joins with the editor table which may read things like email
lucifer
i see
if we do OAuth before users then MeB Oauth provider needs to updated to read from MB in the meanwhile
until the data is migrated from MB to MeB.
yvanzo[m] joined the channel
yvanzo[m]
Yes, it is probably safer to do it gradually
lucifer
which makes sense since MeB.org is not used by others like MB.org.
yvanzo[m]
MB could also be a proxy to MeB OAuth for a while
lucifer
that sounds fine to me but i am not sure if it comes with security implications
bitmap
yvanzo[m]: that was something else I wanted to discuss
lucifer
maybe we could ask this to the external security reviewers as well.
yvanzo[m]
that would still be like jumping off a cliff, but with a safety net
mayhem
kepstin, who knows security pretty well might be a good sounding board for this as well.