Okay, so today I decided to mess around with ODB, specifically trying to make a “pro wrestler” profile. I’m not a database expert, just a guy who likes to tinker, so bear with me.
First, I fired up ODB. I already had it installed from a previous project (don’t even remember what it was, honestly). I gotta say, the interface is pretty straightforward, even for a dummy like me.
Setting Up the Table
I started by creating a new table. I named it “Wrestlers”, pretty original, I know. Then came the fun part – deciding what info to include about each wrestler. I figured these were essential:
- Name: Obviously. Can’t have a wrestler without a name!
- Alias: Their cool wrestling name.
- Finisher: Their signature move.
- Wins: How many matches they’ve won.
- Losses: How many times they’ve gotten their butt kicked.
Creating feilds type
I spent the next hour to figure out how to add each field and the data types.
The data type I selected each of fields.
- Name: Text
- Alias: Text
- Finisher: Text
- Wins:Interger(Number)
- Losses: Interger(Number)
After I set them up, I add some data to test Wrestlers’s table
Entering the Data
Now for the really “creative” part. I started making up wrestlers. I came up with gems like:
- Name:Bob Smith, Alias:The Smasher, Finisher: The Pancake Press, Wins:12,Losses: 24
- Name:Dave Jone, Alias:Dr. Doom, Finisher:The Bone Cruncher, Wins:35, Losses: 2
- Name:Mike Sam, Alias:Mr. Nice Guy, Finisher: The Apology (it’s a surprisingly effective move), Wins:1, Losses:50
I filled in a bunch more, just random stuff that popped into my head. It was actually pretty fun, like creating my own little wrestling universe. I could probably use a random name generator to do this faster, might do it next time.
The Result
In the end, I had a table full of wacky wrestlers. It’s nothing fancy, but it works! I can see all their stats, their ridiculous names, and their even more ridiculous finishing moves. I can even sort them by wins, to see who my top “champion” is (it’s Dr. Doom, in case you were wondering).
So, that was my little ODB adventure for the day. Not exactly groundbreaking stuff, but hey, I learned something new, and I had a good time doing it. Maybe tomorrow I’ll try to figure out how to make it look a little less… basic. Or maybe I’ll just add more wrestlers. Who knows!
