{"id":51660,"date":"2015-07-03T00:09:59","date_gmt":"2015-07-03T06:09:59","guid":{"rendered":"http:\/\/hill-kleerup.org\/blog\/2015\/07\/03\/the-perils-and-pitfalls-of-y2gay.html"},"modified":"2015-07-03T00:09:59","modified_gmt":"2015-07-03T06:09:59","slug":"the-perils-and-pitfalls-of-y2gay","status":"publish","type":"post","link":"https:\/\/hill-kleerup.org\/blog\/2015\/07\/03\/the-perils-and-pitfalls-of-y2gay.html","title":{"rendered":"The Perils and Pitfalls of "Y2Gay""},"content":{"rendered":"

This is a lovely article on how you represent marital relationships in a database — and how you have to keep coming revising your database schema as the definition of marriage change: http:\/\/qntm.org\/gay<\/a><\/p>\n

The lesson to take from all this (if you can follow it along, and I tink it's pretty understandable for much of the way) is that how you structure your data constrains what you can do with it. This is something any programmer or database admin is painfully aware of.("Oh, you know that condition we said last week would never, ever happen? Well, one VP wants to allow it just for his office and on alternating Tuesdays. Can we have that updated by next Monday.") Poor planning and inflexible implementations can't stop the march of history for long, but it can sure make life difficult for those being dragged along in it.<\/p>\n

This was written back in 2008. The author made an update at http:\/\/qntm.org\/support<\/a> after the SCOTUS decision on marriage equality in Obergefell v. Hodges.<\/i> Also fun.<\/p>\n

(h\/t +<\/span>George Wiman<\/a><\/span> and several others)<\/p><\/blockquote>\n

<\/a><\/div>\n
\n<\/a>\u00a0\n<\/div>\n

View on Google+<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

This is a lovely article on how you represent marital relationships in a database — and how you have to keep coming revising your database schema as the definition of marriage change: http:\/\/qntm.org\/gay The lesson to take from all this (if you can follow it along, and I tink it's pretty understandable for much of … Continue reading “The Perils and Pitfalls of "Y2Gay"”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":51661,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[106],"tags":[],"class_list":["post-51660","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-plusposts"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/hill-kleerup.org\/blog\/wp\/wp-content\/uploads\/2015\/07\/isner_jefferson_and_martha_wv_marriage_ledger5B15D.jpgimgmax=660.jpg","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6964,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/11\/23\/databases.html","url_meta":{"origin":51660,"position":0},"title":"Databases","author":"***Dave","date":"Tue 23-Nov-04 6:59am","format":false,"excerpt":"Interesting article via BoingBoing on the economic justification of database copyrights. Under US law, databases of unoriginal material cannot be copyrighted -- nobody can copyright the basic phone and address...","rel":"","context":"In "Media Moguls"","block_context":{"text":"Media Moguls","link":"https:\/\/hill-kleerup.org\/blog\/category\/media\/media-moguls"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13744,"url":"https:\/\/hill-kleerup.org\/blog\/2009\/02\/16\/nobody-expects-the-error-establishing-a-database-connection-message.html","url_meta":{"origin":51660,"position":1},"title":"Nobody expects the “Error establishing a database connection” message!","author":"***Dave","date":"Mon 16-Feb-09 10:16am","format":false,"excerpt":"Evidently this is a not-wildly-uncommon error that WordPress gets. Something happens to disturb the userid\/password\/host database connection, and suddenly (the downside to a fully dynamic system) there is no blog. That this came up first thing in the morning for me was\u00a0a bit embarrassing. Fortunately, I was exchanging messages (on\u2026","rel":"","context":"In "Blogging - Technical"","block_context":{"text":"Blogging - Technical","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/blogging-technical"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3150,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/07\/31\/people_unclear.html","url_meta":{"origin":51660,"position":2},"title":"People Unclear on the Concept","author":"***Dave","date":"Wed 31-Jul-02 8:41pm","format":false,"excerpt":"A German court has ruled that search engines deep linking directly to news stories is against EU law. The law in question is the \"Database Directive,\" a piece of European...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2407,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/06\/28\/under_construct.html","url_meta":{"origin":51660,"position":3},"title":"UNDER CONSTRUCTION","author":"***Dave","date":"Fri 28-Jun-02 6:27pm","format":false,"excerpt":"I'm going to be upgrading to MovableType 2.2 this evening, doing a backup first and all. There's a finite chance the database could get zorched, so if you post something...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2429,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/06\/26\/rfq.html","url_meta":{"origin":51660,"position":4},"title":"RFQ","author":"***Dave","date":"Wed 26-Jun-02 9:06am","format":false,"excerpt":"I have a quotations database which I call WIST (Wish I'd Said That). I keep it online here. It's a pride and a joy and a pain in the ass...","rel":"","context":"In "Quotations (WIST)"","block_context":{"text":"Quotations (WIST)","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/wist"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2958,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/08\/29\/cant_win_for_lo.html","url_meta":{"origin":51660,"position":5},"title":"Can’t win for losing","author":"***Dave","date":"Thu 29-Aug-02 10:02am","format":false,"excerpt":"I mentioned the other day the quotations database I have. My biggest problem that I have with it (aside from its care and feeding) is actually publishing the damned thing....","rel":"","context":"In "Quotations (WIST)"","block_context":{"text":"Quotations (WIST)","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/wist"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/51660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/comments?post=51660"}],"version-history":[{"count":0,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/51660\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media\/51661"}],"wp:attachment":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media?parent=51660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/categories?post=51660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/tags?post=51660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}