Database experiences in Python: Good or Bad?

[Eric Brunel]

Roy Smith wrote:
[snip]
> Operationally, the only real
> annoyance I found was that (IIRC), empty strings in the database would
> come back as None instead of as "" (I consider this a bug).

It is. In Oracle... Oracle considers empty strings as NULL values, which is 
simply stupid. When you do a select, there's no means to distinguish an 
empty string from a NULL (represented as None in Python). So the oracledb 
module is just consistent with the way Oracle manages strings...
-- 
- Eric Brunel <eric.brunel at pragmadev.com> -
PragmaDev : Real Time Software Development Tools - http://www.pragmadev.com