HNHacker News
TopNewBestAskShowJobs

kh1

67 karma · joined February 5, 2021

submissionscomments
kh1··on SQLAlchemy 2.0 Released
If you use pandas with SQLAlchemy, you should be aware that pandas might not be fully compatible with SQLAlchemy 2.0 yet.

Some github issues:

https://github.com/pandas-dev/pandas/issues/40686

https://github.com/pandas-dev/pandas/issues/40460

I'm not actively following how compatible pandas has become, but you should absolutely test your code if you want to upgrade to 2.0.

kh1··on E-bike batteries have caused 200 fires in New York: ‘Everyone’s scared’
Assuming it is ebikes that cause these fires, the scary thing is that residents may use water to put out fire without knowing what could happen.
kh1··on Python, Catastrophic Regular Expressions and the GIL (2013)
The gif showing the backtracking is cool. I wonder if there's similar tool for python.
kh1··on Append data to the url query
When I use curl, it's mostly when I need to check header or to trace requests in the network, for which I just use -vvv. Simple one-off stuff.

So I wonder how much demand there actually is for advanced features like this. When I need to make POST requests with queries and data, I would just use python because I most likely need to process the response (parse html, store json output to database, etc.).

Adding advanced features are nice, but IMO this might lead to over-engineering and it might be hard to maintain down the line.

kh1··on Honda electric moped coming, intended to fit “50cc” category
But there are people who ride illegal ebikes that go faster than 24km/h and I have never seen them getting caught
kh1··on UK Government Guidelines on Documenting APIs
This looks great, but many orgs use auto-generated documentations for client libraries (e.g. OpenAPI), which IMO doesn't give you easy-to-understand introduction/overview. And I've seen many documentation I have to decipher.

Although tools like OpenAPI has its own place when it comes to documentation, should we maintain "intuitive" end-user documentation separately? I don't think this can be automated based on the code.

kh1··on Managing Python Versions with Pyenv
Thanks. IMO changing system python versions might confuse some people.

I often have to debug not-so-tech-savvy colleagues' python scripts/environments.

If we used pyenv, I could picture me telling them that they forgot to switch system python environment.

kh1··on Managing Python Versions with Pyenv
I always have different python versions on system level (`$ sudo apt install python3.7 python3.8 python3.9 python3.10`) and use virtualenv to manage versions for each project (`$ virtualenv env -p python3.9`), and that has served me well for years. Could someone tell me why pyenv is superior?
kh1··on PipeWire 0.3.46
Interesting you and others use Bitwig, which I've never even considered using before. Maybe I should pay broader attention.
kh1··on PipeWire 0.3.46
What DAW do you use? I tried Ardour but gave up because MIDI experience wasn't good compared to Cubase.
kh1··on Playing with Matplotlib style sheets
Indeed that does make charts look better. I do this for grid line:

ax.set_axisbelow(True) ax.grid(True, alpha=0.3)

kh1··on Graphviz: Open-source graph visualization software
Oh I did take a quick look at the repo but didn't notice it was in the SQL. Thank you!
kh1··on Graphviz: Open-source graph visualization software
That looks really cool. Would you possibly share the script?
kh1··on Japan is holding back as the world rushes toward electric cars
I meant arguments I see in Japan.

In fact, car price movement is different in Japan, steadily rising since the 90s. [0] (Written in Japanese; The second chart is CPI-adjusted car prices)

Also PPP against US has been declining. [1]

[0] https://news.yahoo.co.jp/byline/fuwaraizo/20200519-00178444 [1] https://knoema.com/atlas/Japan/topics/Economy/Inflation-and-...

kh1··on Japan is holding back as the world rushes toward electric cars
Aside from the points mentioned in the article, I see a lot of arguments about economy: Real income isn't rising while cars are getting more and more expensive. Just checked the price of new Leaf, and it costs the same as median 1 year salary (before tax).

I think that explains why much gasoline "kei" cars (i.e. cars with less than 0.66 liter engine) are popular. They are much cheaper to buy, cheaper to maintain, etc.

kh1··on Survey shows people no longer believe working hard will lead to a better life
I just looked at graphics, but that's comparing minimum wage against various goods, isn't it? So it would be interesting to see the comparison between median wage and rent, etc. From the data, however, it looks like income inequality expanded quite a bit.
kh1··on CEO behind Japan’s best-performing stock says his secret is raising salaries
Very true, especially hiring "Scrum-experts/Agile coaches" and cheap engineers from outside. Based on my experience, they don't have good understanding of the business, so business people need to write up word-for-word documentation (e.g. Take this column from spreadsheet and multiply by 100 to show the numbers in percentage). At this point, business people who have programming skills wonder why they have to work with corporate IT.

On the other hand, don't many western companies outsource IT work as well? Having never worked in US/EU tech industry, I don't see much difference when it comes to outsourcing. (hiring temp engineers is obviously different from outsourcing, but the concept must be the same)

kh1··on WHO gives emergency approval to China’s Sinopharm coronavirus vaccine
According to WHO [1]:

> Few older adults (over 60 years) were enrolled in clinical trials, so efficacy could not be estimated in this age group. Nevertheless, WHO is not recommending an upper age limit for the vaccine because preliminary data and supportive immunogenicity data suggest the vaccine is likely to have a protective effect in older persons. There is no theoretical reason to believe that the vaccine has a different safety profile in older and younger populations.

Does that mean something? Could one argue China is pushing WHO hard for political reasons?

I mean, many countries are desperate to get vaccines, but why have we bothered with tests with different age groups if "there's no theoretical reason" to conduct enough tests for certain people?

I'm not an expert in the field, so there's a chance the preliminary/supportive data does in fact prove the efficacy for older populations as well.

[1] https://www.who.int/news/item/07-05-2021-who-lists-additiona...

kh1··on What's Salesforce? (2019)
Is it just me or does the Apex screenshot look better than many enterprise websites we see nowadays?
kh1··on English is relatively easy to learn, but not to master (2018)
When you finish middle school, you're supposed to learn most of kanjis used in real life.[0] At that point it's pretty rare to encounter kanjis that are completely foreign to you.

But there's electronic dictionary on which you can draw to search for kanji.[1] I used one of these in high school.

[0] https://en.wikipedia.org/wiki/J%C5%8Dy%C5%8D_kanji [1] https://www.casio.com/content/dam/casio/product-info/locales...

kh1··on English is relatively easy to learn, but not to master (2018)
I think you should start with easy ones. IIRC kids take small tests in class every semester at elementary school (like 50-150 kanjis per test). Those kanjis are the easy ones and then you can build up. So learning kanjis you find on a newspaper or a novel might be too hard. Understanding those words in real life context requires you to have higher language skills anyway (e.g. understand economy news or whatever in Japanese).

On a slight side note, kids can't even write their own names in kanji. You can imagine how happy we got when we were taught kanjis that were part of our name. So you shouldn't feel bad about it, taking small steps serve you well in the long term.

kh1··on English is relatively easy to learn, but not to master (2018)
As a Japanese, I agree with you. When friends who are learning the language ask me questions, I sometimes can't even answer them. So I end up saying "that's just how we say/use it".

And much respect from me. I wouldn't learn Japanese if my mother tongue is European language.

kh1··on The worst of the two worlds: Excel meets Outlook
True. The problem is people share the bug tracking spreadsheet over email, and you have to find out the latest version from inbox. I still don't know what the best solution could be for both business people and IT people. For word documents, I write in markdown and check in to git which allows me to compare the difference, etc. And I use pandoc when I distribute it as a proper document.