DBvolution Icon

DBvolution

Java library to remove Object/Relation Impedance

Add a Review
2 Downloads (This Week)
Last Update:
Download dbvolution-0.9.43.jar
Browse All Files
Windows Mac Linux

Screenshots

Description

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

DBvolution Web Site

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

KEEP ME UPDATED

Other Useful Business Software

The Leading Provider of Business VoIP Phone Systems Icon

Award-Winning Business VoIP Phone System

The Leading Provider of Business VoIP Phone Systems Icon
1 of 5 2 of 5 3 of 5 4 of 5 5 of 5
62 Reviews
  • Unlimited Calling, Faxing, Video Conferencing
  • 24/7 U.S Based Customer Support
  • Super Reliable, Simple to Use
Write a Review

User Reviews

Be the first to post a review of DBvolution!

Additional Project Details

Intended Audience

Developers

Programming Language

Java

Registered

2013-05-08

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, thanks