v1.9.4.1 and Last Post

v1.9.4 of phpLiteAdmin has just been released. It's amazing to see the progress of the project. This will be the last post on this blog.

To continue reading on the development progress of phpLiteAdmin, check out the following blogs maintained by the developers of the project:

Christosoft Blog

Dane Designs

v1.8.8 and other things

Back a few months ago when I created phpLiteAdmin (formerly SQLite3Admin), it was meant for personal use so I could easily manage my SQLite3 databases on the web since there weren't any existing tools at the time. After turning it into an open source project and several months of continuous improvements, it has become a popular tool for developers all over the world. I never imagined this kind of scope.

Still, even after countless new features and becoming almost identical in breadth to phpMyAdmin, the source code for phpLiteAdmin is contained within a single file. Its ease of installation makes it an attractive option to most developers who want to quickly manage their SQLite databases without the hassle of dealing with lengthy wizards, deep directory hierarchies, and other problems of unnecessary complexity. If you have been using phpLiteAdmin, you know how convenient it is - wherever there is an SQLite database, you simply drop phpliteadmin.php alongside, and full management of that database becomes possible!

Anyway, v1.8.8 has just been released and is available for download. It has bug fixes - same old, same old... but 1.8.9 is where I anticipate some great new things happening...

I see the next major release as having the ability to support multiple users. An SQLite manager on the web should take advantage of the fact that it's public to anyone with a browser and internet connection. Account creation and management would allow a group of people to simultaneous manage SQLite databases without worrying about accidental deletions by unqualified individuals with too many privileges.

I know that this blog is pretty dead. After all, it's a blog dedicated to the development of a pretty obscure piece of software used by a small percentage of a small percentage of developers, who as a group, are a small percentage of people in the world! But if you have any input on the future of phpLiteAdmin or anything interesting to say, let the words flow.

v1.8.5 released and v1.8.6 on the way

It's been awhile, but v1.8.5 has finally been released. There are some major bug fixes and a new feature allowing you to specify a directory to scan for databases. This is in contrast to the old way of manually specifying the path of each database and putting them in an array at the top of the file. Both ways are now possible in v1.8.5.

More exciting however, is the upcoming v1.8.6, which will allow you to view your records in graphs and charts instead of boring lists. How would you like to see a line chart showing the varying values of certain table fields? Or a pie chart showing male vs. female users in your user table? This will all be possible very soon.

v1.8.3 released and upcoming rounded corners!

v1.8.3 has been released. It includes bug fixes and better navigation control when browsing records.

More importantly, however, is the upcoming rounded corners in v1.8.4. Using the new border-radius CSS property, every boring rectangle in the UI will be transformed into a sleek rounded rectangle.

Staring at smooth, rounded corners is much more soothing than staring at sharp, jagged corners. This may not seem like a big deal, but you will change your mind once you begin managing your SQLite databases and notice that your mood and overall happiness have improved - all due to the pleasing effects of rounded corners.

Take a look at this magnificent feat on the demo.

phpLiteAdmin v1.8.2 released

It was only a few days ago that v1.8.1 was released, but v1.8.2 is ready for download.

No security fixes are included in this update, so it is completely optional (though, as always, recommended).

Two bugs were fixed in this version:

• There was an issue with tables that had long columns, causing the data to be cut off, this is now fixed as a scroll bar will appear under such circumstances (fixing issue #5).
• Logging in did not work in Internet Explorer unless the user explicitly hit the "Log in" button, otherwise when using the Enter button, the log in request would not be processed. This was fixed by adding a hidden field (fixing issue #7).

There is a minor feature addition in v1.8.2, which allows you to change the name of the cookie which contains the user password, which can be changed by modifying the $cookie_name variable near the top of phpliteadmin.php.

Thank you for all those that reported these issues to the development team, we appreciate it, and so does everyone who uses phpLiteAdmin.

If you encounter any issues with phpLiteAdmin, please feel free to create a new issue in the issue tracker.