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/