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-product-listing-starter 💾 Code https://github.com/colbyfayock/my-product-search https://my-product-search.netlify.app/ 🗒️ Read More https://spacejelly.dev/posts/how-to-build-search-for-a-serverless-database-with-aggregations-using-xata-in-next-js/ 🔔 Subscribe for more tech and developer videos null 🐦 Get updates straight to your Twitter @colbyfayock https://twitter.com/colbyfayock 📸 Catch the next stream live on Twitch @colbyfayock https://twitch.tv/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: hello@colbyfayock.com 👨‍🚀 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/promptcloud/amazon-product-dataset-2020 🎼 Music Music from Uppbeat (free for Creators!): https://uppbeat.io/t/avbe/coffee-on-the-patio License code: WK5SXKPEYAIIDYLF #colbyfayock #xata #nextjs #search #api #serverless #webdevelopment