MVB: How to build the backend for a Two-sided marketplace

Introducing our new series MVB: Minimum Viable Backend
We have customers that are trying to build awesome apps that have no idea where to get started, so we decided to create a series covering how to create the foundation for the most popular types of apps.
THIS EPISODE:
In this episode, we review the two-sided marketplace and build the backend foundation to an app similar to Uber.
What We'll Cover:
- Basic Database Schema and Setup
- Demand Side (Passengers)
- Supply Side (Drivers)
- Location
What we won't get to this time:
3rd party integrations:
- Payments/Payouts (Stripe)
- Messaging (Email/SMS with Sendgrid/Twilio)
- Recaptcha (Google)
- Chat/Real-time Updates (Ably)
We have weekly office hours if you want to continue building on this foundation!
SIGN UP FOR XANO
Vist Xano - The Fastest No Code Backend Dev Platform
go.xano.co/3hFAihZ
Twitter
/ nocodebackend
Chapters
0:00 - Introduction
3:30 - Initial Xano Setup
4:30 - Setting up Database Tables
9:30 - Setting up the API Endpoints
9:50 - Get Cars Near Me
14:40 - Book a Trip based on nearby Vehicles
22:50 - Start Trip workflow
27:50 - Complete Trip workflow
30:11 - Get List of Trips (As Customer)
31:20 - Get List of Trips (As Driver) + How to use Joins
34:54 - Summary and Questions
35:38 - Why did we setup the Database like that?
37:05 - How to think about Database tables vs Data Locality
41:15 - Relational vs Non-Relational Setup in Xano
42:04 - API Endpoint Summary
42:20 - Breaking down the API and the Function Stack in Xano
43:21 - How to apply this to another type of two-sided marketplace
44:10 - Wrap up

[@bmg.studio]

This is completely bananas. The number of opportunities Xano (& say Webflow + JS) creates is insane.

[@wheres_bears1378]

Please do more of these 👍 It would be great if it was a bit slower or explained in more detail as I was hanging on by the seat of my pants

[@user-ft2md2gd4s]

Great. Can’t wait for episode two

[@armanpiter]

Sean is so involved that forgot about us🤣 but anyway it was very helpful 👍

[@MrTonyradford]

Love this. Thanks a lot

[@shayhia]

This looks really good guys! Can't wait to try it out. Game changer.

[@jeronimopiquerodwm7476]

I am totally new to Xano. Thanks a lot for this tutorial. it is very helpful. I will use those tips and practices on the project I just started.

[@MacGriff603]

This was excellent and very helpful!

[@thenormaltraveler]

This was super helpful. Thx

[@webylon8992]

Really looking forward to trying out Xano but tbh but this was really hard to follow. Sean is way too fast and doesn't seem to understand his audience compared to Prakash that is very methodical and can explain complex processes in a more educated and easy way so pls, would love more of Prakash.

[@wadanda]

At 11:45 Sean clicks inside the geo-point field in the vehicle table and sees the location showup in the url bar - how did he do that? Is this a chrome extension that i could find?

[@nocodebackend]

@Ivan Oboth - he copied the contents of the cell from the Xano database table and pasted it into the URL bar