Problem is I want to leave some logic also in db (triggers etc) and then i come to trouble if i need to do some calculations in db. STR + STR in db is not the right way to be done in SQL. I can handle these str<->decimal conversions in any program, but i also need fully functional database and it is not possible this way. This should be some finacial stuff and i really don't want to do it like having prices in cents or so. If this decimal trouble becomes a problem, i'll get cherrypy myself again and start over from scratch, but i'd really like to stay with web2py ..:)
Michal mdipierro wrote: > That is not what I said. I said that it is not possible to implement > decimal in a way that behaves the same way with database backend > systems that support decimal nativly and those that do not. > > My suggestion is, for now, use 'string' but convert the values to > decimal.Decimal() before using them in computations. This will give > you the precision you want. > > Massimo > > On May 27, 7:56 am, Michal Jursa <mic...@jursa.cz> wrote: >> I know about trunk solution, but you've recently said you dont like to >> implement decimals at all. Or may be I miunderstood you..:) >> >> You think it is fine to start with trunk version and one day it will >> become stable? Coz thats the only thing that really holds me back from >> using web2py in 'real' world..:) >> >> Michal >> >> mdipierro wrote: >>> In trunk this is already implemented >>> http://groups.google.com/group/web2py/browse_thread/thread/13d9e9fd73... >>> But it is experimental. >>> If you really want a date for a stable Decimal API in DAL, I can Say >>> July 31 but it may be done sooner. >>> Masssimo >>> On May 27, 6:53 am, Michal Jursa <mic...@jursa.cz> wrote: >>>> Hi, >>>> I know there were a lot of posts about pros and cons of implementing >>>> DECIMAL type to DAL, but there is no result. As DECIMALs are really >>>> important for me, I'd like to know if it will be included in DAL and if >>>> yes, when ( i don't need exact date :) ). I can patch DAL to do it for >>>> me on postgres now, but that's not solution for future and to say true, >>>> I'm not happy with those solutions converting strings to decimals and >>>> back etc. I think DECIMAL is standard type today and missing support in >>>> sqlite should not be reason to stop implement it in DAL. If web2py aims >>>> to be a real tool, then decimals are necessary. Noone makes real >>>> projects on sqlite. >>>> If I decide to stay with web2py, then I'd like to make this decision for >>>> a bit longer term so I really need some info, coz i need to start >>>> project :) >>>> Michal >> > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
