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

Поиск

Список

Период

Сортировка

От	Ken Tanzer
Тема	Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?
Дата	27 апреля 2012 г. 03:24:37
Msg-id	CAD3a31Vb6t+W2pHuDpZ3XYqhXW+9=m33+DWer5zbF4L0h_9+cA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible? (John DeSoi <desoi@pgedit.com>)
Ответы	Re: PHP SQL Color Syntax that is Postgresql & GPL3 Compatible?
Список	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.