Work with SQLite Databases on Android with aSQLiteManager

Productivity Sauce
SQLite is a great little database engine for maintaining all sorts of databases, but to work with them, you must have a database client. And when you need to create and manipulate an SQLite database on an Android device, aSQLiteManager is just the tool for the job. Despite its bare-bones appearance, this open source app packs a rather impressive array of features.
For starters, aSQLiteManager features a database creation wizard that makes it easy to create a database from scratch and populate it with tables and fields. The app can handle not only tables, but also views and indexes. The database browser allows you to view, edit, and delete records in the current table, while a simple SQL builder tool lets you construct and run SQL queries. It's also possible to save all executed queries in a dedicated table in the currently opened database. aSQLiteManager also makes it possible to execute SQL scripts. As you would expect, the app lets you back up the current database as an SQL script. You can then use the script to restore the database when needed. In addition to that, aSQLiteManager can import and export data in the CSV format. In short, the app has all the essential tools for working with SQLite, which makes it an indispensable tool for storing and manipulating data stored in SQLite databases on Android.
aSQLiteManager can be installed from F-Droid and Google Play Store, and if you want to support the developer, you can purchase the donation version of the app.
comments powered by DisqusIssue 272/2023
Buy this issue as a PDF
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
News
-
An All-Snap Version of Ubuntu is In The Works
Along with the standard deb version of the open-source operating system, Canonical will release an-all snap version.
-
Mageia 9 Beta 2 Ready for Testing
The latest beta of the popular Mageia distribution now includes the latest kernel and plenty of updated applications.
-
KDE Plasma 6 Looks to Bring Basic HDR Support
The KWin piece of KDE Plasma now has HDR support and color management geared for the 6.0 release.
-
Bodhi Linux 7.0 Beta Ready for Testing
The latest iteration of the Bohdi Linux distribution is now available for those who want to experience what's in store and for testing purposes.
-
Changes Coming to Ubuntu PPA Usage
The way you manage Personal Package Archives will be changing with the release of Ubuntu 23.10.
-
AlmaLinux 9.2 Now Available for Download
AlmaLinux has been released and provides a free alternative to upstream Red Hat Enterprise Linux.
-
An Immutable Version of Fedora Is Under Consideration
For anyone who's a fan of using immutable versions of Linux, the Fedora team is currently considering adding a new spin called Fedora Onyx.
-
New Release of Br OS Includes ChatGPT Integration
Br OS 23.04 is now available and is geared specifically toward web content creation.
-
Command-Line Only Peropesis 2.1 Available Now
The latest iteration of Peropesis has been released with plenty of updates and introduces new software development tools.
-
TUXEDO Computers Announces InfinityBook Pro 14
With the new generation of their popular InfinityBook Pro 14, TUXEDO upgrades its ultra-mobile, powerful business laptop with some impressive specs.