asterisk users - Jul 2015 - Fwd: What database should I use, for simple data storing? SQLite or the buitin one?

To some extent the answer depends on how you want to use it overall, and 
what you already have installed.


We did something similar on a project where we created a simple app 
accessible via AGI, and it stored/retrieved data to/from anXML file.  If 
your access frequency is low enough that might be a good solution.  On 
the other hand if you need complex query capability you should stay on 
the SQL side.


  If you already have MySQL installed for other Asterisk features (eg: 
CDR, or if you use FreePBX) then you might as well use that.

?

Hi.

Thank you for your instruction!
What I need is simplicity. That is, a simple solution (no relational data base)
will fit very well now. In this case I will start investigating about how to use
the Asterisk (version 13 or later) builtin database.

Is it SQLite?
How to access it via dial plan, etc?
What must I configure in my asterisk?
What must i install to use the builtin database?
Where to find a tutorial with explanations about such questions?

Best regards.

 


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979    (Brasil)
________________________________________
De: asterisk-users-bounces at lists.digium.com [asterisk-users-bounces at
lists.digium.com] em Nome de Technical Support [support at telium.ca]
Enviado: ter?a-feira, 7 de julho de 2015 11:51
Para: asterisk-users at lists.digium.com
Assunto: Re: [asterisk-users] Fwd:  What database should I use, for simple data
storing? SQLite or the buitin one?

To some extent the answer depends on how you want to use it overall, and
what you already have installed.


We did something similar on a project where we created a simple app
accessible via AGI, and it stored/retrieved data to/from anXML file.  If
your access frequency is low enough that might be a good solution.  On
the other hand if you need complex query capability you should stay on
the SQL side.


  If you already have MySQL installed for other Asterisk features (eg:
CDR, or if you use FreePBX) then you might as well use that.

?


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users