DEV Community

Cover image for Introducing BudgetApp: Building an Open Source Desktop Application with Python and PySide6 🐍
Manuel AF
Manuel AF

Posted on

Introducing BudgetApp: Building an Open Source Desktop Application with Python and PySide6 🐍

Exploring desktop development, local-first storage, PDF generation, and software architecture through a practical Python project.

Hey DEV Community! πŸ‘‹

Are you passionate about Python? Have you ever wanted to move beyond scripts and build a complete desktop application?

Today, I'd like to introduce BudgetApp, one of the open-source projects I'm developing as part of ConnectApp, my independent initiative focused on building reusable software, sharing knowledge, and exploring responsible software engineering.

BudgetApp is a desktop application developed with Python and PySide6 (Qt) to help users create, organize, and manage business quotations.

But beyond its practical purpose, the project is also an opportunity to explore something I find particularly interesting:

How can we build desktop applications that are useful, maintainable, and respectful of users' data?

πŸ’» Why Python and PySide6?

Python is widely used for automation, backend development, data processing, and artificial intelligence.

However, it's also an excellent language for building desktop applications.

Combined with PySide6, the official Python bindings for Qt, it provides a powerful foundation for creating graphical user interfaces.

With BudgetApp, I'm exploring several important areas of desktop development:

  • Python for application logic.
  • PySide6 for the graphical interface.
  • SQLite for local data persistence.
  • MySQL as an optional remote database alternative.
  • PDF generation for business quotations.
  • Data validation and consistent calculations.
  • Software architecture and separation of responsibilities.

These technologies offer practical opportunities to learn how a real application works beyond a simple programming exercise.

πŸ“‹ What does BudgetApp do?

BudgetApp is designed to make the preparation and management of business quotations more straightforward.

Its documented workflow includes:

βœ… Managing company and customer information.

βœ… Creating and editing quotations.

βœ… Adding items, quantities, prices, discounts, and VAT.

βœ… Calculating and reviewing totals.

βœ… Searching previously saved quotations.

βœ… Tracking quotation statuses, such as draft, sent, and accepted.

βœ… Exporting quotations as PDF documents.

βœ… Working with Spanish and English document output.

The goal is to organize the entire quotation workflow in one desktop environment.

Instead of managing separate spreadsheets, documents, and calculations, users can work with a more structured process.

πŸ—„οΈ Local-first or remote storage? You choose.

One of BudgetApp's interesting features is its approach to data persistence.

The application supports two storage options:

SQLite β€” Local storage

A suitable choice for users who prefer keeping their business information on their own computer.

It avoids the need to maintain a separate database server for a simple desktop workflow.

MySQL β€” Optional remote storage

For scenarios where an external database is required, BudgetApp also supports a configurable MySQL connection.

This introduces different infrastructure, configuration, and security responsibilities.

The application uses the operating system's secure credential storage for remote database passwords.

An important distinction: remote MySQL support does not automatically mean that the application provides multi-user collaboration or conflict-free synchronization.

πŸ“„ Generating PDF quotations

PDF generation is another interesting engineering challenge in BudgetApp.

A quotation involves more than placing text on a page.

The application needs to organize customer details, quotation items, quantities, prices, discounts, taxes, and final totals.

It also needs to produce a document that remains understandable outside the application.

This makes PDF generation a useful area for exploring data formatting, calculations, document structure, and validation.

It also raises a privacy consideration:

Once a PDF is exported and shared, the application no longer controls where that document goes.

That's why users should review the information included before distributing it.

πŸ—οΈ Learning software architecture through a real project

One of the principles I try to follow throughout ConnectApp is that open-source projects should remain understandable and maintainable.

BudgetApp explores architectural ideas inspired by Clean Architecture, particularly the separation of business models, persistence, and user-interface responsibilities.

However, the project is still evolving.

Some responsibilities and dependencies need further refinement, which makes the codebase an opportunity to discuss architectural decisions and improvements rather than presenting it as a perfect reference implementation.

For developers and students, there are interesting questions to explore:

  • How should a PySide6 interface interact with business logic?
  • How can persistence be separated from quotation calculations?
  • How should different database implementations be organized?
  • How can financial calculations be tested reliably?
  • How should errors, backups, and restoration be handled?

These are the types of questions that turn a programming project into a software engineering learning experience.

πŸŽ“ A project for Python students and developers

I believe one of the best ways to improve as a developer is to work with applications that solve real problems.

BudgetApp can be especially interesting if you're:

  • Learning Python and looking for a more complete project.
  • Exploring PySide6 or Qt desktop interfaces.
  • Interested in SQLite and MySQL.
  • Learning software architecture and modular design.
  • Practicing PDF generation and data validation.
  • Looking to contribute to an evolving open-source application.

You don't need to be an expert in every technology.

Studying the architecture, reviewing calculations, improving documentation, or proposing tests can be valuable ways to participate.

πŸ” Open Source, privacy, and software quality

At ConnectApp, I believe that Open Source doesn't mean second-class software.

Making an application's source code available should encourage transparency, maintainability, responsible engineering, and collaboration.

Privacy is also an important part of that philosophy.

BudgetApp gives users a choice between local SQLite storage and optional remote MySQL storage, but each configuration comes with its own responsibilities.

Local storage doesn't automatically guarantee security, and external storage requires careful configuration.

The project remains under development, so anyone adapting it for business use should review its current documentation, test workflows with sample data, and evaluate whether it meets their requirements.

🀝 Let's learn and build together!

I'd love to connect with Python developers, students, educators, and anyone interested in desktop software engineering.

BudgetApp is another opportunity to demonstrate how open-source projects can become practical learning resources.

Whether you want to review the code, share ideas, discuss architecture, or propose improvements, your feedback is welcome.

Here's a question for the DEV Community:

When building a desktop application in Python, what do you find most challenging: designing the UI, structuring the architecture, handling local databases, or packaging the application?

I'd love to hear about your experiences!

🌍 Explore BudgetApp and ConnectApp

πŸ“‹ BudgetApp project page: https://www.connectapp.es/es/aplicaciones/budget-app/

🌐 ConnectApp: https://www.connectapp.es

πŸ’» GitHub: https://github.com/ManuelAf-ConnectApp

ConnectApp β€” Open Source Software. Real Privacy. Freedom to Create.

Because learning Python isn't just about writing code. It's about discovering how to build software that people can actually use. πŸš€

Top comments (0)