Open Source Java Database Software

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

HSQLDB is a relational database engine written in Java, with a JDBC driver, conforming to ANSI SQL:2016. A small, fast, multithreaded engine and server with memory and disk tables, LOBs, transaction isolation, multiversion concurrency and ACID.

GeoTools is an open source (LGPL) Java code library which provides standards compliant methods for the manipulation of geospatial data. GeoTools is an Open Source Geospatial Foundation project. The GeoTools library data structures are based on Open Geospatial Consortium (OGC) specifications.

Develop professional database applications, highly performant with little source code. JVx is a full-stack application framework to create multi tier applications with Single Sourcing for different technologies (Swing, vaadin, react, ...). Nightly builds are available: https://dev.sibvisions.com/jvx.nightly/ Maven snapshots are available: https://oss.sonatype.org/content/repositories/snapshots Eclipse plugin is available: http://marketplace.eclipse.org/search/site/eplug

Database connection pool with support for lots of languages and databases.

Jailer is a tool for database subsetting, schema and data browsing. It creates small slices from your database and lets you navigate through your database following the relationships. Ideal for creating small samples of test data or for local problem analysis with relevant production data. Creates small slices from your productive database and imports the data into your development and test environment (consistent and referentially intact). Improves database performance by removing and archiving obsolete data without violating integrity. The Data Browser lets you navigate through your database following the relationships (foreign key-based or user-defined) between tables. Generates SQL (topologically sorted), XML (hierarchically structured) and DbUnit datasets. A demo database is included with which you can get a first impression without any configuration effort.

Robust schema evolution across all your environments, with ease, pleasure, and plain SQL. Version control for your database, so you can migrate it with ease and confidence. Flyway lets you regain control of your migrations with ease. Flyway migrates your database, so you don't have to worry about it. Releases have never been this easy. Migrate from any version (including an empty database) to the latest version of the schema. Plain SQL scripts (including placeholder replacement). No proprietary XML formats, no lock-in. Java-based migrations for advanced data transformations and handling with LOBs. All you need is Java 7+ and your Jdbc driver and you're good to go! Full support for Amazon RDS, Microsoft SQL Azure, Google Cloud SQL, Heroku, and more. Filesystem and classpath scanning to automatically discover SQL and Java migrations. Ship migrations together with the application and run them automatically on startup using the API.

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.

Make AI-driven decisions using your data, in real-time. At any scale, with unbeatable performance. Vespa is a full-featured text search engine and supports both regular text search and fast approximate vector search (ANN). This makes it easy to create high-performing search applications at any scale, whether you want to use traditional techniques or a modern vector-based approach. You can even combine both approaches efficiently in the same query, something no other engine can do. Recommendation, personalization and targeting involves evaluating recommender models over content items to select the best ones. Vespa lets you build applications which does this online, typically combining fast vector search and filtering with evaluation of machine-learned models over the items. This makes it possible to make recommendations specifically for each user or situation, using completely up to date information.

Ebean provides multiple levels of query abstraction ORM Queries, mixed with SQL, DTO Queries, SqlQuery and JDBC. Work at the highest level of abstraction and drop down levels as needed. Built in DB migration generation and running. Support for "rebase" migrations as well as repeatable, init and 'normal' migrations. Ebean produces SQL that you would hand craft yourself. 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. IDE auto-complete when writing queries, compile time checking and it's FUN. Optimize queries to only fetch what we need (partial objects). Automatically avoid N+1 via a smart load context.

NoSQL Textual Database System

Apache Phoenix is a SQL skin over HBase delivered as a client-embedded JDBC driver targeting low latency queries over HBase data. Apache Phoenix enables OLTP and operational analytics in Hadoop for low latency applications by combining the best of both worlds. The power of standard SQL and JDBC APIs with full ACID transaction capabilities and the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. Apache Phoenix is fully integrated with other Hadoop products such as Spark, Hive, Pig, Flume, and Map Reduce. Become the trusted data platform for OLTP and operational analytics for Hadoop through well-defined, industry-standard APIs. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds.

SQLite JDBC is a library for accessing and creating SQLite database files in Java. Our SQLiteJDBC library requires no configuration since native libraries for major OSs, including Windows, Mac OS X, Linux etc., are assembled into a single JAR (Java Archive) file. The usage is quite simple; download our sqlite-jdbc library, then append the library (JAR file) to your classpath. SQLite JDBC is a library for accessing SQLite databases through the JDBC API. SQLite supports on-memory database management, which does not create any database files. To use a memory database in your Java code, get the database connection. sqlite-jdbc extracts a native library for your OS to the directory specified by java.io.tmpdir JVM property. To use another directory, set org.sqlite.tmpdir JVM property to your favorite path.

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

