Re: DBI accessing SQLite with XML data

in reply to DBI accessing SQLite with XML data

I would recommend redesigning your database schema. Parse xml and insert into table.

CREATE TABLE mytable (
    id INTEGER PRIMARY KEY,
    element TEXT,
    items TEXT,
    item TEXT,
    data TEXT,
    UNIQUE(element, items, item, data)
);
[download]

Then you can do the following:

sqlite> SELECT ("element" || "/" || "items" || "/" || "item" || "/" ||
+ "data") AS source where source like '%some string%';
[download]

Comment on Re: DBI accessing SQLite with XML data Select or Download Code

In Section Seekers of Perl Wisdom