HNHacker News
TopNewBestAskShowJobs

pingsl

105 karma · joined December 15, 2021

~ Database engineer for decades

~ Open source evangelist for a while

submissionscomments
pingsl··on We lost 54k GitHub stars
This is horrible -_-!!! But I wonder what would happen to GitHub Discussions in this situation?

I now 100% feel necessary to build a Discord channel for OSS projects.

pingsl··on Super Simple Storage Service
Confused for a second till I saw "Write-Only storage".

Obviously, they should include "Trash bin" in the pricing comparison table.

pingsl··on IBM Parallel Sysplex
From an app dev perspective, sysplex is very similar to a single system image, especially when they are using the Db2 database.
pingsl··on I found a security issue on a competitor, got fired and served a summons
You were very likely not the only one who found this security issue. But you were probably the only one who disclosed this issue to the bank.

This is ironic, but it is how business people deal with issues.

pingsl··on The first RISC-V portable computer is now available
I am very excited to see the RISC-V devices come to the end users.

Then I am thinking how this device could fit into my daily life. I am wondering what are the typical scanrios for portable computers these days?

pingsl··on We’re the founders of Substack, we just launched an iOS app. AUA
I have accounts on Medium and Substack.

In the beginning, I posted blogs on Medium, and I sent out newsletters on Substack.

Then Medium started to provide email subscriptions.

Now Substack has a mobile app.

I need to rethink my content strategy going forward...

pingsl··on Postgres Auditing in 150 lines of SQL
> if someone has access to data the assumption is they are able to read it.

This is not the case in most production for two major reasons:

1. Row-level security is expensive and hard to manage, so in most cases, users are granted the select privilege on table level. But indeed, it doesn't mean they should have access to all the rows in that table.

2. Power users should not have production accounts all the time. The production accounts should only be activated when power users have to perform the changes during the production change window.

So financial institutes usually generate two kinds of reports for audit/regulation purposes.

1. Report on the privileges and roles, which tells if a user should have those privileges and roles. This is a periodically static report.

2. Report on the actions a user has performed to see if these actions are part of the changes. This is a dynamic report in which we have to capture the select statements.

pingsl··on Substrait: Cross-Language Serialization for Relational Algebra
Me neither. That's why I posted here to see if someone could give some insights on this.
pingsl··on Postgres Auditing in 150 lines of SQL
I am afraid data audit is not just about data changes. The real challenge is how to audit the data read which people should not do.

Since there is no redo logs generated for data read, CDC could not help in this case. It will reply on the audit traces, the SQL capture and cache, etc. But it's costly.

pingsl··on Man given genetically modified pig heart dies
People die some day because of some disease. This is natural.

Give people a heart from other species, this is unnatural.

I'd rather transform my brain and thoughts into a robot.

pingsl··on Ask HN: What are some good keyboards?
I am using logi K580.

It can connect 2 devices and support both Bluetooth and Unifying.

Most important it has numpad with a compact size.

pingsl··on A new wave of Linux applications
> On windows and android was consensus reached between all interested parties or was consensus reached within microsoft/google?

This is exactly the number 1 challenge for Linux Desktops: hard to coordinate with each party, then we end up hundreds of different distros.

pingsl··on A new wave of Linux applications
> the overall user experience is very good if you stick to a pure GNOME desktop. KDE and Xfce are also pretty good.

Yes, exactly users have to stick to one single environment. But when you want to use Gtk application on KDE, then ...

pingsl··on A new wave of Linux applications
I mean the consensus about the visual/UX style like we have on Windows or Android.

It's not that hard, I believe.

pingsl··on A new wave of Linux applications
Agreed, KDE is great. I like Kubuntu and KDE Neon. A little bit frustrated when I have to use a Gtk application; it's sometimes not working well in a KDE environment.
pingsl··on A new wave of Linux applications
I use Windows/MacOS/Linux(Ubuntu) on a regular base.

As a ordinary end user, I feel

1. Windows software are usually good at product function design.

2. Mac has a better enforcement on overall UX. The visual across different software (from different vendors) are much consistent.

3. Linux desktop is unfortunately still missing above 2 points.

Some Linux distro provides really good visual, but it only applies to its built–in programs. If you'd like to switch to the external programs, the system visual might be fragmented.

I really hope in this new wave people could make some consensus on the visual of Linux desktop.

pingsl··on Tell HN: Voting on HN Fails Silently
Think about this, there is no notification system on HN. If you got any errors, you'd better send an email to the moderators here.

