Re: [GENERAL] PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?

2012-04-26 Thread John DeSoi
On Apr 26, 2012, at 11:23 PM, Ken Tanzer wrote: > I took a look. The syntax highlighting in phpPgAdmin is nicely > self-contained in one file, and BSD-licensed. Unfortunately the actual > highlighting is less advanced than some others. (I've gotten spoiled by vim, > but suspect it's not wri

Re: [GENERAL] PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?

2012-04-26 Thread Ken Tanzer
I took a look. The syntax highlighting in phpPgAdmin is nicely self-contained in one file, and BSD-licensed. Unfortunately the actual highlighting is less advanced than some others. (I've gotten spoiled by vim, but suspect it's not written in PHP!) Now I'm looking at a couple of javascript opti

Re: [GENERAL] PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?

2012-04-25 Thread John DeSoi
On Apr 25, 2012, at 6:57 AM, Ken Tanzer wrote: > Hi. I'm looking for an Open Source PHP code that will take plain text SQL > and turn it into colorful HTML. If it could take messy code and clean up > indents and such (a la SQLinForm), that would be a nice bonus. Ideally it > would understand

[GENERAL] PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?

2012-04-25 Thread Ken Tanzer
Hi. I'm looking for an Open Source PHP code that will take plain text SQL and turn it into colorful HTML. If it could take messy code and clean up indents and such (a la SQLinForm), that would be a nice bonus. Ideally it would understand many flavors of SQL, but handling Postgresql syntax is mos

Re: [GENERAL] PHP SQL

2005-03-22 Thread Shaun Clements
Title: RE: [GENERAL] PHP SQL Thanks for your response. It is as you mentioned, within the same database. I will get working on a stored procedure this morning. Thanks for your response. Kind Regards, Shaun Clements -Original Message- From: Jeff Davis [mailto:[EMAIL PROTECTED

Re: [GENERAL] PHP SQL

2005-03-22 Thread Jeff Davis
> pg_fetch_row > pg_fetch_assoc > pg_fetch_object > pg_fetch_result > pg_fetch_array > > Are there performance differences, which are noticeable? I doubt you'll see much real difference. Your real bottleneck will be I/O. You might be able to save something by using COPY out and then back i

Re: [GENERAL] PHP SQL

2005-03-22 Thread Richard Huxton
Shaun Clements wrote: Excellent idea. Yes, I would prefer to write in plpgsql. My next concern then, is, does Postgres, perform some kind of Load Balancing. Well, you can have multiple clients running queries at the same time. I dont want the stored procedure once run, to DOS other users, who are r

Re: [GENERAL] PHP SQL

2005-03-22 Thread Shaun Clements
Title: RE: [GENERAL] PHP SQL Excellent idea. Yes, I would prefer to write in plpgsql. My next concern then, is, does Postgres, perform some kind of Load Balancing. I dont want the stored procedure once run, to DOS other users, who are running reports.. or perform queries using some

Re: [GENERAL] PHP SQL

2005-03-22 Thread Michael Fuhr
On Tue, Mar 22, 2005 at 01:25:30PM +0200, Shaun Clements wrote: > Which is more efficient, in reading in a row of data, and assigning > individual column values to variables, and then inserting a new row into the > new table. > > pg_fetch_row > pg_fetch_assoc > pg_fetch_object > pg_fetch_result >

[GENERAL] PHP SQL

2005-03-22 Thread Shaun Clements
Title: [GENERAL] PHP SQL Hi All I am designing a data loader script that can transform data in one table schema into a new table schema in Postgres for reporting purposes. I wanted to ask, on a performance issue. Which is more efficient, in reading in a row of data, and assigning