ESPN will be releasing two brand new 30 For 30 documentaries in Africa in May and early June, telling the stories of cyclist Lance Armstrong and martial artist Bruce Lee.

V době koronavirové pandemie nás bombardují ze všech stran nejrůznější informace. Informační přetížení je tak značné, že v mnohých lidech vyvolává strach a stres. Jak tomu čelit, komu věřit a jaké informace ignorovat, se v komentáři zamýšlí psycholog Jan Urban.

The finalists are:

• Neil Clarke
• Ellen Datlow
• C.C. Finlay
• Jonathan Strahan
• Lynne M. Thomas and Michael Damian Thomas
• Sheila Williams

I'm a subscriber to Uncanny Magazine, edited by the Thomases, and a Patreon supporter of Clarkesworld, edited by Neil Clarke. I keep up with neither magazine as much as I'd like, but I generally enjoy both of them. Uncanny Magazine in particular has a very high hit rate for me when I do make time to read it.

(I also had the pleasure of meeting Neil Clarke in his kaffeeklatsch at Dublin Worldcon last year, which I really enjoyed & learned a lot from.)

I have one of Jonathan Strahan's anthologies from last year, Mission:Critical on my to-read pile, and I've also been eyeing the Made to Order: Robots and Revolution anthology published this year.

Ellen Datlow edits a lot of horror, which I'm cautious of, and I happen not to have read any of the Tor.com short fiction she acquired last year, but that could be remedied (in a well-lit room during the day, etc). She also lists a couple of anthologies, and while I'm not touching a Best Horror of the Year anthology, I might risk the ghost stories anthology.

C.C. Finlay and Sheila Williams edit respectively F&SF Magazine and Asimov's Science Fiction, neither of which I subscribe to or read regularly, but because I'm already not keeping up with the things I do subscribe to, not for any stronger or more considered reason.

The finalists are:

• Sheila E. Gilbert
• Brit Hvide
• Diana M. Pho
• Devi Pillai
• Miriam Weinberg
• Navah Wolfe

You can find lists of books published in 2019 edited by each of these finalists at this crowdsourced page at File 770, of which:

• Brit Hvide: 2 books on my wishlist
• Devi Pillai: 1 read, 2 on wishlist
• Miriam Weinberg: 2 on wishlist
• Navah Wolfe: 1 read, 1 on to-read pile

