piaste

32 ms·

391.
by piaste 4y ago
SQLite supports computed columns, so you could just add a virtual text column next to the 'real' epoch column defined as the date representation of your choice. https://www.sqlite.org/draft/gencol.html Ignore
392.
by piaste 4y ago
I disagree: delegating to a cache isn't a major problem, when the single source of truth is public and relatively easily accessible. A DNS server censoring or tampering with DNS requests is already trivially detectable now by comparing
393.
by piaste 4y ago
> if scarcity is not needed or desirable for MtG players why would they not just release all cards individually for the same price? why should any card be harder than another to acquire? Because it's desirable for the publisher? Sin
394.
by piaste 4y ago
True collectors do exist who collect something purely because it's rare. In MtG the most obvious example are 'misprint' fans who enjoy collecting cards that got accidentally printed off-center, or upside-down, or in the wrong
395.
by piaste 4y ago
Your vision matches mine pretty much 100%. If an asset doesn't live exclusively the blockchain, the blockchain can't enforce its ownership. If the blockchain can't enforce its ownership, it doesn't have anything else to
396.
by piaste 4y ago
Indeed, Dalí would absolutely be minting NFTs if he were alive today. And this is one of the most unkind things I might have ever said about NFTs.
397.
by piaste 4y ago
> without this imposed scarcity all assets would have equally unlimited supply and the game would probably be pretty bland, and there would be not as much reason to trade cards and build a hand. Completely false. The strategy game and th
398.
by piaste 4y ago
> But when you buy a print from the artist, you're paying for that signature that says "#3 of 100." There's nothing stopping the artist from printing more, and there's nothing stopping random people from duplicat
399.
by piaste 4y ago
> I know it's popular to be a millennial on HN and demand instant gratification of our short attention spans. But 20 years really is nothing for developments like this. > Also, that's less than 20 years ago. They were messin
400.
by piaste 4y ago
+1 I do that on mobile, I have a heavily locked-down Fennec F-Droid for random browsing but it's awful to use Google websites from it, so I keep Bromite around only for checking my old GMail / GDrive accounts (I've moved to o
401.
by piaste 4y ago
With Photopea, you can let the application load, then disconnect from the internet (or otherwise firewall the app) before loading your image. I just gave it a try and I could load the image, edit it in various ways, and save it just fine. I
402.
by piaste 4y ago
> what are the most unfortunate technology or startup names my fellow HN'ers have encountered? A few years back there was a Github OSS project by an Asian developer who couldn't speak English at all - I think it was a Ruby or N
403.
by piaste 4y ago
> Keycloak is a great tool but definitely not has B2B features like user management for each business customer, self service and delegated access management as well as self service federation. (See also: https://zitadel.com&#x
404.
by piaste 4y ago
> an always-on connection that I have no control over Has anybody tried disabling the LTE antenna (or whatever it uses) on a Tesla for privacy/security reasons? I'm sure hoping the car still drives fine without it, but can it b
405.
by piaste 4y ago
I believe (hope) Asooka's post was satirical, but I am no longer as confident in such judgements as I used to be.
406.
by piaste 4y ago
Ideally, the expert's advice would be a product in itself. For the expert to be incentivized to give unbiased* advice, 100% of their income needs to be from the customer, and 0% from the car maker. Which Bluntly put, this boils down to
407.
by piaste 5y ago
Man, memegen was covered by Buzzfeed ten years ago . It ain't exactly the hottest, edgiest shitposting club out there.
408.
by piaste 5y ago
No, he's talking about the OP, whose site needs to intercept all your search queries in order to provide the highly valuable service of adding "site:reddit.com" for you.
409.
by piaste 5y ago
Yeah, I used to save a local copy of Wikivoyage in Kiwix when travelling abroad, back in days before the EU abolished roaming charges. Worked great.
410.
by piaste 5y ago
"Active users" is a metric that is: (a) somewhat tricky to define with legislative-grade rigour, and much more importantly: (b) only measurable by the very same entities who would be subject to this regulation Were it not for the
411.
by piaste 5y ago
Do you apply the same rigorous standards to all your purchases? Do you refuse to buy a drink or a pair of shoes or a travel ticket unless you can ensure that "not a single cent goes to execs" who get "absurdly high, grossly u
412.
by piaste 5y ago
> Clearly they are not blowing through an entire year's defense budget in three days (that would be over 100x the usual rate of spend!). The figure in the article includes losses; indeed, it speaks of costs , not spending . Of cou
413.
by piaste 5y ago
> I doubt you would want murderers advertise for their cause on Facebook. Why not? The Unabomber Manifesto is freely available, and I would not want it censored by private parties. If anyone should decide that "this content consti
414.
by piaste 5y ago
As long as it's responsive. A lot of websites from that era are unusable from mobile phones. Whatever your business or marketing strategy, there's a significant chance the first time a new customer clicks on a link to your webpage
415.
by piaste 5y ago
> I do realize there's an independent implementation in Vaultwarden, so that's almost better than a spec -- just as long as Vaultwarden was a clean-room impl and thus reading that code is "legally safe." Vaultwarden i
416.
by piaste 5y ago
> Yes it does. You were arguing that Apple can prevent competition from ever arising. This isn't the case, clearly. Ok, fine, it can only reduce the effectiveness of competition by a large amount . See the last point in this reply.
417.
by piaste 5y ago
> It is trying. Yahoo tried to acquire Google too, remember? The success rate doesn't need to be 100% for my point to be valid. WhatsApp and Instagram could very well have eaten Facebook's lunch. Now FB is being threatened for
418.
by piaste 5y ago
> Apple cannot prevent competition from arising outright, just as RIM could not, just as Microsoft could not. On the contrary, it is actively doing so. It does so in the same way that Facebook prevented Instagram from becoming a competit
419.
by piaste 5y ago
> At what point exactly did it lose the rights it was entitled to then? At some point between becoming a publicly-traded company and becoming the sole gatekeeper of a significant chunk of the world's personal data and apps. To pro
420.
by piaste 5y ago
You speak of Apple as if it were an individual or a small company run by a tight group of friends. AAPL is not a courageous pioneer being oppressed by "The Man". AAPL is a trillion-dollar institution that by design exists only t

More ›