Projects

Hibernate Spatial

Hibernate Spatial is a generic extension to Hibernate for handling geographic data. It is generic in the sense that it works in the same way across different databases. Hibernate Spatial allows you to deal with geographic data in a standardized way, whatever database that you use (as long as a ... [More] Spatial Dialect Provider exists for it). In other words, it abstracts away from the specific way your database supports geographic data, and provides a standardized, cross-database interface to geographic data storage and query functions. Hibernate Spatial supports most of the functions of the OGC Simple Feature Specification. [Less]

Steam Condenser

The Steam Condenser is a multi-language library for querying the Steam Community, Source and GoldSrc game servers as well as the Steam master servers. Currently it is implemented in Java, PHP and Ruby.

Querydsl

Querydsl is a framework which enables the construction of statically typed SQL-like queries. Instead of writing queries as inline strings or externalizing them into XML files they can be constructed via a fluent DSL/API. The benefits of using a fluent API in comparison to simple strings are ... [More] * code completion in IDE * almost none syntactically invalid queries allowed * domain types and properties can be referenced safely * adopts better to refactoring changes in domain types [Less]

MetaModel

The eobjects.org MetaModel is a project created for maximum reuse of a domain model of the database domain. The MetaModel is a model that contains classes that represent the structure of a database (schemas, tables, column, relationships) and interaction with the database (queries) using ... [More] SQL/LINQ-style expressions. In short a model for modelling (hence the word "metamodel") data in databases and other datastores like CSV-files, MS Access files and Excel spreadsheets. [Less]

sbql4j

An extension to Java language with an engine based on Stack-Based Architecture (SBA) It provides capabilities similar to Microsoft LINQ for Java language. Allows to process Java objects with queries. SBQL4J follow software engineering principles such as orthogonality, modularity, minimality ... [More] , universality, typing safety, and clean, precise semantics. Code with queries are parsed by preprocessor integrated with OpenJDK Compiler. SBQL4J builds AST query trees which are then analyzed and as output Java code is produced. It integrates tightly with Java which means: Java variables can be used in queries directly (no special syntax like setParameterX is required). Queries returns Java objects (collection or single object depending on query and used Java types). Java methods and constructors can be invoked inside queries. Query language is type-safe - queries are checked in compile time. Queries can be translated to pure Java code (with no reflection usage) so execution is very fast. (Description) SBQL4J gives Java developers full power of SBQL query language . Multiply nested and complicated queries are well-supported, which can't be written in any other query language (including LINQ). Available operators: arithmetic: +, -. *, /, %, == , != , >, =, 0 and unitPrice > 3.00 };Selects all orders, while referring to customers by the order in which they are returned from the query (example from LINQ page). (Model description) List customers = getCustomerList(); List customerOrders = #{ (customers as c). ($index as custIndex, c.orders as o). ("Customer #"+(custIndex + 1)+" has an order with OrderID "+o.orderID) };This sample uses an order by operator with a custom comparer to sort first by word length and then by a case-insensitive sort of the words in an array (example from LINQ page). String[] words = { "aPPLE", "AbAcUs", "bRaNcH", "BlUeBeRrY", "ClOvEr", "cHeRry" }; Comparator comp = new Comparator() { @Override public int compare(String o1, String o2) { return o1.toLowerCase().compareTo(o2.toLowerCase()); } }; List sortedWords = #{ words as w order by w.length(); w using comp }; Is it true that each department employs an employee earning the same as his/her boss? (Model description) List dept = data.getDepts(); Boolean res = #{ all (dept as d) any ((d.employs minus d.boss) as e) (e.salary == d.boss.salary) };Get the minimal, average and maximal number of employees in departments. (Model description) List dept = data.getDepts(); Struct res = #{ min(dept.count(employs)) as minimum, avg(dept.count(employs)) as average, max(dept.count(employs)) as maximum };For each employee get the message containing his/her name and the percent of the annual budget of his/her department that is consumed by his/her monthly salary (Model description) List emp = data.getEmps(); List res = #{ emp.("Employee " + name + " consumes " + (salary * 12 * 100 / (worksIn.budget)) + "% of the " + worksIn.name + " department budget.") };See more executable examples (about 90 queries) in download section. There is a run-ready Eclipse project with build SBQL4J library and examples. [Less]

Squeryl

Squeryl is a strongly typed, declarative DSL for manipulating database objects from within the Scala language

XMLToaster

XMLToaster is a two way database to XML mapping tool. It maps XML messages directly into database tables and extracts data into XML documents. It uses a simple SQL "select" like statement to extract data into XML documents of arbitrary complexity. It scales to handle very complex ... [More] mappings such as might be found when extracting from a legacy database into an ESB service catalog. Persistence is currently through an XML mapping file, shortly to be replaced by more user-friendly SQL style update statements. The persistence engine is also capable of handling enterprise level requirements. Key features: - Simple XML message generation from a database. - Quick and easy persistance of XML messages to the database without the traditional coding overhead. It specialises in handling very complex mappings of XML to tables. [Less]

lucene-test

Sandbox for testing Apache Lucene features. Nothing relevant for now.

jlightqueryer

A simple light java queryer through JDBC drivers.

jdbquery

One single interface for querying any database engine that supports JDBC. A Useful tool for all developers Main Objectives - Window to create new connections (Shows history of connections) - JDBC Driver repository - Schema Browser - SQL Syntax highlighting - SQL History - export to CSV , tab ... [More] delimited etc - User creatable SQL buttons (Example view sessions in oracle) [Less]