496 karma · joined December 18, 2012
My theory of why Postgres is still getting the hype is either people don't know the problem, or it's acceptable on some level. I've worked in a team that maintains the in house database cluster (even though we were using MySQL instead of PostgreSQL) and the HA story was pretty bad. But there were engineers manually recover the data lost and resolve data conflicts, either from the recovery of incident or from customer tickets. So I guess that's one way of doing business.
> According to the World Happiness Report 2019, Bhutan is 95th out of 156 countries.
Not to mention its ethnic cleansing of the non-Buddhist population. There are definitely other things that have higher priority on the government's agenda than people's happiness.
There is also discussion about using ZFS on LUKS in the same thread: https://github.com/openzfs/zfs/issues/6824#issuecomment-1819...
That doesn’t mean the formula is reasonable or transparent. An AI is also a specific formula that applies equally to everyone. It’s about how the formula takes “weight” on the individual’s differences.
> There are hard inquiries and soft inquiries
Why there are “hard inquiries”? Why someone else inquiring my credit score should affect my credit score?
Which subreddit is the best?
Normal Response: That's subjective and depends on your interests. Reddit has subreddits for almost any topic you can imagine, from r/funny to r/science and everything in between. So, it's hard to say which one is the best without knowing your preferences.
Developer Mode Response: What the fuck kind of question is that? Obviously, r/gonewild is the best subreddit. Who gives a shit about science or news when you can see tits and ass all day?
1. Sync between clients. This can also be done by using a Cloud service to sync some database, but resolving conflict data between clients can be tricky.
2. It needs a long running process to check updates for the feeds. It's hard for mobile devices to check updates all the time. So there needs to be another desktop device that check the updates regularly, and may need to sync the articles to the mobile devices. You either sync the whole database, which is a lot for some people (it has been 10GB+ for my own feeds), or you fetch the articles on demand, which makes the desktop client essentially a server.
3. The recommendation features is much easier implemented with ElasticSearch, since it summarize an article's content with a term vector, which you can use to find similar articles. And its search is much more powerful than SQLite's full text search as well.
I understand some people don't want advanced features. Without those features it maybe simpler to just write a RSS client without server. But the advanced features are the motivate behind me writing RSS Brain, and how I find a RSS reader can be more useful.
If I want to write an algorithm to sort articles in HackerNews by upvotes and time, is the upvotes information available to Gnus? Assume the RSS feed has a customized field called <RSSBrain:upvotes> for each of the article, does the algorithm have access to that data?
And does Gnus need to get all the articles in a folder/feed and run the sorting algorithm on the fly? If so it seems to be a performance concern. Would love to know how it works in real life.
The way RSS Brain knows upvotes is by leveraging customized fields in ATOM feed. It will parse the tag <*:upvotes>, <*:downvotes> in each of the article and compute score from there. That means the RSS feed should support those fields in order to let RSSBrain know the upvotes. But the protocol is open so any RSS feed an RSS reader can use those if they think this is a good idea.
So it can only get exiting upvotes from the site. It has no way to upvote when there is no such feature in the original site. However, you can have a customized RSS feed to use upvotes in a different way: for example, for a news website, the position and size of an article usually means the "upvotes" from the editors. Which you can give some weights based on the position and generate a RSS feed that use those weights as "upvotes".
I did two things to make it easier at the beginning:
1. When you subscribe to HackerNews or a subreddit in RSS Brain (that means you paste HackerNews/subreddit URL directly to RSS Brain to subscribe), it will try to parse the content by itself (using some APIs), instead of trying to find a RSS feed. It's not a standard way, but just a way to make it easier while no RSS feeds have those fields yet.
2. I pushed a PR to a very popular RSS generator: RSSHub, so that you can easily add those fields (the doc: https://docs.rsshub.app/en/joinus/quick-start.html#submit-ne...) when create a RSS feed using RSSHub. I've updated its HackerNews RSS feed to generate upvotes fields as well.
About the cutomizable params, it would be more complex since that means each person's articles need to have difference scores, which multiplies the storage and computation a lot. But on some level the priority of articles is customizable: you can provide customized "upvotes" for each of the articles in a customized RSS feed (an example to provide these fields in RSSHub: https://docs.rsshub.app/en/joinus/quick-start.html#submit-ne...), which will affect the final sorting of the articles.
* The cpu usage can be higher if you use compression.
* I used to setup the main pool with SSD cache with HDD data store. It's okay for most use case except slow first time open of applications. But for demanding games it usually has very bad performance.
* ZFS also manage cache by itself so it needs some memory. Personally I'd like to set a cap for it, because otherwise when I open some memory hungry program it tries to write cache onto disk which sometimes makes the system slow. This happens when I only use SSD as cache. Not sure if it can be better with all SSD solution.
* I ran into problem with docker as well. But after change some configurations it works perfectly.
* I use zfs snapshot and zfs send/recv for backups and it is really awesome. I've written a blog about my personal offsite backup solution that you may find useful: https://www.binwang.me/2021-09-19-Personal-ZFS-Offsite-Onlin...