HNHacker News
TopNewBestAskShowJobs

wfriesen

132 karma · joined July 23, 2017

[ my public key: https://keybase.io/wfriesen; my proof: https://keybase.io/wfriesen/sigs/WtqgVUgYm61hNZymlqL6OxIprtQtzpjwCJ21z7lJIa8 ]
submissionscomments
wfriesen··on Google Pixel Watch 2
In Australia it's $400 Google Store credit with the Pro, $250 with the regular. Pixel Watch 2 starts at $549.
wfriesen··on Movie-Theater Behavior Has Gone Off the Reels
Those prods have existed since phones, but it was previously about not having a ringtone blare out. Now the backlash is against people scrolling tiktok/whatever during a movie. I haven't been to a movie theatre in a while so I can't say if it's a phenomenon but that would be infuriating
wfriesen··on How to check if two SQL tables are the same
I've always used this. Any rows returned means there are differences

  select * from (
    (
      select *
      from table1
      minus
      select *
      from table2
    )
    union all
    (
      select *
      from table2
      minus
      select *
      from table1
    )
  )
wfriesen··on YouTube will stop removing false claims of 2020 US election fraud
Yeah, compulsory voting is what makes it a viable way to detect fraud.

I was also mistaken somewhat when I said "paper ballots". There is certainly electronic voting in Australia, but the "authentication" aspect of just saying a name is still the same. It's essentially "trust but verify"

wfriesen··on YouTube will stop removing false claims of 2020 US election fraud
In Australia we do paper ballots, no voter ID, you just say your name and it's crossed off a list. Afterwards, if the same name was crossed off two lists, the amount of double votes are counted and if it is enough to change the result then the result of that electorate is invalidated. This has not ever happened.
wfriesen··on The curse and blessings of dynamic SQL (2004-2022)
Coming from an Oracle background, both application and data warehousing, I wholeheartedly agree with the articles first paragraph saying that application based dynamic SQL is horrible, but DBA (and I'll include data warehousing) dynamic SQL is great, but it's essentially about how complex the thing is.

A DBA is likely doing things like looping over metadata tables and running

  'grant select on ' || some_table || ' to ' || some_user
While an app developer with free reign will end up doing something much more complex, and much harder to reason about/tune
wfriesen··on Book Depository will be closing on 26 April 2023
A good meta search across book stores is https://booko.info/ It's not global, but serves a few countries
wfriesen··on A brief history of APFS (2022)
Not mainlined now, and probably not ever given that Linus has said "considering Oracle's litigious nature, and the questions over licensing, there's no way I can feel safe in ever doing so"

https://arstechnica.com/gadgets/2020/01/linus-torvalds-zfs-s...

wfriesen··on Interesting Facts about Bell Labs and 2001: A Space Odyssey (2001)
I think of the classic sci-fi depiction of "picture phones", and they are almost exclusively a device mounted on a wall, much like the original telephone. Maybe it's just a usability issue, in that holding a phone pointing at yourself is a bit annoying?
wfriesen··on Make your database tables smaller
Joins are cheap when joining on indexed columns, but the trade off is extra time maintaining those indexes when writing. As always, it depends on the use case.
wfriesen··on BorgBackup: Deduplicating archiver with compression and encryption
I've been using it for a while now getting the password from a file.
wfriesen··on From WampServer to Vagrant to QEMU
Interesting path, he's skipped straight over the Vagrant->Docker step most took (myself included)
wfriesen··on Tell HN: WhatsApp Is Down
Signal doesn't press you to setup (by default) unencrypted cloud backups.
wfriesen··on Do McKinsey and other consultants do anything useful?
I worked in government where Accenture where brought in for projects. A lot of high level meetings and presentations, then sub-junior level devs. At the end there was a lot of legal wrangling over "we delivered what you asked for", while the customer got very little of what they wanted.
wfriesen··on Calibre 6.0
I'm using the linuxserver container image for calibre, then rsync'ing to my laptop to sync with my kindle. Not really server-only but has everything I want from that

https://docs.linuxserver.io/images/docker-calibre

wfriesen··on Music for Programming
Other than doom I like some fuzzy raw black metal to drown out noise, like Paysage d'hiver. Thankfully they have quite a large discography.
wfriesen··on Paperless-NGX
I just migrated my instance by repointing the webserver container image at the one in this repo. So far, so good.
wfriesen··on Home Depot successfully installs Tomcat 9 in production
Tomcat is a common embedded server for Spring Boot applications, and included in the default web stack from Spring Initialiser.
wfriesen··on Fastmail vs. ProtonMail: A Comparison
That's only on the cheapest paid plan. You can customize plans and increase the amount of domains, though it adds to the price.
wfriesen··on Time Series Forecasting in SQL
This isn't really "in SQL" as much as "using a product that has a SQL extension/backend".
wfriesen··on Poor man's VPN (pay for only what you need)
pivpn now supports both wireguard and openvpn, with wireguard as the default.
wfriesen··on RSS-Bridge – The RSS feed for websites missing it
The official plugin uses a php port of Mozilla's Readability, which is used for Firefox Reader Mode. There is also the 3rd party FeedIron that is more configurable.

https://github.com/feediron/ttrss_plugin-feediron

wfriesen··on Server.casino – Random Servers Across the Internet
Just 80, it seems https://github.com/caioluders/server.casino/blob/354cec4c053...

That probably increases the odds that the servers it finds are "interesting"

wfriesen··on What does First Normal Form mean?
Business/requirements/users will often tell you that no two users will have the same birthday/SSN/whatever, but so often that eventually proves incorrect. Just using an auto increment ID as the primary key can prevent a lot of pain down the road.
wfriesen··on How image search works at Dropbox
I use rssbridge for sites without a feed, and the feediron plugin for ttrss for sites whose feed is incomplete.

https://github.com/RSS-Bridge/rss-bridge https://github.com/feediron/ttrss_plugin-feediron https://git.tt-rss.org/fox/tt-rss

wfriesen··on SQLite the only database you will ever need in most cases
The .wal file comes and goes, so occasionally things like rsync will fail if the file no longer exists by the time it tries to transfer.
wfriesen··on Walletmor Payment Implant
They contain very little metal, so will not set off any metal detectors. I have a similar sized implant, but not this one, and have no trouble at airports.
wfriesen··on French drugs haul 'was strawberry Haribo'
The result is the same, but most drugs (prescription and otherwise) are more in the milligram range. For ecstacy/MDMA an effective dose is usually on the order of 100mg.
wfriesen··on A Youtube video downloader written in Go
I'd assume it's only YouTube, the usage message has this text [1]:

    Download a video from youtube
The beauty of youtube-dl is that it is so universal, supporting a great number of sites, even the simplest case of giving it a direct link to a video file and it will essentially wget it, and process according to your config.

[1] https://github.com/kkdai/youtube/blob/00a2aefb29c4fbf4fc3bf3...

wfriesen··on Set the default branch for newly-created repositories
My guess is because "Main" was used in Microsoft's TFS.
Page 1 of 2Next →