Welcome to the EpicWeb.dev Workshop app!

This is the deployed version. Run locally for full experience.

Join EpicWeb.dev↗︎Login

08. SQL/01. Raw SQL (🏁 solution)

Raw SQL

Loading "SQL Queries for User Search in Prisma (🏁 solution)"

SQL Queries for User Search in Prisma (🏁 solution)

Run locally for transcripts

👨‍💼 Great job! So far we're not doing anything you couldn't do with regular Prisma, but we'll get there. I've got some more requirements for you than we had before. Let's take care of the TypeScript issues first though...

If you want to, you can update

app/utils/db.server.ts

to remove the old in-memory db we had before. We're not using it anywhere else anymore!

If you'd rather not, 🧝‍♂️ Kellie will do it for you.

← Previous Next →

Edit on GitHubEdit this page on GitHub

problem solution diff chat

Please set the playground first

Loading "Raw SQL"

Loading "Raw SQL"

Login to get access to the exclusive discord channel.

general
Resource / Api endpoints on epic stack / RR7
Lucas Wargha 🚀 🌌:
Hi everyone! Quick question for those using the Epic Stack: How are you handling resource routes ...
✅1
2 · 8 days ago
general
Epic stack using tanstack form
Lucas Wargha 🚀 🌌:
https://github.com/epicweb-dev/epic-stack/compare/epicweb-dev:main...wargha:feature/tanstack-form-ex...
✅1
3 · 25 days ago
general
Init command outdated on the EpicWeb website
Virgile 🏆 🌌:
Hi everyone. I've initialized a new epic-stack project yesterday. Following instructions from http...
✅1
3 · a month ago
general
Welcome to EpicWeb.dev! Say Hello 👋
Kent C. Dodds ◆ 🚀🏆🌌:
This is the first post of many hopefully!
18
81 · 2 years ago
general
epic stack website initial load at home page is unstyled (sometimes)
osmancakir 🚀 🌌:
Sometimes (especially when it is loaded first time on a new browser etc.) I see this unstyled versio...
10 · 2 months ago
general
Mark as complete, resets the first time you click it.
Daniel V.C 🚀 🌌:
Not sure if anyone else has had this issue, as i've not seen anyone else talk about it, but I find ...
✅1
8 · a month ago
💾data
general
📝forms
🔭foundations
double underscore?
trendaaang 🌌:
What with the `__note-editor.tsx`? I don't see that in the Remix docs and I don't remember Kent talk...
✅1
2 · a year ago
general
Keeping Epic Stack Projects Free on Fly – Any Tips?
Lucas Wargha 🚀 🌌:
I’ve been experimenting with the Epic Stack and deploying some dummy projects on Fly. I noticed that...
✅1
0 · a month ago
💾data
general
📝forms
🔭foundations
Creating Notes
Scott 🌌 🏆:
Does anybody know in what workshop we create notes? I would like to see the routing structure. So fa...
✅1
2 · 4 months ago
💾data
Prisma extension not showing my db
oaguinaga 🌌 🚀:
I noticed that in the data modeling module, Kent can visualize Prisma tables directly inside the edi...
✅1
2 · 4 months ago
🔭foundations
💾data
general
📝forms
🔐auth
Thank you for the inspiration
Binalfew 🚀 🌌:
<@105755735731781632> I wanted to thank you for the incredible knowledge I gained from your Epic Web...
❤️1
1 · 4 months ago
💾data
How often do you need to run a migration?
Scott 🌌 🏆:
I just finished the Data Migrations workshop (I come from a No-SQL background). Let's say I add a n...
✅1
1 · 6 months ago
general
npm install everytime I setup a new playground
Duki 🌌:
Is it normal that I have to run `npm install` in my playground directory, everytime I setup the play...
✅1
2 · 6 months ago
💾data
Code snippets in workshop app
remich 🌌:
What is used to include the code snippets in the workshop app? I'd like to have syntax-highlighted P...
✅1
1 · 7 months ago
💾data
a very large insert
osmancakir 🚀 🌌:
hi all, I need to perform seeding to my deployment. I followed the steps in the database documentati...
✅1
2 · a year ago
💾data
📝forms
🔭foundations
Reviewing foundations, Mutations, Actions
silvanet 🚀 🌌:
Forgive me for this. I went over the file size limit. I don't want to sign up for being able to exce...
✅1
2 · a year ago
general
Migration to Vite: Server-only module referenced by client
Fabian 🌌:
Hi, I'm working on migrating to Vite following the remix docs (https://remix.run/docs/en/main/guides...
✅1
1 · 8 months ago
💾data
Undesired behaviors while running the data-modeling workshop
juliano.brasil 🌌:
After pulling the latest updates I started experiencing 2 undesired behaviors while running the wor...
✅1
2 · a year ago
💾data
📝forms
Getting a TS error that is not present in the course files
OtterlyPunk:
So I'm working in parallel and I'm feeling the problem is I'm using a new version of something in my...
✅2
12 · a year ago
general
Remix Vite Plugin
Binalfew 🚀 🌌:
<@105755735731781632> Now that remix officially supports vite (though not stable) what does it mean...
✅1
3 · 2 years ago
💾data
Prisma Typed SQL
Kent C. Dodds ◆ 🚀🏆🌌:
Hey <@&1123674184959148043> friends, check out the new Typed SQL feature in Prisma! I've added an ex...
2
2
0 · 9 months ago
general
🔭foundations
Solutions video on localhost:5639 ?
quang 🚀 🌌:
Hi, so I'm having a hard time navigating (hopefully will be better with time) The nav on epicweb.de...
✅1
9 · 2 years ago
💾data
Multi-Column Index - How does it eliminate the B-tree?
Darren 🚀 🌌:
So I just finished the Query Optimization - 02 Multi-Column Index lesson and was confused by the fol...
✅1
2 · 10 months ago
general
Epicshop is now social and mobile friendly!
Kent C. Dodds ◆ 🚀🏆🌌:
I'm excited to announce that now the Epic Web workshops are mobile friendly! https://foundations.ep...
🎉2
0 · a year ago
💾data
📝forms
🔭foundations
How can I do this?
silvanet 🚀 🌌:
Viewing the Intro (from the Workshop) for Mutations, the course has an embedded video where Kent exp...
✅1
3 · a year ago
💾data
Query optimization for queries generated by prisma
Allan 🌌:
Hi everyone! I finished the data modeling workshop this week and was inspired to do some query optim...
✅1
2 · a year ago
🔐auth
💾data
08. ROLE-BASED ACCESS / 02. ROLES SEED - migration to local vs production
Fabian 🌌:
So I'm in a bit over my head with this one, in particular with how migration works in a local env vs...
✅1
1 · a year ago