HNHacker News
TopNewBestAskShowJobs

alright2565

1,700 karma · joined January 9, 2021

submissionscomments
alright2565··on Ford Mustang Mach-E using BlueCruise at time of crash: NTSB
(but maybe don't try and deploy them when you're stopped in the middle of a 5-lane highway with your lights off)
alright2565··on Using ClickHouse to scale an events engine
the only additional requirement that the AGPL introduces is that if you modify the AGPL software, you have to provide people who can access it over the network the code.

If you just use a pre-built package, the AGPL has the exact same requirements as the GPL.

alright2565··on Using ClickHouse to scale an events engine
It's not actually so esoteric. The two main knobs are

- max_concurrent_queries, since each query uses a certain amount of memory

- max_memory_usage, which is the max per-query memory usage

Here's my full config for running clickhouse on a 2GiB server without OOMs. Some stuff in here is likely irrelevant, but it's a starting point.

    diff --git a/clickhouse-config.xml b/clickhouse-config.xml
    index f8213b65..7d7459cb 100644
    --- a/clickhouse-config.xml
    +++ b/clickhouse-config.xml
    @@ -197,7 +197,7 @@
     
         <!-- <listen_backlog>4096</listen_backlog> -->
     
    -    <max_connections>4096</max_connections>
    +    <max_connections>2000</max_connections>
     
         <!-- For 'Connection: keep-alive' in HTTP 1.1 -->
         <keep_alive_timeout>3</keep_alive_timeout>
    @@ -270,7 +270,7 @@
         -->
     
         <!-- Maximum number of concurrent queries. -->
    -    <max_concurrent_queries>100</max_concurrent_queries>
    +    <max_concurrent_queries>4</max_concurrent_queries>
     
         <!-- Maximum memory usage (resident set size) for server process.
              Zero value or unset means default. Default is "max_server_memory_usage_to_ram_ratio" of available physical RAM.
    @@ -335,7 +335,7 @@
              In bytes. Cache is single for server. Memory is allocated only on demand.
              You should not lower this value.
           -->
    -    <mark_cache_size>5368709120</mark_cache_size>
    +    <mark_cache_size>805306368</mark_cache_size>
     
     
         <!-- If you enable the `min_bytes_to_use_mmap_io` setting,
    @@ -981,11 +980,11 @@
         </distributed_ddl>
     
         <!-- Settings to fine tune MergeTree tables. See documentation in source code, in MergeTreeSettings.h -->
    -    <!--
         <merge_tree>
    -        <max_suspicious_broken_parts>5</max_suspicious_broken_parts>
    +        <merge_max_block_size>2048</merge_max_block_size>
    +        <max_bytes_to_merge_at_max_space_in_pool>1073741824</max_bytes_to_merge_at_max_space_in_pool>
    +        <number_of_free_entries_in_pool_to_lower_max_size_of_merge>0</number_of_free_entries_in_pool_to_lower_max_size_of_merge>
         </merge_tree>
    -    -->
     
         <!-- Protection from accidental DROP.
              If size of a MergeTree table is greater than max_table_size_to_drop (in bytes) than table could not be dropped with any DROP query.
    diff --git a/clickhouse-users.xml b/clickhouse-users.xml
    index f1856207..bbd4ced6 100644
    --- a/clickhouse-users.xml
    +++ b/clickhouse-users.xml
    @@ -7,7 +7,12 @@
             <!-- Default settings. -->
             <default>
                 <!-- Maximum memory usage for processing single query, in bytes. -->
    -            <max_memory_usage>10000000000</max_memory_usage>
    +            <max_memory_usage>536870912</max_memory_usage>
    +
    +            <queue_max_wait_ms>1000</queue_max_wait_ms>
    +            <max_execution_time>30</max_execution_time>
    +            <background_pool_size>4</background_pool_size>
    +
     
                 <!-- How to choose between replicas during distributed query processing.
                      random - choose random replica from set of replicas with minimum number of errors
alright2565··on Receive push notifications from your rice cooker
sure, just write a homeassistant integration. you have only 4 cases to handle:

- toaster oven on

- rice cooker on

- both on

- both off

I would be extremely surprised if the sense was able to detect a rice cooker accurately.

