Build an AI Travel Agent with MariaDB, MindsDB, FastAPI, Next.js, OpenAI + more. Complete TUTORIAL.

Thank you to MariaDB + MindsDB for sponsoring this series.

Services used

Software used

Chapters
00:00:00 Welcome
00:03:34 Overview
00:07:59 References and Requirements
00:11:05 Provision EC2 Instance
00:16:58 Connect to EC2 Instance via SSH
00:21:11 Install Docker on EC2 Instance
00:23:35 Provision MariaDB with Docker Compose
00:34:04 Connect to EC2-Docker-based MariaDB Instance Locally
00:40:55 Configure Virtual Environment and Jupyter
00:47:54 Loading Dotenv with Python Decouple and Jupyter
00:56:43 Connect to MariaDB via SQLAlchemy
01:03:52 Load a Kaggle Dataset to MariaDB
01:15:47 Create MariaDB User for MindsDB
01:23:13 Integrate MariaDB & MindsDB
01:31:31 Creating a Forecasting Model with MindsDB
01:40:39 Predicting Future Values with MindsDB
01:46:37 Load Flight Prices Dataset to MariaDB
01:53:28 Prepare Flight Data for Predictions
02:03:25 MindsDB Predictor for Flight Price Data
02:08:09 More Data Features for Better Predictions
02:17:21 SQLAlchemy Model from Database Table
02:29:26 Pydantic Schema for SQLAlchemy Model
02:34:05 SQLAlchemy Lookup Functions for Model Data
02:39:04 MindsDB SQL Queries via Rest API and Python Part 1
02:47:25 MindsDB SQL Queries via Rest API and Python Part 2
02:59:34 FastAPI Backend App
03:07:32 Why the FastAPI Backend
03:16:56 FastAPI CORS for Nextjs
03:26:26 Integrate MariaDB to FastAPI
03:31:02 Listing Database Data via API View
03:34:32 Detail View and Schema with FastAPI and Pydantic
03:44:37 Styling a Link with Tailwind
04:15:05 Nextjs Form sending POST Requests to FastAPI
04:23:43 MindsDB with FastAPI and Nextjs
04:30:23 Generate and Load Airport Data in MariaDB and FastAPI
04:39:36 Airport Dropdown Selector
04:45:32 Handling POST Data with FastAPI and Pydantic
04:57:56 Improve Flight Price Prediction UI
05:06:10 TailwindCSS Global Styles
05:14:16 Form Styling with Flowbite References
05:21:38 Prediction Results UI Table
05:35:36 Integrate MindsDB with OpenAI to Make Flight Recommendations
05:45:39 OpenAI Recommendation Response in UI
05:56:28 Unique Request ID for Forecasts
05:59:24 Recommendation Display
06:05:47 Purchase Links
06:10:08 Starting to Handle New Data
06:11:51 Export Data and Train a Gretel Model
06:16:49 Load Gretel Data to MariaDB via Pandas
06:31:52 Train MindsDB Forecast Model via Jupyter
06:43:07 Final Clean Up
06:45:04 Thank you and your next challenge

[CodingEntrepreneurs]

