Archive for the ‘MySQL’ Category

Adminer: Web frontend to MySQL, in a single file

Friday, August 21st, 2009

adminer_210809

This is a tool that will be useful to developers who need to make urgent changes in some server MySQL. Admin is a Web frontend to the popular database, which requires only a 170 Kb file to run. Just upload it to your site and use it.

Supports all functions that can be found in phpMyAdmin, for example: create database, list the contents of the tables and change their parameters, adding and removing tables and columns, perform all kinds of indexes and stored procedures to execute commands on line or from a file, export as CSV or SQL display or kill processes, among others.

Works with MySQL 4.1, 5.0 and 5.1 running on PHP 4.3 or 5 sessions enabled. It is available in eleven languages, including Spanish, and is absolutely free. Ideal for out of trouble or do not download packages installations.

Link via Admin

Tags: , ,
Posted in MySQL | No Comments »

MySQL Librarian publishes

Wednesday, July 15th, 2009

With the MySQL Librarian is now a place on the web was founded on the article, news, blog entries, and download links about MySQL can be collected. MySQL user should be used as a platform for a comprehensive overview of the subject. The offer will also descriptions of presentations and books and photographs and videos have included the contents of each can from the community to be displayed.

A detailed description of the MySQL Librarian is available in the DevZone.

Link: via MySQL Librarian

Tags: ,
Posted in MySQL | No Comments »

PostgreSQL 8.4 maintains its distance with rivals

Thursday, July 2nd, 2009


The Group PostgreSQL Global Development has released version 8.4 of the database of open source with advanced features. There are nearly 300 improvements to administration, programming and query language opening up new possibilities with this database.

Some improvements are:

* Restoring the database using parallel processes, accelerating the recovery of a back up to 8 times compared to the previous version.
* Column privileges, to control access to a greater level of detail.
* Language settings and management for database. To be able to select the most appropriate depending on the language that is required.
* Update 8.3 to 8.4 with minimal downtime
* New tools for monitoring consultations, delivering information to managers to know what is happening in the database.
* Implement advanced features of ANSI SQL: 2003 which allow complex queries into a single expression which previously required several.
* Improvements in stored procedures, for example using default parameters in the statement or list of arguments of variable length, the style C + + / Java.
Besides the new features, this new version includes improvements to the strong performance, particularly in complex operations.

While there are other databases of open source with a large base of users as MySQL, PostgreSQL orientation has always been to implement the features that make face to face with advanced databases such as Oracle. In this issue again The project has made it clear what distinguishes PostgreSQL jurisdiction in the world of open source.

Link: via PostgreSQL

Tags: , ,
Posted in MySQL | No Comments »