#metabrainz

Side question: Is it safe to login with my github credentials on bono?

oh you could also just do it all in memory. 26658151 recording mbids in total, 56bytes a uuid in python comes to ~1.5 G if my calculation is right.

lucifer: yeah, that's just what I was trying now

Are we talking about 26658151 unique IDs here?

but i think db will be more optimized anyway. unless pandas/numpy has something specialized for it.

yes

F

PrathameshG:

this might also be useful too - remember how we mentioned last week that we want to try and find canonical recordings?

[bookbrainz-site] 14dependabot[bot] opened pull request #816 (03master…dependabot/npm_and_yarn/eslint-plugin-babel-5.3.1): chore(deps-dev): bump eslint-plugin-babel from 4.1.2 to 5.3.1 https://github.com/metabrainz/bookbrainz-site/p...

this is something that mayhem has been working on

[bookbrainz-site] 14dependabot[bot] opened pull request #817 (03master…dependabot/npm_and_yarn/swagger-jsdoc-6.1.0): chore(deps): bump swagger-jsdoc from 4.3.2 to 6.1.0 https://github.com/metabrainz/bookbrainz-site/p...

[bookbrainz-site] 14dependabot[bot] opened pull request #818 (03master…dependabot/npm_and_yarn/babel/plugin-proposal-object-rest-spread-7.17.3): chore(deps-dev): bump @babel/plugin-proposal-object-rest-spread from 7.16.0 to 7.17.3 https://github.com/metabrainz/bookbrainz-site/p...

alastairp: sounds good

Really Trying to wrap my head around postgresql

the idea of a canonical recording is that much of the time when people talk about a specific song ("Comfortably numb by Pink Floyd"), they mean something quite specific (track 18 on the original release of The Wall: https://musicbrainz.org/release/14db3839-4007-3...)

compared to any of the hundreds of live recordings that might exist by the same band: https://musicbrainz.org/search?query=%22Comfort...

if you have any problems/questions with postgres then please let us know

Yea actually I do have one.

How do I use postgresql with python

sorry for such a basic question, I am pretty new to SQL haha

definitely a good first question ;)

Also, is the musicbrainz_db hosted on bono?

something like this sample code that we have might help you: https://github.com/metabrainz/listenbrainz-serv...

there is a python package called psycopg2 which is the main tool used to interact with postgres from python

we usually use psycopg2 for connecting with postgres but pandas has a read_sql so you could try that too.

oh yeah, that might also work if you just want to load a block of data into memory

yes, musicbrainz_db is on bono - look at the commands above that I pasted

yes sort of, a replica of the production musicbrainz_db is hosted on bono

lucifer: thanks, that might hit closer to home

right - good point, this isn't the real main musicbrainz database, just a copy - but it's kept up to date, every hour it downloads and applies changes from the main database

alrighty. Also, I hope I don't have enough privilages to mess up the database accidentally

that's unlikely to happen, and if it does we can recreate the database from scratch in about 15 minutes, so it's not like it's a problem if it does happen

Cool

just run commands that start with "SELECT" and you'll be fine

lol just what i was going to say :D

Well that's some good advice lol

Thankfully I should be done with my SQL course in a week. Hopefully that'll help with most of the SQL stuff.

Another newbie question. I generally use `gh auth login` to login with my github credentials on remote devices. As for plain git authentication, I avoid using token authentication due to various reasons.

TLDR: Is there any interactive auth built into vanilla git on linux that I could use?

alastairp: fyi, #1917-#1921 were released today. iirc some of those were on your list.

thanks lucifer! ❤️

PrathameshG: yes, you'll want to use ssh keys!

PrathameshG: i don't think so. fwiw, we usually use ssh keys but if you want gh cli we can install it on bono.

Cool, I can get around that one

lucifer: It's alright. I should get used to the industry standard as soon as possible

I applaud that ^

btw, how does `gh auth` work anyway? I suspect it uses token auth behind the scenes?

> The default authentication mode is a web-based browser flow. After completion, an authentication token will be stored internally.

Its pretty much a convenient way to login with a browser.

I just use `gh auth login -p https -w` and rest gets handled

riight - but is your preference to not use tokens because you don't like auth tokens in general, or because you don't like to paste the token in each time you do a remote git operation?

TBVH I am just afraid of losing the tokens 💀

Also, its inconvenient to go and fetch them everytime

If you don't mind, how do you exactly login with SSH as fast as possible on a termnial?

basically what's your workflow for authenticating git on a remote server

you don't need to login at all with ssh key (unless you specify a passphrase for it) :). just generate the key once, add to your github account and be done with it. everything else happens automagically.

[musicbrainz-server] 14reosarevok merged pull request #2373 (03master…MBS-11655): MBS-11655 / MBS-12136: Separate tag cloud into genre and non-genre tags, and add a text list https://github.com/metabrainz/musicbrainz-serve...

Sounds pretty convenient

PrathameshG: for ssh, I have a (private) key on my home computers, and the corresponding public keys in bono and github

if you don't know about ssh keys in general, you can read about public key cryptography

Yes, reading up on that RN 👀

The github documentation for all this is pretty great too

I also have an ssh config file which has a specific section for bono that looks like this:

so I can just type 'ssh bono' (the definition after the word Host on the first line), and it will automatically connect to the correct host with the specific username (very useful if your username on your local machine is different to that on the remote host)

Pretty sick, I really needed that.

Gotta stop typing the whole SHH command with portforwarding like a dumbass everytime 🤦‍♂️

you can put portforwarding options in the ssh config too!

Alrighty, SSH was pretty easy.

I see, that's even better than using interactive logins if you know what you're doing