Open Source Groovy Database Software

P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with Java classes. GETL taken into account when developing ideas and following requirements: 1. The simpler the class hierarchy, the easier solution; 2. The data structures tend to change over time, or not be known in advance, working with them must be maintained; 3. All routine work ETL should be automated wherever possible; 4. Compiling the code on the fly bail speed and reserve for the optimization; 5. Sophisticated class hierarchy guarantee easy connection of other open source solutions.

Kangaroo is an AI-powered SQL client designed to enhance database interaction by integrating large language model capabilities into query workflows. It allows users to write, analyze, and optimize SQL queries using natural language assistance, making database operations more accessible and efficient. The tool is intended for developers, analysts, and data professionals who want to simplify complex query generation and debugging processes. It integrates with databases to provide context-aware suggestions, helping users understand schema structures and relationships. Kangaroo also supports conversational querying, enabling users to describe what they want to retrieve and receive corresponding SQL queries. The system aims to bridge the gap between traditional database tools and modern AI-driven workflows. Overall, Kangaroo transforms SQL clients into intelligent assistants that improve productivity and reduce the learning curve for database interactions.

Jdbsee CLI supports running SQL queries from command line in batch or interactive mode. Database connection settings and related credentials can be persisted for later reuse. The JDBC drivers can be automatically downloaded from maven central repo or loaded from local jars. For more info see https://github.com/davidecavestro/jdbsee/blob/master/docs/index.adoc.

Cinnamon is an Enterprise CMS with all functions of a Component CMS, and is ideal for versioned management of assets of all types, like modular technical documentation (DITA and other standards), media assets, documents, contracts, software releases etc. Cinnamon consists of the server, a desktop client and all libraries the desktop client is built on. Cinnamon is an ideal platform for technical documentation systems, custom web or desktop applications in the fields of document management, publishing, translation and many others. There are also commercial products available that use Cinnamon as a platform. Please contact us for more info.

NeoDatis ODB is a new generation Object Oriented Database. ODB is a real native and transparent persistence layer for Java, .Net, Groovy, Scala and Google Android. ODB is very simple and very fast and comes with a powerful query language.

GSN is a middleware (extendible software infrastructure) for rapid deployment and integration of heterogeneous wireless sensor networks. It is tested with Mica2, Mica2Dot, TinyNodes, Wisenode ,Wired & Wireless cameras, several RFID readers,...

The Moqui Ecosystem is a series of open source components for enterprise applications all built on a common framework (Moqui Framework) written in Java and Groovy. The components include tools that plug in to the framework, business artifacts, and applications. Some of the popular tool plug ins include ElasticSearch, Apache FOP, Apache Camel, OrientDB, and Hazelcast. The business artifacts later includes a universal data model (mantle-udm), service library (mantle-usl), reusable screens (SimpleScreens), and integration components for EDI, Authorize.NET, and Shippo. There are 2 main applications in the ecosystem: POP Commerce ERP and eCommerce for retail and wholesale, and HiveMind Project Management and ERP for service organizations. NOTE: the code repositories for Moqui Ecosystem are hosted on GitHub at: https://github.com/moqui

UI To the Hadoop HBase Project

Cross-platform data acquisition and visualization software with an embedded HTTP-server, binary protocol parsing library, protocol emulation server, remote secure administration server, embedded Groovy scripting facilities and HMI (SCADA) visualization module.

Reverse engineer a legacy database to a Grails domain model. A java GUI will be be available from which database tables can be selected and mapped to grails domain objects.

CodaServer is a database that makes building business applications easy. It uses a SQL-like language that lets you describe your workflow and business processes, and uses this information to enforce your business rules and guarantee data integrity.

XTarget is an Groovy Library for automated editing of small XML Databases with Groovy scripts. It focuses on simultaneous editing of data, including structures like lists and maps, and linking between various XML files.

Marid is a cross-platform data acquisition and visualization software intended to build complex and hierarchical data acquisition systems. The base concepts of its architecture include: * Graphical deploy configuration builders * Powerful Groovy scripting language * Embedded database ( H2 , HSQLDB) to store data * Cross-platform design (write once, run anywhere) * Embedded GUI-configurable binary/ascii device protocol parser/generator * Deploy manager to deploy firmwares to remote controllers/servers via secure channel * Embedded web-sever * Dynamically linked plugins available from Nexus Repository * Remote monitoring tools * Modular Marid IDE to manage them all

Onco-STS is a web-based Laboratory Information Management System for sample and analysis tracking in oncogenomic experiments. The systematic sequencing and analysis of tumour samples, as well other oncogenomic experiments, necessitates the tracking of relevant sample information throughout the investigative process. These meta-data of the sequencing and analysis procedures include information about the samples and projects as well as the sequencing centers, platforms, data locations, results locations, alignments, analysis specifications and further information relevant to the experiments. The sample tracking system for oncogenomic studies (Onco-STS) is designed to store these data and make them easily accessible to the researchers who work with the samples. The system is a web application, which includes a database and a front-end web page that allows the remote access, submission and updating of the sample data in the database.

CLADlims is a wed based laboratory information and data management system for animals and their measurement records. It is designed to track the weight and tumour growth of the animals, visualize the data, compare data, inform the user for any alarming measurements as well as keep any other data related to animals, cages and experiments. Users can submit the data directly from the measuring facilities to the database using a mobile device (tablet or phone) or any computer with a modern web browser. Multiple tumours per animal can be tracked. With CLADlims you can improve efficiency by getting rid of the text files or spreadsheets and save time and money.

This project is a java web application developer toolbox. It is among other, a simple and powerful framework which does not require dealing with XML files. It also provides a lot of other features, such as a DB abstraction layer, a nice javadoc doclet, a

A very simple data tier, writen in groovy. It can create and alter tables, and the OLTPs (INSERT,UPDATE,DELETE).

A simple, reliable object store for rapid prototyping and applications that have minimal ongoing storage requirements.

In your job, do you have queries that you are running regularly and sometimes you need to share those to non-technical people? Now you can do with your personal SQL Servant. Just configure and test it, if all is good distribute it. Those people doesn't need to have any fancy licensed SQL client.