Hi How can I send sql commands (querying about sip registrations) to sqlite in mod_managed? I know I can use "sofia status profile internal" using api interface but when there are many registrations and I just wanna check some of them this is not efficient
Depending on your system, you can use either the Mono.Data.SqliteClient or get the System.Data.SQLite library from http://sqlite.phxsoftware.com/. The former for linux, the latter for windows. The sanity of this request is not something I'm familiar with, but that should enable you to take matters into your own hands, for good or ill =cP -Tod Hansmann On 5/12/2010 11:58 PM, babak yakhchali wrote:
Hi How can I send sql commands (querying about sip registrations) to sqlite in mod_managed? I know I can use "sofia status profile internal" using api interface but when there are many registrations and I just wanna check some of them this is not efficient
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I use the same method to access registrations, (albeit in a MySQL DB through ODBC) It works fine. The problem I worry about - is scalability - as I have it today in my prototype - I am building and tearing down an ODBC connection on every query. This is not desirable, so I have to pool the connection in some way. When that is done, I can not see a reason not to do it this way? On Thu, May 13, 2010 at 3:51 AM, babak yakhchali <babak.freeswitch@gmail.com
wrote:
u mean this is not a good idea to get registrations from sqlite?? _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I will go so far to say that we should not even tell people the embedded db is sqlite and we should explicitly change its format so its not accessible. If you want to share your db with anything, even other things in process in freeswitch, you should be using another database via odbc. Mike On May 13, 2010, at 3:51 AM, babak yakhchali wrote:
u mean this is not a good idea to get registrations from sqlite?? _______________________________________________
participants (4)
-
babak yakhchali
-
Michael Jerris
-
Phillip Jones
-
Tod Hansmann