Ein weit verbreitetes Missverständnis steht hinter dem Mythos, dass dynamische SQL langsam ist. Für bedingte WHERE-Klauseln kann eben dieser Mythos zu Performanceproblemen fürhen.
Dataclips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create a query on dataclips.heroku.com, and then share the resulting URL with co-workers, colleagues, or the world. The recipients of a dataclip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats
Expose your database (or any fine grained subset of it) to executives or business analysts (or any other non-technical personnel) for quick browsing and ad-hoc reports.
Comprehensive information about the database as a whole.
This interface is implemented by driver vendors to let users know the capabilities of a Database Management System (DBMS)
Atlantis Data Surf is a free animated SQL Database Visualization Tool which allows you to easily visualise complex schemas - use it to 'surf' through your data.
HTSQL was created in 2005 to provide an XPath-like HTTP interface to PostgreSQL for client-side XSLT screens and reports. HTSQL found its audience when analysts and researchers bypassed the user interface and started to use URLs directly. The language has evolved since then.
he Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself!