Running more complicated reports using basestation.sqb

Want to post something that doesn't quite fit into the other forums? This is the place for that.
Post Reply
adi4x
Posts: 4
Joined: Sat Feb 06, 2016 9:25 am

Running more complicated reports using basestation.sqb

Post by adi4x » Sat Feb 06, 2016 9:34 am

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
Posts: 156
Joined: Tue Oct 06, 2015 9:57 pm

Re: Running more complicated reports using basestation.sqb

Post by dsfh2992 » Sun Feb 07, 2016 4:09 am

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
Posts: 4
Joined: Sat Feb 06, 2016 9:25 am

Re: Running more complicated reports using basestation.sqb

Post by adi4x » Mon Feb 08, 2016 3:09 pm

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

T-EGJA1
Posts: 107
Joined: Sun Sep 08, 2013 12:11 am
Location: Mid-Devon, UK

Re: Running more complicated reports using basestation.sqb

Post by T-EGJA1 » Tue Feb 09, 2016 10:58 pm

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'
Terry

Post Reply