| [phoenix-dev] New Database API |
|
Team, I've committed the Database API that Karl has been working on this quarter, as part of bug 249508. As a reminder, the goal was to allow local editing of pages that require database access. The new API provides transparent access to your local databases, or to the live ones, depending on where the code is running. Furthermore, the code allows for easy troubleshooting via SQL error reporting and SQL backtraces when run on your local dev environment. Everything you need to get started is here: http://wiki.eclipse.org/Using_Phoenix#Databases Please note the following: 1. Accessing databases using DB connection classes is now deprecated. Please use the new API to ensure page editing works locally 2. This Database API is not necessarily intended for use by non-Phoenix committers -- if committers need access to data, Phoenix devs should provide API/accessors via $App or other classes. The general public doesn't have time to familiarize themselves with our data schemas. See Using Polls for an example on how databases can be made easy for committers. 3. Any database schema changes need to be reflected in the refactorer 4. You need to download and run the refactorer each time the database is changed We may investigate automating 2. and 3. at a later time, but for now, that's how it is. Props to Karl, Matt and Nate for their hard work here. Denis |