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 DisqusIssue 259/2022
Buy this issue as a PDF
News
-
Titan Linux is a New KDE Linux Based on Debian Stable
Titan Linux is a new Debian-based Linux distribution that features the KDE Plasma desktop with a focus on usability and performance.
-
Danielle Foré Has an Update for elementary OS 7
Now that Ubuntu 22.04 has been released, the team behind elementary OS is preparing for the upcoming 7.0 release.
-
Linux New Media Launches Open Source JobHub
New job website focuses on connecting technical and non-technical professionals with organizations in open source.
-
Ubuntu Cinnamon 22.04 Now Available
Ubuntu Cinnamon 22.04 has been released with all the additions from upstream as well as other features and improvements.
-
Pop!_OS 22.04 Has Officially Been Released
From the makers of some of the finest Linux-powered desktop and laptop computers on the market comes the latest version of their Ubuntu-based distribution, Pop!_OS 22.04.
-
Star Labs Unveils a New Small Format Linux PC
The Byte Mk I is an AMD-powered mini Linux PC with Coreboot support and plenty of power.
-
MX Linux Verison 21.1 “Wildflower” Now Available
The latest release of the systemd-less MX Linux is now ready for public consumption.
-
Microsoft Expands Their Windows Subsystem for Linux Offerings With AlmaLinux
Anyone who works with Windows Subsystem for Linux (WSL) will now find a new addition to the available distributions, one that’s become the front-runner replacement for CentOS.
-
Debian 11.3 Released wIth Numerous Bug and Security Fixes
The latest point release for Debian Bullseye is now available with some very important updates.
-
The First Alpha of Asahi Linux is Available
Asahi Linux is the first distribution to fully support Apple Silicon and is now available for testing.