Posts Tagged ‘ingres’

Ingres Engineering Summit - From the user side ….

Wednesday, April 30th, 2008

I saw this post on one of the Ingres mailing list and thought others might be interested in hearing what Roy Hann (UK IUA President)  had to say about the recent Ingres Engineering Summit .—-Original Message—–From: Roy Hann

Sent: Wednesday, 30 April 2008 2:51 AM

Subject: [Info-Ingres] Ingres Engineering Summit

Nobody has yet posted any report of the Ingres Engineering Summit anywhere, so I thought I’d report a few bits and pieces that captured my attention.

First of all, it was an open event, as befits an open source company.

Anyone was welcome to attend and a great many partners (and others) did. I don’t know the total headcount but considering it was a moderately expensive week and a long time out of the office, it was very well attended. I’d guess there were well over 100 people there.

The amount of openness demonstrated was impressive. It wasn’t just about exposing the code, it was also about exposing the thinking, the working practices, the people, and–yes–the tensions. With the exception of a one-hour slot that was employees-only, everything was out in the open.

Anyone who didn’t attend has missed out on a lot. Plan to attend next year.

Just running through the agenda from top to bottom, and focussing just on Ingres rather than OpenROAD, here are some highlights:

Andrew Ross did a one hour presentation that covered a lot of ground on the general theme of “community development”, and more precisely, the barriers to community development and what has to change to make it easier/possible.

As we all know, there was a lot standing in our way, and there is a long way to go still. However the need for a properly open process was as taken as given. As well as reporting a lot of progress with things like http://code.ingres.com (Subversion code repository), http://lxr.ingres.com (code cross-referencer), and http://bugs.ingres.com (bug tracking), Andrew also outlined a number of as-yet unresolved problems. I think I’ll leave it to Andrew to elaborate on those, but the big one (IMO) is the communication channels. Mike Sale, Mike Leo and I have been discussing this too. One thing we agree on is that the current phpBB-based Ingres forums are an embarrassment and have to go (real soon if I have my way). Mike Leo’s suggestion of using vBulletin turns out to be top of the list at Ingres too, so that could happen fairly quickly. There are several benefits to vBulletin but the big one is that it will allow us to have a single community delivered via web pages, e-mail, or NNTP, so that we can accommodate everyone’s way of working. IRC will of course remain separate.Another big item from Andrew’s presentation is that there are actually two fairly successful virtual development systems about ready for delivery. We should be able to get our hands on these within a week or so.I won’t dwell on the rest of the presentations in such detail. You can infer the significance of these topics appearing on the agenda as well as I can.We had a number of demos of things like Ingres Café and some OpenGIS software. There was a presentation from Gordon Thorpe on the formidable challenge of re-architecting GCA. Hugh Darwen spoke about Project D (an implementation of Tutorial D on top of Ingres) and earned himself the second prize for Best Presentation. We had two presentations on column stores, one of which went on to win the first prize Best Presentation (Marcin Zukowski on Monet/x100). Karl spoke fluently about something or other for an hour and many of us marvelled. Mike Touloumtzis led a discussion about how to implement column encryption; nothing was decided but a lot of ground was explored. Steve Ball and Alison Stillway led another discussion on how to implement MVCC and which model of MVCC to adopt; nothing was decided except that a design document will be drafted for public comment. (To my mind this may be the most immediately and widely useful enhancement that popped up on the new-features radar.) Emma McGrattan picked up where Andrew Ross left off. The big thing in her presentation was the carefully expressed and several-times repeated instruction that Ingres Corp requires all its personnel to devote 10% of their time to community projects (i.e. 1/2 day per week). That is a lot of effort folk! After Emma, Kai-Uwe Sattler talked about some research into making Ingres more autonomous and self-tuning (including the ability to recommend secondary indices and statistics). There were two presentations on two different replicators from partner companies. Roger Whitcomb told us about the work he’s been doing on Ingres Management Tools, which was really good stuff. (I was present at the meeting where VDBA was first unveiled back circa 1995 and it was greeted with horror and revulsion then, and nothing has changed. Roger’s work is definitely going in the right direction this time.) After this I stepped out of server-land and saw Daryl Monge discussing Ruby on Rails. For some reason every head in the room turned to look at me when he reminded us that RoR requires every table to have a synthetic integer key. Evidently everyone understands this is wicked and wrong and that they should feel guilty about it, but equally evidently people are just going to go on doing it anyway. That was enough for me, so I retreated back to server-land again after that.

