Poway Orchestra Backend

Make the Poway sections the center of the backend. Start with your orchestra user directories, approved members, and administrative accounts, then drop into the broader Flask and Python tools below.

Poway Sections

PSO Data
Browse Poway users

  1. See every PSO account stored in the orchestra site database.
  2. Review names, emails, roles, and creation timestamps in one table.
  3. Use this as the main directory for member and admin account tracking.

Open PSO Users
PSO Data
Track approved members

  1. Review approved orchestra members and their current section assignments.
  2. See instrument, section, approval time, and approving admin together.
  3. Use this as the roster view for active Poway Symphony participants.

Open PSO Members
PSO Data
Review created member cards

  1. See every saved Poway orchestra member card in one place.
  2. Track the owner, section family, instrument title, and creator.
  3. Use this view to review and manage the published card directory.

Open Member Cards

Platform Reference

Python Development
What should Student Developers learn?

  1. Python 3.12 is used for most of our backend PBL. HTML, CSS, JavaScript will be used in frontend
  2. Visuals Studio Code (VS Code) is the primary editor, Interactive Development Environment (IDE).
  3. GitHub. Managing and sharing code change, branches, pull requests, issues, and more will be through GitHub.
  4. DevOps. Python programmers should have a passion for managing the environment and learning automation (Git, Linux, Bash, Python Packages, Docker).
  5. API and Microservice using Flask. Mastering development techniques in creating and consuming RESTful APIs

Explore Python
Flask Development
What is Flask? How do I start Web development?

  1. Flask Framework is the popular Web Application development framework of Python.
  2. Blueprint is Python technique to help abstract complexity, moving information into independent files and directories. Blueprints are intended to encapsulate feature-sized sections of our application into well organized files.
  3. HTML using Bootstrap is a great way to build interesting pages and reduce CSS
  4. Jinja2 is a server-side Python like template engine, supports HTML5 web development, and provides full integration with Flask.

Explore Flask
Backend and Persistence
How do you manage Persistent data with Python?

  1. A Database is an example of persistent data that is held on a computer. Programming languages and frameworks allow you to store and retrive data.
  2. SQL stands for Structured Query Language · SQL lets you access and manipulate databases and has become a long lasting development standard.
  3. SQLAlchemy is the Python SQL toolkit and Object Relational Mapper (ORM) that gives application developers the full power and flexibility of SQL.
  4. There are many newer and sometimes easier Database languages and frameworks. Mongo, DynamoDB, Neo4J are Databases being used by students developers in last 3 years.

Explore Data