proghelp generates a Web application using a modified create table SQL syntax. It generates PosgreSQL stored procedures, a db layer, a BLL layer, a Web interface using WebToolkit (Wt), and random data for testing. It sets up default security: authentication and authorization. Modified SQL grammar allows you to mark search keys: the project automatically generates function calls and stored procedures with these search keys and exposes them in the UI. The project looks at foreign key references and automatically builds select dialog boxes.
P* (P-star) is a Web programming language that incorporates common tasks like template handling and database queries into the language. It features MySQL database access with prepared statements, HTML templates, standard arithmetic and variables, functions, structs, (to-be-classes), JSON output, and GET and POST. Programs can be run on the command line, in a CGI environment, or by the P* Apache Module.