Setup App Client

๐Ÿ‘จโ€๐Ÿ’ผ We are finally ready to start using our new SQLite database in our application. We've already created a PrismaClient in our seed script, but now we want to access our SQLite data in our application.
We're going to keep the old in-memory database around until we've migrated everything over, so just stick this new client above it at the top of .
You'll need to handle HMR (as described in the background info for this exercise) using the singleton helper.
We also want you to add logging for all Prisma queries, but we want to customize this so it only logs the slower queries so we can make sense of our logs. The emoji will help you out with that, but here are the logging docs.
Finally, we'll also want to pre-connect our client since we start making database queries right away and there's no benefit to the default lazy connection.
The emoji will be your guide!
Login to get access to the exclusive discord channel.
  • 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 ยท 17 days 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 ยท 20 days 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 ยท 10 months ago
  • general
    Remix Vite Plugin
    Binalfew ๐Ÿš€ ๐ŸŒŒ:
    <@105755735731781632> Now that remix officially supports vite (though not stable) what does it mean...
    • โœ…1
    3 ยท 10 months ago
  • general
    Welcome to EpicWeb.dev! Say Hello ๐Ÿ‘‹
    Kent C. Dodds โ—† ๐Ÿš€๐Ÿ†๐ŸŒŒ:
    This is the first post of many hopefully!
    • 17
    78 ยท a year 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 ยท 2 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 ยท 3 months 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 ยท 4 months 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...
    2 ยท 3 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...
    2 ยท 3 months 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 ยท 4 months 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 ยท 4 months 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 ยท 4 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...
    2 ยท 4 months ago
  • ๐Ÿ’พdata
    data modeling 06/02 is missing part of the prompt
    Allan ๐ŸŒŒ:
    In Data Modeling 06/02 the files include `server/index.ts` but there are no guiding emojis, no promp...
    • โœ…1
    2 ยท 4 months ago
  • ๐Ÿ’พdata
    Why does TS not like Buffer being used when the return type of the blob appears to be Buffer?
    OtterlyPunk:
    I'm looking at the return types from Prisma and it appears that the `petImage.blob` is a `Buffer` ty...
    • โœ…2
    5 ยท 5 months ago
  • ๐Ÿ’พdata
    ๐Ÿ”auth
    Prisma batching in the Require Authorized (07/03/solution)
    ajara ๐ŸŒŒ ๐Ÿš€:
    When I did the `requireUser` function in `auth.server.ts` I thought about using `requireUserId` func...
    • โœ…1
    4 ยท 5 months ago
  • ๐Ÿ’พdata
    ๐Ÿ”ญfoundations
    Handle Missing Data - Error when i'm using invariantResponse
    Luan.ibarra ๐ŸŒŒ:
    Hello, I'm trying to use the invariantResponse utility from // "#app/utils/misc.ts" to do this in a...
    • โœ…2
    2 ยท 5 months ago
  • ๐Ÿ’พdata
    Data Modeling: a real world scenario
    trendaaang ๐ŸŒŒ:
    Kent, In the data modeling workshop, you mentioned that polymorphism is generally a bad idea in dat...
    • โœ…1
    3 ยท 5 months ago
  • ๐Ÿ”ญfoundations
    ๐Ÿ’พdata
    general
    ๐Ÿ“forms
    ๐Ÿ”auth
    Native Logging
    trendaaang ๐ŸŒŒ:
    I was thinking that it could be useful to log every CRUD operation to help track down errors. Is tha...
    • โœ…1
    6 ยท 5 months ago
  • ๐Ÿ’พdata
    ๐Ÿ“forms
    Issues with child routes when loading a modal with actions (server/client)
    OtterlyPunk:
    I've set up a mini-project to go through the first set of videos and I'm having issues with the form...
    • โœ…1
    7 ยท 6 months ago
  • general
    The video play is pretty laggy currently
    QzCurious ๐ŸŒŒ:
    I thought I should tag you for this <@105755735731781632>. Please take a look if something wrong.
    • โœ…2
    9 ยท 6 months ago
  • general
    New Workshop Scheduled
    Kent C. Dodds โ—† ๐Ÿš€๐Ÿ†๐ŸŒŒ:
    Hey Epic Web devs! I wanted to let you know before everyone else on here: https://www.epicweb.dev/ev...
    • 2
    0 ยท 6 months ago
  • general
    Deploying an exercise
    Khoi ๐Ÿš€ ๐ŸŒŒ:
    Dear <@105755735731781632> , First of all, I really appreciate your effort in building this EPIC cou...
    • โœ…1
    1 ยท 6 months ago
  • general
    "Start App" throws error: Error: Cannot add empty string to PrefixLookupTrie
    Martin ๐ŸŒŒ:
    โœ— npm run start > start > kcdshop start [playground:4000] [playground:4000] > dev [playground:4000...
    • โœ…1
    7 ยท 10 months ago
  • general
    ๐Ÿ“forms
    Can't start the playground
    trendaaang ๐ŸŒŒ:
    Been a minute since I last worked on this course. Just tried running the app and was notified that t...
    • โœ…1
    3 ยท 7 months 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...
    • โœ…1
    12 ยท 5 months ago
  • general
    Question about the Workshop App tabs
    sjollivier ๐ŸŒŒ:
    Just started the course. I might have missed this in the Getting Started video, but how should I be ...
    • โœ…1
    1 ยท 7 months ago
  • general
    "Start App" throws TypeError: Cannot read properties of undefined (reading 'toLowerCase')
    ntin89 ๐ŸŒŒ:
    ```TypeError: Cannot read properties of undefined (reading 'toLowerCase') at userAgentContains (...
    • โœ…1
    4 ยท 7 months ago