mysqldump windows command line only databases with prefix

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.

@echo off
setlocal enabledelayedexpansion
set myvar=
for /f %%i in ('c:xamppmysqlbinmysql -uroot -pmysql -e "SHOW DATABASES LIKE 'prefix_%%'"') do set myvar=!myvar! %%i
echo %myvar:~10%
@echo on
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"
Video

THE KNOB III – BlueTooth 4.0 aka BLE

4 Comments

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.

Video

THE KNOB II – Wifi-Hardware

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.

AS3 Simple UnTAR

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.

And last, I want to share this with you:

AS3 Simple Untar on Google Code

Have fun with it.

Adobe AIR Gyroscope Native Extension with Euler Angles (roll, pitch, yaw) for iOS

24 Comments

UPDATE: I have released the extension including source on google code with some changes.
Euler Gyroscope ANE on Google Code

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

NSString *myStr = [NSString stringWithFormat:@"%f&%f&%f&%f&%f&%f", 
rotate.x, 
rotate.y, 
rotate.z, 
motionManager.deviceMotion.attitude.roll, 
motionManager.deviceMotion.attitude.pitch, 
motionManager.deviceMotion.attitude.yaw];

[motionManager startDeviceMotionUpdates];

motionManager.deviceMotionUpdateInterval = 0;

And added these three parameters roll, pitch and yaw to the Actionscript Gyroscope Event.

new GyroscopeEvent(GyroscopeEvent.UPDATE, _x, _y, _z, _roll, _pitch, _yaw)

You can download source and final iOS .ane Native Extension file here:
iOS Air Native Extension Gyroscope – with Euler Angles

Convert PNG to JPEG XR for use in Flash / Flex and AS3

1 Comment

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.

Adobe AIR 3: How to build a Captive Runtime, Standalone Bundle Executable App

1 Comment

The challenge was to build a Adobe Air 3 Standalone Executable. Also called a „Captive Runtime“ or a Bundle.

Here are some better descriptions:
http://www.adobe.com/devnet/air/articles/air3-install-and-deployment-options.html

But it was not so easy as it sounds because the order of the adt options are very important!

If the order isn’t correct you get the error „-storetype is required„.

And if you are behind a firewall or no internet connection, the timestamp server isn’t reachable. So use „-tsa none“ if you get „Could not generate timestamp: Connection timed out: connect„.

Here is my ant task which do the job with the correct order. But the order of the options in a terminal command should be the same.

<target name="07. [package exe]">
	<mkdir dir="${publish.dir}"/>
	<input message="certificate password:" addproperty="certPassword" />
	<java jar="${sdk.dir}/${adt}" fork="true" failonerror="true" dir="${deploy.dir}/">
		<arg value="-package" />
		<arg value="-keystore"/>
		<arg value="${air.certificate}"/>
 
		<!-- NATIVE_SIGNING_OPTIONS -->
		<arg value="-storetype"/>
		<arg value="pkcs12"/>
		<arg value="-storepass"/>
		<arg value="${certPassword}"/>
		<!-- <arg value="-tsa" />
		<arg value="none" /> -->
		<arg value="-target" />
		<arg value="bundle" />
		<!-- Name Of File To Create-->
		<arg value="${publish.dir}/${publish.exe}" />
		<!-- App Descriptor-->
		<arg value="${application.descriptor}" />
		<!-- Files To Package -->
		<arg value="Icon*" />
		<arg value="Default*" />
		<arg value="iTunesArtwork.png" />
		<arg value="-C" />
		<arg value="${deploy.dir}/" />
		<arg value="${deploy.swf}" />
	</java>
</target>

Hope this helps some people having the same problems.