Devi Pillai edited A Memory Called Empire by Arkady Martine, which I love so much, and Navah Wolfe edited The Twisted Ones by Ursula Vernon, which is one of the few marketed-as-horror books I have willingly read. (It won't ever be my favourite Vernon book, but it was a good read.)

I’ve had some requests to show details of how I arrange the buttons in order to shorten my long skirts for bicycling. Well like this: Clear as mud? Let’s take a closer look. Disclaimer: I’ve been wearing both of these skirts for years and it shows in these detail shots. First that plaid walking skirt … Continue reading Bustled for Bicycling

Happy 40th birthday to me! I'm currently in Connecticut visiting with the whole family, which is only somewhat coincidentally on my 40th birthday weekend. The main thing is the pizza! Two quick updates from this month, strawberry-related:

One of my all-time favorite games, Celeste, just got a new free 9th chapter (which is sized more like three chapters). This was a mixed blessing since over a year ago I finished all its hardest levels (all achievements) and then managed to pry myself from it. So I felt compelled to get the two new achievements to get back to 100%, but it was a somewhat hypnotizing and RSI-inducing grind. (Especially since I had gotten pretty rusty. I even forgot that you can hold onto walls, which made the first few levels much harder...) The worst part was that the final level was rumored to be kinda ridiculous, and the "WOW" achievement even moreso, so I was feeling worried about that the whole week it took to get through the prior 99. All told it was pretty worthwhile; the level design is really admirable as usual, and it stays true to the signature difficulty curve. I recommend it.

Second is a font sighting sent by a friendly Internet stranger. This one is from a fairly popular (18M views this month) music video called Fresa, which features Columbian Reggaeton artist Lalo Ebratt. A sighting in such a video would be interesting, but the wildest thing is where it is:

Hello again! I got a little bit stuck on my most recent project because I don't have the right tools to do it the best way, which has created a sort of analysis-paralysis, but I like to think that one is wrapping up. Of course I still need to make a video which will take 9999 hours. Winter's computational space heater made a decent discovery, which is an Arithmetic Progression of Primes. An AP is some starting number x, and some positive stride s, where a progression of numbers in this sequence are all prime:

6月13日(土)開催バースデーライブ！「KIMERU Live 2020 Halloween Party Birthday」の告知動画が完成しました！！ ライブ様子を見るだけでうずうずしますね!チケットをまだお持ちでない方に朗報です♪本日より yahoo!チケット先行 の受付開始★受付期間は4月20日(月)まで！そして、現在 アニメイト特別先行 も受付中！こちらは1週間限定先行で購入者には特典で"サイン入り仮装衣装ブロマイド”が会場にて貰えます!!ライブ当日に着用する仮装衣装のブロマイドに直筆サイン！4月12日までの限定先行なのでこの機会に今すぐお申し込みを！ ハロウィン×KIMERUバースデーのライブ！KIMERUは仮装衣装でのライブ♪ ハロウィンライブは2012年以来のようで、なんと8年ぶり!!前回はドラキュラや早着替えで魔女風仮装をしてました♪今回はどんな衣装で登場するのかお楽しみ!! 6月はみんなで楽しい時間を過ごしましょう★===================KIMERU Live 2020 Halloween Party Birthday◇日程2020年6月13日(土)　OPEN 12:30/START 13:00◇会場青山RizM◇チケット ※別途ドリンク代・スタンディング　 5,500円◇チケットお申込み <先行発売> ※抽選●アニメイト特別先行 <受付中！>申込URL:https://www.animate-onlineshop.jp/pn/pd/1776119/受付期間：4月4日（土）10:00～4月12日（日）23:59当落入金：4月15日（水）～4月19日（日）23:59特典：サイン入り仮装衣装ブロマイド●Yahoo!チケット先行 <受付中！>申込URL：https://ticket.yahoo.co.jp/tour/00004935/受付期間：2020年4月7日(火)15:00～4月20日(月)23:59当落入金：2020年4月25日(土)15:00～4月29日(水)23:59 ===============続きをみる

『著作権保護のため、記事の一部のみ表示されております。』

6月13日(土)開催のバースデーライブ！「KIMERU Live 2020 Halloween Party Birthday」のyahoo!チケット先行の受付が本日4月20日(月) 23:59まで！まだチケットをお持ちでない方はお申込みを急げ！ 「KIMERU Live 2020 Halloween Party Birthday」◇日程2020年6月13日(土) OPEN 12:30/START 13:00◇会場青山RizM ◇チケット　※別途ドリンク代・スタンディング　 5,500円●Yahoo!チケット先行 <受付中！>申込URL：https://ticket.yahoo続きをみる

『著作権保護のため、記事の一部のみ表示されております。』

I almost never do sponsored posts on this blog because I hate reading them on other people’s blogs so I only do it if it’s a product that I truly adore and think you’d love too.  I’ve written before about … Continue reading →

Did one of the most difficult things I’ve ever done: I cut up my mother’s wedding dress. Now, Mom always *loathed* her wedding dress. Her mother talked her into a waltz length, ballerina-y dress, and she never enjoyed looking at her wedding pictures. She put it in her cedar chest and never looked at it. […]

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.

I had a small dip in productivity this week. I think I mentioned that at the end of last summer I had shingles. It was a super mild case, but I wound up with something called “post-herpetic neuralgia” which is basically nerve pain. It’s super well-controlled with gabapentin, which also has some positive effects on […]

This is the Call for Nominations for the 2019 Theszie Awards (the rec.sport.pro-wrestling Awards). To nominate candidates for all categories, you may use this form. Nominations are due by January 5, 2019. Finally, to see previous years’ results, click here for 2018, click here for 2017, here for 2016, here for 2015, here for 2014, […]

This is the Call for Votes for the 2019 RSPW (Theszie) Awards. You can vote here. The Theszies are the oldest fan awards in pro wrestling history, going back to 1990 (when Mr. Perfect quite appropriately won Best Wrestler and Junkyard Dog v. Ric Flair at Clash of the Champions XI won Worst Match). They […]

A convocation of the Lover Triad of United States Grand Lodge will be held in Cleveland, Ohio, August 14-16 2020. Registration for the convocation is now open. See this site for more information.

Do what thou wilt shall be the whole of the Law. Greetings on the First Day of the Writing of the Book of the Law! Due to the ongoing economic impact of the Coronavirus pandemic, the International Supreme Council of Ordo Templi Orientis, in consultation with the Grand Lodges, is implementing the following measures to …

Continue reading