for clearification: the roots of the question: business needs; our client has a big Oracle infrastructure. Now they want, in relation to their infrastructure a litte App based on SQlite.
as I mentioned earlier: to copy data from an Oracle DB to another Oracle DB there is just one single line necessary: import into mytable select a,b,c from remotetable remoteOracleDB somewhere in my local OracleDB I have to define a bit earlier a database link with IP-adress, Port, SID UserID and passwort concerning the remote OracleDB. That's it. Are am I to lazy to implement by my self ? : Yes and No I have implemented it within C# and ADO.net. Then it's not only one line of code, which is easy to read an easy to maintain. It's a lot more: The basic concept is a loop, suprise suprise ! But you have to take into account that you have to convert every single datatype, (e.g. DATE, there is a different representation Sqlite versus Oracle) you have to look for character-set and so on and so on. My wish: If someone else already has done this work .... Thatfore I think an ODBC driver has to be implemented (there I am not an expert) ... and a database Link to Oracle should be defineable by ATTACH (IP-Adress:Port, OracleSID, UserId, Password) that would be heaven on earth. -----Ursprüngliche Nachricht----- Von: Gary_Gabriel Gesendet: 05.06.2010 16:02:14 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Oracle connection Hi Pavel, > Note: SQLite *API*, nobody says about databases. These words from > press-release basically say that now Berkeley DB "back end" has > SQLite's "front end", i.e. you can work with BDB database through the > same set of functions as with SQLite database. But you cannot mix them > with each other and of course you cannot mix both of them with Oracle > database. It's 3 different technologies and if you want any bridges > between them you have to write them yourself. > You are correct. above is an interfacing and implementation issue of how to employ the API within the interfacing structure. Your answer below answered it adequately from the SQLite perspective. But the post "Re: [sqlite] releasing EXCLUSIVE lock after writing dirty pages from the memory cache into the DB ?" [1] presents a strategy expanding beyond the press release and offers a complementary perspective. It addresses the questions of supporting business teams and the infrastructure by collecting information assets from embedded databases. These questions include -> Where are the assets? What is the availability of the assets? How readily and easily can these assets be used? These questions are complementary to the SQLite perspective. After the announcements of Oracle on this list I visited the manufacturer site looking for qualified information on the integration strategy, product and implementation. Information retrieval was difficult and as this is not a priority issue for my projects, I passed on without qualified technical information that would focus my interpretation. I am sure that the info is there, but I left with only an overview and interpretation and limited knowledge of the intents for interfacing and implementation that could provide guidance. Oracle information and the post cited below seem to indicate that the integration goes beyond the API and enhances performance. There are a number of other platforms moving in the direction of providing backend or networking SQLite platforms and most offer strategic information sufficient for preliminary qualification. - Gary Gabriel [1] [sqlite] releasing EXCLUSIVE lock after writing dirty pages from the memory cache into the DB ? 28.4.2010. http://article.gmane.org/gmane.comp.db.sqlite.general/56055/match=releasing+exclusive+lock+after+writing+dirty+pages+memory+cache+into+db > @Simon: to be honest I don't understand where the roots of the > question are. Either you're too lazy to implement it yourself or for > some reason you believe that SQLite could do some magic and could > transfer data from Oracle without copying anything into local memory. > That's impossible, computers don't work that way. If you know how to > work with Oracle and how to work with SQLite then you can quickly > write your application to execute this kind of data transfer. The > pseudo code for that follows: > > issue select statement A to Oracle > while there's record returned by statement > issue insert statement B to SQLite with data retrieved from Oracle > move to the next row in statement A > end of while > > I'm pretty sure that if SQLite could do what you want, Simon, it would > do it exactly like this. > > > Pavel > > On Thu, Jun 3, 2010 at 2:59 PM, Gary_Gabriel > wrote: > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________________________ NEU: WEB.DE DSL für 19,99 EUR/mtl. und ohne Mindest-Laufzeit! http://produkte.web.de/go/02/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
