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
-
Hannah Montana Linux Is Back!
Developer Noah Cagle decided the world needed the once obscure but beloved Linux distribution and gave it a decidedly pink refresh.
-
System76 Refreshes the Lemur Laptop
If you're looking for a laptop with tons of power and battery, look no further than the latest iteration of the System76 Lemur Pro.
-
More than 43 Million Lines of Code in Linux Kernel 7.2
Using the cloc utility, Michael Larabel of Phoronix discovered that Linux kernel 7.2 has over 43 million lines of code.
-
Kubuntu Focus Goes Ultra
The Kubuntu Focus team has upped the performance ante of its M2 and Zr laptops with the latest, greatest CPUs from Intel.
-
Linux Gamers May Soon See Less Mouse Lag in KDE Plasma
Gamers using KDE’s Plasma desktop have been suffering from a slight input delay in mouse movement that could lead to getting fragged.
-
Three Lines of Code Improve Linux Storage Performance
A developer changed three lines of code, giving Linux storage performance a 5% bump.
-
AUR Hit Again with Malicious Packages
Once again the Arch User Repository is plagued by a high volume of malicious packages.
-
Alpine Linux 3.24 Features Fresh Desktops and a Newer Kernel
If you're a fan of Alpine Linux, it's time to upgrade because the latest version has been released with KDE Plasma 6.6, Gnome 50, and Linux kernel 6.18 LTS.
-
EU Open Source Strategy Plays Key Role in Tech Sovereignty Package
Comprehensive measures adopted by the European Commission aim to reduce dependency on non-EU countries.
-
Linux Foundation Report Indicates AI Driving Tech Hiring
Within growing security and skills gaps, AI has been found to be a positive driving force behind tech hiring trends in Europe.
