Re: Improvements to PostgreSQL

Suresh Tri wrote:
> 2. Core functionality add-ons to postgresql :-
> -Table joins

Already done.

> -Java stored procedures

Already done.

> -Backup and recovery (incremental backup/restore)

Will appear in next release.

> -Query optimization
> * Indexing techniques
> * Star query optimization

Good luck with that. :-)

> - Data Types
> * BLBL
> * Images
> * Long

These are probably redundant with bytea.

> 3. Application compatibility
> -Oracle Compatible JDBC driver

JDBC drivers should be compatible with the JDBC standard, not with some
vendor.

> -Query compatibility
> * Oracle DML/DDL Compatibility

Like what?

> * Behavioral differences like null handling

Not gonna happen.

> * Nested Queries

Do you mean recursive queries?

> * Manual Optimization Hints

These are probably not going to be compatible with Oracle anyway.

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

PostgreSQL is already enterprise-level.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/