Re: [SQLObject] Decimals in sqlite

[Oleg B. <ph...@ph...>]

On Fri, Feb 08, 2008 at 11:06:40AM -0600, Christopher Singley wrote:
> On Friday 08 February 2008 02:53:45 Oleg Broytmann wrote:
> >    If you find a problem - please publish more details. In case of PySQLite
> > there is a way to map data to/from strings for any data; currently
> > SQLObject uses this feature to map strings to/from unicode, and map
> > date/time strings; it would be possible to add a mapping for Decimals.
> 
> That sounds like a better way!  Strings should be a fine way to store 
> fixed-point numbers of finite length.  Are there any considerations that 
> might make this a bad idea?

   If you are going to use (or allow to use) the DB in external non-python
tools you have to document the mapping, and even the documents could not
help in case of standard tools that don't know anything about the mapping.
The mapping is a function of PySQLite2, not SQLite itself:
http://initd.org/pub/software/pysqlite/doc/usage-guide.html#sqlite-and-python-types

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.