Thursday, August 05, 2010


Today someone at work strongly suggested that SQL interfaces to a database are hard to keep and we should only use XML interfaces... (It doesn't even make any sense!)

SQL is a language for querying (as the name implies) information and XML is defined for structuring information. SQL interfaces are the norm for RDBMS. All other interfaces always (as far as I can tell) use the SQL interface to query and retrieve data from the database. Using XML would simple add another layer of complexity, another layer of latency, another nail in the performance's coffin.

Reminded me of when Dilbert asked the Pointy Hair Boss what colour the proposed database should be. Or the story of a "software architect" insisting that using Corba would be faster than TCP for data transfer... us from such knowledge people,

No comments: