SQL?  Really?  Wow.


On Thu, Jun 27, 2013 at 5:26 AM, Georg Zotti <georg.zotti@univie.ac.at> wrote:
Hi Marios,

I see two immediate applications: interactive debugging, and, if it's also
possible to change values, the basic tool for building a remote control
application.

What is the effect on runtime, is there any slowdown? Is PicoQL under GPL?
Still under development or stable?

A remote-control/debug application should have a GUI/command-line
interface on a second screen, and if possible display the relevant data
structures without the user having to know the exact names, or these names
must be well-documented, so a debug system should be usable for the
developers with enough documentation for non SQL experts.
A remote application should be as complete as possible, not just in demo
state. It could even provide a mode to export ephemeris data, which some
users continue to request, but which is something Stellarium was not
developed for. But such a RC application sounds like lots of work - are
you willing and will you have time to maintain and further develop this
tool after demonstrating that it works?

What about code maintenance: It must be documented what has to be done if
Stellarium changes internally.

I would welcome such a thing if well-made and user-friendly, how about the
others? Or is a similar plugin under development already? Of course, it
should be a branch on Bazaar.

Georg


On Fr, 21.06.2013, 17:01, Marios Fragkoulis wrote:
> Dear list members,
>
> I am a PhD candidate and in the course of my research
> I have developed an open-source tool [1] that allows you to instrument
> existing
> C/C++ programs so that you can run SQL queries on their in-memory data
> structures.
> All that's needed is adding a few lines of code, and linking with our
> PicoQL library.
> I have already instrumented successfully Stellarium, two other
> mid-range C++ applications,
> HDF and FITS containers (scientific computing data formats) as well as
> the Linux kernel.
> SQL queries are issued interactively from an external interface and
> are type safe. They
> are useful in extracting knowledge out of the application's data
> structures and
> (cross-)checking system invariants using data structure state.
> For example, it is easy to instrument Stellarium's hierarchy of
> services and modules
> and combine them in queries such as the fairly trivial:
>
> SELECT * FROM Constellation;  // Get all constellations from
> vector<Constellation *>
> SELECT * FROM Planet JOIN SatellitePlanet ON SatellitePlanet.base =
> Planet.Satellites_id;  // For each
> planet in QList<PlanetP> get its satellites from
> QList<QSharedPointer<Planet> >
>
> The whole Stellarium class hierarchy can be instrumented like this.
> More information on the mapping and more queries are available here [2].
>
>  From your experience in developing Stellarium can you see specific
> uses of this work that would be
> valuable to the development team and/or the user community?
> One thought is to be able to track all stellar objects or those of a
> specific type, say planets,
> projected on screen (in viewport) at a certain time.
> I have provided support for this (without any side-effects I hope) [3].
>
> [1] https://github.com/mfragkoulis/PiCO_QL
> [2] https://github.com/mfragkoulis/PiCO_QL/tree/master/examples/Stellarium
> [3]
> https://github.com/mfragkoulis/PiCO_QL/blob/master/examples/Stellarium/stellarium_dsl.sql#L57
>
> Regards,
>
> Marios Fragkoulis
> PhD candidate
> Software Engineering and Security Lab
> Department of Management Science and Technology
> Athens University of Economics and Business
> http://istlab.dmst.aueb.gr/content/members/m_mfrag.html
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> Stellarium-pubdevel mailing list
> Stellarium-pubdevel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/stellarium-pubdevel
>


--
Dipl.-Ing. Dr Georg Zotti
Ludwig Boltzmann Institute for
  Archaeological Prospection and Virtual Archaeology (LBI ArchPro)
Hohe Warte 38
A-1190 Wien



------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Stellarium-pubdevel mailing list
Stellarium-pubdevel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/stellarium-pubdevel