Last week I released version 1.3.0 of the Ruby and RoR adapter for Ingres. This release includes the following changes:
Ingres Ruby Driver:
Restrict tables() to only return non-system tables
Add support for Ingres datatypes float4, float8, money, decimal, bigint, and ANSI SQL date/time/timestamp
Ruby on Rails adapter:
Add support for Ruby on Rails 2.1 Migrations - for more information [...]
The Ingres JDBC driver, iijdbc.jar, has the capability to log the queries that pass through it. This is extremely useful for obtaining query timings as well as working out what goes between an application and the DBMS server. For example, below is a snippet of a trace obtained from Jira:
2008-07-08 10:04:12.319: Ingres-ResultSet[40296].next()
2008-07-08 10:04:12.319: Curs[40296].load()
2008-07-08 10:04:12.319: [...]
It looks like someone else has taken over DBD-Ingres and put out a new release. According to the CHANGES the following updates were made:
- add missing timestamp types
- add workaround for do statements with placeholders
-> works for Ingres2006 R3
You can download the updated driver from http://search.cpan.org/CPAN/authors/id/S/SR/SREAGLE/DBD-Ingres-0.5201.tar.gz.
Due to unforeseen circumstances the Getting Started with Ingres and PHP session I was supposed to present next Wednesday, 9th April 2008, has been brought forward one day to April 8th. The session will provide the basics for getting up and running with PHP and Ingres, covering the different platforms supported by both Ingres and [...]
Yesterday, I/we released version 1.2.2 of the Ruby driver and RoR adaptor for Ingres. The release is a small update that includes the following changes:
Fix quote() in ingres_adapater.rb to use the class of variable rather than the equivalent Ingres column type.
Fix segvio in Ingres Ruby driver when fetching char/varchar with data longer than 4074 bytes.
The [...]
Sometime ago I wrote a quick post on getting the Ruby binding for ODBC working with Ingres. Whilst there is still some work to be done there I thought I might write about the Ingres Ruby binding and Ruby on Rails (RoR) adapter.
A consultant for an Ingres client based in the US was asked to [...]
Its been a long time coming but I have finally released to cvs.php.net a major revision of the PECL Ingres code. So major that I have had to break backwards compatibility to implement the ability to have multiple active result-sets. Since I promised Andy Grimm I would write a piece on the new driver for [...]
This Wednesday I gave a session on the languages that can interface with Ingres. The content of my session was a high level overview with some simple examples thrown in for the non Embedded languages. Going into sufficient detail for all the languages we support in 35 minutes was not possible. There was a lot [...]
The following python code can be used to change the table structure into btree. Should you wish to change your tables to hash or isam then change the SQL in the second to last line:
print “modify %s to btree unique on %s with unique_scope=statement;\p\g” %(row[0], k.group(1))
Read on [...]
As a follow up to a prior post you can now register to attend the (free as in beer) UK IUA spring conference. I will be presenting a session on the different languages you can interface with Ingres, entitled - No Speaky the COBOL? - Ingres can speak your language. If you do not like [...]
Community Forums