Productivity Sauce

Dmitri Popov
Manage MySQL with Consummate Ease Using SQL Buddy

Jan 19, 2011 GMT

phpMyAdmin is probably the most popular Web-based tool for managing MySQL databases, but it is definitely not the only fish in the sea. In fact, if phpMyAdmin's interface is not your cup of tea and the tool itself is overkill for your needs, then you'd be better off using something like SQL Buddy. This lightweight tool sports a slick user-friendly interface that puts all essential management features at your fingertips. Better yet, SQL Buddy is ridiculously easy to install. Grab the latest version of the application, unzip the downloaded archive, move it to your server, and SQL Buddy is ready to go. As any database management tool worth its salt, SQL Buddy lets you create, edit, and...
Tibesti: Screencasts the Easy Way

Jan 14, 2011 GMT

Thanks to Tibesti, creating screencasts doesn't have to be a chore. This tiny utility lets you record desktop activity with a minimum of effort. Installing Tibesti on Ubuntu is a simple three-command affair: sudo apt-add-repository ppa:ackondro/tibesti sudo apt-get update sudo apt-get install tibestiTibesti is designed to be as straightforward in use as possible. The main window provides access to the most important settings, including output format, quality, and recording mode. In addition to OGG, Tibesti supports the WebM, AVI, and H.264 formats, and the utility can capture both video and audio. The Options window lets you configure the tool's options. Here you can enable or disable...
Back up MySQL Databases with a Simple Bash Script

Jan 12, 2011 GMT

If you host your own blog or any Web-based application running on the Apache/MySQL/PHP stack, you should have a backup system in place for keeping data stored in MySQL databases safe. There are several solutions that can help you with that, but nothing beats a simple Bash script I stumbled upon in a blog post comment. Here is the script in all its beauty: #!/bin/bash NOW=`date +"%Y-%m"`; BACKUPDIR="location/of/your/backup/dir/$NOW"; ### Server Setup ### #* MySQL login user name *# MUSER="user"; #* MySQL login PASSWORD name *# MPASS="pass"; #* MySQL login HOST name *# MHOST="your-mysql-ip"; MPORT="your-mysql-port"; # DO...
Turn Google Chrome into a Text Editor with Write Space

Jan 07, 2011 GMT

The Write Space app for Google Chrome and Chromium can come in rather handy when you need to quickly scribble down a note without leaving the browser. Once installed, Write Space adds a no-frills text editor to the browser. Despite its simplicity, Write Space has a handful of nifty features. For example, the persistent auto-save function saves the text file on every key press, so you don't have to worry about losing your changes. Write Space also offers live document statistics, such as number of words, line, and characters. You don't need an Internet connection in order to use Write Space, and the app saves text files locally. Write Space also makes a great tool for users practicing the...
Use GoogleCL to Upload Photos to Picasa Web Album

Jan 05, 2011 GMT

If you are using Google's Picasa Web Album photo sharing service and you want to automate the process of uploading photos, the GoogleCL command-line toolset can come in rather handy. Once installed on your machine, you can use it to perform several tasks such as creating albums, uploading and tagging photos, downloading photos, etc. directly from the command-line. Better yet, GoogleCL is pretty straightforward in use. For example, you can upload all photos in a directory to a specific album using the following command: google picasa post --title "Travel Photos" /home/user/photos/*.jpgIf the specified album doesn't exist, GoogleCL automatically creates it for you. When you run...
Manage Amazon S3 with DragonDisk

Dec 28, 2010 GMT

Amazon S3 provides ample storage at bargain prices, but to put the service to practical use, you need a client software. There are a few command-line utilities out there that let you manage your S3 storage space, but if you are looking for a graphical client, then you might want to give DragonDisk a try. This graphical S3 client allows you to manage buckets as will as synchronize local directories with S3 buckets. Although DragonDisk is not released under an open source license, it's available free of charge, and it runs on Linux. There is a .deb binary package for Ubuntu and Debian uses as well as a tarball package for other Linux distros. You can use the latter on Ubuntu, too. To run...
Tomdroid: Now with One-Way Sync

Dec 20, 2010 GMT

The version of Tomdroid covered in a previous blog post lacked any advanced features like the ability to sync notes. A lot has changed since then, though. The Tomdroid developers have released a new version of the app which boasts a couple of improvements and new features. The most notable addition is the synchronization feature which supports syncing with the Tomboy Web service and SD cards. For now, the synchronization feature can handle only one-way syncing, though. Using the synchronization feature is supremely easy. Press the Menu hardware button, tap on Settings, and select the desired service. If you want to sync notes with the Tomboy Web service, you must authenticate the Tomdroid...

Issue 188/2016

Buy this issue as a PDF

Digital Issue: Price $9.99
(incl. VAT)