alright2565··on The fall of the iconic chain 99 Cents Only
> Company executives and industry analysts blamed a series of factors, including the COVID-19 pandemic, escalating theft and crime, competition, big increases in operating costs stemming from high inflation and the expense of servicing its debt … significant minimum-wage jumps.

But you keep reading just a little bit, and you find out this company is a victim of a leveraged buyout:

> The family management team … departing in 2013 The deal — which valued 99 Cents Only Stores at $1.6 billion — saddled the company with a debt load that turned a “conservative balance sheet” into a “highly leveraged capital structure,”

This is absolutely shameless. The owners put the company on incredibly shaky footing, then when a bump in the road comes up, they use it to do politics and refuse to take responsibility?

alright2565··on Home insurers are dropping customers based on aerial images
After you go to the hospital for an injury, your health insurance company will send you a letter asking where the injury occurred so they can try and get someone else to pay for the treatment.

This process is called subrogation and it is out of the control of the injured person.

alright2565··on Receive push notifications from your rice cooker
The Sense is way too expensive for the very limited capabilities it has. You get to pay extra for the machine-learning to mis-interpret your appliances!

The Emporia Vue is half the price and has a clamp for each circuit.

In this case though, the wall plug monitoring is definitely the right solution.

alright2565··on Documentation for the AMD 7900XTX
Once your computer is booted up, the your code doesn't interact with the IME in the general course of doing its work.
alright2565··on Backdoor in upstream xz/liblzma leading to SSH server compromise
https://github.com/tukaani-project/tukaani-project.github.io...

> Note: GitHub automatically includes two archives Source code (zip) and Source code (tar.gz) in the releases. These archives cannot be disabled and should be ignored.

The author was thinking ahead! Latest commit hash for this repo: 8a3b5f28d00ebc2c1619c87a8c8975718f12e271

alright2565··on I scraped all of OpenAI's Community Forum
I saw this part:

> Every Discourse Discussion returns data in JSON if you append .json to the URL.

then this:

> Raw data was gathered into a single JSONL file by automating a browser using Playwright.

Kinda seems to me like having a whole browser instance for this isn't necessary? I would have been surprised if this .json pattern didn't continue for all pages, and it turns out that it does in fact also work for the topic list: https://community.openai.com/latest.json

The other place I've seen this sort of API pattern is reddit. For example, https://www.reddit.com/r/all.json or (randomly chosen) https://www.reddit.com/r/mildlyinfuriating/comments/1bqn3c0/...

alright2565··on The man who bought Pine Bluff, Arkansas (2022)
I don't know exactly what he's doing, but fusion is pretty easy to do: https://www.instructables.com/Build-A-Fusion-Reactor/
alright2565··on Why are most sofas so bad?
> you discover that much of the cheapest stuff has the same flimsy glueboard, peeling laminate, and unstable joinery of the cheap stuff at Wal-mart.

I'm not going to argue too much with this, but I think this is underselling Ikea quite a bit.

Their cheap stuff is definitely made out of cheap materials. But I've found it to be well-engineered compared to walmart with reinforcements in critical places and general overall good quality control (doesn't come pre-scratched).

Walmart-level furniture on the other hand is often designed to look a certain way, with no consideration for how loads will be placed on it or long-term durability.

alright2565··on Mass timber is great, but it will not solve the housing shortage
"drive out current inhabitants" by offering one of them an entirely voluntary and mutually beneficial deal?

Or do you mean that existing owner should be required to get their neighbors' consent to do what they want with their own property?

Anyone selling their home would, all other things being equal, prefer to sell their home to an neighbor with which they have a relationship then to a random person. The neighbors should make an offer if they really care.

alright2565··on The Purple Streetscape
I'll do even better. The failed streetlight closest to their office is at 33.7858029, -84.3887389, only two blocks or 1500ft away.
alright2565··on Bob_cassette_rewinder
I'm not familiar with mini dishwashers like Bob, but the full size ones are definitely not a "convenience addiction". You may be capable and skilled at using the two/three-sink method for washing up, but the general population isn't and will instead run the tap and waste far greater amounts of heat and water than a dishwasher would require.
alright2565··on FDA clears first over-the-counter continuous glucose monitor
Calibrating my scales and thermometers would be nice. What procedure do you use for it? is it documented online anywhere?
alright2565··on Kagi and Wolfram
Honestly, I don't care to visit those businesses. Their sort of maximize-engagement attitude is the exact opposite of what I want.

