Search Results for "sql query analyzer"

...Use great SQL, never generate SQL cartesian product, always honor relational limit/offset. For ORM queries Ebean can profile the object graph being used and either automatically tune the query. Docker test containers for all the supported databases. Get 100% test coverage on all the features of the database we use. We can build queries using type safe query beans.

MyBatis-Plus is an enhanced toolkit for MyBatis, designed to simplify development and increase productivity. It provides a range of out-of-the-box features such as code generation, conditional query builders, and pagination plugins, reducing boilerplate code and streamlining database operations. MyBatis-Plus is widely used in enterprise applications for its efficiency and ease of use.

PrestoSQLite is the best ORM for sqlite written in java. It can map database tables with EntityAdapter class, which you can use to build sql query or if you don't like handling sql language you can only use entity class which provides functions to read, save and delete data from tables (CRUD) . Also with SQLiteQueryAdapter you can read data using complex query statements without directly using the sql language. To finish using the SQLBuilder class you can have your query written to be used directly with the SQLite JDBC Driver to have the best performance without unnecessary frills.

...It relieves developers from dealing with low-level database requirements while saving development time. SQLite is an awesome embedded relational database. Still, writing SQL and parsing query results are quite tedious and time-consuming tasks. greenDAO frees you from these by mapping Java objects to database tables (called ORM, “object/relational mapping”). This way you can store, update, delete, and query for Java objects using a simple object oriented API. We want to provide the fastest Android ORM.

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...

Using this library you can focus on how you want to map results of your SQL query to your domain objects. You don't need to use any xml configuration (like, for example in MyBatis/iBatis). You also don't need to use any annotations to run SQL Mapper. The SQL Mapper is similar to Spring JDBC Framework, but it has some of its features simplified and some changed. It runs on JDK 7 or higher. The zip archive contains the library jar, sources and javadocs, and also a demo which shows how to use the mapper. ...

Lettuce allows Java programmers writing direct SQL queries in Java codes. It defines SQL keywords in Java classes, and it also introduces a way easily combining these keywords to create a versatile query in Java.

MockSqlBuilder uses mock objects and method interception to build SQL queries in an OOP fashion. Instead of strings (like HQL or plain text), MockSqlBuilder uses the data object's and their methods to record and construct a query.