Anyone played with Postgres' full-text search capabilities? I'm looking to add search based on a release group's title + artist. Would you go with one of the default configurations? If so, which one? If not, is there anyone you recommend?
2022-04-25 11558, 2022
lucifer
mayhem can tell you about the config we used in our experiments.
2022-04-25 11540, 2022
q3lont
that'd be awesome. I'm pretty new to this stuff, just reading about it yesterday, and I figured I might go with the 'simple' one, since release groups might not be just english-specific. But if I searched for "stimul" it wouldn't match "stimulator" (which makes sense for 'simple', but...)
2022-04-25 11504, 2022
mayhem
q3lont: yes, that is a good insight.
2022-04-25 11532, 2022
mayhem
there are other facets that influenced our decisions -- spelling mistakes and scalability.
2022-04-25 11506, 2022
mayhem
if you need to correct for spelling mistakes or other minor textual errors, then you need a fuzzy version of search -- postgres trigram work great for that.
2022-04-25 11522, 2022
mayhem
but they have the downside that they get very very slow the more fuzziness a query has.
2022-04-25 11549, 2022
mayhem
which for us is a dealbreaker. we need our solutions to be more scalable.
2022-04-25 11503, 2022
mayhem
which is why we use typesense instead of postgres.
2022-04-25 11551, 2022
q3lont
might I ask for which project is that? for musicbrainz.org?
No mailed in reviews, so the regulars are up: lucifer, mayhem, akshaaatt, reosarevok, atj, bitmap, zas, alastairp, yvanzo, monkey, CatQuest, Freso – anyone else who want to give review, let me know ASAP. :)
2022-04-25 11515, 2022
Freso
lucifer: Go!
2022-04-25 11522, 2022
lucifer
hi all!
2022-04-25 11531, 2022
aerozol
I am here too Freso :)
2022-04-25 11551, 2022
CatQuest
aerozol! morena!
2022-04-25 11552, 2022
mayhem
happy 5am aerozol!
2022-04-25 11512, 2022
aerozol
:D buenos días!
2022-04-25 11537, 2022
monkey
Eek, 5AM.
2022-04-25 11547, 2022
lucifer
previous 2 weeks was lots of work on recommendations and related stuff. other than that some LB bug fixes, helping GSoC applicants with applications. and also participated in the secrity meeting. fin.
2022-04-25 11550, 2022
lucifer
mayhem: next?
2022-04-25 11556, 2022
mayhem
k
2022-04-25 11512, 2022
Freso
(Still up: akshaaatt, reosarevok, atj, bitmap, zas, alastairp, yvanzo, monkey, CatQuest, aerozol, Freso – anyone else who want to give review, let me know ASAP. :))
2022-04-25 11513, 2022
mayhem
last week I personally had a rough week so, I didn't really get as much done as I had wanted.
2022-04-25 11530, 2022
mayhem
most the usual BS for metabrainz as well as gsoc application triaging.
2022-04-25 11548, 2022
mayhem
we had a slow start to GSoC but in the end we recveived a lot of good applications.
2022-04-25 11557, 2022
mayhem
and the WTF applications were *extra* WTF this time around.
2022-04-25 11502, 2022
mayhem
fun to read certainly.
2022-04-25 11504, 2022
CatQuest
:D
2022-04-25 11511, 2022
monkey
!m GSoC participants !
2022-04-25 11511, 2022
BrainzBot
You're doing good work, GSoC participants !!
2022-04-25 11514, 2022
aerozol
amazing!
2022-04-25 11527, 2022
CatQuest looking forward to many of them
2022-04-25 11539, 2022
mayhem
lucifer: and I have been working on recommendations and trying to get them to improve with loads of tuning. we now have better tools, better understanding and our recommended tracks are improving quite a lot.
2022-04-25 11508, 2022
mayhem
I hope to write troi-bot part this week that will give all users who follow troi-bot daily playlists so we can all start complaning about them.
2022-04-25 11521, 2022
mayhem
its been a really long road to get here, but now we're days away.
2022-04-25 11534, 2022
mayhem
stellar job MeB team!
2022-04-25 11538, 2022
mayhem
aerozol: go!
2022-04-25 11503, 2022
aerozol
Kia ora! It's been a slow few weeks/months for me, buried in other work
2022-04-25 11518, 2022
aerozol
but also partly because I've been trying to tease things apart in a design sense
2022-04-25 11537, 2022
aerozol
so it's been slow going, but hopefully important stuff
2022-04-25 11505, 2022
aerozol
mainly standardising all the logos, so that we now have a library of logos in the logo repo
2022-04-25 11513, 2022
aerozol
that all match and are ready to go
2022-04-25 11522, 2022
CatQuest
!m aerozol
2022-04-25 11522, 2022
BrainzBot
You're doing good work, aerozol!
2022-04-25 11523, 2022
aerozol
if I catch anyone using an old one.... ;P
2022-04-25 11524, 2022
akshaaatt
!m aerozol
2022-04-25 11525, 2022
BrainzBot
You're doing good work, aerozol!
2022-04-25 11542, 2022
aerozol
Also putting together some guidelines for MetaBrainz design and MusicBrainz design
2022-04-25 11555, 2022
mayhem
I'm soo happy the logos got sorted.
2022-04-25 11530, 2022
aerozol
Initially I was hoping to have one doc that covers all projects but I should have realised they were too different already
2022-04-25 11505, 2022
aerozol
It would be great to get feedback on the design docs after, because the timings good with GSOC applicants lately
2022-04-25 11521, 2022
aerozol
They all ask very similar questions and some docs might help!
2022-04-25 11542, 2022
CatQuest
+1
2022-04-25 11555, 2022
aerozol
That's my novel done, go akshaaatt!
2022-04-25 11504, 2022
akshaaatt
Hi Everyone!
2022-04-25 11507, 2022
CatQuest
hi!
2022-04-25 11518, 2022
akshaaatt
For the past few days, I have been learning loads of new stuff.
I have finally made the integration of ListenBrainz in the MB Android App at https://github.com/metabrainz/musicbrainz-android… and it is superb! The app is gonna get 5 times the users if things go as planned :)
2022-04-25 11504, 2022
CatQuest
reocodespam <3
2022-04-25 11509, 2022
akshaaatt
also spent a lot of time debugging issues and resolving them.
2022-04-25 11529, 2022
akshaaatt
The best news I have so far is that https://test.musicbrainz.org has been made responsive and things look wonderful and I'm enjoying it like crazy.
2022-04-25 11534, 2022
akshaaatt
Do check it out!
2022-04-25 11513, 2022
ephemer0l joined the channel
2022-04-25 11516, 2022
akshaaatt
That's about it for me. Coordinating on some GSoC stuff and yeah the usual! fin!
2022-04-25 11521, 2022
akshaaatt
Go alastairp!
2022-04-25 11531, 2022
alastairp
wow, great work on test, akshaaatt!
2022-04-25 11533, 2022
alastairp
hi
2022-04-25 11534, 2022
Freso
(Still up: reosarevok, atj, bitmap, zas, yvanzo, monkey, CatQuest, Freso – anyone else who want to give review, let me know ASAP. :))
2022-04-25 11505, 2022
alastairp
very quiet week for me last week - we had family at home plus the short week I didn't get much done at all
2022-04-25 11559, 2022
alastairp
I did some back-and-forward with people to finish gsoc proposals, wd to everyone who submitted those, I reviewed some CB PRs, and responded to a security bug in CB
2022-04-25 11516, 2022
alastairp
I attended the MeB security meeting
2022-04-25 11506, 2022
alastairp
I did some planning after discussion with monkey on what was going to be our next dev sprint - to introduce react server side rendering to LB, let's see if I have time before the end of the month to make progress on that
2022-04-25 11512, 2022
alastairp
that's me, reosarevok next?
2022-04-25 11516, 2022
reosarevok
Hi
2022-04-25 11544, 2022
reosarevok
I worked on implementing a bunch of stuff for genres that is allowed by the schema changes (annotations, URL relationships, boring aliases that do nothing useful yet but at least exist)
2022-04-25 11509, 2022
alastairp
aliases!
2022-04-25 11517, 2022
CatQuest
boring aliases!
2022-04-25 11522, 2022
reosarevok
that do nothing yet!
2022-04-25 11523, 2022
reosarevok
But yeah
2022-04-25 11525, 2022
CatQuest
:DDD
2022-04-25 11536, 2022
reosarevok
And I tried to debug the wikidatabot, Mineo helped a bit, we might have found the issues (didn't have time to check yet because I spent today fixing new small tickets)
2022-04-25 11543, 2022
CatQuest
\o/
2022-04-25 11502, 2022
aerozol
excited about any genre updates woo
2022-04-25 11503, 2022
reosarevok
Hopefully I can have it working properly by the end of the week? No promises yet
2022-04-25 11507, 2022
reosarevok
Anyway, go CatQuest!
2022-04-25 11513, 2022
CatQuest
Meow! `😺`
2022-04-25 11520, 2022
CatQuest
so, this week I was a lot more productive than I was expecting.
2022-04-25 11529, 2022
CatQuest
did work and
2022-04-25 11529, 2022
CatQuest
swept outside and planted flower-leeks and other spring things
2022-04-25 11541, 2022
CatQuest
sadly those things aren't really brainz related,
2022-04-25 11547, 2022
CatQuest
But I did infact manage to add a few tickets and test beta Bookbrainz and
2022-04-25 11553, 2022
CatQuest
!m monkey for the new beta-release routine!
2022-04-25 11553, 2022
BrainzBot
You're doing good work, monkey for the new beta-release routine!!
2022-04-25 11500, 2022
CatQuest
as well as adding some books and releases and retagging and suches.
2022-04-25 11529, 2022
CatQuest
had some discussion on the community.. thanks kellnerd, indy, monkey and aerozol for lots of interesting input.
2022-04-25 11542, 2022
CatQuest
This week I will also be doing much of the same, but I hope to also be able to squeeze an instrument or two in as well ♓
2022-04-25 11549, 2022
CatQuest
fin, go monkey!
2022-04-25 11500, 2022
monkey
Hi !
2022-04-25 11505, 2022
Freso
(Still up: atj, bitmap, zas, yvanzo, Freso – anyone else who want to give review, let me know ASAP. :))
2022-04-25 11515, 2022
monkey
For the past two weeks I did a lot of reviewing GSoC applications and PR Reviews. Again congrats to everyone who submitted a proposal !
2022-04-25 11535, 2022
monkey
I continued work on the LB metadata viewer, and investigated some potential BrainzPlayer bugs
2022-04-25 11505, 2022
mayhem
any chance we can deploy that soon? even if it isn't perfect, so we can keep testing.
2022-04-25 11510, 2022
monkey
Lots of dicsussions in Bookbrainz forums, deploying a new release and continuing fixing issues
2022-04-25 11538, 2022
monkey
Finally, did some admin and database maintenance, ticket triage and such
2022-04-25 11550, 2022
monkey
Oh, and I fixed Korea.
2022-04-25 11553, 2022
monkey
Yes, you read that right
2022-04-25 11555, 2022
mayhem
woah.
2022-04-25 11502, 2022
mayhem
can you fix russia next?
2022-04-25 11513, 2022
zas
yes please...
2022-04-25 11514, 2022
CatQuest
oh no.
2022-04-25 11522, 2022
monkey
In real life, I'm currently in the process of moving apartments, which means lots of packing, which means less time for work.
2022-04-25 11537, 2022
monkey
That's it for me ! atj go !
2022-04-25 11541, 2022
alastairp
but your new house looks great!
2022-04-25 11545, 2022
aerozol
If you want Russia to be fixed, make a ticket at least, geez
2022-04-25 11547, 2022
mayhem
and I hope you voted for the lesser of two evils too!
