Planet Ingres

February 09, 2010

Andrew Ross - Step by step: configuring asterisk to enable call recording

This is the third in our series on Asterisk. This article will cover enabling asterisk to record calls. You may want this to interview people over the phone, podcast, or some other purpose. Read on.

read more

by aross at February 09, 2010 02:13 AM

February 08, 2010

Grant Croker - Ingres Administration Tools Webcast

Later this week Roger Whitcomb will be hosting two webcasts exposing Ingres’ strategy for developing an administration tool for Ingres. The webcasts are scheduled for 7am and 4pm Pacific Standard Time on Thursday 11th Feburary. For information on joining the webcasts see the post in the Community Forums.

Related Posts

by Grant Croker at February 08, 2010 05:49 PM

Andrew Ross - Flash and Twitter are open, aren't they?

In the past, we've been given feedback that as an organization supporting open source and open standards we should not use certain technologies. Adobe flash, and Adobe Air have been two notable examples of this. For some, this issue is black or white... if you want to reach people on the web, flash is a big part of doing so. Conversely, those advocating open standards note the risks and damage caused by using technologies encumbered by patents and royalties and thus push strongly for free alternatives. It is thus interesting to see what Adobe has to say on the matter. Read on.

read more

by aross at February 08, 2010 01:59 PM

February 05, 2010

Ingres Tech Blog - Developing with PHP/ Zend

There is alot of great work going on in the Zend community and we recently have made some good connections there. With more and more PHP development going on it is no surprise to see the success happening in the Zend community. Zend recently published they have over 27,000 customers taking advantage of their technology. Great job guys!

The Zend Developer Zone is a great source of information and we recently listed EasyIngres as a project to get involved there as well. If you’re working with Ingres and PHP, here’s a good page to help get you started.

by Deb Woods at February 05, 2010 05:26 PM

Teresa King - What’s Happening with the Ingres JDBC Driver?

The Ingres JDBC team has busy working on new features in the Ingres JDBC Driver for Ingres 10 release. Enhancments include:
  • Adding Support for the following JDBC 4.0 API features:
    • Automatic loading of java.sql.Driver
    • National Character Set Conversion Support
    • Enhances Support for BLOB and CLOB
    • Wrapper pattern
    • New Scalar Functions
    • SQLException enhancements
    • JDBC API changes to existing JDBC interfaces
    • SQL/XML and XML support
    • Connection Management
For more information on the Ingres support of the JDBC 4.0 API features, see JDBC 4.0 API Features Implemented.

A Community Preview of the Ingres JDBC Driver (iijdbc.jar) can be found at Community Preview Download Area.
  • Boolean Data Type Support.
For more information regarding Ingres’s support of the Boolean Data Type, see Boolean Data Type Support.

A Community Preview of the Ingres JDBC Driver (iijdbc.jar) will be available in the future that exposes this support. An Ingres 10 DBMS and Data Access Server (DAS) are a must to exploit this feature.
  • Batch Execution Support.
Batch processing (batch execution actually) is currently supported in the Ingres JDBC Driver but under the covers statements are not actually batched but instead are done as Singleton queries which undermine the performance improvement expected when batching queries. The feature was implemented in this manner due to the lack of support in the Ingres DBMS for batch processing. With Ingres 10, the DBMS will be adding capabilities to handle batch processing and the JDBC Driver will be modified to take advantage of the new Batch feature. This enhancement should significantly improve batch processing in the Ingres JDBC Driver.

For more information regarding Ingres’s support of Batch Execution in Ingres 10 and the JDBC Driver, see Batch Statement Execution Performance.

A Community Preview of the Ingres JDBC Driver (iijdbc.jar) will be available in the future that exposes this support. An Ingres 10 DBMS and Data Access Server (DAS) are a must to exploit this feature.
Future blog entries will discuss new updates to the JDBC Driver and Community Previews of the new functionality.

by teresa at February 05, 2010 04:36 PM

Eva Wong - UCOSP status report #2

