Software Map

The goal of dzo is to treat application database objects the same way the application's source code is treated, with respect to development, revision control, and deployment. Dzo uses a text file that contains native create statements for all database objects and compares them against the actual database-schema. As a result, dzo creates the SQL statements needed to update the database schema (or you can let dzo execute the SQL statements directly). If your application lives in a Tomcat or Java EE application server, dzo has a servlet that controls the deployment process, inspects and executes the necessary database changes, and finally deploys the application. Dzo currently works with HSQLDB, MySQL, Oracle, PostgreSQL, and SQL Server (more to come).

Java Ultra-Lite Persistence is an RDBMS-independent object-relational library. It features inheritance, many classes per table, many tables per class, optimistic concurrency, and simple mappings, etc.

SmallSQL is a pure Java DBMS, a relational
database for Java desktop applications. It has a
JDBC 3.0 interface and offers many ANSI SQL 92 and
ANSI SQL 99 features. It is very small and fast
because it does not have a network interface.

SwingSet is an Java toolkit that contains data-aware replacements for many of the standard Java Swing components. It currently includes replacements for JTextField, JTextArea, JComboBox, JCheckBox, JSlider, and JLabel. There is also an image component, a graphical record navigator, and a data grid component. All of the primary components are available as JavaBeans.

xplain2sql converts files from Xplain to SQL. It supports a very large subset of Xplain, and it can convert from Xplain to Microsoft SQL Server, DB/2,
Inprise InterBase, PostgreSQL, Oracle, MySQL 5, SQLite 3 or ANSI-92 SQL. It can also generate an XML description of the generated SQL. This XML description can be used to create low-level middle-tier code. Example stylesheets for Eiffel/ECLI and Delphi/ADO are included. The C source code release should compile on any platform with an ANSI C compiler. There are binary releases for FreeBSD, Linux, Solaris x86, and Windows 2000.

Scriptella is an Extract-Transform-Load (ETL) and
script execution tool. Its primary focus is
simplicity. It doesn't require the user to learn
another complex XML-based language to use it, but
allows the use of SQL or another scripting
language suitable for the data source to perform
required transformations.

pimentech-dbutils provides a set of tools for designing a database in
XML, computing the SQL database generation code and the diagram (in
dot), and doing other useful tasks.

Geolizer is a patch for Webalizer that uses the
GeoIP library to generate faster and more reliable
geographic statistics than the default DNS suffix
method. It is recommended that DNS reversal be
disabled on your HTTP server for improved
performance and more accurate statistics. It also
supports country flag pictures, can be compiled
under MinGW/MSYS, and features a human-readable
transfer size display.

SPTK (Simply Powerful Toolkit) is a cross-platform
toolkit that provides a set of C++ classes for
fast and easy application development. It provides
GUI components that use FLTK, and features
database support with seamless connection to GUI
components. There are drivers for use of SQLite
and PostgreSQL directly, as well as support for
other database engines through UnixODBC. SPTK
includes many classes for working with strings,
dynamic arrays, and maps, and is faster and has a
smaller footprint than STL. It also supports
reading, writing, and creating Excel 7 files,
high-level GUI components with dataset support,
support for automatic layouts, and support for
Aspell.

Tin Can Jukebox is a very fast, full-featured, Web
based jukebox that can securely stream large MP3
collections over the Internet to multiple users.
Features include many browsing modes, dynamic
downsampling, playists, language packs, and user
access control.

IAM backup is package made of two classes. One
performs the backup of the selected MySQL
database, and the second restores the database.
Both classes support GZIP-compressed files for
improved performance. When performing the backup,
the user is prompted to download the backup file,
straight from the browser. Alternately, the backup
can be stored on the local server at a predefined
location. Restoring the database (or copying it to
another server) is just as easy.

LiteSQL is a C++ library that integrates C++
objects tightly to a relational database and thus
provides an object persistence layer. LiteSQL
supports SQLite3, PostgreSQL, and MySQL as
backends. LiteSQL creates tables, indexes, and
sequences to database and upgrades schema when
needed. In addition to object persistence, LiteSQL
provides object relations which can be used to
model any kind of C++ data structures. Objects can
be selected, filtered, and ordered using a
template- and class-based API with type checking
at compile time.