Basestation database method

[Faramir]

Working on a (python) script that is able to merge the Populated SQB file with the existing database I 'm at a standstill. The merging itself is seems to work but it corrupts the database as a whole. Does someone know exactly how Basestation enters data received from the SBS device into the database? Which information is placed in which tables and how are the tables maintained? Looking at the Basestation.exe file I can find three INSERT INTO queries but how is a 'new' aircraft is entered into the database and with what information provided by BaseStation is a mystery to me. I looked at the plugin for VRS but that dind't bring me much. Basically I'm looking for a way to mimic Basestation's interaction with the database. Any help is greatly appreciated!

[OtNE]

I've been updating and appending records to the .sqb for years but using OBDC SQLite3 drivers and MSAccess (2003 or later).

I've never had a problem or error unless BaseStation or something else was live.

Not Python related, but it may help ?

Cheers,  Paul

[Faramir]

Thanks for your information Paul!
On my own database I also use Python scripts. But adding and updating over 450.000 records without the follow-up on the other tables is almost a corruption waiting to happen. That's why the complete method is essential.
Changing an operatorflag or some field is no problem. I use both Python and SQLite Maestro but that makes no difference.

Cheers,
John