zknill

12 ms·

151.
by zknill 3y ago
It's true for protocol version 1 that only the committed data is sent on the replication connection. In protocol version 2 (introduced in postgres 14) large in-progress transactions can appear in the new "Stream" messages sen
152.
by zknill 3y ago
The logical replication protocol sends a series of messages that essentially follow the flow that a database transaction would. i.e. a stream of messages like: "BEGIN", "[the data]", ["COMMIT" or "ROLLBACK
153.
by zknill 3y ago
The writes via SQLedge are sync, that is we wait for the write to be processed on the upstream Postgres server. So it operates as if SQLedge wasn't in the request path from application to Postgres. The writes to Postgres are only refle
154.
by zknill 3y ago
Yes, absolutely, and this is going to be one of the hardest tech challenges to solve. I've thought a little about it, and it's probably unrealistic to think that we can translate every single PG statement into a SQLite one, especi
155.
Log/slog: structured logging in Go 1.21(zknill.io)
4 points by zknill 3y ago|1 comments
156.
SQLedge: Postgres Replication to SQLite(github.com)
3 points by zknill 3y ago|0 comments
157.
by zknill 3y ago
If you're talking about the case where a local database forwards a read to the 'leader', and that read is put on the leader's log, but that read is only served when the read is replicated in the log back to the original
158.
by zknill 3y ago
This design is really similar to the approach taken by litefs[1] and turso[2]. Writes are forwarded to the primary (like you would with a write-through cache) and a local copy of the data is held in each region. These local copies are only
159.
So, you want to deploy on the edge?(zknill.io)
251 points by zknill 3y ago|131 comments
160.
by zknill 3y ago
The optimistic concurrency is a feature of SQLite, not their sqld server. And I think there are other approaches to replication that still retain the embedded aspect; litefs, litestream. I guess I'm thinking, if it looks like postgres,
161.
by zknill 3y ago
I thought one of the main attractions of SQLite was that it was embedded, so specifically didn't need an HTTP round trip to query the DB. It seems like this project removes that benefit, so what is it solving for or adding instead? Wha
162.
by zknill 4y ago
I built https://packagemap.co for working with Java code. It builds maps of your packages. If you try it out, I'd love to get your feedback.
163.
by zknill 4y ago
I built https://packagemap.co which is similar and designed for java. I'd love to get your feedback on it.
164.
by zknill 4y ago
Hey, cool idea. I built something similar for working with Java code, but it could be extended to other languages. https://packagemap.co I've seen engineers find it hard to work out if their code is organised well together.
165.
Radical advances in technology are alluring but incremental changes are better(zknill.io)
1 points by zknill 4y ago|0 comments
166.
by zknill 4y ago
There's a particular writing style that ChatGPT tends to produce that commonly starts sentences with "As a [xyz]..." and "By doing [abc], we achieved [xyz]..." , it also tends to hedge sentences by adding in words l
167.
We improved Packagemap's query performance by 4x(blog.packagemap.co)
1 points by zknill 4y ago|0 comments
168.
We improved Packagemap query performance by 4x(blog.packagemap.co)
1 points by zknill 4y ago|0 comments
169.
by zknill 4y ago
I found the name of this confusing. I immediately thought of "Cards against Humanity"[1], so I kind of expected an interactive game based on ChatGPT. The site appears to be an aggregator for negative coverage of ChatGPT. 1. https
170.
Radical change is alluring but incremental is better(zknill.io)
1 points by zknill 4y ago|0 comments
171.
Embrace the Power of Incremental Change in Technology(zknill.io)
1 points by zknill 4y ago|0 comments
172.
How to Write Confidently with ChatGPT(zknill.io)
1 points by zknill 4y ago|1 comments
173.
Writing Confidently with ChatGPT(zknill.io)
2 points by zknill 4y ago|0 comments
174.
by zknill 4y ago
I made https://packagemap.co to help me visualise the class, method, and type usages in the codebases I work on. It comes with a parser you run on your machine which generates a graph of your code. On the site you can use the fi
175.
by zknill 4y ago
Yes! Thanks
176.
by zknill 4y ago
I work in a large java code base, where I'm often exposed to brand new code (written a while ago, or written by other teams). I built this tool to help me understand the unfamiliar: https://packagemap.co There's a pars
177.
by zknill 4y ago
I'd be very keen to hear your feedback if you do manage to give it a go. You can mail me hello@ <productname>.co
178.
by zknill 4y ago
I work in a large monolith that doesn't always have the package and code separation that I'd like. I built PackageMap to help me visualise the codebase, and see where the natural seams were -- or should be. https://pack
179.
by zknill 4y ago
I host my side project[0] on Fly.io using their "not for production use" LiteFS distributed SQLite database. I'm currently still in the free-tier. But I'd be perfectly happy to pay for the product. It's super easy t
180.
Common Code Coupling Mistakes(blog.packagemap.co)
1 points by zknill 4y ago|0 comments

More ›