HNHacker News
TopNewBestAskShowJobs

evv

2,113 karma · joined October 11, 2012

co-founder of seed.hyper.media

Github: /ericvicenti

Email: eric at vicenti dot net

submissionscomments
evv··on Postgres 15 improves UNIQUE and NULL
Interesting! But where can you implement the UNIQUE constraint for doc names under a given parent? I guess your application code would need to handle that
evv··on Postgres 15 improves UNIQUE and NULL
I have struggled to implement a tree structure in PG with nullable unique values.

Consider a "docs" table where each doc has a unique name, under a given parent doc. A null parent would be a top-level doc, and top-level docs just have a unique name. This didn't work before, and would hopefully be addressed by PG15.

I'm not sure if null parents really represent a "problem with my data", or if the tree structure was too exotic for PG to support properly.

How I got around it: hardcode a certain root doc ID, then the parent column can be NOT NULL. But this felt janky because the app has to ensure the root node exists before it can interact with top-level docs. Plus there were edge cases introduced with the root doc.

evv··on Show HN: Recut automatically removes silence from videos – built with Tauri
Recut lets you configure that with a little slider
evv··on Celsius Appears insolvent, and it's taking the whole crypto market with it
My friend Kelvin says crypto is going to absolute zero.
evv··on Tech Experts Urge Washington to Resist Crypto Industry's Influence
https://news.ycombinator.com/item?id=31579357
evv··on Ask HN: How to Monetize Open-Source Software?
So glad you already cover my favorite ideas for monetization! I'm considering how to monetize my own startup- currently the whole codebase is permissively licensed.

I plan to sell a hosted service, but hopefully I will be in a position where I actually WANT AWS to yoink the code and run a competitive service, so it can feed into better business models.

