JSimpleDB GUI Application

JSimpleDB Graphical User Interface (GUI) executable application.

License

License

Categories

Categories

GUI User Interface
GroupId

GroupId

org.jsimpledb
ArtifactId

ArtifactId

jsimpledb-guiapp
Last Version

Last Version

3.6.1
Release Date

Release Date

Type

Type

jar
Description

Description

JSimpleDB GUI Application
JSimpleDB Graphical User Interface (GUI) executable application.

Download jsimpledb-guiapp

How to add to project

<!-- https://jarcasting.com/artifacts/org.jsimpledb/jsimpledb-guiapp/ -->
<dependency>
    <groupId>org.jsimpledb</groupId>
    <artifactId>jsimpledb-guiapp</artifactId>
    <version>3.6.1</version>
</dependency>
// https://jarcasting.com/artifacts/org.jsimpledb/jsimpledb-guiapp/
implementation 'org.jsimpledb:jsimpledb-guiapp:3.6.1'
// https://jarcasting.com/artifacts/org.jsimpledb/jsimpledb-guiapp/
implementation ("org.jsimpledb:jsimpledb-guiapp:3.6.1")
'org.jsimpledb:jsimpledb-guiapp:jar:3.6.1'
<dependency org="org.jsimpledb" name="jsimpledb-guiapp" rev="3.6.1">
  <artifact name="jsimpledb-guiapp" type="jar" />
</dependency>
@Grapes(
@Grab(group='org.jsimpledb', module='jsimpledb-guiapp', version='3.6.1')
)
libraryDependencies += "org.jsimpledb" % "jsimpledb-guiapp" % "3.6.1"
[org.jsimpledb/jsimpledb-guiapp "3.6.1"]

Dependencies

compile (19)

Group / Artifact Type Version
org.jsimpledb : jsimpledb-app jar 3.6.1
org.jsimpledb : jsimpledb-main jar 3.6.1
org.jsimpledb : jsimpledb-coreapi jar 3.6.1
org.jsimpledb : jsimpledb-parse jar 3.6.1
org.jsimpledb : jsimpledb-vaadin jar 3.6.1
com.google.guava : guava jar 21.0
org.dellroad : dellroad-stuff-spring jar 2.2.1
org.dellroad : dellroad-stuff-vaadin7 jar 2.2.1
org.springframework : spring-aspects jar 4.3.7.RELEASE
com.vaadin : vaadin-shared jar 7.7.3
com.vaadin : vaadin-server jar 7.7.3
org.eclipse.jetty : jetty-annotations jar 9.2.19.v20160908
org.eclipse.jetty : jetty-webapp jar 9.2.19.v20160908
org.eclipse.jetty : jetty-server jar 9.2.19.v20160908
javax.validation : validation-api jar 2.0.0.Final
org.aspectj : aspectjrt jar 1.8.9
org.slf4j : slf4j-api jar 1.7.25
org.slf4j : slf4j-log4j12 Optional jar 1.7.25
log4j : log4j Optional jar 1.2.17

provided (1)

Group / Artifact Type Version
com.google.code.findbugs : jsr305 jar 3.0.1

test (1)

Group / Artifact Type Version
org.testng : testng jar 6.9.10

Project Modules

There are no modules declared in this project.

Permazen is a better persistence layer for Java

Persistence is central to most applications. But there are many challenges involved in persistence programming that lie outside of the domain of simply storing the data.

Mainstream Java solutions such as JDBC, JPA and JDO were designed simply to give Java programmers access to existing database functionality. They address the "storage" problem, but leave many other important issues that are inherent to persistence programming poorly addressed, or not addressed at all.

Permazen is a completely different way of looking at persistence programming. Instead of starting from the storage technology side, it starts from the programming language side, asking the simple question, "What are the issues that are inherent to persistence programming, regardless of programming language or database storage technology, and how can they be addressed at the language level in the simplest, most correct, and most language-natural way?"

With Permazen, not only are many issues inherent to persistence programming solved more easily and naturally than before, but also many issues that traditional solutions don't address at all are solved, and some entirely new, useful functionality is added.

Permazen is:

  • A Java persistence layer for SQL, key-value, or in-memory databases
  • A rigorously defined, modular key/value API with adapters for multiple database technologies
  • A way to make your application portable across different database technologies
  • An object serialization framework
  • An automated schema management framework
  • A library for inverting Java references
  • A library for automatic field change notification
  • An embeddable Java command line interface (CLI)

Permazen was inspired by years of frustration with existing persistence solutions, in particular JPA. Compared to using JPA, building an application with Permazen is a refreshingly straightforward experience.

