[asterisk-bugs] [Asterisk 0012788]: Make all SQLite-related modules use Sqlite3

[noreply at bugs.digium.com]

The following issue has been SUBMITTED. 
====================================================================== 
http://bugs.digium.com/view.php?id=12788 
====================================================================== 
Reported By:                ssokol
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   12788
Category:                   General
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     new
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             06-04-2008 17:03 CDT
Last Modified:              06-04-2008 17:03 CDT
====================================================================== 
Summary:                    Make all SQLite-related modules use Sqlite3
Description: 
For general consideration: if Asterisk is going to include SQLite support,
shouldn't all the modules use the same version of SQLite?  We currently
have:

cdr_sqlite.c = SQLite v.2
cdr_sqlite3_custom.c = SQLite v.3
res_config_sqlite.c = SQLite v.2

A brief googling of sqlite seems to indicate that SQLite3 is much better
behaved than SQLite2 -- better locking mechanism, better handling of
multi-threaded environments, etc.

Would it be permissible to create a "res_sqlite.c" that provides:

CDR
Realtime configuration driver
func_odbc-style queries (read and write)

Perhaps even more esoteric stuff like voicemail storage, AstDB
replacement, queue log storage, and access via CLI and manager commands?


====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
06-04-08 17:03  ssokol         Asterisk Version          => SVN             
06-04-08 17:03  ssokol         SVN Branch (only for SVN checkou =>  trunk       
  
======================================================================