Oracle released MySQL 5.5 RC

mysql-php-code-server

During the Oracle OpenWorld2010, Larry Ellison’s has announced the availability of the MySQL 5.5 Release Candidate. MySQL is the most open source Database used in the world and released under the GNU/GPL license. The RC comes with interesting improvements on Windows and Linux platform. Excellent performance on multi-CPU, crash recovery, support for ACID transitions  and InnnoDB as the default storage engine.

Read more what’s new in MySQL 5.5 or download Community Server.

Sun and Oracle

sun-java-download-oracle-database-mysql

Sun and Oracle today announced a definitive agreement for Oracle to acquire Sun for $9.50 per share in cash. The Sun Board of Directors has unanimously approved the transaction. It is anticipated to close this summer.

The acquisition combines best-in-class enterprise software and mission-critical computing systems. Oracle plans to engineer and deliver an integrated system—applications to disk—where all the pieces fit and work together so customers do not have to do it themselves. Customers benefit as their system integration costs go down while system performance, reliability and security go up.

Generate Free data for your tables

database-data-sql-mysql-querry

Was really hard filling the database of my project with data to test it. I lose around 3 hours to type a lot of information’s to fill the tables. Generatedata.com is a great website to generate a lot of data to populate your tables. Result type can be in HTML, Excel, XML, CSV or SQL. You can specify and the number of results that you want. For me is to late now but if you are in the same situation go and get as data as you need.

Continue reading

Web based MySQL administration

Web based MySQL administration

MySQL is a relational database management system (RDBMS) and most of web databases are based on MySQL with more than 11 million installations. The program runs as a server providing multi-user access to a number of databases. To administer MySQL databases one can use the included command-line tool (commands: mysql and mysqladmin).

In the alternative to use command-line, a great tool to administrate the database is SQL Buddy open source MIT-style license. No installation script is necessary, just unziping the files to the server and the next step is logging in. In few steps you can make a full back-up to your site and also the function import is implemented. Supported by the most used web browser you can download SQL Buddy from here