Hey.  This isn’t a real post but I thought you might enjoy. Recently the Yorkshire Museum had a curator battle where they challenged museums to post the #creepiestobject in their collection on twitter.  And it was fantastic and a million … Continue reading →

It may be tempting at the start of a new project to create the first database tables manually, or write SQL scripts that you run manually, especially when you first have to spend a significant amount of time on sifting through all the migration libraries and then some more to get it working properly.

Going through this process did slow me down at the start of the project but I was determined to use a migration tool because hunting inexplicable bugs that only happen in production just to find out there is a definition mismatch between the production and development databases is not fun. Using such a tool also motivates you to write both the setup and teardown steps for each table while the current design is still fresh in your mind.

At first I considered a standalone migration tool because I expect them to be very good at that single task. However, learning the idiosyncrasies of a new tool and trying to make it fit seamlessly into my development workflow seemed like more trouble than it is worth.

I decided to stick with a Common Lisp library and found the following seven that work with PostgreSQL and/or Postmodern:

• Postmodern-passenger-pigeon
• database-migrations
• cl-migrations
• Mito
• Crane
• Orizuru-orm
• cl-mgr

I quickly discounted Crane and Mito because they are ORM (Object Relational Mapper) libraries which are way more complex than a dedicated migration library. Development on Crane have stalled some time ago and I don't feel it is mature enough for frictionless use yet. Mito declares itself as being in Alpha state; also not mature enough yet.

I only stumbled onto cl-mgr and Orizuru-orm long after making my decision so I did not investigate them seriously. Orizuru-orm is in any case an ORM which I would have discounted because it is too complex for my needs. CL-mgr looks simple, which is a good thing. It is based on cl-dbi which makes it a good candidate if you foresee switching databases but even if I discovered it sooner I would have discounted it for the same reason as CL-migrations.

CL-migrations looks very promising. It is a simple library focusing only on migrations. It uses clsql to interface with the database which bothered me because I already committed to using Postmodern and I try to avoid adding a lot of unused code to my projects. The positive side is that it interfaces to many different databases so it is a good candidate if you are not committed to using Postmodern. It is also a stable code base with no outstanding bug reports.

The two projects I focused on was Postmodern-passenger-pigeon and Database-migrations because they both use Postmodern for a database interface.

Postmodern-passenger-pigeon was in active development at the time and it seemed safer to use than Database-migrations because it can do dry runs, which is a very nice feature when you are upgrading your production database and face the possibility of losing data when things go awry. Unfortunately I could not get it working within a reasonable amount of time.

I finally settled on Database-migrations. It is a small code base, focused on one task, it is mature and it uses Postmodern so it does not pull in a whole new database interface into my project. There are however some less positive issues.

The first issue is a hindrance during development. Every time the migrations ASDF system (or the file containing it, as ASDF prefers that all systems be defined in a single file) is recompiled it adds all the defined migrations to the migrations list. Though each one will only be applied once to the DB it is still bothersome. One can then clear the list with (setf database-migrations::*migrations* nil) but then only newly modified migration files will be added. The solution then is to touch the .asd file after clearing the migrations list.

The second negative point is quite dangerous. The downgrade function takes a target version as parameter, with a default target of 0. This means that if you execute downgrade without specifying a target version you delete your whole database.

I am currently using Database-migrations and it works well for me. If for some reason I need to switch I will use cl-migrations.

Using Database-migrations

To address the danger of unintentionally deleting my database I created a wrapper function that does both upgrade and downgrade, and it requires a target version number.

Another practical issue I discovered is that upgrades and downgrades happen in the same order as they are defined in the migration file. If you create two tables in a single file where table 2 depends on table 1 then you can not revert / downgrade because Database-migrations will attempt to delete table 1 before table 2. The solution here is to use the def-queries-migration macro (instead of def-query-migration) which defines multiple queries simultaneously . If you get overwhelmed by a single definition that defines multiple tables the other option is to stick with one migration definition per file.

LIVE. De Wever over eventuele tweede piek: “Normale quarantaine is er een van zieken, niet van gezonde mensen”  Het Laatste Nieuws

