Hey all. If you’ve been meaning to get around to learning to use databases but didn’t want to go and do those dry, boring examples out on the interwebs, some cool guy or gal put together a database of D&D stuff into an SQLite database. We’re talking classes, equipment, domains, feats, items, monsters, power, skills AND spells! That sure makes tinkering around with SQLite a lot more fun I must say!
Link here:
http://www.andargor.com/files/srd35-db-SQLite-v1.3.zip
It’s kinda huge (12.7MB)
Mind you I don’t think you can use the database in your own projects (Check the OGL license, *Im not a lawyer, blah blah blah* using non Wizards of The Coast IP *Blah blah*) but for tinkering around it’s awesome!
Check it:
select name,description from spell where name like '%armor%'yields
Armor of Darkness
The spell envelops the warded creature in a shroud of shadows. The shroud can, if the caster desires, conceal the wearer’s features. In any case, it grants the recipient a +3 deflection bonus to…SNIPPED FOR BREVITY
Epic Mage Armor
An invisible but tangible field of force surrounds the subject of epic mage armor, providing a +20 armor bonus to Armor Class…SNIPPED FOR BREVITY
Seed: Armor
This seed grants a creature additional armor, providing a +4 bonus to Armor Class. The bonus is either an armor bonus or a natural armor bonus, whichever…SNIPPED FOR BREVITY
Mage Armor
An invisible but tangible field of force surrounds the subject of a mage armor spell, providing a +4 armor bonus to AC.
Unlike mundane armor, mage armor entails no armor check penalty, arcane spell failure chance, or speed reduction. Since mage armor is made of force, incorporeal creatures can’t bypass it the way they do normal armor.
(Yeah, the results include HTML formatting cause I think it was geared to web display but it’s easy enough to strip out some tags if you really want to)
Another example:
select name,attack from monster where family like '%Abomination%'
Anaxim Spinning blade +43 (2d6+12/19-20 (plus 1d6 on critical)) or electricity ray +35 ranged touch
Atropal Touch +49 (2d6 Con drain/19-20) melee touch
Chichimec Primary wing buffet +39 (2d6+12) melee
Dream Larva Bite +56 (4d8+16)melee
Hecatoncheires Greatsword +73 (2d6+20/17-20) melee; or boulder +55 (2d8+20/19-20) ranged
Infernal +58 claw (4d6+16) melee
Phaethon pseudopod slam +85 (4d8+24 plus fire damage) melee
Phane Incorporeal touch +43 (1d6 plus stasis touch) melee
Xixecal Claw +95 (2d8+28/19-20) melee
Just go nuts! I’ve had such a blast learning SQLite queries with this database cause as a nerd, I can actually relate to the contents VS some dumb examples about a dumb CD collection with dumb id’s and dumb serial numbers and dumb relational yada yada! JUST GIMME THE DATA!!! 
select name from monster where size like '%Tiny%'
select \* from monster where name like '%Golem%'
select \* from monster where name like '%Golem%' and size like '%Huge%' and attack like '%Slam%' REMEMBER: the queries are CASE SENSITIVE so if you don’t get results, check your case.
No offense to anyone who does dry, boring database programming for their day job! I’ve got an Adamantine Golem on my side.
-Mario [import]uid: 11636 topic_id: 19158 reply_id: 319158[/import]