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

Hi.

I was studying about how to use databases in Asterisk, accessing it from the
dial plan.
In my project, my dial plan will have to store simple data (ex: IP number, port
number, device name, etc) in a persistent way, so that it will be possible to
retrieve such information in future moments, still via dial plan.

For this case, I would like to know?

1. What is the best choice for storing and retrieving simple data , with dial
plan instructions: SQLite or the builtin database option? Consider that I'm
worried about installation, configuration and use difficulties.

2. Does Asterisk 13 come with SQLite ready for use or have I to install this
database separately and configure it to be accessible in dial plan?

3. Where can I find tutorials about using SQLite or the builtin database for
storing simple that?

P.S.: I'm not interested in storing CDR data.

Any hint will be very helpful!

Thanks a lot!


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979    (Brasil)

Propose U to use Mysql

2015-07-07 17:26 GMT+03:00 Rodrigo Pimenta Carvalho <pimenta at
inatel.br>:
>
>
> Hi.
>
> I was studying about how to use databases in Asterisk, accessing it from
> the dial plan.
> In my project, my dial plan will have to store simple data (ex: IP number,
> port number, device name, etc) in a persistent way, so that it will be
> possible to retrieve such information in future moments, still via dial
> plan.
>
> For this case, I would like to know?
>
> 1. What is the best choice for storing and retrieving simple data , with
> dial plan instructions: SQLite or the builtin database option? Consider
> that I'm worried about installation, configuration and use
difficulties.
>
> 2. Does Asterisk 13 come with SQLite ready for use or have I to install
> this database separately and configure it to be accessible in dial plan?
>
> 3. Where can I find tutorials about using SQLite or the builtin database
> for storing simple that?
>
> P.S.: I'm not interested in storing CDR data.
>
> Any hint will be very helpful!
>
> Thanks a lot!
>
>
> RODRIGO PIMENTA CARVALHO
> Inatel Competence Center
> Software
> Ph: +55 35 3471 9200 RAMAL 979    (Brasil)
> --
> _____________________________________________________________________
> -- 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
>


-- 
Best regards
Antony
??? (066) 919-75-33
??? (063) 656-43-40
satskiy.a at gmail.com <mail%3Asatskiy.a at gmail.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20150707/4cee1344/attachment.html>

I believe that Asterisk 1.8 and older uses the BerkeleyDB for Asterisk's
internal database (AKA the Astdb) and in newer versions use SQLite. However,
the basic functionality is the same. Whether you use the Astdb or MySQL
really depends on what you want to do with it. The AstDB is not a relational
database like MySQL, it simply a key/value store. If you can get away with
that, and you need simplicity, then the AstDB is the way to go. If you need
MySQL you'll probably end up having to write AGI scripts to access it. Like
I said, it all depends on what your needs are.
Regards;
John 

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Rodrigo
Pimenta Carvalho
Sent: Tuesday, July 07, 2015 10:26 AM
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] What database should I use, for simple data
storing? SQLite or the buitin one?



Hi.

I was studying about how to use databases in Asterisk, accessing it from the
dial plan. 
In my project, my dial plan will have to store simple data (ex: IP number,
port number, device name, etc) in a persistent way, so that it will be
possible to retrieve such information in future moments, still via dial
plan. 

For this case, I would like to know?

1. What is the best choice for storing and retrieving simple data , with
dial plan instructions: SQLite or the builtin database option? Consider that
I'm worried about installation, configuration and use difficulties.

2. Does Asterisk 13 come with SQLite ready for use or have I to install this
database separately and configure it to be accessible in dial plan?

3. Where can I find tutorials about using SQLite or the builtin database for
storing simple that?

P.S.: I'm not interested in storing CDR data.

Any hint will be very helpful!

Thanks a lot!


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979    (Brasil)
--
_____________________________________________________________________
-- 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

Hi John.