For the past 2 weeks, I have been working with the first 2 patches, issimple and isempty, with the first one committed and second one pending for approval. These patches are compiled based on the latest from the GEOS library repository after the people working on it fixed the building issue, and applied the patch sent by my mentor Alex Trofast.

Next moving on, I'm going to work closely with Sara on the SEP testing and hopefully and compile a set of steps for newbies to QA for Ingres.

Wiki pages that I have been reading about.
http://community.ingres.com/wiki/Test_Developer
http://community.ingres.com/wiki/SEPGUIDE

by A nerdy girl (noreply@blogger.com) at February 05, 2010 09:46 AM

Eva Wong - UCOSP code sprint day #2

Today we continue to explore the unanswered questions left over from yesterday. These are the things that I have explored

OGC stands for opengeospatial consortium, and GEOS is an implementation of the OGC specification. It is formed by a set of companies who have invested their time to have set out a standard for geospatial information systems and databases. GEOS implements part of the SFS standard and Ingres uses it for geospatial manipulation and calculation. The patch Alex sent sends me extends GEOS to support more of the standard so that Ingres can use the GEOS.

Functions instances to implement:
  • IsSimple,
  • IsEmpty,
  • Overlaps,
  • X(on points only),
  • Y(on points only),
  • NumPoints (on linestring only)

Files to change:
  • adgoptab.roc
  • fi_defn.txt
  • aduint.h
  • adfops.h
  • adupoint.c
  • adffiids.h


Following the standard that is quoted from OpenGIS Implementation Specification for Geographic information - Simple feature access:
Organization: Open Geospatial Consortium Inc.
Date: 2005-11-22
Reference number of this document: OGC 05-134
Version: 1.1.0
Category: OpenGIS® Implementation Specification
Editor: Keith Ryden

SQL functions on type Geometry
IsEmpty(g Geometry) : Integer
The return type is Integer, with a return value of 1 for TRUE, 0 for FALSE, and –1 for UNKNOWN corresponding to a function invocation on NULL arguments.
TRUE if this geometric object corresponds to the empty set

IsSimple(g Geometry): Integer
The return type is Integer, with a return value of 1 for TRUE, 0 for FALSE, and –1 for UNKNOWN corresponding to a function invocation on NULL arguments.
TRUE if this geometric object is simple, as defined in the Geometry Model

SQL functions that test spatial relationships
Overlaps(g1 Geometry, g2 Geometry) : Integer
The return type is Integer, with a return value of 1 for TRUE, 0 for FALSE, and –1 for UNKNOWN corresponding to a function invocation on NULL arguments.
TRUE if the intersection of g1 and g2 results in a value of the same dimension as g1 and g2 that is different from both g1 and g2 Integer

SQL functions on type Point
X(p Point) : Double Precision
return the x-coordinate of Point p as a double precision number

Y(p Point) : Double Precision
return the y-coordinate of Point p as a double precision number

SQL functions on type LineString
NumPoints(l LineString) : Integer
return the number of Points in the LineString

by A nerdy girl (noreply@blogger.com) at February 05, 2010 08:59 AM

February 04, 2010

Teresa King - How to Locate Information About the Ingres JDBC Driver?

Ever wonder how to find more information on the Ingres JDBC Driver? There is quite a bit of information on the Ingres Community Wiki relating to the Ingres JDBC Driver and using Java with Ingres.

Most of this information is centrally located at Ingres Java Development Center. We try to ensure all content on the wiki related to Java and Ingres can be accessed from this main page. I’m sure we don’t manage to link up everything but we do try.

A summary of the type of information that can be found here follows.

The minimum JRE needed for a particular JDBC Driver version.

Accessible from this page are:

• Articles relating to using Java with Ingres and integration of Ingres with Java Applications and Application Servers such as JBoss, Apache Tomcat, Weblogic, and Glassfish. To directly check out all articles see Ingres Java Articles.
• Coding samples relating to using new Ingres features from Java. To directly check out all coding samples see Ingres Java Coding Samples.
• Presentations around Java and Ingres. To directly check out all coding samples see Ingres Java related presentations.

