west0n

6 ms·

31.
by west0n 3y ago
TLTR: Understand and optimize relational databases (MySQL, PG) rather than introducing a new type of database (e.g., DynamoDB, Kafka, Redis) whenever issues arise. Common mistakes: - Lack of indexes - Using ORM (generating too many SQL quer
32.
by west0n 3y ago
The Reason Behind "Why Amazon forces its developers to write press releases" https://www.businessinsider.com/heres-the-surprising-way-ama...
33.
by west0n 3y ago
Recently, I learned that PostgreSQL can integrate with many languages through plugins, such as PL/Python, pgrx (Rust), pgzx (Zig), and so on. I wonder if anyone is planning to write one for Java or C#, lol.
34.
by west0n 3y ago
It seems that to counter this type of supply chain attack, the best practices for managing software dependencies are to pin the version numbers of dependencies instead of using `latest`, and to use static linking instead of dynamic linking.
35.
Full-scale file system acceleration on GPU [pdf](dl.gi.de)
148 points by west0n 3y ago|45 comments
36.
by west0n 3y ago
According to this paper, GPU4FS is a file system that can run on the GPU and be accessed by applications. Since GPUs cannot make system calls, GPU4FS uses shared video memory (VRAM) and a parallel queue implementation. Applications running
37.
by west0n 3y ago
PostgreSQL is a very unique community compared to other database community(MySQL, Redis, MongoDB, ClickHouse et.c). It is INDEED decentralized, which means NO single company control it. This is related to the style of PostgreSQL's prim
38.
by west0n 3y ago
Neal Gompa opened a discussion on the Fedora development list, noting the license change and the need to remove Redis from Fedora. Gompa also raised the issue on openSUSE's Factory discussion list. After Docker was phased out, various
39.
by west0n 3y ago
You may try kubeblocks(kubeblocks.io), a database control plane that can run almost any database on K8s.
40.
by west0n 3y ago
If you see following error logs, $ pueue Error: Couldn't find a configuration file. Did you start the daemon yet? Run `pueued -d` first. I think this prompt should be printed on the screen the first time it runs, or automatically exec
41.
by west0n 3y ago
From this blog( https://engineering.mercari.com/en/blog/entry/20240206-3a12b... ), it appears that Tortoise provides a feature that I think could be called managed HPV. It offers a way for administrators to con
42.
by west0n 3y ago
This incident reflects the increasing profit pressure on Redis Inc. Furthermore, Redis' competitive edge in performance is declining, especially with the emergence of alternatives like Dragonfly and Garnet (disscussed here https:&#x2F
43.
by west0n 3y ago
I know that some companies are developing AI-based interview products. In a video conference, the AI asks questions and then evaluates the candidate's answers, giving a score. This can save a lot of time for the interviewer. Such a wor
44.
by west0n 3y ago
Previously, I also used various so-called tiling window managers and configuring lots of shortcuts to improve my typing efficiency. Now, I mainly focus on researching how to use GPT to generate code .. Perhaps, in the future, using GPT effe
45.
by west0n 3y ago
I'm very curious if there are any databases running in production environments on Btrfs or ZFS.
46.
by west0n 3y ago
The vast majority of databases currently recommend using XFS.
47.
by west0n 3y ago
In East Asian cuisine, such as Japanese dishes, mackerel is a common ingredient. Grilled mackerel is delicious. Generally speaking, salmon is a fish with relatively low mercury content, much lower than that of tuna, making it a healthy choi
48.
by west0n 3y ago
And this is just a "External Fermentation Hypothesis"
49.
by west0n 3y ago
Here is the original research paper: https://www.nature.com/articles/s42003-023-05517-3
50.
by west0n 3y ago
Summary: how to write a PostgreSQL proxy with Python
51.
by west0n 3y ago
What surprises me the most is that this project is developed in C#, while Dragonfly is developed in C++, and Redis is in C.
52.
by west0n 3y ago
From the benchmark performance charts( https://microsoft.github.io/garnet/docs/benchmarking/results... ), the throughput of the GET command exceeds that of Dragonfly by more than tenfold. While 50% latency is s
53.
by west0n 3y ago
Both PlanetScale and Neon have the branch feature, and it significantly simplify the process of testing and staging. However, the feature in PlanetScale is closed-source, nice to see an open-source alternative of that.