Re: [asterisk-users] Redis in place of astdb
El Thu, 9 Jul 2020 10:37:52 +0200 Antony Stone escribió: > On Thursday 09 July 2020 at 00:50:28, Jon Bonilla (Manwe) wrote: > > > DO you know odbc redis drivers? It would be nice to store cdrs ans other > > stuff in redis without patching asterisk > > A quick Google search turns up > https://www.cdata.com/kb/tech/redis-odbc-python-linux.rst > which I have no experience of and cannot comment on, but looks like what you > need. > > PS: I question the wisdom of storing CDRs in Redis - I think an RDBMS is the > correct tool for *that* job. I agree that Redis may be useful in other > areas, though. > You're right but I need to do some post-processing to the cdr and store the final one in mysql. -- PekePBX, the multitenant PBX solution https://pekepbx.com -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Redis in place of astdb
I’ll second that - for CDR you want the fastest sequential writing with possible batching of CDR records Best regards, Alex www.thirdlane.com > On Jul 9, 2020, at 1:37 AM, Antony Stone > wrote: > > On Thursday 09 July 2020 at 00:50:28, Jon Bonilla (Manwe) wrote: > >> DO you know odbc redis drivers? It would be nice to store cdrs ans other >> stuff in redis without patching asterisk > > A quick Google search turns up > https://www.cdata.com/kb/tech/redis-odbc-python-linux.rst > which I have no experience of and cannot comment on, but looks like what you > need. > > PS: I question the wisdom of storing CDRs in Redis - I think an RDBMS is the > correct tool for *that* job. I agree that Redis may be useful in other > areas, > though. > > > Antony. > > -- > All matter in the Universe can be placed into one of two categories: > > 1. Things which need to be fixed. > 2. Things which need to be fixed once you've had a few minutes to play with > them. > > Please reply to the list; > please *don't* CC me. > > -- > _ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Check out the new Asterisk community forum at: https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > 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 -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Redis in place of astdb
On Thursday 09 July 2020 at 00:50:28, Jon Bonilla (Manwe) wrote: > DO you know odbc redis drivers? It would be nice to store cdrs ans other > stuff in redis without patching asterisk A quick Google search turns up https://www.cdata.com/kb/tech/redis-odbc-python-linux.rst which I have no experience of and cannot comment on, but looks like what you need. PS: I question the wisdom of storing CDRs in Redis - I think an RDBMS is the correct tool for *that* job. I agree that Redis may be useful in other areas, though. Antony. -- All matter in the Universe can be placed into one of two categories: 1. Things which need to be fixed. 2. Things which need to be fixed once you've had a few minutes to play with them. Please reply to the list; please *don't* CC me. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users