Hacker News Reader

pzduniakon SQLite is all you need for durable workflows

I can vouch for them too, being a super early adopter. One of the best early bets I've ever made. Awesome OSS product, glad the team decided to leave Uber to commercialize it.

pzduniakon Proton Meet

>The FTC went after Zoom in 2020. The complaint alleged that since at least 2016, Zoom misled users by claiming “end-to-end, 256-bit encryption” when it actually provided a lower level of security, and Zoom saved the cryptographic keys that would allow it to access the content of customers’ meetings.

May 7th 2020: https://www.zoom.com/en/blog/zoom-acquires-keybase-and-annou...

May 22nd 2020: https://github.com/zoom/zoom-e2e-whitepaper

E2EE seems to be available to free accounts https://support.zoom.com/hc/en/article?id=zm_kb&sysparm_arti...

(opinions are my own etc.)

pzduniakon Canada slashes 100% tariffs on Chinese EVs to 6%

BYD quite literally matched their prices here with the Seal and both brands offer equally stupidly good deals vs the current interest rate here in Poland.

They just can't compete with luxury brands that don't sympathize with fascism. People just don't want to advocate for their own demise.

pzduniakon FOKS: Federated Open Key Service

I used to use Keybase Git repos for file-based secrets management for my toy DevOps project. Either FOKS Git repos or native support in SOPS would be pretty damn cool!

pzduniakon Just make it scale: An Aurora DSQL story

Who would use Preview products in production? I'm building out some software that would fit perfectly into the constraints set for DSQL, but I realistically can't commit to something with no pricing / guarantees.

pzduniakon Synadia Response to CNCF

How are folks interpreting "include (advanced features) in the NATS server while exploring a BSL license model for future versions" given the statement that "We never considered blanket relicensing of the codebase"? It sounds like grasping at semantics to paint themselves in more positive light. I still very much read this as a server code relicense of a project that they transferred to CNCF.

pzduniakon Tesla sales plummet in the UK, France, and Germany

Boiling this argument into "being cool or not" is disingenuous when we're talking about a person directly threatening your current way of life. Just two cents coming from a citizen of a European country where he's attempting to meddle with the politics. Probably getting a Korean car next, despite them being objectively worse and more expensive for my needs.

pzduniakon We're accelerating the Android XR platform with a new agreement with HTC

And racing sims. Saves me money when I don't have to warm up as much before going to track days.

pzduniakon Olympians turn to OnlyFans to fund dreams due to 'broken' finance system (2024)

Or, hear me out, it's purely a cultural thing. Some communities are into hockey, wrestling, soccer, football etc. You could say the same thing about ski jumping, yet it's extremely popular in a few EU countries and pretty well funded. AFAIU barely anyone gave a shit about gymnastics in the US before Biles - if we have pipelines for young athletes to succeed, their sports can absolutely become regionally popular, sufficiently for them to be self sustainable through direct sponsorships.

pzduniakon LA wildfires force thousands to evacuate, NASA JPL closed

>Should some of the Police budget be cut and redirected?

I'm as far from this situation as you can be, but yes, absolutely, it's ridiculous how much money is set on fire on ineffective budget items, while at the same time AFAIU the police force is not really held responsible to do its job.

pzduniakon OpenERV

https://www.komfovent.com/en/products/domekt-r-400-f-c6m-573

I think this is the one I'm using for ~200-ish sqm.

pzduniakon OpenERV

I'll definitely prepare a longer write-up when I have everything figure out, but here's a summary:

I have 4 systems:

- Komfovent HRV for ventilation

- NIBE F-series heat pump for floor and water heating

- Vaillant gas boiler that "supports" the heat pump

- Samsung multi-split AC units

HRV - Komfovent uses the same controllers in all of their units, so you get all the communication goodies you'd want - though it took me a long while to figure out that basic features need to be toggled on :) There are existing YAML presets for their C6/C6M controllers on HA forums. The only caveat is that if you want to feed it a virtual thermostat, you need a stuff a device simulating a 10k NTC inside of the ventilator. Otherwise it's just a single Ethernet cable.

Heat pump - I'm not exactly sure if I'm happy with NIBE, but thanks to the community the integration ended up being quite easy. I wasted a bunch of money on their MODBUS40 just to learn that you need to use a certain MODBUS address in the internal bus to make certain registries writeable (eg. thermostat values) - so I took an ESP32 with Ethernet, a galvanically isolated RS485 dongle, a 12V to 5V converter and used https://github.com/elupus/esphome-nibe. The firmware extracts my templated HA sensor's value and feeds it to the heat pump as a virtual thermostat.

Vaillant uses this weird "eBUS" protocol, there's a bunch of cheap PCBs that you can use to connect to it - I'm using https://github.com/danielkucera/esp-arduino-ebus. That's the last system that I haven't touched :)

