Depeche is an easy to use, Java based database mapper. It enables you to work with databases using data structures, queries are lists of records, and records are maps of field names to field values.
Here are some key features of "Depeche":
· No checked exceptions.
· Dynamic query building using simple methods; also, queries can be passed around and used to create other queries.
· Also welcome to use raw SQL.
· Lazy evaluation - don't run queries unless/until you need to.
· Result caching - after running a query once, it stores the results so it doesn't need to run again. If you want to run it again, just clear the results or use a new query.
· No problem with multiple-column primary keys and foreign keys.
· Simple transaction support
· No configuration required, but supports configuration through "properties files" and JNDI
· Currently supports PostgreSQL, MySQL, MS SQL Server and FileMaker; support for other databases can be added easily.
Requirements:
· Java
· SLF4J