Can MySQL query another DBMS? (SQLite)

[dlite922]

Microsoft Access can run queries on Oracle DB.

Wondering if I can query SQLite through MySQL (join tables,etc)

I could easily dump the sqlite db to mysql, but requirements changed and I can't do this anymore.

Doing it with php (query one db, than another) takes too long, for one, and can't do pagination very well.

Googled, but to no avail.

Is this at all possible?


Dan

[dlite922]

Found something:

http://dev.mysql.com/tech-resources/articles/dbixmyserver.html

We can now face the most interesting part. Using tables from other database management systems, other than MySQL, as Federated tables inside MySQL.
If you need to use a table in Oracle, or PostgreSQL, SQL Server, until now the only option would have been importing the data into your database. There are cases, however, where the foreign data changes frequently, and you would need to import the data at very short intervals. If this is the case, instead of importing data, you can just link it to your application, and use it LIVE!

Looks promising.


Dan