PostgreSQL
From ICISWiki
Database backends > PostgreSQL
PostgreSQL Software Catalogue
(Posted June 11, 2008)
Linked from the Download section of the PostgreSQL website, the Software Catalogue aims to list all the drivers, tools, applications and other software available to work with and on PostgreSQL in a single place to avoid all that tedious googling previously required! See http://www.postgresql.org/download/product-categories
Editing the PostgreSQL Configuration File
(Posted April 18, 2008)
See:
- PostgreSQL Hardware Performance Tuning by Bruce Momjian
- Performance Tuning PostgreSQL by Frank Wiles
New language for Web and PostgreSQL application, Alinous-Core 1.0 Released
(Posted August 6, 2007) Tomohiro Iizuka:
CROSSFIRE JAPAN,INC. released new language and the development environment.
- Develop web applications using database with HTML and SQL
- The development environment is free, and you can download it from the official website.
- By using Alinous-Core, it is not necessary to learn Java, PHP, Perl or Ruby. If you know HTML and SQL, you can make a WebDB application smoothly.
More information at: http://alinous.org/
psqlODBC 08.02.0400 Released (PostgreSQL ODBC Driver)
(Posted May 2, 2007)
Hiroshi Inoue: "This release corrects a problem with the source tarball of the previous release, and fixes some some issues discovered in the code."
Release notes: http://psqlodbc.projects.postgresql.org/release.html Downloads: http://www.postgresql.org/ftp/odbc/versions/
psqlODBC 08.02.0300 Released (PostgreSQL ODBC Driver)
(Posted April 26, 2007)
Hiroshi Inoue: "With this release two versions of the driver are provided for Windows; 'PostgreSQL ANSI' which supports single and multibyte applications through the ANSI ODBC API, and 'PostgreSQL Unicode' which provides Unicode support through the Unicode ODBC API. On Unix systems, the driver type may be selected via a configure option. MSDTC is also supported on Windows, and 64 bit support is now included in the source code (binaries are not yet available)."
Release notes: http://psqlodbc.projects.postgresql.org/release.html Downloads: http://www.postgresql.org/ftp/odbc/versions/
Freeware for converting MS Access database to PostgreSQL (ongoing project)
(Posted April 10, 2007)
PgFoundry: "Convert MS Access DB to PostgreSQL with indexes and cascading update/delete and autoincrement, oh my. Windows Only, it's in Visual Basic." PgFoundry has not released any files for this project as of today. Keep your eye on this page for developments: http://pgfoundry.org/projects/msdbtopg/
PostgreSQL Diff Tool 1.0.0_beta20 released
(Posted April 10, 2007)
PgFoundry: "Simple PostgreSQL diff tool that is useful for schema upgrades. The tool compares two schema dump files and creates output file that is (after some hand-made modifications) suitable for upgrade of old schema." Project information at: http://pgfoundry.org/projects/apgdiff/
pgAdmin III v1.6.3 released
(Posted March 28, 2007)
The pgAdmin Development Team is pleased to announce the release of pgAdmin 1.6.3, the Open Source graphical PostgreSQL administration tool for Windows, Linux, FreeBSD , Mac OS X and Solaris, now available for download in source and a variety of binary formats from: http://www.pgadmin.org/download/
PostgreSQL Maestro 7.3 released
(Posted March 26, 2007)
...A powerful Windows GUI solution for PostgreSQL administration and database development.
"The main feature of the new version is the Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your PostgreSQL databases. Each diagram displays the tables of your database and the relationships between them."
More information available at: http://www.sqlmaestro.com/products/postgresql/maestro/
pg_bulkload released
(Posted March 19, 2007)
Introduction (from README.pg_bulkload): "pg_bulkload provides high-speed data loading capability to PostgreSQL users.When we load huge amount of data to a database, it is common situation that data set to be loaded is valid and consistent. For example, dedicated tools are used to prepare such data, providing data validation in advance. In such cases, we'd like to bypass any overheads within database system to load data as quickly as possible. pg_bulkload is developed to help such situations. Therefore, it is not pg_bulkload's goal to provide detailed data validation. Rather, pg_bulkload assumes that loaded data set is validated by separate means. If you're not in such situation, you should use COPY command in PostgreSQL." Download pg_bulkload here: http://pgfoundry.org/projects/pgbulkload/
mysql2pgsql Version 1.2 released
(Posted March 12, 2007)
A Perl script that converts a mysqlDump.sql file to a postgresDump.sql file. Download at: http://pgfoundry.org/projects/mysql2pgsql/
PostgreSQL offers advanced cursor support as part of its core functionality.
(Posted January 25, 2007)
Cursor support has been available since at least version 6.4. See: http://archives.postgresql.org/pgsql-advocacy/2003-09/msg00076.php
