Login Register Actian.com  

Actian Community Wiki

Navigation
Learn About
Developing With
Ingres Talk
Information
Toolbox

Ingres Projects

From Ingres Community Wiki

Jump to: navigation, search

The Ingres Community is actively working on a variety of projects. Please take a look at the following areas to see what projects are in the works. To see a list of additional feature enhancements see TODO Feature Requests & Mancing.

To see the planned Roadmap for the next releases of the Ingres Product Suite see Roadmaps & Jasa SEO.

Contents

Featured project

Ingres Geospatial Project

This project is focused on storing geometry and geography related data in Ingres databases. This includes supporting industry standard data types and functions. The project also includes support for desktop GIS and map rendoring software.

Learn more...



Image:announce_discuss.png=Discussion Image:announce_planning.png=Planning Image:announce_design.png=Design Image:announce_develop.png=Coding Image:announce_beta.png=Beta Image:announce_release.png=Stable Image:announce_terminate.png=Terminated


Ingres DBMS Projects

Completed Projects

Projects completed in the 9.3 release are described at http://community.ingres.com/wiki/Ingres_Roadmap/9.3

Projects completed in the 9.3.1 release are described at http://community.ingres.com/wiki/Ingres_Roadmap/9.3.1

Projects In Progress

For projects currently planned for Ingres 10, see http://community.ingres.com/wiki/Ingres_Roadmap/10#10.0_Projects_In_Process.

Projects Under Discussion

See http://community.ingres.com/wiki/Ingres_Roadmap/10.x#10.x_Projects_Under_Consideration

Projects with Community Involvement

Project Leader(s) Availability
Image:announce_beta.png copydb nologging
The ability to have copydb/unloaddb generate a "set nologging" statement in the copy.in script.
Paul Mason Currently available in community edition builds of Ingres 10
Image:announce_beta.png Performance Enhancements
Our business partner, DATAllegro, is leading this project to improve or provide Hash join, sort performance, partitioned aggregates in Ingres 2006.
Karl Schendel Currently available in community edition builds of Ingres 10
Image:announce_beta.png Build system improvements for better parameterization
including site specific (VERS) parameters / options capability. The key item here is to revise the VERS format and arrange for jam to read VERS before reading the platform Jamdefs. This allows VERS to control jam as well as controlling mkxxx shellscripts; this is essential to (e.g.) being able to turn on/off hybrids, etc.
Karl Schendel Currently available in community edition builds of Ingres 10
Image:announce_beta.png Check Digit Functions
Functions to both generate and validate check digits on a string using a specified encoding scheme(Luhn, Verhoeff, ISBN etc)
Martin Bowes Currently available in community edition builds of Ingres 10
Image:announce_develop.png Soundex_dm
An implementation of the Daitch-Mokotoff Soundex algorithm
Martin Bowes Available, starting in community edition build 125 of Ingres 10
Image:announce_beta.png Must Log DB Menu in CBF DBMS Configuration
Extends cbf so you can specify that logging cannot be disabled on a database
Alex Hanshaw Currently available in community edition builds of Ingres 10
Image:announce_beta.png Enable History Recall Feature By Default
Enables the history recall feature in terminal monitor, by default, on UNIX platforms
Jay Hankinson Available, starting in community edition build 123 of Ingres 10
Image:announce_design.png Allow table level inconsistency during crash recovery

rather than always forcing immediate full database inconsistency without completing recovery. Tables get marked logically and/or physically inconsistent. At end, DB is NOT marked inconsistent if all bad tables had save-until dates (see PSEUDOTEMPORARY).

Karl Schendel
Image:announce_design.png PSEUDOTEMPORARY tables

Tables which are not sync'ed and permit failure during crash recovery without any db inconsistency.

Karl Schendel
Image:announce_design.png Partitioned global temporary tables

Useful for managing large GTT's, or for inducing partition-compatible joins or aggs with other large tables.

Karl Schendel
Image:announce_design.png MODIFY to TABLE_REPAIR

Extract that part of "modify to patch_table" that detects the FHDR so that it can be run separately. Intent is for relfhdr fixup after replacing a table file with (e.g.) a backup.

Karl Schendel
Image:announce_design.png Greater than 1k column capability selectable at build time

The main thing here is to change createdb to create catalog bitmaps as BYTE(n) instead of a series of named integer columns, makes it much much easier to vary the column max.

