Database program

I am trying to create a pedigree database with specific features I have not found in other programs.

It would only need to be on my PC no net publishing or anything.

Anyone???
Lisa

 

Hi Lisa,

What software do you have access to?
How big a base are you looking at? (How many entries?)
How complex do you think this is?

Best
DerekJ

 

Wow it's been almost 2 years LOL

Is there anyone that can help me with this? Feel free to PM me.

To answer Derek's questions...
I have Office, VB, Adobe CS4, can obtain what is needed within reason, entries? several thousand, not very complex in my opinion.

I am needing a database to enter pedigree's and flag specific traits to later be pulled up as a group. I can explain better if needed. I am doing a genetic marker study.

Google: All Breed Horse Pedigree Database (don't remember if we can add links here) It is a great resource, but I want to be able to pick the "reports" as an example, type in secretariat, chose the thorougbred.

 

If you require database software, then MySQL is the freeware of choice. This may require a fair bit of RTFM to use however.

If you have a full version of Office, you might also have Microsoft Access, which could do the trick for you. It is a little friendlier to use, although, not as scalable as MySQL.

 

Ok! LOL which MySQL should I attempt to tackle?

I do have Access so I may try that as well. Just hadn't gotten very far with it.

 

Oh, jumpin'... I didn't realize how difficult it was to find the basic, free version on the mySQL site. :-o

I'll do you one better. I'll recommend xampp. This is a mySQL database, pre-configured for you, and it comes bundled with some other software, like a web server, and a mailserver, but most importantly, a program called phpMyAdmin, which lets you graphically administer your mySQL databases. This should reduce the learning curve for you quite significantly.

 

If you're looking to write a custom program for yourself then might I suggest something lighter than any sort of MySQL such as SQLite. It's like MySQL except that there's no server/client relationship. It's simply a library that you link with your application and all your database operations are merely file manipulations. It's very simply to use and a very good SQL implementation. I highly recommend it!

Furthermore, I'd also recommend writing your program in a high level language such as Python or Ruby. They will make development much faster, easier and fun! SQLite bindings exist for both languages...