Tuesday, April 21, 2015

10 Fun Tools To Easily Make Your Own Infographics

People love to learn by examining visual representations of data. That’s been proven time and time again by the popularity of both infographics and Pinterest. So what if you could make your own infographics? What would you make it of? It’s actually easier than you think… even if you have zero design skills whatsoever.
Below are my two favorite infographic-making web 2.0 tools that I highly recommend. They both have pros and cons but in general are great for any beginner or novice designer. If Photoshop is a 4-letter word to you, then these sites are your friend. If you’re a tech-savvy designer and illustrator, it can’t hurt to check out some of the work on these two sites for inspiration.
10 Fun Tools To Easily Make Your Own Infographics | Edudemic

Converting Microsoft Access MDB Into CSV Or MySQL In Linux

I have recently had reason to convert an Access MDB file to CSV for use in a mysql database. I don't like the idea of an Access database on a production server and Microsoft has been agreeing since 1999.
As it turns out it is actually very easy, there is GPL software available for the job at http://mdbtools.sourceforge.net/. If you are using Ubuntu or Debian you can use apt-get install the mdbtools package.
To get the list of tables, you run the following command:
mdb-tables database.mdb

You can then get a CSV version for each table using:

mdb-export database.mdb table_name

You can also convert the mdb into a format required by MySQL. First you must get the put the table schema into the database using the following command:

mdb-schema database.mdb | mysql -u username -p database_name

You then import each table by running:

mdb-export -I database.mdb table_name | sed -e 's/)$/)\;/' | mysql -u username -p database_name

Sed is required as mdb-export doesn't put a semi-colon at the end of each insert statement,  which MySQL definately doesn't like.

After running this, you can now be rid of the horror that are Access MDB files :)

Converting Microsoft Access MDB Into CSV Or MySQL In Linux - Not Another One!

Tuesday, April 14, 2015

Top 10 Apps to Watch Live TV on Android

Anyone can kill time but it’s the Android users who get to kill quality time. These days we get stuck traveling or waiting and there is no better way to spend idle time than by watching TV. Sure the big bulky TV always sits smugly in our living rooms but thankfully we can take our Android devices with us. With the combination of fast internet connections and an Android device, you will be watching the lazy-tube in no time at all. We have selected the best apps to help you watch live TV on Android, and yes this means you can catch the ball game anytime, anywhere.



Waiting for the doctor or traveling to work suddenly becomes more tolerable when you have Homer Simpson to give you company. Catch an episode of Family Guy while your dinner is getting ready. Is the professor late again? We suggest you take a peek at the latest Game of Thrones episode.



Top 10 Apps to Watch Live TV on Android

Friday, April 3, 2015

Animated Gifs on Linux with ffmpeg and Imagemagick

This post is somewhat inspired by the fact that Google+ now makes cool little gif animations from photo bursts of 5 pics or more when you upload. Very nifty. But, ugh, the images are SMALL and often choppy. What if you want larger picture dimensions, smoother or longer animations? For those who care about making these *ridiculously cute* animations out of mpeg or avi movies from your phone/camera/youtube… this is for you. Just be careful not to use movie clips longer than 15 to 20 seconds or you’ll end up with a huge image file.



Animated Gifs on Linux with ffmpeg and imagemagick | Tommy Butler

Linux Find Large Files

Q. How do I find out all large files in a directory?



A. There is no single command that can be used to list all large files. But, with the help of find command and shell pipes, you can easily list all large files.



Linux Find Large Files

How to Find and Remove Duplicate Files on Linux

Whether you’re using Linux on your desktop or a server, there are good tools that will scan your system for duplicate files and help you remove them to free up space. Solid graphical and command-line interfaces are both available.



Duplicate files are an unnecessary waste of disk space. After all, if you really need the same file in two different locations you could always set up a symbolic link or hard link, storing the data in only one location on disk.



How to Find and Remove Duplicate Files on Linux

Wednesday, April 1, 2015

How can I copy files with duplicate filenames into one directory and retain both files by having the duplicate(s) rename automatically? - Ask Ubuntu

On windows OS, when you copy a file into a directory that already has a file with that name, it asks you whether you want to:



  • copy the file and replace/overwrite the existing one
  • cancel copying the new file into the directory
  • copy the file, but rename it (as something like "filename - copy (1)")


When I do this in Ubuntu, I don't have that 3rd option (which is a lot of times a very useful option). Is there any way to be able to do that in Ubuntu?



How can I copy files with duplicate filenames into one directory and retain both files by having the duplicate(s) rename automatically? - Ask Ubuntu


ffmpeg fit music to video length - Google Search

ffmpeg fit music to video length - Google Search

How can I check the integrity of a video file (avi, mpeg, mp4 and etc)?

This title could be somewhat misleading, so let me explain...



I'm downloading a video file ... mpeg, avi - being one of the popular formats. Now, if I am downloading it, and the download breaks in the middle of the uhm ... download, then, for example, Windows Media Player will give out some error and refuse to play it (although the file is, let's say, 98% complete). But, players like KMPlayer, or MediaPlayer Classic will play it up until that point (as the matter of fact, they can play it while it is being downloaded as well).



So, I'm interested, ... without using any means of download (download managers and alike) to secure the file is completely downloaded, how can one verify whether the video file is downloaded whole, and that it is complete?



How can I check the integrity of a video file (avi, mpeg, mp4...)? - Super User