Hacker News: csnweb

New comment by csnweb in "French government agency confirms breach as hacker offers to sell data"

csnweb — Thu, 23 Apr 2026 18:13:03 +0000

We do very much have credit rating in Germany, might be very different than the one in the US, don’t know theirs.

New comment by csnweb in "GPT-5.4"

csnweb — Thu, 05 Mar 2026 18:40:54 +0000

Are you may be comparing the pro model to the non pro model with thinking? Granted it’s a bit confusing but the pro model is 10 times more expensive and probably much larger as well.

New comment by csnweb in "Uv is the best thing to happen to the Python ecosystem in a decade"

csnweb — Thu, 30 Oct 2025 08:36:15 +0000

You can activate the uv venv from anywhere just fine, just do source path_to_sandbox/.venv/bin/activate. Probably makes sense to define a shortcut for that like activate sandbox. Your conda env is also linked to a directory, it’s just a hidden one, you can also create the uv obe somewhere hidden. But I get it to some extent conda has this large prefilled envs with a lot of stuff in it already that work together. Still if you then end up needing anything else you wait ages for the install. I find conda so unbearable by now that I voluntarily switch every conda thing I have left over to uv the second I need to touch the conda env.

New comment by csnweb in "Valetudo: Cloud replacement for vacuum robots enabling local-only operation"

csnweb — Sat, 25 Oct 2025 11:14:41 +0000

Because the gp comment is not about grapheneos, but its creator and could be taken as insulting (considering none of them is likely to be actually schizophrene).

New comment by csnweb in "Willow quantum chip demonstrates verifiable quantum advantage on hardware"

csnweb — Thu, 23 Oct 2025 07:12:27 +0000

That might take a few days or weeks, it seems like they put in some decent effort into it this time. From skimming the supplement I wouldn’t be suprised if the speedup is only 100x though. That’s still significant, but clearly less than they claim. For example I am not entirely convinced that 20% flops efficiency is really the upper limit or that the slicing overhead of 5x is really needed here.

New comment by csnweb in "How we decreased GitLab repo backup times from 48 hours to 41 minutes"

csnweb — Fri, 06 Jun 2025 23:54:57 +0000

But if you happen to have n=2^c, then an algorithm with logarithmic complexity only needs c time. Thats why this is usually referred to as exponential speedup in complexity theory, just like from O(2^n) to O(n). More concretely if the first algorithm needs 1024 seconds, the second one will need only 10 seconds in both cases, so I think it makes sense.

New comment by csnweb in "How we decreased GitLab repo backup times from 48 hours to 41 minutes"

csnweb — Fri, 06 Jun 2025 19:10:17 +0000

If you replace an n^2 algorithm with a log(n) lookup you get an exponential speed up. Although a hashmap lookup is usually O(1), which is even faster.

New comment by csnweb in "How to Run DeepSeek R1 671B Locally on a $2000 EPYC Server"

csnweb — Sat, 01 Feb 2025 14:11:18 +0000

The knowledge is stored in the model, the one mentioned here is rather large, the full version needs over 700GB of disk space. Most people use compressed versions, but even those will often be 10-30GB in size.

New comment by csnweb in "Common DB schema change mistakes in Postgres"

csnweb — Mon, 29 Apr 2024 11:41:29 +0000

I think you probably don’t want the application user to inherit from the superuser you may use for migrations since some migrations require a superuser.

New comment by csnweb in "Claude 3 surpasses GPT-4 on Chatbot Arena for the first time"

csnweb — Wed, 27 Mar 2024 19:05:46 +0000

It won’t answer questions that are not somehow related to code or computing, I usually don’t need anything else so I didn’t really test the limits of that so far.

New comment by csnweb in "Claude 3 surpasses GPT-4 on Chatbot Arena for the first time"

csnweb — Wed, 27 Mar 2024 18:08:21 +0000

The chat part (mostly) uses GPT-4, you can also see which model is called in the request logs. Here is the official announcement: https://github.blog/changelog/2023-11-30-github-copilot-nove...

New comment by csnweb in "MM1: Methods, Analysis and Insights from Multimodal LLM Pre-training"

csnweb — Sat, 16 Mar 2024 17:09:54 +0000

For me it really is extremely close to 100% for timers, I barely remember it being wrong and I use it several times per day. Finding my phone via the HomePod also works pretty much every time, may be 90% for me but it doesn’t recognize my wife so for her it basically never works. The others I don’t use enough. But timers and reminders work really well for me and it’s also what I need to most from an assistant.

New comment by csnweb in "We built our customer data warehouse all on Postgres"

csnweb — Fri, 02 Feb 2024 07:42:04 +0000

There are tools for Postgres unit testing https://wiki.postgresql.org/wiki/Test_Frameworks. Which is not to say there isn’t any room for improving them.

New comment by csnweb in "Valetudo – Cloud replacement for vacuum robots enabling local-only operation"

csnweb — Thu, 28 Dec 2023 19:43:25 +0000

It’s extremely hard to root, I think that’s why it got removed from the supported robot page. As for ios, just saving the page on the Home Screen really works fine, no need for a native app here imho.

New comment by csnweb in "Matter, set to fix smart home standards in 2023, stumbled in the real market"

csnweb — Mon, 25 Dec 2023 18:58:13 +0000

Same here, I also don’t understand why the home app is rather lacking. The light switches in the control center are okay, but that quickly becomes too full. I mostly use voice commands to manage my lights and third party apps like the one from Eve for other accessories.

New comment by csnweb in "In Digital Ocean, S3-like space keys can access all your buckets"

csnweb — Sun, 01 Oct 2023 13:06:57 +0000

I agree, probably the biggest point Digitalocean is lacking. I think the only workaround is creating several projects? But that probably becomes annoying and hard to manage quite easily if you want a lot of separation.

New comment by csnweb in "Digital Markets Act: Commission designates six gatekeepers"

csnweb — Wed, 06 Sep 2023 23:59:06 +0000

Many of my friends in Germany have Telegram as well and I think that it’s mainly because it has by far the best multi device (esp. Desktop / Notebook) UX. Switching devices with Telegram and using it on several devices concurrently has always been super easy.

New comment by csnweb in "Data centres account for between 1.5% and 2% of global electricity consumption"

csnweb — Sun, 20 Aug 2023 18:51:01 +0000

Hetzner (German data center provider) claims to achieve a PUE of 1.1 (https://www.golem.de/news/besuch-im-rechenzentrum-so-betreib...), admittedly their cloud offerings are quite limited but I think they are expanding on that front. So it doesn’t seem like only hyper scalers would fall into that limit.

New comment by csnweb in "The Viterbi Algorithm at 50 (2017)"

csnweb — Mon, 15 May 2023 06:30:18 +0000

The short answer is very likely no, at least not without any other major breakthroughs. The reason why Viterbi is fast is because the underlying probabilistic model is rather simple, which does not hold for quantum situations in general.

New comment by csnweb in "Type constraints in 65 lines of SQL"

csnweb — Fri, 17 Feb 2023 18:57:00 +0000

While that might not fit your needs I map unions to Postgres with an enum encoding the type and then adding constraints on which additional columns must be set (and also must not be set) depending on the type. For your example the enum might be leaf or tree and then if it’s of type tree you have non nullable left_child and right_child columns and if it’s a leaf those must be null, and then you might have a value column that is non null in both cases or only for leaves.