+- Python Forum (https://python-forum.io)
+-- Forum: General (https://python-forum.io/forum-1.html)
+--- Forum: News and Discussions (https://python-forum.io/forum-31.html)
+--- Thread: Python database application (/thread-12597.html)
Python database application - SimonU - Sep-02-2018
Hi everyone,
I am very new to Python, hope you share your knowledge with me.
I need to develop an accounting application(database) with Python for my company.
There are 10 user ( 1 admin, 2 superuser and 7 users)
I am the admin so I always need to remote logon to normalize data, update the modules and functions.
Which framework, SQLALchemy or others is better for my case?
I prefer to have users to logon thru web browser.
Would it be better with API application or web browser?
Please advise.
Thank you,
SimonU
RE: Python database application - Larz60+ - Sep-02-2018
I would use an existing database administrator, rather than trying to create my own. They tend to be very flexible and allow for on the spot queries, visualizing tables, altering or any other task you can think of.
They as far as i know are available for every DBM. For sqlite3, there's sqliteman: https://sourceforge.net/projects/sqliteman/
For postgreSQL, PgAdmin, etc.
see: https://www.capterra.com/database-management-software/