Skip site navigation (1) Skip section navigation (2)

Re: temporal algebra and data type

From: Peter Padua Krauss <ppkrauss(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: temporal algebra and data type
Date: 2012-02-22 12:50:17
Message-ID: CAHEREtsEW=2LdhpsW9aoY66Ztvc9Ep92Mzo9bsk1d=wXCuKpjA@mail.gmail.com (view raw)
Hello,

I am new here,
it is a question about "how to colaborate" and/or "where to find", in the
scope of temporal database...

-----

I see the Temporal Postgres,
"a project for making tools and documentation that people can use to better
manage, query, and maintain time data in Postgres",
http://temporal.projects.postgresql.org/

BUT
* the project is oversized for my needs ...
* there are NO complementar "pure SQL" library for manage "sheduling
events".

Searching I find something more close to my necessities, the S.Bailey's
TIMESPAN model, at
 http://scottrbailey.wordpress.com/2009/05/19/timespan-postgresql/

BUT it is not ready for practical use (it is more for didactic use)... THEN
I create
   http://code.google.com/p/temporal-type
that is what I need.

*QUESTIONS: *

1) There are another  project, similar or better than my!? There are "pure
SQL standard libraries" for this?

2) Why something similar (manage events without pg-extension) is not into
the temporal.projects.postgresql.org ?

3) There are another "good place" for colaborate with a simple and "pure
SQL" library project?
   Can I colaborate to the wiki-page?  see
    http://wiki.postgresql.org/wiki/Temporal_Extensions
From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Peter Padua Krauss <ppkrauss(at)gmail(dot)com>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: temporal algebra and data type
Date: 2012-02-22 13:14:08
Message-ID: 4F44EA20.8070504@timbira.com (view raw)
On 22-02-2012 09:50, Peter Padua Krauss wrote:
> 1) There are another  project, similar or better than my!? There are "pure SQL
> standard libraries" for this?
> 
Range Types [1]. It is 9.2 material but it is already in the repository.


[1] http://www.postgresql.org/docs/devel/static/rangetypes.html


-- 
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento


Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group