HNHacker News
TopNewBestAskShowJobs

zkirill

746 karma · joined February 12, 2010

submissionscomments
zkirill··on What the Russians thought of James Bond in the 1960s
Apologies for the side question but this is the first time I’ve heard of the Spectator and was wondering if the subscription is worth it.
zkirill··on AWS power failure in US-EAST-1 region killed some hardware and instances
Amazingly insightful answer. Thank you very much!
zkirill··on AWS power failure in US-EAST-1 region killed some hardware and instances
Have there been any incidents that affected more than one AZ?

AWS RDS in multi-AZ deployment gives you two availability zones. Aurora gives you three. What kind of scenario would be used to justify three AZ’s for the purposes of high availability?

zkirill··on Fasting lowers blood pressure by reshaping the gut microbiota
Forgot about the heart palpitations! That was a fun discovery.
zkirill··on Fasting lowers blood pressure by reshaping the gut microbiota
Maybe you're right. It was a long time ago. The only points of data that I have is that I had a "college athlete" level of fat around my heart as per my sonogram and it took me months of work to rebuild my muscle mass.
zkirill··on Fasting lowers blood pressure by reshaping the gut microbiota
Fasting was one of the most memorable and shaping experiences of my life. I fasted for three days (72 hours of nothing but water) and observed so many interesting and fascinating things happening to my body each day: skin flare ups and subsequent clearings, changes in mouth and gut odour, periods of brain fog and brain clarity, cravings followed by complete loss of feeling of hunger. Every passing day had different effects. The most memorable was an astronomical improvement in my olefactory senses. By day two I was able to pick out the smell of individual ingredients in any dish being prepared in my vicinity. By day three, I lost the majority of my muscle mass.

The one and only time I ever did this was when I was young and in extremely good health (daily intense exercise, excellent diet, no health conditions). Slightly worried about doing it again today. Also, quite concerned having since learned that brain mass is the first stored energy source your body will go after during what is effectively starvation. Perhaps someone more knowledge on here can comment on how true that is.

zkirill··on Ask HN: Golang Codebases to Read
The Go standard library is excellent. When I wrote Go I always used it for reference and best practices. No other open source project really came close in my opinion except for other Google Go projects.
zkirill··on Ask HN: A late stage VC keeps approaching an early stage startup
Politely decline meetings. Say you're always willing to listen to offers and opportunities. Until they come up with some hard numbers and terms then they are getting more from you then you are from them.
zkirill··on Ask HN: Why aren't you coding?
Hope you get better buddy.
zkirill··on Colin Kaepernick Targets a Socially-Driven Billion-Dollar Company with New SPAC
Since they haven't chosen a ticker yet what's the best way to sign up for updates on this and get in on this early?
zkirill··on Japanese people may have gained longevity by balancing their diets
What's an alternative to the Economist? I can't find a better publication short of an academic journal or literature. Someone recommended Foreign Affairs but I've yet to buy one.
zkirill··on Ask HN: Essential life skills to function as a human being?
Human being living in isolation needs very different skills than a human being living among other human beings. The latter's ability to integrate into society is essential.
zkirill··on Show HN: Curl https://ec2.shop
Super! It would be great to see price per month as well.
zkirill··on Are US companies afraid of hiring contractors from Eastern Europe?
How do you advertise yourself or how can companies find you? I'm asking because I found Eastern Europe to be surprisingly underrepresented on the hiring websites that I use.
zkirill··on Ask HN: What is your Work From Home setup
Which standing desk do you have?
zkirill··on Ask HN: When do you think we will be able to regenerate teeth?
Depends on what you mean by regenerate. If you want to "remineralize demineralized enamel areas" [1] then check out nano-hydroxyapatite toothpaste that's been available for more than 40 years.

[1] https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4252862/

zkirill··on Ask HN: What is your Work From Home setup
My work from home and work on the road setup is a yoga mat. I found that my shoulder and back health were severely degrading after years of sitting and despite daily physical exercise, and this was the only solution that reversed that pattern for me.
zkirill··on Scaling SQLite to 4M QPS on a Single Server (EC2 vs. Bare Metal)
I can't find where Hetzner helps you procure the bare-metal. Only receive it and install it for you.
zkirill··on Scaling SQLite to 4M QPS on a Single Server (EC2 vs. Bare Metal)
Are there any services that help you buy the bare metal outright, set it up at a colo, and maintain it for you?
zkirill··on An introduction to RabbitMQ
Would anyone using RabbitMQ as a replacement for GCM/FCM on Android mind sharing their experiences?
zkirill··on Three bugs in the Go MySQL driver
As someone who is currently transitioning from Go to Java/Kotlin I agree with you to an extent. However, I was surprised that I wasn't able to find anything in the Java/Kotlin universe that is comparable to Go's web request context cancellation.
zkirill··on Three bugs in the Go MySQL driver
>> Instead, make sure that every SQL operation in your app is using the QueryContext / ExecContext interfaces

I've been wondering if this is indeed a best practice or something that should be used only when necessary. Should every database query really abort if the connection to the client fails?

In addition, if you follow this advice you now need to check if the returned error is context.Cancelled which warrants an HTTP 400 response.

zkirill··on Ask HN: Name one idea that changed your life
Splitting (also called black-and-white thinking or all-or-nothing thinking) was debilitating well into my adolescence.
zkirill··on Ask HN: Change in developer salaries in 2020 Q3 and Q4?
When do they start posting internship positions? Next summer’s salaries will be an interesting data point.
zkirill··on WSU scientists enlist citizens in hunt for Asian giant hornet
They should enlist dragonflies. A few years ago I was chased by this type of hornet in rural Japan and was saved by a dragonfly that intercepted it in a dramatic takedown.
zkirill··on Ask HN: Which tools do you use for wireframes?
I swear by the native iOS Notes app and an Apple Pencil on an iPad. Simple, reliable, no surprises, and easy to share.
zkirill··on Ask HN: Freelancer? Seeking freelancer? (April 2020)
SEEKING FREELANCER | Canada, Singapore, Japan | REMOTE

• iOS: Swift

• Android: Kotlin

• Server: Go (Golang), PostgreSQL

• Web: Angular, Hugo

Happy customers, mature product, experienced remote team, steady continuous growth, zero outside funding, recession proof business.

Say hello at kirill@getfillet.com!

zkirill··on New for AWS Lambda: Use Any Programming Language and Share Common Components
Noob question but is it possible/advisable to somehow (re)use prepared statements in Lambda?

"Prepared statements only last for the duration of the current database session. When the session ends, the prepared statement is forgotten, so it must be recreated before being used again. This also means that a single prepared statement cannot be used by multiple simultaneous database clients..."[1]

1. https://www.postgresql.org/docs/current/sql-prepare.html

zkirill··on Stripe Press
Off the top of my head:

* Undocumented surprise error when user tries to re-subscribe in a different currency or change currency. Solution is to recreate the whole customer.

* Docs instruct to subscribe new users to free plan which is actually a bad practice for reasons that include first bullet point.

* Lack of docs/guidance for China payment systems and seeing Stripe server and frontend errors in testing environment.

zkirill··on Stripe Press
I am actively looking for Stripe alternatives because there are several core platform features that are still not fixed or implemented, while every news I hear about Stripe seems to be how they are branching out into auxiliary services. Even their customer support has gotten worse in the past year or two.
← PreviousPage 5 of 8Next →