Use the tools provided by the IDE, framework, and data model to swiftly get the exact data from the database
The API is built from the ground up to show you where everything is and how it works
Never learn another variant of SQL, don't even bother with the first, just generate the data model and go!
Separate your data model from your business logic but have it accessible at all times
DBvolution works with your IDE, not against, allowing you to use all the tools provided. Use code completion, refactoring, the integrated debugger, everything offered by the IDE because DBvolution gives you access to the database via pure Java code
Learning the skills for 1 database is the same for all databases.
All the syntax, and even code, is exactly the same, so you can take the lessons from one project and apply them directly to the next.
Not all databases are created equally but you don't want to give up SQLite's lightweight implementation just to get Spatial
DBvolution implements all the features for all the databases, so you don't have to live without just because the database people haven't caught up
DBvolution allows you to run a transaction using one method call: use DBScript.implement()
Testing a transaction is even easier: DBScript.test()
DBScript encapsulates a distinct transaction into one method creating an analogue of database transaction behaviour. It even rollbacks automatically if an exception occurs
Most of the time you know exactly what you want from the database but you just have to get it
DBvolution make this easy by implementing query-by-example: simply create a DBRow-based object with the features you want and add it to the query
The defined features are included in the query and only items matching those features are returned
This method work especially well with DBTable