Viewing profile — Nican

I think the article is great as-is, showing how the initial architecture choices can have deep consequences.

I remember reading about how the major airlines now are more of a "bank that happens to have planes," due to the loyalty programs being worth significantly more than the airline. D…

This looks like yet another basic key value store. Benchmarking is a complicated problem, but FoundationDB claims 300,000 reads per second on a single core. TigerBeetle claims 100k…

I am trying to read this article on my phone without an ad blocker, and it is an impossible challenge. Ads keeps loading and unloading, causing the page to jump around, and lose tr…

This is a nice article, and I appreciate the examples. The next problem to solve is how to persist state on disk across two different accounts after a transfer has been done.

Microsoft's blog post on Hyperlight got my attention a while ago: https://opensource.microsoft.com/blog/2025/02/11/hyperlight-... I am way out of my depth here, but can anyone make…

Yeah. I read over that page, and everything seems sensible. The only part that is not well explained is that "FoundationDB has been tested with databases up to 100 TB".

FoundationDB has been growing as my favorite database lately. Even though it is only key-value store. Out of curiosity: what are the scale limits of FoundationDB? What kind of issu…

Transactional consistency / ACID guarantees. Before you execute the query, you should be able to query any of the data, and after you execute the query, none of the data should be …

Yes. SQL is a form of API, and it carries all the same challenges. -> Permission control, making sure that the user of API can not see data they are not supposed to. -> Auditabilit…

This looks like a good use case for ScyllaDB with Compression and TTL. It is pretty simple to setup a single-node instance. If you rather have something in-process and writes to di…

As usual, there is a spectrum of data safety vs. performance. Redis is at the "very fast, but unsafe" side of the scale. ScyllaDB for me is in the middle of being high performance …

I have been out of the loop with Java. Is Virtual Threads the answer to asynchronous I/O? (Much like Go/C# async/node.js?) That looks like an interesting solution to support asynch…

> the SQL syntax for selecting a few records is much more verbose than head -n or tail -n I use DBeaver to inspect SQLite files, and to also work with Postgres databases. I kind of…

I am happy using CockroachDB. The performance is not as good, since all your database writes require a 2 out of 3 quorum. But managing the database with the CockroachDB is pretty s…

I first came to learn about the complexity of character sets by finding out that SQL Server's default characterset is 2 bytes per character. I eventually came across Scott's video.…

Careful not to repeat what the University of Minnesota did to the Linux kernel, when willing submitting security bugs to write out a paper about trust.

I thought of the same thing, so I am trying to find information on the documentation about things that CockroachDB does very well: 1. Consistent backups/transactions. When a backup…

AI can make you more productive, but it does not make you a better programmer. I am still skeptical about the quality of Copilot, but it has given me good suggestions about how to …

It would be interesting to have blog posts about the optimizations that were made.

I do not have that particular problem, but may I recommend for you to look for books on the subject? A search on Audible for "overachiever" came up with this: https://www.audible.c…

I am another person that still have problems opening up a tab, and trying to access social media, even though I know it is blocked on my computer. My solution involves a Pi-hole. Y…

I have been toying with the idea lately of using a transactional database (like SQL) to manage some of the very important queues. Using a transaction to retrieve an item from the q…

The answer here is non-trivial. I have since long stopped developing with PHP, but PHP has several run modes (And multiple runtimes like HHVM), that may bring different performance…

Why do you believe that PHP would cause issues that Nodejs would not?