Today I had a small task that involved messing with a table that shouldn’t be messed with. I discovered that there are two quick ways to duplicate a table on PostgreSQL:
-- copies everything to the `_bkp` table
CREATE TABLE table_bkp AS (SELECT * FROM original_table);
-- only copies the table structure
CREATE TABLE table_bkp AS (SELECT * FROM original_table) WITH NO DATA;
A refactoring example. When I introduce the Fake Object testing pattern to people, a common concern is the maintenance burden of it. The point of the pattern is that you write some 'working' code only for test purposes. …
via ploeh blog November 20, 2023This post is hard to write in a lot of ways. It's more personal than most I've written. This is presumptively a tech blog, and this piece is about so much more than technology. But it's important. Making things, software or otherwise, is ultimatel…
via ntietz.com blog November 19, 2023Update on what happened across the GNOME project in the week from November 10 to November 17. GNOME Circle Apps and Libraries Workbench A sandbox to learn and prototype with GNOME technologies. Sonny says Workbench is a code playground and Library to learn, e…
via This Week in GNOME November 17, 2023Generated by openring