libzdb-general

libzdb-general@tildeslash.com

1 participants
152 discussions

unix sockets
by Paul J Stevens 02 Mar '09

02 Mar '09

Jan-Henrik, Is there a mechanism for connecting to postgresql through a unix socket? I see there is a 'unix-socket' query option for mysql, but what about pgsql? thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

[Announce] libzdb 2.4
by Jan-Henrik Haukeland 16 Feb '09

16 Feb '09

Version 2.4 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.4.tar.gz MD5 checksum: b4c4ba0090881d4714f7f3e56d6eadbd libzdb-2.4.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minor feature and bug fix release which has been tested on the following platforms: Darwin 9.6.0 [x86] Linux FC/U [x86/x64] FreeBSD [x86] Changes in this release: * The configure options --with_mysql=<path> and --with_postgresql=<path> has a new meaning. If <path> is given it is assumed to be the full path to respectively mysql_config and to pg_config. Example: ./configure --with_mysql=/usr/local/mysql/bin/mysql_config ./configure --with_postgresql=/usr/local/pgsql/bin/pg_config * From version 2.4, libzdb places its header files into a zdb sub-directory as in, <prefix>/include/zdb. Clients must now use the include-dir compiler flag, -I<prefix>/include/zdb. * Internal optimizing changes and improvements * Changed prototypes of type 'extern void foo()' to 'extern void foo(void)' so the library compiles without warning if -Wstrict-prototype is used with gcc. Thanks to Paul Stevens Bug fixes: * Fixed off-by-one bug in Vector_remove * PostgreSQL: Fixed PostgresqlResultSet_getColumnSize to report correct value. * PostgreSQL: Improved error reporting and fixed potential allocation bugs in prepared statements. * PostgreSQL: Calling PreparedStatement_setString with a NULL value now works

1 0

error in the configure script (No available database found or selected)
by Gustavo Baratto 20 Jan '09

20 Jan '09

Hello there... I'm getting a weird error saying no database was selected, even though the configure script seem to find mysql This is the full output of the configure script: opensolaris:~/src/libzdb-2.3# ./configure --prefix=/opt/libzdb-2.3 --with-mysql=/opt/mysql/ --without-postgresql --without-sqlite --enable-protected checking for a BSD-compatible install... /usr/bin/ginstall -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... config/install-sh -c -d checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for style of include used by make... GNU checking dependency style of gcc... none checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /usr/bin/ggrep checking for egrep... /usr/bin/ggrep -E checking whether gcc needs -traditional... no checking for re2c... no checking for flex... /usr/bin/flex checking build system type... i386-pc-solaris2.11 checking host system type... i386-pc-solaris2.11 checking for a sed that does not truncate output... /usr/bin/gsed checking for ld used by gcc... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking for /usr/ccs/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -p checking whether ln -s works... yes checking how to recognize dependent libraries... pass_all checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... g77 checking whether we are using the GNU Fortran 77 compiler... yes checking whether g77 accepts -g... yes checking the maximum length of command line arguments... 786240 checking command to parse /usr/bin/nm -p output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... no checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/ccs/bin/ld) supports shared libraries... yes checking whether -lc should be explicitly linked in... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... no checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... no checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for g77 option to produce PIC... -fPIC checking if g77 PIC flag -fPIC works... yes checking if g77 static flag -static works... no checking if g77 supports -c -o file.o... yes checking whether the g77 linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate checking for pthread_create in -lpthread... yes checking for mysql... checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for postgresql... no checking for SQLite3... sqlite=no configure: error: No available database found or selected. Try configure --help Thanks for any help

2 7

[Announce] libzdb 2.3
by Jan-Henrik Haukeland 05 Dec '08

05 Dec '08

Version 2.3 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.3.tar.gz MD5 checksum: 62e16369e268e9280978d36343207e60 libzdb-2.3.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minor feature release which has been tested on the following platforms: Darwin 9.5.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Note, a few function signatures in public interfaces has been changed. Functions that can throw an exception on error, now just returns void. This is done to be consistent wrt error handling via exceptions. This means that existing client code may require modest refactoring if return values are checked. In addition, internal improvements has been done here and there. Changes in this release: Version 2.3 ----------- * Cleaned up API and changed function return type to void for those functions that can throw exception on error. * Support variable arguments in Connection_prepareStatement() to make it easy to build prepared statements in-place

1 0

support for other databases
by Uwe Kiewel 04 Dec '08

04 Dec '08

Hi, do you plan to implement support for other databases? An interface to sqlrelay and/or DB2 would be fine. Kind regards, Uwe

2 1

[Announce] libzdb 2.2.3
by Jan-Henrik Haukeland 30 Jul '08

30 Jul '08

Version 2.2.3 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.3.tar.gz MD5 checksum: a2a79dfbafa10a20d2cf0edfb5d5795e libzdb-2.2.3.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a bug fix release which has been tested on the following platforms: Darwin 9.4.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Note, this release should fix problems with SQLite database locks. As you probably know, SQLite locks the database file on certain operations. This is a problem when two or more connections tries to update the SQLite database at the same time, since only one connection will succeed. There are ways around this problem and the strategy we use in libzdb is to retry the statement whenever a database lock is encountered. Unfortunately the retry code had a bug which prevented it to run more than one time. This is now fixed and libzdb will handle concurrent usage of SQLite much better. Changes in this release: Version 2.2.3 ------------- Bug fixes: * Make sure connection properties, max rows and query timeout are reset on Connection_close(), if changed. * Ensure that timeout is set for new Connections and fixed a bug in the SQLite retry macro so the SQLite driver now will retry executing on database lock

1 0

[Announce] libzdb 2.2.2
by Jan-Henrik Haukeland 08 Jun '08

08 Jun '08

Version 2.2.2 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.2.tar.gz MD5 checksum: 756e148181b8f108a8a586dbd0a25b0c libzdb-2.2.2.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a non-critical minor bug fix release which has been tested on the following platforms: Darwin 9.3.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Changes in this release: Version 2.2.2 ------------- * Ensure that reaper progress forward and remove all connections it can * Fixed a va_copy bug on 64 bits systems

1 0

[Announce] libzdb 2.2.1
by Jan-Henrik Haukeland 04 May '08

04 May '08

Version 2.2.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.1.tar.gz MD5 checksum: 20c6bceae77f9e358e19b3ca4283afa1 libzdb-2.2.1.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a bug fix release which has been tested on the following platforms: Darwin 9.2.2 [ppc/x86] Linux FC/U [x86] Changes in this release: Version 2.2.1 ------------- * SQLite: Improved error reporting by using sqlite3_prepare_v2() when available. Thanks to Paul Stevens for suggesting this. Bug fixes: * MySQL and PostgreSQL: Fixed off-by-one count when verifying validity of parameter and column index. Thanks to Paul Stevens for bug report. * MySQL: Workaround mysql column truncation bug. Thanks to Paul Stevens for bug report.

1 0

Connection_lastRowId on postgresql
by Paul J Stevens 03 May '08

03 May '08

Jan-Henrik, This call always returns 0 on a postgresql connection. I assume this is because my tables are without OIDs. Is that intentional? I can work around it. But perhaps a small note in the api docs would be in order? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 15

ensureCapacity
by Paul J Stevens 03 May '08

03 May '08

Jan-Henrik, Found some time today to do more testing on a problem I was still having with the mysql driver (the postgres driver is kicking ass). I suspect there is still a problem in ensureCapacity (or it's consumers). I'm attaching a small program that will reliably reproduce this. Looks like strings from the /first/ row (and only the first row) retrieved from a resultset are still being truncated at 256 char length. tested against yesterdays svn-rev. thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general