Karl Schendel
Image:announce_design.png page compression

Operates at the DI level, largely invisible to higher layers except for syntax and page-compression catalog bits.

Karl Schendel
Image:announce_design.png CHANGE_TRACKING tables

Any update to a change-tracked table causes its iirelation.relqid2 to be incremented at commit time. (Partition specific.) An external process can track and compare relqid2's to identify specific tables and/or partitions that changed.

Karl Schendel
Image:announce_develop.png Ingres Janitors Project
A group of projects to extend and enhance Ingres.

To find out more, please view our web site, check out our FEQ, visit us in the #ingres IRC channel, and talk with us to let us know the kinds of things you want to see in a best in class Open Source RDBMS.

Roy Hann
Image:announce_design.png Debug Framework
Debugging is often a time intensive process requiring lots of coordination between the end user, DBA's, system administrators and support personnel. A Debugging Framework could ease some of the issues involved by providing a standard collection of debug information that can be easily attached to support tickets. This project was supported by Google Summer of Code.

A framework is being developed to execute a set of chosen executables and libraries in order to gather as much useful information as possible for debugging errors, while remaining as open and extensible as possible.

Anthony Stanisci
Image:announce_design.png GeoSpatial
This project involves updating the Ingres DBMS to support the Open Geospatial Consortium (OGC) Simple Feature Specification (SFS) for SQL. This involves new data types implementing shapes. It also involves functions for performing analysis and manipulating spatial data within the DBMS. This project involves code and participation from the Open Source Geospatial (OSGeo) community.

To find out more, please view our web site, join our mailing list, visit us in the #ingres IRC channel, and talk with us to try out these new capabilities.

Andrew Ross
Image:announce_release.png FOSSLC - The Free and Open Source Learning Centre (FOSSLC) is a non-profit organization driven by industry, academia, and community. It provides conferences, webcasts, online videos, and workshops teaching skills with open source software. FOSSLC is a neutral and friendly place to learn about open source development, the business of open source, and meet people from the open source community. Thank you Ingres for supporting FOSSLC! Read more about FOSSLC FOSSLC Events Team
Image:announce_develop.png RD Tasks
Task List from Development Summit, Dominican Republic 2008
Christine Normile
Image:announce_develop.png Ingres CAFÉ
In conjunction with Carleton University in Ottawa, Canada, Ingres is developing a Consolidated Application Foundation for Eclipse (Ingres CAFÉ). Ingres CAFÉ provides a complete development and deployment environment for Eclipse with a fully integrated enterprise strength Ingres RDBMS. This environment let's developers start coding with a single-click install and developers can easily move their applications into production. This project was supported by Talent First Network and Google Summer of Code. This project is currently dormant.
Samrat Dhillon Andrew Ross
Image:announce_design.png Summer of Code - see a list of Google summer of code projects.
Andrew Ross
Image:announce_design.png Media Wiki - A project for Media Wiki running on Ingres
Image:announce_develop.png Project D - A fully compliant D language for Ingres (just like SQL and QUEL)
Doug Inkster
Image:announce_develop.png OSX Installer
Build a Mac OS/X Native Ingres Installer
Daryl Monge
Image:announce_develop.png letter abbreviations for integers
The Ability to abbreviate integer values with "standard" letters such as "K" or "M"; for example, this would allow the representation of "2048" using "2K" in page size stipulation and other integer constants.
Martin Bowes
Image:announce_develop.png Session wide SQL variables
Provide the ability to declare and use 'session' variables in SQL sessions so that for instance: results could be passed from one statement and used as input to another. This would lever the existing syntax for host variables in the DBMS where presently interactive or script use has no meaning for them.
Ian Kirkham
Image:announce_develop.png Array datatypes in DBprocs
Support simple arrays of primitive types in database procedures.
Ian Kirkham
Image:announce_develop.png DBA assist tool - ingaccess
DBA assist tool that introduces ability to manage Ingres installations using a single command i.e ingaccess restart.
Keith Bolam
Image:announce_release.png DROP IF EXISTS support
Support the IF EXISTS syntax with DROP statements.
Ian Kirkham Currently available in community edition builds of Ingres 10
Image:announce_release.png REPEAT/REPLICATE scalar function
Support the REPEAT scalar function.
Ian Kirkham Currently available in community edition builds of Ingres 10
Image:announce_release.png Multi-row INSERT
Support the insertion of multiple rows in a single SQL INSERT statement
Ian Kirkham Currently available in community edition builds of Ingres 10

