<lucifer> "if it doesn't then try sharing..." <- ```... (full message at <https://matrix.moviebrainz.org/_matrix/media/v3/download/moviebrainz.org/drVYlcLPRQLUQVsffaNJWMbC>)
mayhem[m], bitmap, yvanzo, reosarevok: reminder that we have OAuth stuff meeting in ~3hrs from now.
2024-02-05 03631, 2024
mayhem[m] nods
2024-02-05 03606, 2024
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?
2024-02-05 03606, 2024
yellowhatpro
Should we work on postgres functions?
2024-02-05 03657, 2024
yellowhatpro
Also `select count(*) from information_schema.tables;` told there are 719 entities.
2024-02-05 03620, 2024
pranavkonidena[m joined the channel
2024-02-05 03620, 2024
pranavkonidena[m uploaded an image: (3186KiB) < https://matrix.moviebrainz.org/_matrix/media/v3/download/matrix.org/qlRwQmWAOSBTLbsJgOnoadbk/ima_1e43671.jpeg >
2024-02-05 03639, 2024
pranavkonidena[m
Hi , I had a doubt.. is the Dialogs function kinda like a snack bar management system?
2024-02-05 03645, 2024
pranavkonidena[m
jasje (IRC): ^
2024-02-05 03612, 2024
yvanzo
yellowhatpro: Isn’t it already providing some functions for reading/writing the database?
2024-02-05 03653, 2024
yvanzo
yellowhatpro: What can be the extra structs then?
2024-02-05 03603, 2024
jasje
pranavkonidena[m: kinda but not exactly
2024-02-05 03609, 2024
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?
2024-02-05 03653, 2024
pranavkonidena[m uploaded an image: (2222KiB) < https://matrix.moviebrainz.org/_matrix/media/v3/download/matrix.org/mwdFgqFjeZkJMdxZvbFDFsQh/ima_ec16be5.jpeg >
2024-02-05 03653, 2024
pranavkonidena[m
Something like this ^
2024-02-05 03632, 2024
kubrimskii joined the channel
2024-02-05 03649, 2024
pinkman_[m]
<pinkman_[m]> "```..." <- > <@matrixtest7103:matrix.org> ````... (full message at <https://matrix.moviebrainz.org/_matrix/media/v3/download/moviebrainz.org/wxasWGOvBjqCbyPOExCKdYgn>)
2024-02-05 03604, 2024
kubrimskii
Hi! duplicating my question
2024-02-05 03604, 2024
kubrimskii
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
2024-02-05 03605, 2024
kubrimskii
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?
2024-02-05 03632, 2024
lucifer
also i would suggest to join using matrix so that you can stay connected.
2024-02-05 03658, 2024
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)
2024-02-05 03648, 2024
kubrimskii
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.
2024-02-05 03631, 2024
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.
2024-02-05 03605, 2024
yellowhatpro
sql-gen creates 2 files for each entity, one has the struct, the other one has methods
2024-02-05 03642, 2024
yellowhatpro
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.
2024-02-05 03608, 2024
yvanzo
yellowhatpro: Did you start thinking about how many hours you would like to dedicate to it? (90/175/350)
2024-02-05 03637, 2024
yellowhatpro
Ok musicbrainz schema it is then for now.
2024-02-05 03644, 2024
yellowhatpro
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
2024-02-05 03655, 2024
yellowhatpro
is a*
2024-02-05 03616, 2024
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?
2024-02-05 03619, 2024
lucifer
2. Depending on the route we intend to take, discuss changes needed in the MB server.
2024-02-05 03619, 2024
lucifer
3. How does local development adapt to OAuth changes?
2024-02-05 03650, 2024
lucifer
starting off with 1.
2024-02-05 03606, 2024
yvanzo
yellowhatpro: Picking from other ideas, there are a lot of background tasks that can do: creating subscription emails, generating data reports…
2024-02-05 03645, 2024
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).
2024-02-05 03649, 2024
pinkman_[m] has quit
2024-02-05 03626, 2024
lucifer
we can do users first, oauth later or the reverse or both together. the doc lists the steps needed for each briefly.
2024-02-05 03633, 2024
bitmap
migrating users will be an MB schema change, FWIW, so unless we plan to delay things, then probably migrate them after?
2024-02-05 03613, 2024
lucifer
we could probably do it without schema change i think.
2024-02-05 03622, 2024
mayhem[m] joined the channel
2024-02-05 03623, 2024
mayhem[m]
schema change yes, but those tables are not replicated, yes?
2024-02-05 03634, 2024
lucifer
would need additional handling in the application layer.
2024-02-05 03657, 2024
bitmap
editor is not replicated
2024-02-05 03607, 2024
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?
2024-02-05 03625, 2024
lucifer
so that you could do it independently of a schema change
2024-02-05 03603, 2024
bitmap
yeah, that is an option
2024-02-05 03618, 2024
yvanzo
editor public data is not replicated but it is dumped still
2024-02-05 03631, 2024
yvanzo
(and exported)
2024-02-05 03650, 2024
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.
2024-02-05 03651, 2024
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
2024-02-05 03618, 2024
lucifer
i see
2024-02-05 03602, 2024
lucifer
if we do OAuth before users then MeB Oauth provider needs to updated to read from MB in the meanwhile
2024-02-05 03615, 2024
lucifer
until the data is migrated from MB to MeB.
2024-02-05 03618, 2024
yvanzo[m] joined the channel
2024-02-05 03618, 2024
yvanzo[m]
Yes, it is probably safer to do it gradually
2024-02-05 03645, 2024
lucifer
which makes sense since MeB.org is not used by others like MB.org.
2024-02-05 03658, 2024
yvanzo[m]
MB could also be a proxy to MeB OAuth for a while
2024-02-05 03628, 2024
lucifer
that sounds fine to me but i am not sure if it comes with security implications
2024-02-05 03633, 2024
bitmap
yvanzo[m]: that was something else I wanted to discuss
2024-02-05 03615, 2024
lucifer
maybe we could ask this to the external security reviewers as well.
2024-02-05 03646, 2024
yvanzo[m]
that would still be like jumping off a cliff, but with a safety net
2024-02-05 03657, 2024
mayhem
kepstin, who knows security pretty well might be a good sounding board for this as well.
