Version 1.0 first production version released 6. February 2011
Have uploaded the fifth version of a SQLite browser / manager / editor for the Android platform.
More screen doump:
The exact license terms used by this project on the project summary page.
Comments welcome at the project summary page or by mail to me
Join this project:
To join this project, please contact the project me as shown on the project summary page.
Get the source code:
Source code for this project is available through a SVN client from the SourceForge SVN (see how) or you can browse the aSQLiteManager SVN here.
Project Information
In my work with Android development (eg a41CV) I often have to download the SQLite databases to my computer to check the database.If I had a SQLite browser a lot of trubles would be saved - but any SQLite browsers out there? I have not found them.
Status of project
All basic functionality implemented. Execution of any SQLite SQL statements included. This includes commands as 'drop tables' but not a 'undrop table' so be careful.It took quite some time to make the two way scrolling view work reasonable. The horizontal scrolling is still a little difficult you have to drag horizontal otherwise the scrolling will be vertical. Are still looking for a better solution.
Se here what is comming in the next version.
You can read about a41cv and my other Android apps at http://aaa.andsen.dk
New in this version:
- The second beta version of aSQLiteManager
- More advanced SQL builder (for Select, Create view, Create table, Drop table, Drop view, Delete from and Insert into)
- aSQLiteManager is opened if a .sqlite or .db is clicked uppon in different filmanagers (OI File Manager, in Adao Teams File Manager and in Simplest File Manager)
- A few bug fixed
Working on:
Planning further development, could be:- Select SQL history from query form
- Sort data / query results by clicking on title
- Data entry and editing form use editing button at each row
- Backup and restore of databases
Implemented:
- Query result in data grid
- More advanced SQL builder (for Select, Create view, Create table, Drop table, Drop view and Delete from)
- Executed statements can be saved in current database in a table named aSQLiteManager (configuration) each query is saved only once
- Paging on Table and View data viewer implemented. Numbers of records to return can be configured form option menu at the main form
- Clicking on a field in the data browser copy the content to the clip board
- A help screen with a little help, links and mailto
- Now it is possible to execute any SQL
- command on the open database
- Fully translated to Danish (translate this file to get it in your language)
- Select and open a database
- Se tables, views and index
- Se a tables structure
- See index definitions
- Browse the data of tables and views
- A data two way scrolling data browser
- Display view data
- A better file picker (sorted with directories first)
- The sqlite_master table now included in list of tables and sorted by name
- Create new database and open it
- Headers on query results
- Most part translated to Danish