# Advice for beginner for database app

**URL:** <https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025>\
**Category:** Python\
**Created:** [April 10, 2021, 7:16pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025 "2021-04-10T19:16:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrasx853](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@andrasx853](https://forum.codewithmosh.com/u/andrasx853)\
**Post date:** [April 10, 2021, 7:16pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/1 "2021-04-10T19:16:50Z")

</div>

Dear Mosh, Community

I am passionate about database apps and looking for resources(books, tutorials etc) for building database applications similar than on the picture in the link. There are a lot of questions in my head such as which language I should use and what GUI library to implement whether on desktop or online it would be.

[https://www.applications-platform.com/wp-content/uploads/2020/01/05-Quotes-v3.png](https://www.applications-platform.com/wp-content/uploads/2020/01/05-Quotes-v3.png)

The topics I am looking for is based on its features.

- The desktop app would connect to a database (SQLite)
- It would have also an internal database,
- rich GUI data list - How to connect GUI with database?
- and it would come own fileformat if it is desktop application

How to start building up my skills for all of the above mentioned features?

Which one would be the most simplest path? I currently have Python skill for scripting as well as Html, CSS, JS and C#.

- JAVA with JavaFx,
- Python with PyQt,
- Win Forms
- Python with Django React for web.
- Any other?

---

<div class="post-metadata">

**Author:** ![NicolasATC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/nicolasatc/32/714_2.png) [@NicolasATC](https://forum.codewithmosh.com/u/NicolasATC)\
**Post date:** [April 11, 2021, 4:09pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/2 "2021-04-11T16:09:05Z")

</div>

Other possibilities:

- Javascript/HTML/CSS/Electron
- C# and WPF
- Swift if you want to build for Mac

But in the end it all depends for what OS you want to build your app for. If you want to build for MacOS, Windows or Linux…or if you want to build it as a web app. As I see you want to build it for desktop, so you have that figure it out.

> [@andrasx853](#):
>
> How to start building up my skills for all of the above mentioned features?

I’d first start by learning a language. Which one? hard to tell. C# is a pretty strong language and .NET will allow you to develop for a lot of options (desktop, backend, web, cloud)

Database managment is not hard at all, so you can take the ‘Complete SQL mastery’ course by Mosh, which is really good.

Just my opinion… 😬

---

<div class="post-metadata">

**Author:** ![NicolasATC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/nicolasatc/32/714_2.png) [@NicolasATC](https://forum.codewithmosh.com/u/NicolasATC)\
**Post date:** [April 11, 2021, 9:50pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/3 "2021-04-11T21:50:40Z")

</div>

Forgot to add: take a look at .NET MAUI

> **[The New .NET Multi-platform App UI | Xamarin Blog](https://devblogs.microsoft.com/xamarin/the-new-net-multi-platform-app-ui-maui/)**
>
> Get excited about the highlights for the new .NET Multi-platform App UI (MAUI) that was announced at BUILD 2020.

---

<div class="post-metadata">

**Author:** ![andrasx853](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@andrasx853](https://forum.codewithmosh.com/u/andrasx853)\
**Post date:** [April 11, 2021, 10:10pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/4 "2021-04-11T22:10:40Z")

</div>

Thank you. Database management is not hard indeed. I have the lack of knowledge of how to link GUI with a database. I think, the easiest way will be to just try a simple Tkinter Treeview (or DataGrid) linked to Sqlite tutorial to get a hint. I cannot imagine how to link React to a database even how to build a Treeview UI with React.

---

<div class="post-metadata">

**Author:** ![NicolasATC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/nicolasatc/32/714_2.png) [@NicolasATC](https://forum.codewithmosh.com/u/NicolasATC)\
**Post date:** [April 11, 2021, 11:55pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/5 "2021-04-11T23:55:00Z")

</div>

I have some python-DB projects already working… and the way to link them is not hard at all.

If interested, let me know, and I can share the code with you!

---

<div class="post-metadata">

**Author:** ![andrasx853](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@andrasx853](https://forum.codewithmosh.com/u/andrasx853)\
**Post date:** [April 14, 2021, 9:06pm UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/6 "2021-04-14T21:06:01Z")

</div>

Hi Nicolas,

I am very appreciated, it is very kind. That would be great to start learning from existing projects. Do you have github?

---

<div class="post-metadata">

**Author:** ![NicolasATC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/nicolasatc/32/714_2.png) [@NicolasATC](https://forum.codewithmosh.com/u/NicolasATC)\
**Post date:** [April 15, 2021, 2:08am UTC](https://forum.codewithmosh.com/t/advice-for-beginner-for-database-app/4025/7 "2021-04-15T02:08:22Z")

</div>

My github is almost abandoned. I think I have to start uploading some projects there.

Anyway… here is the link to the password manager I wanted to create. I’m sure it will help you.

> **[NickATC/Password\_Manager](https://github.com/NickATC/Password_Manager)**
>
> A beautiful and fully functional Password Manager to create, edit, and save all your passwords.

I wrote that code like 3 years ago, so it was very simplistic and full of errors… so, focus on how I linked the GUI and the database. If you need explanation on how I did it, let me know.

of course, take a look at the readme.

I read this book and it helped me lots. If you are into Python and GUI design, it’s worth every cent:

> **[Python GUI Programming Cookbook - Second Edition | Packt](https://www.packtpub.com/product/python-gui-programming-cookbook-second-edition/9781787129450)**
>
> Master over 80 object-oriented recipes to create amazing GUIs in Python and revolutionize your applications today