I did this when I first created the ID, the moderator helped me out. Or my ID will be shadow blocked. :D

pingsl··on Discord is a black hole for information
What he described is not only a Discord "issue", it applied to other modern communication tools as well. I feel Discord is better than Slack because there is no 10K searchable message limit for free accounts and ridiculous pricing model.
pingsl··on Daily chart: A new low for global democracy
This article is behind a paywall. I know there is a Chrome extension called "Bypass Paywalls". But I really don't want to use it, as it breaks the business model of the writers.
pingsl··on Ask HN: Is it ok to reject a job because I don’t like their software?
I am inquisitive about what kind of enterprise communication software you think is good.

MS Teams is not perfect but it's not that bad either. I have used Teams, Slack, even Discord a little bit. I don't think anyone of them is above average.

pingsl··on Volcengine Inc violates the Apache 2.0 License when using SkyWalking
I followed up on this and had some conversation with one of the Skywalking PMC members.

They escalated the situation to the company legal of Byte Dance (the parent company of Volcengine Inc.). Then Volcengine has added an Apache license file for Skywalking. Skywalking is open-source software, it has no commercial license. So nobody knew how to evaluate the impact of this violation. And some people thought it was well resolved.

I felt very frustrated about this. It means there is totally *zero* risk to violating an open-source software.

pingsl··on Google to turn on activity tracking for many users who turned it off
- The ability of Google Workspace organizations to turn off “Web & App Activity” for all users will be removed.

Why is this? The company should have control over how employees use the company assets.

pingsl··on Ask HN: I lack foresight. How to cope?
Try to stop thinking too much. There is a book called "The Power of Now". You live at this moment, you only need to care about this moment. You moved the box to the car, it's fine. You don't need that thing at this moment. When you need it, just go get it.

I know it will sound like old school.

pingsl··on MGui
I noticed it's "Last update: Aug 28, 2003". So what is the point here?
pingsl··on PostgreSQL query performance bottlenecks
These 2 predicates are totally different.

The predicate in the 1st statement is actually an expression "created_at + INTERVAL '90 DAY'", it's not column "created_at".

Some databases allow users to create indexes on expression. So if you want to write the 1st statement, you need an index on expression, not a normal index.

pingsl··on Microsoft to Acquire Activision Blizzard
Activision Blizzard is finally being acquired?! Yeah, no wonder, they are not doing well these years.

Wait, it's an all-cash transaction valued at $68.7 billion?! So at least Microsoft believes they are doing well...

pingsl··on More than 1M fewer students are in college, the lowest numbers in 50 years
China is on the opposite, for example, there will be over 10 million college graduates in China in the coming summer.

However, Chinese graduates are in a similar situation as US college graduates.

It's hard to find a decent job with a college degree. The college degree was once the premium but now more like a baseline in many industrials. Now China wants to push more young men to go to the professional education track.

But the challenge is there are more issues in professional education than in college education here.

pingsl··on Ask HN: What are the hard problems when building apps with a realtime back end?
I think it depends on the development stage of your product.

If you just get some amazing idea you want to quickly lauch and see the result, then the best way is to adpot 3rd parties as much as possible (as long as those stuff could work together).

Then your product receives the momentum, exciting. But you start to have all kinds of issues because you don't spend much effort on the stuff, the initial version. It's not about your capability. You just don't need a perfect design in the very early stage of the product. You might only need 1 or 2 people in order to get all the SaaS work together, although it's not optimal from system and computer resources perspectives.

Then you start to think about refactor the product, a better design, a decent system which means you have to worry about everything. And the first problem is do you have adequate engineers to do that work.

Some startups died in the refactor...

For realtime features, it's hard to build since you have to worry all the infrastructure, scaling and performance. And the even harder part is to run the realtime features smoothly and stably. So I would recommend to use 3rd parties SaaS until you have enough resources and time.

pingsl··on Why Germans remain so jittery about nuclear power
What is the alternative to nuclear power for Germans?

People want to control carbon emissions, people want clean power, people want cheap power, people don't want to take any potential (small) risk.

That is really hard.

pingsl··on New Year, New CEO
To host a privacy-first IM platform is really challenging. If they took advantage of the users' privacy (behavior, interests, contacts, etc.), they would make good revenue. But they will not.

Then how to make this good thing sustainable is a question. Users would think donation is fair enough. But the fact is a world-class IM platform needs an exceptional engineering workforce. Those people are not just looking for users' donations at will.

Page 1 of 2Next →