Python Forum

I am planning a project to record journal entries and am intending on storing the data in a Postgres database. I was intending on creating a text based user interface in the terminal to input data into the database with an ORM tool like SQLAlchemy.

I was hoping to be able to read and write data to the database securely via the internet, and am thinking of using SSH to achieve that.

could anyone advise the best way to do it or provide some pointers?

Thanks in advance.

I agree with the use of SQLAlchemy, I have a tutorial here if you need it: https://python-forum.io/Thread-SqlAlchem...-Data-Load

If you haven't heard of it, there is a ( Cheese Shop ) here: https://pypi.org/ where you will find thousands on helpful packages most of which can be installed using pip
for example, SSH packages: https://pypi.org/search/?q=SSH

Finally, you may want to think about using Flask for the overall application, and if so, you can take this quick but excellent tutorial:
https://blog.miguelgrinberg.com/post/the...ello-world
especially the part on SQLAlchemy: https://blog.miguelgrinberg.com/post/the...v-database

I'm confused about the need for SSH. Aren't you going to use SQLAlchemy for talking to the database? Perhaps you need to give more details about what you're trying to do.

@ndc85430 - The intention was the application would run on a server which I would SSH into in order to make changes from my tablet or laptop while on the go. The database would be how the application recorded data, and SSH is how I would communicate with the application.

I am a beginner, so I am not sure if that is completely missing the mark. Thanks for the feedback so far.

Quote:The intention was the application would run on a server which I would SSH into in order to make changes from my tablet or laptop while on the go.

This would be better done not at the software level, but by using VPN