Thursday, October 14, 2010

The recode has begun!

Indeed it has!

I have been long neglecting this project, but I am now ready to make phpLiterAdmin even better!

The next version will be phpLiterAdmin v2.0, and v1.0 will be abandoned. Here are some of the major changes that will be included in phpLiterAdmin v2.0:

  • Information will be stored in an SQLite database.
    • This means user names and passwords will be stored in a table, along with databases as well. So users will be able to be assigned permissions to a database. I will attempt to have very basic permissions, such as read (only be able to read information from the database, like SELECT, PRAGMA) and read/write (full control).
  • Support for SQLite v2 (both through PDO and built-in functions) and SQLite v3 (unsure about encrypted databases, hopefully, though!)
  • Better importing and exporting of databases.
    • You will be able to download the raw database.
    • Importing of large SQL files can be done in stages. The file will either be broken up and then each individual file will be imported, or the same file will incrementally be imported. I will see ;-)
    • Exporting of large databases will also be done incrementally. The export file will be saved to the server, and added to incrementally by reloading the page, preventing a timeout.
  • Pagination for simple SELECT queries, that way the whole table won't be displayed at once.
That is about it! But it will be quite a bit of work to do, since it will be coded from the ground up.

Keep on checking back here, I will post updates as I go.

No comments:

Post a Comment