Jam.py (web framework)

{{Infobox software

| name = Jam.py

| screenshot = File:Screenshot from 2024-05-23 09-42-54.png

| caption = Screenshot of Parameters, with the visual form editor being used to create an application

| author = Andrew Yushev

| released = {{Start date and age|2015|07|01}}

| latest release version = {{wikidata|property|reference|edit|P348}}

| latest release date = {{start date and age|{{wikidata|qualifier|P348|P577}}}}

| genre = Web framework

| license = BSD 3-clause

| repo = https://github.com/jam-py-v5/

| programming language = Python, JavaScript

| platform = Cross-platform

| website = {{URL|jampyapplicationbuilder.com}}

}}

Jam.py is Web framework providing low-code and no-code, full solution stack rapid application development using Web Server Gateway Interface (WSGI), for the programming languages JavaScript and Python.{{Cite web |url=https://wiki.python.org/moin/WebFrameworks/ |title=WebFrameworks |website=Python Wiki.org}} It is free and open-source software released under a BSD 3-clause license.

Jam.py version 5.x is a single-page, event driven low-code development platform for database-driven business web applications, based on the don't repeat yourself (DRY) principle, with emphasis on create, read, update and delete (CRUD). It is designed to automatically create JavaScript web forms from the underlying database tables, although a form can be created manually if required. The existing database tables can be imported into Jam.py to create the forms and reports. Database views are unsupported for import.

It provides a built-in web server, graphical user interface builder (named Application Builder), and database access including third-party databases.

Jam.py version 7.x supports routing within the single-page. Uniform resource locator (URL) mapping is unsupported.

Features

v5.x is a single distribution which runs with Python 2.6+ and 3.x
v7.x runs with Python >3.6, and is using dependencies installed automatically
Can run as a standalone web development server or be used with any web server which supports WSGI
Built-in GUI builder named Application Builder
Support for JSON client data (for Representational State Transfer (REST) and JavaScript clients)
Support for popular databases Oracle Database, Microsoft SQL Server, PostgreSQL, SQLite, MySQL, Firebird (database server), SQLCipher{{cite web |title=SQLCipher |url=https://github.com/sqlcipher |website=GitHub |language=en}}{{Cite web|url=https://jampy-docs.readthedocs.io/en/latest/admin/project/database.html|title=Database — Jam.py documentation|website=jam-py.com}}
Extensible authentication mechanisms and role-based access control
Internationalization support
jQuery for Ajax and UI
Template language
Reports Templates based on LibreOffice
Files upload and camera capturing
Optimistic locking

Distinctive features

= Built-in application builder =

All development, maintenance and remote database administration can be performed via Builder interface. The most distinctive feature is the Client and Server Module. The Server Module enables the Python code for business logic, executed as a server-side session. The Client Module executes the JavaScript code within a browser. It is possible to exchange data between the two.

[https://www.linux-magazine.com/Issues/2020/241/Jam.py Building a database front end with Jam.py]

Application Builder is strongly influenced by Delphi visual designer.[https://www.webprecis.com/best-frameworks-for-web-design Best Frameworks for Web Design]

= Application builder client module =

This JavaScript "Hello, World!" program code displays a simple web page when visited:

task.create_menu($("#menu"), $("#content"), {

splash_screen: '

Hello World!

view_first: true

});

The above code resides in Task/Client Module(s) within the Application Builder. The task function can be accessed globally.

= Application builder server module =

The Python libraries can be imported within the Task/Server Module(s):

import smtplib

def send_email():

# code that sends email

The above code imports smtplib library, which might be used to send emails. The defined functions can be accessed globally.

=== Database migrations ===

Jam.py supports database migration and data import from one supported database to another.

The below code in the Task/Server Module will import data from SQLite to application database:

from jam.db.db_modules import SQLITE

def on_created(task):

task.copy_database(SQLITE, "demo.sqlite")

Limits:

The SQLite database cannot be imported into the application database which has foreign keys.[https://jampyapplicationbuilder.com/docs/how_to/how_to_migrate_to_another_database.html How to migrate to another database]

PythonAnywhere

PythonAnywhere Python 3.x deployment is supported{{Cite web |url=https://github.com/pythonanywhere/help_pages/blob/master/articles/Jampy.md |title=pythonanywhere/help_pages |website=GitHub |date=11 October 2021}}