Database
Database .NET 4.0 released
Database .NET is a simple, uniform and intuitive database management tool for multiple databases, Making Local and Remote Database Administration Easier. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries. A standalone tool that does not require installation. New Features(Ver 4.0) 2010/12/26: Added Index Editor Added IBM DB2 [...]
PostgreSQL 9.1alpha3 Now Available
The third alpha release for PostgreSQL version 9.1, 9.1alpha3, is now available. This alpha release contains several new major features added since the alpha2 release. Please download, install, and test it to give us early feedback on the features being developed for the future versions of PostgreSQL. Features added in 9.1alpha3 since alpha2 include: * [...]
phpPgAdmin 5.0.2 Released
This second update of the pgpPgAdmin 5.0 branch brings some bug fixes on features, compatibility and clean some code. Details bellow. ==== Download ==== To download phpPgAdmin 5.0.2 right now, visit: http://phppgadmin.sourceforge.net/?page=download ==== Changelog ==== * Fix a css typo & error in cappuccino theme * Fix #3139003 “Autocomplete doesn’t insert value”, report and patch [...]
How to Create a New Table in PostgreSQL
You can create a new table by specifying the table name, along with all column names and their types: CREATE TABLE weather ( city varchar(80), temp_lo int, — low temperature temp_hi int, — high temperature prcp real, — precipitation date date ); You can enter this into psql with the line breaks. psql will recognize that the [...]
How to Access a Database in PostgreSQL
Once you have created a database, you can access it by: Running the PostgreSQL interactive terminal program, called psql, which allows you to interactively enter, edit, and execute SQL commands. Using an existing graphical frontend tool like pgAdmin or an office suite with ODBC or JDBC support to create and manipulate a database. These possibilities are not covered in this tutorial. Writing a [...]
How To create a new database in PostgreSQL
The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL server can manage many databases. Typically, a separate database is used for each project or for each user. Possibly, your site administrator has already created a database for your use. He should have told you [...]
What is PostgreSQL?
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later. PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL standard [...]
How to Install Oracle 9i on Linux
Install Red Hat 7.3 on planb (10.10.2.9). Choose “server” profile. Make a symlink to fool the Oracle installer into thinking you have libc6.1. Otherwise, when you run the installer, you will get an error message like “…/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory”. planb# cd [...]
How to choose between MySQL or PostgreSQL – A Comparison
MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with propriety database software. MySQL has long been assumed to be the faster but featureless of the two database systems, while PostgreSQL was assumed to be a more densely featured database system [...]
How To Install PHPMyAdmin on Fedora 9
phpMyAdmin is an opensource tool written in PHP intended to handle the administration of MySQL database and table over the web. Currently, phpmyadmin can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is being distributed in more than 50 [...]