I've used DBI for years and I liked learning it, and learning it. Maybe the right phrase would be "in an every-learning state". I used to roll my own schema system and still do try to hide SQL in subs. But I have a few queries (sorry).
- at first I felt a little dyslexic reading the hashes/arrays method names. I'd much prefer hashlist/arraylist, or even LoH/LoL. A plural word just got me somehow, maybe you'd like to add a synonym.
- Another niggle, seems that a Group By would be more efficient than doing a query for each order in your example of nested queries on two databases. No problem for your audience I'd guess, but you might like to mention the idea of database overhead in your docs.
- I also was intrigued by DBIx::Easy, the makemap and serial methods for example seemed to answer questions I once had when learning databases, and then picked up or rolled my own. I'm sure you've looked at it, but it does have an interesting take on the meaning of the term "easy".
I was going to suggest doing something more radical to make things easy, something like a smart gun - point it in the general direction of the opposing forces and you get a bullseye. Maybe EasyDB tried to do that. Can you make it even easier than that module? I'm thinking of not forcing the user to do any of those loops or anything, just hand coderefs for an error sub and a sub that says what to do with each returned value. Anyway your take on it seems fine. Was hoping for something easy enough to lure PHP users back to Perl. :)
- I am a little worried about people not being able to step up to DBI, perhaps you'd like to mention differences or things left out with regard to big old DBI. In fact tons of really easy to understand documentation about databases would be wonderful for beginners.
- If there is anything else, I'd ask for more methods that do things common to web site work so that people aren't always rolling their own. One example is authentication and cookies. There are lots of ways to do it, but even if the answer is "leave it to Apache" it would be invaluable for you to provide such a facility with ample installation, usage, and philosophy docs. "Simple" doesn't mean the programmer is simple-minded or uneducated, it could just mean "I've rolled my own umpteen times but would like to get something stable that works done ASAP and go home at a reasonable hour without delving into my code catacombs". So, making hard things Simple would be a good code word. Then making really hard things Simple, etc. (thanks Zeno).
Hope this helps.
Matt
In reply to Re: DBIx::Simple
by mattr
in thread DBIx::Simple
by Juerd
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |