VoIP Mailing List Archives

[pimenta at inatel.br]

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@lists.digium.com [asterisk-users-bounces@lists.digium.com] em Nome de Tech Support [asterisk@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@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Rodrigo
Pimenta Carvalho
Sent: Tuesday, July 07, 2015 10:26 AM
To: asterisk-users@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

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

[pimenta at inatel.br]

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@lists.digium.com [asterisk-users-bounces@lists.digium.com] em Nome de �нтон Сацкий [satskiy.a@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@inatel.br<mailto:pimenta@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@gmail.com<mailto:mail%3Asatskiy.a@gmail.com>
--
_____________________________________________________________________
-- 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