Re: DBI accessing SQLite with XML data

[Jim]

You may be using the wrong database software.

Appropriate Uses For SQLite
Simplicity in a database engine can be either a strength or a weakness, depending on what you are trying to do. In order to achieve simplicity, SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth. If you need some of these features and do not mind the added complexity that they bring, then SQLite is probably not the database for you. SQLite is not intended to be an enterprise database engine. It is not designed to compete with Oracle or PostgreSQL.

Consider using Oracle Berkeley DB XML instead of SQLite. "Oracle Berkeley DB XML is an XML database with support for XQuery designed to store and index XML content for fast, scalable and predictable access."

Jim

[vagabonding electron]

BaseX could be another one: http://basex.org/.
Perl API: https://github.com/BaseXdb/basex-api/tree/master/src/main/perl.