libzdb-general

libzdb-general@tildeslash.com

1 participants
152 discussions

[Announce] libzdb 2.7
by Jan-Henrik Haukeland 14 Oct '10

14 Oct '10

"Good news, everyone!" Version 2.7 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.7.tar.gz MD5 checksum: 8c7241e482c88076739df96dc578143d Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature and bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * Mac OS X Leopard (Darwin 10.5.x ppc) * FreeBSD 6.x, 7.x and 8.x (x86 and x64) * Solaris 10 and Solaris Express (sparc and x86) * OpenBSD 4.x (x86 and x64) Release notes: -------------- This release brings tentative Oracle support to libzdb thanks to Volodymyr Tarasenko. If you already have Oracle installed on your system, then simply running configure should pick it up. Otherwise if you want to build libzdb with Oracle support, but don't have Oracle installed (like me) it is a bit more work. Here's what I did; download Instant Client (basic and sdk) from http://www.oracle.com/ Create a oci directory someplace and copy header files and libs into this directory. Then use this configure statement; ./configure --with-oci-include=/<path>/oci/include --with-oci-lib=/<path>/oci/lib The Oracle implementation is not quite yet production ready which emerge from the change log below, though for most practical purposes it should work - according to Volodymyr. If you want to help out testing and improving it, please do. The SQLite implementation has been further improved by adding a configure option to make SQLite release unused memory. This is very useful as SQLite does not care so much about releasing memory and its memory usage can grow considerably if left unchecked. Changes in this release: ------------------------ * Added tentative support for Oracle. Thanks to Volodymyr Tarasenko, and Sergey Pavlov for implementing this. This implementation does not support BLOB, though CLOB is supported. It will also not run all zdb unit tests, but should be useful for most purposes. It is released with the hope that others may still find it useful and help iron out any remaining issues. * Added new convenience zdb.h meta include file which can be used to include all required API interfaces * Internal optimizing changes and improvements - we simply adore refactoring * SQLite: Clear connection on rollback to prevent SQLite from issue an SQLITE_BUSY error if there are pending selects in progress. * SQLite: added a "heap_limit" URL property. Makes SQLite auto-release unused memory if memory usage goes above the specified limit [KB]. Require that SQLite is compiled with the SQLITE_ENABLE_MEMORY_MANAGEMENT option to take effect. Bug fixes: * SQLite: Ensure that the database file is specified in connection URL. Thanks to Bogdan Nicula. * PostgreSQL: Implemented Connection_setQueryTimeout()

3 4

Re: Configure/compile issues on Solaris SPARC
by Lou Picciano 11 Aug '10

11 Aug '10

Martin, Thanks for your response. the reason why postgresql library was not found by ldd on your system is, that the loader path is not set to it. You need to fix the loader path either using solaris' "crle" utility or setting LD_LIBRARY_PATH env. variable. We are well aware of the crle tool. It does offer some powerful utility for environment-wide runtime linking; but this is definitely not what we want to do. The preferred approach is to link the correct libraries - often different versions for different purposes - against specific binaries. We could fiddle with the runtime environment of each binary in any number of ways, but this is just 'bad practice'; to create one-off solutions to the runtime environment for each executable. This is a management nightmare! Regarding mysql version - the error is reported because mysql.h file contains invalid version. (I don't think it does, if your test is >= 4.1): # grep MYSQL_VERSION_ID /usr/local/mysql/include/mysql/mysql.h #if defined(EMBEDDED_LIBRARY) || defined(EMBEDDED_LIBRARY_COMPATIBLE) || MYSQL_VERSION_ID >= 50100 1.) attach config.log so we can check it 2.) provide output of "grep MYSQL_VERSION_ID /path/to/your/mysql.h" I just ran the whole process against against a freshly-downloaded source tree to provide you an empirical test. (FWIW, an # configure distclean left our previous source tree in an unconfigure-able state). I even added the LD_LIBRARY_PATH variable, in case you're testing for it in config. (Didn't see any evidence you were). ./configure \ CPPFLAGS='-I/usr/local/postgres/9b4/include/' \ LDFLAGS='-L/usr/local/postgres/9b4/lib/' \ LD_LIBRARY_PATH='/usr/local/postgres/9b4/lib/' \ PGCONFIG='/usr/local/postgres/9b4/bin/pg_config' \ --enable-optimized \ --enable-protected \ --enable-openssl=/usr/local/ssl \ --enable-sqliteunlock \ --with-mysql=/usr/local/mysql/bin/mysql_config \ --with-postgresql=/usr/local/postgres/9b4/bin/pg_config \ --with-sqlite=/usr/local Here's the result of configure: +------------------------------------------------------------+ | The Zild Database Library is configured as follows: | | | | Optimized: ENABLED | | Protected: ENABLED | | Profiling: DISABLED | | Zild: DISABLED | | Sqlite3 unlock notification API: ENABLED | | Unit Tests Build: DISABLED | | Openssl: ENABLED | |------------------------------------------------------------| | SQLite3: ENABLED | | MySQL: DISABLED | | PostgreSQL: ENABLED | +------------------------------------------------------------+ Here is the output of ldd: # ldd /usr/local/lib/libzdb.so libpq.so.5 => (file not found) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (...etc) (this build does not link at all to any mysql client... As I've mentioned, I've been able to get a mysqlclient linked in by modifying the configure script) And the config.log is attached. Thanks for your ideas. Lou ----- Original Message ----- From: "Martin Pala" <martinp(a)tildeslash.com> To: "This is the libzdb general mailing list" <libzdb-general(a)tildeslash.com> Sent: Wednesday, August 11, 2010 3:28:44 PM Subject: Re: Configure/compile issues on Solaris SPARC Lou, the reason why postgresql library was not found by ldd on your system is, that the loader path is not set to it. You need to fix the loader path either using solaris' "crle" utility or setting LD_LIBRARY_PATH env. variable. Regarding mysql version - the error is reported because mysql.h file contains invalid version. Please: 1.) attach config.log so we can check it 2.) provide output of "grep MYSQL_VERSION_ID /path/to/your/mysql.h" On Aug 11, 2010, at 9:18 PM, Lou Picciano wrote: Paul, > let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ Indeed there is. In fact, there may be a few, as would be normal on these systems; different versions of not only MySQL, but of any number of tools, used in different ways for different objectives, or to test different variables. This is very common in our testing of multiple versions of OpenSSL, for example, and works flawlessly... But what's relevant in this case, I should think, is that the specific version of MySQL to which we point, using configure, --with-mysql=/usr/local/mysql/bin/mysql_config \ ...is indeed >= 4.1, as indicated by this note: # /usr/local/mysql/bin/mysql_config --version 5.0.51 In further testing, we were able to achieve the MySQL integration by 'manhandling' the configure script - shouldn't have to do this! - but cannot get the correct version of PostgreSQL recognized: # ldd /usr/local/lib/libzdb.so libpq.so.4 => /usr/lib/libpq.so.4 -- OR, Depending on configuration: ---- libpq.so.5 => (file not found) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 libmysqlclient.so.15 => /usr/local/mysql/lib/mysql/libmysqlclient.so.15 even though we're pointing to an instance of PostgreSQL in an entirely different location. --with-postgresql=/usr/local/postgres/9b4/bin/pg_config Are you maintaining the libzdb package, too? What do you think the answer is? Lou ----- Original Message ----- From: "Paul J Stevens" < paul(a)nfg.nl > To: "This is the libzdb general mailing list" < libzdb-general(a)tildeslash.com > Sent: Wednesday, August 11, 2010 2:26:39 PM Subject: Re: Configure/compile issues on Solaris SPARC Me again :-) Lou, let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ On 08/11/2010 06:57 PM, Lou Picciano wrote: > > # nm /usr/local/mysql/lib/mysql/libmysqlclient.so | grep mysql_init > 000300f0 T mysql_init > > ) > > Some pertinent output from configure: > > ... -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

2 1

Re: Configure/compile issues on Solaris SPARC
by Lou Picciano 11 Aug '10

11 Aug '10