Database Administration and Data Management Tools Projects

Project Leader(s)
Image:announce_develop.png DBA Tools API and Companion Projects Ingres Director and Orchestram Management Suite Roger Whitcomb
Image:announce_develop.png Query Tool (QT)
An Ingres data management application written in OpenROAD for developers, data analysts, and DBAs.
John Mahony
Durwin Wright
Image:announce_develop.png Ingres Support Appliance
The Ingres Support Appliance is a collection of Ingres proprietary and OpenSource components utilised to provide Ingres database server monitoring facilities.
Mark Whalley
Image:announce_develop.png Snmp agent
The project goal is to provide an SNMP MIB and SNMP agent for Ingres databases. The screenshot below shows the results of a mib browser query into the current agent.
James Semple
Image:announce_discuss.png DBMS Server Query Tracing - Implement the ability to record ALL the SQL processed by Ingres over a given period (the ‘Workload’). Peter Gale
Image:announce_develop.png Query Playback - Implement the ability to playback ALL the queries processed by Ingres over a given period. Sean Paton
Image:announce_develop.png BackupTool - an enhanced Ingres backup tool offering sha1 checksums, encryption, and improved ease of use. Supported by Talent First Network and Google Summer of Code. Thanh Ha
Image:announce_develop.png Ingres Design Analyser Alexander Thiem

Ingres Migration Tools Projects

Ingres OpenROAD Projects

Java/JDBC Projects

JDBC Research Projects

Project Leader(s) Availability
Image:announce_release.png Ingres JDBC Config Utility
A utility to read Ingres config and generate a corresponding JDBC driver properties file to simplify setup of JDBC driver properties, including tracing. This utility would be automatically invoked during installation as well as standalone as needed.

Teresa King
Usha Rajsekar
Bruce Lunsford
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 9.3.
Image:announce_release.png Multiple DAS Support
Enable easy configuration of multiple Data Access Servers.

Teresa King
Gordy Thorpe
Bruce Lunsford
Ralph Loen
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 9.3.
Image:announce_develop.png Ingres Integration with EclipseLink
Provide Ingres integration with EclipseLink.

Usha Rajsekar
Gavin Stevenson
Image:announce_beta.png Ingres JDBC 4.0 Support
Implement JDBC 4.0 features in the Ingres JDBC driver.

Gordy Thorpe
Usha Rajsekar
Currently Available in http://code.ingres.com/ingres/main/src/common/gcf/gcj. Will be in the next upcoming Ingres release.
Image:announce_release.png Ingres OpenJPA Support
Use Ingres with OpenJPA

Alan Raison
Now available as part of the standard OpenJPA distribution
Image:announce_beta.png Implement Support for the Boolean Data Type in JDBC
Gordy Thorpe
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.
Image:announce_beta.png Batch Statement Execution Performance
Gordy Thorpe
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.

Java Application Projects

Project Leader(s) Availability
Image:announce_beta.png Liferay Portal
Liferay Portal is an Open Source portal system: It can be used as platform to run a rich amount of available portlets. So it allows you for instance to do Web Content Management or to build intranets. Since 'Liferay Portal 5.2.1' it has support for Ingres Database 9.3 included. This project explains the Ingres specific changes inside the Liferay source code and shows how to install and configure Liferay Portal to use an Ingres database. A portlet development tutorial is planned as well.

David Maier
The IngresUtil class is available at http://svn.liferay.com/repos/public/portal. An IzPack based installation package which includes Liferay 5.2.2 and Ingres 9.3 b149 is available but needs an update to newer versions.
Image:announce_develop.png Ingres Database Workbench version 2.0 The Ingres Database Workbench (IDW) is a powerful, low-overhead tool that makes Ingres database development faster and easier and simplifies day-to-day database tasks. IDW allows you to browse your database objects such as tables, views, procedures and rules. You can also issue SQL statements using the SQL scrapbook editor, edit the contents of your tables and edit your procedures and rules. The general purpose SQL editor maintains a command and result set history and includes SQL statement generation tools to help you create correct SQL statements that produce the result sets you need. Based on the Eclipse Rich Client Platform (RCP), IDW easily integrates into your existing architecture.

