In this developer code pattern, we walk you through the creation of a web application that tracks support tickets. The app allows users to create, assign, manage, and close support tickets. The app UI is built with Vue.js, and the data is stored in EDB.
For the database, we are using EDB. EDB is an enterprise-class database based on the very popular PostgreSQL open source relational database. We are provisioning a database-as-a-service using IBM Cloud. With a few mouse clicks, we get a fully managed installation of EDB in the cloud that we can access from anywhere. We use the common psql command-line tool to run our data loading scripts to seed the database, but many query tools are available that can also be used.
When you have completed this code pattern, you will understand how to:
- Provision a “Databases for EDB” instance on IBM Cloud.
- Use Sequelize to programmatically map objects to your relational database.
- Create a modern web app built on Node.js, with an Express server for REST APIs, and a Vue-based UI.
- Use psql scripts to seed the database tables with tickets, users, and support staff.
- Administrator uses psql to seed EDB tables with user, assignee, and ticket data.
- User interacts with the Node.js app to create and maintain ticket information. The Vue-based client UI accesses EDB data via the Express server REST APIs.
- The server uses Sequelize to perform CRUD operations on the EDB instance.
Ready to get started? Find the detailed steps for this pattern in the README. The steps will show you how to:
- Clone the repo
- Provision the Databases for EDB service
- Add service credentials to environment file
- Load sample data
- Run the application
- Use the app
- Review the application structure