Re: Roadmap for a Win32 port - Mailing list pgsql-hackers

Hi Bruce,

You obviosuly missed my recent posting advertising the homepage
of Konstantin Knizhnik?

Make sure to have a look: http://www.garret.ru/~knizhnik/

You find there -everything- concerning multiplatform IPC,
threading and even some extraordinary, complete database
backends that are superior to the database backends
previously available as open source (including PostgreSQL,
I'm afraid...). The licensing of all of this stuff is -public domain-.
I think this should really be worth a look/discussion/mentioning.

Here an excerpt of my last email, describing the furios list
of features abailable in GOODS:

Some core features of the GOODS backend (as they come to my mind):
-> full ACID transaction support, incl. distributed transactions
-> Multiple stoarge servers distributed over a TCP/ID network
-> multible reader/single writer (MVCC)
-> dual client side object cache
-> online backup (snapshot backup AND permanent backup)
-> nested transactions on object level
-> transaction isolation levels on object level
-> object level shared and exclusive locks
-> excellent C++ programming interface
-> WAL
-> garbage collection for no longer reference database objects (online VACUUM)
-> fully thread safe client interface
-> JAVA client API
-> very high performance as a result of a lot of fine tuning (better  perfomance than berkeley db in my benchmarks!!!)
-> asyncrous event notification on object instance modification
-> extremly high code quality
-> a one person effort, hence a very clean design
-> the most relevant platforms are supported out of the box
-> complete build is done in less than a minute on my machine
-> it's documented
-> it's tested and found to be working for a while now
...

kind regards,
Robert Schrem


On Thursday 06 June 2002 04:57, you wrote:
> Here is a summary of the responses to my Win32 roadmap.  I hope this
> will allow further discussion.
>
> ---------------------------------------------------------------------------
>
> INSTALLER
> ---------
> Cygwin Setup.exe                        http://cygwin.com
> Nullsoft                                http://www.nullsoft.com/free/nsis/
>
> GUI
> ---
> pgAdmin2
> http://pgadmin.postgresql.org/pgadmin2.php?ContentID=1 pgaccess
>                    http://pgaccess.org/
> Java admin (to be written)
> Dev-C++ admin (to be written)
> http://sourceforge.net/projects/dev-cpp/
>
> BINARY
> ------
>
>
> FORK()
>
> cygwin fork()                           http://cygwin.com
> CreateProcess() and copy global area
>
> THREADING
>
> Posix threads
> Gnu pth                                 http://www.gnu.org/software/pth/
> ST
> http://state-threads.sourceforge.net/docs/st.html (single-session
> multi-threading possible)
> (Posix AIO is possible)
>
> IPC
>
> Cygwin                                  http://cygwin.com
> MinGW                                   http://www.mingw.org/
> ACE
> http://www.cs.wustl.edu/~schmidt/ACE.html APR
>       http://apr.apache.org/
> Our own
>
> ENVIRONMENT
>
> Cygwin                                  http://cygwin.com
> UnxUtils                                http://unxutils.sourceforge.net/
> Write own initdb
>
>
> IMPLEMENTATIONS
> ---------------
> PostgreSQLe
> http://hp.vector.co.jp/authors/VA023283/PostgreSQLe.html Dbexperts
>                      http://www.dbexperts.net/postgresql Connx
>                      http://www.connx.com/
> gborg
> http://gborg.postgresql.org/project/winpackage/projdisplay.php Interbase
>
> http://community.borland.com/article/0,1410,23217,00.html