So there you are. I saw fewer than half the presentations, so perhaps someone else will comment on the others.

Finally , I am hoping to get at least a couple of these repeated at the IUA conference on June 17 in London. Please let me know if there is anything above that particularly takes your fancy and I will see what I can do.

Roy

Inside the Community - Ingres style….

Tuesday, April 22nd, 2008

Today is day one at the Ingres Engineering Summit being held in Punta Cana (Dominican Republic) with a  cross section of folks from across the Ingres engineering, support/ service, Product Management teams as well as a number of contributors from the Ingres open source community.  Amazing the number of people here and the tenure they have around Ingres - I think the winner from the community has 24 years using Ingres ( he started using Ingres on VAX - wow!!) . We also have a number of newbies to Ingres from various universities and it’s great to have them here as well.

The agenda is loaded with pretty cool topics that range from demos from DMSolutions (GIS) and Ingres CAFE,  application development using Ingres CAFE and OpenROAD,  Google Summer of code work, Datallegro contributions,  open sessions with Ingres Janitor’s Project just to name a few. Lots of good debate on code repositories and various new ideas to get engaged with. I was talking with one of partners here at the Summit - Karl from Datallegro and he is speaking later and has several hundred submissions in queue.. Great job Karl. Great seeing the blog from Datallegro on line as well.

 Later this week we have a codefest planned, lots of after hours activities and yes you can’t go to Punta Cana with out some team building event - rumor is it is building a sand castle and best design wins not sure what …. That ought to be loads of fun with a bunch of really technical dbms guys.  Any hardware design guys in the house????

/deb woods

Establishing trust with your open source community

Wednesday, April 16th, 2008

Yesterday was kind of a bummer for open source communities everywhere. We saw an open source company (MySQL) compromising the trust they have with their community. MySQL announced that they will only offer certain features to paying customers. Take a look at Jeremy’s blog for more commentary. They have forked their community release and one must now wonder what goes next. Building creditability is always a difficult task for one to achieve. It takes hard work every day, building innovative, robust products, adding value in everything you do, responding to customer queries, and doing what you say you will do. The latter being most important - open source is about open code. It is about sharing your work so others can contribute, use, provide feedback, etc.

At Ingres, we are working very hard to grow and build our community. We are always looking for guidance and new ideas on how to build a robust community. We have a number of activities underway with various universities, partners, customers, users and are looking for more each day. I worked at Red Hat for years where knowledge was always plentiful and we never compromised our creditability with our community. This is a trait we are building at Ingres as well. The industry has responded over the years with a strong vote of support for the open source model and it is surprising and sad to see MySQL take such a turn.

/deb woods

Ingres puts on a Red Hat..

Monday, April 14th, 2008

There have been quite a few changes over at the Red Hat Exchange and in keeping up with some old friends we decided it was time to join the Exchange. Red Hat Exchange is a great place for open source companies to share information and to ‘mingle’ with other open source solutions. Customers can visit the site and get some good information about the various players in the open source space and see the solutions that are available. The Exchange first started out as a web only support offering with no Enterprise support - it just didn’t fit our model. We have worked with Red Hat on a number of key projects like building high available solutions using  the GFS clustering product as well as robust application development platforms with  JBoss, it is only natural that we sign up to the Exchange. Hope to see you guys there..

/deb woods

Ingres Open Source Style

Monday, March 31st, 2008

In case you missed Andrew Ross’ presentation on how to get started contributing to Ingres, I wanted to share the link to the webinar. You can find it in the Ingres DBMS section entitled Ingres Open Source Community. The VIP archive page has a wealth of information on how to get started with Ingres, upcoming release information and future direction. Sign up to get invites to future sessions.

Andrew does a great job walking through some of the tools that Ingres is now using to help users i.e.

  • view source (LXR)

http://lxr.ingres.com

  • How to create a  work area

svn co http://code.ingres.com/ingres/main~/ingres-main

  • To raise a bug to the Ingres community

http://bugs.ingres.com

  • Looking for more on Ingres

http://groups.google.com/group/comp.databases.ingres/topics

deb woods

Getting Ingres up and running on Mac OS X Leopard

Friday, March 28th, 2008