Samsung ACs use their MIM-B19N modules installed in the outdoor units. There's some magic around enabling remote control, but once you plug their diagnostics device into their indoor units, you can flash all of them at once. I had to mess around with internal NASA addresses to have all the units appear at once.

For indoor sensors I have 3 types:

- AirGradient units measure CO2, tempeature, humidity, PMx etc. - these are mounted at ~150cm and feed the "current house temperature" template.

- I have like 8 Everything Presence One devices, powered by a custom PCB that converts 12V/24V sent over wired alarm cables to the device. They have built-in temperature, humidity and motion sensors. These are mostly installed for motion sensing and their height makes the temperature measurements quite useless.

- Everything else (and most importantly bathrooms) is done using custom ESP32-C3 devices that use SHT31 sensors to measure humidity and LD2412 for movement sensing. Also using the same adapter PCB for powering.

Thermostats are synchronized across all the devices with HA scripts. The HRV specifically uses its own wired temperature sensor to determine if it should enable heat recovery ("free cooling mode"), since its extracted air temp is always a bit lower than room temp (laziness :-)). "Current temperature" template fed to other heaters is derived from multiple room temperatures (currently using an average), with rooms "ignored" if AC is heating there (or was turned on recently). Ventilation has 2 modes set up - 20% and 80% - with the latter toggled by a bathroom humidity threshold.

There are 3 remaining things I want to set up:

- auto switching to gas heating if it's cheaper / the house is running on batteries - so far I've only imported electricity / gas prices into HA and quickly realized that I'm missing a power monitor on the heat pump circuit

- dampening of air ducts to reduce the temp drop when high humidity extraction boost gets triggered

- using more of the HRV range by auto-adjusting fan speed depending on real CO2 values - there's max 2 ppl at the house most of the time, so even at 20% the HRV is quite wasteful

pzduniakon OpenERV

If you're OK with large controllers, the cheap Chinese RS485 stuff seems to work perfectly fine. For "digital inputs" I started out with Polish $150 devices, eventually ended up using the cheapest AliExpress listings for some expansions and so far they've been working exactly the same, with the only difference being the quality of the docs. I'd expect the 0-10V modules to be exactly the same.

pzduniakon OpenERV

Check out Komfovent units if you want a ready solution. My setup is Komfovent HRV (over MODBUS TCP), NIBE heatpump (over MODBUS UDP + esphome-nibe), Vaillant gas boiler (over eBUS-WiFi) + a bunch of AirGradients scattered around the house. Nothing has access to the internet, everything is glued together with HA. Works surprisingly well :)

pzduniakon OpenERV

>that they are very expensive niche products

My entire "medium sized European suburban house" runs on a $2.5k 400m3/h unit with HEPA filters made in Lithuania - and that was the more expensive model that I can directly control over MODBUS / 0-10V signal (even turning it into a "dumb" unit). Most of the expenses were running the ducts. YMMV

It's just awesome. Every single room has fresh-smelling air and after fine tuning all my heating systems with algos implemented in Home Assistant - I'm getting ~60-100ppm over outdoor CO2, perfectly clean air, temperature within 1C of the set value, on-demand humidity extraction after showers etc. All it needs to be properly overengineered now is a bunch of dampers and per-room CO2/humidity feedback :)

pzduniakon Show HN: Open-source private home security camera system (end-to-end encryption)

Right? All of this seems like trying to solve the wrong issue. Solve VPN routing with a routing solution, solve stream collection and processing with something like Frigate. I run ML models locally on a GPU and get a notification through MQTT/HA/Tailscale to my phone when the local stray cat arrives for dinner. What else do you really need?

I don't buy the cheap storage argument, trading an upfront cost of maybe $100 for all that complexity. And you can still keep archives - and even a reasonable UI - with some off the shelf FUSE driver. Or, less janky, a cron script running rclone or whatever.

Cool project, I just don't see people migrating to it.

pzduniakon Charset="WTF-8"

Sorry, I was thirsty.

There were no "big" rivers, ever. More like springs. We have lots of subterranean water, so out of the 18 rivers we have in the city, 16 have their sources here [0]. They were used to power mills in the 19-20th century during the industrialization. Many of the rivers that used to go through the city center flow underground.

I live close to the river Olechówka [1], which flows into a regulated reservoir that used to feed a mill - so the area is called Młynek, "Little Mill" :)

[0] https://podwodnalodz.blogspot.com/2013/09/o-wodzie-po-ktorej... [1] https://i.imgur.com/SIp8CxN.jpeg

pzduniakon Charset="WTF-8"

Yep, postal code does all the work.

pzduniakon Charset="WTF-8"

I live in Łódź.

