Viewing profile — giovannibonetti

I wonder how we could handle that in a simpler way with durable workflows (e.g. Temporal, Restante, DBOS) – which are similar to Erlang processes but with persistent disk storage. …

Instead of spending all of this effort trying to optimize an OLAP data lake for an OLTP use case, why not ust use a regular OLTP database like Postgres or MySQL? Even if the data s…

> For example, for 360p video at 30 fps, where H.264 requires 1 Mbps, MLVC requires roughly 122 kbps for equivalent quality — about one-eight the bitrate under real-time conditions…

> It is just a really awful system overall. You mean for the user. It is great for the insurance companies, though, since tying health insurance to employment indirectly keeps the …

> FOR UPDATE SKIP LOCKED > The best way to think about this Postgres feature is that it reserves the rows that you’re selecting for use in your transaction without interfering with…

> The reason I think it’s useful to view queries as binary—they either seq scan or they don’t seq scan—is: the more you micro-optimize a query, the more of a risk you take that the…

> Because of all these connection footguns, external connection poolers like pgbouncer are great! If you can’t add this for whatever reason, in-memory connection poolers are a grea…

This reminds me of the Flix programming language [1], which has annotated effects like so: def main(): Unit \ { Clock, Http, Logger, IO } = ... [1] https://flix.dev/

This reminds me of this Bjarne Stroustrup's Rule (creator of C++): - For new features, people insist on loud, explicit syntax. - For established features, people want terse notatio…

> That's fewer moving parts, one load-bearing system instead of two... When I saw "load-bearing" I remembered the other discussion in the frontpage explaining how to prevent Claude…

Perhaps what is missing is a better memory/caching layer to avoid doing the same for explorations over and over again.

I wish LaunchDarkly and other feature flag providers supported protocol buffers to MN define the feature flag schema. It would be a game changer when you have complex variations an…

Property testing and deterministic simulation seem like good alternatives.

Shout-out to PowerSync for making it easier to develop fast offline-first mobile apps. It pushes data from Postgres/MySQL/SQL Server subscriptions to a SQLite into the user's mobil…

It would be even cooler if it was made with a Lisp and took advantage of it being homoiconic.

Those looking for a more mature solution in this space will probably enjoy SQLc [1]. It was initially developed for Go applications, but over the years it got pluggins for many oth…

> but seeing how Lustre does HTML templating versus how Phoenix does Heex was my deciding factor to try the latter. My understanding is this is because of a current lack of any mac…

For those of you a similar SPA-type app with more type safety – which is even more useful for writing code with AI – you may want to have a look at the Gleam language and the Lustr…

Given that it has only two commits, where the first one is just "done", I would guess a substantial amount.

If it's going to be read-only, why not make it a Parquet file instead? It should result in a smaller file size due to columnar compression. DuckDB has built-in capability to read P…

>There was a time that Google cared deeply about UX. Now, on macOS Google remaps CMD-G in Google Docs to launch some LLM bullshit That reminds me of a few years ago when Android ph…

As far as I can tell, Postgres is not designed with this inclination towards doing lighter work when clients are waiting and piling up maintenance work to do in background. I think…

Yes, partitioning will decrease a bit the read performance of queries not correlated with the partition key. That's why you need to periodically merge smaller partitions, so that y…

Say, if you know the function is a polynomial of degree N, with N+1 datapoints you can find it – e.g. with Lagrange's polynomial, although the finite precision of computer numbers …

With some extra admin work, you can greatly increase your insert throughput, as long as the table load is comprised mostly of inserts: 1. Partition your table by range of a monoton…