Running more complicated reports using basestation.sqb

[adi4x]

Hi,

I want to be able to do more complicated reports and analysis with the data that I'm writing to basestation.sqb. Things like frequency of filghts of certain airlines during specific weekdays, and other strange stuff.
Since basestation.sqb is in an open format, I was able to export the data to csv and play with it with Access and Excel, and get the kind of reports that I want. However, this method is a bit cumbersome.

Has anyone tried other methods to interact with the database, and can recommend a software that I can use to get the kind of analysis and reports that VRS doesn't provide?

Thanks!

Adi

[dsfh2992]

Yes. There is a program called "SQlLiteDatabaseBrowserPortable" that can be used to construct SQL queries and run them against the SQB. It has proven very helpful to me.

--Dan

[adi4x]

Thanks, I have that one. Not so strong on SQL queries though

[T-EGJA1]

There are plenty of tutorials for SQL query language available online if you google for them - that's the way I've learned to manipulate data in the basestation.sqb .......... for software, I use 'SQLite Expert Personal'