Re: [GENERAL] Wordpress & PostgreSQL ...

2006-10-29 Thread Yanni Chiu
Dawid Kuroczko wrote: Suppose one would like to create a WordPress workalike, i.e. a blogging engine sharing look&feel of WordPress but written from scratch. What language/framework do you think would be the best? Try Squeak/Seaside (www.seaside.st). The continuation stuff is optional, you can

Re: [GENERAL] Select first ten of each category?

2006-04-12 Thread Yanni Chiu
Michael Glaesemann wrote: Without using UNION, (which would require writing a select statement for each category), how would LIMIT allow him to do this for each category in a single query? You're right, it would need a UNION, and a SELECT per category. So there'd be another SELECT to find al

Re: [GENERAL] Select first ten of each category?

2006-04-12 Thread Yanni Chiu
Benjamin Smith wrote: It has a LARGE number of entries. I'd like to grab the 10 most expensive items from each category in a single query. How can this be done? Use a LIMIT on your SELECT. See: http://www.postgresql.org/docs/8.1/static/queries-limit.html ---(end of bro

Re: [GENERAL] connecting to server process via sockets

2005-05-16 Thread Yanni Chiu
Randall Smith wrote: > > For fun and learning, I would like to connect to the Postgresql backend > and issue queries using sockets. I'm using Python's socket module. I'm > new to socket programming, but I'm experienced with Python and > Postgresql. Look in the postgres docs for the section on f

Re: [GENERAL] Perl and AutoCommit

2005-03-26 Thread Yanni Chiu
Madison Kelly wrote: > >What I am trying to do is turn off autocommit for one particular task > in my program. I realize I can turn off AutoCommit when I connect to the > database but in this case that is not what I want to do. This is a > one-off task. > >What I thought would work was: >