Our Blog

Mobile App development with Corona SDK

by sly May 02, 2011 08:22

Technoponics has selected the Corona SDK technology for its iPhone, iPad and Android projects.

Created in 2007 par the minds behind Adobe Flash, Corona SDK is first and foremost a game development tool. But since we believe that every mobile application should have a gaming aspect to it, Corona SDK is a perfect fit.

Corona SDK also allow simultenous development of both the iOS and Android environment.

We will publish on this blog our experiences in this new world we call Corona SDK !

 

 

 

 

 

 

 

.

Tags:

English | Software

Développement Mobile avec Corona SDK

by sly May 02, 2011 07:57

 

Technoponics a choisi la plateforme de développement mobile Corona SDK pour ses projets iPhone, iPad et Android. 

Créé en 2007 par les leaders de l'équipe Flash d'Abobe, Corona SDK est à-priori une technologie destinée à programmer des jeux. Mais nous croyons que toutes applications mobiles doivent, à quelque part, être un jeux. 

Corona SDK nous permet aussi de développer simultanément pour iOS et Andoid dans la plupart des cas. 

Nous publierons dans notre blog nos expériences et découvertes dans ce nouveau monde qu'est celui de Corona SDK  !

 

 

 

 

 

 

 

 

.

JQUERY version 1.5

by sly February 14, 2011 08:45

La nouvelle version 1.5 de Jquery est disponible.  Grace à l'option Deferred on peut maintenant faire des "callbacks" consécutifs..woohoo

Tags:

Coding | Français

JQUERY 1.5

by sly February 14, 2011 08:43

Just released : Jquery 1.5 , with the new Deferred option for multiple callback...woohoo

http://blog.jquery.com/2011/02/07/jqcommunity-updates-feb2011/#jqreleased 

Plus a preview of the official Jquery UI Grid.

Tags:

Coding | English

CSV Strings in SQL

by BillyTheKid August 18, 2010 06:35

I’m working on a webservice that will receive a comma separated list of ID’s and return XML and was concerned about the performance of the function I had been using in SQL to split a string into a table to join and select records.

I have been using a pretty basic iterative function that uses CHARINDEX and SUBSTRING, acceptable for small strings, but it was not going to work for this project.

Thankfully I found a CLR function in c# which has amazing performance.  Credits to Adam Machanic over at SQLBlog.  Find the code in his post here

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx

To use his code, the first thing you will need to do is copy the class into a .cs file and compile it:

csc /target:exe sql_split_clr.cs

If the c sharp compiler is not in your path, add it.  For SQL 2005 you want to use the framework version 2.

set path=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727;%PATH%

CLR functions and procedures are disabled by default in SQL 2005.  If you have not yet enabled it, use the following

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

 

You will then need to create the assembly and functions in SQL like this:

CREATE ASSEMBLY SQL_Split
FROM 'c:\clr\sql_split_clr.dll'
GO

CREATE FUNCTION string_to_list(@list nvarchar(MAX),@delim nchar(1) = N',')
RETURNS TABLE (item nvarchar(4000))
AS EXTERNAL NAME SQL_Split.UserDefinedFunctions.SplitString_Multi
GO

Now the new CLR function should be ready to use

SELECT * FROM dbo.string_to_list('a,b,c,d,e',DEFAULT)

As a final aside, what’s with having to specify the DEFAULT keyword to use the default parameter value on functions.  You don’t have to with stored procedures.

Tags: , ,

Coding | English

More on Videos and HTML 5

by BillyTheKid June 15, 2010 08:37

After my last blog post on videos Encoding H264 for the iPhone I ran into a little issue with the videos I was encoding when trying to stream to the iPhone it would say "Movie could not be played".   The only difference I could see between one that I found that would play and mine was the codec, which was set to ISOM, instead of mp42 for one that worked.

It was quite a simple fix actually, just changing -f mp4 to -f ipod in the ffmpeg command line changes the format to M4V which the iPhone will stream without issue.  FFMpeg makes a minor complaint about using a .mp4 extension with m4v format, but it all works fine.  Credits to the Metal Toad Media blog for the fix.

