Must have Database Tools Scripts for Web
Works like an improved version of pg_dump, allowing administrators to setup up filters when dumping the database's content.
This means sensitive data like passwords can be left out of the dump file to prevent any future incidents, leaks, or...
pgFormatter can remove comments from the code, can enable syntax highlighting in the output for an increased readability, developers can control how the script handles keywords and functions, and they can also customize the indentation size.
SQL code can...
PgHero can show a small status review for a desired PostgreSQL database.
This is done via a Web-based interface where admins can go and check out how their database is being used.
Admins can view a list of recent queries, current indexes, the disk space...
PgHero.sql is the project that inspired the PgHero Ruby Web app. This app provides the same functionality as PgHero.sql, only from a Web-based GUI.PgHero.sql does practically the same thing, only using SQL commands and working from the user's database...
pgShark is obviously inspired by WireShark, a handy state of the art network protocol analyzer.pgShark works kind of the same way, only it targets network traffic going to a PostgreSQL database.Developers can use this feature to build a wide array of...
pgTap is written in PL/pgSQL and PL/SQL, following the xUnit philosophy, responsible for frameworks like NUnit, JUnit and more. The framework is basically a collection of various functions for gathering, analyzing and reporting on PostgreSQL-powered...
pg_repack is an unofficial fork from the now abandoned pg_org project.
As the original pg_org extension, pg_repack does not lock any tables when moving data around and can be used to optimize production level databases.
pg_repack comes with three distinct...
In the meantime, SQLite has become an unofficial de-facto standard for storing data on the client's side.SQLite has actually become so successful these days that an official extension has even been included with the newer PHP 5.x branch by...
For now, the PHP SQL Parser library only supports the MySQL SQL dialect.Other dialects can be added, but some hard-coding might be required.All parsed SQL statements will be stored inside an arrayFeatures:Supported MySQL...
phpMyAdmin has reached the stratosphere of fame in Web development, almost completely identifying itself with the product it serves.
Just by saying phpMyAdmin, any developer these days will think of MySQL. Some don't even know MySQL doesn't come with...