> While you can "feed" raw SQL to SA that would not be how one normally > uses it. > > Wouldn't it be better to document the database itself?
Thanks for the handful example. Indeed, I can see two approaches here, which both would be nice to have implemented. The benefits of using raw SQL instead of live DB are not being dependent on running database (document building server may not have access to it, for example) and the possibility of using comments in the query file, like: -- This is table is used by: -- -- * blah -- * blah -- -- .. NOTE:: This is a note -- CREATE TABLE foo ( id int(11) NOT NULL AUTO_INCREMENT, bar_id int(11), -- Reference to table ``bar`` ); But then again, your example shows how easy it is to fetch data from SA powered db connection. Makes one tempted to write a directive from it :) -Juha P.S. I wonder how fast will the NoSQL solutions retire these efforts :) -- You received this message because you are subscribed to the Google Groups "sphinx-dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sphinx-dev?hl=en.
