Custom Search API with Serverless Database in Next.js with Xata

Published: 25 January 2023
on channel: Colby Fayock
1,978
68

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


Watch video Custom Search API with Serverless Database in Next.js with Xata online without registration, duration hours minute second in high quality. This video was added by user Colby Fayock 25 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,978 once and liked it 68 people.