Re: Improvements to PostgreSQL

Hi,

I am already a member of hackers group and I get all
the messages posted to the group. In fact I get 2
copies of each!! I think I subscribed twice. But I am
unable to send messages to the group.

Here are the feature list which we are planning to
implement. This list is obtained by comparing the
features of Oracle 8i and Postgresql 7.4 . We know
that a lot more work has to be done in finding the
exact features and the way to implement them. Anyway
this is our initial list :

Our basic idea is to divide the task of migrating from
Oracle to postgresql in 3 parts
1. Automation of migration from Oracle to postgresql
:- there is already the tool ora2pg - but we came to
know that a lot of things have to be improved to
totally automate it.

2. Core functionality add-ons to postgresql :-
-Table joins
-Java stored procedures
-Backup and recovery (incremental backup/restore)
-Query optimization
* Indexing techniques
* Star query optimization
- Data Types
* BLBL
* Images
* Long
Some of the above features are already present, but
may not be complete(as compared to Oracle).

3. Application compatibility
-Oracle Compatible JDBC driver
-PL/SQL Compatibility
* Named parameter
* Parameterized Cursors
* Output Paramters
-Query compatibility
* Oracle DML/DDL Compatibility
* Behavioral differences like null handling
* Nested Queries
* Manual Optimization Hints

I know that this list is not totally explainative, but
we will provide you further details as we investigate
deeper in this regard.

All your sugestions are welcome. Please help us to
implement these features.
Our aim is to make postgresql enterprise level.

Thanks,
Suresh

--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote: > I
am forwarding this to hackers on behalf of some
> people who want to
> improve PostgreSQL in India.
>
> I suggest you read the developers FAQ on the
> developers page:
>
> http://developers.postgresql.org
>
> then subscribe to hackers to discuss feature
> additions. Thanks.
>
>
---------------------------------------------------------------------------
>
> Suresh Tri wrote:
> > Hi all,
> >
> > We are a bunch(about 10)of enthusiastic software
> > engineers from Bangalore who strongly believe in
> > opensource.
> > We are currently looking at the prospect of
> improving
> > the PostgreSQL to the enterprise level. At first
> we
> > would like to take PostgreSQL atleast to the level
> of
> > Oracle 7i or 8i. We already have the difflist of
> > features differences between Oracle 8i and the
> current
> > PostgreSQL(7.4). But we are finding it hard to
> > prioritize the features.
> > What do you think are the important features that
> are
> > present in Oracle 8i but absent in the current
> > PostgreSQL ehich the enterprises look at. It would
> be
> > of the great help if you can tell us about these
> > featues and also the way in which we can
> contribute to
> > the PostgreSQL development.
>
> --
> Bruce Momjian |
> http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610)
> 359-1001
> + If your life is a hard drive, | 13 Roberts
> Road
> + Christ can be your backup. | Newtown
> Square, Pennsylvania 19073
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>

___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://www.allnewmessenger.com