ilikepi

Yeah...I'd really like to extricate myself from Amazon Photos/Drive, but I haven't even begun to investigate how much of a project that will be.

I'd say it's highly likely that is an intentional pun. Several of the show's writing staff hold advanced STEM degrees. One of them wrote a mathematical proof specifically to include as a plot device in one episode[1].

[1]: https://en.wikipedia.org/wiki/The_Prisoner_of_Benda

Yep, very similar experience here. I find listening to music from that time period just makes me melancholy (err...no pun intended), so I mostly avoid it now. I'm not sure if this is because it brings me back to that time, or if it's the general mood of the music itself...probably both. I guess it makes sense that the music of a given time would reflect the general mood of the people coming of age at that time.

I don't know where else to go with that thought...ah whatever. ;)

EDIT: fix typo, because of course

The latest episode of Radiolab also discusses the origins of the panel.

https://www.wnycstudios.org/podcasts/radiolab/articles/faceb...

> Postgresql is following a blacklist access model which is really hard to get right, a whitelist approach like mysql would be much easier.

I don't think this is quite right. When a new user is created in Postgres, I don't believe any permissions are implicitly GRANTed by default aside from CONNECT. And I believe the only default privileges granted on a given database are to its owner. Is it possible your experience has only been with configurations in which your PG user was either the owner of the database or a superuser?

EDIT: clarification

For some time now, in the default configuration, `brew upgrade` is run automatically any time you run `brew install`. You have to set HOMEBREW_NO_AUTO_UPDATE to disable this behavior.

EDIT: whoops, that was incorrect. It's actually `brew update` that is run automatically, which updates Homebrew itself plus all of its formulae. However, I think often the effect can't be similar. If formulae are updated, and the new package you're trying to install shares a dependency with other packages, the dependency will be automatically updated as part of the install process. I'm not sure if this can also trigger an update of an existing leaf package though.

I think part of the challenge (from my perspective, as someone who only rarely needs to mess with python) is not that the workflow you describe is particularly complicated in isolation, it's the shear number of different tools that ostensibly have the same goal: to manage python virtual environments and packages. Because there are so many different tools, there is a near-limitless supply of different articles and SO posts in which people describe the "best" way to accomplish the most basic setup and maintenance of a virtual environment. It's quite difficult for new and/or occasional users to choose a good way to get started. Even if there is an "official" way documented on python.org for each Python version, when you run into a problem with it, inevitably you're stuck filtering through lots of advice to "just use <third-party tool xyz> instead".

It kinda seems like your example says more about the specific behavior of the MacGPG installer than about the general reliability of macOS's package database.

> Never understood this company. Lenovo and Dell sell computers with Ubuntu or Fedora pre-installed, that have been tested and are guaranteed to be fully compatible with Linux.

This hasn't always been the case. System76 has been around since 2005.

> Why would you go with System76, which is selling rebranded Clevo laptops with a markup, and PopOS, which is an Ubuntu derivative?

To support a company whose entire purpose is to provide hardware running Linux, as opposed to one which does it as a small niche within their much larger Windows-based business.

> What is the purpose of a USB2.0 port on a new computer in 2021?

Volume cost savings, presumably. I guess that's the port you use for input devices since they don't really require high bandwidth connections...

> My other bugbear are the auto playing videos on Netflix and the use of massive spoilers in episode thumbnails.

You can actually turn off "Autoplay previews" now. You have to log into your account from a web browser, and then look at the Playback settings for the profile you want to change.

> Does that take 6 months?

If this one change is in a pool with tens of thousands of other possible changes, and it also has to go through one or more QA cycles? Sure, why not 6 months?

Oh totally...

It's slightly surprising there's not an emergency evacuation procedure for people who work in the building that involves locking all devices that remain in the building via a hot-key or hot-corner. Come to think of it, I wonder if a screen lock command is something that could be pushed from a Windows domain controller...and if so, why wasn't that used?

Wow, I did not realize Activity Monitor did that. QuickTime Player seems to have lost its dynamic icon, though.

I've gotten to the point where I don't even use the dock anymore, it just stays hidden. Quite a long way from the good ole' days of themes.org, freshmeat.net, and spending hours customizing my desktop environment.

