Database Abstraction Layer
Posted: Tue Jul 15, 2008 5:47 pm
I had started a thread about this before here, but I'd actually like to get the code itself critiqued if anyone would be so kind.
This is a very, very early pre-release of a database abstraction layer. It has some similarities to a few different patterns, but doesn't follow any of them exactly as far as I know. The best way to describe it may be to call it an SQL generator. Right now it only works for MySQL and it doesn't currently support views or transactions, but it does support joins and subqueries and a few other basic things. There is another class (not included in this package) that handles data definition language (DDL) statements that will also eventually accompany the package, as will support for other DBMS's like PostgreSQL, Oracle, MS SQL, DB2, etc. More about it can be read in the readme.txt file, in the comments in the code, and in the thread above.
For a test script, I included a limited user management file using the abstraction layer.
Any comments, critiques, suggestions, or questions would be greatly appreciated. Thank you in advance.
This is a very, very early pre-release of a database abstraction layer. It has some similarities to a few different patterns, but doesn't follow any of them exactly as far as I know. The best way to describe it may be to call it an SQL generator. Right now it only works for MySQL and it doesn't currently support views or transactions, but it does support joins and subqueries and a few other basic things. There is another class (not included in this package) that handles data definition language (DDL) statements that will also eventually accompany the package, as will support for other DBMS's like PostgreSQL, Oracle, MS SQL, DB2, etc. More about it can be read in the readme.txt file, in the comments in the code, and in the thread above.
For a test script, I included a limited user management file using the abstraction layer.
Any comments, critiques, suggestions, or questions would be greatly appreciated. Thank you in advance.