You are not logged in. [Login] Entrance · Main Index · Search · New user · Who's Online FAQ · Calendar

Speciality Forums >> Astronomy Software & Computers Previous   Index   Next   Threaded

Pages: 1 bassplayer142 professor emeritus Reged: 10/03/11 Loc: Michigan Making Database Observation App - NEED INPUT!       #5442319 - 09/26/12 08:12 PM Edit   Reply   Quote Quick Reply   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:       Pauls72 sage Reged: 10/28/07 Loc: LaPorte, IN Re: Making Database Observation App - NEED INPUT! [Re: bassplayer142]       #5442386 - 09/26/12 08:48 PM Edit   Reply   Quote Quick Reply   Why not use something like MS Access, SQL Express, MySQL or even just Excel by itself? Post Extras:       bassplayer142 professor emeritus Reged: 10/03/11 Loc: Michigan Re: Making Database Observation App - NEED INPUT! [Re: Pauls72]       #5442437 - 09/26/12 09:12 PM Edit   Reply   Quote Quick Reply   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:       bassplayer142 professor emeritus Reged: 10/03/11 Loc: Michigan Re: Making Database Observation App - NEED INPUT! [Re: bassplayer142]       #5457049 - 10/05/12 07:56 PM Edit   Reply   Quote Quick Reply   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:       csa/montana Den Mama Reged: 05/14/05 Loc: montana Re: Making Database Observation App - NEED INPUT! [Re: bassplayer142]       #5457295 - 10/06/12 12:32 AM Edit   Reply   Quote Quick Reply   I'll transfer it for you. Post Extras:       llanitedave Humble Megalomaniac Reged: 09/26/05 Loc: Amargosa Valley, NV, USA Re: Making Database Observation App - NEED INPUT! [Re: csa/montana]       #5458738 - 10/07/12 02:15 AM Edit   Reply   Quote Quick Reply   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:       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 Edit   Reply   Quote Quick Reply   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:       bassplayer142 professor emeritus Reged: 10/03/11 Loc: Michigan Re: Making Database Observation App - NEED INPUT! [Re: Thomas Pfleger]       #5495189 - 10/29/12 07:29 PM Edit   Reply   Quote Quick Reply   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:       bassplayer142 professor emeritus Reged: 10/03/11 Loc: Michigan Re: Making Database Observation App - NEED INPUT! [Re: bassplayer142]       #5495194 - 10/29/12 07:33 PM Edit   Reply   Quote Quick Reply   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:       Pages: 1

Previous   Index   Next   Threaded

Extra information 2 registered and 6 anonymous users are browsing this forum. Moderator:  Bowmoreman, richard7  Print Thread Forum Permissions       You cannot start new topics       You cannot reply to topics       HTML is disabled       UBBCode is enabled Thread views: 939 Jump to *Announcements and News* -----   Cloudy Nights Announcements   Discussion of CN Articles, Reviews, and Reports   Celestial Events*General Astronomy* -----   Beginners Forum   General Observing and Astronomy   Outreach   Light Pollution*Equipment Discussions* -----   ATM, Optics and DIY Forum   Binoculars   Binoviewers   Cats & Casses   Classic Telescopes   Equipment   Eyepieces   Mounts   Observatories   Reflectors   Refractors    Video and Electronically Assisted Astronomy*Astrophotography and Sketching* -----   Beginning and Intermediate Imaging   Film Astrophotography   DSLR & Digital Camera Astro Imaging & Processing   CCD Imaging & Processing   Solar System Imaging & Processing   Sketching   Astro Imaging/Sketching Contest *Observing* -----   NEO   Planetary and Solar System Observing   Lunar Observing   Deep Sky Observing   Double Star Observing   Solar   Variable Star Observing and Radio Astronomy*Telescope Specific Forums* -----   Celestron NexStar    NexStar GPS / CPC Telescopes   Questar Forum   Meade ACF/RCX / LX / GPS    Meade ETX*Speciality Forums* -----   Arizona Science and Astronomy Expo   NEAF (Northeast Astronomy Forum) and NEAIC (Northeast Astro Imaging Conference)   AstroArt   Astronomy Clubs and Star Parties   Astronomy Software & Computers   AstroWebsites   Science! Astronomy & Space Exploration, and Others   Space Rocks   Stellar Media*Swap and Shop* -----   Shop and Swap Audio Components*CN Feedback and Vendor Announcements* -----   Vendor and Group Announcements*International Year of Astronomy 2009 - Forums are now closed.* -----   IYA Archive Info

CN Forums Home