Love receiving packages addressed to ??d? :)

pzduniakon From BSP to ESP – How S3ctor Abused Quake Editors to Redefine the Morrowind Mod

Eh, you're overestimating OP's statement. I think they're roughly my age and at eight I was busy figuring out Win32 APIs and DLL imports in Object Pascal to make _rad utility programs_. I probably would've immediately gone into game modding if not for the fact that I was using a late 90s Dell notebook that had like 8MB of VRAM :) Two years later I had a bunch of game servers running entire custom gamemodes implemented in LUA with other kids _loving it_.

pzduniakon Warsaw came close to never being rebuilt (2015)

What you're pointing at is mostly irrelevant - the massive coal / lignite plants are obviously filtering the exhaust through filters according to EU levels. A family member works in the field.

The actual air pollution issue stems from small heaters used in houses that haven't been upgraded yet (or people using them improperly / burning trash) - but there's plenty of EU funding going towards replacing them. Many of the remaining users are unfortunately living in poverty and can't even afford the remaining 20-30% of the price + heating afterwards can absolutely become more expensive.

pzduniakon Monitoring energy usage with smart plugs, Prometheus and Grafana

Eh, that's even more expensive. I think I'll end up having to develop my own hardware, even with Vue blowing $1500 for energy monitoring is a bit too much given how cheap the hardware can be.

pzduniakon Monitoring energy usage with smart plugs, Prometheus and Grafana

Is anyone aware of any other OSHW alternatives to this? Preferably with Ethernet. ESPHome would be preferable.

The clones I can find are roughly the same price as the "original" hardware.

ATM90E32AS seems to be ~$1 per channel on JLCPCB, so I'd imagine this could be pretty cheap with SMT assembly. My use case is like ~60 circuits.

pzduniakon ESPHome

I built mine using a Hydreon Rain Gauge sensor (RG11 in my case) and combined it with an off the shelf wind sensor from AliExpress, presumably sold by Adafruit's supplier, which closes a reed switch every rotation. Everything is powered through PoE, controlled by wESP32. I spent a couple hundred bucks at most including all the mounting hardware.

It all controls an aluminum "awning" in my house that's supposed to open above certain wind speed, close when it rains.

pzduniakon Bitcoin rally pushes BlackRock ETF over $10B in record time

This is good for Bitcoin because number go up!

pzduniakon European crash tester says carmakers must bring back physical controls

Oops, accidentally cut off the last few words.

Coincidentally it's back to working in the first case I described. Adding stops is still broken:/

pzduniakon European crash tester says carmakers must bring back physical controls

>Google's baffling regression in handling voice input for common tasks while driving

Is it just me or is Google Maps voice input in AA completely busted now? I used to be able to press the "Search" bar on the touch screen in the app, say the search term and it would just show the results. Likewise for adding stops along the way. Now for the former I need to explicitly say "navigate to X" (or it says that it doesn't have a screen and refuses to do anything???) and for the latter I have to say something like "add a navigation stop at X", the assistant lists our the result (??????) and asks me which one I want to choose. Of course I don't see anything on the map in either case.

I can't imagine how bad it is when you

pzduniakon What it was like working for Gitlab

I'm pretty sure someone making 2-4x their local salary for a remote company and paying taxes is healthier for the economy than working your ass off (or not) for a local startup that wants to end up getting acquired OR doing the same remote work with 2-3 layers of management extracting the difference in pay. At least in Poland I can't think of any single company I'd want to work for.

pzduniakon A Canadian payroll dependency chart

In Poland there are some complexities when you run a company / employ, but as an employee it's relatively straightforward UX where you click through a government-operated "income tax fillings wizard" and either just OK a pre-filled declaration or add a couple missing items. Paper filling is a bit more complicated, but I think you can get help at the tax office to get 1 or 2 forms sorted out.

For self-employment I send 2 documents per month regarding my expenses (which is somewhat easy if you understand the rules), plus one or two summaries per year. Hiring is a bit more complicated, I only file simplified declarations for employing private people as contractors. Otherwise I'm pretty much a worst case scenario as I file 7 different yearly declarations covering most possible sources of income defined in the law. It's not that bad, but it could be better.

Running a company can be practically automated with an online accounting SaaS, including payroll. Laws tend to be relatively understandable and there isn't much complicated math. Most of the recent confusion was around shitty laws poorly implemented and then partially reverted by our previous government. I did not enjoy that, but there were some decent online writeups explaining how to proceed.

pzduniakon Australia to ban engineered stone

In my experience in Poland you leave the stuff that has to fit in the countertop at the stonemason's workshop and they measure/test fit everything there. My guy has a bunch of (perhaps?) old machines that all do the cuts flooded with something that resembles diamond tooling or grinding wheels.