Hacker News Reader

guillem_lefaiton Best-selling Zigbee temperature sensors tested and compared

What happen to the batteries when inside the freezer ? Sensors seems to be fine at -20°C, but is it the case for standard AAA or CRC32 batteries ?

guillem_lefaiton Fast16: High-precision software sabotage 5 years before Stuxnet

Even funnier as one of the co-author (Juan) and one of contributor (Costin) are both in the "3-buddy problem" podcast.

Obviously IOCs are presented.

guillem_lefaiton Show HN: Data Engineering Book – An open source, community-driven guide

The figures in the different chapters are in english (it's not the case for the image in README_en.md).

guillem_lefaiton Show HN: Real-time system that tracks how news spreads across 200k websites

same

guillem_lefaiton Fire destroys S. Korean government's cloud storage system, no backups available

I was there few months ago and I found them to be quite good too, both in coverage (shops, bus/metro networks) and accuracy. Obviously, not the apps I'm used to so & the language but otherwise, it was okay.

guillem_lefaiton Our European search index goes live

It's possible indeed as I'm doing it for another reason (monitoring sovereigty).

You can ask Icann [0] access to gTld domain list files (if you have a legitimate reason to do so). Once access you are granted access to a gTld, you can download a compressed csv file with a line per couple <domain, nameserver>.

[0] https://czds.icann.org/home

guillem_lefaiton Make Your Own Backup System – Part 1: Strategy Before Scripts

Thanks for the reference, it makes sense.

guillem_lefaiton Make Your Own Backup System – Part 1: Strategy Before Scripts

And then, after a year what do you do with the oldest hard drive ? Does it enter the cycle again, do you destruct it or do you use it in a failsafe environnement ? The procedure looks OK and I would like to make it more organised myself, just trying to find the right balance.

guillem_lefaiton Make Your Own Backup System – Part 1: Strategy Before Scripts

Could you elaborate on your strategy to rotate your disks ?

guillem_lefaiton Supply Chain Attacks on Linux Distributions – Fedora Pagure

NoLimitSecu, French cybersecurity podcast, released an episode yesterday with the authors: https://www.nolimitsecu.fr/compromission-de-distributions-li...

It was amazing to hear that they chose the weakest path, argument injection and were able to found a vector in two weeks twice (fedora + opensuse).

guillem_lefaiton Geothermal power is a climate moon shot beneath our feet

I live in Martinique, in the Caribbean and there is a somewhat inactive [0] volcano. To generate electricity, we are importing oil/biogaz from Europe. Solar is ramping up but it makes sense to use volcano heat if: - the associated risks are low (earthquakes, just got a 4.8 30 minutes ago [1]) - tropical climate does not make maintenance too costly

Even if it's not the cheapest option, if it can provide some backup, that could be an option. Because solar panel and hurricanes are not best friends.

[0] that kills 30k people in 1902 : https://en.wikipedia.org/wiki/1902_eruption_of_Mount_Pel%C3%... [1] https://www.emsc-csem.org/Earthquake_information/earthquake....

guillem_lefaiton Geothermal power is a climate moon shot beneath our feet

And often those places are islands, meaning their grid are isolated.

guillem_lefaiton EU regulations to look out for in 2025

The 28th regime will provide interesting insights on whether or not EU members are willing to move on fiscal harmonization.

I live in Martinique, a French outermost region and although we are in the Caribbean, we are also in the EU. This creates some friction as the standard CE norm is usually not available in neighbouring countries, therefore : 1. goods mostly come from EU (specifically France) 2. because goods have to travel across the ocean, prices are higher 3. because prices are higher, specific tax laws are maintained and new ones are introduced with the aim to make prices lower 4. specific tax law introduces another barrier and limit competition 5. because competition is low, prices are high(er)

Harmonization vs the use of specific tax law/rules is a never ending discussion in Martinique.

In the US mad king context, I'm looking forward to it.

guillem_lefaiton Ask HN: Who wants to be hired? (January 2025)

  Location: Martinique (UTC-4) / France
  Remote: yes
  Willing to relocate: open to discussion
  Technologies: Python, Spark, SQL, Javascript, APIs
  Résumé/CV: https://guillem.lefait.fr/cv-glefait-en.pdf
  Email: guillem@hey.com

Data dev/manager with strong interests in cybersec, willing to find a position in a team working to stop the bad guys with the right data.

guillem_lefaiton Putting DuckDB in Postgres to Query Iceberg

Well done !

In the github page https://github.com/paradedb/paradedb/tree/dev/pg_lakehouse, DataFusion still appear and probably should be replaced by DuckDB.

guillem_lefaiton Why do recipe writers lie about how long it takes to caramelize onions? (2012)

My sister was a chef. I cook okay but the very difference with her is 1. the skills, 2. the tools and 3. the ability to do things in parallel. All that means she's a lot faster than me.

1. To chop an onion or a shallot real fast, you need to do it a lot. In restaurant, you can probably chop 100x what you can do at home. Grated carrot with julienne knive ? It seems absurd to me at the time, but in the end that's a training.

2. To not lose time, you need the proper tools (and know how to use them). Sharped knive, flour stifler, ... . For example, my knives are not sharpened often enough, which means I cannot chop vegetables that well.

3. Cooking several things in parrallel will go wrong if you do not know what to look at before things get burned. If you are too "prudent", you will lower the fires and degrade your scalability.

guillem_lefaiton Ask HN: Why did medium.com "fail"?

Thanks for the link, found the post very interesting.

guillem_lefaiton If you like startups you should love anti-trust

It looks similar to politics. A new candidate have to bring something on the table: new ideas, new faces, new horizon whereas if an in-place politician is interested in being re-elected, he probably wants to show how great he was and keep its base happy enough to have high retention.

Maybe you seek rent when you have non negligible costs to maintain past (think maintenance and tech debt)

guillem_lefaiton “I’m selling data of 400M Twitter users that was scraped via a vulnerability”

There is lobbying indeed, the leverage being the call-center jobs.

In France for example, this activity was under scrutiny for decades (2014: https://www.lemonde.fr/vie-quotidienne/article/2014/02/12/de..., 2022: https://www.francetvinfo.fr/internet/telephonie/demarchage-t...), and even if the law is now more restrictive than before : - no week-end call - calls from 10am to 1pm and 2pm to 8pm - you can be included in bloctel, a "do not call me list" it still leave room for this activity.

Almost all these jobs will probably be replaced by AI in a near future, so the main leverage will disappear and ...

guillem_lefaiton Show HN: Automated Insights from Your Google Analytics

More actionability, always nice for analytics.

Suggestion: maybe make FAQ entries easily shareable. I wanted to link to one specific item, but I was not able to do it.

guillem_lefaiton Global Risk of Deadly Heat

I found several interesting ideas in the book:

- coloring the sea to increase albedo

- pumping the water below ice layer to reduce the ice melt speed

- the incentives to reward carbon capture

Some actions (terrorism) introduce society changes:

- drone attacks on plane/ship using fuel to limit carbon transportation

- announcements of the contamination of animals with Creutzfeldt-Jakob disease to reduce the meat consumption

guillem_lefaiton Ask HN: What bits of fundamental knowledge are productivity multipliers?

Learning and not forgetting. Or learning more than you're forgetting.

guillem_lefaiton Finding a Creature in Ethereum's Dark Forest

The address in question: https://etherscan.io/address/0x9997D91A31AA0Ed1F619e025b65E9...

guillem_lefaiton Is Web3 anything?

In that case, you could enforce that some of the paid amount is locked and release over time so as to provide an incentive to build something not totally fucked up.

guillem_lefaiton Hire me and pay what you want, just give me interesting work

This is an interesting experiment and I suspect this could be a very nice way to find co-founders or first employees. Good luck

guillem_lefaiton Nobody is joining Google's FLoC

Once you're dead, GDPR does not apply to you/your data anymore.

guillem_lefaiton St Vincent volcano: Only those vaccinated for Covid-19 can evacuate – PM

#fake https://twitter.com/DJimeshaPrince/status/138124725900273254...

guillem_lefaiton Show HN: Garlic a onion metadata search engine

It looks like the search are exact. Is there a way to send either pattern (to be used with regex) or substring (to be use with contains) ?

guillem_lefaiton What Do You Agree to When You Accept All Cookies

The IAB vendor list is a json: https://vendorlist.consensu.org/v2/vendor-list.json Easy to parse and analyse.

guillem_lefaiton Ask HN: Who wants to be hired? (January 2021)

  Location: France (Martinique) [AST/UTC-4]
  Remote: yes
  Willing to relocate: no except part-time in Miami
  Technologies: Python, Spark, Optimisation, SQL/No-sql, viz (vega), JS tracking, Bot detection
  Résumé/CV: https://guillem.lefait.fr/resume
  Email: guillem@hey.com
  Experienced data lead working in analytics/adtech, full remote the last 4 years. Besides data, I'm interested in PoCs, privacy, security (https://guillem.lefait.fr/security-log) and entrepreneurship.