I start with my first Android applications, and I use the built-in SQLite database to store my application data. To check if my sql queries create the correct tables, restrictions, etc., And to check if my application inserts the data I want into it, I always connect to adb to my development phone and use the sqlite3 command.
Although I am starting to learn Android, I have been working for the last few years as a professional Java developer, mainly engaged in web development and Eclipse RCP development. During these years, when I was doing something from the database, I always had access to the visual database editor (depending on RDBMS: Toad, DBVisualizer, Heidi, etc.), and I'm pretty used to the fact that offer these tools.
The presence of a graphical interface for viewing database tables, viewing restrictions, performing test queries, etc. helps me do my job much faster than, for example, when I have to use the command line shell for these tasks.
So my question is: are there any Android development tools that allow me to access my application database during development using the GUI / something more convenient than sqlite3 from my computer?
PS: Of course, I found database tools on the market that let you edit your database by phone. But typing long sql queries on the telephone keypad and viewing tables on a 3.7-inch screen is not so convenient in my opinion.
source
share