As mentioned a couple posts ago, Codex was getting the same massive feature boost and cleanup that MDB got. Technically I’m not completely done yet but my schedule is going to get complicated soon, and I don’t know how much more time I’ll have to work on it. I figured I’d get everything I have up until now out the door.

The changelog for this version is as follows:

• Option to enable debugging output
• Database persistent connections are now off by default
• Warnings fixed in various places
• Database access API significantly cleaner
• ADODB caching is now an optional config setting (since caching slowed things down for me greatly)
• Code cleanups in many places: large functions cut down in size, better code constructs, useless stats removed, etc
• CSS split out with session support for themes (light and dark theme included)
• Removed useless dbperfmon option
• Support for multichapter fics, with dynamic navigation toolbars on the top and bottom and a table of contents
• Support for attempting to unwrap fics that have fixed-width line breaks
• Two-layer cache framework
• Set the page width properly on iPhone
• Search output is trimmed down to only show info relevant to search
• Attempt a very basic fuzzy search if exact match is not found

In general, things such as the fuzzy search, cache framework, and themes are generally set-and-forget items. However, the database structure has significantly changed due to the support for chapters now. The data from the fics table has been split out into a chapters table, so now the fic table only stores the fic’s title and comments, and all other data is in the chapters table (chapter title, chapter number, data or file to read, etc). Even one-shot fics have an entry in the chapters table (just one chapter), and the UI will treat those fics accordingly and not draw the chapter navigation. New SQL for database structure and an example fic (Guardian Angel) have been included. Migration of data from the old database structure to the new one can be done, but I haven’t included the SQL for it. You can contact me and I’ll help you migrate. Apologies for any difficulties, but it was necessary to do this to support chapters.

You can get it on the codex page.

MDB has a bug inhibiting downloading of files larger than a certain size.  Output buffering was accidentally left on during file download, so files larger than the output buffer (usually 128M) are truncated to that size.  The one little fix is a bit too small for a whole release right now, so I’ll either have to wait to do more fixes or until a little time has passed and I feel that no other fixes will be coming.  Either way, the fix is in gitphp so if it’s a problem you can grab the snapshot.

Codex is currently getting the same massive revamp, feature boost, and cache framework that MDB got.  It’s my oldest full fledged PHP/SQL project so it has the crappiest code and could benefit the most from such a thing.