Database independent code
- From: rabbit@xxxxxxxxx (Peter Rabbitson)
- Date: Sat, 28 May 2005 15:28:40 -0500
Hello,
I need to implement some database access in my code, and my knowledge of
databases is pretty basic (mostly MySQL ans flat un-indexed tables). Can
somebody point me to advanced tutorials on database independent code? For
example I can't find a way to tell what methods from DBI and family can I
use without concern that the code will break if tomorrow the database engine
will have to change.
Also I am trying to figure out what is the most commonly accepted way of
storing complex data structures like arrays-of-hashes-of-hashes-of... in
databases. The first thing that comes to my mind is describing the entire
branch in each table row, in other words working the enumeration back to the
root of the structure, ordering the rows accdording to key and array index
occurences. This however does not seem very efficient as far as table size
management goes. Some preliminary searching turned up a possibility of
storing XML as table data which also seems too inefficient to me.
So anyway, if someone could share a good reading on the subject that he came
upon would be most helpful.
Thanks
Peter
.
- Prev by Date: Re: absolute path of current process
- Next by Date: Hash of Arrays, p. 276
- Previous by thread: count rows without count(*)
- Next by thread: Hash of Arrays, p. 276
- Index(es):
Relevant Pages
|
