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

[noreply at bugs.digium.com]

The following issue has been RESOLVED. 
====================================================================== 
http://bugs.digium.com/view.php?id=12788 
====================================================================== 
Reported By:                ssokol
Assigned To:                russell
====================================================================== 
Project:                    Asterisk
Issue ID:                   12788
Category:                   General
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     resolved
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             06-04-2008 17:03 CDT
Last Modified:              06-04-2008 17:07 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?


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

---------------------------------------------------------------------- 
 russell - 06-04-08 17:07  
---------------------------------------------------------------------- 
If someone writes the code, sure.  However, I don't think we should remove
the sqlite2 versions if we have sqlite3.  People wrote them against sqlite2
because that is what they wanted for their environment.

If you want to talk about this stuff any further, let's do it on the -dev
list.  We try to strongly discourage the use of this site as a discussion
forum. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
06-04-08 17:07  russell        Status                   new => resolved     
06-04-08 17:07  russell        Resolution               open => fixed       
06-04-08 17:07  russell        Assigned To               => russell         
06-04-08 17:07  russell        Note Added: 0087827                          
======================================================================