cadbox1

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

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.

It just did the same thing for me. Thank you for sharing.

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.

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

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

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.

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/

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/

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: cadellchristo@gmail.com

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.

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/

Powered by a PRAwN stack (Postgres, React, AWs and Node) in the free tier deployed using CDK

I don't have the startup part yet but here's my one-person stack with Postgres, Node and React deployed on AWS with CDK using RDS, Lambda, S3 and Cloudfront. It's 100% in the free tier.

https://github.com/cadbox1/prawn-stack

I think I’ve built something similar in React. It looks like a nested list but each item can have multiple parents. It syncs to GitHub and is public, I use it to share my recipes.

https://verynested.cadell.dev/ https://cooking.cadell.dev/

I like knowledge apps that use external storage like GitHub because you have control of your data without sacrificing the convenience of the cloud.

I did the same thing for my knowledge sharing app: https://verynested.cadell.dev/

I use it to share my recipes; https://cooking.cadell.dev/

I think graph/network based notes are really interesting and I'm keen to see how Athens develops.

I've created my own open source approach called Very Nested [1] that uses GitHub repos for storage. It also supports files and images.

So far, I've enjoyed organising my recipes [2] with it.

Feedback welcome, it's new.

[1] https://verynested.cadell.dev/

[2] https://cooking.cadell.dev/

I found myself wanting a graph based approach too, with multiple parents, so I created Very Nested [1] to find out what it was like.

It's open source, outline focused (like workflowy) and uses GitHub for storage and hosting. It also supports files and images.

So far, I've enjoyed organising my recipes [2] with it.

Feedback welcome, it's very new.

[1] https://verynested.cadell.dev/

[2] https://cooking.cadell.dev/

Did you use a tool to create the JSON or did you type it by hand?