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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo