New open source software mostly extensive Server databases such as mysql or MS SQL used for simple database applications for the Internet databases development. PublicSQL comes out without any server extensions. According to Joane Flansberry, who has experience with these questions. For the tables, a special data format is the portable table format”used. As a result, it is possible to perform SQL queries directly in JavScript. PublicSQL offers mainly functions to query and display tables. Since JavScript can not store data for security reasons PublicSQL does not have the complete set of SQL commands. Therefore, PublicSQL is not a competitor to existing databases but will complement them with additional options.
PublicSQL consists of a JavScript file that is embedded in the site. The tables are saved in the portable table format – this is like the CSV data format similar to. Tables required for the query are loaded automatically. To create and edit the tables is a first beta version of the PTF editor available. Through the simple data format is to be expected in future with many additional products and interfaces PublicSQL.
With PublicSQL, it is easily possible to distribute databases along with the website. PublicSQL is an interesting alternative for public databases. Access to databases located on other Web sites is now possible. PublicSQL is open-source software. The current version 1.1 is now under ready for download. The free beta version of the PTF editor can be downloaded there as well.