Gourt > Computers > Software > Databases > PostgreSQL (1)
PostgreSQL is a free object-relational database server (database management system), released under a flexible BSD-style license. It offers an alternative to other open-source database systems (such as Ingres, MySQL and Firebird), as well as to proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server. Similar to other open-source projects such as Apache, Linux, and Mediawiki, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.
PostgreSQL's unusual-looking name makes some readers pause when trying to pronounce it, especially those who pronounce SQL as "sequel". PostgreSQL's developers pronounce it "post-gress-Q-L". (Audio sample, 5.6k MP3). It is also common to hear it abbreviated as simply "postgres", which was its original name. The name refers to the project's origins as a "post-Ingres" database, the authors having also written Ingres.
Features
More on [ PostgreSQL ]
éå¬æ¥ã2/5ãã¨æã£ãããç³è¾¼æéã2/5ã§ãéå¬æ¥ã¯2/20ã ããæ°ãã¤ãããã http://j.mp/5O3sG0 #postgresql
suzuki (suzuki) Fri, 25 Dec 2009 06:54:56 -0000
開催日が2/5かと思ったら、申込期限が2/5で、開催日は2/20だよ。気をつけよう。 http://j.mp/5O3sG0 #postgresql
JPUGå宿2010ã¯æ°æ½ã®æ岡温æ³ã ããã ã http://j.mp/5O3sG0 #postgresql
suzuki (suzuki) Fri, 25 Dec 2009 06:51:51 -0000
JPUG合宿2010は新潟の月岡温泉だそうだ。 http://j.mp/5O3sG0 #postgresql
@6A1AN3K0 esto es lo que piden: Programador: ajax, JSP,JSF,GLASSFISH,POSTGRESQL, principalmente ajax, aún no me dicen cuanto $$ ofrecen..
eXrag (eXra) Fri, 25 Dec 2009 06:41:58 -0000
@6A1AN3K0 esto es lo que piden: Programador: ajax, JSP,JSF,GLASSFISH,POSTGRESQL, principalmente ajax, aún no me dicen cuanto $$ ofrecen..
ç°å¢ã¯ JIRA 4.0.1 Enterprise - WAR + Tomcat 6.0.20 + postgresql-server-8.1.18-2.el5_4.1 (rpm)
jfut (jfut) Fri, 25 Dec 2009 06:27:41 -0000
環境は JIRA 4.0.1 Enterprise - WAR + Tomcat 6.0.20 + postgresql-server-8.1.18-2.el5_4.1 (rpm)
VPSã§ã¯WEBKEEPERS(http://jp.webk.net/)ãåããããå®ãã£ããã ãã©ãPostgreSQLã使ãã®ã«æ500åãããã¨ãæå³åãããªãã®ã§å´ä¸ãVPSãªã®ã«ãããªå¶ç´ããããªãã¦ãã
kurasan (ããã°) Fri, 25 Dec 2009 06:26:39 -0000
VPSではWEBKEEPERS(http://jp.webk.net/)も同じくらい安かったんだけど、PostgreSQLを使うのに月500円かかるとか意味分からないので却下。VPSなのにそんな制約があるなんてね。
ãã£ã¨ãPostgreSQLããã½ãã¨ãã ãããã ã¼ãããã£ã¦èªãã®ã¯ééã£ã¦ã¾ãâ¦ããâ¦ï¼ (ãã£ãã®ä»¶ããã£ãã®ã§æãæã
nifex (ã«ã¸ãã) Fri, 25 Dec 2009 06:18:38 -0000
えっと、PostgreSQLを「ぽすとぐれ えすきゅーえる」って読むのは間違ってます…よね…？ (さっきの件があったので恐る恐る
PostgreSQL - Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. Completely free database
Consulting - pgHoster is a PostgreSQL-oriented web hosting companies. Featured on the PostgreSQL.org website.
Meta Description: [ ,,pgHoster :: PostgreSQL Database and Web Hosting ]
A Review by Paragon Corporation - Article that focuses on features that make PostgreSQL different from most relational database management systems.
Meta Description: [ In this article we will delve into the features of the PostgreSQL object-relational database environment and what makes it special. We will focus on features that make PostgreSQL different from most relational database management systems (RDBMS). ]
About.com on Postgres - Provides feature articles, net links, forum discussions and a chat room.
Meta Description: [ Postgres and INGRES are open-source database products brought to us by the database research group at UC Berekely. These links provide the best resources on the Net! ]
Adding XML - Tools to enable XML support.
Databases: As The Tables Turn - Tim Perdue article about porting sourceforge code from MySQL to PostreSQL.
Meta Description: [ PHPBuilder.com, the resource for PHP
tutorials, templates, PHP manuals, content management systems, scripts,
classes and more for the PHP developer. ]
dbengine - A plug 'n play Web interface for PostgreSQL and Oracle.
500
Embedding R in Postgres - The REmbeddedPostgres package allows you to embed the R interpreter in Postgres and use R functions as if they were built-in SQL functions.
GUI tool for PostgeSQL - PGExplorer is a GUI development tool for the Postgres Database Server [commercial].
Meta Description: [ MS Windows frontend client GUI tool for executing SQL on a PostgreSQL database ]
Guide to Version 7.x Development and Configuration - A side by side comparison to Oracle 8i that can also be read as a stand alone document.
Meta Description: [ Oracle complete guide to installation, configuration and certification Test_1Z0-001 Test_1Z0-023 Test_1Z0-025 Test_1Z1-024 Test_1Z1-026 ]
Interactive SQL - GUI tool for creating SQL queries and managing PostgreSQL databases [commercial].
Java JDBC - Drivers, documentation, and tutorials.
MySQL PHP to PostgresSQL - A program that takes a php page that uses mysql calls and changes them into Postgres calls.
Native PostgreSQL Frontend for Windows - Client applications for Windows including native SQL terminal and backup tools, psql and pg_dump, for executing SQL scripts and accessing PostgreSQL servers remotely.
Meta Description: [ PostgreSQL client applications for Windows. Includes native SQL terminal and backup tools, psql and pg_dump, and gzip. ]
NuSphere UltraSQL - NuSphere UltraSQL is a native Windows port of popular PostgreSQL database. Commercial.
Meta Description: [ PhpED - PHP IDE integrated development environment for developing web sites using PHP, HTML, Perl, JScript and CSS that combines a comfortable editor, debugger, profiler with the MySQl, PostrgeSQL database support based on easy wizards and tutorials.Esy to use for debugging PHP scripts, publishin... ]
OCaml - OCaml bindings that allow access to Postgres from the OCaml programming language. [Open Source, LGPL]
Octave-pg - Octave modules to access PostgreSQL.
Oracle v. Postgres - Forum discussion comparing Oracle and Postgres.
Performance Tuning PostgreSQL - This article aims to help demystify PostgreSQL database performance tuning.
Meta Description: [ Tuning your PostgreSQL database is somewhat of a black art. While documentation does exist on the topic, many people still find it hard to get all the power out of their system. This article aims to help demystify PostgreSQL database performance tuning. ]
PGAda - PostGreSQL bindings for Ada
Meta Description: [ Ada PostgreSQL binding ]
PGCup - PGCup is a simple Java PostgreSQL administration tool. Currently under development and seeking volunteers. [Berkeley/BSD].
PhpPgAdmin - Feature list and downloads for a web-based administration tool.[Open Source, GPL]
PL-J - A stored procedure platform that provides Java and other object oriented language integration.
PostGIS: Geographic objects for PostgreSQL - Spatially enables the server, allowing it to be used as a backend spatial database for geographic information systems (GIS).
500
Postgres on Redhat7.0 - Article from PHPBuilder on obtaining packages, installing and configuring.
Meta Description: [ PHPBuilder.com, the resource for PHP
tutorials, templates, PHP manuals, content management systems, scripts,
classes and more for the PHP developer. ]
PostgresDAC - Borland Delphi/C++Builder component set for direct access to PostgreSQL without BDE or ODBC.
PostgresPy Project - An open source software project dedicated to the continual improvement of the relationship between Python and PostgreSQL.
Meta Description: [ The PostgresPy Project Home Page ]
PostgreSQL Autodoc - Automated creation of PostgreSQL documentation in Dia, Docbook, HTML, and GraphViz formats.
PostgreSQL based relational database - EnterpriseDB is a relational database management system based on PostgreSQL. It adds compatibility and performance features.
PostgreSQL College - A series of free Macromedia Flash courses teaching aspects of PostgreSQL, including sequences and referential integrity.
PostgreSQL Inc. - Commercial support for the object-relational database management system, PostgreSQL, as well as full database hosting.
Meta Description: [ PostgreSQL, Inc. is the leading global commercial service and support provider for the world's most advanced open source database ]
Postgresql Korean Users' Group - Official Homepage of PostgreSQL Korean Users' Group. This site contain documents, patches, user's profiles of PostgreSQL korean users.
PostgreSQL Manager - Graphical tool for PostgreSQL administration and development.
PostgreSQL Module for Python - Python module that embeds the PostgreSQL query library.
Meta Description: [ PyGreSQL homepage ]
PostgreSQL Performance Tuning - Information on how to tune and generally get good performance from PostgreSQL.
PostgreSQL Technical Documentation - Contains community contributed documentation, CBT (Computer Based Training) tutorials, installation guides, technical guides, support contracts, lists of hosting providers, and additional resources.
PsqlODBC - ODBC driver for Windows. Site includes download, mailing list, documentation, and FAQs.
pyPgSQL - A Python library for accessing PostgreSQL databases that conforms to the Python DB-API version 2.
Meta Description: [ A DB-API 2 compliant Python interface to
the PostgreSQL database. ]
Recursive functions in PostGreSQL PGSQL - An example of how to display a recursive tree in pgsql.
Meta Description: [ In a prior article we discussed how to use SQL Server's user-defined functions to solve the recursive tree problem. In the SQL version we solved the common who reports to who problem. In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions.... ]
Red Hat Database - A version of Postgres that has been optimized for the Red Hat Linux distribution.
404
Ruby Extension Library - Allows access to Postgres from the Ruby Object Oriented scripting language.
Meta Description: [ 日本PostgreSQLユーザ会は、PostgreSQLの普及促進を目的に活動する特定非営利活動(NPO)法人です。 ]
Search PostgreSQL Sites - A searchengine for PostgreSQL-Documentation. Sample application for Tsearch2.
The PostgreSQL EOAdaptor - For WebObjects and Enterprise Object Framework (EOF) from Apple. Runs on NeXT, Windows, Apple, Sun.
Tsearch2 - Implementation of a new data type tsvector - a searchable data type with indexed access. Documentation and download.
XPg: PostgreSQL GUI on Java - XPg is an object-oriented platform-neutral editor with a full featured graphical user interface that supports connections to multiple databases [Open Source : GPL].
Meta Description: [ XPg - GNU Java Tool for PostgreSQL ]
| How To Migrate MySQL to PostgreSQL | |
| Next Video | |
