Get started with Jam.py Application Builder

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 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.

Check out the Jam.py Admin UI slides!

Python Jam.py Framework Admin User Interface Introduction

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."

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.