FLEISS Frameworks is a set of programming, instrumental, application, and system frameworks to develop a free software system within an organization either non-commercial or commercial, but primarily scoping on business organizations.

Spring Data Neo4j, part of the larger Spring Data family, provides easy configuration and access to Neo4j Graph Databases from Spring applications. It offers three different levels of abstraction to access the store. The Neo4j client, the Neo4j Template, and the Neo4j Repositories. Spring Data Neo4j offers advanced features to map annotated entity classes to the Neo4j Graph Database. The template programming model is equivalent to other Spring templates and builds the basis for interaction with the graph and is also used for the Spring Data repository support. Spring Data Neo4j is a core part of the Spring Data project which aims to provide convenient data access for NoSQL databases. Spring Data builds on Spring Framework, check the spring.io web-site for a wealth of reference documentation. If you are just starting out with Spring, try one of the guides.

Un sistema formato da server, client, linguaggio di script, controllo versione e distribuzione automatica. Tutto questo per creare applicazioni di tipo enterprise che lavorino principalmente con database.

Logstash is a server-side data processing pipeline that dynamically ingests data from numerous sources, transforms it, and ships it to your favorite “stash” regardless of format or complexity. It supports and ingests data of all shapes, sizes and sources, dynamically transforms and prepares this data, and transports it to the output of your choice. Logstash is extensible, with over 200 plugins available to let you create and configure your pipeline how you choose.

Hibernate is an Object/Relational Mapper tool. It's very popular among Java applications and implements the Java Persistence API. Hibernate ORM enables developers to more easily write applications whose data outlives the application process. As an Object/Relational Mapping (ORM) framework, Hibernate is concerned with data persistence as it applies to relational databases (via JDBC).

Java Data Access Objects. A DAO system. Include data access objects and code generators. Cross table relations are easy too. This project uses POJO. Code written by a DBA whose approach isn't to persist java object but to normalize the database and work from that side.

Last Release: 2024/03/26 ver0.4.0_jdk22 ** Checked DB(MiluDBViewer0.4.0_jdk22)** Cassandra 4.1.4 MySQL 8.0.36 Oracle Database 23c Free PostgreSQL 14.11 SQLite 3.45.1 Microsoft SQLServer 2017 MongoDB 3.6.5 ** Checked DB(MiluDBViewer0.3.9_jdk21 )** Cassandra 3.9.0 MySQL 5.7.20/8.0.11 Oracle 12c Release2/11g Release2 PostgreSQL 10.4/10.1 SQLite 3.23.1 Microsoft SQLServer 2017 MongoDB 3.6.5 ** Availblable OS ** Windows, Linux, Mac ** Available Language ** English/French/Spanish/Chinese/Japanese ** Required ** JDK22+OpenJFX22 => MiluDBViewer0.4.0_jdk22 JDK21+OpenJFX21 => MiluDBViewer0.3.9_jdk21 JDK17+OpenJFX17 => MiluDBViewer0.3.9_jdk17 JDK11+OpenJFX11 => MiluDBViewer0.3.4

MyBatis is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. MyBatis eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. MyBatis can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records. Every MyBatis application centers around an instance of SqlSessionFactory. A SqlSessionFactory instance can be acquired by using the SqlSessionFactoryBuilder. SqlSessionFactoryBuilder can build a SqlSessionFactory instance from an XML configuration file, or from a custom prepared instance of the Configuration class. Building a SqlSessionFactory instance from an XML file is very simple. It is recommended that you use a classpath resource for this configuration, but you could use any InputStream instance, including one created from a literal file path or a file:// URL.

JabRef is an open-source, cross-platform citation and reference management tool. Stay on top of your literature: JabRef helps you to collect and organize sources, find the paper you need and discover the latest research. JabRef is available free of charge and is actively developed. It supports you in every step of your research work.

Liquibase Community is an open source project that helps millions of developers rapidly manage database schema changes. Liquibase helps millions of teams track, version, and deploy database schema changes. Control database schema changes for specific versions. Eliminate errors and delays when releasing databases. Automatically order scripts for deployment. Easily rollback changes. Collaborate with tools you already use. Liquibase Core works with the following databases: Apache Derby, CockroachDB, Firebird, H2, HSQL, Informix, InterBase, MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, SQLite, Sybase Anywhere, Sybase Enterprise. The databases that require extensions are: Azure Cosmos DB, Cassandra, Cache, DB2i, Hibernate, Impala/Hive, MaxDB, MongoDB, Redshift, SAP HANA, SQLFire, Snowflake, Teradata, Vertica, VoltDB. See Liquibase Database Tutorials. Liquibase can be integrated with Maven, Ant, Gradle, Spring Boot, and other CI/CD tools.

Photoindex is a web application to collect and manage photos from a large number of photographers.