The CC Certificate aims to increase our global community’s expertise in open licensing and awareness of our shared, digital commons.  Our first goal is to train at least one person interested in open licensing in every country and territory, around the world. So far, we have CC Certificate graduates from 44 countries and counting! One … Read More "Creative Commons Welcomes Our 2020 CC Certificate Scholarship Recipients!"

The post Creative Commons Welcomes Our 2020 CC Certificate Scholarship Recipients! appeared first on Creative Commons.

https://www.bestbuy.com/site/one-piece-world-seeker-playstation-4/6180300.p?skuId=6180300

I can tell you--after seeing them in the bathroom mirror this morning--this shortcrust pastry recipe will give you les poignées d'amour. That's French for "love handles." Même pas peur? Not even scared? Good! Read on and discover a truly delicious and versatile pâte brisée. I should know...I've tested 10 of them in the past week--ever since you asked for the recipe! Today's Word: la pâte brisée : shortcrust pastry, a rich dough for making pie crust Audio: Listen to the words pâte brisée in this soundfile En cuisine, la pâte brisée est une pâte servant de base aux tartes salées ou sucrées. La pâte brisée désigne généralement une pâte composée principalement de farine et de matière grasse sans sucre. In cooking, shortcrust pastry is a dough used as a base for savory or sweet pies. Shortcrust pastry generally refers to a dough composed mainly of flour and fat, without sugar. Jérôme's Pâte Brisée: 4-ingredient Shortcrust Pastry (makes one large or two small tarts!) Ingredients... 2 cups flour 2 teaspoons baking powder 1/2 cup white wine 1/2 cup sunflower oil Note: ordinary white wine is all you need. Leftover wine will work as long as it hasn't turned to vinegar. For...

There is no better comfort food than a Chicken Pot Pie. It may seem daunting to make this savory dish, but trust us, it’s not when you use Queenhobo’s easy recipe. Most people stress about the crust, but you don’t have to when you use canned biscuits instead of a traditional topping. The thick biscuit […]

1. ZAPP spezial: Medien in der Corona-Krise (ndr.de, Annette Leiterer & Gudrun Kirfel & Daniel Bouhs & Tim Kukral & Caroline Schmidt & Sebastian Asmus & Andrea Brack Peña) Das NDR-Medienmagazin „Zapp“ widmet sich in einer halbstündigen Sendung den verschiedenen Auswirkungen der Corona-Krise auf die Medienbranche. Es geht unter anderem um Rekordreichweiten durch Corona, um Rettungspakete […]

An American woman goes to the police in Las Vegas. She claims she has been raped by an athlete: global football star Cristiano Ronaldo. What really happened has never been resolved because lawyers settled the case with a payment of $375,000 by the Real Madrid star. By SPIEGEL Staff

Claas Relotius wrote many seemingly excellent feature stories for DER SPIEGEL, but unfortunately most of them apparently contain fabricated passages. We are sorry about what has happened and we are investigating with the requisite humility.

The days run together during the coronavirus quarantine, but a jigsaw puzzle and a brief family moment help define them.

Drag queen D.J. "Shangela" Pierce talks about RuPaul's Drag Race and the new HBO series, We're Here.

One man wore plastic gloves and a face mask as he pulled up in a pickup to receive school-packed meals for his children.

The structure is a rare example of Art Deco style used for a garage. It will still be used to park cars but also will have amenities for apartment tenants.

Icelandic filmmaker Hlynur Pálmason's award-winning second feature, "A White, White Day," is a gripping, ruminative drama of grief and revenge.

The Pierce Brothers honor their influences with "The Wretched," and mask familiarity with atmosphere and suspense.

Natalie Wood's daughter, actress Natasha Gregson Wagner, has written a memoir of life with the legend and produced an HBO documentary about her career.

Piers Morgan believes the Premier League and EFL campaigns should be voided because of the COVID-19 outbreak.

PRINCESS ANNE, 69, appeared in a video on the Royal Family Instagram to celebrate the International Day of the Midwife. A video of the Princess Royal, the Queen's only daughter, was posted to the IGTV of the account.

Mizkan Euro Ltd is recalling Branston Pickle products because they may contain pieces of plastic.

Coop is recalling Frozen Hash Browns because they may contain pieces of white plastic. The possible presence of plastic makes this product unsafe to eat.