Now we have H264 encoded .mp4 files which can be streamed to Safari or Chrome, as well as the iPhone.  Here is a very simple example of the HTML 5 video tag.

<html>
<head>
<title>Video Testing</title>
</head>
<body style="background-color:#FFFFFF; ">
<center>
<video controls>
<source src="http://www.technoponics.com/media/expo67.mp4" type="video/mp4">
</video>
</center>
</body>
</html>

Encoding H264 video for iPhone streaming with ffmpeg

by BillyTheKid May 21, 2010 05:43

The first thing you need to know is that to stream a video to the iPhone using progressive downloading you will need to use 2 pass encoding.  There is something called the MOOV atom which needs to be at the beginning of the file, but can't be created until after the encoder has been through the entire source file at least once.  Pres umably bitrates, metadata etc, need to be pre-calculated, but that's just a guess.  If you come across something called qt-quickstart which will move the MOOV atom, avoid it, just take the time/cpu cycles to do a 2 pass encoding, the videos look better anyway.

Make sure you have a recent build of ffmpeg which has the ffpresets directory.  I'm currently using Rev 18639 from Tripp's unofficial win32 builds.  One thing to note, on Windows, you have to specify the full path to the preset file, in the -vpre parameter, and put it in double quotes, like in my example below. 

On the first pass ffmpeg will create a log file in the current directory that it uses during the second pass.  You will see examples on the internet for 2 pass encoding that have an output file for the first pass, but it is unnecessary, we only need the log file so you should specify NUL to save the hard drive I/O.  On Linux you’d use /dev/null.

For this little test, I have downloaded a 60 second public domain newsreel clip from 1967 discussing the opening of the world expo held in Montreal that year.  Head on over to the National Film Board (NFB) website to get any number of videos you can try converting.  The NFB video was 720x480, but the iPhone supports only 640x480 video up to 1500k bitrate.  In my example I’m scaling the video down to 640x428 and padding the top and bottom with 26 pixels. 

Here is the command for pass 1:

ffmpeg -y -i Expo67.mpg -f ipod -pass 1 -vcodec libx264 -s 640x428 -padtop 26 -padbottom 26 -r 30000/1001 -vpre "D:\utils\ffmpeg\ffpresets\libx264-fastfirstpass.ffpreset" -vpre "D:\utils\ffmpeg\ffpresets\libx264-ipod640.ffpreset" -b 250k -bt 50k -bf 0 -an -threads 0 NUL

The b and bt parameters are bitrate and bitrate tolerance, which you might want to increase for your video.  The –bf 0 parameter turns b-frames off, the iPhone does not support H.264 b-frames.  Adding it here prevents an error when encoding the 2nd pass.  The –an parameter turns audio off, which we won’t encode until the second pass.

Here is the command for pass 2:

ffmpeg -y -i Expo67.mpg -f ipod -pass 2 -vcodec libx264 -s 640x428 -padtop 26 -padbottom 26 -r 30000/1001 -vpre "D:\utils\ffmpeg\ffpresets\libx264-hq.ffpreset" -vpre "D:\utils\ffmpeg\ffpresets\libx264-ipod640.ffpreset" -b 250k -bt 50k -acodec libfaac -ab 56k -ac 2 -ar 22050 -async 1 -threads 0 Expo67.mp4

The trick here is to use two ffmpeg presets at the same time, fastfirstpass/ipod640 then hq/ipod640 for the second pass, always specifying the ipod640 preset second.

Here is a link to the Expo67.mp4 video, which should stream directly to your iPhone using progressive download.

IPad magique d'Apple

by sly January 28, 2010 04:44

Pour ceux qui l'ont manqué, Apple a enfin annoncé son légendaire appareil style tablette aujourd'hui – disons que département de marketing d’Apple a déjà trouvé mieux comme nom de produit. Si vous ne me croyez pas, faites rapidement une recherche sur Twitter pour #iPad, et préparez-vous à être assailli de jeux de mots d’un goût douteux.

