This is a software for development of data access layer.

  • No ORM: only meta-programming and code generation.
  • No exotic databases: only RDBMS.
  • Old school SQL at design-time. Some helpers to generate SQL but no attempts to replace SQL with something.
  • Using of "database first" rather than "object model first".
  • Strong typing of generated code: the types are compatible with DB-schema.
  • 3 tables or 30: no problem.
  • The simplest design patterns: DTO, DAO.
  • Multiple target languages: PHP, Java, C++, Objective-C, C#.
  • Applicable for many types of applications: PHP, GWT, JSF, Android, iOS, .NET, ATL, and many others.
  • Free and Open Source. Everyone is welcome to contribute.

Projects:

  1. SQL DAL Maker is a generator of DTO and DAO classes. Target programming languages: PHP, Java, C++, Objective-C. There are plug-ins for Eclipse, IntelliJ IDEA, AppCode, PhpStorm, Android Studio.
  2. A fork of sqlite-jdbc by Xerial with meta-data improvements.
  3. SQL DAL Maker for .NET: T4 generator of DTO and DAO-like classes from XSD-file of typed DataSet.

Links:

Project files http://sourceforge.net/projects/utils4dal/files/
SVN http://sourceforge.net/p/utils4dal/code/HEAD/tree/

TODO:

  1. Priority 1: Improve ParameterMetaData features of SQLite JDBC Driver.
  2. Priority 2: Implement functionality for stored procedures.