This project will extend the capabilities of version 1.0.


Jane Thalen

ODBC Projects

ODBC Research Projects

Project Leader(s) Availability
Image:announce_release.png Exploit the DBMS Scrollable Cursor Support added in Ingres 9.2 in the ODBC Driver
Ralph Loen
Currently Available in http://code.actian.com/ingres/main/src/. Will be in Ingres 9.3.
Image:announce_release.png Implement Support for the Boolean Data Type in ODBC
Ralph Loen
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.
Image:announce_develop.png 64 bit ODBC Driver on Windows
Ralph Loen
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0 64 bit Ingres on Windows.
Image:announce_release.png Enhance ODBC Driver Naming to better support multiple Ingres installations on one machine
Ralph Loen
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.
Image:announce_release.png Enhance ODBC Driver to take advantage of the Ingres 10 batch capability
Ralph Loen
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.1.
Image:announce_planning.png Enhance ODBC Configuration Page to take advantage dyanmic vnodes Ralph Loen Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.2.

.NET Projects

.NET Data Provider Research Projects

Project Leader(s) Availability
Image:announce_release.png .NET EnlistTransaction and TransactionScope Support
The IngresConnection's EnlistTransaction( ) method enables the Ingres .NET Data Provider to interface to an explicit transaction programming model using the .NET Transaction class or to an implicit transaction programming model using the .NET TransactionScope class.

Teresa King
Dave Thole
Currently Available in http://code.ingres.com/ingres/main/src/. This will be available in Ingres 9.3.
Image:announce_develop.png .NET EnlistTransaction and TransactionScope 64-bit Support
This project adds support by the Ingres .NET Data Provider for IngresConnection.EnlistTransaction( ) method and .NET TransactionScope class on 64-bit platforms.

Teresa King
Dave Thole
Under construction.
Image:announce_release.png .NET Exploit Multiple DAS Servers
The Multiple Data Access Servers (DAS) Project provided a means to easily start multiple DAS Servers. This project exploits that functionality and provides a mechanism whereby multiple hostnames and ports can be specified in the .NET Connection string.

Dave Thole
Currently Available in http://code.ingres.com/ingres/main/src/. This will be available in Ingres 9.3.
Image:announce_beta.png Implement Support for the Boolean Data Type in .NET Data Provider
Dave Thole
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.
Image:announce_beta.png .NET IngresType.IngresDate
Dave Thole
Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.
Image:announce_develop.png Add Support to .NET Data Provider for Named Parameters in Parameterized Queries
Dave Thole
Currently Available in . Planned for Ingres 10.0.
Image:announce_develop.png Ingres Linq Support
Linq is an O/R (Object-Relational) mapping tool, with some similarities to Hibernate. Linq is type-safe, queries get compiled into MSIL on the fly, and your C# WHERE clauses are translated into SQL and sent to SQL server for execution. In short, it makes design of data access layers safer and faster. In C# 3.0, linq code looks like this:
 var q = from p in db.Products             
         where p.ProductName == "Pen"  
         select p.ProductID;  

This Community Project aims to contribute an Ingres Plugin for the DbLinq project, an alternative implementation of Microsoft Linq.


Thomas Glaser
Image:announce_beta.png Ingres ASP.NET Role and Membership Providers
The Ingres ASP.NET Role and Membership providers enable the rich roles and membership functionality introduced with ASP.NET 2.0 to be used with the Ingres RDBMS as the data source.

Oliver Oyston
Image:announce_develop.png OpenROAD Intellisense Editor and Tool Platform
This project aims to provide an external script editor for OpenROAD with intellisense style code completion. The code is primarily written in C# and utilises the .NET data provider.

Oliver Oyston

PHP Projects

PHP Driver Research Projects

