Re: [asterisk-users] AstDB with Sqlite
The Dialplan DB commands still work using the old Berkley conventions. If you want to use the sqlite for functions other than AstDB, then you have to resort to SQL SELECTs and INSERTs. If you need that kind of functionality, you will probably save yourself some headaches by just using MYSQL. From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Mark Robinson Sent: Wednesday, January 09, 2013 8:37 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] AstDB with Sqlite Are you sure that it is correct for sqlite? For what i know it should contain select or inser operator in dialplan. Correct if i am wrong. On Oct 19, 2012 9:18 AM, "Danny Nicholas" wrote: Just use the standard dialplan db commands - Read Set(TESTOP=${DB(Nightop/ext)}) write Set(DB(Nightop/ext)=107). It's not as robust as Mysql or postgres but does seem to do better than the old Berkley database. From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Mark Robinson Sent: Thursday, October 18, 2012 10:08 PM To: asterisk-users@lists.digium.com Subject: [asterisk-users] AstDB with Sqlite As you may know, asterisk version 10 and high use sqlite. Are any examples or documentation how to use in dialplan? -- _ -- 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
Re: [asterisk-users] AstDB with Sqlite
Are you sure that it is correct for sqlite? For what i know it should contain select or inser operator in dialplan. Correct if i am wrong. On Oct 19, 2012 9:18 AM, "Danny Nicholas" wrote: > Just use the standard dialplan db commands – Read > Set(TESTOP=${DB(Nightop/ext)}) write Set(DB(Nightop/ext)=107). It’s not as > robust as Mysql or postgres but does seem to do better than the old Berkley > database. > > ** ** > > *From:* asterisk-users-boun...@lists.digium.com [mailto: > asterisk-users-boun...@lists.digium.com] *On Behalf Of *Mark Robinson > *Sent:* Thursday, October 18, 2012 10:08 PM > *To:* asterisk-users@lists.digium.com > *Subject:* [asterisk-users] AstDB with Sqlite > > ** ** > > As you may know, asterisk version 10 and high use sqlite. Are any examples > or documentation how to use in dialplan? > > -- > _ > -- 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
Re: [asterisk-users] AstDB with Sqlite
Just use the standard dialplan db commands - Read Set(TESTOP=${DB(Nightop/ext)}) write Set(DB(Nightop/ext)=107). It's not as robust as Mysql or postgres but does seem to do better than the old Berkley database. From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Mark Robinson Sent: Thursday, October 18, 2012 10:08 PM To: asterisk-users@lists.digium.com Subject: [asterisk-users] AstDB with Sqlite As you may know, asterisk version 10 and high use sqlite. Are any examples or documentation how to use in dialplan? -- _ -- 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
[asterisk-users] AstDB with Sqlite
As you may know, asterisk version 10 and high use sqlite. Are any examples or documentation how to use in dialplan? -- _ -- 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