5 hours ago • Comments on a post

I've written about the "world of postgres wire compatible" [0] and yes there are some databases that implement the protocol and don't implement postgres (see: immudb and ravendb) I give databases like CockroachDB more credit for actually making their intention and generally following through with implementing Postgres. Also unlike some others on my list CockroachDB really is meant as an OLTP replacement. Performance characteristics and operations will definitely differ but as solely a user/application developer you shouldn't notice as much.

[0] https://datastation.multiprocess.io/blog/2022-02-08-the-worl...

6 hours ago • Comments on a post

Link to your implementation or notes? :)

6 hours ago • Comments on a post

I said absurdly reductionist and definitely meant that. :) There is a ton going on under the hood to make it work well, to fully implement postgres, and to work efficiently.

9 hours ago • Created a post

Let's build a distributed Postgres proof of concept

199 points • 43 comments

1 day ago • Comments on a post

Ah, now I understand what you meant.

1 day ago • Comments on a post

Sure that's fine too all I mean is that you can run WP on a $5 Linode/DO VM and handle the front page of HN but you need to do static page generation.

I think people underestimate what's possible cheaply and simply with static pages. (Not saying Cloudflare is not free for this load but it is a separate additional step you'd need.)

1 day ago • Comments on a post

It's not really closer IMO. The most obvious difference between PostgreSQL and MySQL is quotes. But you can have MySQL use ANSI quotes as a per-connection setting. PostgreSQL and MySQL both have advanced date manipulation functions and SQLite not so much. MySQL and PostgreSQL have much bigger standard library of functions than SQLite. SQLite comes with hardly any aggregation methods (stddev, median, mode, percentile, etc.).

Yes you can compile some of these in as extensions but for example even the sqlite3 CLI you have from your distro comes with almost none of these extensions.

1 day ago • Comments on a post

Hmm? Generating static pages avoids database calls to construct pages. You do it once when you publish/edit a post. Then every reader never makes a database call again.

1 day ago • Created a post

Performance tests for bulk insert into SQLite memory database in Go

2 points • 0 comments

1 day ago • Comments on a post

Just a reminder, always add on some static page generator on top of Wordpress so you completely avoid the class of problems with "too many database connections". Yes that error is MySQL specific but the class of problems you're avoid is: not hitting the database for fairly static content like blog posts.

1 day ago • Comments on a post

This is a surprisingly well-written, engaging corporate statement. Most statements are pretty bland and purely to the point but after reading this I thought I was reading news coverage of their exit not their own statement.

2 days ago • Comments on a post

Is there a way to write v8 bytecode directly and to execute v8 directly on it?

3 days ago • Comments on a post

I keep unread messages in my inbox. 10 in there right now.

3 days ago • Comments on a post

> For the C “FFI” he used standard dynamic linking, not dlopen(). This distinction is important, since it really makes a difference in the benchmark. There’s a potential argument about whether or not this is a fair comparison to an actual FFI, but, regardless, it’s still interesting to measure

4 days ago • Comments on a post

It's up now, thank you! The result is that INSERTs are still the same on my machine but SELECTs are at worst twice as bad and at best 10% as bad.

4 days ago • Comments on a post

Good point, thanks for checking out the code! I replaced db.Query with a db.Exec for the SELECT count (just to avoid the row iteration/deserialization) and I'm seeing closer performance.

I'll post an update and credit you.

4 days ago • Comments on a post

The code is on Github, links in the post. You can add whatever more usage patterns you'd like!

5 days ago • Comments on a post

I'd seen this one before but not the Djesus Uncrossed [0] one they mention here.

[0] https://www.youtube.com/watch?v=mqISX2o0a4A

5 days ago • Created a post

SQLite in Go, with and Without Cgo

4 points • 1 comments

5 days ago • Comments on a post

DuckDB: embedded OLAP, SQLite: embedded OLTP. For small datasets (<1M rows let's say) either would be similar in performance.

I need to do the benchmarks to substantiate this but this is my intuition.