Replace sqlite with couchDB?
Hi, I am not very familiar with FS internals, but I recently found this "new" db engine called couchDB. Looks pretty interesting, and its main focus is scalability. Has anybody played with couchDB? does it make sense to replace sqlite with couchDB in FS? Here's a link to the project homepage: - http://couchdb.apache.org/ And here's a video of a presentation given by one of the lead programmers: - http://www.vimeo.com/1992869
Hi Nicolas, Just off the top of my head, but I think couchDB is rather large compared to sqlite, and I think it's also geared more towards storing dynamic datasets...rather ones that can be structured...like FS calling data can. But I might be wrong :) your buddy. --matt On Mon, Apr 13, 2009 at 12:00 PM, Nicolas Brenner <nicolas@medularis.com>wrote:
Hi, I am not very familiar with FS internals, but I recently found this "new" db engine called couchDB. Looks pretty interesting, and its main focus is scalability. Has anybody played with couchDB? does it make sense to replace sqlite with couchDB in FS?
Here's a link to the project homepage: - http://couchdb.apache.org/
And here's a video of a presentation given by one of the lead programmers: - http://www.vimeo.com/1992869
_______________________________________________ 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
Well, if it's too large compared to sqlite maybe it doesn't make sense. But I was thinking calling data is not always fixed. Depending on what you use FS for, you might want to get a CDR with many different data linked to each call, even different kinds of data linked to different calls, that would make each call very different and variable in its structure, which would fit a document db model. Thinking a bit more now, since couchdb is a document-based DB, it might be good for configuration-generating applications, like the ones consumed by xml_curl. These are external applications, yet they are still very closely related to FS, and might be able to benefit from using something like couchdb. On Mon, Apr 13, 2009 at 1:06 AM, Matthew Fong <mattdfong@gmail.com> wrote:
Hi Nicolas, Just off the top of my head, but I think couchDB is rather large compared to sqlite, and I think it's also geared more towards storing dynamic datasets...rather ones that can be structured...like FS calling data can.
But I might be wrong :) your buddy.
--matt
On Mon, Apr 13, 2009 at 12:00 PM, Nicolas Brenner <nicolas@medularis.com>wrote:
Hi, I am not very familiar with FS internals, but I recently found this "new" db engine called couchDB. Looks pretty interesting, and its main focus is scalability. Has anybody played with couchDB? does it make sense to replace sqlite with couchDB in FS?
Here's a link to the project homepage: - http://couchdb.apache.org/
And here's a video of a presentation given by one of the lead programmers: - http://www.vimeo.com/1992869
_______________________________________________ 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
_______________________________________________ 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
Nicolas Brenner <nicolas@medularis.com> wrote:
Hi, I am not very familiar with FS internals, but I recently found this "new" db engine called couchDB. Looks pretty interesting, and its main focus is scalability. Has anybody played with couchDB? does it make sense to replace sqlite with couchDB in FS?
I think a lot of people would object to replacing a small database such as SQLite, which is easily integrated into the FreeSWITCh source code, with an Erlang application. Somehow, I don't see FreeSWITCH users accepting all of the dependencies that would bring, unless they're already using the Erlang module for other reasons. However, if it would be of benefit to Erlang users, I'm sure the FreeSWITCH developers would gladly accept a module. There are lots of databases out there, for example, http://monetdb.cwi.nl/ to mention just one that a Web search located for me. Which ones get supported depends on whether anyone is sufficiently interested to write modules for them. PostGRESQL and MySQL are already on the list, notably.
The only part I see fit for integration with CouchDB is for storing CDR documents. This kind of database is imho best-used for storing large sets of data, in a document structure. I don't think the FS config fits this description, since the amount of config documents are typically not "large". You can also look at related distributed systems like Hadoop/Hbase, which could be good to store CDRs in. It's been a couple of months since I researched these systems, but I think it's possible to enable an HTTP REST interface for both, so you could use the built-in feature for posting CDRs to a HTTP server. Best regards, Even André On 13. april. 2009, at 07.52, Jason White wrote:
Nicolas Brenner <nicolas@medularis.com> wrote:
Hi, I am not very familiar with FS internals, but I recently found this "new" db engine called couchDB. Looks pretty interesting, and its main focus is scalability. Has anybody played with couchDB? does it make sense to replace sqlite with couchDB in FS?
I think a lot of people would object to replacing a small database such as SQLite, which is easily integrated into the FreeSWITCh source code, with an Erlang application. Somehow, I don't see FreeSWITCH users accepting all of the dependencies that would bring, unless they're already using the Erlang module for other reasons. However, if it would be of benefit to Erlang users, I'm sure the FreeSWITCH developers would gladly accept a module.
There are lots of databases out there, for example, http://monetdb.cwi.nl/ to mention just one that a Web search located for me.
Which ones get supported depends on whether anyone is sufficiently interested to write modules for them.
PostGRESQL and MySQL are already on the list, notably.
_______________________________________________ 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
participants (4)
-
Even André Fiskvik
-
Jason White
-
Matthew Fong
-
Nicolas Brenner