Joel,
here's my initial response. From the top of my head I can answer a few of your questions.
- I personally use the 'sql-postgres mode in emacs to execute pg/plsql. Combined with an auto-revert on the error log I can quickly re-execute (parts) of database queries that failed and test new queries as well.
- For the OpenFTS search to work the item to be searched has to be an acs-object.
- You'll find the openacs-driver-api in the doc section of your OpenACS instance.
- Inline functions are used for temporary pg/plsql procedures. They most often are used in installation script to create new objects or to initialize or upgrade a package.
- Advantages of the content repository include version management and automatic inclusing the OpenFTS search.
Hope this helps,
/Bart
