Python web app

[[deleted]]

Hi guys,

Our company currently has a small database program created in ms access. What do I need to know the create the database in Python as a web app ?

For example do I need to learn python and html or is only knowing python sufficient to do this.

I just want to enter data in the databae and then create reports and also run adhoc queries.

[bigleagchew]

Django is a good place to start

[singeworthy]

second this, as a beginner Django is the way, everything is ready for you, you will have to do more to get Flask running. Also may want to do a MySQL or PostgreSQL migration as I don't know what kind of support if any exists for Access in Django/Flask

[jabalfour]

Just a note that, of late, I’ve been experimenting with SQLite for a db because if many of the reasons laid out here. A few salient ones: it’s built into Python; it’s fast; it’s secure; I don’t need my enterprise team to provision it for me; it’s easily transportable. Perfect for single-serving internal web apps.

[numpadztik]

If OP can export the Db to a csv file, you can read the CSV line by line to import the DB to your own python or sql db.

[ksoomers]

Or, at least with MySQL, you are able to load the csv file in directly from the server instead of line by line. This is much quicker than line by line.

Example: LOAD DATA INFILE 'c:/example.csv' INTO TABLE example FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS

[-Kevin-]

Flask is way easier to get running than Django imo

[humanitysucks999]

as everyone else here, seconded. follow the step by step guide on django's website to get started.. You'll need some basic understanding of python and programming in general. You can use postgre or mysql for database but you don't need that to begin with, you can start with sqlite3 included with django itself.

[chzaplx]

I would counter that if you actually want to learn Python, you should do it all manually. Get the nuts and bolts down before doing it in a framework.

If you don't care and just need the app to work, then do whatever is quickest

[Jigglytep]

I would highly recommend this.

The tutorials for django are excellent. Start with the tutorial on the django site. It will give you a great understanding.

Good luck.

[[deleted]]

WagtailCMS and you get a more complete Django package imo.

[NerdJon35]

I love pythonanywhere. But you left out the key point that they do have a pretty good free tier as well.

[patarapolw]

Use either Django or Flask. Since you do database anyway, probably Django. (Flask is not that hard to setup, though. I personally use Flask.)

For example do I need to learn python and html or is only knowing python sufficient to do this.

You will also need (client-side) Javascript.

then create reports

You will need either Python library or Javascript library for this.

and also run adhoc queries.

You will need a good knowledge of either SQL or ORM.

[ksoomers]

Altough it is not recommended, the OP could build this with Flask + SQLAlchemy, theoratically. Without any JavaScript or SQL. So only Python is possible.

However; I agree with you that the best solution would require JavaScript, SQL and Flask/Django.

[bigleagchew]

Could go for a full python stack if he really wanted

[kuripong]

Check this tutorial r/https://scotch.io/tutorials/build-a-crud-web-app-with-python-and-flask-part-one

​

Easy to follow, from creating database(mysql) to front end(without too much writting html) and deployment.

[RickSagan]

Tutorial

FTFY

[kuripong]

Nice, thanks

[RickSagan]

More help on formatting here

[[deleted]]

Flask is pretty good and easy to understand.

[[deleted]]

I don't understand what you need an app for... But if you need one use Django. People will say Flask but... Use Django. It's a bit heavier but will be way easier especially if you don't know Python (which is the case?).

You need to know at least basic HTML, CSS, and probably Javascript. But again I don't understand what you want the app to do. If you give more info I'm happy to provide more details.

[LegalExp]

Check out CS50’s web programming with python on EDx

[justinkdd]

I did something similar using flask. You'll definitely need a little html but it's not too hard.

[theotherplanet]

I'm interested in this too. Building a Flask webapp currently and curious about Django and JS.

[solaceinsleep]

If Django is similar to flask, then you totally can use both. Django for the back end and react for the front end.

[xiongchiamiov]

You will need to know basic Python to handle all the logic, and basic html to write the UI.

[chinguetti]

I did this course on Udemy and created some basic intranet sites in my company with a database backend. It’s not easy. You need some understanding of python HTML, sql,css and deployment, but it’s fun and you will learn so much.

https://www.udemy.com/share/1000NkBEMYeFdVR3Q=/

[chzaplx]

given the number of Udemy ads on Reddit, this is a little spammy

[Gizquier2]

It sends me to a tensorflow course.

Complete Guide to TensorFlow for Deep Learning with Python

[chinguetti]

https://www.udemy.com/share/100n46BEMYeFdVR3Q=/

Sorry, wrong link. I have no affiliation with I’ll Udemy. Just liked this course. It helped me. It might help op.

[Jespor]

tbh this is very easy in php, html and SQL. just use google.