phpLiterAdmin and GZip
I have released phpLiterAdmin v0.7.2 which introduces the ability to export and import in a Gzip format.
This is also phpLiterAdmin's 1st release that has NO Bug Fixes 
(I think lol)
What is next for phpLiterAdmin? I can tell you what isn't... Row editing... It is a pain in the BUTT, I am having troubles with slashes being added and just totally get messed up :'( So row editing may not come until 1.0 or 1.x
Now, the possibilities of the next release? Probably a page to very easily create tables :-] but to be honest, after that is done, I don't know what else should be added... :x
Posted by aldo on July 15, 2008, 01:34:09 AM
Comments
Possiblities:
- Create tables
- Insert new record
- A Select statement query designer, like what MSAccess has or like the things featured here:
http://query-designer.qarchive.org/
Obviously, not quite as advanced, as you can't do drag and drop in HTML, but a tool for making it easier to generate medium complexity SELECT statements with lots of fields to select and criteria would be very welcome. The other week, I spent ages trying to do a SELECT statement that would select the 5 most recent comments to show on my front page and display them in the order of the most recent comment, but also with a count of the most recent comments. I probably wouldn't have been able to do it without the help of query designer in MS Access. It contained the likes of :Last(comment) ... Count(comments) ... Avg(score) ... INNER JOIN ... GROUP BY ... HAVING ... ORDER BY.
And the thing I always get wrong with SQL SELECT statements like this is where to put the () brackets or how many brackets to do and whether to use HAVING or WHERE. So a query designer that does the bracket placement for me etc, would be very good.