Ask these questions of your persistence solution:

  • Configuration complexity Do we have to explicitly configure details of how data is mapped? Are we forced to (ab)use the programming language to address what are really database configuration issues?
  • Query language concordance Does the code that performs queries look like regular Java code, or do we have to learn a new “query language”?
  • Query performance transparency Is the performance of a query visible and obvious from looking at the code that performs it?
  • Data type congruence Are database types equivalent to Java types across the entire domain of values? Are we guaranteed to always read back the same value we write?
  • First class offline data Can it be precisely defined which data is copied out of a transaction? Does offline data have all the rights and privileges of “online” (i.e., transactional) data? Does this include the ability to query indexes, and a framework for handling schema differences? Can offline data be easily serialized/deserialized?
  • Schema verification Is the schema assumed by the code cross-checked against the schema actually present in the database? Are we always guaranteed a consistent interpretation of stored data?
  • Incremental schema evolution Can multiple schemas exist at the same time in the database, to support rolling upgrades? Can data be migrated incrementally, i.e., without stopping the world? Are we free from "whole database" migration operations that would limit scalability?
  • Structural schema changes Are structural schema updates performed entirely automatically for us?
  • Semantic schema changes Is there a convenient way to specify semantic schema updates, at the language level (not the database level)?
  • Schema evolution type safety Is type safety and data type congruence guaranteed across arbitrary schema migrations?
  • Transactional validation Does validation, including reference validation, occur only at the end of the transaction (as it should), or randomly and inconveniently in the middle?
  • Cross-object validation Is it possible to define validation constraints that span multiple objects/records? Can we register for data-level notifications about changes in non-local objects?
  • Custom types and indexes Is it possible to define custom data types, have them be indexed? Is it easy to define arbitrary custom indexes?
  • Language-level data maintainability Can database maintenance tasks and queries be performed via a command line interface (CLI) using Java types, values, and expressions (including Java 8 streams and lambdas)? Are there convenient tools for manual and scripted use?
  • Data store independence Are we restricted to using only a specific type of database technology, or can virtually any database technology be used by implementing a simple API, making it easy to change later if needed?

Permazen addresses all of these issues, this without sacrificing flexibility or scalability.

Permazen does this by treating the database as just a sorted key/value store, and implementing the following in Java:

  • Encoding/decoding of field values
  • Referential integrity; forward/reverse delete cascades
  • Indexes (simple and composite)
  • Query views
  • Schema management
  • Change notification
  • Validation queues
  • Command line interface
  • GUI database editor

Permazen also adds several new features that traditional databases don't provide.

What's the Downside?

Permazen gains advantages by fundamentally changing the equation with respect to persistence programming. However, in some situations, not all of these changes result in improvements when compared to traditional SQL/JPA. Here are some things to consider.

You have to learn something new. Persistence programming with Permazen requires a different way of thinking. For example, a "DAO" layer is often no longer necessary, and you have to think harder about how to query your data efficiently (instead of crossing your fingers and hoping the database figures it out for you).

For an equivalent query, Permazen will perform more frequent, but smaller, database accesses. As a result, in situations where the code and the data are separated by a high latency network, Permazen will tend to be slower.

More flexible type hiearchies are possible, but it's also easy to make a mess. JPA has support for class inheritance and partial support for generics. Permazen supports interface inheritance (including Java's equivalent of "mix-ins") and fully supports generic types. The restrictions imposed by JPA tend to force model classes to stay simpler. With Permazen, implementing an interface (directly or indirectly) can mean that a model class inherits a bunch of new persistent fields.

Permazen Slides

For a quick overview, check out these slides from a JSimpleDB talk at a local Java user's group (Permazen was previously named JSimpleDB).

Permazen Paper

For a deeper understanding of the motivation and design decisions behind Permazen, read Permazen: Language-Driven Persistence for Java.

Abstract:

Most software applications require durable persistence of data. From a programmer’s point of view, persistence has its own set of inherent issues, e.g., how to manage schema changes, yet such issues are rarely addressed in the programming language itself. Instead, how we program for persistence has traditionally been driven by the storage technology side, resulting in incomplete and/or technology-specific support for managing those issues.

In Java, the mainstream solution for basic persistence is the Java Persistence API (JPA). While popular, it also measures poorly on how well it addresses many of these inherent issues. We identify several examples, and generalize them into criteria for evaluating how well any solution serves the programmer’s persistence needs, in any language. We introduce Permazen, a persistence layer for ordered key/value stores that, by integrating the data encoding, query, and indexing functions, provides a more complete, type-safe, and language-driven framework for managing persistence in Java, and addresses all of the issues we identify.

Installing Permazen

Permazen is available from Maven Central:

    <dependency>
        <groupId>io.permazen</groupId>
        <artifactId>permazen-main</artifactId>
    </dependency>

or from the Ivy RoundUp ivy repository:

<dependency org="io.permazen" name="permazen"/>

You should also add the key/value store module(s) for whatever key/value store(s) you want to use, e.g.:

    <dependency>
        <groupId>io.permazen</groupId>
        <artifactId>permazen-kv-sqlite</artifactId>
    </dependency>

There is a demo distribution ZIP file that lets you play with the Permazen command line and GUI, using a simple database of the solar system.

Documentation

Documentation and links:

Versions

Version
3.6.1
3.6.0
3.5.3
3.5.2
3.5.1
3.5.0
3.4.0
3.3.0
3.2.0
3.1.0
3.0.1
3.0.0
2.4.7
2.4.6
2.4.5
2.4.4
2.4.3
2.4.2
2.4.1
2.4.0
2.3.2
2.3.1
2.3.0
2.2.1
2.2.0
2.1.7
2.1.6
2.1.5
2.1.4
2.1.3
2.1.2
2.1.1
2.1.0
2.0.1
2.0.0