Re: eDBI and SQLite
- Posted by jeremy (admin) Sep 13, 2009
- 1239 views
This is technically v nice, and I can see the advantage of having a unified database front end. My only niggle with this system is that the lowest common denominator has to be accommodated. I can't think of any specific examples, but there are some API functions present in sqlite, not present in the others, and some SQL is not supported in sqlite that is supported in the others, and could lead to misunderstandings in production code.
Yes, this is always the problem with a cross-db interface.
I am unlikely to switch to MySQL or PostgreSQL in the near future (although its not totally impossible), and this is a worthwhile project, but its fairly unlikey that I'm going to be able to add anything useful to what you are doing (or as prolifically as you do)
If the application in question does not plan to nor benefit from multiple databases, then I would use a native database library as well, and do with PostgreSQL.
Jeremy
