Flex”i”MMI

Screenshots   |   Get it !   |   Release notes

The SQLite Sorcerer or Darry BotAIR, for intimates, is a small SQLite administration application running with Adobe AIR™.

The SQLite Sorcerer can help you to perform the main administration tasks on your SQLite database:

• Database:
  • Create a new database from scratch, autocompacted or not,
  • Compact, analyze / deanalyse a database
  • Encrypt and rencrypt using a password or an existing hashed key: have a look here to learn more on the feature.
  • Quickly open recently used databases
  • Compare the structure of 2 databases !
    • Just open a second database and the comparison is done !
    • The result of the comparison is displayed in a datagrid with details
    • Transfer items between databases
  • Get the whole SQL code of the database.
• Tables:
  • Create, delete, rename, copy with or without data
  • Edit the structure of a table (use the context menu or double click)
    • Changing all attributes of fields is allowed, including default values
    • Add, delete or rename fields
    • Define conflict clauses
• Data
  • Add, delete or edit records directly in a data grid
  • Filter data using keyword or regular expression
  • View all data or use chunks to browse table content
  • Empty tables
  • Export data from tables or queries into CVS or TXT files
  • Import data from a CSV or TXT file (taking into account of the character set)
    
• Queries
  • Type your sql and check the results
    • Insert field or table names by double click or drag&drop in the SQL text area
    • Define and use snippets to ease your query definition
  • Save your query as a new view
  • Define parameterized queries and execute it for different values
  • Re-execute your queries using the History
  • Import and execute a SQL file
• Views / Triggers
  • Triggers are created in a handy form
  • Views are created from the Query Panel
• The SQL code is highlighted.

Detailed features and screenshots:

Click a screenshot in the picture wall to enlarge it. Pass the mouse over the enlarged picture to get some "how to".

Note:

 The SQLite Sorcerer is developped in Flex 3 for AIR. Its primary intend is to administrate local SQLite databases for AIR applications but not only, I would like it to be as "compatible" as possible. So don’t hesitate to send me feedbacks or bugs.

Pricing

SQLite Sorcerer is free of charge. You are free to download it, use it and distribute it. The application will also auto-update each time a new version is published.

Nevertheless,  if you decide to adopt SQLite Sorcerer as your favorite SQLite administration tool, you may want to make a donation. Especially if you are a company that uses this great tool in a commercial project.

How to make a donation ?

You can donate using the following Donation button 

  or using the donation button in the About (Hat) window of the application.

or you can simply flattr me :

(No Ratings Yet)

 Loading ...

Written by Arnaud
Tags: AIR, Applications, SQLite, SQLite Sorcerer

The SQLite API that is provided by AIR has a very interesting and powerful feature: the loadSchema() method that returns the whole structure of a SQLite database as a SQLSchemaResult class.

The structure of the SQLSchemaResult can be illustrated by the following schema.

This class is composed by 4 arrays: tables containing SQLTableSchema classes, views containing SQLViewSchemas, triggers for SQTriggerSchema and indices for SQLIndicesSchema.

SQLTableSchema and SQLViewSchema contain an array of SQLColumnSchema classes. Each SQLColumnSchema represents the fields in the tables (or views) of the database. This last class has properties as names, allowNull, primaryKey, dataType… that describes the field in the SQLite database.

As I am working on an AIR application that needs to analyze the structure of SQLite databases, I decided to convert the SQLSchemaResult to XML and then play with it. I think that it is really easier to perform the task that the application has to execute (the easiest way being the use of the HierarchicalData class but…).

Continue reading »

(1 votes, average: 5 out of 5)

 Loading ...

Written by Arnaud
Tags: AIR, SQLite

In this serie (that was supposed to be closed) about executing a multi-statement query in AIR (ie a query with several statements as INSERT, UPDATE, DELETE and even CREATE TABLE), I gave examples of queuing queries, looping on queries and at last, working with dependant queries.
Let’s now mix everything.

Continue reading »

(1 votes, average: 4 out of 5)

 Loading ...

Written by Arnaud
Tags: actionscript, AIR, SQLite

In this last chapter, I want to focus on dependant queries.
What I call dependant queries is queries that use the result of a previous one into their own statement.

Continue reading »

(1 votes, average: 2 out of 5)

 Loading ...

Written by Arnaud
Tags: actionscript, AIR, SQLite

In the first part of this serie, I explained how to split a SQL query and use each element of the returned array to queue each SQL statement.

In this second part, I would like to explain how to loop on a query. Very simple topic.

Continue reading »

(No Ratings Yet)

 Loading ...

Written by Arnaud
Tags: actionscript, AIR, asSQL, SQLite