database

Sun claims big leap with MySQL 5.1

Submitted by Bryan on April 14, 2008 - 10:39pm

ComputerWorld: Sun will use the MySQL Conference & Expo in Santa Clara, Calif., to release MySQL 5.1, an upgrade that includes several new features designed to make the database more suitable for mission-critical applications at large enterprises.

Complete Story

»

Opinion: File Based Applications to replace Database Systems

Submitted by joelhalse on March 31, 2008 - 5:05am
OpenEdit's Joel Halse believes that file based applications and not the database driven systems are the next evolution for information management. The below article is written by Joel Halse and explains his reasons for why he has reached this conclusion.

Lets say you need to organize 2000 people on a football field. A relational database would create 2000 little boxes and make everyone stay in their little box. If someone needed to move around, they would first need to inform the administrator so that the administrator doesn't lose track of everyone. A file based system on the other hand would hand out a cell phone to everyone and tell them to have fun. If someone needs you, we'll give you a call. Just make sure you don't lose your cell phone. Beyond that, have a great day.

A relational database was a good system. It was also created in a time where searching a million files took more than milliseconds. It was a product of limitations. It wasn't necessarily the ideal solution, but it was a good solution given the tools at hand. Those limitations are gone. Those limitations are in the past. New technology and mind boggling search capabilities have opened the door for new options that weren't available 20 years ago.

File based applications are the next evolution for information management. Especially for the web.

Why? Because it's easier understand. It's not that you aren't smart enough to understand a database. It's that you don't have to understand a database. Especially when you already understand how to use a file based system.

»

IBM Invests In Open Source EnterpriseDB

Submitted by Bryan on March 27, 2008 - 6:05am

Intelligent Enterprise: Four weeks after Sun Microsystems locked up the open source MySQL database system, IBM has decided to become one of four investors in EnterpriseDB.

Complete Story

»

OpenEdit: 10 Reasons Databases Suck

Submitted by Bryan on March 26, 2008 - 5:57pm

"While the misconception that a database is an absolute requirement for complex web applications may not be listed as the second most common error of the 21st century, it is a misconception that continues to go largely unchallenged."

Complete Story

»

Adobe funds SQLite database

Submitted by Bryan on February 26, 2008 - 11:00am

Company says it's supporting public-domain project incorporated into some of Adobe's own software. Also new: an Adobe open-source site. (From News.com's Underexposed blog)

Complete Story

»

Linux.com: Using MySQL as a filesystem

Submitted by Bryan on February 15, 2008 - 6:34pm

"With MySQLfs you can store a filesystem inside a MySQL relational database. MySQLfs breaks up the byte content of files that you store in its filesystem into tuples in the database, which allows you to store large files in the filesystem without requiring the database to support extremely large BLOB fields. With MySQLfs you can throw a filesystem into a MySQL database and take advantage of whatever database backup, clustering, and replication setup you have to protect your MySQLfs filesystem."

Complete Story

»

Drupal Database Configuration

Submitted by Bryan on February 12, 2008 - 11:58pm
Drupal Database Configuration

 

Database configuration for a clean install.

MySQL Blogs on Sun acquiring MySQL

Submitted by CMS Report on January 16, 2008 - 4:16pm
Check out Planet MySQL for the latest perspectives and opinions regarding Sun acquiring MySQL.
»

Solving the Duplicate Entry Problem with Drupal Comments

Submitted by Bryan on November 14, 2007 - 7:30am

A couple months ago, I experienced a number of errors at my Drupal site that all pointed to a corrupted database. I believe the problem likely was the caused by a sloppy export/import I performed with the MySQL database while moving the site to a new server.

While my particular database problem was an easy fix, if you really don't know much about databases you may find that you really need some guidance on how to solve problems like these. This article is the process I went through to correct this particular MySQL database problem in Drupal 5 and some general database rules that show why this problem occurred in the first place.

»

Moving a SMF forum to a phpBB forum

Submitted by Bryan on November 7, 2007 - 6:44am

Thanks to a post at OpenSourceCommunity.org, I came across a conversion tool to allow you to import the SMF 1.1 database into a phpBB 3 site. Information about the conversion tool can be found in a forum post at phpbb.com. By the way, the script is still in beta, meaning that it works but you might find some bugs since it is not fully tested.

It is not that I'm encouraging anyone to convert their site from SMF to phpBB, but it is very nice to have options such as these available. In fact if anyone can point me to a good conversion tool for migrating a phpBB database to SMF, I would welcome the information.

»
Syndicate content