Here’s a little snippet which mysqldumps only the databases with a specific prefix or another wildcard expression under windows command line or windows batch.
for /f %%i in ('c:xamppmysqlbinmysql -uroot -pmysql -e "SHOW DATABASES LIKE 'prefix_%%'"') do set myvar=!myvar! %%i
c:xamppmysqlbinmysqldump.exe -u root --password=mysql --databases %myvar:~10% | "c:Program Files (x86)gzipgzip.exe" > "C:WHEREEVERYOUWANTmysqlbackup-%date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.gz"
Here is a new Version of my rotating Knob. It now uses Bluetooth Low Energy aka BT 4.0 to communicate to the iOS device. I’m using the BLE Shield by RedBear Labs. I also coded a native App to have access to the iOS music library. So now it kan be used as a replacement for that cool, but expensive, infotainment systems integrated in cars. Mine doesn’t have one. On the other side Toyota’s infotainment systems aren’t cool. Hey guys take a look at Audi or BMW. And last but not least it has a new case with an aluminium knob. It looks very nice now. In addition it is enough space to put in a 9V battery to use it completely wireless.
You know, I’m addicted to rotating knobs. And this is my new version. This one works over Wifi. So it works for desktop and mobile, native and Adobe Air. It is build with an Arduino Leonardo, a RedFly Wifi Shield and a ProtoShield with 10 buttons, 1 rotary encoder and 3 LEDs.
On the software side I’m using the OSC protocol over UDP which is very fast and responsive.
The challenge: How to distribute additional content-packages for an Adobe Air App for iOS and Desktop.
The Answer: Inspired by this article I started coding my own ActionsScript tar version to unpack gnu-tar files. This format has some benefits. First it is one file, easy downloadable and shareble. Because it’s uncompressed, it is faster than any compressed format like zip. This doesn’t really matter because all files in my packages are compressed files like jpeg. I unpacked a 350 MB file on an iPad 2 in 18 seconds. Additionally it is very fast to extract only one file or data out of it, maybe for some metainformation. Possibly there is some potential to optimize the speed. It’s a common used format, so packing tools are available on all plattforms (Windows, Mac OSX and Linux). Because of this there is no need to code a special packing tool.
I baked my very first AIR iOS Native Extension. It’s just an adapted version of this version from Adobe. Because in my opinion the data of radians per second aren’t really good to handle. So I looked into Apples API documentation and found out that there are Euler Angles in the CMMotionManager CMDeviceMotion classes. So I just changed a few lines in the Objective-C Code. I learned much from this tutorial Native Extionsion for Adobe AIR and iOS 101 by Liquid Photo
A new feature in Flash Player 11 and Adobe AIR 3 is the feature to use JPEG XR. A enhanced JPEG format.
But how to generate or convert JPEG XR files. I found no Photoshop Plugin. All open source tools aren’t able because of licensing problems. The only tool i found is XN View, which can convert PNG files including the alpha channel to JPEG XR.
But you have to use the “Batch Convert” tool. Only there is the option to convert to JPEG XR.
After converting you can load and use the JPEG XR files via Actionscript. e.g. with a Loader or via embedding. It behaves like a PNG file but with much smaller size while keeping very good quality.
“We need a small iPad app. Just four buttons, every button opens a video. Today!”
I thought, “OK”. I had only a freshly installed Mac and an Apple developer account. Continue reading >>>