Re: Irony

[Jerry Stuckle <jstuckle@attglobal.net>]

On 8/14/2014 6:45 PM, Rusi Mody wrote:
> On Friday, August 15, 2014 1:50:02 AM UTC+5:30, Paul E Condon wrote:
> 
>> Comments (opinion) supporting your position that SQL logging is silly.
> 
>> It is my understanding that SQL is a query language that is designed
>> to query (and update) a *relational*database* that has been designed
>> according to design rules for which there is a vast how-to
>> literature. Usually the goal is a database about a business firm and
>> its customers, suppliers, employees, and stock holders. 
> 
>> For SQL logging to be useful, it seems to me, there should be a
>> properly designed *relational*database* of the internal state of a
>> computer and its relationship to its users, and to the resources under
>> its control.
> 
>> Are there such designs? Something that a sysadmin can buy, and/or
>> download, from a reliable source and install and get working with
>> minimal effort? Something that he can just do without management
>> thinking he is exceeding his job authority? I think not.
> 
>> Therefore I conclude that SQL logging will not be used except in very
>> large, very stable organizations, and should not matter in the context
>> of Debian and its future. If it does happen in Debian, it will be just
>> another downloadable .deb package, not a major shift in the nature of
>> the Debian community or its relations with the rest of human society.
> 
>> Who knows of an Entity-Relationship diagram for a POSIX system wherein
>> the updates of data meet the 'ACID' criteria? What will happen if a
>> logged transaction violates an integrity constraint that is required
>> by the data model? 
> 
> 
> How about we backup one step up the etymological path?
> 
> And replace 'relational' by 'structured' [The original name was Structured Query Language -- shortened to SQL]
> 
> Are you saying logging data is not structured?
> 
> I believe this is not a rhetorical question: it seems to me logs are
> somewhat at the borderline of needing the heavy-duty structuring
> associated with SQL.
> 
> ACID (like postgres) is a red-herring.  Indicated by the existence of
> database systems like sqlite -- library/API based, natural mode of
> running is single threaded
> 
> 

It is the LANGUAGE that is STRUCTURED - not the data.  SQL was created
to deal with relational data, not structured data.

Jerry