HNHacker News
TopNewBestAskShowJobs

nikolatt

116 karma · joined September 29, 2017

Data Engineer Team Lead @ roiti.com
submissionscomments
nikolatt··on Postgres SELECT DISTINCT Does Not Scale
I haven't followed the latest Postgres releases, but I thought it would be added by now - Timescale/Tigerdata have already implemented a similar index scan in Postgres: https://www.tigerdata.com/blog/how-we-made-distinct-queries-....
nikolatt··on TALA Is Open-Source
The post does highlight that in the introduction:

> It doesn't do DAGs as well. I often find myself preferring Dagre or ELK when I want a long flowing graph.

nikolatt··on PgDog is funded and coming to a database near you
Why the snark comment? The PgDog project has been around for a while, it's not vibe coded.
nikolatt··on Vitamin D and Omega-3 have a larger effect on depression than antidepressants
Thank you for the comment. This is not in my area of expertise, so I hope you can clarify - how does one test that "mitochondria and other energy-related biochem phenomena work as expected"?
nikolatt··on Apache Iceberg
I've been looking at Iceberg for a while, but in the end went with Delta Lake because it doesn't have a dependency on a catalog. It also has good support for reading and writing from it without needing Spark.

Does anyone know if Iceberg has plans to support similar use cases?

nikolatt··on Apple's AirPods Pro hearing health features
Wait, those high frequency sounds in Tokyo are teenage repellents? I thought they are bird/insect repellants. I could hear the sounds and was literally getting mini headaches walking around.
nikolatt··on Ballerina: Functional programming framework for front end web development
Hadn't heard of this before, nice! Do you happen to know how they create/generate the diagrams on their homepage?
nikolatt··on Carapace: A multi-shell completion library and binary
I just want to say - thank you! I've been using ZSH since it became the default on macOS and one thing that started annoying me recently is the slow startup time. Your snippet tangibly improved that.

Do you by chance have any good resources on optimising my config further?

nikolatt··on Show HN: Dlt – Python library to automate the creation of datasets
It's literally the same library though
nikolatt··on Europe gas storage reserves – by country, updated daily
On the topic of AGSI, the company I work for published a Python client to work with their API in case you're interested: https://github.com/ROITI-Ltd/alsi-py

Edit: Correction, it's for ALSI, not AGSI, sorry about that. We should add AGSI now that the API is available.

nikolatt··on The opioid effects of gluten exorphins: asymptomatic celiac disease (2015)
It's not the year 2089, but the number of subjects (elderly individuals) which have been tested.
nikolatt··on Show HN: MonkeyMind – A shortcut-driven to-do list for your Mac's menu bar
Hadn't thought about that! Thank you for the remark, will definitely keep it in mind.
nikolatt··on Show HN: MonkeyMind – A shortcut-driven to-do list for your Mac's menu bar
Cool, thank you both for the information!
nikolatt··on Show HN: MonkeyMind – A shortcut-driven to-do list for your Mac's menu bar
Looks great, thank you for sharing!

A question I have about macOS development - where should I start in order to learn how to make menu bar and shortcut driven UIs?

nikolatt··on Gut bacteria may change the way many drugs work in the body
If it's not too much, could you share what's currently working for you?
nikolatt··on Ask HN: Has anyone undergone stem cell treatment for auto-immune disease?
Could you please elaborate more on this hypnosis?
nikolatt··on Ask HN: Has anyone undergone stem cell treatment for auto-immune disease?
I have AS as well! Sadly, I have not even researched stem cell treatment so I cannot help with your question. But if I may ask one of my own - what diet have you followed that has helped you with your symptoms. Also, are you taking biological drugs like Humira or Enbrel?
nikolatt··on What Is The Morning Writing Effect?
There was this notion that at night the brain is more tired, meaning it cannot both focus on the code and daydream (or similar). From personal experience, this is at least partially true.