PgDBF is a program for converting XBase databases - particularly FoxPro
tables with memo files - into a format that PostgreSQL can directly
import. It's a compact C project with no dependencies other than standard
Unix libraries. While the project is relatively tiny and simple, it's also
heavily optimized via profiling - routine benchmark were many times faster
than with other Open Source programs. In fact, even on slower systems,
conversions are typically limited by hard drive speed.
pgpool-II allows multiple PostgreSQL servers (DB nodes) to be
connected, which enables queries to be executed simultaneously on all
servers.
It enables "parallel query" processing. Also, pgpool-II can be started
as pgpool-I by changing configuration parameters. pgpool-II that is
executed in pgpool-I mode enables multiple DB nodes to be connected,
which was not possible in pgpool-I.
pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can
connect to pgpool as if it were a standard PostgreSQL server.
pgpool caches the connection to PostgreSQL server to reduce the overhead to
establish the connection to it.
Web-based administration tool for pgpool-II.
Lightweight alternative to heavy phpMyAdmin for easy access MySQL databases.
Currently phpMyAdmin can:
* browse and drop databases, tables, views, columns and indexes
* display multiple results sets through stored procedures or queries
* create, copy, drop, rename and alter databases, tables, columns
and indexes
* maintain server, databases and tables, with proposals on server
configuration
* execute, edit and bookmark any SQL-statement, even batch-queries
* load text files into tables
* create and read dumps of tables
* export data to various formats: CSV, XML, PDF, ISO/IEC 26300 -
OpenDocument Text and Spreadsheet, Microsoft Word 2000, and
LATEX formats
* import data and MySQL structures from OpenDocument spreadsheets,
as well as XML, CSV, and SQL files
* administer multiple servers
* manage MySQL users and privileges
* check referential integrity in MyISAM tables
* using Query-by-example (QBE), create complex queries
automatically connecting required tables
* create PDF graphics of your database layout
* search globally in a database or a subset of it
* transform stored data into any format using a set of predefined
functions, like displaying BLOB-data as image or download-link
* track changes on databases, tables and views
* support InnoDB tables and foreign keys
* support mysqli, the improved MySQL extension
* create, edit, call, export and drop stored procedures and
functions
* create, edit, export and drop events and triggers
* communicate in 62 different languages
PostGIS-JDBC provides the spatial data structures needed to use
PostgreSQL-JDBC with spatial tables.
Allows the creation of encrypted SQLite databases
phpPgAdmin is phpMyAdmin (for MySQL) ported to PostgreSQL. phpPgAdmin is a
fully functional PostgreSQL administration utility. You can use it to create
and maintain multiple databases and even multiple servers.
Features include:
- create and drop databases
- create, copy, drop and alter
tables/views/sequences/functions/indicies/triggers
- edit and add fields (to the extent Postgres allows)
- execute any SQL-statement, even batch-queries
- manage primary and unique keys
- create and read dumps of tables
- administer one single database
- administer multiple servers
- administer postgres users and groups
LICENSE: GPL2 or later
PostGIS adds support for geographic objects to the PostgreSQL
object-relational database. In effect, PostGIS "spatially enables"
the PostgreSQL server, allowing it to be used as a backend spatial
database for geographic information systems (GIS), much like ESRI's
SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS
"Simple Features Specification for SQL" and has been certified as
compliant with the "Types and Functions" profile.
PostGIS development was started by Refractions Research as a project
in open source spatial database technology. PostGIS is released
under the GNU General Public License. PostGIS continues to be
developed by a group of contributors led by a Project Steering
Committee and new features continue to be added.