Improvements to online databases coming soon!

At home, I maintain my book collection, reading list, and story submissions databases within MySQL on my iMac. I have scripts that take this data and either build static pages, or create flat files that can be used by perl or PHP scripts to present the data on my website. Currently, my reading list is of the former category, static pages updated nightly. My book collection and story submission log are of the latter category, where flat files of the data are uploaded nightly and the data is presented via perl scripts on the website.

As of this morning, I have signed up for the MySQL database service offered by my ISP, Panix. With this service, I can maintain all of this data in MySQL databases hosted by my ISP and access these databases via Perl, PHP, Python, and C. What all of this means is that in the coming weeks, there should be some dramatic improvements to the capabilities you will see in these three databases, better searching, richer information, some pretty cool stuff.

Developing the public-facing code is not the problem (after all, I make a living doing application development, most of which involves databases). Finding the time to develop the public-facing code is another issue. But keep your eyes peeled for these changes. I’ll be sure to announce them as they are completed.

About Jamie Todd Rubin

Jamie Todd Rubin writes fiction and nonfiction for a variety of publications including Analog, Clarkesworld, The Daily Beast, 99U, Daily Science Fiction, Lightspeed, InterGalactic Medicine Show, and several anthologies. He was featured in Lifehacker’s How I Work series. He has been blogging since 2005. By day, he manages software projects and occasionally writes code. He lives in Arlington, Virginia with his wife and three children. Find him on Twitter at @jamietr.