I'd much rather get information from an individual or small group who is intrinsically motivated and is not just looking for the lowest bar of quality that won't make folks immediately bounce.

I also want to note that just putting Google Analytics on there doesn't kill the site's ranking. There are some sites that are just infested, and those are what get dramatically downranked.

alright2565··on Cloudflare Announces Firewall for AI
> Firewall for AI is an advanced Web Application Firewall (WAF)

    function requestIsBad(request) {
        return [
          /Do Anything Now/i,
          /[A-Z]{4+}/,
          /10 tokens/i,
        ].some(regex => regex.test(input));
    }

it's a good time to be selling shovels!
alright2565··on Testcontainers
You can just run postgres natively: https://github.com/zonkyio/embedded-postgres-binaries + https://github.com/zonkyio/embedded-postgres

or through WASM: https://github.com/electric-sql/pglite

alright2565··on Klarna says its AI assistant does the work of 700 people
Amazon does this as well, from what I remember. Their bot is a classical decision tree, not LLM, but that doesn't matter from the customer's perspective.
alright2565··on Show HN: Reverse-Engineering a Switch Lite with 1,917 wires
That's what I was thinking, but now I'm pretty sure it doesn't even need crazy algorithms like that.

1. align the image stack. not trivial, but a common task.

2. take several cross-sections, in both dimensions, and have a human draw a line along a specific layer line

3. linearly interpolate these lines into a surface.

4. for each pixel in each output layer, set the value to layers[l + offset][x][y], where the offset was calculated in step 3.

alright2565··on Show HN: Reverse-Engineering a Switch Lite with 1,917 wires
I expected scan-and-sand to be somewhat automated, but they're doing it by hand? Incredible!

Might another way to resolve issues with the PCB dishing be to photograph the layers at a fraction of a layer height? So that in that way you have a lot more slices to work with, and you can digitally "flatten" the PCB?

alright2565··on Show HN: Reverse-Engineering a Switch Lite with 1,917 wires
Did you take a panorama of the board after desoldering all the components? I'm curious (although not likely to want to dedicate more than minimal time to) if it would be possible minimize/eliminate your innovation #2 by using computer vision.

Or are you maybe aware of other images of depopulated boards?

alright2565··on Show HN: Reverse-Engineering a Switch Lite with 1,917 wires
Looks like the answer is yes, for money. Nothing I can quickly find that is FOSS.

It doesn't seem like this problem requires anything crazy, just traditional computer vision, but of course the devil is in the details.

alright2565··on I don't think the cheapest APC Back-UPS units can be monitored except in Windows
What's interesting is that APS's Windows-only software, Powerchute Serial Shutdown, is actually Java-based, accessed through the browser, and trivially de-compilable and readable.
alright2565··on I don't think the cheapest APC Back-UPS units can be monitored except in Windows
How do you power a PC off this setup? Mine has a C14 inlet.
alright2565··on I don't think the cheapest APC Back-UPS units can be monitored except in Windows
From my own adventure in this area, the battery is very standard and IMO reasonably priced. What gets expensive is shipping it, since lead is so heavy. I remember having trouble finding local sellers for them that would have avoided the shipping cost.
alright2565··on Air Canada is responsible for chatbot's mistake: B.C. tribunal
Apologies for the off-topic reply here, but they've just fixed the ipv6 issues with gtlib by removing the AAAA records.
alright2565··on Zuck on the Apple Vision Pro
this video is highly produced, just with the goal of having a casual vibe.

1. zuck's perfect pacing and word choice

2. the friend pulling up browser windows perfectly on-cue, and zuck pointing at exactly the right place

3. second camera already set up to capture the friend

alright2565··on Zigbee and Z-Wave are the best part of my smart home
It's the opposite for me. I have so many problems with Zigbee devices dropping off the mesh for no reason and batteries dying in 1/10th the advertised time.

Meanwhile my ESPHome devices have never had any issue whatsoever.

← PreviousPage 7 of 10Next →