Project Leader(s) Status
Image:announce_release.png PHP data seek function
Whilst it is possible to position the row before a fetch using the ingres_fetch function, the Ingres driver does not have a data seek function (mysql_data_seek). This is a requirement users porting from MySQL and other database which do provide such a function in their PHP extension.
Grant Croker In 2.1.0
Image:announce_release.png PHP escape characters
Implement a function to escape "special" characters such as the single quote, before passing to Ingres.
Grant Croker In 2.1.0
Image:announce_release.png PHP Describe Input Support
Describe input will remove the need for a php programmer to describe the data being passed. This will allow the driver to better handle PHP STRING values that contain either LOB, N(VAR)CHAR, MONEY or DECIMAL types
Grant Croker In 2.1.0
Image:announce_release.png PHP Charset retrieval
Get the value of II_CHARSETxx used in the Ingres installation/instance.
Grant Croker In 2.1.0
Image:announce_release.png PHP Unbuffered Query
Unbuffered query execution allows a developer to execute a query without its rows being buffered. Typically used for INSERT/UPDATE/DELETE statements where there is no row-set to return. It can also be used with SELECT statements, however only a single statement can be open at a time.
Grant Croker In 2.2.0
Image:announce_release.png PHP Doc Review
Review of the PHP docs for Ingres
Grant Croker Published to http://php.net/ingres
Image:announce_release.png PHP Reflection
Support Reflection/introspection.
Grant Croker In 2.2.0
Image:announce_develop.png PHP LOB Locators
Ingres does not support fetching of LOBs with bi-directional scrollable cursors. To allow blobs to be fetched LOB locators need to be used.
Grant Croker On Hold
Image:announce_release.png Boolean support
Add support for the BOOLEAN type to the PHP driver
Grant Croker In 2.2.2
Image:announce_release.png SQL Comments
Improve support for handling ? markers inside SQL comments (/* */)
Grant Croker In SVN
Image:announce_discuss.png PHP insert id
There is no PHP function in the Ingres PHP driver to get the sequence value used in the last SQL statement. In MySQL the value of the last inserted value for an auto increment column is made available without using SQL.
Grant Croker
Image:announce_discuss.png PHP select db
Implement a way of switching databases.
Grant Croker
Image:announce_discuss.png PHP Ping
Test to see if the connection is still alive, if not re-connect.
Grant Croker
Image:announce_discuss.png Virtual Node Management
This project is to add the ability to query / create / delete Ingres vnode entries through PHP. This functionality will be implemented through Ingres OpenAPI.
Grant Croker
Image:announce_discuss.png PHP Savepoints
Support the SQL SAVEPOINT statement allowing for partial transactional rollbacks
Grant Croker
Image:announce_discuss.png PHP Critical Failures
Better handle server failures/crashes as per http://community.ingres.com/forum/php/11013-ingres_free_result-working-correctly.html
Grant Croker

PHP related projects

Project Leader(s)
Image:announce_planning.png Ingres ADOdb Support
Related to the planned community project of the 'Typo3' & 'Ingres' certification, it is required to support 'AdOdb'. 'ADOdb' is a Database Abstraction Library for PHP. More information about 'ADOdb' can be found at http://adodb.sourceforge.net .

David Maier
Image:announce_beta.png Ingres MDB2 Support
'MDB2' is a another Database Abstraction Library for PHP. More information about 'MDB2' can be found at http://pear.php.net/MDB2 . An Ingres driver for MDB2 (beta version) is available here http://www.ascolteo.fr/ingres/mdb2-en . Your feedback is welcome!

Olivier Desmares
Image:announce_develop.png EasyIngres PHP
EasyIngres is a package which automatically installs a PHP development environment on Windows including :
  • Ingres 9.2
  • Apache 2.2.8
  • PHP 5.2.9

Plus other tools like the Ingres Developer Workbench V0.1 and the Scite editor version 1.77


Bruno Bompar
Image:announce_develop.png Drupal on Ingres
Project to port Drupal to run on Ingres.

Alex Trofast
Image:announce_develop.png MediaWiki on Ingres
Port the latest MediaWiki code to work with Ingres and PECL Ingres 2.x

Grant Croker
Image:announce_develop.png PDO Ingres
PHP Data Objects (PDO) interface for Ingres

Stephane Planquart

Ingres Python Projects

Python Driver Research Projects

