HackerTrans
TopNewTrendsCommentsPastAskShowJobs

cadbox1

no profile record

Submissions

Slowing Down

cadell.dev
3 points·by cadbox1·4 năm trước·0 comments

comments

cadbox1
·3 năm trước·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 năm trước·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 năm trước·discuss
It just did the same thing for me. Thank you for sharing.
cadbox1
·3 năm trước·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 năm trước·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 năm trước·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 năm trước·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 năm trước·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 năm trước·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 năm trước·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 năm trước·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/