| How to read data from SQLite database? [message #652579] |
Tue, 14 June 2016 04:54  |
 |
Littlefoot
Messages: 21823
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
