Prisma Posts – Hack Club Scrapbook

Posts tagged with :prisma:

Let's do a quick showdown of what's been cooking for #C07NUNPGEU8| during the week of September 22 to 28, Philippines Standard Time. Apologies if this week's been a hell week due to being the 1st quarterly exam on the 25th and 26th day of September, 2024. The bulk of the coding hours in the week are dedicated to building the MVP features for the Slack app version of Recap Time Bot, our multi-purpose toolkit/service account/bot for Recap Time Squad's projects and friends, including hooking up Prisma ORM for Postgres data presistence on Nest (instead of coping up with the Airtable free tier limits) and building up some workflows via TypeScript Slack app development work (permission requests for accessing some bot features and slash commands). See the attached screenshots for a sneak peek. The rest is mostly infrastructure related work for both my personal and Recap Time Squad cloud resources (mainly Cloudflare DNS records over octoDNS and some Docker Compose shenanigans), plus some behind the scenes work for my website powered by Material for Mkdocs theme. Overall, I banked 10h 11m as of time of writing (up to the publication of this scrapbook entry), totaling to 14h 46m since September 17 (plus 10m designing for fun and profit) without the 'browsing' hours. See the thread for details on the stats.

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/42868358-9e1a-44cd-a1eb-63c140527596-image.png

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/fe27f75f-1a8f-4bbc-b416-5121474ab819-image.png

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/9fb249a7-6d12-4c11-b26c-a539f31071f2-image.png

https://imgutil.s3.us-east-2.amazonaws.com/4df45aa9d4c307b39f2215abf91496310c4ffe8e9189185a7183d96796688cdb/711a42ca-beed-4cf5-bec7-0a0a5bfd6816.png

I finally shipped my project 'Chatty' Its a fullstack discord clone with real time messaging Made with nextjs, shadcn, tailwind, socket.io, prisma, postgresql, It has responsive ui, with light and dark themes, Server creation, channel management.etc, tried to replicate major features of discord If you'd like, join the existing server I created using this link chatty-silk.vercel.app/invite/fd6fb69b-884a-4f2d-ae93-40299ff241ec Review this app and if you have any cool features in mind, just shoot me a dm... GitHub :github.com/jignesh119/chatty Live url: chatty-silk.vercel.app Note: -In the app voice and video calling requires a websocket connection between client and server all the time whereas vercel (where I deployed to) uses serverless architecture. Hence those features won't work -For realtime chat updates I've added constant polling as fallback for websockets(if no websocket connection) hence maintains realtime status Hence, To see app's full features set this up locally using instructions provided in readme. PFA screenshots of app:

https://imgutil.s3.us-east-2.amazonaws.com/4e12148de4c36433da40250642ea250f65a52707a3ef7728b1016982c813beaf/3eb490e9-ba20-4aab-aa98-e9c995dd01ec.png

Created a simple file manager website to learn how to use prisma and supabase. The project allows users to upload files and then store them within folders. Github: github.com/Flaryiest/File-Manager-Website Production: file-manager-website-production.up.railway.app

https://imgutil.s3.us-east-2.amazonaws.com/612cfaae62a7bcba723011e72ce8a2e1e34f16ebba6bf08f92a0686326af4bc6/ff27ceea-3159-4e82-875b-117a23f43a89.png

Ship! :shipitparrot: 🚢 #arcade I made a zapier-like automation tool ! It currently only works with notion, slack, google drive and discord. It was a really really complicated project, sometimes it works sometimes it doesnt. I tested it on different accounts and all of them create new sorts of problems. It's honestly a hit and trial thing, I really suggest you try it out, it might work for you ! While making this, Clerk has been an absolute pain to interface with my db. The part that I really love about this project is the workflow editor which is made with reactflow ! (most of the stuff in the ui is for decoration only, even the essential stuff aint working :skull-hole: , blame prisma or something) STACK: DB: Neon ORM: Prisma Framework: Next.js Bucket Storage: Uploadcare Auth: Clerk TBD: Setting up billing with Stripe (I dont feel like doing this bcz im not confident the automations work :blob_hehe:, blame webhooks now) Live: fuzz.srijit.xyz GitHub: github.com/DevSrijit/saas-automation

