DefinitelyKeePass for me as well. I particularly like the keyfile feature where you need your master password plus a key file/pen/whatever to unlock the database

I think it's still in beta but you can already trim unused libraries :) Trim self-contained applications - .NET Core | Microsoft Docs[^]

True and that's why my company doesn't allow using pins. It should be fine for your home computers unless you think someone will still your stuff :) In that case, all bets are off.

(note sure if joking so assuming it's not) Nope, if you forget your pin you have to login to the machine using your regular password and then set a new pin. You need to be physically present on the machine.

Actually that is the same argument for why, possibly, aliens would destroy humanity if they ever came here. We are nothing compared to advanced civilizations so they wouldn't care about us. No malicious intent necessary. Lex Fridman had an awesome interview with Michio Kaku where they discuss this. It's super interesting. Here's the link if you want to take a look (starts at 15 minutes): Michio Kaku: Future of Humans, Aliens, Space Travel & Physics | Artificial Intelligence (AI) Podcast[^]

This is only true if you use a port above 1024. Ports bellow 1024 are given some extra "protections" by Linux, one of them being that your program must be executed as root to be able to bind to them. This means that if you use a port >1024 and get infected by something, that something can bind to that port, act like a ssh server and capture everything you are doing. As usual there are tons of discussions and opinions about this if you want to take a look: - Why not move SSH to another port? - BSD How To[^] - Why putting SSH on another port than 22 is bad idea[^] - Why putting SSH on another port than 22 is bad idea | Hacker News[^] This is probably overkill for what you and I do but I like to keep it safe (and I had to worry about this kind of stuff on a previous job although I'm not a security expert, not even close, so keep that in mind). One way to keep both benefits is to keep ssh on port 22 on your linux box but port-forward a random >1024 port on your router to port 22. Is this worth it? I'm not sure but at least it's one less thing to worry about.

Ah! Sorry for some reason I thought you didn't know about ssh keys :doh: Anyway I'm glad it works :) It's amazing what PuTTY and SSH can do for such "simple" programs. On a side note, be carefull about not running ssh on a standard port. You are giving up some linux protections when doing that.

Hi, sorry for taking so long to reply (looong weekend..). If I understand correctly then yes, that setup should work both locally on your network as well as remotely :) I should probably make a guide on how to set this up because with all the forwarding going on it gets really confusing really fast. Anyway let me know if you have any more trouble :) And if you want to make everything a little bit more secure, checkout how to connect using a key pair instead of a username/password

Ahah don't worry. I'm more than happy to help wherever I can :) Answering your question, yes you do need to open the putty connection before running your app otherwise it will not be able to connect to the database. You only need to do this once (when you turn on your PC for example) and then leave it open.

It doesn't. That's the great thing about it. From the app point of view, it's always connecting to a database on your local machine. You don't need to setup environment variables, hardcode credentials in code, etc, etc Here is my PuTTY setup. Create and save a PuTTY session (just to make things easier) and then add the ports you want (replace 127.0.0.1 with the IP address of your server). When you connect to the session, PuTTY will setup everything: https://i.imgur.com/qSX8pW2.png[^] If you want to make everything even easier, generate a ssh key pair. In that case you don't even need to provide a username/password.Just open the session and that's it. BTW, we are talking about databases but this works for any kind o server. As long as it's something listening on a port, you can do this. EDIT: Just realized something. Setp 5 is wrong. After step 4, save the session otherwise you'll need to do this everytime you connect. Then do step 5

Hi! In that case you have 2 options. The one I use is to configure your router to portforward an external port (say port 12345) to port 22 to you linux server. Then just use PuTTY on windows (or JuiceSSH on Android. I use both) to connect to :12345 as a reverse proxy. PuTTY, in turn, will open local port 5432 on your windows laptop/home computer. If you don't want or can't use portforward (e.g. the external IP of your router changes a lot), you have a second option. You can use something like SSHReach.me[^] . It works the same way but it's easier to setup. Then you just connect to their servers instead of your router. After this is setup, make your WinForms app connect to localhost:5432 and it will work. The beauty of this is that PostgreSQL thinks you are connecting from localhost so you don't need to send your password. I'm not sure if it's easier then setting up a VPN but for programming it provides (IMO) a lot more flexibility and (maybe) security then a VPN. I'll see if I can send you my PuTTY configuration when I get home. If all this is a little confusing (it was for me) take a look at this SO answer: networking - How does reverse SSH tunneling work? - Unix & Linux Stack Exchange[^] .

I use a reverse SSH connection. This will open a port on your local machine and tunnel it to your postgresql box. It's especially usefull when developing because you can always connect to localhost:5432 on your local machine instead of having to deal with connection strings and everything else. You don't even need to supply the login credentials to your server. It's way simpler then setting up a VPN and you still get all the security benefits (encryption, etc). There is also another (way cooler IMO) benefit. Bind the postgresql server to localhost:5432 and no one can connect to it, even from inside your lan but this might not e usefull to your case. IMO this makes it even more secure then just using a VPN.

Yeah I think you were right. Today I received almost all the emails from last week so I guess they might have triggered the spam filters and blocked the emails. Everything seems to be working fine now. Thanks!

Thanks for the reply. Unfortunately I'm still not receiving the newsletters. This is a corporate account but I'm almost sure it's not being blocked (I get emails with the replies to this thread for example). I'll wait until next week and I'll let you know if I start receiving them again (otherwise I'll check if there's a new rule blocking this kinds of emails, although there wasn't before)

Hi,

For a couple of days now I haven't received any of your newsletters. Last one I got was from wednesday last week.

Visiting https://www.codeproject.com/Feature/DailyBuild/ and https://www.codeproject.com/Feature/Insider/ I see the banner saying that I'm subscribed.

I haven't changed any settings as far as I know so I'm not sure what could be causing me to not receive the newsletters.

Thank you.

What I have tried:

Checked the spam folder and email filters as well as the subscription settings on the profile page.