Jam.py Application Design Tips

• Development Checklist
  • Development Checklist
    • Built in Code Editor
    • Python version
    • Using Python Virtual Environments
    • Using the Source Control
    • Unit Testing
    • Continuous Integration (CI)
    • Generating Documentation
    • Limited introduction to the tool
    • Debugging
    • Profiling
    • Containers
  • Choosing the Web Server
    • Apache Web Server and mod_wsgi
    • IIS Web Server
    • CPanel
  • Choosing the Database
    • Database triggers
    • Database views
    • Database indexes
    • Database sequences
  • admin.sqlite Database
• Application Design
  • Getting Started
  • Top 5 Questions
    • 1. What is Jam.py?
    • 2. Why using Jam.py?
    • 3. Why not to use Jam.py?
    • 4. Does it scale?
    • 5. What can I use it for?
  • Terminology
    • Catalogs (Catalogues)
    • Journals
    • Details
    • Reports
    • Virtual Tables
    • Need more Groups?
    • Wrapping up
  • Journal/Detail (or Master/Child) scenario
  • Forms, Buttons and other user interaction items
  • Bulk updates, inserts or delete
  • Authentication Decision
    • Built in Authentication
    • Non built in Authentication
    • External Authentication
    • LDAP (Active Directory) Authentication
    • SAML or SSO Authentication
    • OAuth2, OpenID or SiteMinder (CA) Authentication
    • MFA or Two Factor Authentication
  • User Registration Form
  • Forgotten Password Method
  • Using Python libraries
  • Generated Images
• “How-to” guides
  • How to install Jam.py on Windows
    • Install Python
    • About pip
    • Setting up a virtual environment
    • Install Jam.py
    • Common pitfalls
• How was Demo built?
  • Demo project
  • Demo database
  • What to expect?
    • DropDown Menu(s)
    • Data Grid(s)
    • More Data Grid(s)
    • Data Grid Header/Footer
    • Any questions?
  • Ok, how do I start?
    • Invoices
    • Customers
    • Invoice items
    • How did we go?
    • Click on!
    • Your 1st task!
  • A little code
    • Invoices
    • Error handling!
    • So, how was it?
  • More code
    • Invoices Details
  • Server code
    • Invoices
    • Why Server Code?
    • Debugging
    • And finally…
    • …the End of Code
  • index.html
    • Templates
    • Template Code
    • Wrapping up
  • Dashboard
    • Dashboard template
    • Dashboard Menu Item
    • Dashboard Code
    • Cosmetic code
    • End of Dashs
• MS Access migration
  • MS Access migration
  • Top Migration Questions
    • 1. Complacency
    • 2. VBA?
    • 3. Excel?
    • 4. Queries
    • 5. Primary Keys
    • 6. Deployment
    • 7. Compile Error
    • 8. Cannot open the database
    • Conclusion
  • Where from here?
    • Notes/Issues
    • Terms and Conditions
  • Now what?
    • Tables
    • Using UTF8
    • Field Captions
    • Reserved Words
    • Deleted Flag
    • Primary Keys
    • Foreign Keys
    • Indexes
    • Users table
  • Some migrated examples
    • Personal Account Ledger
    • Northwind Traders
    • Inventory transactions
• Acknowledgements
  • About the author
    • Copyright