Page 1 of 1

Running more complicated reports using basestation.sqb

Posted: Sat Feb 06, 2016 9:34 am
by 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

Re: Running more complicated reports using basestation.sqb

Posted: Sun Feb 07, 2016 4:09 am
by 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

Re: Running more complicated reports using basestation.sqb

Posted: Mon Feb 08, 2016 3:09 pm
by adi4x
Thanks, I have that one. Not so strong on SQL queries though :-)

Re: Running more complicated reports using basestation.sqb

Posted: Tue Feb 09, 2016 10:58 pm
by 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'