[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/pul…
2022-03-21 08002, 2022
alastairp
this is something that mayhem has been working on
2022-03-21 08013, 2022
BrainzGit
[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/pul…
2022-03-21 08014, 2022
Shubh has quit
2022-03-21 08034, 2022
BrainzGit
[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/pul…
2022-03-21 08048, 2022
PrathameshG
alastairp: sounds good
2022-03-21 08029, 2022
PrathameshG
Really Trying to wrap my head around postgresql
2022-03-21 08057, 2022
alastairp
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-3b4…)
there is a python package called psycopg2 which is the main tool used to interact with postgres from python
2022-03-21 08025, 2022
lucifer
we usually use psycopg2 for connecting with postgres but pandas has a read_sql so you could try that too.
2022-03-21 08048, 2022
alastairp
oh yeah, that might also work if you just want to load a block of data into memory
2022-03-21 08010, 2022
alastairp
yes, musicbrainz_db is on bono - look at the commands above that I pasted
2022-03-21 08012, 2022
lucifer
yes sort of, a replica of the production musicbrainz_db is hosted on bono
2022-03-21 08049, 2022
PrathameshG
lucifer: thanks, that might hit closer to home
2022-03-21 08001, 2022
alastairp
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
2022-03-21 08029, 2022
PrathameshG
alrighty. Also, I hope I don't have enough privilages to mess up the database accidentally
2022-03-21 08051, 2022
alastairp
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
2022-03-21 08005, 2022
PrathameshG
Cool
2022-03-21 08014, 2022
alastairp
just run commands that start with "SELECT" and you'll be fine
2022-03-21 08040, 2022
lucifer
lol just what i was going to say :D
2022-03-21 08006, 2022
PrathameshG
Well that's some good advice lol
2022-03-21 08049, 2022
PrathameshG
Thankfully I should be done with my SQL course in a week. Hopefully that'll help with most of the SQL stuff.
2022-03-21 08019, 2022
PrathameshG
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.
2022-03-21 08047, 2022
PrathameshG
TLDR: Is there any interactive auth built into vanilla git on linux that I could use?
2022-03-21 08048, 2022
lucifer
alastairp: fyi, #1917-#1921 were released today. iirc some of those were on your list.
2022-03-21 08053, 2022
alastairp
thanks lucifer! ❤️
2022-03-21 08011, 2022
alastairp
PrathameshG: yes, you'll want to use ssh keys!
2022-03-21 08030, 2022
lucifer
PrathameshG: i don't think so. fwiw, we usually use ssh keys but if you want gh cli we can install it on bono.
Its pretty much a convenient way to login with a browser.
2022-03-21 08020, 2022
PrathameshG
I just use `gh auth login -p https -w` and rest gets handled
2022-03-21 08032, 2022
alastairp
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?
2022-03-21 08007, 2022
PrathameshG
TBVH I am just afraid of losing the tokens 💀
2022-03-21 08008, 2022
PrathameshG
Also, its inconvenient to go and fetch them everytime
2022-03-21 08007, 2022
PrathameshG
If you don't mind, how do you exactly login with SSH as fast as possible on a termnial?
2022-03-21 08039, 2022
PrathameshG
basically what's your workflow for authenticating git on a remote server
2022-03-21 08023, 2022
lucifer
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.
2022-03-21 08046, 2022
BrainzGit
[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-server/…
2022-03-21 08052, 2022
PrathameshG
Sounds pretty convenient
2022-03-21 08001, 2022
alastairp
PrathameshG: for ssh, I have a (private) key on my home computers, and the corresponding public keys in bono and github
2022-03-21 08025, 2022
alastairp
if you don't know about ssh keys in general, you can read about public key cryptography
2022-03-21 08052, 2022
PrathameshG
Yes, reading up on that RN 👀
2022-03-21 08015, 2022
PrathameshG
The github documentation for all this is pretty great too
2022-03-21 08048, 2022
alastairp
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)
2022-03-21 08053, 2022
PrathameshG
Pretty sick, I really needed that.
2022-03-21 08054, 2022
PrathameshG
Gotta stop typing the whole SHH command with portforwarding like a dumbass everytime 🤦♂️
2022-03-21 08038, 2022
alastairp
you can put portforwarding options in the ssh config too!
2022-03-21 08047, 2022
PrathameshG21 joined the channel
2022-03-21 08050, 2022
PrathameshG21 has quit
2022-03-21 08007, 2022
PrathameshG16 joined the channel
2022-03-21 08025, 2022
cuanim has quit
2022-03-21 08058, 2022
PrathameshG16 has quit
2022-03-21 08026, 2022
PrathameshG has quit
2022-03-21 08033, 2022
PrathameshG11 joined the channel
2022-03-21 08039, 2022
PrathameshG11 has quit
2022-03-21 08028, 2022
PrathameshG joined the channel
2022-03-21 08010, 2022
PrathameshG
Alrighty, SSH was pretty easy.
2022-03-21 08010, 2022
PrathameshG
I see, that's even better than using interactive logins if you know what you're doing
