I use a virtual table module for reading from oracle tables.
A configuration script interrogates the Oracle DB for tables/views conforming
to a naming regime and issues
CREATE VIRTUAL TABLE <name> IF NOT EXISTS USING oracle ('<oracle name>');
for each matching DB object. The XCreate function uses the oracle name passed
as a parameter to DESCRIBE the object and transforms this into DDL for SQLite
to parse.
The same approach should work with your desired database.
I did not implement writes because it is not required for my application. I
think it could be done, but care must be taken to ensure transaction integrity
and I expect handling "foreign" updates row by row (even with just preparing
once and binding values) to be much slower than passing the SQL to be performed
"natively" (in a user defined function perhaps).
Gunter
-----Ursprüngliche Nachricht-----
Von: Reddy C. balaji [mailto:balaj...@spanservices.com]
Gesendet: Donnerstag, 20. Juni 2013 06:34
An: sqlite-users@sqlite.org
Betreff: [sqlite] Connection between SQLite - Other Databases
Hi All,
Please let me know the options available to connect to other
databases ( Oracle, MSSQL , MySQL etc ) from SQLite. For example, to connect
from Oracle to other databases DBLink can be used. In the same way, from MSSQL
, Linked Server can be used to connect to other databases.
In the same way are there any features available in SQLite ??
Thank you
Reddy Balaji C.
DISCLAIMER: This email message and all attachments are confidential and may
contain information that is Privileged, Confidential or exempt from disclosure
under applicable law. If you are not the intended recipient, you are notified
that any dissemination, distribution or copying of this email is strictly
prohibited. If you have received this email in error, please notify us
immediately by return email to mailad...@spanservices.com and destroy the
original message. Opinions, conclusions and other information in this message
that do not relate to the official of SPAN, shall be understood to be nether
given nor endorsed by SPAN.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--------------------------------------------------------------------------
Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at
This e-mail is confidential and may well also be legally privileged. If you
have received it in error, you are on notice as to its status and accordingly
please notify us immediately by reply e-mail and then delete this message from
your system. Please do not copy it or use it for any purposes, or disclose its
contents to any person as to do so could be a breach of confidence. Thank you
for your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
