Postgres Posts – Hack Club Scrapbook

Posts tagged with :postgres:

haven't posted here in a while but i just finished (the mvp) for my project rustytime :D (currently at ~75h) • what is it? It's like :wakatime: WakaTime but FOSS and made with a :rust: Rust backend, :svelte: Sveltekit frontend and :postgres: TimescaleDB (Postgres extension) • why? I though it would be a cool project :colon3: • is it good? Idk :shrug_y2: but you can judge it for yourself here :P • is it fast? It's pretty speedy! Over 1500 heartbeats/second on my machine! repo: github.com/ImShyMike/rustytime (you should give it a star :thumbup:) please send stuff you think i should add in the thread :)

Mapped out the architecture I'm going to build Hatchet in. ✨ It will use 4 different databases, postgres, scylladb, redis and opensearch. The clients will be written in TypeScript with React, expo + react-native for mobile, nextjs for the web and tauri for desktop. Backend will be written primarily in Rust and Golang with one microservice in Python. It will use Cloudflare R2 for file uploads, Signal Protocol for Encryption. Very excited about using Kafka (I have no idea how it works, but I guess its needed for this one).

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/7d0daa21-37b7-4cd8-8cbb-a32015950c07-image.png

Does anyone know the best way to deploy a project for free, with the ability to connect a local postgres, passwords/secrets and node backend, and have it publicly available? I need to deploy it for the Athena Award but don't want to spend money. I have my project on Github for reference: github.com/Christie125/Grove-Athena-Project-1

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/9db05233-d5db-4e0f-957c-5bf26fa7189b-f1f6aae1-284f-4b7e-9cb8-ad0954613c11.png

Wohooo! Not everything fully works, But most of the core stuf and all the tables are now no longer using node-persist (JSON) But now use postgres :postgres: I've also added all the stuff to :noco: and will do some cool stuff there :giggle: There is so much relational data! So this is such a cool usage! Ive seen how node-persist can struggle myself and this is sum i wanted to fix b4 V1 FOR SURE!!! :debot:

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/4bdab8bc-f443-4935-ab9a-5d1356ba15bb-cleanshot_2025-05-01_at_18.12.06.png

Quackatime updates for today: • Switched from TanStack Start API routes to Hono - much less buggy, much less code • Fix API keys always returning an “invalid key” error • Add a basic endpoint for the status bar - currently just says “Quackatime” but this will be fixed soon • Fixed hashes being too long and exceeding the 255 character limit in Postgres • Lots of code cleanup • We now use T3 Env for type checked environment variables • Added Biome (formatter + linter) and CI quack.skyfall.dev

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/e66c7a0b-fab8-44e7-8305-f42c8289e853-image_3.png

day 3 of #C045S4393CY| felt intense pain figuring out how to clear a postgres database :pf: procrastinated math and english and bio (3 for 3?!)

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/2403cac2-9c2b-4d4f-9a32-3e58d446638e-screenshot_2025-02-24_at_9.33.02___pm.png

Working on my portfolio! This project marks my very first Next.js project!! I added cool features such as - Headless blog (Hashnode), Guestbook (you can leave your reviews there!), etc more! Built with Next.js, Framer Motion, Postgres, Prisma, Google+Github oAuth, TailwindCSS CHECK OUT: ashish.top

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/6675fd2a-3581-4296-8bdf-9e78bd3c86e9-image.png

so chat is finally working, it uses websockets and a postgres database. the usernames are generated by hashing the user-agent and ip address, so everyone should have a randomly generated username

https://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/657ef970-f744-4b06-81a4-649ed93b067c-image.png

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

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://scrapbook-into-the-redwoods.s3.us-east-1.amazonaws.com/6921ef49-4901-461a-8f31-c3d9b2730ad4-53d6e78f-120d-4d29-a600-eaa942f44a7c.png

Working back on Horizon soon, but while we are doing that, I am working on a Discord bot to be able to help me automate stuff on the server as well as to replace Dyno, the bot that I am using on my server. Some initial features that I have is • AI through Google API (oh so help me arcade to get those OpenAI credits but it does work) • Announcements • Auto refresh of slash commands on startup • A database using Postgres More features are to come soon as I work on integration for the bot, maybe even verification for some sides 👀 But it does work, beautifully. Albeit the AI features are broken most of the time due to API issues or something like that. The sourcecode can be viewed at github.com/loomfi/Luna. I am attempting to figure out how to host, which I may use Nest for. Anyways, thank you guys!

https://scrapbook-into-the-redwoods.s3.amazonaws.com/5ef6962c-89f7-4f6c-b186-0dca2efd9f05-image.png

https://scrapbook-into-the-redwoods.s3.amazonaws.com/47906f7c-7b4f-462e-a45c-bcf92b8d9154-image.png

:purplebubble: Purple Bubble Ship! 🚢 More updates to magic mirror have been made! we are working on message reaction support, core schema changes, a db provider switch to postgres, as well as misc other bugfixes and improvements

https://scrapbook-into-the-redwoods.s3.amazonaws.com/1ad4de01-09a0-4cb9-9cb0-1014b47e5018-prisma_schema.png

github.com/Malthael134/todo-nextjs/commit/549eca0443f4aa26120b62b254a4465017d44604 managed to FINALLY understand the issue and fix it. I can now push my drizzle schema to the postgres db running in docker

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 #C01504DCLVD| 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