Thank you very much for you reply. It is exactly what I was needing to know. 
Now I will study about the use of SQLite + Asterisk, because MySQL will not be
necessary in my solution. A relational database will not be necessary.
I 'm needing simplicity.

Do you know where can I find a tutorial about accessing and using the asterisk
builtin database, considering Asterisk 13 or later?

Any hint will be very helpful.

Thanks


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 Tech Support [asterisk at voipbusiness.us]
Enviado: ter?a-feira, 7 de julho de 2015 11:58
Para: 'Asterisk Users Mailing List - Non-Commercial Discussion'
Assunto: Re: [asterisk-users] What database should I use,       for simple data
storing? SQLite or the buitin one?

    I believe that Asterisk 1.8 and older uses the BerkeleyDB for Asterisk's
internal database (AKA the Astdb) and in newer versions use SQLite. However,
the basic functionality is the same. Whether you use the Astdb or MySQL
really depends on what you want to do with it. The AstDB is not a relational
database like MySQL, it simply a key/value store. If you can get away with
that, and you need simplicity, then the AstDB is the way to go. If you need
MySQL you'll probably end up having to write AGI scripts to access it. Like
I said, it all depends on what your needs are.
Regards;
John

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Rodrigo
Pimenta Carvalho
Sent: Tuesday, July 07, 2015 10:26 AM
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] What database should I use, for simple data
storing? SQLite or the buitin one?



Hi.

I was studying about how to use databases in Asterisk, accessing it from the
dial plan.
In my project, my dial plan will have to store simple data (ex: IP number,
port number, device name, etc) in a persistent way, so that it will be
possible to retrieve such information in future moments, still via dial
plan.

For this case, I would like to know?

1. What is the best choice for storing and retrieving simple data , with
dial plan instructions: SQLite or the builtin database option? Consider that
I'm worried about installation, configuration and use difficulties.

2. Does Asterisk 13 come with SQLite ready for use or have I to install this
database separately and configure it to be accessible in dial plan?

3. Where can I find tutorials about using SQLite or the builtin database for
storing simple that?

P.S.: I'm not interested in storing CDR data.

Any hint will be very helpful!

Thanks a lot!


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979    (Brasil)
--
_____________________________________________________________________
-- 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


--
_____________________________________________________________________
-- 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

Hi Antony.

Thank you for your replay. I have decided to use the builtin database, according
to others help that I have kindly received in this discussion list. What I need
is a simple solution, not a relational database one.

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 ????? ?????? [satskiy.a at gmail.com]
Enviado: ter?a-feira, 7 de julho de 2015 11:32
Para: Asterisk Users Mailing List - Non-Commercial Discussion
Assunto: Re: [asterisk-users] What database should I use, for simple data
storing? SQLite or the buitin one?

Propose U to use Mysql

2015-07-07 17:26 GMT+03:00 Rodrigo Pimenta Carvalho <pimenta at
inatel.br<mailto:pimenta at inatel.br>>:


Hi.

I was studying about how to use databases in Asterisk, accessing it from the
dial plan.
In my project, my dial plan will have to store simple data (ex: IP number, port
number, device name, etc) in a persistent way, so that it will be possible to
retrieve such information in future moments, still via dial plan.

For this case, I would like to know?

1. What is the best choice for storing and retrieving simple data , with dial
plan instructions: SQLite or the builtin database option? Consider that I'm
worried about installation, configuration and use difficulties.

2. Does Asterisk 13 come with SQLite ready for use or have I to install this
database separately and configure it to be accessible in dial plan?

3. Where can I find tutorials about using SQLite or the builtin database for
storing simple that?

P.S.: I'm not interested in storing CDR data.

Any hint will be very helpful!

Thanks a lot!


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200<tel:%2B55%2035%203471%209200> RAMAL 979    (Brasil)
--
_____________________________________________________________________
-- 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



--
Best regards
Antony
??? (066) 919-75-33
??? (063) 656-43-40
satskiy.a at gmail.com<mailto:mail%3Asatskiy.a at gmail.com>