Bookshop Demo

Bookshop is a virtual online bookstore application through which you can find books of various categories and rate the books.

You can perform CRUD operations such as viewing book details, adding and deleting ratings, editing book inventory, etc.

Powered by TiDB Cloud, Prisma and Vercel.

🔥 Visit Live Demo

👉 Click here to visit

Deploy on Vercel

🚀 One Click Deploy

You can click the button to quickly deploy this demo if already has an TiDB Cloud cluster with bookshop data imported.

Integration will guide you connect your TiDB Cloud cluster to Vercel.

Do remember to import the bookshop data into your TiDB Cloud cluster. (Follow this guide)

🧑‍🔧 Manually Deploy

1. Register TiDB Cloud and create dev-tier cluster

Click here to visit TiDB Cloud

After cluster created, you can get the connection details by clicking the Connect button.

Get User and Host field from the dialog.

Note: For importing initial data from local, you can set an Allow All traffic filter here by entering an IP address of 0.0.0.0/0.

Your DATABASE_URL should look like mysql://<User>:<Password>@<Host>:4000/bookshop

2. Import table structures and data

2.1 Install TiUP

TiUP is a component manager for TiDB.

Run the following in your terminal:

curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

2.2 Run TiUP demo

You can get User and Host from TiDB Cloud panel.

Run the following in your terminal:

tiup demo bookshop prepare -U <User> -H <Host> -p <Password>

More details about importing table structures and data please refer to our doc.

3. Deploy on Vercel

You can get DATABASE_URL from previous step.

📖 Develop Reference

Prisma

Prisma Deployment Guide

Bookshop Schema

Bookshop Schema Design