Regarding that link you posted: The creation of a SQLite Database has nothing to do with XML, nor is XML needed. What you see there is a MXML document, a special XML flavor introduced by Macromedia/Adobe. But the majority of this document is just plain Actionscript 3 (wrapped in
So you're going to use Actionscript to create and access the Database. But since you're new to the whole database thing, I suggest you first take a step back and actually learn some SQL. This is going to be easiest by using a tool that allows you to create Databases and run queries. There's even a Firefox addon that allows you to manage SQLite databases from within your Browser.
Once you are comfortable with SQL (you can also look up the exact syntax for SQLite here), the step to using this in Actionscript is really small, because in Actionscript you do nothing else than sending SQL queries (so it's actually good practice to learn the query syntax before you integrate it into more complicated code).
The help documents over in the Adobe Flash help should contain enough information to show you how to use SQLite in Flash/Flex.
Update: Here's a short explanation of the most important SQL commands and when you're typically going to use it in your application.
When your application starts up, you should check if the Database already exists. If not, you can create one using
CREATE TABLE. With
CREATE TABLE you specify all the database fields and their types. This can be quite complicated at first, but some of the tools linked above allow you to create the table using a GUI and then "export" the SQL create statements. Example:
CREATE TABLE myTable (
id INTEGER PRIMARY KEY,
To read data from one (or multiple) tables, use
SELECT * FROM myTable
To write to a table, use
INSERT INTO myTable (id, name) VALUES (1, 'Foo')
To update data, you use the
UPDATE statement. Example:
UPDATE myTable SET name = 'Bar' WHERE id = 1
To delete data, there's the
DELETE statement. Example:
DELETE FROM myTable WHERE id = 1