Hi, I cannot get the file:
wget http://www.rsmogura.net/pgsql/pgjdbc_exp_20101130_C.tar.gz --2010-12-01 12:05:28-- http://www.rsmogura.net/pgsql/pgjdbc_exp_20101130_C.tar.gz Resolving www.rsmogura.net... 64.120.14.83 Connecting to www.rsmogura.net|64.120.14.83|:80... connected. HTTP request sent, awaiting response... 404 Not Found 2010-12-01 12:05:29 ERROR 404: Not Found. On Tue, Nov 30, 2010 at 7:49 PM, Radosław Smogura <m...@smogura.eu> wrote: > Hello, > > Maybe you are interested about this what I done with JDBC > > === Original driver (Text mode) === > * Memory * > 1. Memory usage improvments when using result set input streams (no uneeded > memory copy) - needs few touches for bigger performance. > 2. Memory usage improvments for large data, should be no problem to load > 1GB > bytea[] when have only 300MB of memory ("threshold" size still hardcoded). > > * JDBC 4 * > 1. XML are now correctly transformed before send to server - previous > version > used normal text-file transformations that is not enaugh. > 2. In all modes (text/binary) XMLs are sended in binary mode, so driver > don't > need to do special transformation (does it require libxml?), until > character > streams are used. > 3. JDBC4 exception throwing. > 4. XML objects are readable only once, you can't reuse it, update form > result > set (silently set to null on RS.updateRow() - shouldn't be silent) returns > null till refreshRow(), but you can write to them after load. > 5.Target XML behavior is streaming behavior to don't repeat problems with > bytea. > > * JDBC 4.1 * > 1. Just started. > > * Others * > 1. Few additional test cases. Few utils for XML checking (string equals is > too > less) no good, but better. > 2. Fixed bug, causing inproper time(stamps) encoding for WITH TIME ZONE > fields, > after changing default time zone. > > === Binary mode === > 1. Read for almost all data types with arrays. > 2. Write for few. > 3. Much more restrictive checking when casting form one type to other. > 4. Exceptions when casting from one type to other inproper type. > 5. Still ResultSet.getString() for XML will return XML - this spec. > prohibited > (X - base type conversion, x - possible conversion, no x - no base and > possible = no conversion). > 6. No getPriviliges for metadata - no binary output for ACL!!! > 7. Many, many tests passed. > 8. Data reading is faster for all reads (checked with profiler, against > original driver). > > Driver is here http://www.rsmogura.net/pgsql/pgjdbc_exp_20101130_C.tar.gzis > currently JDK 6 compatible (will be not), compressed patch takes about > 136kb > gziped. > > Kind regards & have a nice day > ---------- > Radosław Smogura > http://www.softperience.eu > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
