PublicSQL

Start page

PublicSQL is a SQL variant to be used in JavaScript. It allows using SQL commands for access of tables and databases direct in JavaScript. It works with the "Portable Table Format", a text format like the CSV-Format. The tables maybe passed by a CD. PublicSQL programs are executable without server extensions - the time-consuming database connection is not applicable. Also the access to remote tables is possible. And the best: PublicSQL is Open-Source-Software for free use.

News

Article in Linux-Magazine (22. September 2010)

The October Issue of the Linux Magazine includes an article about PublicSQL. An example is available at ftp://ftp.linux-magazin.com/pub/listings/magazine/119/PublicSQL/.

NEW! PTF Editor 1.0.4 (From 04. June 2010)

It's easy to create and copy your PTF-Files with the new PTF Editor available at the download page.

PublicSQL Version 1.1 available

Version 1.1 of PublicSQL contains the follow modifications:

Queries of more than 2 tables are now possible.
The 'ORDER BY' clause is supported.
The access of the tables outside the current directory is usually by the variable "publicSQL.tablePath".
Error numbers and error texts are established.
The function publicSQL.show() additionally displays row numbers.
An display error by the function publicSQL.show() was corrected.
An error by the function publicSQL.arraySort() was corrected.

PublicSQL is available from our download page.

Here you find the press release to PublicSQL (PDF format).