HackerTrans
TopNewTrendsCommentsPastAskShowJobs

cadbox1

no profile record

Submissions

Slowing Down

cadell.dev
3 points·by cadbox1·4 lata temu·0 comments

Show HN: Random Emojis – A live feed of emojis using Cloudflare and WebSockets

emojis.cadell.dev
2 points·by cadbox1·4 lata temu·0 comments

Show HN: A pageview counter using the AWS free tier, Postgres, Node and React

prawn.cadell.dev
2 points·by cadbox1·4 lata temu·0 comments

Show HN: A modern page view counter to see how unpopular my project is

github.com
7 points·by cadbox1·5 lat temu·1 comments

comments

cadbox1
·3 lata temu·discuss
Figma uses a similar solution for their realtime feature. They have a famous article that explains why CRDTs aren’t necessary when you have a central server authority. https://www.figma.com/blog/how-figmas-multiplayer-technology...

I implemented the same solution with Redux actions and Cloudflare Durable Workers. https://emojis.cadell.dev
cadbox1
·3 lata temu·discuss
> people who curate digital gardens of knowledge are in a unique position to be curators of focused streams of knowledge

I think you're onto something here. I save and organise articles and have been exploring ways to share them for some time.

There's two ways to organise knowledge - chronologically and topically. They're both important but for different audiences. Organising chronologically means followers can keep up with recent activity. It's simple and works and is the basis for RSS and social media feeds.

Organising by topic is for knowledge management where you can arrange and re-arrange content based on your understanding of the topic. One day you have a list of cool engineering articles then you might split that into articles about data etc.

I'm working on an app that tries to capture both. Each topic has a timeline of updates and each topic can be broken down into other topics.
cadbox1
·3 lata temu·discuss
It just did the same thing for me. Thank you for sharing.
cadbox1
·3 lata temu·discuss
Nice work! It looks like Sequel Pro for Postgres.

This might be the first free, user-friendly interface for Postgres out there. Closest would be TablePlus but it’s paid.
cadbox1
·3 lata temu·discuss
I think a combination of chronological and topical organisation is best because each has their own audience.

Topics are great for visitors exploring your content for the first time and chronological updates are great for followers already familiar with your work.

This is the concept i’m exploring in my app, Kapa Notes. You write notes by topic and it generates timeline updates for you that you can edit as you like. I went with an outline based editor to reduce the friction of managing topics as much as possible.

https://kapanotes.com https://kapanotes.com/cadbox1
cadbox1
·4 lata temu·discuss
I built a notes app specifically for capturing my HN links. It organises them both by date and topic so I can browse them by topic but also find “that one link from last week”.

https://kapanotes.com/cadbox1
cadbox1
·4 lata temu·discuss
Deploy daily.

We had a similar issue in a Java application and couldn't work out the root cause so we decided to redeploy daily. No problems after that.
cadbox1
·4 lata temu·discuss
I came to a similar conclusion about CRDTs after reading Figma's article.

I ended up implementing state machine replication using Cloudflare's Websockets and Redux and found the result to work quite well.

Redux actions seemed ideal for this problem because you can simply share the actions between peers. I couldn't find many redux-based solutions out there but it worked well for my use case.

https://emojis.cadell.dev/
cadbox1
·4 lata temu·discuss
I'm building an app using fly.io and SQLite and it's pretty interesting.

this indie-stack shows how to use the remix framework, fly.io, SQLite and Prisma together.

https://github.com/remix-run/indie-stack

I think fly.io will only expand their SQLite features with the creator of Litestream onboard. Exciting stuff!

https://fly.io/blog/all-in-on-sqlite-litestream/
cadbox1
·4 lata temu·discuss
Location: Perth, Australia

Remote: Yes

Willing to relocate: No

Technologies: Typescript, React, Next.js, SQL, AWS, Java, PHP

Résumé/CV: https://gist.github.com/cadbox1/5dc033c47031989938fd0e079dca...

Website: https://cadell.dev/

Email: [email protected]

I'm an Engineer with 7 years experience in a range of roles, stacks and companies. I've been Full Stack, Tech Lead and Engineering Manager, working with React, Node.js, Typescript, Next.js, SQL and AWS, in startups, scale-ups and small business.
cadbox1
·4 lata temu·discuss
I wanted incremental refresh in Postgres as well and found that you can manage your own table to get something close.

Basically you create a regular table in place of a materialised one, only aggregate data newer than what's currently in the table then store the new aggregates in table. Repeat this an interval.

https://github.com/cadbox1/prawn-stack/blob/master/src/backe...

I use this to show page view data aggregated by hour without calculating it on each request using Lambda

https://prawn.cadell.dev/
cadbox1
·5 lat temu·discuss
Powered by a PRAwN stack (Postgres, React, AWs and Node) in the free tier deployed using CDK