https://imgutil.s3.us-east-2.amazonaws.com/35015ed2ebea2924c5346ab9221cdb168ed7b244cb907003cbc6045057e276dc/e23f6a81-4aa0-4954-8f35-abb1454fba57.png

Release candidate for my FRC team management tool: • Uses Prisma ORM with a Postgres database • Heavy slack integration to make the experience as integrated as possible • Easily customizable Google Sheets frontend github.com/rutmanz/CLUCK

https://imgutil.s3.us-east-2.amazonaws.com/000a93b3b427e0f8597c60dfcdc3a8ddfb4bb055e6798d241727563a2d2306b7/48913ae7-f559-44aa-a8a2-e0416033375a.png

Devlog: Progress is being made at golinks v2, although roadblocks are being experienced in storing Slack bot tokens at Cloudflare D1 via Prisma at the moment. I expect to fully implement the bare bones within this week, among other things.

https://scrapbook-into-the-redwoods.s3.amazonaws.com/4e4252f8-0d2a-46cf-b42c-1426cda9603f-image.png

Hey 👋, I focussed me today on working at a page for users to create articles how to fix things on my email provider [selfmail](github.com/i-am-henri/selfmail). A user can now create and delete a post. A mod is able to delete this post too. I made this project using prisma and nextjs and the platform is completely open source avaiable as a monorepo. I plan to improve the ui and the user experience later.

https://imgutil.s3.us-east-2.amazonaws.com/285f33b1f4c8995e33fecbb8e616deba8d5c949378978623007c3449bb4765ca/b83c9695-1545-4f17-aa87-5049f0a0e1b7.png

Still this is not an official #arcade submission yet but quick status update, but I made a lot of progress on the golinks rewrite. github.com/andreijiroh-dev/api-servers/compare/136a6a95dafd2e3aee61de68785967cdd57b9110...d6d2d67d1da9e9f54f8ce79b6bbb2a6f7d6b30ad

https://imgutil.s3.us-east-2.amazonaws.com/3b6e7980a59602b3fb99faa76a79789d31d9bda2b7f8b41a8b76ab2bfa6a1eb6/22346da9-e5dd-4a32-b92b-3aaec064d825.png

No official submission from #arcade for today (god why I do this before 3 AM PHT), but currently working on implementing configuration stuff for dotenv-tools CLI, as well as doing a TypeScript rewrite of my golinks Cloudflare worker with sqlite involved (via D1) and Prisma ORM. What could possibly go wrong?

https://imgutil.s3.us-east-2.amazonaws.com/5919030f5fbdacef18a83699a061ebad314a8875cd61027b3899499657aa7a29/310c343b-f7f3-41bc-8057-83042fa8a612.png

Added a slack integration to my prisma-powered team management system github.com/rutmanz/CLUCK

https://scrapbook-into-the-redwoods.s3.amazonaws.com/05a00e6a-b2b7-4a0b-9fd5-37c1f3ff514d-image.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/f0ae0af9-6120-42f6-b8e4-bdebc0ec8420-image.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/7f70d5ce-fdbb-4d7d-9306-ea42aa143598-image.png

https://imgutil.s3.us-east-2.amazonaws.com/a9e2f6906a4acc524bc59f15cdaa4295456ad9814e1580f592afcbd08081246d/a4210461-7509-4a8a-bb9b-0ffd129beba2.png

Post 15 Papaya: A collaborative notes application built with TypeScript, JWT/Bcrypt, Express, Prisma, and PostgreSQL. It allows users to register, log in, create, update, delete, and share notes with other users. Users can also manage their profiles, update passwords, and search for notes. Check out the server and detailed documentation @ github.com/shrysjain/papaya

