{"id":127,"date":"2011-09-08T15:21:24","date_gmt":"2011-09-08T20:21:24","guid":{"rendered":"http:\/\/www.alandmoore.com\/blog\/?p=127"},"modified":"2011-09-08T15:27:38","modified_gmt":"2011-09-08T20:27:38","slug":"less-blogging-more-coding","status":"publish","type":"post","link":"https:\/\/alandmoore.com\/blog\/2011\/09\/08\/less-blogging-more-coding\/","title":{"rendered":"Less blogging == More coding"},"content":{"rendered":"<p>So, the blogging has slowed a bit, but that&#8217;s a good thing.  Yes, Episode IV of my &#8220;Reviving your old PC&#8221; series is in progress and on its way.  You gotta wait for quality, folks.<\/p>\n<p>But last night I started and interesting new project that took over my brain and had me up most of the night.  It&#8217;s like this&#8230;<br \/>\n<!--more--><\/p>\n<p>We have a weekly Bible study meeting at the house; a regular part of this event is the singing of a few hymns and praise songs, which I generally lead.  I have a good library of such songs built of from years of participating in praise bands and so forth, but I don&#8217;t have lyrics to pass out for the rest of the group.<\/p>\n<p>So for a while, I&#8217;ve been sticking to short, simple songs that most people seem to know the words to.  I&#8217;ve been meaning to make song sheets for everyone, but it&#8217;s such a wasteful and messy approach to getting lyrics to everyone &#8212; as soon as you make a sheet, you want to sing songs that aren&#8217;t on it, then you make more, and more; before you know it, you have a 30-page booklet with songs in no particular order.<\/p>\n<p>Being a techy kind of guy, I naturally turned to my computer for a more elegant solution.  I spent some time trying to get <a href=\"http:\/\/www.lyricue.org\" title=\"Lyricue: because apparently GNU people go to church too!\">lyricue<\/a> to work with my laptop and TV set (which awesomely has a VGA input), but I couldn&#8217;t get it to work.  I just ended up with black screens. \ud83d\ude41<\/p>\n<p>As I was tinkering with it last night, it occurred to me that as part of my lyricue installation I had a <a href=\"http:\/\/www.lyricue.org\/sites\/default\/files\/english-samples.xmlz\" title=\"Here's the whopping big database, but you need lyricue to import it into mysql.\">whopping big database<\/a> of songs in MySQL.  And here am I, a LAMP developer.  So why not hack together a little <a href=\"http:\/\/en.wikipedia.org\/wiki\/Create,_read,_update_and_delete\" title=\"CRUD doesn't mean it's bad, it's an acronym...\" target=\"_blank\">CRUD<\/a> application in PHP to access this database and display its data nicely in a browser window?  Besides, I&#8217;ve been learning jquery lately and this gave me the excuse to flex those new skills a little.<\/p>\n<p>So, hours of obsessive hacking later, I have a functional little web-app full of javascript\/CSS3 niceties  which I hope to try out tonight.  And when I get a chance, I&#8217;ll toss it up on github for whoever wants to fiddle with the spaghetti.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, the blogging has slowed a bit, but that&#8217;s a good thing. Yes, Episode IV of my &#8220;Reviving your old PC&#8221; series is in progress and on its way. You gotta wait for quality, folks. But last night I started and interesting new project that took over my brain and had me up most of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3,7,5],"tags":[30,29,28],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-blogging","category-general","category-programming","category-technology","tag-javascript","tag-lamp","tag-programming-2"],"_links":{"self":[{"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/comments?post=127"}],"version-history":[{"count":6,"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/posts\/127\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/posts\/127\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/media?parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/categories?post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alandmoore.com\/blog\/wp-json\/wp\/v2\/tags?post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}