Getting back in the game

[Hamster]

I can start with SQLITE. Would like to move to proper RDBMS as soon as possible. I know SQL Server. Not sure how well Flask / SQLAlchemy plays with it or MySQL / Oracle might be better.

Flask makes is a web framework (a router) so should have no impact on your choice of DB.

Flask

Flask is a popular, extensible web microframework for building web applications with Python.

www.fullstackpython.com

It allows you to do this:

from flask import Flask
app = Flask(__name__)


@app.route('/')
def hello_world():
    return 'Hello, World!'

if __name__ == '__main__':
    app.run()

For a DB (I recommended sqlite so you don't have to mess around with yet another server) I would look at postgres. There shouldn't be any issues though and depending on the type of application you can get pretty far with sqlite. In fact, as long as your application is not especially write-heavy you may never need a db server.

If you are going to code a blog or some type of content site (blog, photography, recipes, reviews etc) you may want to look at mongo or some other type of no-sql database.

...and down the rabbit hole we go

 

[pantoffel]

Since you knew and used C# you can just use that along with ASP.NET...you can throw in for example Bootstrap if you want your sites to be a bit more reactive.

Learning ASP.NET isn't that hard, adding Bootstrap in is more of a mission.

Thank you. You’re right, ASP.Net would make sense considering my previous experience with c# and SQL Server.

I’ll tell you what though: I’ve tried several times already with ASP.Net and gave up. Not sure why. It’s like (for me at least), as if ASP.Net changes drastically every 3 months. It always felt like a moving target for me. And recently MS added .Net Core. I dunno. I’m just not sticking to ASP.

The little bit I already looked into Node, Django and Flask - they look more straight forward, less of maize, less of a moving target.

Probably my perception of ASP.Net is wrong but I’ve been battling to get a grip on it hey.

Still, in theory your suggestion makes a lot of sense and probably warrants another look from me.....

Thanks!

 

[_kabal_]

I haven’t used any python frameworks, but I have used many other programming languages for large projects.

I honestly think that dotnet core is a great place to start.

nodejs is a “programming language”/runtime, you still need to pick your poison. I love javascript to bits, but imo I don’t think that node is a great place to start. If you are already comfortable with programming, then that is another story.

my personal favourite stack of choice at the moment is code first graphql with nestjs, using prisma2 as an “orm” and vuejs with nuxt

 

[charlieharper]

I'm sure somebody is going to throw Docker, Vagrant, Kafka and all sorts of tech into the mix.

Unless you're working in a giant team for big Corpo 2.0, Docker and co is overkill.
Very unlikely that you'll need it. With all respect, it will cause a lot of pointless overhead that will have little or no productivity impact.

Learn Git instead.

 

[_kabal_]

Wrong.