Planet Ingres

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

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

• Maven driver repository updated
• New Ingres Ruby driver and Rails adapter posted
• Using Ingres with Grails via a Hibernate DAO

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

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.

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

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

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

• Rapid
• Hello, Eclipse calling …
• Learning to share
• UK IUA Conference 2009
• Ingres Code Sprint 09

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

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.

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

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!