Unilever is recalling Wall’s Mini Calippo (Orange and Lemon-Lime) multi-packs because they may contain small pieces of metal. The presence of metal makes this product unsafe to eat.

PIERS MORGAN - a host on Good Morning Britain - issued a warning on Twitter for the public to not be "complacent' as he issued a reminder about his co-star Kate Garraway's husband Derek Draper who he said is "fighting for his life" following his hospital admission with coronavirus.

Our immediate economic prospects for this country could hardly look grimmer. As the coronavirus pandemic continues, Britain is on track for the worst slump in decades. In alarming terms, the extent of the recession was set out by a report this week from the independent Office for Budget Responsibility.

IRANIAN agents are delivering suitcases stuffed with £800,000 in cash to Hezbollah terrorists despite the Islamic state begging for financial help to deal with coronavirus, it is claimed.

OH, FOR pity's sake! Death is stalking the country, the NHS is over-run, the economy is crashing on a seismic scale but Ofcom is pontificating about broadcaster Piers Morgan's mimicry of a Chinese accent calling it "offensive and racist". Get a life, dears!

He expected to be incredibly busy immediately after the birth of his son Gordon, but Charlie Kimball has thoroughly enjoyed more family time.

Luke Land, 3, of Danville, Ind., is Mayberry Cafe's 2019 Opie look-alike winner.

Brownsburg upended Plainfield on Dec. 7 but the Bulldogs will be missing a key player when the two teams meet in the Hendricks County finals.

An iconic fast-food item is going through its midlife crisis. But is McDonald's new apple pie really living its best life in its new body?

Built around an Arts & Crafts theme, this year's Centerpiece Home shows off natural tones and details from Japan and the American late 1800s.

An overview of the sole French territory in North America

Trump’s attempted manipulations of official metrics degrade our democracy, economy and public safety.

Tart rhubarb and creamy custard—sweetened with just a hint of orange zest and nestled inside a flaky crust—are a match made in rustic pie heaven. This no-fuss single crust pie takes only a few minutes to prepare.

Continue reading "Rhubarb Custard Pie" »

Hear about travel to Barolo and the Piedmont region of Italy as the Amateur Traveler talks to Betsy and Greg Ball from eurotravelcoach.com about this wine region that they love.

The LockPickingLawyer easily opens this Yale Y500 Combination Key Access padlock with just a sliver of aluminum from a soda can.

Read the rest

Invitation Only Research Event

Event participants

Paul D’anieri, Professor of Public Policy and Political Science, University of California, Riverside
Vlad Mykhnenko, Associate Professor of Sustainable Urban Development, St Peter’s College, University of Oxford
Chair: Orysia Lutsevych, Research Fellow and Manager, Ukraine Forum, Chatham House

5 June 2014 , Volume 70, Number 3

The Golan Heights is home to thousands of Druze who cling on tenaciously while looking over their shoulder at the chaos in their homeland

6 November 2019 , Volume 95, Number 6

Cătălin I. Cârstea, Gen Nakamura and Lauri Oksanen
Trans. Amer. Math. Soc. 373 (2020), 3423-3443.
Abstract, references and article information

(American Association for Cancer Research) Combining intratumoral electroporation of interleukin-12 (IL-12) DNA (tavokinogene telseplasmid, or TAVO) with the immune checkpoint inhibitor pembrolizumab (Keytruda) led to clinical responses in patients with immunologically quiescent advanced melanoma, according to results from a phase II trial.

(International Astronomical Union) The Gruber Cosmology Prize, which is co-sponsored by the IAU, recognises scientists whose discoveries have driven fundamental advances in our understanding of the Universe. The 2020 prize has been awarded to Lars Hernquist and Volker Springel for their pioneering work on cosmological simulations, which have not only led to their own discoveries, but also become an invaluable resource used widely by other researchers.

Russia's GRU military intelligence service appears to have got hold of many emails from Chancellor Angela Merkel's constituency office in a 2015 hack attack on Germany's parliament, Der Spiegel magazine reported on Friday, without citing its sources. A spokesman for the German government had no immediate comment. Der Spiegel said federal criminal police and the federal cyber agency had been able to partially reconstruct the attack and found that two email inboxes from Merkel's office had been targeted.