Viewing entries tagged with 'sqlite'

Adobe AIR SQLite ORM

Posted by Alexis on 21 March 2011 | 0 Comments

Tags: , , ,

Quick update and interesting note. I've been blogging about AIR and SQLite databases, and recently I've had to put together an analytics tracking library for AIR (currently Google Analytics only supports Flex apps, it needs the DOM to function).

0 comments | Read the full post

Interger Primary Key as Rowid SQLite

Posted by Alexis on 17 January 2011 | 1 Comments

Tags:

Interesting quirk about SQLite table PRIMARY KEY's. I've been using ID as my table KEY name, a habbit adobted from MySQL. And in recent SQLite development I've been using

1 comments | Read the full post

Insert Or Update if row exists AIR SQLite

Posted by Alexis on 16 January 2011 | 0 Comments

Tags: ,

OK leading on from the previous post, here's a solution for the INSERT or UPDATE if row exists which seems like a very common question in forums.

0 comments | Read the full post

3115 Error with SQLite

Posted by Alexis on 16 January 2011 | 0 Comments

Tags: ,

I'm doing some work with SQLite in Adobe AIR. Doing some tests to figure out a cleaver TRIGGER to UPDATE or INSERT appropriately.

0 comments | Read the full post