tag:blogger.com,1999:blog-67852289087136170212012-02-16T18:53:20.356-08:00News and information about the development of phpLiterAdmin.Iannoreply@blogger.comBlogger31100tag:blogger.com,1999:blog-6785228908713617021.post-87620031559727886992010-10-20T00:23:00.000-07:002010-10-20T00:23:14.967-07:00Just wanted to let everyone know how I was doing on phpLiterAdmin v2.0.<br /><br />Well, there isn't much for me to say, right now I am still working on parts of phpLiterAdmin which have been in previous versions, so nothing to show off.<br /><br />Sorry I can't give you any big update yet, but once things get working, I will be sure to post some screen shots ;-)<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6785228908713617021-8762003155972788699?l=phpliteradmin.blogspot.com' alt='' /></div>Iannoreply@blogger.com0tag:blogger.com,1999:blog-6785228908713617021.post-25808667011048378262010-10-14T13:09:00.000-07:002010-10-14T13:09:37.218-07:00Indeed it has!<br /><br />I have been long neglecting this project, but I am now ready to make phpLiterAdmin even better!<br /><br />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:<br /><br /><ul><li>Information will be stored in an SQLite database.</li><ul><li>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).</li></ul><li>Support for SQLite v2 (both through PDO and built-in functions) and SQLite v3 (unsure about encrypted databases, hopefully, though!)</li><li>Better importing and exporting of databases.</li><ul><li>You will be able to download the raw database.</li><li>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 ;-)</li><li>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.</li></ul><li>Pagination for simple SELECT queries, that way the whole table won't be displayed at once.</li></ul>That is about it! But it will be quite a bit of work to do, since it will be coded from the ground up.<br /><br />Keep on checking back here, I will post updates as I go.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6785228908713617021-2580866701104837826?l=phpliteradmin.blogspot.com' alt='' /></div>Iannoreply@blogger.com0tag:blogger.com,1999:blog-6785228908713617021.post-66764005506926459012010-10-14T12:25:00.000-07:002010-10-14T12:25:59.249-07:00I was alerted of a <a href="http://www.htbridge.ch/advisory/authentication_bypass_in_phpliteradmin.html">security vulnerability in phpLiterAdmin v1.0 RC1</a> yesterday morning. The vulnerability is a authentication bypass, which is, of course, bad.<br /><br />It is <i>highly</i>&nbsp;recommended you update to <a href="http://code.google.com/p/phpliteradmin/downloads/detail?name=phpliteradminv1-rc1.1.zip&amp;can=2&amp;q=">phpLiterAdmin v1.0 RC1.1</a> immediately to resolve this vulnerability.<br /><br />I apologize for this security issue, it was a mistake I won't make again. Thanks for using phpLiterAdmin, the better SQLite manager!<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6785228908713617021-6676400550692645901?l=phpliteradmin.blogspot.com' alt='' /></div>Iannoreply@blogger.com0