Open Core is distasteful in my opinion because it limits the growth of the open project. (no no I won't accept that relevant Pull Request, because I want to sell this feature as proprietary)

GPL/copyleft is not right for me either, in fact I want to HELP people fork for their own companies and profits.

So, once Amazon finally launches their competitor service, I can still:

  - compete with AWS on product and User Experience
  - sell early access/license to the open source code
  - sell courseware subscriptions+packages
  - sell first-party support
  - crowdfund feature development
  - sell consulting services
evv··on Show HN: Caddy v2.5.0
I wouldn't put effort into changing if you have no troubles with nginx. Caddy has some neat features like live-configuration and built in LetsEncrypt. Plus the JSON configuration is a great idea, once I get it working.

The real reason is the thing you highlighted: "I can see there are some NGINX Plus features that are free in Caddy." Sadly it seems that NGINX is now crippleware. Personally I find it risky to depend on open source organizations who refuse to accept important features to the project, so they can sell those features as proprietary.

evv··on Show HN: Caddy v2.5.0
Thanks! Somehow you knew that I was struggling with JSON config of a custom Caddy build (for the Cloudflare extension)

caddy-json-schema looks great, I'll try this next time!

not sure if I totally missed `caddy adapt` or if I had troubles with it.

evv··on Show HN: Caddy v2.5.0
Caddy is such a delight! I can't reccomend it fast enough when somebody mentions they are on nginx.

Small random feedback: I like the idea of JSON configuration but most of the common docs/recipes are documented only with the Caddyfile format. I couldn't figure out the full JSON schema that was expected so I wound up generating a Caddyfile string instead for my programatic control. Maybe there is some translation tooling that could help?

evv··on Videolan.org robots.txt
These are some cute "fuck off"s but its unlikely that these sites actually respect the robots.txt, right?

Correct me if I'm wrong: After the recent web scraping ruling[1] it seems that it's perfectly legal to ignore the robots.txt.

[1] https://news.ycombinator.com/item?id=31075396

evv··on A 4-year-old can run errands alone and not just on reality TV
Child abducted by CPS- I did not see the plot twist coming.
evv··on State of OSS Monetization
Makes a lot of sense to sell a service powered by an open source project. Why is the blockchain token "the best way", or necessary at all?
evv··on Flutter is the most popular cross-platform mobile SDK
> I'd argue the biggest flaw with the web is it has a million nit-picky features when it should ONLY offer JavaScript+canvas

That would break the web, though? One of the biggest _strengths_ of the web is backwards compatibility.. I, for one, am grateful to use modern browsers to consume older content and apps.

evv··on White hat hacker awarded $2M for fixing ETH-creation bug
Thanks. As somebody with a very basic understanding of ETH, it seemed super unlikely that a L2 would be able to able to mint arbitrary ETH. (That would obviously be vulnerability in the L1)
evv··on The Pirate Bay Token
I wouldn't touch BTT. BitTorrent is owned by some private company now.

The creator of BitTorrent has gone on to invent a new type of cryptocurrency (proof of space+time)

evv··on Google Chromium, sans integration with Google
See also: VSCodium if you like VSCode but don't like sending sensitive telemetry info to Microsoft.

It is ironically hosted for free on Microsoft's popular git hosting website.

evv··on Remix Goes Open Source
Definitely not wishful thinking. According to the creators on Twitter, it absolutely getting open-sourced today as MIT.

The "Remix v1" event starts at 1PM PST: https://www.youtube.com/watch?v=wsJaUjd1rUo

I'm excited to see some competition for Next.js, but I've been waiting for the Remix license change to get started.

evv··on Notes on Web3
Solana is a "Proof of Stake" network, a trust model where nodes can only be run by currency holders. There is a predetermined list of trusted identities- aka, centralization.

And to your point, centralized services do have better performance.

I'm not trying to be a downer- I think centralization can be incredibly valuable for building trusted systems. But they are not to be confused with trustless networks like Bitcoin, Ethereum, and Chia.

evv··on MangoDB: An open-source MongoDB alternative
Fundamentally I do agree with you. (especially with the mention of "Apache License 2.0 with Commons Clause", which was giving me a headache this morning)

But also I'm not lifting a finger to help companies like MongoDB, unless properly compensated.

Personally I hope that MongoDB does go for a trademark lawsuit, triggering the Streisand Effect. Then Mango can find a better name and attract attention.

evv··on Tell HN: Tesla rear-ended me on autopilot, no one will investigate
I have adaptive cruise control, and it behaves the exact same today as it did on the day I test drove the car. It doesn't change behavior unpredictably with OTA updates!

How was the driver supposed to know that the previous issue was not some rare fluke?

Tesla is recklessly rolling out software, and amazingly has pushed off the liability to the drivers willing to try it. Sadly we are all part of the beta, like it or not, if there are are Teslas driving around on public streets.

I'm mostly shocked that insurance rates have not skyrocketed for FSD beta testers.

evv··on MangoDB: An open-source MongoDB alternative
How many fruit-related names are available, anyways? There would surely be a different lawsuit coming their way if they named it AppleDB. (ok, I admit this is a terrible joke)

If "Mango" can get away with it, I think it is very cool to provide a graceful path to open source tech.

I don't have much pity for the $33B company that promotes its mediocre semi-proprietary database to unsuspecting devs/students who don't know better.

evv··on Show HN: Use your iPhone's camera to see any photo on your wall
Why would they distribute the ML weights file if it isn't being used for logging or reporting? Of course I do theorize that it is actually being used.

There is so much network traffic between macOS services and the internet, I'm not sure how easy it would be for researchers to discover if CSAM reporting is enabled. Little snitch detects 292 macOS services on my M1, all talking to the internet. Network experts in Apple probably even have ways of bypassing little snitch.

evv··on Show HN: Use your iPhone's camera to see any photo on your wall
I'm not big into "conspiracy" but you gotta wonder why this "NeuralHash" file on my computer exists if "NeuralHash" was supposedly delayed, according to Apple, on an undetermined timeline.

If I did want to cook up conspiracy theory, it would be easy: Apple wants to distract from the fact that NeuralHash was broken by researchers. This project apparently is able to create CSAM collisions:

https://github.com/AsuharietYgvar/AppleNeuralHash2ONNX

If NeuralHash is really rolled out, and if this python project can really create collisions, the CSAM system could be DDoS'd by people on their own computers, jamming up Apple's internal censorship review system with false positives. Hence, Apple would be incentivized to sweep this under the rug by "delaying" rollout indeterminately.

evv··on Show HN: Use your iPhone's camera to see any photo on your wall
If iOS is anything like macOS, they have already quietly rolled it out.

If you're on a mac, even "Big Sur", check to see if the CSAM weights file is here at: /System/Library/Frameworks/Vision.framework/Resources/NeuralHashv3b-current.espresso.weights

If you use un-jailbroken iOS 14 of course you can't easily check for the presence of the weights file, so you're already trusting Apple on their word.

evv··on Generation X Is Sick of Your Bullshit (2011)
Oh, I'm extremely mad at Manchin and Sinema. But I believe you are underestimating the power of the presidential podium. I will readily admit that the Democratic party deserves more blame than Biden himself.

If Biden cared, he could shame these "Democrat" senators and prevent them from getting re-elected. If he uses his platform to inhibit their campaign fundraising, they will surely change positions out of fear of loosing their seat.

And something to keep in mind before we make campaign contributions for 2022, remember that some votes are way more valuable than others. Each vote for a Senator in Arizona counts more than 5x than in California.

evv··on Generation X Is Sick of Your Bullshit (2011)
My friend, a plurality is not a majority.

And in a two party system, even a majority won't help. Biden got elected thanks to young voters, but look how little climate action the new administration has taken.

Sad that you're looking to assign blame rather than problem-solve for future generations.

evv··on Is nuclear power our best bet against climate change?
The free market approach would probably work because nuclear has incredible energy density. And during the day, solar is crazy cheap.

The polluting energy sources are more expensive. How fucking lucky is that!

But I don't think nuclear deregulation will motivate the rapid change we require to avoid climate disaster. Carbon tax would help, I think, but there is zero chance it will be implemented on the global scale. (Fuck our lives, right?)

evv··on Is nuclear power our best bet against climate change?
Maybe it's funny but yes, I blame politicians. Who do you think defines rules for PG&E? Is the energy density of nuclear not high enough? We can't afford it? There too many CO2 emissions?

California produces ~40% of our electricity with fossil fuels, and if we switch to electric vehicles, demand will dramatically grow. Plus we need to replace the 9% of power that Diablo Canyon provides until 2024. The situation is dire for CA, a state that is supposedly a leader on climate action, and who is blessed with good weather and economy. Good luck deploying solar+storage in places that have winter and worse economic constraints.

Look at France if you really think politics is not the problem. The vast majority of their power is nuclear. Zero carbon emissions from those reactors. France is the largest exporter of electricity in the world.

Do you think France has some secret nuclear technology, or do they have different physical constraints? I don't think so. I do applaud French politicians for mobilizing against climate change.

evv··on Is nuclear power our best bet against climate change?
Any reason not to use ocean water? The Diablo Canyon reactor in California has tech that limits ocean water temperature increase to 20°F, to avoid harm to sea life.

You can also spend excess energy on desalination, which is helpful for water-starved places like CA.

And yes, this is CA's only nuclear reactor, which politicians are actively pushing to shut down without a replacement.

evv··on Rowy: Open-source Airtable alternative on Google Cloud
I hated Airtable because it was proprietary system that I could not modify or host myself. Rowy doesn't seem like an improvement because it only connects to Google Firestore, a proprietary and centralized service.

Realistically I just want to use PostgreSQL and an open source UI on top, like NocoDB or Baserow.

But hey, maybe Rowy will be a cold glass of water for those stuck in Firebase hell.

← PreviousPage 3 of 19Next →