+ 4

How can I start building a desktop application in Python working with SQL Server Database using Django server?

Ok, I try my best to to explain as clear as possible what is the scenario here. First, I need to be clear about that beyond the basics of Python programming, building a simple game, make a not-so-complicated query from a database, I know close to nothing about what a server is, how to connect your application to your database on a remote server, how to build windows forms, how to secure my app from SQL Injection, how Django can be of use here and probably many more that I am yet to be aware of. The task is simple, though, and I really really want to do this on my own, but every time I take a look at the internet, read the documentations, check YouTube how-to's, etc., I become so darn confused and exhausted that I ultimately give up. I just want to make a secure desktop application running on windows with a GUI in Python, which can maintain, process and get information from a database using SQL Server, that database is on a server which runs a Django 2.2. Do you get me? Thanks in advance.

17th Jul 2019, 12:35 PM
【𝓪𝓈𝒽𝓴𝓪ℕ♦ℝ𝓪𝓷𝒿𝓫𝓪𝓇】
【𝓪𝓈𝒽𝓴𝓪ℕ♦ℝ𝓪𝓷𝒿𝓫𝓪𝓇】 - avatar
2 Answers
+ 5
If the database already exists on a server then you can also connect to it remotely and query / manipulate data directly from the desktop application, again you would not need django for this necessarily. Just find the right library and you are all set... https://datatofish.com/how-to-connect-JUMP_LINK__&&__python__&&__JUMP_LINK-to-sql-server-using-pyodbc/
18th Jul 2019, 4:53 AM
Tibor Santa
Tibor Santa - avatar
+ 4
Django is a web framework. That means it can create html web pages using some back-end logic that involves databases and/or a backend python program running on the web server. If you want to build a stand-alone windows application then you don't need Django. You can build it in any of the python gui frameworks (tkinter, qt, pysimplegui, kivy) and connect it with a local database e.g. in sqlite or whatever engine you need. So first you need to figure out the architecture and functionality of your program, then look at the options how to implement it in python.
18th Jul 2019, 4:49 AM
Tibor Santa
Tibor Santa - avatar