[needs-packaging] Oracle DBXML

[Andrew West]

This is a request for packaging Oracles DBXML, a XML database system that provides command line tools as well as language extensions to access the databases. It's available under the Apache license.

Available here;
http://www.oracle.com/technology/products/berkeley-db/xml/index.html

[strangedata (rcteigao)]

up

[Ralph Janke (txwikinger)]

The sources tarball from oracle contains really 4 packages. Two of them libdb4.6 and libxerces28 are already packages in debian/ubuntu in hardy, and xquilla exists as well as libxqilla3 in hardy.

[Zeth (zeth0)]

The tarball from Oracle contains four packages, three of which are already in Ubuntu. libdb is in Ubuntu, as is libxerces, while xqilla is new in intrepid:http://packages.ubuntu.com/intrepid/xqilla
So the main thing for the package is only the dbxml directory. Of course, how versions work out is an issue.

[Ralph Janke (txwikinger)]

Correctlion xqilla and libxqilla3 exist only from intrepid

[Zeth (zeth0)]

The Oracle bundle has these:

xercesc_content_type.patch
xercesc_regex.patch

These are in Gentoo's xerces package, but are they in Ubuntu?:
http://packages.larrythecow.org/?v=ebuild&s=dev-libs%2Fxerces-c-2.7.0-r1

[Zeth (zeth0)]

So it seems most of the deps are on the way somewhere. The remaining things are the dbxml package itself, and hopefully the Python bindings also, e.g. python-dbxml.

[Oliver Dungey (oliver-dungey)]

I have just been building this package using instructions from here:
http://commandline.org.uk/electronic-text/2008/aug/14/native-xml-storage-db-xml-part-one/

Nearly got it all compiled using the standard Intrepid components but I have now come unstuck with the error:
ImpliedSchemaGenerator.cpp:80:50: error: xqilla/functions/FunctionParseJSON.hpp: No such file or directory

It seems that the problem is xqilla, libxqilla-dev and libxqilla3 are from the 2.0 version set but bdbxml needs 2.1.2.

Anyone know when we are likely to see this xqilla update in Intrepid?

[Robert Paulsen (robert-paulsenonline)]

Any update on this?

dbxml is a very handy tool. I have several little home-brew apps that use it and since I have moved from SLES to Kubuntu I miss it. I can build and install it manually but would rather have an "official" build that didn't drag along dependencies with version numbers that mismatch the Ubuntu 9.10 versions.

[Raphael Jolivet (raphael-jolivet)]

Up.

Berkeley DB XML is a really nice piece of software that deserves a better visibility.
I think that having an official package in Ubuntu would help it to be widely adopted.

I would really like to have the PHP mod packaged as well.
It's time we move from SQL-based database to more flexible solutions for web sites development.

As per the official build guide (http://www.oracle.com/technology/documentation/berkeley-db/xml/ref_xml/xml_unix/intro.html) :
"The Berkeley DB XML distribution comprises several libraries: a base C++ library, three third-party libraries, and optional libraries for additional language interfaces such as Java, Perl, Python, PHP, and Tcl".

So I guess this could be split into 5 different packages :
* berkeley-xmldb
* berkeley-xmldb-java
* berkeley-xmldb-php
* berkeley-xmldb-python
* berkeley-xmldb-tcl

The third party libraries (libdb, qxilla, libxerces) being already distributed in ubuntu.

Thanks for considering this request.

[Gregory Burd (gregburd)]

Hello, I'm the product manager over at Oracle in the Berkeley DB group. I created a Launchpad project for BDB XML https://launchpad.net/berkeley-db-xml and I'm generally available for questions, help, etc on this and other BDB related topics.

Unless there is a really good reason to use the "xmldb" name I'd prefer if we called the packages:
* berkeley-dbxml
* berkeley-dbxml-java
* berkeley-dbxml-php
* berkeley-dbxml-python
* berkeley-dbxml-tcl

I know, it's a nit pick... :)

-greg

[Robert Paulsen (robert-paulsenonline)]

Greg,

Thanks for your interest in ths!

"dbxml" makes sense.

The main thing is getting it into (K)Ububtu!

[Gregory Burd (gregburd)]

I couldn't agree more. We need it in the distro and ideally used in
some visible manner so that people can see that it's viable.

-greg

On Wed, Jun 23, 2010 at 1:20 PM, Robert Paulsen
<email address hidden> wrote:
> Greg,
>
> Thanks for your interest in ths!
>
> "dbxml" makes sense.
>
> The main thing is getting it into (K)Ububtu!
>
> --
> [needs-packaging] Oracle DBXML
> https://bugs.launchpad.net/bugs/157165
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Ubuntu: In Progress
>
> Bug description:
> This is a request for packaging Oracles DBXML, a XML database system that provides command line tools as well as language extensions to access the databases. It's available under the Apache license.
>
> Available here;
> http://www.oracle.com/technology/products/berkeley-db/xml/index.html
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/ubuntu/+bug/157165/+subscribe
>

[Lars (larsmans)]

An effort to package DBXML for Debian is underway at http://mentors.debian.net/cgi-bin/sponsor-pkglist?action=details;package=dbxml. It seems the requirements are all in Ubuntu 10.10, so I'm planning of upgrading and trying it out one of these days. Will report here if it works.

(I posted this two days ago, but the comment seemt to have disappeared. Maybe yesterday's admin work has something to do with this.)

[Gregory Burd (gregburd)]

If you need help from Oracle or have questions please feel free to
contact me: <email address hidden> - I'm a product manager working in
the Oracle Berkeley DB Group. Thank you for your efforts.

-greg

[Lars (larsmans)]

I've finally found the time to check out the Debian package, but it won't build (the Debian folks know this, http://mentors.debian.net/cgi-bin/sponsor-pkglist?action=details;package=dbxml). I've volunteered to fix this package.

I've set up a repository at http://github.com/larsmans/dbxml-debian. Anyone who'd like to help (Greg, got any developers with too much spare time on their hands?) can join in. As far as I can see, the errors are in the debian/rules file, where debhelper should be called with --sourcedirectory=dbxml.

[Gregory Burd (gregburd)]

I'll ask around but with the Holidays and two releases in the pipe it's not likely. We can certainly answer questions, and if you find something that needs to be fixed/changed in BDB XML let me know sooner than later so that we can get it into the next release.

Cheers, and thanks for doing this work!!! :)

-greg

> -----Original Message-----
> From: Gregory Scott Burd [mailto:<email address hidden>]
> Sent: Monday, December 20, 2010 11:46 AM
> To: Gregory Burd
> Subject: Fwd: [Bug 157165] Re: [needs-packaging] Oracle DBXML
>
> ---------- Forwarded message ----------
> From: Lars <email address hidden>
> Date: Sun, Dec 19, 2010 at 4:59 PM
> Subject: [Bug 157165] Re: [needs-packaging] Oracle DBXML
> To: <email address hidden>
>
>
> I've finally found the time to check out the Debian package, but it
> won't build (the Debian folks know this, http://mentors.debian.net/cgi-
> bin/sponsor-pkglist?action=details;package=dbxml). I've volunteered to
> fix this package.
>
> I've set up a repository at http://github.com/larsmans/dbxml-debian.
> Anyone who'd like to help (Greg, got any developers with too much spare
> time on their hands?) can join in. As far as I can see, the errors are
> in the debian/rules file, where debhelper should be called with
> --sourcedirectory=dbxml.
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/157165
>
> Title:
>  [needs-packaging] Oracle DBXML
>
> Status in Ubuntu:
>  In Progress
>
> Bug description:
>  This is a request for packaging Oracles DBXML, a XML database system
> that provides command line tools as well as language extensions to
> access the databases. It's available under the Apache license.
>
> Available here;
> http://www.oracle.com/technology/products/berkeley-db/xml/index.html
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/ubuntu/+bug/157165/+subscribe