Project Leader(s) Status
Image:announce_beta.png Automatic changelog generation
Grant Croker In SVN 3963
Image:announce_beta.png Fix bug 161 - Python driver behavior of fetch() in non-SELECT query Grant Croker In SVN 3978
Image:announce_develop.png Fix bug 260 - Python dbi driver timestamps select problem Grant Croker
Image:announce_develop.png Fix bug 407 - Python README file implies ODBC is required but does not explicitly state it is needed Grant Croker In SVN 3992
Image:announce_discuss.png Fix bug 441 - Python DBI driver error when passing in bind parameters in select list Syntax error on 'using' Grant Croker
Image:announce_discuss.png Fix bug 505 - Python DBI driver does not save LONG NVARCHARs longer than 16000 characters Grant Croker
Image:announce_discuss.png Fix bug 525 - Python DBI driver possible PyNone None Leak Grant Croker
Image:announce_discuss.png Fix bug 579 - Ingres Python driver executable is out of order on Windows Grant Croker
Image:announce_discuss.png Python 2.5 Support Grant Croker Chris Clark
Image:announce_beta.png Python 2.7 testing
Grant Croker
Image:announce_discuss.png Python 3.1 testing
Grant Croker
Image:announce_discuss.png PEP-3137 Grant Croker
Project Leader(s)
Image:announce_discuss.png Django 1.0 Driver Chris Clark

Ingres Driver TODO

  • Open bug reports
  • General
    • describe input support - Would give "proper" LONG VARCHAR and LONG NVARCHAR support when applications do NOT indicate the bind param is a LOB.
  • ORMs

Ruby Projects

Ruby Driver Research Projects

Project Leader(s) Status
Image:announce_release.png Ruby on Rails 2.1 Support

Revise the Ruby on Rails adapter for ActiveRecord 2.1

Grant Croker In Version 1.3.0
Image:announce_release.png Ruby Migrations Support Grant Croker In Version 1.3.0
Image:announce_release.png Ruby Increased Data Type Support

Add support for SQL/ANSI Date data types

Bruce Lunsford In Version 1.3.0
Image:announce_release.png Ruby Multiple Concurrent Connections Support

Allow the Ruby driver to make more than one active connection at any one time. Currently the driver can only have a single connection open.

Grant Croker In Version 1.4.0
Image:announce_release.png Ruby Date Format Support

Provide a mechanism to adjust the default date format for INGRESDATE to VARCHAR conversions

Grant Croker In Version 1.4.0
Image:announce_release.png Generate Documentation using RDoc

Ruby has a documentation tool, like javadoc, which can be used to document modules, including C code. This project would review the current state of the documentation for the Ruby driver and update it to something more usable and current.

Grant Croker In Version 1.4.0
Image:announce_release.png Bug 555 - Ruby driver SEGVs when selecting a LOB

Fix bug #555

Grant Croker In SVN
Image:announce_discuss.png Ruby Describe Input Support

Ingres 9.1 onwards can pre-determine the target column type for a parametrized query allowing for improved conversion between Ruby and Ingres data types.

Grant Croker
Image:announce_discuss.png Gem Package

Create a RubyGem package for simplified installation. A part of this project would look at publishing the generated gem on http://rubyforge.org.

Grant Croker
Image:announce_discuss.png Rails 3.0 Support

Update the Ruby on Rails adapter to support Rails 3.0 and Arel

Grant Croker
Image:announce_discuss.png Row Producing Procedures

Add the ability to execute row producing procedures

Grant Croker
Image:announce_discuss.png Frequent Flyer GTK Demo

Update the Ruby GTK demo

Grant Croker

Ruby Driver TODO

  • General
  • Clean up
    • Organize the code
      • Order functions
      • Separate Ingres.c into separate functional areas, ala python dbi interface
  • Documentation
    • Enter TODO tags to identify known issues
  • (Missing) Features
    • Data type support
      • Unicode datatypes
    • Concurrent result-sets
      • At the present results are returned as multi-dimensional array and the OpenAPI statement is closed. It might be useful to have ruby functions that can query the data values.
    • It should be possible to alter the output from Ingres.table() to only user tables, only system tables or all tables (current default)
    • Create a RubyGem (installable package)
  • Testing
    • Improve test coverages from the active_record unit-tests
      • All other AR unit tests
    • Enhance unit-tests for the ruby driver
      • At least cover data types, all methods and exceptions

Ingres Perl Projects

Ingres OpenAPI Projects

Net/Authentication Projects

General Connectivity Research Projects

Project Leader(s) Availability
Image:announce_release.png Ingres PAM Integration
Integrate PAM Support into Ingres. The basis of this change was contributed by Ronald Jeninga of independIT Integrative Technologies GmbH.

