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 269/2023
Buy this issue as a PDF
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs
News
-
MNT Seeks Financial Backing for New Seven-Inch Linux Laptop
MNT Pocket Reform is a tiny laptop that is modular, upgradable, recyclable, reusable, and ships with Debian Linux.
-
Ubuntu Flatpak Remix Adds Flatpak Support Preinstalled
If you're looking for a version of Ubuntu that includes Flatpak support out of the box, there's one clear option.
-
Gnome 44 Release Candidate Now Available
The Gnome 44 release candidate has officially arrived and adds a few changes into the mix.
-
Flathub Vying to Become the Standard Linux App Store
If the Flathub team has any say in the matter, their product will become the default tool for installing Linux apps in 2023.
-
Debian 12 to Ship with KDE Plasma 5.27
The Debian development team has shifted to the latest version of KDE for their testing branch.
-
Planet Computers Launches ARM-based Linux Desktop PCs
The firm that originally released a line of mobile keyboards has taken a different direction and has developed a new line of out-of-the-box mini Linux desktop computers.
-
Ubuntu No Longer Shipping with Flatpak
In a move that probably won’t come as a shock to many, Ubuntu and all of its official spins will no longer ship with Flatpak installed.
-
openSUSE Leap 15.5 Beta Now Available
The final version of the Leap 15 series of openSUSE is available for beta testing and offers only new software versions.
-
Linux Kernel 6.2 Released with New Hardware Support
Find out what's new in the most recent release from Linus Torvalds and the Linux kernel team.
-
Kubuntu Focus Team Releases New Mini Desktop
The team behind Kubuntu Focus has released a new NX GEN 2 mini desktop PC powered by Linux.