|Problems? Is your data what you think it is?|
2Re: Can SQL be used without a database?by jeffa (Bishop)
|on Dec 30, 2003 at 19:55 UTC||Need Help??|
I can vouch for DBD::SQLite. It rocks. :) The first hurdle with SQLite is the fact that you have to have an egg before you can have chickens. What i mean is that you first have to write a script that creates (and then optionally populates) the database file. Something as trivial as:
However, you may notice from the code that i am supplying the ID. I do not think that SQLite offers auto-incremented ID's for you.
Alternatively, if you already have your data stored in another format, check out SQL Fairy before you roll your own.
Here is are updated lines for the snippet above:
Much better. ;)
L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)