Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: DBI accessing SQLite with XML data

by Anonymous Monk
on Dec 31, 2012 at 08:55 UTC ( #1011024=note: print w/ replies, xml ) Need Help??


in reply to DBI accessing SQLite with XML data

How could I achieve this? What modules would I need?

?? You can't :) end of story

?? If you have to ask, you probably can't achieve it :) otherwise you wouldn't need to ask

?? Oracle Berkeley DB XML ??

?? XML::Twig, XML::Rules, XML::LibXML, SQL::Statement, SQL::Translator, DBD::SQLite


Comment on Re: DBI accessing SQLite with XML data
Re^2: DBI accessing SQLite with XML data
by Anonymous Monk on Dec 31, 2012 at 10:34 UTC
    Actually I found a way using regular expressions. You have to create a custom regexp function and then use it to parse the XML (courtesy of http://www.justatheory.com/computers/databases/sqlite/).

    Not exactly what I was looking for and surely not very efficient performance-wise, but for now it does the trick.
      Thanks for sharing that link - I believe it WOULD be efficient, and could be extremely powerful, if you embed XML processing into the function.

      Please post working code back, for lazy bums like me to plagiarize.

      Happy 2013!

                   "By three methods we may learn wisdom: First, by reflection, which is noblest; Second, by imitation, which is easiest; and third by experience, which is the bitterest."           -Confucius

        Will do - but you'll need to wait a couple of days as I won't have access to the Internet.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1011024]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (8)
As of 2014-09-17 15:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (90 votes), past polls