PBooks version 0.08 has been released, and you can find the complete tarball in the new download location:
PBooks Downloads
If you would like to install PBooks on Windows please see the new instructions we posted today:
http://www.pbooks.org/wiki/PBooks_Installation_using_XAMPP_and_Windows
While there continue to be some issues with Selenium tests (failures when there shouldn’t be), PBooks 0.08 is almost ready for release.
Installation has been a significant hurdle for many people so in ticket 138 I have specified the need to test out a complete install prior to release. An installation into a webserver docroot will be tested, as even though it is not recommended, many users on shared hosts find it easier to do so.
I’m very pleased to report that there has been some seriously major progress towards running PBooks with SQlite. The major hurdle was the way that I had structured SQL statements with “LEFT JOIN”. Once I found a better way to draft them, specifically using “INNER JOIN”, the incompatibility went away.
Besides the JOIN issue, I also had to remove the use of SUBSTRING and DATE MySQL functions. Unfortunately those are not the same in SQlite. Instead I’ll write an action to use PHP’s substring, as I’m sure that will still be faster than XSL’s substring capabilities.
Also note that there are two new SQL files - one for the structure and one for some sample data. Using SQLite with PBooks is still very far from being complete, but its a lot closer than it was a few hours ago! 
For more information, see PBooks and SQLite
Latest Comments
RSS