Paul, > let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ Indeed there is. In fact, there may be a few, as would be normal on these systems; different versions of not only MySQL, but of any number of tools, used in different ways for different objectives, or to test different variables. This is very common in our testing of multiple versions of OpenSSL, for example, and works flawlessly... But what's relevant in this case, I should think, is that the specific version of MySQL to which we point, using configure, --with-mysql=/usr/local/mysql/bin/mysql_config \ ...is indeed >= 4.1, as indicated by this note: # /usr/local/mysql/bin/mysql_config --version 5.0.51 In further testing, we were able to achieve the MySQL integration by 'manhandling' the configure script - shouldn't have to do this! - but cannot get the correct version of PostgreSQL recognized: # ldd /usr/local/lib/libzdb.so libpq.so.4 => /usr/lib/libpq.so.4 -- OR, Depending on configuration: ---- libpq.so.5 => (file not found) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 libmysqlclient.so.15 => /usr/local/mysql/lib/mysql/libmysqlclient.so.15 even though we're pointing to an instance of PostgreSQL in an entirely different location. --with-postgresql=/usr/local/postgres/9b4/bin/pg_config Are you maintaining the libzdb package, too? What do you think the answer is? Lou ----- Original Message ----- From: "Paul J Stevens" <paul(a)nfg.nl> To: "This is the libzdb general mailing list" <libzdb-general(a)tildeslash.com> Sent: Wednesday, August 11, 2010 2:26:39 PM Subject: Re: Configure/compile issues on Solaris SPARC Me again :-) Lou, let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ On 08/11/2010 06:57 PM, Lou Picciano wrote: > > # nm /usr/local/mysql/lib/mysql/libmysqlclient.so | grep mysql_init > 000300f0 T mysql_init > > ) > > Some pertinent output from configure: > > ... -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

2 1

Configure/compile issues on Solaris SPARC
by Lou Picciano 11 Aug '10

11 Aug '10

Hello Listers! A question about building libzdb - against latest betas of PostgreSQL and MySQL... FWIW, PostgreSQL is by far our focus at the moment. We have been specifying the pg_config location with the --with-postgresql option. configure does find pg_config # ./configure \ LDFLAGS='-L/usr/local/postgres/9b4/lib/' \ --enable-optimized \ --enable-protected \ --enable-openssl=/usr/local/ssl \ --enable-sqliteunlock \ --with-mysql=/usr/local/mysql/bin/mysql_config \ --with-postgresql=/usr/local/postgres/9b4/bin/pg_config \ --with-sqlite=/usr/local (note: # /usr/local/postgres/9b4/bin/pg_config --version PostgreSQL 9.0beta4 # /usr/local/mysql/bin/mysql_config --version 5.0.51 # nm /usr/local/mysql/lib/mysql/libmysqlclient.so | grep mysql_init 000300f0 T mysql_init ) Some pertinent output from configure: ... checking for /usr/local/mysql/bin/mysql_config... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for mysql_init in -lmysqlclient... yes fail, >= 4.1 required checking for postgresql... yes checking for /usr/local/postgres/9b4/bin/pg_config... yes checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes ... +------------------------------------------------------------+ | License: | | This is Open Source Software and use is subject to the GNU | | GENERAL PUBLIC LICENSE, available in this distribution in | | the file COPYING. | | | | By continuing this installation process, you are bound by | | the terms of this license agreement. If you do not agree | | with the terms of this license, you must abort the | | installation process at this point. | +------------------------------------------------------------+ | The Zild Database Library is configured as follows: | | | | Optimized: ENABLED | | Protected: ENABLED | | Profiling: DISABLED | | Zild: DISABLED | | Sqlite3 unlock notification API: ENABLED | | Unit Tests Build: DISABLED | | Openssl: ENABLED | |------------------------------------------------------------| | SQLite3: ENABLED | | MySQL: DISABLED | | PostgreSQL: ENABLED | +------------------------------------------------------------+ Platform is sun4u - Solaris SPARC E450 Any Ideas? We're off to try fiddling with the configure script... thanks! Lou

2 1

libzdb compilation with G++ compiler
by neo reeves 02 Dec '09

02 Dec '09

Hi All, I would like to link the zdb library with the existing CPP source code. So when I tried to compile the zdb library code with GNU cpp compiler, its not able to compile. Can anybody please let me know how to link or compile the zdb library with the CPP source code. Thanks in advance,- Neo The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

1 0

[Announce] libzdb 2.6
by Jan-Henrik Haukeland 03 Jul '09

03 Jul '09

