Edward Swing wrote:
We're doing something like this already.
Specifically, we are using a
Java client to retrieve, query, and update wiki pages. We have written a
Java class that wraps the api.php, and accesses it through web calls
(opening URL connections, parsing XML, etc.).
Since the database is on the wiki server, and our application may be on
a different server, we do not access the database directly. If you
wanted to do that, I would probably get the SQL schema from the
documentation and use JDBC calls.
Accessing via api.php is much more stable though. Directly accessing the
database for reading/editing is discouraged.