Postgres Posts – Hack Club Scrapbook

I love maps! (well I guess this is python, so dictionaries :)) - anyways here's some map-of-the-slack-ery, now taking into account member lists of each channel. Still very jank, but that'll be changing soon! Less janky code + postgres + CLI tool is next, before refining the labeling process and moving onto clustering #100-days :picasso:

https://scrapbook-into-the-redwoods.s3.amazonaws.com/825e406a-0bba-4b95-9d52-3b37518e272e-image.png

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

Started Jams development. Postgres Database setup & starting routing on the NextJS side. (no styling yet of course) (also no real content yet)

I've been working on the backend. I've set up the postgres DB and the ORM (it was a bit of a hassle since using Typescript with it is confusing and tedious), I now have to build a scheduler for flights and I still need to figure out the video streaming,

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

day 8/10 of #10-days-in-public still trying to fix db, spun up a local db instead of using the supabase one

https://cloud-f1pewb4z9-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

as we're planning on relaunching some stuff for our hack club, i spent my afternoon building the backend for a chapter platform, where people can sign up for pathways, create a profile and access course content — built w/ postgres, supabase and airtable, probably gonna make an api & search engine for content soon :blob_hype:

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

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

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

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

hey look it's a database transaction :postgres:

https://cloud-4hnlmm4dl-hack-club-bot.vercel.app/0screen_shot_2021-09-24_at_10.11.01_am.png

messing around with custom psql prompts :postgres:

https://cloud-5z8jsicjk-hack-club-bot.vercel.app/0screen_shot_2021-09-01_at_10.20.56_am.png

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

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 got portainer, gitea and a postgressql server running on my pi! All very easy to use.

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

https://cloud-5qtti4d4y-hack-club-bot.vercel.app/1image.png

look at this beautiful query :postgres:

https://cloud-i7k7ecymx-hack-club-bot.vercel.app/0uploaded_using_raythis_extension_6_.png

switched shorty over from redis to postgres! this is a snippet of some diesel stuff :gas: clb.li/short

https://cloud-iodj32y3z-hack-club-bot.vercel.app/0rust.rs.png

Installed CapRover and set up a PostgreSQL database

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