https://scrapbook-into-the-redwoods.s3.amazonaws.com/ea32773c-260b-4a13-944c-05e6e561765a-image.png

https://imgutil.s3.us-east-2.amazonaws.com/d73a4e57d8fda2a944b29b424d12c02ffdf8b77f589ec99b4fdb4465c1633289/662edc2d-bfa6-4d56-a3a9-ba8623ad1b6c.png

Created a social network just for fun in React with Nextjs and Prisma. Will implement new features in the future github.com/Lorenzo0111/socialnetwork

https://scrapbook-into-the-redwoods.s3.amazonaws.com/e7b6725f-949c-47ee-b756-dc2713ae4827-image.png

https://imgutil.s3.us-east-2.amazonaws.com/d73a4e57d8fda2a944b29b424d12c02ffdf8b77f589ec99b4fdb4465c1633289/c2f38663-b472-4a74-b876-df3eec28a0f0.png

Today I’ve built the todo app in two new frameworks: • Svelte • Next (With prisma and drizzle) I’ve probably finished the ideas of new frameworks

https://scrapbook-into-the-redwoods.s3.amazonaws.com/fa1fe0b5-caac-4707-8b7d-c97c75452f30-img_9963.png

Another project I made today was rewriting my old and messy javascript bot into a new stack using Bun, Prisma, Typescript and Docker. That's a discord bot to listen and forward minecraft plugin updates from the SpigotMC marketplace. github.com/Lorenzo0111/SpigotUpdatesBot

https://scrapbook-into-the-redwoods.s3.amazonaws.com/02602d72-ef4f-47a2-a9fc-fc592999db32-immagine_di_ios.jpg

Today I continued my streak of coding todo apps in different frameworks, that's the turn of Nuxtjs and Angular. The nuxt version is ready with Prisma database and also authentication. The angular version is still not totally finished github.com/lorenzo0111/todoapps

https://scrapbook-into-the-redwoods.s3.amazonaws.com/8bd4555b-2df0-4f7d-be1f-52b6bfb29ad6-image.png

Integrated Prisma ORM and meeting tracking with my team management system github.com/rutmanz/CLUCK

https://scrapbook-into-the-redwoods.s3.amazonaws.com/c9d45050-4baa-462a-a338-e5f9696ab604-image.png

Today I wrote a simple todo app using React Native to try out the new Expo API Routes system with Prisma. Next step will be adding authentication to the backend github.com/lorenzo0111/expotodo

https://scrapbook-into-the-redwoods.s3.amazonaws.com/03105347-6fb8-4230-9a59-be0424d7bce9-image.png

Day 1 of #15-days-in-public Added club creation functionality to my club dashboard! At the end I’ve spotted a little bug where I’ve not added the user to the club they created, whoops! Please don’t mind the CSS, I was fighting Prisma for ages on this lol

Club dash progress! Just been working on a Navbar. I forgot how to CSS :grimacing-hole: Clubs have been manually created for now (prisma studio <3), but on the navbar you can now select the club you want to view the feed for. If unauthed, it defaults to global and the dropdown doesn't exist

https://scrapbook-into-the-redwoods.s3.amazonaws.com/0144f01e-2340-4f73-a976-a33862253aa9-image.png

Started a new project! A dashboard for managing my club Setup a new Next app with Prisma and auth (mostly done but not enough to commit)

https://scrapbook-into-the-redwoods.s3.amazonaws.com/5ad95a46-c047-466e-bd58-29c2702bfcb4-image.png

It's been a while since I've done my #scrapbook, but that's likely because #hack-hour is a lot superior (I'm kidding! or am I?) - I'm working on a massive overhaul running on my new bestie Prisma :prisma: - stay tuned!

https://scrapbook-into-the-redwoods.s3.amazonaws.com/79bf1cc2-6aad-4ecd-a891-253d2eccc200-img_3415.jpg

🇨🇦 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