Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

2009/4/22 Ruslan Zasukhin > On 4/22/09 5:33 PM, "David Bovill" wrote: > > > At the moment we can only search for attributes in XML and loop through > > other hierarchical data structures (ie arrays or XML with our own > recursive > > algorithms) - having a robust SQL like query language to sear

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

Agreed - I've only played with XPath / XSLT - and it does the job - though I think there would be a nicer way to express the queries - either in something we could use with RunRev's hierarchical arrays - or in Valentina. I guess I didn;t really like Xpath and have the feeling it hasn't really gaine

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

I think this might be what you are looking for: http://quality.runrev.com/qacenter/show_bug.cgi?id=2252 Bernard On Wed, Apr 22, 2009 at 3:33 PM, David Bovill wrote: > having a robust SQL like query language to search and retrieve > data in arbitrary XML documents sounds too good to be true - e

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

On 4/22/09 5:33 PM, "David Bovill" wrote: Hi David, >> Actually this is result of efforts as some of Valentina users, which was >> brave enough to DREAM aloud. So our team. Big amount of work in >> implementation of this task did Ivan. > > Ivan - your the man! Indeed :-) >> Have you read art

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

2009/4/22 Ruslan Zasukhin > > Actually this is result of efforts as some of Valentina users, which was > brave enough to DREAM aloud. So our team. Big amount of work in > implementation of this task did Ivan. > Ivan - your the man! Have you read article, docs, examples deeply? > Please do to n

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

On 4/22/09 1:52 PM, "Brian Yennie" wrote: Hi Brian, For people who not aware -- Brian Yennie was man, which have push us to MetaCard, and even better, have help a lots create first Valentina external for MetaCard. :-) > Very interesting and congratulations on this new feature! Thank you. >

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

On 4/22/09 1:41 PM, "David Bovill" wrote: Hi David, > Thanks Lynn / Ruslan - I've been waiting FOREVER for something that properly > handles tree / hierarchical data structures! > > I seriously can't believe (ranting slightly) , that this is such a rare > facility in the world of computer langu

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

Ruslan, Very interesting and congratulations on this new feature! Can you comment on how it compares to Oracle's "START WITH ... CONNECT BY"? That is the only comparable feature I've seen, and of course requires paying a high price for Oracle. Of course now Oracle owns Sun which owns MySQ

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

Thanks Lynn / Ruslan - I've been waiting FOREVER for something that properly handles tree / hierarchical data structures! I seriously can't believe (ranting slightly) , that this is such a rare facility in the world of computer languages and databases. Object-like hierarchical structures are simpl

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

On 4/21/09 6:15 PM, "David Bovill" wrote: Hi David, > Great! Couple of questions: > >1. Do you have a url to point to the syntax for addressing hierarchical >data? Yes. This is ARICLE "Hierarchical (Recursive) Queries in Valentina SQL", where we show

RE: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

> Great! Couple of questions: > >1. Do you have a url to point to the syntax for addressing > hierarchical >data? http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:refe rence:recursive_query_commands http://valentina-db.com/dokuwiki/doku.php?id=valentina:articles:re

Re: Valentina DB 4.1 Introduces Groundbreaking SQL Feature

Great! Couple of questions: 1. Do you have a url to point to the syntax for addressing hierarchical data? 2. Any plans to have Valentina support with On-Rev? 2009/4/21 Lynn Fredricks * Recursive SQL Queries. An advanced feature thought to be the first > implementation in databases: re

Valentina DB 4.1 Introduces Groundbreaking SQL Feature

Valentina DB 4.1 Introduces Groundbreaking SQL Feature Paradigma Software announces the release of Valentina DB 4.1, a general product release including a special, new feature for managing hierarchical data with recursive SQL commands. Valentina DB 4.1 provides both performance improvements and