Free Tools

The following page contains a number of utilities and tools that can be freely used with JustOneDB and equally with standard PostgreSQL.

DescriptionDocumentationVersionDownload Link
JustOne Loader
4.3
JustOne X12 Package
1.0
JustOne HL7 Package
1.0
JustOne EDI Package
1.0
JustOne VCF Package
1.0
PostgreSQL Constraint Fix
1.0

JustOne Loader

JustOne Loader provides the ability to bulk load huge volumes of data from files into your PostgreSQL database with unprecedented flexibility and speed.

The loader includes features for:

  • file globbing
  • variable and fixed field length handling
  • record and field delimiter recognition
  • quotation mark handling
  • discarding records and fields
  • control character handling
  • field formatting and trimming
  • record filtering
  • record validation
  • record padding
  • parsing composite and hierarchical record structures
  • meta data field generation
  • row post processing
  • commit points
  • parallel file loading
  • distributed database loading

JustOne X12 Package

The X12 Package is a pre-built set of database tables, views and functions to support the parsing, storage, retrieval and analysis of X12 exchanges.
The X12 package offers a solution for acquiring X12 segments for rapid data discovery, investigation and analysis without requiring any prior knowledge of the X12 message structure.
Installation of the X12 Package only takes a few minutes, after which, you may immediately start loading, storing, retrieving and analyzing X12 exchange data contained in files.

JustOne HL7 Package

The HL7 Package is a pre-built set of database tables, views and functions to support the parsing, storage, retrieval and analysis of HL7 v2.x messages.
The HL7 Package is extendable and may be used to store both HL7 message segments as defined by the Health Level 7 International organization and also non-standard message segments.
The HL7 package offers a solution for acquiring messages for rapid data discovery without requiring any prior knowledge of the HL7 message structure. The package provides an agile foundation upon which messages may be staged, transformed, and analyzed.
Installation of the HL7 Package only takes a few minutes, after which, you may immediately start loading, storing, retrieving and analyzing HL7 messages contained in files.

JustOne EDI Package

The EDI Package is a pre-built set of database tables, views and functions to support the parsing, storage, retrieval and analysis of EDIFACT exchange messages.
The EDI package offers a solution for acquiring EDIFACT segments for rapid data discovery, investigation and analysis without requiring any prior knowledge of the EDIFACT message structure.
Installation of the EDI Package only takes a few minutes, after which, you may immediately start loading, storing, retrieving and analyzing EDIFACT exchange data contained in files.

JustOne VCF Package

The VCF package is a pre-built set of database tables, views and functions to support the parsing, storage, retrieval and analysis of VCF records.
The VCF package offers a solution for acquiring VCF records for rapid data discovery, investigation and analysis without requiring any prior knowledge of the VCF record structure.
Installation of the VCF package only takes a few minutes, after which, you may immediately start loading, storing, retrieving and analyzing VCF data contained in files.

PostgreSQL Duplicate Keys (PG bug #11141)

This package repairs any PRIMARY KEY and UNIQUE constraints in PostgreSQL that contain duplicate keys (PG bug #11141).
Constraints are repaired by deleting rows with a duplicated constraint key and which are not accessible via the constraint index.