This is the Linux app named DBvolution whose latest release can be downloaded as dbvolution-0.9.43.jar. It can be run online in the free hosting provider OnWorks for workstations.
Download and run online this app named DBvolution with OnWorks for free.
Follow these instructions in order to run this app:
- 1. Downloaded this application in your PC.
- 2. Enter in our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 3. Upload this application in such filemanager.
- 4. Start the OnWorks Linux online or Windows online emulator or MACOS online emulator from this website.
- 5. From the OnWorks Linux OS you have just started, goto our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 6. Download the application, install it and run it.
SCREENSHOTS
Ad
DBvolution
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
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
Audience
Developers
Programming Language
Java
Database Environment
Other API, JDBC, Oracle, MySQL, PostgreSQL (pgsql), SQLite, Microsoft SQL Server
This is an application that can also be fetched from https://sourceforge.net/projects/dbvolution/. It has been hosted in OnWorks in order to be run online in an easiest way from one of our free Operative Systems.
