Is there any function to help manage XML storage in EDB? I'm pondering
the best way forward for managing data, and am thinking that structured
files might be the best way, so XML or JSON, but also need some quick
lookups, so EDB tables with key data like identifiers to find the
files. Is there any assistance in EDB for this sort of thing, where I'd
stuff the XML and I could then get all rows where the XML contains a
<widget> with a "blue" attribute?

--

Matthew Jones

Matthew


You could use full text search - you'd need to write your own Word Generator & Text Filter but that's easy enough. That at least means you only have to extract and check properly those that contain the right stuff even if they're not together.

If its only simple stuff and you can get away with <attribute>data</attribute> then it becomes easy - set that unit as the word

Roy Lambert

Roy Lambert wrote:

> You could use full text search - you'd need to write your own Word
> Generator & Text Filter but that's easy enough. That at least means
> you only have to extract and check properly those that contain the
> right stuff even if they're not together.
>
> If its only simple stuff and you can get away with
> <attribute>data</attribute> then it becomes easy - set that unit as
> the word

Thanks - that found me
http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_genera
l&msg=19&page=96 which shows it is quite easy, and flexible.

I could for example convert the words into "attribute=value" key pairs,
which would make them findable quite easily. Hmm, lots more pondering
to do on this architecture.

--

Matthew Jones

Matthew


even better - some kind soul posted their word generator and text filter to the extensions ng so you can just modify it

Roy Lambert