giovannibonetti

7 ms·

61.
by giovannibonetti 1y ago
According to [1], arena allocators provide low-latency high-troughput garbage collection riding on top of "practically unlimited" virtual memory implementations of 64-bit machines. However, it requires changes in the language leve
62.
by giovannibonetti 1y ago
Roc [1] is the language I think does the best trade-off among high-level instructions, design simplicity, performance, and pragmatism to handle real-world tasks. It started as a purely functional language, but the authors are adding some es
63.
by giovannibonetti 1y ago
Most indexes people hear about are like that. However, there are indexes that work the other way around, like Postgres' Block Range Indexes (BRIN). They are mostly useful as skip indexes - for a given block, they have a summary that te
64.
by giovannibonetti 1y ago
PF stands for packet filter in both cases
65.
by giovannibonetti 1y ago
Drones and VR require significant upfront hardware investment, which curbs adoption. On the other hand, adopting LLM-as-a-service has none of these costs, so no wonder so many companies are getting involved with it so quickly.
66.
by giovannibonetti 1y ago
At work we recently switched from Wkhtmltopdf to Typst, which is a breath of fresh air. It is very fast and generates PDFs from scratch without needing to involve HTML or a browser engine. It is implemented in Rust and distributed as a self
67.
by giovannibonetti 1y ago
I wonder if AI will solve that
68.
by giovannibonetti 1y ago
A board game has a much narrower scope than programming in general.
69.
by giovannibonetti 1y ago
> I think someone else likened it to a lawnmower that will run rampage over your flower bed at the first hiccup This reminds me of a scene from the recent animation movie "Wallace and Gromit: Vengeance Most Fowl" where Wallace
70.
by giovannibonetti 2y ago
Messaging platforms like WhatsApp come to mind
71.
by giovannibonetti 2y ago
The article mentions the struggle to speed up expression computation on MySQL due to its dynamic typing. I wonder if Postgres' more static type system works better in that regard.
72.
by giovannibonetti 2y ago
This works fine when you have partitioned tables over time, and the current partition is row-oriented, while the historic read-only partitions are columnar.
73.
by giovannibonetti 2y ago
When it comes to Postgres extensions for columnar storage, I like how Citus [1] handles the more general problem of columnar tables instead of focusing just on "hypertables" which necessarily must have a time column as primary key
74.
by giovannibonetti 2y ago
Maybe attending online college courses like Coursera could be a compromise?
75.
by giovannibonetti 2y ago
I don't use it at all currently because the problems it solves do not come up at my job. But if they did, I would gladly use it. If your job involves a lot of heavy number crunching it might be useful.
76.
by giovannibonetti 2y ago
For a more convenient way to use GPUs for algorithms like this, the Futhark language [1] can be very valuable. It is a very high-level language that compiles to GPU instructions, which can be accessed as Python libraries. In their website t
77.
by giovannibonetti 2y ago
To serve a user timeline in single-digit milliseconds, it is not practical for a data store to load each item in a different place. Even with an index, the index itself can be contiguous in disk, but the payload is scattered all over the pl
78.
by giovannibonetti 2y ago
Redis, SQLite or even a traditional DB like Postgres or MySQL can all do a better job than that.
79.
by giovannibonetti 2y ago
Storage can be further reduced if we think that, with a 64-bit processor, probably a 32-bit address space is enough for most applications (that require less than 4 GB of RAM). Maybe we can go even deeper with 16-bit near/relative point
80.
by giovannibonetti 2y ago
Yeah, RAG is a great way to handle outdated docs
81.
by giovannibonetti 2y ago
Regarding lossless text compression, does anyone know how a simple way to compress repetitive JSON(B) data in a regular Postgres table? Ideally I would use columnar compression [1], but I'm limited to the extensions supported by Google
82.
by giovannibonetti 2y ago
You might be interested in SQLx, since you write the SQL but the library generates the tedious bindings for you.
83.
by giovannibonetti 2y ago
Even better, based on queue latency instead of length
84.
by giovannibonetti 2y ago
For applications storing user data on Postgres, the citext (case-insensitive text) type does just that. https://www.postgresql.org/docs/current/citext.html
85.
by giovannibonetti 2y ago
> I still think the world really needs a solid, immutable-first and functional-first scripting/glue language, and Crystal isn’t that. The author might be interested in Roc [1] by Richard Feldman et al, which seems to check all the b
86.
by giovannibonetti 2y ago
That makes a lot of sense, well thought! The only thing I would like to add is regarding the critical mass of oppressed people in the US, at least when it comes to immigrants. I think the first generation struggles the most, but their child
87.
by giovannibonetti 2y ago
My bad, I had misunderstood that. You're right, and thank you for sharing it. That is a great differentiator. I see you have Python and JS/TS libraries, but my team is working with Go right now, so I'll have to pass. However,
88.
by giovannibonetti 2y ago
No, they don't. They work just like Temporal and the others, which send the durable state to a separate store. I totally understand that this is good for the tool business model, since many users will end up paying for the separate sto
89.
by giovannibonetti 2y ago
I've been looking into this space since I learned about Temporal recently, and I wonder if it would be better to have this integrated in my application, as a library, instead of an external dependency. This way, all the state would be
90.
by giovannibonetti 2y ago
Regarding causal ordering, it's worth remembering that a convenient way of implementing way is with Lamport clocks, since there is only a single variable to keep track of – the single monotonic clock that comes from the combination of

More ›