Hacker News Reader

Something1234on Tell HN: I got 10x Hetzner storage at the same price

Dedicated hosts and instances are super expensive especially compared to Hetzner.

Something1234on Consciousness is supported by near-critical slow cortical electrodynamics

Is this what the house coma guy story was based on?

Something1234on Why Musk’s biggest space gamble is freaking out his competitors

Can someone explain this to me?

Something1234on Ask HN: Any other databases on single disk file like SQLite exist?

Apache H2, and Apache Derby. There's quite a few that are available if you only need them to be supported on the JVM.

Something1234on Wordle Now Redirects to NYT

I mean maybe if we used shuf with the same seed value for everyone it would work.

Something1234on How PostgreSQL stores rows

There was another article posted today about LSM trees, and how they use segment files. I think at the end of the day the "distributed, fault tolerant, key-value storage" is using segment files too. By having your database use segment files directly you're just skipping a middleman.

Something1234on Ask HN: What do you use to power search for a static site?

I built a simple search using SQLite as part of the build process for my static site. It uses AWS lambda to actually serve up the results.

Something1234on Saving on egress switching from AWS to Hetzner

Isn't 12A kind of small for an entire rack?

Something1234on Israel Finds Fourth Covid Booster Is Ineffective

To the people asking for caution about these vaccines, how long did it take from development to roll out for the polio shot? Was there the same reluctance?

Something1234on In Japan, digicams are the new film

So many sites run wordpress cause it's easy. Wordpress doesn't cache by default unless you run on one of the major hosts like kinsta or wp engine. Wordpress needs MySQL. Can you really fault them for picking out a standard CMS instead of rolling a static site that requires someone to be slightly technical.

Something1234on Updating a 50 terabyte PostgreSQL database (2018)

count(*) is always going to be slow. They don't store the number of live tuples, just an estimate so it's a full table scan. The secret is to use indexes to get down to a small bit that you care about. If you're filtering on 3 columns, the goal is to get the index to wipe out at least half the results you don't care about and so on and so forth.

A 130M record table with no indexes is going to be crazy slow. Although if all you need are primary key updates, then that's the way to go.

Something1234on Josh Hawley introducing his own stock ban bill

> Ossoff's bill also would apply the ban to any *dependent children* in addition to the spouses of lawmakers, whereas Hawley's bill would not.

I mean this sort of makes sense. In order for an adult child to be a dependent they have to be pretty much invalid, and not responsible for their own actions.

Something1234on CalyxOS now supports Pixel 6 and Pixel 6 Pro

Don't they have the mobile data plan that they offer to people? Get a mobile hotspot and support an educational instituition.

Something1234on Poll: Which FAANG is the most likely to decline in the years ahead?

You should also check out flea markets usually I find blue rays for between 2 and 3 dollars in the case.

Something1234on Consider SQLite

Maybe an NFS mount or something that handles back ups automatically? Scripting to handle an automatic restore of the database?

Maybe a heroku that knows about your database file and automatically loads the latest version for you?

I kind of feel like GP is a troll comment, as there's no real value add for a managed SQLite.

Something1234on NASA Says Webb’s Excess Fuel Likely to Extend Its Lifetime Expectations

Wait if Hershel was the largest optical telescope in orbit, how come it didn't catch the public imagination like Hubble did?

Something1234on Coming to Agreement, a logic puzzle for Oxford admissions interviews

Take out my phone and turn on my flashlight, so they can see me. Also hug the right wall, cause that's what most people do.

Something1234on Christmas shopping the IBM way: computerized gift selection in 1962

So is the source code available?

Something1234on Ask HN: Those making $500/month on side projects in 2021 – Show and tell

How do you build a wiki as a static site?

Something1234on TSMC in Japan: Things to know about its chip factory plans

Yeah except most of them are in water scarce region. Texas and Arizona are going to be in trouble in the next 10 to 15 years WRT water supply, the mighty Colorado isn't delivering enough. The fossil aquifers are being depleted.

Something1234on Ligatures in programming fonts: hell no (2019)

Counterpoint to your counterpoint: the standard is still the best way, and ligitures are non standard.

Something1234on Webb placed on top of Ariane 5

"If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization." ~ Gerald Weinberg.

For those who don't know what the quote is. I found it here[1].

[1]: http://www.ganssle.com/articles/programmingquotations.htm

Something1234on The Internet Has a Rat Poison Problem

https://www.cdc.gov/rabies/location/usa/surveillance/human_r...

This is absolutely nuts. Also how would he know that he wasn't bitten if it brushed up against him.

Something1234on The Internet Has a Rat Poison Problem

Yeah but they too good at hunting the ones who aren't going to enter my house. They're little psychos[1], but I love my little psychos.

[1]: https://theoatmeal.com/comics/cats_actually_kill

Something1234on Packaging for instant coffee made out of seaweed

How can I be absolutely sure that my tea bags do not have plastic in them?

That's so gross. I like buying a lot of tea from Asia and small companies. I'm not that big of a fan of loose leaf just because it's less convenient to brew.

Something1234on New Zealand to ban smoking for next generation in bid to outlaw habit by 2025

You smoking infringes on my right to clean air in a restaurant.

Something1234on New Zealand to ban smoking for next generation in bid to outlaw habit by 2025

How would an import tax be disallowed? Every country has weird tariffs and whatnot.

Something1234on Piracy release group EVO ‘blames’ movie industry for its popularity

How so?

That doesn't make sense. I think most of the royalties come from the long tail of companies, and market cap is a really terrible way of determining the worth of a company

Something1234on Bash patterns I use weekly

https://regex101.com/

Something1234on On the Impossibility of Supersized Machines (2017)

In the past 10 years, I think we had a 8x increase in easily available storage going from 1TB drives being a $100 to a 16TB drive being roughly $250. So I would have to say that your time scale is way too optimistic at best.