[Asterisk-Dev] Re: PostgreSQL support in Asterisk 1.2?

Andrew Kohlsmith akohlsmith-asterisk at benshaw.com
Wed Aug 10 10:02:58 MST 2005


On Wednesday 10 August 2005 12:21, Tilghman Lesher wrote:
> In that case, SQLite cannot be considered to be a DB under your
> definition, either.  From the documentation [0]:
>
> "...SQLite support[s] the concept of "type affinity" on columns. The
> type affinity of a column is the recommended type for data stored in
> that column. The key here is that the type is recommended, not required.
> Any column can still store any type of data..."
>
> So much for data consistency checking.

Yeah really, I did not realize that...  Is MySQL so forward about the artistic 
license it takes with my constraints?  Further, I am pretty damn sure that 
SQLite isn't trying to come across as ACID-compliant.

And while I realize I'm stretching for reasons to like SQLite now I do want to 
make note that most systems that would implement SQLite are using it strictly 
for a lite SQL layer in which to work -- especially since SQLite has no 
network layer at this time.  Having the 'C' in ACID isn't nearly as important 
if you're the only app capable of accessing the DB (crazily contrived 
examples of file locking and such preemptively excluded).

-A.



More information about the asterisk-dev mailing list