So I'm trying to work a bit on the Mac OS X port of Ingres that's had a recent update and some important changes. There's a few things that don't just come "out of the box":

  1. You'll have to install as root

    To do this the easy way, just open a term and run the command "su -". This will prompt you for your current user password to make sure that you really mean it.
     
  2. You need to set DYLD_LIBRARY_PATH

    Mine is set to /lib:/usr/lib:/usr/local/lib:$II_SYSTEM/ingres/lib

    You can safely replace any directives to set LD_LIBRARY_PATH with setting DYLD_LIBRARY_PATH
     
  3. You need to up your shared memory kernel settings

    Create the file /etc/sysctl.conf and add the following lines if you have 4G memory:

    kern.sysv.shmall=4096000

    kern.sysv.shmseg=8

    kern.sysv.shmmni=256

    kern.sysv.shmmin=1

    kern.sysv.shmmax=1024000000
     
  4. You need to be running Leopard

    We know this may be a bit of a hassle, and it could be remedied with some work, but the current people working on the port are all running Leopard and we're trying to focus time on getting the port working well on Leopard first. If you're interested in helping out, please let me know!

Here's a few things I did that just make life easier based on my experience:

  • Create an "ingres" user via the good old System Preferences app's Accounts section
  • Install in /opt
  • Permanently change my term's option for termcap interaction with the function keys to "Strict VT-100 keypad behavior" on the Advanced tab of my preferences

To make your life easy, but maybe slightly bloated, run the ingres_express_install.sh script and let it rip by. Once finished, login as the ingres user, set your env (including DYLD_LIBRARY_PATH), and create your first database:

  • createdb -umsale mymacdb

Replace the msale with the username you use to do development on the local box and then that user will be able to perform DBA actions for that database. If you want to do your development/dba work as ingres, just leave out the -u option.

You can now connect to your database via the JDBC tool of your choice to interact via ANSI-friendly SQL (I use SQuirrel due to its Toad-like UI) using the JDBC driver at $II_SYSTEM/ingres/lib/iijdbc.jar.

Let us know if you have any issues with the install and we’ll do the best we can to help out. We know there is plenty of work that still needs to be done to get this port reliable and ready as a solid development platform on the Mac.

If you are a student with experience developing C or Obj-C on the Mac, we would love to get you involved in our Google Summer of Code project to get Ingres healthy on Leopard.

Ingres and the Google Summer of Code

Thursday, March 27th, 2008

Ingres get’s more and more into the GPL swing of things with our participation this year in the Google Summer of Code. You can check out our project proposals here. Students should check out this URL for more information.

If you have a suggestion for another proposal that you would like to contribute to, please let us know soon and we will work to get it included if at all viable.

One of the new things (for us) we have up and running now for instant help and feedback is an IRC #ingres channel on freenode.net. If you’re interested in jumping on, but are not sure what IRC is and how to use it, check out wikipedia or for something a little more practically directed to getting you started, check out this FAQ.

Alfresco and Ingres: Enterprise-Class Open Source for Content Management

Monday, March 24th, 2008

Ingres has joined forces with Alfresco to provide true open source alternative to Enterprise Content Management. Alfresco is the leading open source provider for document, records, knowledge, and web content management. In addition to traditional content management services, Alfresco enables collaboration support for the internet way of business.

The benefits of Alfresco and Ingres as a combined solution:

  • Availability – out of the box online backup and recovery
  • Security – a centralized repository requires proper data protection
  • Scalability – users can start small and grow to enterprise wide deployments
  • Mission critical experience - applied to content management solutions
  • Open source – total enterprise grade open source solution

Ingres and Alfresco Bundle

Ingres and Alfresco want developers and end users to get up and running quickly and easily. That’s why we built an integrated bundle of Alfresco with Ingres so users can install both technologies in one easy install.

Download now!

For More Information:

Ingres CAFE - Writing web applications w/ Eclipse

Tuesday, March 18th, 2008

Over the past year we have had quite a bit of interest in the Eclipse dtp bundle and this has spurred interest in building an integrated developer’s stack. Ingres CAFE is such a project that was spearheaded by Samrat Dhillon, a graduate student at Carleton University in Ottawa.


Ingres CAFE bundles the Eclipse IDE, Ingres Database, Apache Tomcat, Hibernate Libraries, and JSF libraries into a single installable package complete with documentation and integrated maintenance. There is also a demo included to help developers get started with the tool.

Check out Ingres CAFE and let us know what you think and future developer tools you would like to see working with Ingres.

Great job to the students at Carleton University in Ottawa, Canada.

deb woods


Close
E-mail It