[Lars (larsmans)]

This took me much longer than I thought, but I've finally got round to uploading a first attempt to mentors.debian.net and requested sponsoring from a Debian developer. If picked up, DB XML should end up in the Debian package repo, where Ubuntu can pick it up.

The package includes manpages for the tools, distilled from the HTML docs, since Debian wants to have a manpage for each and every command. @Gregory, those may be worthwhile to include in the upstream distribution. I've made no other changes to the package.

[Daniël de Kok (danieldk)]

I have a dbxml build (based on Lars') work here:

https://launchpad.net/~danieldk/+archive/dact

In contrast to upstream, it builds against Berkeley DB 5.1. I still have to check compatibility against dbxml + db 4.8. I'll also make an updated Debian package later.

[Daniël de Kok (danieldk)]

Works for our application:

- Created a database with dbxml, linked against DB 5.1 on Ubuntu.
- Opened with dbxml, linked against DB 4.8 on OS X. Everything works as expected.

The rationale for building against DB 5.1 is that libdb4.8++ is removed in Debian sid.

[Gregory Burd (gregburd)]

Although I'm no longer at Oracle working on Berkeley DB I am fairly
confident when I say that the majority of the changes in BDB since 4.8
were related to a) the integration of the SQLite layer (the SQL API)
and b) scalability/locking changes below the API to improve multi-core
scalability. I think that is why the older version of BDB XML still
works as expected with the latest version of BDB. Of course testing
the combination should be something that the community does to ensure
quality as I'm sure that Oracle will not "bless" this combination as
"supported" until they release a newer version of BDB XML.

-greg

On Sun, Jun 5, 2011 at 8:52 AM, Daniël de Kok <email address hidden> wrote:
> Works for our application:
>
> - Created a database with dbxml, linked against DB 5.1 on Ubuntu.
> - Opened with dbxml, linked against DB 4.8 on OS X. Everything works as expected.
>
> The rationale for building against DB 5.1 is that libdb4.8++ is removed
> in Debian sid.
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/157165
>
> Title:
>  [needs-packaging] Oracle DBXML
>
> Status in Ubuntu:
>  In Progress
>
> Bug description:
>  This is a request for packaging Oracles DBXML, a XML database system
>  that provides command line tools as well as language extensions to
>  access the databases. It's available under the Apache license.
>
>  Available here;
>  http://www.oracle.com/technology/products/berkeley-db/xml/index.html
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/ubuntu/+bug/157165/+subscribe
>

[Daniël de Kok (danieldk)]

Gregory, thanks for the information!

[Daniël de Kok (danieldk)]

I have also submitted dbxml to Debian-mentors, based on Lars' and my previous work:

http://mentors.debian.net/cgi-bin/sponsor-pkglist?action=details;package=dbxml