Je dois dire que, bien que je m'intéresse à presque toutes les nouvelles de Apple, je n'étais pas impressionnée par la tablette. Toutes les rumeurs ont indiqué un plus gros iPhone au prix proportionnellement élevé. L'intérêt que j'avais était quelque peu tempéré par ma crainte d'un autre gadget «révolutionnaire» nécessitant un contrat coûteux de trois ans.

En tout, il n'y avait pas beaucoup de surprises chez Apple aujourd'hui.

Les rumeurs étainent assez précises : Steve & Cie nous ont essentiellement livré un iPod Touch de 10 pouces avec quelques ajustements notables, y compris le nouveau magasin de livres iBook, et quelques menus sérieusement ‘Prettified’. La plus grande surprise de la journée était peut-être le prix: prévu depuis longtemps de coûter dans les environs de 1000$, le modèle de base de l'iPad (16 Go, WiFi seulement) a été annoncé à seulement 499 $ USD, le mettant assez proche des autres appareils comme les ‘netbooks’ et ‘e-Readers’ (au moment où j'écris ceci, je me sens encore un peu soulagée de ne pas m'avoir achetée un Kindle DX).

Apparemment, un bon nombre de personnes s'attendaient à une caméra sur cette iPad. Personnellement, je ne suis pas affecté par cette omission. Cela dit, J'aurais préféré d'avoir plus de nouvelles non liées à l'iPad aujourd'hui! J'attendais iPhone 4.0! Et peut-être quelques nouveaux MacBook Pro. Des fonctions multitâches, peut-être?! Pourtant, j'irai quand même chez un Apple Store pour leur donner mon 499 $. Steve Jobs veut savoir si l'on croît qu'il y a un une place dans nos vies pour un autre type d'ordinateur, prise en sandwich entre nos iPhones et nos ordinateurs portables. Fort probable que la réponse est oui - mais je suppose qu'il faut attendre jusqu'en avril pour en être certain.

Note : Ceci est le premier bulletin de Michaela, notre Anglo de service, en Français. Félicitations.

Apple's magical iPad - [insert bad name-related joke here]

by SuperMike January 27, 2010 11:20

For anyone who wasn't paying attention, Apple finally announced its fabled tablet device today - the somewhat unfortunately named "iPad". If you don't believe me, do a quick Twitter search for #iPad, and prepare yourself for the onslaught of bad jokes and puns.

I have to say that, while I'm at least marginally interested in everything Apple does, I wasn't that excited about the tablet. All rumours indicated a big iPhone with an equally big price tag. The interest I did have was somewhat tempered by my equal-or-greater fear of another "revolutionary" gadget requiring me to sell my soul to a carrier for three years.

All in all, there weren't a whole lot of surprises from Apple today.
The Apple rumour machine proved itself fairly accurate: Steve & Co. essentially brought us a 10-inch iPod Touch, with a few notable tweaks, including the new iBook store, and some seriously prettified menus. The biggest surprise of the day was the price point- Long expected to start in the $1000 range, the base model of the iPad (16GB, WiFi only) was announced at just USD$499, putting it pretty close to the land of netbooks and e-Readers (As I write this, I'm still feeling rather relieved that I didn't splurge on that Kindle DX). Folks, this is the couch potato's Mac.

Disappointments? Apparently a fair number of people were anticipating a camera on that shiny new iPad. Personally, I don't think it's essential. That said, MY main complaint is the lack of non-iPad announcements today! I was expecting iPhone 4.0! And maybe some shiny new Macbook Pros! And where's my multitasking?! Still, none of this makes me any less inclined to run, not walk to my nearest Apple Store and give my $499 to the nearest hipster in a coloured shirt. I'm not sure I would use the word "magical" (with any degree of seriousness) to describe a piece of hardware, but Steve Jobs wants to know whether we think there's a space between our iPhones and our laptops for yet another kind of computer. I think there is - But I guess we'll have to wait until April to know for sure.

Tags:

English

Photobombe

by sly November 23, 2009 09:58
Les “Photobombs” sont maintenant mes produits dérivés de l’Internet. Une bombe-photo est essentiellement une photographie qui est ruinée (ou amélioré) par une force externe (un passant, un ami saoul, etc). Allez visiter le site http://thisisphotobomb.com pour découvrir l’univers du ‘Photobombing’ …