HNHacker News
TopNewBestAskShowJobs

nbevans

584 karma · joined August 2, 2012

submissionscomments
nbevans··on Reassessing relative temporal lobe size in anthropoids and modern humans
So what you're saying is... /it's aliens/ ... right?

(:

nbevans··on IRIS²: The EU’s Response to Musk’s Starlink
The UK was trying to negotiate a special agreement/treaty regarding Galileo. But the EU did not want to even consider it. Indeed even today the UK has not really given up on trying to be friends with the EU and continues to remain open to rejoining Galileo and Horizon programmes. Bizarrely, the latter of which, the EU seemingly had a moment of weakness during the negotiations by agreeing that the UK could remain members of Horizon - but then later had a change of heart and decided to break the agreement (international law?) in choosing to cut the UK out to this very day.
nbevans··on IRIS²: The EU’s Response to Musk’s Starlink
Operational? Yes. Reliable? No. It has had numerous outages in the last 4 years.

How do you explain several non-EU states being members of the Galileo programme - namely Switzerland and Norway? Hell, even China invested into it in 2003. And yet, the UK which invested almost a quarter of its funding is booted out on the basis of an unrelated political issue? It doesn't make sense. The British even offered to continue funding and investing into it. So "forced out" is an accurate description.

nbevans··on IRIS²: The EU’s Response to Musk’s Starlink
They still haven't finished Galileo yet; with the project seemingly going backwards ever since the British were forced out. How will they deliver yet another moonshot project like this? They don't even possess reusable rocket technology yet to make such a LEO project economically viable.
nbevans··on EU lawmakers approve effective 2035 ban on new fossil fuel cars
Quite a "u-turn" from the bloc which for two decades pushed (through regulation) dirty diesel engines as the solution.
nbevans··on OpenAI-to-SQLite
They can put it in the T&Cs saying you can't do that though. Like what most geocoding APIs do - e.g. Google says you cannot cache/store the geocoding results.
nbevans··on CTEs as lookup tables
CTEs are great for breaking down a large query into discrete steps. They're basically SQL's equivalent of a pipe function.
nbevans··on London's Ultra Low Emission Zone to cover entire city
The mayor described it as step towards "Singapore-style" road pricing and went further in setting a target goal to copy the whole Singapore set-up for road pricing. Which is an interesting U-turn from the cacophony of outrage between 2016-2019 when it was suggested that the UK should adopt a Singapore-style trade and tax policy. Bit by bit...
nbevans··on Crsql – Multi-writer and CRDT support for SQLite
That isn't necessarily "how SQL works". Sure, you might design your schema like that. But many accounting systems don't necessarily store a "balance" except perhaps as a performance optimisation. They derive the balance from the history of transactions that have occurred on an account. And a transaction is, essentially, a + or - value.

Indeed it can be argued that CRDTs are a natural fit for SQL because it is essentially a derivative of set theory

nbevans··on Crsql – Multi-writer and CRDT support for SQLite
That isn't how CRDT's work though. In the example of mutating a bank balance, there would be addition operations and subtraction operations. So /eventually/ all nodes would arrive at the same balance. It's a bit like event sourcing but lower-level.
nbevans··on Hosting SQLite databases on any static file hoster (2021)
SQLite isn't compressed. There is a commercial offering from the creators of SQLite that adds compression but its rarely seen in the wild to be honest.
nbevans··on Over 1M Teslas recalled because windows can pinch fingers
Correct but this wasn't the arms. It was the subframe that they connect to. And the rust was coming from the inside out - a so-called "perforation rust" - which isn't detectable on MOT and is usually mistaken as surface rust.
nbevans··on Over 1M Teslas recalled because windows can pinch fingers
Tesla is the only car brand where such a minor recall (that can be fixed via an OTA update) results in a news article by a major news distributor.

Meanwhile my 2007 Mercedes C-class literally rusted through its rear subframe and suspension arms were hanging off. It could have failed catastrophically at high speed. Not detected by any MOTs (yearly vehicle inspections). No recall - officially, but unofficially they repaired my vehicle for free because they recognise it's a major liability issue. Recognised as a multi-year manufacturing defect on the model.

nbevans··on Uno platform: Build single-codebase applications across all platforms
.NET
nbevans··on Uno platform: Build single-codebase applications across all platforms
Mainstream ecosystem and language.
nbevans··on Uno platform: Build single-codebase applications across all platforms
It's more comparable to Flutter than MAUI. Since all the controls are custom rendered to be "look-a-likes" rather than genuinely native. Naturally, the look-a-like approach to cross-platform apps does have some drawbacks - namely that it is always lagging behind the bleeding edge of the native platform controls. But for certain categories of app this is not a major issue.
nbevans··on Electric Vehicles Are Going to Suck; Here's Why [video]
A major improvement would be LED headlights which have a MTBF that is so high that they can essentially last for the lifetime of the vehicle. Zero "bulb" replacements. (LED headlights exist BTW, and I'm sure there are VW Golf trim levels that include them nowadays)
nbevans··on Shipping Multi-Tenant SaaS Using Postgres Row-Level Security
Using RLS to implement multi-tenancy is a terrible idea. Just deploy a database per tenant. It's not hard. Why overcomplicate it?
nbevans··on Your compliance obligations under the UK’s Online Safety Bill
Doesn't matter if they ignore the laws as then they have to pay fines which bolsters the Treasury anyway. It's win-win. That's why the EU itself loves to regulate in this way because dishing out tickets to American big-tech is a big money spinner for a superstate that is fast running out of money. The real problems start when these fines are being seen in the halls of power as disruptive to trade; as then it becomes a bilateral political issue which can of course blow up in a full blown trade spat very quickly.

Also your example of ignoring Afghan laws on women doesn't work. If you tried to setup a business in Afghanistan that was say an online tutoring programme tailored for Aghan women. How quickly do you think your DNS will get pointed to 0.0.0.0 on the Afghan internet? And how quickly will they seek to prosecute you as a director of that business? As a foreigner living abroad, you'll probably be fine but you won't be making money from your target market. So you're finished. The law worked and you didn't ignore it.

nbevans··on The bait-and-switch hidden in today’s cookie announcement
https://news.ycombinator.com/newsguidelines.html
nbevans··on The bait-and-switch hidden in today’s cookie announcement
Thank you!
nbevans··on The bait-and-switch hidden in today’s cookie announcement
Indeed this is overly editorialised and the author very much assumes the reader is of the same opinion of them from the outset. The author seems to believe that web browsers will just ignore UK legislation and not bother to implement the necessary changes.
nbevans··on Riding London’s unexpectedly fantastic Elizabeth line
It was a highly complex integration of 3 different railway signalling protocols. These are safety critical systems that need to be "proven" to be safe through extensive simulation tests and real-world testing. The Crossrail/Siemens team that worked on this integration split the project up into 4 parts. 3 parts for each signalling system. And then the final part to allow transitioning a train between each signalling system in a seamless way. They were testing the trains on the western, central and eastern parts of the line for years as a way of gaining confidence in their work. It has been reported that this is the first time anywhere in the world that a railway has been created to support multiple signalling systems and be able to transition seamlessly between them during service.
nbevans··on Riding London’s unexpectedly fantastic Elizabeth line
Indeed - the expectations were very high for Crossrail before and during development. All that has happened is they have delivered the product exactly as described, albeit 4 years later and over budget.

It should be noted that 4 years ago the BBC were running documentaries about how successful the Crossrail project had been after the tunnels were finished and most of the stations were almost done. It seems that nobody expected the software and signalling to take an additional 4 years of time. Somebody somewhere really messed up that part of the project. Everything else - the main civil engineering project - did go extremely smoothly and was even ahead of schedule at times.

nbevans··on I cheated on my Microsoft interview (2019)
Recruitment agents are always pumping failed interviewees for the questions they were asked. They then make sure their next candidates are better prepared with this knowledge.

This guy really shouldn't feel so bad. It's Microsoft's fault for not rotating the questions better. That, or they did rotate the questions, and it really was absolute pot luck.

nbevans··on The rise and fall of Cathie Wood, controversial Wall Street investor
These are nothing like the same. These are private equity funds. Cathie Wood is just a publicly traded ETF. It only trades public stocks.
nbevans··on The rise and fall of Cathie Wood, controversial Wall Street investor
I think people are very harsh on Cathie Wood. At the end of the day it is an ETF fund. She sets the % holdings and that's it. It trades by itself every millisecond of every day to maintain those allocated %s. Of course it will rise and fall with the market, as it has done. Pretty much every tech/growth focused fund has done the same thing over the last two years.

It is very telling when people start writing "career obituaries" like this just because a stock is 50-70% down. What is it that Warren once said: If you can't stand your stock pick being 50% down then you shouldn't be doing stocks?

The macroeconomics is clear. Depopulation and digitisation are the major trends that will define the coming decades. If you're -50+% down on your tech/growth picks right now. It may be 1000%+ (gains) by the time you actually want to draw-down your investment during, say, retirement.

nbevans··on Britain should scrap its online safety bill
Pensions have not been going up. The triple lock was suspended. Inflation is wrecking the pensions of millions. The UK pension system is one of the worst in Europe. If it was ever to be substantially improved you will definitely hear about it.

All countries tend to have polarisation around the topic of "immigration". Statistically the UK is one of the most welcoming and least racially prejudicing countries in the world. There are numerous independent studies and reports that you can find to support this. You do need to pay though; the visas and healthcare surcharges ain't cheap. The same as any top tier country though.

nbevans··on JSON and Virtual Columns in SQLite
+1 for lenses. A FP concept.
nbevans··on Cron-based backup for SQLite
Indeed and in my experience this has been more reliable/predictable than the official backup API. The official backup API can get "stuck" on a very large and hot database because it, essentially, has to start from scratch if a page is modified. VACUUM INTO doesn't have this problem.
← PreviousPage 2 of 21Next →