
Well, I've finally started work on my old project named "Quincy".
Quincy was a media database/viewing tool. When I first wrote it, it was in C# with MSSQL. It didn't really work that well, since I was basically using SQL to store blob data of serialized objects. This meant that querying for data required me to load and iterate through all of the objects. Yuck...
The project has been renamed to "TukiTuki." It is using Adobe AIR and SQLite for the database handling. I was originally going to use Python to communicate with SQLite database, but commication between Python and AIR was proving to be very difficult. I was really afraid that I was going to have to use Apache with PHP for AIR to get the information. This would really hurt the portability of TukiTuki (although there are ways). Then I found this article about using AIR to talk to SQLite.
Now, this means that all my queries will be written in flash (a HUGE web-app no,no). Usually I would swallow razor blades before doing this, but since it's a desktop application it changes everything. I guess it's because I started programming with internet applications, and am now trying to move to the desktop (which is completely backwards).
I've just finished the database creation (with my rough-sketch schema). I'm excited about releasing this app, because I feel it will get used by a lot of people, and AIR is good way to ensure that it will not be stopped by OS dependencies.
Since I'm using AIR, the formats will have to be in MP3, FLV, or MP4, though. I just started ripping all my DVD to MP4 using Handbrake with AnyDVD (because DVD43 doesn't work with vista64).
More news to come!
Tags: Personal(20) FollowerofJC.com(10)