rSQLite : a relational SQLite Manager for Android

Abstract

As the use of mobile devices in the workplace grows exponentially, the current SQLite database managers available were too simple and failed to present the user with an intuitive way to browse and edit data. Most applications simply listed the content of the tables, ignoring the relations between them. This missing capability is what motivated this project. To create an app capable of managing a SQLite database focusing on the relations between tables. After selecting Android as the target operating system for its huge market share and how easily new developers can start to create projects, the application was developed using Java and Eclipse. Following the study of the way the SQLite language creates and saves the relations between tables, the nal code is able to understand these relations and present an intuitive user interface. In order to experience the full capabilities of the application, the database design must follow a short and simple list of conventions, but the relational functionalities can also be disabled, in which case the application works as a simple editor for any SQLite le. The result is an innovative, intuitive and fast SQLite Manager that allows the user to navigate through the database tables using the relations between them as well as making all the other basic activities such as creating new entries or editing existing ones. In conclusion, users who actively work with SQLite databases will now have a better and easier to use tool that will improve their experience with mobile devices in the workplace.