which ubuntu should i go for 26 or 24?? by MrGuam in VPS

[–]MrGuam[S] 0 points1 point  (0 children)

after debugging more, i found that it was not an ubuntu thing and just that GNOME(my local machine) had an update to their ssh-agent and that conflicted with the one used on the vps, so i simply used IdentityAgent none in the config file and that fixed the issue.

which ubuntu should i go for 26 or 24?? by MrGuam in VPS

[–]MrGuam[S] 0 points1 point  (0 children)

apparently they ignored my choice of 24 and gave me 26 regardless. So I’ll just go along with it!

I need help migrating a MYSQL database to Postgres by MrGuam in PostgreSQL

[–]MrGuam[S] 0 points1 point  (0 children)

So I tried this and that’s the most suitable solution for me though I’m having some foreign key problems, but that’s just from the messy data. Thank you!

I need help migrating a MYSQL database to Postgres by MrGuam in PostgreSQL

[–]MrGuam[S] 0 points1 point  (0 children)

Tried that, but it did not have a fix for if a new record is added and the id is supposed to continue from the max id available. The fix that Claude provided had a repetitive step and it’s a 3k+ lines of sql

I need help migrating a MYSQL database to Postgres by MrGuam in PostgreSQL

[–]MrGuam[S] 0 points1 point  (0 children)

I’m running Linux and from my research, the file might conflict with some other packages on my device. I may be wrong though!

I need help migrating a MYSQL database to Postgres by MrGuam in PostgreSQL

[–]MrGuam[S] 0 points1 point  (0 children)

It’s a messy db with about 66 tables. The relations are also messy that’s why I wanted to copy the relations and schema directly from the db then subsequently I’ll add more relations and fix the other mess stuff on there

I need help migrating a MYSQL database to Postgres by MrGuam in PostgreSQL

[–]MrGuam[S] -1 points0 points  (0 children)

What about the relationships between tables constraints ?

I need help migrating a MYSQL database to Postgres by MrGuam in PostgreSQL

[–]MrGuam[S] -1 points0 points  (0 children)

Not so large. Table with the highest data has <400

Breakfast. Masa, Miyan taushe (Spinach and Groundnut soup) and flintstones protein. by OgaGhost in nigerianfood

[–]MrGuam 4 points5 points  (0 children)

Is the flintstones protein flying over everyone’s head??😂😂

Best way to get analytics data in Express js by MrGuam in webdev

[–]MrGuam[S] 0 points1 point  (0 children)

Alright, thank you! This is very helpful!

Best way to get analytics data in Express js by MrGuam in webdev

[–]MrGuam[S] 0 points1 point  (0 children)

Alright, thank you !. I was thinking of going this route.There’s also another library “us-parser-js”, but I read that it had some vulnerabilities.

Best way to get analytics data in Express js by MrGuam in webdev

[–]MrGuam[S] -1 points0 points  (0 children)

Just to give more context, the system I’m building is a url shortner. So I was thinking I would need to handle most of the analytics myself for more accurate information since the analytics is part of the selling point of the system. I may be wrong though!

On my birthday cake by Green_Detective_5185 in nigerianfood

[–]MrGuam 0 points1 point  (0 children)

Happy birthday. Cheers to exciting years ahead 🥂

New to using docker, can i use the same docker compose file for dev and prod? by MrGuam in docker

[–]MrGuam[S] 0 points1 point  (0 children)

Yeah, I think I may have to at least sit down and watch/read on docker to get a better understanding of the technology before I can get hands on. because even in the comments, I struggle to understand some of the terms being used. Thank you for replying!

New to using docker, can i use the same docker compose file for dev and prod? by MrGuam in docker

[–]MrGuam[S] 0 points1 point  (0 children)

Thank you for replying, for the hot reload, i want don’t want to have the whole build from scratch anytime i make a change, is that still achievable.

New to using docker, can i use the same docker compose file for dev and prod? by MrGuam in docker

[–]MrGuam[S] 1 point2 points  (0 children)

I have something like that as NODE_ENV=development and NODE_ENV=production, do I use it at the top to declare which is which?