zknill

8 ms·

91.
So you want to build AI Agent group chat like OpenAI?(zknill.io)
2 points by zknill 11mo ago|0 comments
92.
by zknill 11mo ago
I created a side project ~3 years ago based on a similar idea. It was before LLMs were a big thing, and AI could render the code relationships for you. I started with go and java (the two languages I was using in my job) and built AST pars
93.
by zknill 1y ago
This reads like a bit of a smell. I'd be pretty suspicious of why you have tasks and reminders in the first place. The question also reads like the volume of these tasks and reminders is large enough to be a problem. You should check o
94.
by zknill 1y ago
Typically applications will have some kind of logical separation of the data. Given this is targeted at replication of postgres nodes, perhaps the nodes are deployed across different regions of the globe. By using active-active replication,
95.
by zknill 1y ago
Looks like it uses Postgres Logical replication to share changes made on one postgres instance to another. Conflict resolution is last-write-wins based on timestamp. Conflicting transactions are logged to a special table (pgactive_conflict_
96.
by zknill 2y ago
IANAL but, you should be in contact with your airline about your specific flight. You are entitled to be re-booked on the next available flight or get a refund. If you take a refund the airline has no obligation to you anymore. You might fi
97.
by zknill 2y ago
> A spokesperson at MongoDB said: "The rise of MongoDB imitators proves our document model is the industry standard. But bolting an API onto a relational database isn't innovation – it's just kicking the complexity can do
98.
by zknill 2y ago
The other commenters have mentioned doing deploys behind a proxy, which is fine, but eventually you're going to have to re-deploy the component that terminates the client connections (i.e. websocket server or SSE, etc). From the client
99.
by zknill 2y ago
I work on the team that built a Postgres pub/sub connector at Ably (we call it LiveSync). Our postgres connector also works on LISTEN/NOTIFY and has horizontally scalable consumers that will share the load. There's two types
100.
Patterns for Building Realtime Features(zknill.io)
161 points by zknill 2y ago|45 comments
101.
Patterns for Building Realtime Features(zknill.io)
4 points by zknill 2y ago|0 comments
102.
by zknill 2y ago
A quirk of Go is that I can cast a `[]string` to `interface{}`, but I cannot cast `[]string` to `[]interface{}`. This blog post is my go-to explanation for why the second is not possible but the former is.
103.
by zknill 2y ago
The ElectricSQL concept of 'shapes' is interesting. Right now, a shape is just a single table with some column filters and a where clause. The shape is defined on the fly in the query string. Electric does single table sync of tho
104.
Data Integrity in Pub/Sub(ably.com)
1 points by zknill 2y ago|0 comments
105.
by zknill 2y ago
By putting all the state into a single CRDT then yes, you're going to get conflict resolution across the entire document. But you might also want to think about how big that CRDT state is going to get. There's no splitting or isol
106.
by zknill 2y ago
I don't know US commutes, or US geography too well. But it seems these two locations are about 45mins-1hr drive from each other. Where do folks actually live in those areas? Is it that a 30min drive north to San Fran becomes a 30min dr
107.
by zknill 2y ago
Also checkout Ably LiveSync, works with postgres and makes some different (potentially simpler) tradeoffs
108.
Database generated events: LiveSync database connector vs. CDC(ably.com)
1 points by zknill 2y ago|0 comments
109.
by zknill 2y ago
It's a server authoritative system, so the final state is determined by the server. There's a single global order of changes (basically the order the changes were processed by the server), so any conflicts are basically resolved b
110.
by zknill 2y ago
Various parts of the UK political system looked at a 'social media tax' that would then be funneled into the national health service for mental health. The idea was scrapped when it became clear the US would retaliate in some way
111.
by zknill 2y ago
The article gives one example: > Today, physical beat-downs are filmed and uploaded to school-based fight groups on Instagram and other platforms—where they live on more or less indefinitely (sometimes they’re forced down, but they inevi
112.
by zknill 2y ago
I'm confused why most of the discussion about these issues is based on blocking the means of access to the content rather than making those hosting the content responsible for it. Here we're talking about banning smartphones, rath
113.
Supabase Realtime vs. Liveblocks vs. ElectricSQL vs. Replicache vs. LiveSync(ably.com)
2 points by zknill 2y ago|0 comments
114.
Supabase Realtime vs. Liveblocks vs. ElectricSQL vs. Replicache vs. LiveSync(ably.com)
2 points by zknill 2y ago|0 comments
115.
Reliably syncing database and front end state(ably.com)
2 points by zknill 2y ago|0 comments
116.
Reliably syncing database and front end state(ably.com)
1 points by zknill 2y ago|0 comments
117.
by zknill 2y ago
Why do you recommend a heartbeat table to mitigate WAL slot growth if the PeerDB Stream targets a specific table? Presumably this means that the WAL slot is subscribed to all table changes, even if only specific tables are actually included
118.
by zknill 2y ago
Two things: 1. You want to land on the mid-foot. Heel-striking puts a lot of pressure up you leg and joints as you are basically braking with every step. Forefoot strike puts a lot of pressure on your calf and achilles as you have to '
119.
by zknill 3y ago
Of course it's possible to solve. But I think the solutions (and the cons of those solutions) are often pretty arduous or unreasonable. Take the example of joining multiple streams, you have to have all your data outside your database.
120.
by zknill 3y ago
All these tools built on Postgres CDC have tutorials that are based on a single table. But in real life, your data models are likely to be normalized across multiple tables with joins. Or you might have an aggregate object that contains mul

More ›