Manage SQLite Databases with phpLiteAdmin
Productivity Sauce
If you happen to use a web-based or regular application that relies on an SQLite database for storing data, you might appreciate the phpLiteAdmin tool. This lightweight utility consists of a single 150KB PHP script that requires no installation. Open the script in a text editor, and modify the $password and $directory parameters. The latter should point to the directory containing SQLite databases. Drop the script to the document root of your server, and point your browser to http://127.0.0.1/phpliteadmin.php (replace 127.0.0.1 with the actual IP address or domain name of your server).
Despite its tiny size, phpLiteAdmin is a rather capable tool which supports a wide range of actions. You can use it to create and delete databases, manage tables, import data, and perform searches. phpLiteAdmin also lets you construct and run custom SQL queries and even write your PHP functions for manipulating column values. All phpLiteAdmin's functionality is wrapped in a user-friendly interface, so even if you are not a database guru, you can quickly get to grips with the tool.
comments powered by DisqusSubscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Gnome 48 Debuts New Audio Player
To date, the audio player found within the Gnome desktop has been meh at best, but with the upcoming release that all changes.
-
Plasma 6.3 Ready for Public Beta Testing
Plasma 6.3 will ship with KDE Gear 24.12.1 and KDE Frameworks 6.10, along with some new and exciting features.
-
Budgie 10.10 Scheduled for Q1 2025 with a Surprising Desktop Update
If Budgie is your desktop environment of choice, 2025 is going to be a great year for you.
-
Firefox 134 Offers Improvements for Linux Version
Fans of Linux and Firefox rejoice, as there's a new version available that includes some handy updates.
-
Serpent OS Arrives with a New Alpha Release
After months of silence, Ikey Doherty has released a new alpha for his Serpent OS.
-
HashiCorp Cofounder Unveils Ghostty, a Linux Terminal App
Ghostty is a new Linux terminal app that's fast, feature-rich, and offers a platform-native GUI while remaining cross-platform.
-
Fedora Asahi Remix 41 Available for Apple Silicon
If you have an Apple Silicon Mac and you're hoping to install Fedora, you're in luck because the latest release supports the M1 and M2 chips.
-
Systemd Fixes Bug While Facing New Challenger in GNU Shepherd
The systemd developers have fixed a really nasty bug amid the release of the new GNU Shepherd init system.
-
AlmaLinux 10.0 Beta Released
The AlmaLinux OS Foundation has announced the availability of AlmaLinux 10.0 Beta ("Purple Lion") for all supported devices with significant changes.
-
Gnome 47.2 Now Available
Gnome 47.2 is now available for general use but don't expect much in the way of newness, as this is all about improvements and bug fixes.