phpLiterAdmin: A Better SQLite Database Manager?
by Jiang Yio on Jul.12, 2008, under Computing
SQLite is a wonderful flatfile database system that’s just gaining exposure in the PHP-programming population. For moderately-sized databases, SQLite offers speed and performance gains over even MySQL. The native object-oriented interface is also very easy to use.
Because SQLite is a relatively new player in the PHP arena, there is currently a serious shortage of good administration tools targeting it. While MySQL has phpMyAdmin and a bunch of other tools, SQLite is left on the side.
phpLiterAdmin is a new opensource PHP-SQLite administration tool that shows great promise. Although its author currently has more experience with MySQL, he is a skilled PHP developer who is capable of undertaking substantial projects. This project’s on my watch-list.
July 12th, 2008 on 2:31 am
Thanks
I hope to make this feature packed, yet not be bloated, and slow.
Right now I would say it has maybe a few less features (unnoticeable) than phpMiniAdmin. I am planning on adding things such as multiple database support, editing rows, inserting rows (Not sure how I will do that if nothing is in the table), maybe even a easy create table thing.
July 12th, 2008 on 2:38 am
That would be cool. I think inserting rows should follow naturally from creating tables; you really can’t insert rows if you’ve an empty file.
July 12th, 2008 on 4:10 am
Yeah, but I cannot figure out how to get what rows are in a SQLite table without data being inside it, as I cannot find anything to do that =S
July 12th, 2008 on 2:23 pm
I see… I don’t think SQL supports that operation in itself. Perhaps the pragma table_info() is what you need: http://www.sqlite.org/pragma.html#schema
MySQL has a similar mechanism to overcome this issue.
July 17th, 2008 on 4:17 am
I actually figured it out, if I remember the function right it is sqlite_field_name and I know of a function that can get the column type
July 17th, 2008 on 3:41 pm
Ah, cool. SQLite is typeless, though. You write any column type you want, followed optionally by parenthesized integers… and SQLite ignores them. =p
July 20th, 2008 on 9:16 pm
Thats the annoying thing, whats the point of type declarations if it doesn’t listen ._.
July 20th, 2008 on 9:40 pm
This forces you to do the type checking and validation in your own application, and allows you to make up any type you want. Perhaps phpLiterAdmin should not enforce types either, because it’s meant to be used for any general SQLite database.
July 29th, 2008 on 4:36 pm
Yeah, it doesn’t force the data types