OraFAQ Forum: General » How to read data from SQLite database?

Home » Other » General » How to read data from SQLite database? (Oracle 11g XE, no idea about SQLite)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to read data from SQLite database? [message #652579]

Tue, 14 June 2016 04:54

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Hello everyone!

As of the moment, this is just a theoretical discussion, nothing has been done yet.

There are .SQB files (which belong to SQLite database) related to airplanes (such as flightroute.sqb and basestation.sqb). Is there a (simple?) way to read information (stored within these files) from Oracle?

The "simplest" option I found (Googling around) is this: Today's Flights -- How To Extract Data from BaseStation.sqb which (shortly) uses some .EXE to create a .CSV which I could use as an external table (or whatever I want to do with it).

However, I'd much rather use something like a database link - a direct access to .SQB files.

Does anyone have an idea how to do that?

The goal is to join data from already mentioned .SQB files with data airplanes transmit (their speed, altitude, etc.) and - using Oracle Apex - produce a "real time" report.

Regards,

LF

Report message to a moderator