Thanks for watching. A few references for you:
Chapters
00:00:00 Welcome
00:03:34 Overview
00:07:59 References and Requirements
00:11:05 Provision EC2 Instance
00:16:58 Connect to EC2 Instance via SSH
00:21:11 Install Docker on EC2 Instance
00:23:35 Provision MariaDB with Docker Compose
00:34:04 Connect to EC2-Docker-based MariaDB Instance Locally
00:40:55 Configure Virtual Environment and Jupyter
00:47:54 Loading Dotenv with Python Decouple and Jupyter
00:56:43 Connect to MariaDB via SQLAlchemy
01:03:52 Load a Kaggle Dataset to MariaDB
01:15:47 Create MariaDB User for MindsDB
01:23:13 Integrate MariaDB & MindsDB
01:31:31 Creating a Forecasting Model with MindsDB
01:40:39 Predicting Future Values with MindsDB
01:46:37 Load Flight Prices Dataset to MariaDB
01:53:28 Prepare Flight Data for Predictions
02:03:25 MindsDB Predictor for Flight Price Data
02:08:09 More Data Features for Better Predictions
02:17:21 SQLAlchemy Model from Database Table
02:29:26 Pydantic Schema for SQLAlchemy Model
02:34:05 SQLAlchemy Lookup Functions for Model Data
02:39:04 MindsDB SQL Queries via Rest API and Python Part 1
02:47:25 MindsDB SQL Queries via Rest API and Python Part 2
02:59:34 FastAPI Backend App
03:07:32 Why the FastAPI Backend
03:10:16 Create the Next.js Frontend
03:16:56 FastAPI CORS for Nextjs
03:26:26 Integrate MariaDB to FastAPI
03:31:02 Listing Database Data via API View
03:34:32 Detail View and Schema with FastAPI and Pydantic
03:39:32 Listing API Data with Next.js
03:44:37 Styling a Link with Tailwind
03:46:44 Dynamic URL Route Detail Page in Next.js
03:53:03 Next.js Layout & CSS Class
03:58:17 Reusable Next.js Link Component
04:03:09 Backend API Client in Next.js
04:08:38 Handling request errors with swr and Next.js
04:15:05 Nextjs Form sending POST Requests to FastAPI
04:23:43 MindsDB with FastAPI and Nextjs
04:30:23 Generate and Load Airport Data in MariaDB and FastAPI
04:39:36 Airport Dropdown Selector
04:45:32 Handling POST Data with FastAPI and Pydantic
04:50:51 Prevent Duplicate Airports in Next.js
04:57:56 Improve Flight Price Prediction UI
05:06:10 TailwindCSS Global Styles
05:14:16 Form Styling with Flowbite References
05:21:38 Prediction Results UI Table
05:35:36 Integrate MindsDB with OpenAI to Make Flight Recommendations
05:45:39 OpenAI Recommendation Response in UI
05:56:28 Unique Request ID for Forecasts
05:59:24 Recommendation Display
06:05:47 Purchase Links
06:10:08 Starting to Handle New Data
06:11:51 Export Data and Train a Gretel Model
06:16:49 Load Gretel Data to MariaDB via Pandas
06:31:52 Train MindsDB Forecast Model via Jupyter
06:43:07 Final Clean Up
06:45:04 Thank you and your next challenge

[davidkorn]

this kind of quality content for free is just mindblowing

[Batman-ldbm]

now it's gotten extremely complex, too many things happening at once. But, thanks a lot, man, for providing exceptionally high quality content for free. That's a game changer. Totally appreciate it, hahaha.

[eprohoda]

Codingentrepreneurs!bonjour. good . :)

[joaoarthurbandeira]

Hey, can you pleaase do a video on how to integrate DRF with Stripe (so users can put their credit card info once and make payments, say in a marketplace or ecommerce) and how to connect it with NexJs. I've searched a lot and there is no good/up-to-date video anywhere explaining this in details, it would be HUGE!! Thanks!

[seanthomson]

Absolutely loving this! However MindsDB Cloud isn't taking new users currently... Do you have an alternative I could use perhaps? Thanks in advance :) stuck at 01:23:13

[zrzft]

Awesome thank you! For an app with users logging in, would using DRF instead of Fastapi make it easier for managing users and permissions? Would love DRF+Nextjs+Postgres! Hopefully free instead of paid BaaS if possible for the lil guy.

[nakicode]

Thank you for this beautiful tutorial course

[marito]

Thanks, can you do a fastapi course like a "Try Django" -> "Try FastApi" 😅

[jimbo]

I do not have "lightwood" installed. Everytime I try to install it there is nothing but issues and it never installs. Any idea whats causing this?

[dgiri]

You can same do using Django and restapi every time shift other skills its takes more time

[ShourovRoy-pkzm]

Please come with a compete fastapi and graphql video ❤

[dev_apostle]

How would you suggest we demo the final app? How to deploy I mean?

[mohammedismail]

at 54:08 in the env.py file you are having errors in decouple but still the config is running in jupyter notebook. for me its showing a module not found error. how come ?

[drdarbandi]

nice job try to tag along a little bit more with sanctions in middleast for ai subscribtion services

[dev_apostle]

the price column is missing from the original data set

[dev_apostle]

Can we use something besides AWS for this?

[dev_apostle]

How did you get the dataset so small? I have 29k objects to iterate through in mindsdb. It keeps giving me a 40% status error on predictor model creation

[nakicode]

I would like to learn FastApi with nosql

[dev_apostle]

MACOs tells me to get docker desktop to run docker