[clug] Python & databases
Alex Satrapa
grail at goldweb.com.au
Mon Feb 22 15:20:28 MST 2010
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
More information about the linux
mailing list