Custom Search API with Serverless Database in Next.js with Xata
Build a custom search API for a serverless database with custom filters and aggregations with a Xata.
We'll walk through creating a serverless database with 7,000 imported products for an online store, making searches with the Xata API using a Next.js serverless function, and using categories and filters to narrow down product options.
🧐 What's Inside
00:00 - Intro
00:45 - Tool we'll use including Xata and Next.js
01:11 - Setting up a new Next.js project
02:56 - Creating a new database in Xata
03:57 - Installing and logging in to Xata locally with the Xata CLI
05:17 - Importing product data from a CSV with the Xata CLI
06:48 - Using the Xata CLI to configure the project and install SDK
09:20 - Fetching product data from Xata
12:38 - Making a search request to product data
22:45 - Displaying all product categories and counts with aggregations
28:59 - Filtering search results by category
32:50 - Targeting and boosting columns with fuzziness typo tolerance to refine results
37:56 - Outro
🚀 Starter
https://github.com/colbyfayock/demo-p...
💾 Code
https://github.com/colbyfayock/my-pro...
https://my-product-search.netlify.app/
🗒️ Read More
https://spacejelly.dev/posts/how-to-b...
🔔 Subscribe for more tech and developer videos
https://www.youtube.com/colbyfayock?s...
🐦 Get updates straight to your Twitter @colbyfayock
/ colbyfayock
📸 Catch the next stream live on Twitch @colbyfayock
/ colbyfayock
✉️ Or a newsletter right to your inbox!
https://www.colbyfayock.com/newsletter/
💝 Sponsor me for more free content like this!
GitHub: https://github.com/sponsors/colbyfayock
Other: [email protected]
👨🚀 Brought to by colbyfayock.com
https://www.colbyfayock.com
🎥 Want to know what A/V equipment I use?
https://www.colbyfayock.com/uses
🧰 More Resources
Xata
https://spacejelly.dev/xata
Kaggle Data Source
https://www.kaggle.com/datasets/promp...
🎼 Music
Music from Uppbeat (free for Creators!):
https://uppbeat.io/t/avbe/coffee-on-t...
License code: WK5SXKPEYAIIDYLF
#colbyfayock #xata #nextjs #search #api #serverless #webdevelopment