SuccesSQL demo online
This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb.
The WinPHP challenge comes to an end around now, so I’ve put up a demo installation of SuccesSQL (v0.01!) at http://test.successql.org. The test site takes a lot longer to display the first page than version running in my VM and I have no idea why!
The source code is released under the New BSD license and is available from my subversion repository.
I expect that this code isn’t as secure as it should be and isn’t especially well tested either. As such, I highly recommend that you don’t use it on important databases or on a public facing web server!
Obligatory screen shot:
I’ve still got lots to do though, but there’s enough done that I’m using it for work related stuff when I need to look something up, but can’t be bothered to wait for the SQL Server Management tool to get around to starting up. In that sense, it’s already a success!
Looks interesting – could develop into a challenger for phpMyAdmin.
All you need now is nicer graphics. Ever thought about using Ext JS or something like it to power this?
Jani,
Who knows ?! I'm working on good functionality first :)
Regards,
Rob…
I picked a table name on the front page, I landed on the "Structure" page for that table, then I just clicked the "Browse" and got this: http://twitpic.com/6d4ic/full it's throwing up this kind of error for different tables, but not all of them.
Cheers,
Robert
Nice work, Rob. The first page doesn't take that long to display for me (~250ms without cache), but who knows what you are striving for. ;-)
There is one small problem: as it seems that no primary key is defined for table "BuildVersion", an exception is thrown when you want to browse the table.
Regards,
Matthias
Robert & Matthias,
Development mode is now off, so you can't see the exception…
I'm aware of the failure to browse when there's no primary key attached and cheated by adding a known issues section to the README :) I think the solution is to drop down to the db adapter rather than using Zend_Db_Table.
The speed appears to be variable. Juozas is seeing something similar, so at least I know it's not just me!
Regards,
Rob…
I think you should drop /trunk/application/controllers/helpers/Setup.php cause you replaced it already with SSQL_Controller_Plugin_ViewSetup.
Anyway, nice to take a look into your sourcecode. Intressting Projekt, hope to see more in the near future.
Salz`,
Good catch :)
Regards,
Rob…
Btw. is that an project you plan to work on in the future or just some testing/experience?
Salz,
I have need for it at work, so it's definitely something that I will be working on. Probably a bit slower though as I'm rather busy…
Rob…