Version 2.6 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.6.tar.gz MD5 checksum: 54eef941f130768d2d0a311873550e25 libzdb-2.6.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature and bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Leopard (Darwin 10.5.x x86/ppc) * FreeBSD 6.x and 7.x (x86 and x64) * Solaris 10 and Solaris Express (sparc/x86) * OpenBSD 4.x (x64) Release notes: -------------- 1) This release greatly improves upon SQLite concurrency. We have tested libzdb with SQLite using up to 300 concurrent threads without experiencing lock problems. To achieve this, we use the experimental SQLite unlock notification API. To enable this API you need to first build and configure SQLite (version > 3.6.12) with the SQLITE_ENABLE_UNLOCK_NOTIFY preprocessor symbol like so: CFLAGS="$CFLAGS -DSQLITE_ENABLE_UNLOCK_NOTIFY" ./configure ... Then you need to enable this API in libzdb using the --enable- sqliteunlock configure switch when configuring and building libzdb. 2) For those using libzdb with the excellent DBMail (http://www.dbmail.org/ ) project it is strongly recommended to upgrade. This version of libzdb is tested by the DBMail project and should work with the latest DBMail release. Changes in this release: ------------------------ * Internal optimizing changes and improvements * Enable shared cache mode for SQLite >= 3.5 * Added new configure option --enable-sqliteunlock which enables SQLite unlock notification. This feature requires SQLite >= 3.6.12 compiled with the SQLITE_ENABLE_UNLOCK_NOTIFY C-preprocessor symbol. This option greately improves upon SQLite concurrency when libzdb and SQLite is used from a multi-threaded program. * Removed deprecated ResultSet_readData() from API Bug fixes: * PostgreSQL: Unescape values retrieved via ResultSet_getBlob() and via ResultSet_getBlobByName(). By an incurie, unescape was left out of libzdb version 2.5.

1 0

error in the configure script
by Gustavo Baratto 15 Apr '09

15 Apr '09

Hello there... I got this error in the configure script on 2.5: # ./configure --prefix=/opt/libzdb-2.5 --with-mysql=/opt/mysql/bin/mysql_config --without-postgresql --without-sqlite --enable-protected --enable-optimized 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 library containing crypt... none required checking for mysql... yes checking for /opt/mysql/bin/mysql_config... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for mysql_init in -lmysqlclient... yes fail, >= 4.1 required checking for postgresql... no checking for SQLite3... no configure: error: No available database found or selected. Try configure --help I created this patch, and now I don't get the error anymore: # diff -bu configure configure.new --- configure Tue Apr 14 21:59:50 2009 +++ configure.new Tue Apr 14 21:59:22 2009 @@ -20331,7 +20331,7 @@ sed 's/^/| /' conftest.$ac_ext >&5 ( exit $ac_status ) -mysql="no" +mysql="yes" fi rm -f core *.core core.conftest.* gmon.out bb.out conftest$ac_exeext conftest.$ac_objext conftest.$ac_ext fi -- g.

2 2

[Announce] libzdb 2.5
by Jan-Henrik Haukeland 05 Apr '09

05 Apr '09

Version 2.5 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.5.tar.gz MD5 checksum: cf9406ce6505e6265a07ada4990b6526 libzdb-2.5.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 6/7 [x86/x64] Changes in this release: * PostgreSQL: Blob retrieval optimized * PostgreSQL: Added unix-socket parameter to connection URL * Removed GPL license exceptions. The library is now licensed under the GPL version 3 only. * Deprecated ResultSet_readData(). This function _is_ useful for MySQL, but not for other drivers where it has some overhead. * Added GCC __attribute__ printf checks where applicable * Internal optimizing changes and improvements We expect this release to be stable for some time. Just a FYI if you plan to package this release.

1 1

Is 2.5 PPC Mac OS X Compatible?
by Mike McGonagle 05 Apr '09

05 Apr '09

Hello, I was going through the 2.5 version hoping to install this on my Mac, and test some stuff out. But it appears from the annoucement email, that it only supports Intel Mac, is this true? or is there a ./configure option that would allow PPC compilation? Thanks, Mike

2 4

Packaging for Fedora
by Bernard Johnson 02 Mar '09

02 Mar '09

Hello, I was trying to package libzdb for inclusion in Fedora. One concern that came up was the sonames generated with the version of libzdb as part of the soname. https://bugzilla.redhat.com/show_bug.cgi?id=474044#c4 Have you considered generating your sonames to reflect the ABI version of the package rather than tying it to the package version?

2 6

← Newer
1
...
9
10
11
12
13
14
15
16
Older →

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