Roadmap

Here's a list of things I'd like to get running with Phreeze, in no particular order. If you're interested in any one of them feel free to send me a message or a pull request.

1. Generated SQL should use PDO and prepared statements

Because the queries are abstracted this should be feasible and 100% backwards compatible except with reporters. Reporters might need some kind of switch to support prepared statements, but most likely old code will still run the old way (perhaps with logging a warning)

2. Abstract the database reflection during code generation.

At the moment you could technically run Phreeze using any database. SQLite and MySQL are supported out of the box. However the database reflection is hard-coded to mysql and relies on mysql-specific commands like "show tables" This might be possible to use PDO or something else that has already been written rather that re-inventing the wheel.

3. Fix MemCache support for data sets.

Currently level2 cache supports caching individual objects which works pretty well. Phreeze also supports caching of data sets, however it's tricky to rely on them because when individual records are changed they don't know what sets they may belong to. So there either needs to be some kind of reference counter for objects or some other mechanism. As it is the set caching is "eventual consistency" which is probably find for certain types of applications, especially with a short cache expiration.

4. Create an application "config" file

When you generate an app, you may change several settings and tweak things. When generating the app, it would be nice to save this config file and allow you to re-load it the next time you re-generate code so you don't have to re-enter all of the settings the same each time.

5. Create a command line interface

Allow generation of the application via a command-line interface for greater automation

6. Improved Unit Testing Coverage

Phreeze itself currently has minimal testing, though the test harness is already there waiting for more tests. This would be an ongoing project.