ysw0145

Having more options available in the Linux kernel is always beneficial. However, Rust may not be the solution for everything. While Rust does its best to ensure its programming model is safe, it is still a limited model. Memory issues? Use Rust! Concurrency problems? Switch to Rust! But you can't do everything that C does without using unsafe blocks. Rust can offer a fresh perspective to these problems, but it's not a complete solution.

SQLite has its own decisions, to keep itself embeddable and low-footprint. There are many choices on the server but little on embedded devices like mobile phones. I have faced many problems that arise when using SQLite in a cross-platform mobile app, such as corruption and deadlock. However, there are almost no proven alternatives to SQLite.

DuckDB's memory model works perfectly well. I have run tests to benchmark the hash aggregation performance with different OLAP databases today, prepared a dataset with 10^9 rows and various distinct values. Within 32GB memory, DuckDB can finish the count distinct query (although it's slow). Others may tell me it runs out of memory, since all of them have the ability to spill to disk temporarily.

A cross platform file explorer that has a nice UI and plugins is awesome. Many people have more 2 devices runing with different OS. But still, Web techs maybe not a good fit for system tools, for its heavy stack.