Could you help me with python-postgres installation? I installed postgresql, and postgresql-server, they are running, and I can access postgre through phpPgAdmin.
I tried installing psycog2 however I get the following traceback running build running build_py creating build creating build/lib.linux-i686-2.6 creating build/lib.linux-i686-2.6/psycopg2 copying lib/tz.py -> build/lib.linux-i686-2.6/psycopg2 copying lib/extensions.py -> build/lib.linux-i686-2.6/psycopg2 copying lib/pool.py -> build/lib.linux-i686-2.6/psycopg2 copying lib/__init__.py -> build/lib.linux-i686-2.6/psycopg2 copying lib/psycopg1.py -> build/lib.linux-i686-2.6/psycopg2 copying lib/extras.py -> build/lib.linux-i686-2.6/psycopg2 copying lib/errorcodes.py -> build/lib.linux-i686-2.6/psycopg2 running build_ext error: No such file or directory -Thadeus On Fri, Oct 23, 2009 at 1:23 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > This is just my biased opinion: > 1) MySQL was fatser than postgresql when it had no transaction > 2) MySQL has lots of quirks (like max length for text files, no > multiple alter table in one transaction, and others) > 3) MySQL was developed by SUN which was bought by Oracle and it is not > clear what it future is. Some developers have left > 4) I use postgresql so I have tested it better > 5) There are very large postgresql databases I know of (like the .org > domains database), I cannot say the same for mysql (but it may be my > ignorance). > 6) postgresql has autovacuum so you do not need to do much > maintenance. > > On Oct 23, 12:56 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > > Why do you suggest postgresql? I have done alot of research into the two, > > and mysql seems to be the more effeciant of the two. > > > > From what I gather, mysql is created to be lightweight, and super fast. > > Postgresql is created to be feature full and stable. > > > > However, dreamhost does not provide postgresql on their shared hosting, > so > > for now I will have to use mysql. > > > > The site is a web app that tracks fish tanks on gaiaonline.com. > Basically, > > gaia has this mini game called "Booty Grab" (here is more infohttps:// > www.gaiaonlinehelp.com/ics/support/KBAnswer.asp?questionID=17), that > > glows at random times. The only way to find if their glowing, is to go > > through pages and pages of forums... very boring, annoying, and cpu > > intensive with all of the flash on one page.. > > > > Well... My app will contact gaia, ask it for information on a tank, such > as > > when it will be open, and for how long, it stores this data in the > database, > > and displays hyperlinks when pages are available. > > > > http://surrenderthebooty.thadeusb.com/ > > > > Your welcome to sign up if you would like to see the internals. > > > > When attempting to migrate over to mysql, I get an error about key length > > too long, refer to my other post: > http://groups.google.com/group/web2py/browse_thread/thread/27d781db1f... > > > > On Thu, Oct 22, 2009 at 8:14 PM, mdipierro <mdipie...@cs.depaul.edu> > wrote: > > > > > Move to postgresql not mysql ;-). If I may, what is the site? I am > > > curious. > > > > > On Oct 22, 7:56 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > > > > It seems as if now, I am not recieving any 503 errors. This must be > due > > > to > > > > the ammount of growth the site recieved in such a short period of > time, > > > not > > > > to mention i'm running it in a shared hosting environment, there is > > > nothing > > > > I can do except get a dedicated server, or perhaps figure a way to > limit > > > the > > > > requests based on a random timer. For some odd reason, get requests > load > > > > faster, but this could just be a fluke in the environment. > > > > > > I have been browsing through error tickets, and it seems that since > my > > > > database (sqlite) grew from only 100 tracked items to 1460 tracked > items > > > in > > > > a little over a few hours, every ticket recieved is about migration > > > > EOFErrors. I will try exporting everything to csv, switching over to > > > mysql, > > > > and reimporting. Perhaps this will fix some of the performance > issues, > > > and > > > > the EOF errors.. > > > > > > S'Traceback (most recent call last):\n File "gluon/restricted.py", > > > > line 184, in restricted\n exec ccode in environment\n > > > > File "/home/.idiosyncrasy/thadeusb/ > > > > thadeusb.com/surrenderthebooty/applications/init/models/db.py", > > > > line 42, in <module>\n auth.define_tables() > > > > # creates all needed tables\n > > > > File "gluon/tools.py", line 601, in define_tables\n > > > > self.settings.table_permission_name, migrate))\n > > > > File "gluon/sql.py", line 1130, in define_table\n > > > > query = t._create(migrate=migrate)\n > > > > File "gluon/sql.py", line 1501, in _create\n > > > > sql_fields_old = cPickle.load(tfile)\nEOFError\n' > > > > > > -Thadeus > > > > > > On Thu, Oct 22, 2009 at 3:29 PM, Thadeus Burgess < > thade...@thadeusb.com > > > >wrote: > > > > > > > I can post code later tonight when I get home, I can't even make > any > > > > > changes to code until then since it is a personal project. > > > > > > > I will try using a GET request instead, since no data is being > passed > > > > > through post anyways. > > > > > > > It is an apache thing, its just odd I only get it when using ajax. > It > > > did > > > > > not start happening until today when the site received a major > influx > > > of new > > > > > content to track. > > > > > > > There is no way for me to increase threads or processes since this > site > > > is > > > > > on shared hosting :( > > > > > > > -Thadeus > > > > > > > On Thu, Oct 22, 2009 at 3:09 PM, mdipierro < > mdipie...@cs.depaul.edu > > > >wrote: > > > > > > >> 2py never returns 503. Are you using apache? It may be running out > > > > >> of threads or proc > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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 -~----------~----~----~----~------~----~------~--~---
