[GENERAL] Watch your PlanetPostgreSQL.org blogs

2008-03-07 Thread Lewis Cunningham
Apparently Command Prompt and Devrim GÜNDÜZ own planetpostgresql.org and can arbitrarily decide to remove your blog from planetpostgresql. I, and several others, received an email telling us that we we were not meeting the (unpublished) requirements for blog display length. Try telling blogger

Re: [GENERAL] APEX / HTML DB for PostgreSQL

2008-02-26 Thread Lewis Cunningham
--- justin tocci [EMAIL PROTECTED] wrote: interface? I've thought about it enough to want to try it. I don't really know how APEX / HTML DB work so I'm open to suggestions. I can either put the controller in a perl module and send intelligent requests for formatted pages to postgres or

[GENERAL] Suncoast Postgres User Group

2008-02-14 Thread Lewis Cunningham
This is the official announcement for the Suncoast PostgreSQL User Group (SPUG). You can read the blog here: http://pugs.postgresql.org/spug The SPUG serves western central Florida, specifically Tampa, St Pete, Lakeland, Brandon, Bradenton, Sarasota, and even Orlando. Hopefully we will have a

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Lewis Cunningham
--- Erik Jones [EMAIL PROTECTED] wrote: On Feb 4, 2008, at 11:55 AM, Lewis Cunningham wrote: I'd like to have many lists also. There are so many messages in general that I have a hard time keeping up. I would like to be able to just pick and choose those topics that interest me

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Lewis Cunningham
--- Joshua D. Drake [EMAIL PROTECTED] wrote: On Mon, 04 Feb 2008 12:18:55 + Gregory Stark [EMAIL PROTECTED] wrote: Joshua D. Drake [EMAIL PROTECTED] writes: I was going to suggest pruning the mailing lists down to just 3-4 already. The last thing we need to be doing is creating

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Lewis Cunningham
--- Gregory Stark [EMAIL PROTECTED] wrote: pgsql-hackers pgsql-users There really aren't any other groups of people. people who want to talk about There are hackers (contribute to PostgreSQL), DBAs (administer the database), Developers (write application to interact with the database)

Re: [GENERAL] [OT] advanced database design (long)

2008-02-02 Thread Lewis Cunningham
--- vladimir konrad [EMAIL PROTECTED] wrote: I think that I understand basic relational theory but then I had an idea. Basically, instead of adding field to a table every time there is a need for it, have a table split in two: one holds identity (id) and one holds the attributes (linked

Re: [GENERAL] Oracle Analytical Functions

2008-01-30 Thread Lewis Cunningham
How about something like this: SELECT client_id , datetime , lagged as previoustime , datetime - lagged difftime FROM ( SELECT client_id ,datetime ,(SELECT MAX(datetime) FROM all_client_times def WHERE def.client_id = abc.client_id AND

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-23 Thread Lewis Cunningham
If anyone is interested, I could answer the questions for Oracle and you could add those, too. Be interesting to see a chart like that (that stays updated after releases) for a large assortment of databases. If we add a bunch of different databases, it might be easier to manipulate if it was

[GENERAL] Procedural Code Profiling

2007-08-06 Thread Lewis Cunningham
Hi all, What is the best tool for an app to profile procedural code in postgres? I want to instrument my code and trace it so that I can see which code bits are sucking up the cpu and time. I know I can stick messages in the code and gather my own stats but I was wondering is there are any good

Re: [GENERAL] Procedural Code Profiling

2007-08-06 Thread Lewis Cunningham
--- korry.douglas [EMAIL PROTECTED] wrote: execution count (number of times each statement is executed) total execution time (how long did we spend executing each statement?) longest execution time (how long did the slowest iteration take?) number of scans (total number of

Re: [GENERAL] [SQL] Tunning PostgreSQL performance for views on Windows

2007-07-30 Thread Lewis Cunningham
How big are the underlying tables? If they are large, are you partitioning? Since the values only change daily, if the end result is a reasonable size, have you considered using a CTAS rather than views? LewisC --- Ranieri Mazili [EMAIL PROTECTED] wrote: Hello, I'm developing a BI and as

Re: [SQL][GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Lewis Cunningham
Felix, You might want to look at EnterpriseDB, which is PostgreSQL with Oracle compatibility extensions. www.enterprisedb.com LewisC --- Felix Zhang [EMAIL PROTECTED] wrote: Hi all, I'm a newbie of PostgreSQL. I'm searching materials about porting from Oracle to PostgreSQL. Anyone can