Be the first to post a text review of phpPgView. Rate and review a project by clicking thumbs up or thumbs down in the right column.

• phpPgView phpPgView-0.3 file released: phpPgView-0.3.zip

  Version 0.3 [2008-07-29] ------------------------ Features * Insert spacers IMG before each underscore both allow to keep the name of columns and labels breakable. * Format type of values in rows section, with coloration for int, boolean and date types, and conversion of bool in 'true' or 'false' * Add sum below stats of schemas and tables * Add a caption about highlightening of rows * Add favicon * Add export to Excel * Allow to choice the number of rows by page * Add additional page numbering when display more than 25 rows by page * Allow to switch from FK replaced column to referencing FK when list content of the table Bugs fixed * Estimated page numbering is false when filter section is used * Problem with formatting of page numbering: 3.23939e+06 rows * Problem with refresh (F5) and filter not empty when many web pages phpPgView open * Impossible to add multiple SAVED_QUERIES_SEPARATOR in saved queries * Null date and time replaced by '1970...' * Error when filtering while section is collapsed Version 0.2 [2008-06-20] ------------------------ Features * Add default saved queries: queries activity, tables and indexes activity, lasts vacuum and analyze (since postgre 8.2) * Add define in config file to choice to replace or not underscores in columns by breaking spaces to reduce width of HTML tables when display results of queries * Place anchors into page to make the navigation easier * Divide list of schemas into two columns * Add a link to get easily url of the page * Allow to hide SQL of a saved query in config file * Display indexes of tables * Allow to group saved queries in different categories * Display time execution of queries * Display estimated number of rows of tables and schemas, and how much space do database objects take up in data files * Folding sections * Insert hyperlinks on foreign keys * If estimated number of rows for selected tables is greater than MAX_ESTIMATED_NB_ROWS_FOR_COUNT define in config file, then COUNT for page numbering is replaced by this estimation * Add HISTORY and INSTALL files Bugs fixed * Error "Unable to connect to PostgreSQL server." not caught * Problem with accented characters in LATIN1 tables * Error in searching indexes * When first view of data of a saved query, the order on the first column is not considered * Error if ORDER existing in saved queries * Error in tracking FK when table is in the public schema * Php errors if a parameter of configuration file is omited * Page numbering based on COUNT(*): use estimated number of rows for huge tables Version 0.1 [2008-06-16] ------------------------ Features * Allow to execute saved SELECT queries * List all schema of the database * List tables of the slected schema * List definition of columns of the selected table * List constraints (primary keys, foreign keys, uniques, checks) on the selected table * List rows (with page numbering) of the selected table and selected saved query * Allow to sort any column of displayed rows * Allow to add a WHERE clause to the selected table or selected saved query * Replace automatically referencing columns of foreign keys by columns declared "human readable" defined in "config.inc.php" when displaying rows * Allow to hide any schema or table in "config.inc.php"

  posted 468 days ago

• File released: /phpPgView/phpPgView-0.3/phpPgView-0.3.zip

  posted 468 days ago

• phpPgView phpPgView-0.2 file released: phpPgView-0.2.zip

  Version 0.2 ----------- Features * Add default saved queries: queries activity, tables and indexes activity, lasts vacuum and analyze (since postgre 8.2) * Add define in config file to choice to replace or not underscores in columns by breaking spaces to reduce width of HTML tables when display results of queries * Place anchors into page to make the navigation easier * Divide list of schemas into two columns * Add a link to get easily url of the page * Allow to hide SQL of a saved query in config file * Display indexes of tables * Allow to group saved queries in different categories * Display time execution of queries * Display estimated number of rows of tables and schemas, and how much space do database objects take up in data files * Folding sections * Insert hyperlinks on foreign keys * If estimated number of rows for selected tables is greater than MAX_ESTIMATED_NB_ROWS_FOR_COUNT define in config file, then COUNT for page numbering is replaced by this estimation * Add HISTORY and INSTALL files Bugs * Error "Unable to connect to PostgreSQL server." not caught * Problem with accented characters in LATIN1 tables * Error in searching indexes * When first view of data of a saved query, the order on the first column is not considered * Error if ORDER existing in saved queries * Error in tracking FK when table is in the public schema * Php errors if a parameter of configuration file is omited * Page numbering based on COUNT(*): use estimated number of rows for huge tables

  posted 507 days ago

• File released: /phpPgView/phpPgView-0.2/phpPgView-0.2.zip

  posted 507 days ago

• File released: /phpPgView/phpPgView-0.1/phpPgView-0.1.zip

  posted 509 days ago

• phpPgView phpPgView-0.1 file released: phpPgView-0.1.zip

  Version 0.1 ----------- Features * Allow to execute saved SELECT queries * List all schema of the database * List tables of the slected schema * List definition of columns of the selected table * List constraints (primary keys, foreign keys, uniques, checks) on the selected table * List rows (with page numbering) of the selected table and selected saved query * Allow to sort any column of displayed rows * Allow to add a WHERE clause to the selected table or selected saved query * Replace automatically referencing columns of foreign keys by columns declared "human readable" defined in "config.inc.php" when displaying rows * Allow to hide any schema or table in "config.inc.php"

  posted 511 days ago