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
    • Terminology
    • Catalogs (Catalogues)
    • Journals
    • Details
    • Reports
    • Virtual Tables
    • Need more Groups?
    • Wrapping up
  • Authentication Decision
    • Built in Authentication
    • Non built in Authentication
    • External Authentication
    • User Registration Form
    • Forgotten Password Method
• “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?
    • Ok, how do I start?
    • A little code
    • More code
    • Server code
    • index.html
    • Dashboard
• 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
    • Inventory transactions
    • Northwind Traders
• Acknowledgements
  • About the author
    • Copyright