Get started with Jam.py Application Builder

Download Jam.py

Install Jam.py on any platform with Python minimum version 2.7. Python version 3 is supported! Minimum space required 18MB.

Try Demo

Comprehensive invoicing Demo you can base your next application on.

Watch videos

We prepared a number of tutorials about the Jam.py framework to enable you to learn quickly.
Jam.py Application Builder
What is Jam.py? Just as MS Access serves desktop environment, Jam.py serves as web application - and much more. Like running any Python script from the Browser input. It's that simple.

With Jam.py you can create, customise, test and share awesome, fast, event-driven applications for SQLite, Oracle, MySQL, PostgreSQL, Firebird, IBM DB2 and SQLCipher. All of that for free and no vendor lock-in!

In addition, Jam.py can execute any Python script from the Browser input!

Featured in Linux Magazine article "Building a database front end with Jam.py", page 50-55, issue 241/2020.

Please download the User Manual, visit Online documentation or Application Design Tips.

To experience how fast Jam.py is, please download standalone Demo for Windows x64 and point the Web browser to locahost:8080!

Sharing the love: YouTube Channel

We even prepared a utility to migrate MS Access database to Web: Migrate Here. Of course, we are here to help with the process - Contact Form.

Success Stories

-web2py original author Massimo Di Pierro about Jam.py: "Jam is a much more sophisticated version of web2py's appadmin, our name for the database UI. web2py is not a database UI and the one it exposes is in fact very limited. Jam.py is better at it."

-Linux Magazine author Marco Fioretti: "Jam.py is quick and simple to use, and the architecture makes it easy to migrate an application to another database if the need arises."

- "I have just spent 30 minutes using jam.py. It is extraordinary and wonderful what you and your team seem to have accomplished. To provide some context - I spent 2 hours on OpenXava this morning and could not even get their demo working. I was able to set up Jam.py in 5 minutes from the pip install - your doco is great as well." - Jam user.

-Giovanni Cannata Python ldap3 author: "I would let you know that I really like jam.py framework and its modular approach allowed me to integrate the application in our systems with no hassles!"

-Reddit user: "I can't speak for your specific need, but in general there's a large need for a smallish "departmental" intranet development tool that fills the niche of MS-Access but is web-enabled."

MS Access Migration

Many businesses rely on Microsoft Access for managing their data, but as companies grow and demand for real-time access, collaboration, and scalability increases, Access's limitations become apparent. Traditional desktop-based Access databases can be challenging to share, maintain, and scale, especially in environments where teams need to collaborate remotely or require seamless integration with modern web applications.

Moving MS Access to the web addresses several business needs:

  • Improved Accessibility: Web-based applications can be accessed from anywhere, on any device, facilitating remote work and collaboration.
  • Scalability: As business data grows, web-based solutions can handle larger volumes of data more efficiently than desktop applications.
  • Centralized Data: A web-based system ensures that data is centralized and consistent across all users, reducing errors and improving version control.
  • Integration with Other Systems: Web applications can more easily integrate with other business systems, such as CRM, ERP, or cloud services.
  • Reduced Maintenance: Centralized web applications are easier to maintain, update, and secure, compared to individual desktop installations.

Jam.py is a powerful framework that can assist in this transition by providing a low-code, JS and Python-based environment that is well-suited for creating web applications similar to MS Access. With Jam.py, businesses can:

  • Migrate MS Access databases to a web-based platform while preserving key functionalities.
  • Create web-based forms, reports, and views similar to Access, allowing users to interact with the data in familiar ways.
  • Leverage built-in authentication and security to manage access controls and protect sensitive data.
  • Easily deploy the solution on the cloud or on-premises, providing flexibility based on business needs.

By using Jam.py, businesses can seamlessly move their Access databases to the web, unlocking enhanced collaboration, scalability, and integration opportunities while maintaining a user-friendly interface for non-technical users.

From an idea to live web site in no time.

Develop

Object-oriented, event-driven framework with hierarchical structure.

Customize

Powerful yet easy database table data handling on the server and the client.

Secure

Secure way to manage user accounts and passwords. Including SAML and OAuth.

DRY principle! Don't repeat yourself, do it once, do it well.

With Jam.py Databases Application Builder, you can resolve a specific business problem. Out of the box Jam is providing: fast access to underlying databases, security, authentication, validation, calendars, multi languages, all of that with minimum of coding needed. Being Python framework, it is extensible and flexible.

“All in the browser” framework

With Jam.py, you just need the browser! Your productivity will sky rocket as you dig into the framework using our code editor. Make changes in the editor, refresh the page and see the results.

  • Internet Browser IDE
  • Code Editor with Syntax Highlighting and Code Completion
  • No declarative options, you are in charge.
  • Instant WYSIWYG
  • Application lifecycle tracking.
  • SQL and stored procedures supported for major vendors.
  • Integrate any Python library with no contract lock-in and reduce cost instantly.
  • Bootstrap, JQuery, JS, all in here. Use it with no fuss and learning this massive libraries.
  • Create rich, informative reports, due to band-oriented report generation based on LibreOffice templates.
  • Mobile devices supported out of the box.

Event driven grids

Event driven grids enable you to easily manipulate data simply by clicking on a cell and editing its value.

  • Event driven data-aware visual interface controls makes the framework flexible and powerful.
  • Edit your data in the grid, as you would in any Desktop spreadsheet application.
  • Create the master-detail table with breeze, utilising templates for displaying, which is no more than a copy/paste. Easy. Again, no declarative methods, the control is with you as it should be.

jsCharts or any charting libraries

Locked-in with a vendor charting capabilities? Never again. Use free libraries as jsChart, at.al.

  • Use the same charting capabilities on your mobile devices, once for all.
  • Visualise charts immediately after you create/import tables, with a few lines of code. Simple and effective.
  • Analyzing/displaying BIG data? Add free Python lib's, build a Jam Web Form with parameters, execute on the server. Profit.
Simple and effective UI with no fuss

Designed with the simplicity on mind, based on strong Delphi foundation. There are no web widgets, no dependencies on such. Yet, you can use CSS or JS and achieve fantastic results with Jam. In small to medium organisation with no dedicated developers, one can build an app based on requirements in no time with no hustle of declarative frameworks.

Deploying an Jam.py application takes seconds. Literally.

There are only a few files to deploy in the development/production environment. Comparing with some other frameworks, with mega deployment or database dependencies, Jam is a feather light.

  • Fast application export/import, easily transportable, kilobytes in size.
  • Develop on one database, deploy on the other. This is our promise to you. No database lock-in. Ever.
  • Scaling Jam.py application is extremely easy. Develop once, deploy anywhere.
  • Jam will deploy on Windows as well as Mac or Linux. Raspberry Pi? No worries.

Jam.py is Open source. No vendor lock-in. Free to use and distribute.

By using Jam.py Application Builder, you will finally free your organisation of the vendor lock-in. Even more, with the freely available utilities, you can move your expensive database to the open source one leaving you with moving only the BI to Python. Oracle Forms for example, can be moved in no time, the Jam.py framework has Events to cover for the Forms logic. And, of course you have the source code, which can be accommodated for your organisational needs.