[clug] Python & databases

[Alex Satrapa]

On 22/02/2010, at 18:18 , Daniel Pittman wrote:

> Sadly, I don't know of any Python equivalent of the Perl SQL::Abstract module,
> which achieves this by providing a Perl-like syntax to writing queries, and a
> set of back-end modules to generate the individual SQL statement from it.

Django Q and F objects.

> [1]  Theoretically you can write engine-independent SQL to the standard, but
>     I have *never* had that be sufficient in practice.  Certainly not if
>     performance is desired.

Even then, MySQL doesn't always do what you want. It's entirely possible to write engine-independent SQL if you don't aim to be compatible with DB engines that aren't SQL compliant, such as MySQL or SQLiteX.

Alex