Hello All, I am in the process of choosing my application stack and designing an application. In the application I want to be able to store many transactions - in fact, I want it to be able to scale beyond the 32 bit limit. I am planning a _very_ big state machine - I don't want it to choke at a 32 bit limit.
It is looking like postgresql will be my database, with sqlalchemy and possibly elixir layered on top. Elixir seems to abstract away so many underlying details - it looks very attractive. Unfortunately I am a python newbie and am still learning the ropes, but of course want to do everything right from the start. My question - if I want my tables to be able to hold more than 2^32 entries is the primary key (id) then a bigint? What are the underlying limits? If I want an auto-incrementing serial number (which I want to keep forever as a transaction id) that can grow beyond 2^32 can elixir be told to do that and use the underlying bigserial postgresql serial type? What about when I grab the serial number and use it in python, is it then a python int or is it a python long? I am using a 32 bit linux distro at the moment (ubuntu 8.10) - does this change my int size in python? If I go to 64 bit linux will my ints then be 64 bit - or should I use a long? Efficiency is not an issue (yet), but portability is, as I would like to be able to have the app run on 32 bit platforms initially but be able to move to 64 bit later. I know these are all not strictly Elixir questions but I am stuck considering how to move forward with this and thank you for any help. Regards, Brett Owen Rees. -- You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en.
