A Java ORM framework using ActiveRecord pattern that enables writing SQL expressions with Java syntax for rapid development.
ObjectiveSQL is a Java ORM framework based on the ActiveRecord pattern that enables developers to write SQL expressions using Java syntax. It simplifies database interactions by generating code dynamically and supporting complex relational queries without extensive configuration. The framework is designed for projects focused on data analysis and arithmetic-heavy SQL operations, providing a type-safe and intuitive way to build queries.
Java developers working on data-intensive applications, especially those dealing with relational databases and complex SQL expressions, who seek to reduce boilerplate code and configuration overhead.
Developers choose ObjectiveSQL for its ability to write SQL directly in Java with operator overloading, eliminating the need for string-based queries and reducing errors. Its convention-over-configuration approach and dynamic code generation accelerate development while maintaining clean, maintainable code.
Writing SQL using Java syntax
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
With a single @DomainModel annotation, Java classes gain full SQL capabilities, eliminating boilerplate code as demonstrated in the simple Member class example.
Supports has_one, has_many, and belongs_to relationships with easy paged and relation querying, shown in the Member.queryAll(Member.HAS_MANY_ORDERS) examples.
Enables writing SQL expressions like arithmetic and comparison using Java operator overloading, making query building safer and more intuitive, as seen in the complex select.where() example.
Automatically generates database access code, reducing manual coding and configuration files, which is highlighted in the 'Why ObjectiveSQL' section for data analysis projects.
Requires an IntelliJ IDEA plugin for full functionality, limiting developers using other IDEs and adding tooling overhead.
Compared to established ORMs like Hibernate, ObjectiveSQL has a smaller community and fewer third-party integrations, which could affect support and adoption.
While it promotes convention over configuration, setting up for non-standard databases or custom scenarios requires careful Maven dependency management, as indicated in the installation section.