Prisma Posts – Hack Club Scrapbook

🇨🇦 Hack The North 2023! @ImDeet-U045B4BQ2T0, @fayd and I teamed up to make :goose-dance: Hack The Geese :goose-honk-left:! It was a game that attendees could play using the QR codes on their badges. Here’s how’d it work: 1. You’d scan your badge’s QR code to log in. 2. Your find someone who you’d like to compete against and scan their badge’s QR code. 3. You’d both receive a prompt, eg. “take a selfie with a someone with blue hair”. 4. You’d race to take a fun picture based on the prompt before the other player does. 5. You either win or lose, then you got to choose wether or not to rematch! You can go to htgeese.tech/album to see all the photos that folks took during demos with the game (and many more of me stressing over the backend)! We used a slightly cursed combination of a Next.js frontend and a backend written in Go which interacted with one another through Websockets…. yeah, very cursed and very jank. We also used Vercel’s new Postgres & Blob storage services which were surprisingly good. And, of course, we used Prisma…. including it’s slightly hacky spin-off Go client. Another awesome part of the game was @ImDeet-U045B4BQ2T0’s custom designed geese (GEESE!): :htn-goose-1: :htn-goose-2: :htn-goose-3: :htn-goose-4: :htn-goose-5: :htn-goose-6: :htn-goose-7: :htn-goose-8: :htn-goose-9: :htn-goose-10: Every player got one of these made for them when they first signed! The game was a bunch of fun to play IRL and we had people playing it throughout the demo session. Attached is a sick selfie of @fayd in his sunnies and the judge! And at the end of the day, somehow, we were selected as winners so we got to demo on stage and won a couple of prizes which was pretty cool! Here’s us playing a game with all the attendees and a couple of other photos from the weekend (including us working on the project while on #hack-night!). The GitHub is full of more photos and stories from the weekend: github.com/sampoder/hack-the-geese. O CANADA!

https://scrapbook-into-the-redwoods.s3.amazonaws.com/cf2b0eb5-4b92-4c06-b2aa-78cf8f83342e-68747470733a2f2f636c6f75642d3677737063706132732d6861636b2d636c75622d626f742e76657263656c2e6170702f3070726f6d70742d302e393935333738393433393239363533322e706e67.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/2f66fef0-8448-486c-be64-62d76829d73b-268510329-08ca52f3-2170-453e-b223-0abe5576a1d4.jpg

https://scrapbook-into-the-redwoods.s3.amazonaws.com/f4cfcc99-9382-4421-a683-adbf54bf5d35-268510412-4a7e75e7-e510-48f7-bf8e-38f493a24f4c.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/880621d2-d658-4bdc-8769-7cf5c80e4be4-268509113-916408e1-8e21-4487-9c4c-2dd77e81515b.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/f34e634d-a7b3-4b96-b381-aef9f5afb17c-68747470733a2f2f636c6f75642d38626e6877713064682d6861636b2d636c75622d626f742e76657263656c2e6170702f3073637265656e73686f745f323032332d30392d31375f61745f372e34382e34355f616d2e706e67.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/b08d5e1f-f330-4c45-bcd1-6ae51255a6ba-268523676-2aaf42d3-3d4c-4a93-bea4-4c6b212b3905.jpg

https://scrapbook-into-the-redwoods.s3.amazonaws.com/49062a69-7d85-4924-99f0-a56aae1619b7-68747470733a2f2f636c6f75642d38626e6877713064682d6861636b2d636c75622d626f742e76657263656c2e6170702f3173637265656e73686f745f323032332d30392d31375f61745f372e34392e30335f616d2e706e67.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/a22cced9-0970-40fd-9700-a106aff68745-screenshot_2023-09-17_at_6.13.58_pm.png

🔗 It was a little difficult figuring out what event people came from when they joined the slack. But, gone are the days of pre-filling the welcome reason or sending them a DM. As Angelhacks got a little closer, after talking with some people, I thought it would make more sense to have a new parameter on the join form that would keep track of where they came from, add them to the right channels automatically, and give them a chance to introduce themselves with the welcome reason. For example, if you joined from hackclub.com/slack/?event=angelhacks, or something like hackclub.com/slack/?event=angelhacks-toronto or any future event, Toriel will check for the event name in it's transcript, and add you to #angelhacks, and so forth. It was my first time working with :prisma: Prisma and some :nextjs: stuff , and I have to say they're both supper cool and fun to work with (well for the most part, this took me longer than I would like to admit :p)

day 3/3 for WHW : prisma, data, api, stuff -

https://cloud-mt752tfmd-hack-club-bot.vercel.app/0image.png

day 1/10 of #10-days-in-public , i setup the whole environment/repo for my app. It’s using go on the backend + next on the frontend. Additionally it uses prisma client go as the ORM & fiber. thought this would be a fun way to get better at golang :gopher:

https://cloud-of2yc5ipe-hack-club-bot.vercel.app/0img_4480.png

made a little script to move airtable records to a db with prisma, and met up with @reesericci today

https://cloud-b8saa5h05-hack-club-bot.vercel.app/0image.png

Day 4 of #10-days-in-public. I setup nexus prisma (graphql-nexus.github.io), and I faced an issue setting it up but fortunately I fixed it I also started creating a basic mock-up for our web dashboard so I have something to build off of, since we already have a colorscheme and an idea of what our web dashboard will look like it shouldn’t be too hard to implement. I plan to start building the web dashboard on either day 5 or day 6.

https://cloud-5v0wzfxe4-hack-club-bot.vercel.app/0image.png

#10-days-in-public (day 3) hi :hyper-dino-wave: I deployed our backend to hop.io today. We have credits so I decided to take advantage of that (our stack for our backend is typescript, fastify, graphql & prisma if you are curious) i made progress on the github auth for our web dashboard (not ready just yet)

https://cloud-f8ukelkty-hack-club-bot.vercel.app/0screen_shot_2022-10-07_at_4.32.31_pm.png

Today, I tried out :redwoodjs:RedwoodJS for the first (I’m planning to start using it in a new project!). As I was playing around, I made this small website that housed a collection of dinosaur images! It was interesting messing around with Redwood’s generators & how Redwood uses Prisma. 🌲 Into the redwoods I go...

https://cloud-mfkxv8rp0-hack-club-bot.vercel.app/0into-the-redwoods.gif

migrating all the HA stuff to prisma + cockroachdb

https://cloud-c6o55sfah-hack-club-bot.vercel.app/0image.png

I re-wrote my website again and added a Guestbook which uses Prisma and Postgres.

https://cloud-m719559bi-hack-club-bot.vercel.app/0screen_shot_2022-05-13_at_00.21.45.png

Today starts May! And that means my birthday 🍰 🎂 is in two weeks! :parrotdad: :tw_spiral_calendar_pad: Here's as well a picture of a plant 🌱 I took today and a very awesome picture of my new Scrapbook CSS Stylesheet! :css: This is the most complex design I've done for it: It includes a custom background with a texture, gradients, special sized borders with a cool :cooll-dino: red color #EC2F3A I did with the hexadecimal value, and great Pseudo-elements like :before and :after! Also thanks to the #scrapbook Prisma/Postgres:prisma: :postgres: database I learned that I have a 210 days streak! And speaking again on this, here's my Scrapbook website and the GitHub :github: Gist! Feel free to star ⭐ it if you like it!

https://cloud-mmkefkbpz-hack-club-bot.vercel.app/0screenshot_20220501_221430.jpg

https://cloud-dpie0dquw-hack-club-bot.vercel.app/0img_20220501_164543.jpg

@msw & I have been updating Slash-Z to use Prisma

https://cloud-o2i5giwwh-hack-club-bot.vercel.app/0screenshot_2022-01-13_at_10.00.04_am.png

nextjs stickers finally came

https://cloud-pazjpwokk-hack-club-bot.vercel.app/0img_0139.jpg

learnin go, postgreSQL, and prisma by making a neat little project with it :cooll-thumbs:

https://cloud-rghbmb120-hack-club-bot.vercel.app/0image.png

As some of you may know, Scrappy recently went on an eventful holiday (read the story in #scrapbook)! 🎉 Luckily, Scrappy is back and better*! It’s internal storage unit has been updated to switch from the Airtable Store-a-tron v0.1 to the PostgreSQL Prisma Flexi-tron! The old store-a-tron was showing a big :warn: so we need to change before we had to shill out a ton of money for an enterprise variant. (this has been something i’ve been pushing through working on since last month and i’m so glad it’s finished, if you haven’t picked up Scrappy and Scrapbook now runs on PostgreSQL and Prisma, source at github.com/hackclub/scrappy & github.com/hackclub/scrapbook) the Flexi-tron is known to be buggy, so if you run into any issues please please ping me and let me know so I can fix everything up, thanks :D

https://cloud-jlwhxuewc-hack-club-bot.vercel.app/0wtqqnkydyi2ifswzvw2mt4-1200-80-2.jpg

I’ve been hacking on Scrappy (:prisma: :postgres: 👀), just testing I haven’t broken them in the mean time

https://cloud-3quu15r1z-hack-club-bot.vercel.app/0screenshot_2021-08-09_at_11.05.32_pm.png

did some prisma + next js finagling!

https://cloud-7us7sscxh-hack-club-bot.vercel.app/0screen_shot_2021-08-05_at_12.47.48_pm.png

I’ve been trying out doing video workshops and am running a workshop right now at Prisma Day :prisma: that I’m really proud of! it’s on Next.js & ISR with Prisma it’s running in a couple of moments @ www.youtube.com/watch?v=Yw8AWFZlXXE and everything is open source @ github.com/sampoder/prisma-day-2021 :D

https://cloud-d7okryq2i-hack-club-bot.vercel.app/0screenshot_2021-06-30_at_11.15.21_pm.png

been working on converting my discord bot Porygon from js to ts for the past week. this is what my file structure currently looks like. it's really fun and i'm learning a lot about TypeScript, Prisma, and PostgreSQL.

https://cloud-p9od4ai7b-hack-club-bot.vercel.app/0image.png

i recorded my Prisma Day talk and they had this epic setup :0

https://cloud-drvhrrba0-hack-club-bot.vercel.app/0screenshot_2021-06-15_at_9.16.21_pm.png

Prisma is amazing, now I don't have to have my database models in three different places, all slightly different

https://cloud-ko2m6kfx7-hack-club-bot.vercel.app/0screenshot_20210306-141620.png