There probably is, and it probably wasn't. There's a big difference between an office of someone who regularly meets with visitors and a room that is likely limited to a handful of people under controlled circumstances. It's likely there's a whole secured area of the building dedicated to operations (telecomm, engineering, etc).

Reminds me of customizing WindowMaker's dock with system monitor widgets[1]. I wonder how quickly (or if at all) the macOS dock responds to changes to an app's icon...

[1] https://www.dockapps.net/category/system

It seems the huge and annoying "Why don't you join Github" banner is gone now, too. They must have eliminated the persistent cookie that clicking "Dismiss" presumably set. That banner was very frustrating for me, as I clear cookies regularly from the browser profile I use for random surfing.

I'm slightly surprised to not see any mention of materialized views.

We're in the middle of a project in which we use file_fdw to provide an interface to CSV files which are replaced nightly, but we then also have indexed materialized views to provide faster access to the data in those files. The CSVs are only read once per day when REFRESHing the materialized views after a new set of files is dropped in.

One of the nice things file_fdw is that it allows you to create foreign tables even when the source files don't exist on the filesystem. PG only cares about the files at the moment it's trying to read them. There is one downside, though, which is that the files have to be specified via absolute path. This is something that has to be considered given the heterogeneous machine environments on which the application runs.

> I wish there were a way for the db to filter out or not surface rows that violated a constraint but that then loaded the data that did meet the constraints.

You can definitely have PG ignore rows that would violate constraints by specifying "ON CONFLICT DO NOTHING"[1] as part of your INSERT statement.

If you wanted to capture those rows on the fly, one way would be to perform the load via a PL/PgSQL program and include an exception handler specific to the particular constraint violation(s) you expect to hit. But I guess then you'd have to load them one row at a time...and that's not too different from just doing that in your high-level language of choice. Also the PL/PgSQL docs specifically recommend against this idea.[2]

[1]: https://www.postgresql.org/docs/11/sql-insert.html#SQL-ON-CO...

[2]: https://www.postgresql.org/docs/11/plpgsql-control-structure...

EDIT: formatting and clarity

We implemented something like this on our own. We have child classes that inherit from an AR-backed parent, and on the parent we implement an instance method that transforms it (via #becomes) to the appropriate child based on the value of an attribute. The final piece is another attribute that stores a serialized object of child-specific attributes, and other methods that dynamically define attribute readers at boot time. It'll be nice to migrate to this new feature to free ourselves from the burden of that last piece in particular.

> On the other hand Red Hat does offer RHEL for free (gratis) [0] and that should fill the needs of CENTOS users (right?)

They offer a no-cost "developer subscription" of RHEL, but I'd wager the majority of users are running CentOS on servers.

Interestingly, that cable seems to use a 3-conductor (TRS) 3.5mm connector as opposed the usual 4-conductor one found on EarBuds. So I guess that implies it doesn't carry mic input?

Do either of those deal with YouTube ads? The old iOS ad blocker I've been clinging to has stopped blocking YouTube ads recently.

Ironically, coreutils introduced[1] a requirement to add `--no-preserve-root` to `rm -rf /` way back in 2003, so that particular example doesn't really support the counterpoint you're trying to make.

EDIT: clarity

[1]: https://github.com/coreutils/coreutils/commit/34e3ea055721ec...

Perhaps the concern in forking it would be that the group that creates the fork now has the responsibility of maintaining another project, on top of the project(s) they already maintain.

It's the lower tier MBP though - it replaces the "two port" one. The "four port" one is still Intel.

You don't remember that checkbox you clicked when registering for your account affirming that you definitely 100% read, understood, and agreed to be bound by Google's Terms and Conditions and Privacy Policy?

PCH provides the infrastructure for Quad9...so I don't think it makes sense to say that Quad9 is "relaying" DNS traffic to PCH/WoodyNet. There isn't some organizational boundary that's being crossed.

I used Verizon's recently, and it was actually forthcoming about this. I think it was part of the text content shown when the connection began (after the annoying pre-chat Q&A during which they try to convince you they can solve your problem without involving a human).

Apologies. That's what I get for posting while distracted from a conference call.