TechSparx Technology News

Subscribe by email (Delivered by FeedBurner):

Setting up LibreOffice to access MySQL database with JDBC driver

I wanted to try using LibreOffice Base on Mac OS X to play with a MySQL database. I thought it would be easy, just connect to the database and start doing queries, maybe even pull data into a LibreOffice spreadsheet for advanced data munging. But doing the obvious thing got me messages like "No Java Installation found" and "the driver class com.mysql.jdbc.Driver could not be found". Further, yahoogling with some obvious search phrases turned up nothing.

Upgrading or replacing battery pack, SSD and other parts on Acer C720 Chromebook's

I have owned an Acer C720 Chromebook for a couple years now and in many ways it's the best computer I've ever owned. It's small and light and is easy to carry around anywhere. The keyboard and trackpad are excellent. The screen field-of-view leaves something to be desired, but when viewed head-on the screen looks good and the sound quality is acceptible. I do a lot of writing and software development and web browsing and image editing and related work, and have solutions to do everything (including software development) on the Chromebook.

How to restore a MySQL database and tables from .frm .ibd or .myd raw database files

powered-by-mysql-167x86.pngConsider a situation - you've got a well tuned MySQL database server running some popular websites. The sites are implemented with Drupal and Wordpress, but using MySQL to store the content and settings. You think everything is fine, until one day you look at Google Analytics and are aghast to see zero traffic for the previous two days. You go to the websites and are greeted by a 404 error, with the server saying there's nothing there.

If Wordpress is switching from PHP to Node.js, how should they do it?

wordpress-logo-stacked-rgb.pngnodejs-dark.pngSupposedly the Wordpress team is migrating Wordpress from PHP to Node.js. That astonishing bit of news comes from, but the evidence presented isn't exactly compelling.

Headless Wordpress/Drupal is galloping into view with Sleepy Hollow references tagging along for the ride

wordpress-logo-stacked-rgb.pngHeadless Wordpress is becoming a thing, now that Wordpress 4.4 has been released and has some core support for a REST API. The Drupal world has seen Headless Drupal work for a couple years now, and the Wordpress community has seen the light as well. The advantages of decoupling the website rendering from content management are many, the biggest perhaps being the rapidly changing best practices landscape for delivering content to the display device.

Hell Bent from Gallifrey straight to Big Finish - Maisie/Jenna as Me/Clara from now til the end of time

p039ph43.jpgWhatever else we make of the Doctor Who Season 9 finale, one thing is clear: Maisie Williams and Jenna Coleman have a long career ahead of them playing immortals "Me" and Clara, traveling the universe in their own TARDIS. That's how the episode ended, eh? Clara insisting on a return to Gallifrey to finish things, but to take the long way around.

Revisiting software development on Chromebooks - rapidly improving state of Chrome apps for developers

Chromebooks make surprisingly great laptops for software developers. If you don't know much about the Chromebook model, you might dismiss it as just a web-browser with delusions of grandeur. I'm a long-time software developer, writing code for a living since the mid-80's primarily on Unix/Linux/MacOSX systems, and I've pretty much abandoned my MacBookPro in favor of a Chromebook. The Chromebook is much faster than the MacBook (primarily due to the SSD drive), and lots lots lots cheaper to buy/own than any MacBook or MacBookPro.

Drupal Book node hierarchy went missing, necessitating database patching and a couple scripts to help

Twice now I've had the Book hierarchy on a Drupal 6 site go bonkers. The first time was on this very site, back in 2009, while this site was being converted from Drupal 5 to Drupal 6 (it's now on Drupal 7). The /book page simply became empty, and I managed to fix the book hierarchy with some database twiddling. That was over six years ago and I'd since converted this site to Drupal 7. I have another site still running Drupal 6, and the same problem (empty /book page) just happened on that site.

Let's Kill Davros! Or, a review of Doctor Who S09E01, the Magicians Apprentice

p032kxgr.jpgIf someone pointed out to you a little boy, as innocent as could be, and you knew that boy would grow up to create the most evil the universe ever saw, would you kill that little boy and prevent that evil? Yes or No. And what would either answer make you to be? If you're The Doctor, and you're suddenly in the middle of a horridly crazy war that looked like World War I trench warfare but had biplanes shooting laser canons, and you met a scared little boy who was about to die, what would you do?