Teresa King
Usha Rajsekar
Bruce Lunsford
Currently Available in http://code.ingres.com/ingres/main/src/. Available in Ingres 9.3
Image:announce_release.png Deprecate WinTCP Protocol
Deprecate the WinTCP Protocol on Windows. The objective of this project is to get customers migrated to the newer driver, which has better performance, stability, and more features (such as IPv6 support)

Teresa King
Bruce Lunsford
Currently Available in http://code.ingres.com/ingres/main/src/. Available in Ingres 9.3
Image:announce_develop.png UTF-8 Transliteration Gordy Thorpe Currently Available in
Image:announce_develop.png GCC Extended Transliteration
Extend GCC negotiation to transliterate connection parameters
Gordy Thorpe Currently Available in
Image:announce_planning.png Ingres SSL Integration
Add support for SSL as a protocol

Teresa King
Gordon Thorpe
Currently Available in
Image:announce_planning.png Ingres LDAP Integration
Add support for LDAP as a Global Authentication Mechanism

Teresa King
Ralph Loen
Currently Available in
Image:announce_beta.png Implement Support for the Boolean Data Type in ODBC Gordy Thorpe Currently Available in http://code.ingres.com/ingres/main/src/. Will be in Ingres 10.0.
Image:announce_beta.png Enhanced Multi-byte Charset Support in the Ingres GCC Gordy Thorpe Currently Available in http://code.ingres.com/ingres/main/src/. Will be released in Ingres 10.
Image:announce_beta.png Extend iimonitor support for GCF Servers to include Process ID (PID) Usha Rajsekar Currently Available in http://code.ingres.com/ingres/main/src/. Will be released in Ingres 10.

Ingres Internationalization

Ingres Eclipse Projects

Ingres Eclipse Projects

Project Leader(s) Availability
Image:announce_beta.png UTF8 COPYDB

COPYDB and UNLOADDB can be used to generate portable (ascii) data files from an existing database which can then be reloaded into a new database. A mechanism is required to enable these utilities to generate UTF8 data files to provide safe transfer of international characters that are not part of the ascii character set.

Alex Hanshaw Available in next community release.
Project Leader(s) Availability
Image:announce_beta.png Ingres Database Workbench version 2.0

The Ingres Database Workbench (IDW) is a powerful, low-overhead tool that makes Ingres database development faster and easier and simplifies day-to-day database tasks. IDW allows you to browse your database objects such as tables, views, procedures and rules. You can also issue SQL statements using the SQL scrapbook editor, edit the contents of your tables and edit your procedures and rules. The general purpose SQL editor maintains a command and result set history and includes SQL statement generation tools to help you create correct SQL statements that produce the result sets you need. Based on the Eclipse Rich Client Platform (RCP), IDW easily integrates into your existing architecture. This project will extend the capabilities of version 1.0.

Jane Thalen Available on SourceForge.
Image:announce_release.png Ingres DTP

The Ingres Eclipse DTP plug-in provides the ability to develop applications that interface with your Ingres databases from within the Eclipse IDE. You can browse tables and triggers (also known as rules in Ingres), procedures, sequences, synonyms and views. You can edit procedure, table and trigger contents directly with dedicated editors and DTP includes an Ad Hoc SQL editor for ultimate flexibility. You can develop and test Java applications that use the Ingres JDBC driver. DTP allows you to set up database connections locally or in the cloud!

Jane Thalen The Ingres DTP plug-ins come installed with Eclipse Galileo 3.5, and with Eclipse Helios 3.6. Therefore you don't have to do anything extra in order to integrate with your Ingres DBMS on these Eclipse releases.
Image:announce_beta.png Ingres Migration Wizard

The Ingres Migration Tool Set is a collection of tools and libraries, designed to simplify the task of migrating database schemas and procedures from competitor database products to Ingres Classic and Ingres VectorWise.

Jane Thalen
Ray Fan
See here: http://community.ingres.com/wiki/IngresMigrationToolSet
Image:announce_beta.png Ingres Development Stack for JBOSS

The Ingres Development Stack for JBoss creates a rich environment where Java developers can build data-centric applications. Combining the benefits of open source and open standards, the Ingres Development Stack for JBoss allows developers to quickly build portable, reliable, mission critical applications that can scale from the desktop to the enterprise data center.

Jane Thalen Download here: http://www.ingres.com/downloads/ingres-bundles.php#ingjboss
Personal tools
© 2011 Actian Corporation. All Rights Reserved