Let’s add pagination to our loot table! We covered Search & Filtering last-time, and due to chat requests, today we’ll cover pagination 🙂
In this series with our new code-along project, Loot Goblin, we keep increasing the complexity until we get to working with ChatGPT and the OpenAI API! This will legitimately build CV experience for those fresh new “AI Developer” positions.
If you’re a beginner, you may want to start with that Portfolio series, and end up with the same or an equivalent project: • Brand new Fullstack Ap...
… or you can get Johnnify Premium which includes all this code & more, while supporting all my work 🙌
Playlist with all parts of THIS series: [www.youtube.com/watch?v=Ov]( • How to start a NEW app... )
-
This series will get you firmly into the day-to-day job of a software engineer, in any company. If you can talk to databases, APIs, if you can fetch data, and render it nicely on the screen, you can do web dev, I promise 👊
It’s also a great way to increase you price range: With our previous series, you should be able to make portfolio and marketing sites, but this one will get you into serious contracting range! You’ll be able to charge those who think they have the best ideas in the world some serious money 🤑
Or, hey, if you’re the one with the passion project, you’ll be more able than even to make it happen 🚀
🚀 Click around the app yourself: lootgoblin.vercel.app/
💻 See the code (private repo 😱): github.com/johnnify & github.com/johnnify/loot-goblin
- JOHNNIFY PREMIUM -
Get this repository AND MORE with Johnnify Premium: johnnify.com/premium
- 🙌🙌🙌 -
- COMMUNITY -
Our DISCORD SERVER 👾: / discord
- 🥳🥳🥳 -
- Agenda -
[ ] What are we doing today? Loot tables for dungeon masters and game designers?
[ ] `searchParams` to paginate results! kit.svelte.dev/docs/load#usin...
[ ] Implementing limit/offset pagination in Drizzle: orm.drizzle.team/learn/guides...
[ ] Pagination UI with DaisyUI and regular anchor tags: daisyui.com/components/pagina...
[ ] What about cursor based pagination?! Infinite Loading? orm.drizzle.team/learn/guides...
[ ] Let’s implement limit/offset with deferred joins!
[ ] What about full text search?! www.sqlite.org/fts5.html#exte... with Drizzle views?! orm.drizzle.team/docs/views
- BONUS -
[ ] Many-to-Many relationships: A Loot has many Tags!
[ ] Tag UI: daisyui.com/components/badge/
[ ] Tag filtering!
[ ] Vitest full-spec tests!
[ ] What about sorting?!
[ ] `searchParams` to sort on different columns!
[ ] UI: Apply different sorts on click!
- FUTURE -
[ ] Integrating with ChatGPT! Describe your party, ChatGPT suggests the loot drops! platform.openai.com/docs/intr...
[ ] Dynamic OpenGraph Images with: vercel.com/docs/functions/og-...
[ ] User accounts and authentication
- HAVE FUN -
No affiliations whatsoever: if I show something, you know you're hearing my unfiltered thoughts 😄
- Highlighted software -
SvelteKit: kit.svelte.dev/
Drizzle ORM: orm.drizzle.team/
Turso: docs.turso.tech/introduction
Tailwind: tailwindcss.com/
DaisyUI: daisyui.com/
Playwright: playwright.dev/
Vercel: vercel.com/
My own website: magrippis.com/
Search for `@jmagrippis` to find me on socials like Instagram & Twitter! And remember our DISCORD SERVER 😉: / discord
Between the comment section and the socials, let me know *somewhere* what you’d like me to cover next 🙌
Stream number 92!
Негізгі бет Ғылым және технология Fullstack SvelteKit: Pagination with Drizzle & SQLite 📕 Svelte 5 & Turso! LIVE Coding & Chill 🔴
Пікірлер