Return to the Cloudy Nights Telescope Reviews home page


Speciality Forums >> Astronomy Software & Computers

Pages: 1
bassplayer142
professor emeritus


Reged: 10/03/11

Loc: Michigan
Making Database Observation App - NEED INPUT! new
      #5442319 - 09/26/12 08:12 PM

I'm using my new c# skills from work to make a access/database GUI app. I will lay out some particular implementations that I have decided on adding and a few extras that would come after a working product is achieved.

- Create database to store all observing session by number and date
- Search all function for searching any catagory... object, date, etc
- Keep track of Pictures/Sketches by digital upload with viewer so sketchers/astrophotograhy people can use it

I hope to ...

- link a given object to all other names M objects, NGC, IC...
-Backup every session in Excel format for ease of viewing and backup safety


I need Ideas!!! This software will be compiled and uploaded on this thread in the future for anyone to use free of charge.

Any ideas, input, or things I left out would be very helpful. I would like to build the basic GUI before I delve into the real coding if possible.

I could start with some input on what particular entries a standard log has. So far for each session I have...

-seeing, transparency, date, location, name, general notes

and for each object...

object name, object number, description, magnification, future notes, ...

Thanks


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pauls72
professor emeritus
*****

Reged: 10/28/07

Loc: LaPorte, IN
Re: Making Database Observation App - NEED INPUT! new [Re: bassplayer142]
      #5442386 - 09/26/12 08:48 PM

Why not use something like MS Access, SQL Express, MySQL or even just Excel by itself?

Post Extras: Print Post   Remind Me!   Notify Moderator  
bassplayer142
professor emeritus


Reged: 10/03/11

Loc: Michigan
Re: Making Database Observation App - NEED INPUT! new [Re: Pauls72]
      #5442437 - 09/26/12 09:12 PM

A nicer product for one that shouldn't be difficult to use. Since I have never used Access before I couldn't tell you if it can do everything I plan to do.

-Store pictures and view them?
-Keep track of how many objects were observed in each list?
-Check off objects that were observed from a list ex (herschell 400)
-generate a nice report in xls format

etc


Post Extras: Print Post   Remind Me!   Notify Moderator  
bassplayer142
professor emeritus


Reged: 10/03/11

Loc: Michigan
Re: Making Database Observation App - NEED INPUT! new [Re: bassplayer142]
      #5457049 - 10/05/12 07:56 PM

Admin, could I get this thread transferred over to software section? I realize I could gain a lot more interest and ideas there. If not, I can restart it.

Thanks!


Post Extras: Print Post   Remind Me!   Notify Moderator  
csa/montana
Den Mama
*****

Reged: 05/14/05

Loc: montana
Re: Making Database Observation App - NEED INPUT! new [Re: bassplayer142]
      #5457295 - 10/06/12 12:32 AM

I'll transfer it for you.

Post Extras: Print Post   Remind Me!   Notify Moderator  
llanitedave
Humble Megalomaniac
*****

Reged: 09/26/05

Loc: Amargosa Valley, NV, USA
Re: Making Database Observation App - NEED INPUT! new [Re: csa/montana]
      #5458738 - 10/07/12 02:15 AM

If your database is going to be embedded in the application, it might be more compact (and higher performance) to use sqlite3 rather than Access. Also using a language like Python rather an c# will allow it to be cross-platform.

Ah, never mind on Python, I read again and I see the motivation for c#.

This link sends you to a tutorial on embedding sqlite3 in a c# application with a Metro interface.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Thomas Pfleger
Vendor - Eye&Telescope Software


Reged: 04/25/06

Loc: Germany
Re: Making Database Observation App - NEED INPUT! [Re: llanitedave]
      #5464882 - 10/11/12 06:15 AM

Hi,

I suggest that you have a look at the <OpenAstronomyLog> XML format designed to exchange observations. There is everything in that you will probably "invent" for yourself. If you work on a software, the <OpenAstronomyLog> project members (including myself) would appreciate if you support this format.

In my own software, I use the MS Access database format for persistence because on a Windows machine it requires no extra setup during installation. ADO is included in Windows since XP. Using it with C# should cause no problems. If I would consider using another database, it should require no setup by the user of the program.

Greetings from another bass player (Kubicki Factor 4 string fretless, Status Energy 5 string) ;-)

Tom


Post Extras: Print Post   Remind Me!   Notify Moderator  
bassplayer142
professor emeritus


Reged: 10/03/11

Loc: Michigan
Re: Making Database Observation App - NEED INPUT! new [Re: Thomas Pfleger]
      #5495189 - 10/29/12 07:29 PM

Thanks for all suggestions so far. I'm not sure about some of those mentioned software and databases. One reason I chose the access database was for flexibility and backup considerations for anyone who uses the software and then would stop or have an issue with it. I'm not a genius developer in visual studio.

Needless to say, I've made good progress in being able to get data in and view it back out in the program. I have a good search and search all routine for searching through any of the criteria. My next step will be adding an exportable form and uploading images. I'll check out that XML form also as it sounds interesting. I've no real experience in xml though! I've added functionality to add all your equipment into a separate database in order to make selection and input of observations easier and more exact.

Maybe soon I can upload a few pictures or a beta version if anyone is interested.

P.S. Musicman Stringray 4 string

Edited by bassplayer142 (10/29/12 07:30 PM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
bassplayer142
professor emeritus


Reged: 10/03/11

Loc: Michigan
Re: Making Database Observation App - NEED INPUT! new [Re: bassplayer142]
      #5495194 - 10/29/12 07:33 PM

By the way, does anyone know where a list that shows all NGC, IC, Messier, etc objects and their duplicates? I've not found a good way to select one object and have the software automatically recognize the duplicates.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1


Extra information
1 registered and 13 anonymous users are browsing this forum.

Moderator:  richard7, kkokkolis 

Print Thread

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled


Thread views: 1072

Jump to

CN Forums Home




Cloudy Nights Sponsor: Astronomics