[Savannah-hackers] submission of nrdo (NetReach Database Objects) - savannah.nongnu.org

[sballard]

A package was submitted to savannah.nongnu.org
This mail was sent to address@hidden, address@hidden


Stuart Ballard <address@hidden> described the package as follows:
License: gpl
Other License: (I hope this box will still be submitted even though I didn\'t 
select \"other\")

nrdo includes a compile-time build tool and runtime libraries. The build tool 
is under the GPL, but the runtime libraries are under the LGPL. Since the LGPL 
permits redistribution under the GPL as well, I think it\'s accurate to say 
that the project \"as a whole\" is under the GPL.
Package: nrdo (NetReach Database Objects)
System name: nrdo
Type: non-GNU

Description:
nrdo (NetReach Database Objects) is a database programming tool.

Its primary purpose is to make database programming easier and more convenient. 
To this end, it performs two separate but related functions:

1) It allows database table definitions to be specified in a source code file. 
This provides a number of advantages: The files can be maintained in source 
code control, it is easy to upgrade an old installation to the latest version 
of the database, and it is possible to include more semantic information than 
the database itself actually knows. nrdo is invoked at compile time: it reads 
these table definition (.dfn) files, checks the current state of the database, 
and performs whatever CREATE or ALTER statements are necessary to make the 
database match the dfn file.

2) It generates all the repetitive code that is necessary to access the 
database from a programming language. Current supported output languages are 
Java and C#, but the language output is generic and new languages are easy to 
support. Instead of manually creating a database connection, executing an SQL 
statement, looping over the results and reading the returned data values 
manually, nrdo generates a class that represents a data row, for each table. It 
makes use of the extra semantic information in the dfn file to provide 
functions or methods to retrieve rows of the database by whatever criteria you 
specify.

It already exists and you can download the latest distribution at 
http://rainbow.netreach.net/~sballard/nrdo.tar.gz . However, as discussed in 
private email with the Savannah hackers, the current release is not fully 
functional on a Free system; the plan is to address this as soon as possible.


Other Software Required:
nrdo is written in Java; it should work on any of the major Free Java 
implementations but has not been well tested on any of them yet.

nrdo uses the jdbcpool Java connection pooling implementation available from 
http://www.bitmechanic.com/projects/jdbcpool/

To use the C# output bindings you will need a C#/CLR implementation such as 
Mono or Portable.NET.

nrdo also requires a database to be useful; PostgreSQL and MySQL will be 
supported but are not yet.

Other Comments:
nrdo was developed for and is supported by NetReach, Inc 
(http://www.netreach.com/).