More recently the section was updated to clearly document what features where introduced in what JDBC Driver version as well as a comprehensive list of what bugs were addressed in what JDBC patch version.

We are always looking to add new content to the wiki and encourage you to submit ideas for new content or add new content yourself.

Outside of the Community wiki, the Connectivity Guide in the Ingres product documentation is the base reference resource for the JDBC driver.

Questions can always be posted to the Driver Forum.

Feedback is always welcome.

by teresa at February 04, 2010 05:48 PM

Chinese Puzzle - Button clicks do nothing in Ingres Database Workbench, Eclipse and its derivatives

On some distributions of Linux when running Eclipse and applications derived from Eclipse the buttons on dialogs whilst accepting clicks do not seem to do anything.

After some minutes of frustration and even more minutes searching for an answer on Google I found this https://bugs.eclipse.org/bugs/show_bug.cgi?id=291257 Any way the temporary solution is to set the environment variable GDK_NATIVE_WINDOWS to 1 before invoking the Eclipse launcher.  For example, use a script that implements the following:

#!/bin/sh
export GDK_NATIVE_WINDOWS=1
/usr/local/Eclipse/eclipse/eclipse

Another workaround would be to try using the keyboard’s space bar to make a button selection, but this gets a bit tedious.

Alternatively wait patiently for the advent of 3.6.

Related posts

by notnull at February 04, 2010 11:01 AM

February 02, 2010

Andrew Ross - open source database ten times faster than closed source rivals

This story is very interesting given it's significance from both an open and closed source perspective given the high performance and disruptive potential involved.

read more

by aross at February 02, 2010 02:43 PM

January 27, 2010

Ingres Tech Blog - Innovations in BI

Ingres Vectorwise continues to break speed records and early indications look strong for this project. The team is working hard as they launched the Technology Preview Program this week. The Technology Preview Program is an excellent opportunity to get first hand experience with Ingres Vectorwise and see what this technology can do for your BI solutions. Signing up  for the Technology Preview Program is easy and it’s a great opportunity to help provide direction for the project.

ingres-vectorwise

The team is very open to suggestions and it’s a great time to get engaged to help drive this project forward. We would love to hear what you have to say about the project and your ideas for future product improvements.

/deb

by Deb Woods at January 27, 2010 02:26 PM

January 26, 2010

Emma McGrattan - It’s a database Jim, but not as you know it!

ingres-vectorwise

Earlier today we announced the Ingres VectorWise technology preview program which gives our partners and customers an opportunity to kick the tires on an early version of the product, while the engineering team holds it breath and hopes that the doors don’t fall off.  To be fair to the Ingres VectorWise team my emerging technologies guys have been playing with Ingres VectorWise for a couple of months now and are completely blown away by its performance and impressed with the stability of the product.

Many of us in Ingres Engineering have spent more years than we’d care to admit working with database technologies and have seen database trends, such as object-relational databases, come and go, so there was some healthy skepticism about the VectorWise project’s chance for success.  Having lived through the Jasmine project at CA we learned that bolting two pieces of database technologies together  isn’t easy and that the results aren’t always pretty.

I’ll admit that when I saw the initial project plans for Ingres VectorWise, produced by the team Amsterdam, I figured that there must have been some passive smoking going on ;-)   I was somewhat skeptical of the chances of a successful coupling between something as revolutionary and cutting edge as VectorWise and something as “mature” as Ingres – think Hugh Heffner and Holly Madison, but I’m happy to have been proven wrong!  Talking of Hugh Heffner maturity, you may be surprised to learn that Roy Hann, who we hope will be participating in the technology preview program, has recently hit a half century!

There’s lots of detailed information available on the web about the inner workings of Ingres VectorWise.  If you’re an existing Ingres customer or partner who is interested in joining the Ingres VectorWise Technology Preview Program then I’d encourage you to fill out the application that’s available here.

Ingres VectorWise is revolutionary – it’s a database, but not as you know it!


 

by Emma McGrattan at January 26, 2010 04:55 PM