[asterisk-users] Function to query ASTDB families

[Tilghman Lesher]

On Sunday 13 September 2009 04:52:11 Olivier wrote:
> 2009/9/10 Tilghman Lesher <tlesher at digium.com>
>
> > On Tuesday 08 September 2009 16:33:20 Olivier wrote:
> > > Asterisk database is made of <family><key> records such as:
> > > fam  key1  val1
> > > fam  key2  val2
> > > ...
> > > fam  key100  val100
> > >
> > > I'm looking for the smartest way to iterate among different keys
> >
> > associated
> >
> > > to a given family.
> > >
> > > One way to do this is to parse "database show fam" response.
> > > Is there something smarter ?
> > > Something like ${DBKEYS(fam)} which would evaluate to "key1 key2  ...
> > > key100".
> >
> > I think the smarter way, once you've gotten to this level of complexity,
> > is to
> > start using a real external database, such as Postgres, configure the
> > ODBC driver, and use func_odbc to interface to it.
>
> I'm afraid you might be right ...
> But being used to read and write so easily in database, is an addiction
> which is hard to leave ...

Then you should be very happy with func_odbc, because the ease of use is
similar, though the ability to customize how the information is queried is
also very powerful.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org