News for hackers. Stuff that matters.

wfriesen

Re:Google Pixel Watch 2 on Thursday October 05, 2023 @12:18AM (#37774868)
In Australia it's $400 Google Store credit with the Pro, $250 with the regular. Pixel Watch 2 starts at $549.
Re:Movie-Theater Behavior Has Gone Off the Reels on Friday August 04, 2023 @06:18AM (#36997878)
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
Re:How to Check 2 SQL Tables Are the Same on Friday July 28, 2023 @05:56AM (#36904796)
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
    )
  )
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"

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.
Re:The Curse and Blessings of Dynamic SQL on Tuesday May 09, 2023 @02:17AM (#35870767)
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
Re:Book Depository will be closing on 26 April 2023 on Wednesday April 05, 2023 @04:57AM (#35451256)
A good meta search across book stores is https://booko.info/ It's not global, but serves a few countries
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...

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?
Re:Make Your Database Tables Smaller on Friday December 30, 2022 @04:28AM (#34183439)
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.
I've been using it for a while now getting the password from a file.
Re:From WampServer, to Vagrant, to QEMU on Thursday November 10, 2022 @11:52PM (#33557422)
Interesting path, he's skipped straight over the Vagrant->Docker step most took (myself included)
Re:Tell HN: WhatsApp Is Down on Tuesday October 25, 2022 @05:45AM (#33328344)
Signal doesn't press you to setup (by default) unencrypted cloud backups.
Re:Do McKinsey and other consultants do anything useful? on Saturday October 15, 2022 @11:58AM (#33215902)
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.
Re:Calibre 6.0 on Wednesday July 13, 2022 @03:15AM (#32079833)
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

Re:Music for Programming on Thursday July 07, 2022 @01:13AM (#32010151)
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.
Re:Paperless-NGX on Thursday March 31, 2022 @01:28AM (#30864102)
I just migrated my instance by repointing the webserver container image at the one in this repo. So far, so good.
Re:Home Depot successfully installs Tomcat 9 in production on Saturday March 19, 2022 @02:36AM (#30731688)
Tomcat is a common embedded server for Spring Boot applications, and included in the default web stack from Spring Initialiser.
Re:Fastmail vs. ProtonMail: A Comparison on Friday March 18, 2022 @10:32PM (#30730368)
That's only on the cheapest paid plan. You can customize plans and increase the amount of domains, though it adds to the price.
Re:Time Series Forecasting in SQL on Tuesday February 22, 2022 @02:20AM (#30424930)
This isn't really "in SQL" as much as "using a product that has a SQL extension/backend".
Re:Poor man's VPN (pay for only what you need) on Wednesday January 12, 2022 @08:39PM (#29915735)
pivpn now supports both wireguard and openvpn, with wireguard as the default.
Re:RSS-Bridge – The RSS feed for websites missing it on Sunday January 02, 2022 @11:03PM (#29777207)
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

Re:Server.casino – Random Servers Across the Internet on Tuesday June 22, 2021 @04:34AM (#27589329)
Just 80, it seems https://github.com/caioluders/server.casino/blob/354cec4c053...

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

Re:What does First Normal Form mean? on Friday June 18, 2021 @11:44AM (#27551556)
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.
Re:How image search works at Dropbox on Wednesday May 12, 2021 @05:55AM (#27128526)
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

Re:SQLite the only database you will ever need in most cases on Thursday April 15, 2021 @03:27AM (#26817184)
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.
Re:Walletmor Payment Implant on Sunday April 11, 2021 @08:16PM (#26774829)
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.
Re:French drugs haul 'was strawberry Haribo' on Saturday March 20, 2021 @03:43PM (#26525599)
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.

Older »