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

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

[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

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

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

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

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 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

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 in. If

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