This is forked jam.py to continue the support and development, since Andrew is retiring from jam.py project. The GH organisation name is jam.py-v5, since we are hoping to release official v7 this year (2025).
Jam.py is powerful Web Application Builder for managing data effortlessly. All batteries included.
A major difference from other products is that the entire application is contained within a single SQLite3 file. And it can be encrypted!
Another key distinction is the ability to run any Python procedure directly within the Application Builder - including popular libraries like Matplotlib, Pandas, and NumPy - with the results displayed in the browser. Python procedure can run synchronously or asynchronously on the server. There's no need to access the console to review logs anymore, the server sends results to the browser!
More over, using Import tables feature from any supported database is providig instant data access! There's no need to code anything and authentication is one click away!
Hope this sparked some interest! Thank you.
Some short videos about how to setup Jam.py and create applications:
- Creating CRM web database applications from start to finish in 7 minutes with Jam.py framework
- Setting up interface of Jam.py application using Forms Dialogs
Longer video with dashboards and complex internal logic.
Live demos on PythonAnywhere:
-
Personal Account Ledger from MS Access template
Below two apps demonstrate Matplotlib, Pandas, NumPy and RFM analysis, which stands for R ecency, F requency, and M onetary value, directly migrated from MS Access template:
-
Sistema Integrado de Gestão - IMS for Brazilian Market (Portuguese)
-
Bills of Materials, sourced from https://github.com/mpkasp/django-bom as no-code, V7 (wip)
Jam.py alternative site:
https://jampyapplicationbuilder.com/
Jam.py is an object oriented, event driven framework with hierarchical structure, modular design and very tight DB/GUI coupling. The server side of Jam.py is written in Python, the client utilizes JavaScript, jQuery and Bootstrap.
-
Simple, clear and efficient IDE. The development takes place in the Application builder, an application written completely in Jam.py.
-
“All in the browser” framework. With Jam.py, all you need are two pages in the browser, one for the project, the other for the Application builder. Make changes in the Application builder, go to the project, refresh the page, and see the results.
-
Supports SQLite, PostgreSQL, MySQL, Firebird, MSSQL and Oracle databases. The concept of the framework allows you to migrate from one database to another without changing the project.
-
Authentication, authorization, session management, roles and permissions.
-
Automatic creation and modification of database tables and SQL queries generation.
-
Data-aware controls.
-
Open framework. You can use any Javascript/Python libraries.
-
Rich, informative reports. Band-oriented report generation based on LibreOffice templates.
-
Charts. You can use free jsCharts library or any javascript charting library to create charts to represent and analyze your application data.
-
Allows to save audit trail/change history made by users
-
Predefined css themes.
-
Develop and test locally update remotely. Jam.py has Export and Import utilities that allow developer to store all metadata (database structures, project parameters and code) in a file that can be loaded by another application to apply all the changes.
All updated documentation for v7 is online at https://jampy-docs-v7.readthedocs.io/
Brazilian Portuguese translation started at https://jampy-docs-v7-br-pt.readthedocs.io/
Please visit https://jampy-docs-v7.readthedocs.io/en/latest/intro/install.html for Python and framework installation or https://jampy-docs-v7.readthedocs.io/en/latest/intro/new_project.html how to create a new project.
Jam.py application design tips are at https://jampy-application-design-tips.readthedocs.io/
For general discussion, ideas or similar, please visit mailgroup https://groups.google.com/g/jam-py or FB page https://www.facebook.com/groups/jam.py/ (paused atm)
Jam.py is raising funds to keep the software free for everyone, and we need the support of the entire community to do it. Donate to Jam.py on Github to show your support.
Jam.py is licensed under the BSD License.
Andrew Yushev
See also the list of contributors who participated in this project.