I’ve finally got authentication (password access) working on my laptop for the birding site. I think I finally have enough pieces to start putting the site together, at least in terms of the coding. Content is another issue.
I have a database of nearly 10,000 bird species. Naturally that’s too large to search through if you’re just entering your backyard birds in New Jersey. I need a way, database designwise, to incorporate species lists by area…state, park, country, region, etc. THere are many ways to slice this task, but what’s the fastest? What’s the smallest? What’s the most intuitive? DO I create a separate database table for each area that I want to have a list of potential species for? That seems wasteful. A table listing the areas is reasonable, along with an ID, as a lookup table. Do I insert the species range right with the species table? That also seems awkward. The best solution it seems would be one single table that would cross pollinate (excuse the pun) and become a many to many table. One field for species ID and one field for location ID. THis table will become HUGE, however, and then slow. FOr example, say I’ve got 2000 bird species for the US, and each bird is found in 1/5 of the US states, that makes 10 states per bird, or a table with 20,000 entries. Yikes, no way! And that doesn’t include areas like national parks, sanctuaries or wildlife reserves. Mabye the best solution is to have a separate table for each area that I’d like to have a list for. Any thoughts? Did anyone follow that?
I’m still not over the loss of my last amazing medical post, so forgive the technical spewing of thoughts above.
Blogger just ate my awesome post. I could cry. I even hit the post & publish button so it wouldn’t get eaten prematurely and blogger kicked me out and asked me to log back in. My post, of course, was gone. You would have liked it too. Dammit. Sick people, procedures and emotional turmoil and resident triumph all wrapped up into one. Maybe I’ll get inspired to repost it. Or maybe I won’t. After all, you’re here to read about medical adventures and not birds, right? What? Both are OK? OK. You’ll have to settle for birds then, until I’m over the loss of my last creation.
This is a neat site if you have time to indulge in a little undersea exploration. Click on the shipwreck to explore it interactively…you are a diver and have the opportunity to examine its many artifacts. This is not a game, it is a piece of history…
Link via a commenter’s post on Misbehaving
Getting my birding site together is coming closer and closer to reality. I have learned how to create database queries from a web interface, update the data and other simple database activities. The remaining hurdles include learning authentication (member accounts) so that you get your own private bird list, and figuring out how to best transfer a large MS Access based database to mySQL without having to recreate all the tables. DOes anyone know of an easy way to do that?
I am also constantly mulling over the design interface regarding colors, layout and navigation. I have flower photos from my digital camera that I am experimenting creating diferent color palates from to skin the site with naturally grouped colors and tones.
Another nice long flight close to where we were last night. This was for an intoxicated girl who crashed into a tree. Fortunatly she was wearing her seat belt, and her worst injuries ended up being abrasions to her arms from the airbag that deployed. Based on the damage to the car, and the fact that her injuries were confined to abrasions from teh safety devices that were used (seatbelt, airbag), I bet she would have been really messed up if she had not been wearing the belt, or had an older model car without airbags. The entire front end of the car was squashed. She was discharged from the ED with her mother as soon as her alcohol level wore off.