Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible? - Mailing list pgsql-general

From Ken Tanzer
Subject Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?
Date
Msg-id CAD3a31Vb6t+W2pHuDpZ3XYqhXW+9=m33+DWer5zbF4L0h_9+cA@mail.gmail.com
Whole thread Raw
In response to Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?  (John DeSoi <desoi@pgedit.com>)
Responses Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
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 options with good highlighting instead.

Thanks for the suggestion.

Ken

On Wed, Apr 25, 2012 at 4:55 AM, John DeSoi <desoi@pgedit.com> wrote:
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 many flavors of SQL, but handling Postgresql syntax is most important.  I want to include this in my own project, so it needs to be redistributable and specifically GPL3 compatible.  Again ideally, it would be a standalone and fairly lightweight piece of code, rather than having to embed some monster package.
>
> Does anyone know of such a beast?  TIA for any help provided.


Not stand alone, but the phpPgAdmin project colors SQL/PostgreSQL code and I believe the license is GPL.

http://phppgadmin.sourceforge.net/doku.php?id=start





John DeSoi, Ph.D.







--
AGENCY Software  
A data system that puts you in control
(253) 245-3801


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug? Query plans / EXPLAIN using gigabytes of memory
Next
From: John DeSoi
Date:
Subject: Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?