Now stored at https://github.com/gregorydgraham/DBvolution

Available from Maven Central: nz.co.gregs.dbvolution

Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes.

Simple declaration of a DB table:

@DBTableName("mytable")
public class MyTable extends DBRow {

@DBColumn("numeric_code")
@DBForeignKey(Code.class)
private DBNumber numericCode = new DBNumber();
@DBColumn("uid_mytable")
@DBPrimaryKey
@DBAutoIncrement
private DBNumber uidMyTable = new DBNumber();
}

Easy Gets:
List<MyTable> myRows = myDB.get(new MyTable());
MyTable row = myDB.getDBTable(new MyTable()).getByPrimaryKey(61176904);

Natural and Outer Joins and Criteria:
CarCo carCo = new CarCo();
carCo.name.isLiterally("GM");
List<DBQueryRow> results = myDB.get(carCo, new Marque());
dbQuery.addOptional(new CarModel());

Easy debugging:
query.getSQLForQuery();

Simple processing:
db.print(query.getAllRows());
List<Marque> marques = query.getAll

Features

  • Java objects all the time
  • Database abstracted and no SQL required
  • Aims to handle 99% of your everyday SQL without any SQL
  • Supports the other 1% of SQL by supporting views and queries just like tables
  • Automatically capture your schema whatever the size, tested on 800+ table/view schema
  • Add relational semantics into Java code without altering any code or the database
  • Query across multiple tables with as little as one line of code
  • Clear, concise query criteria
  • Automatically detects missing Primary Keys based on Foreign Keys
  • Automatically prevent common errors like blank queries and cartesian joins
  • Easily use the DB objects within JSP pages using get/set methods

Project Samples

Project Activity

See All Activity >

License

Creative Commons Attribution License

Follow DBvolution

DBvolution Web Site

Other Useful Business Software
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of DBvolution!

Additional Project Details

Intended Audience

Developers

Programming Language

Java

Database Environment

Other API, JDBC, Oracle, MySQL, PostgreSQL (pgsql), SQLite, Microsoft SQL Server

Related Categories

Java Front-Ends, Java Object Oriented Software, Java Object-Relational Mapping (ORM) Software

Registered

2013-05-08