The latest release (1.2.0) of SQLite Database Console has added support for rotating the device into landscape mode. You now have the full benefit of the landscape keyboard when typing those long SQL commands.

You can find out more about SQLite Database Console on www.database4iphone.com or SQLite Database Console is available now on the iPhone AppStore.

During development of StoreIt, it is sometimes nice to be able to test SQL running directly on an iPhone without going through the process of building the code into the application. This gives a good idea of performance which you wouldn’t get running the same SQL off the device. For this purpose, we built a little tool for creating and querying a SQLite database on an iPhone or iPod Touch. We are pleased to announce that we have now made this application available through the AppStore.

SQLite Database Console supports the following features:

• SQL console providing access to the SQL language supported by the SQLite database platform.
• Access to all recently executed statements for easy re-execution.
• Recently executed statements saved between sessions.
• Access to the SQLite SQL documentation within the application meaning you can easily switch between the documentation and SQL console when building your queries.
• Connect to the SQLConsole from your desktop machine over Wi-Fi to enable backup and restore of database.
• Use database SQLConsole connection to load SQLite databases created on other machines.

You can find out more about SQLite Database Console on www.database4iphone.com or SQLite Database Console is available now on the iPhone AppStore.