On Dec 2, 9:13 pm, 43gm <[EMAIL PROTECTED]> wrote: > Q1: what are differences between using a database like PostgresQL in > one's machine image, versus, using SimpleDB in the cloud?
A local Postgres database will give you a LOT more functionality (and also better latency and bandwidth for small-to-medium size datasets), and guarantees data order/consistency. SimpleDB on the other hand has less features/more limitations, but scales very well (speed does not vary with size or number of db clients and has no single point of failure). SimpleDB is actually much closer to a sofisticated giant python dict than a RDBMS. Long story short, if you NEED 100% uptime and/or you NEED databases spanning hundreds of gigabytes, SimpleDB is a good solution, in all other cases, you're probably better off using postgres. > Q2: will web2py v1.50 work on Amazon with PostgresQL as database > within the virtual machine? Yes, no problems there. > Q3: what are some tips for backing up the data (to a non-Amazon > machine ;-) The first line of backup would probably be pushing everything to S3. Backing up SimpleDB is not complicated (you could use csv functions from web2py for that), although it can cost quite a bit if you don't think about a diff mechanism that only backs up parts of the database which have been changed. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
