-
OSCON 2011 on SearchEnterpriseLinux.com
SearchEnterpriseLinux's coverage of the 2011 O'Reilly Open Source Convention, set to run July 25-29 at the Oregon Convention Center in Portland, Oregon. Feature
-
Mastering MySQL: Ten essential tips
We've put together our most-read tips on MySQL to help get you started on using this open source relational database management system. Ten essential tips
-
OpenOffice 2.0 Toolbox
This is your guide to getting started with free, open source office suite OpenOffice 2.0. Begin your move away from Microsoft Office today. The two apps aren't as different as you would think. Learning Guide
-
Sybase on Linux: How-to's and help
Here are some shortcuts for using Sybase on Linux. You'll get advice on starting using Perl to access stored Sybase data, shutting down SQLServer using Sybase ASE and more. 10 Tips in 10 Minutes
-
Comparing MySQL, PostgreSQL and SQL Server
How do open source database management systems, like MySQL or PostgreSQL compare to proprietary databases, like SQL Server? Get both sides of the story. Face-off
-
Linux-friendly databases make it big
This Special Report looks at some of the most popular database products that are available to use alongside both Linux and proprietary systems. Special Report
-
Google as a champion of open source?
It's easy to make Oracle the bully in its suit against Google over Android's use of Java, but users say Google isn't exactly a model of open source, either. News | 07 Sep 2010
-
MySQL 5.5 beta released by Oracle
The release of MySQL 5.5 beta is one affirmation of Oracle's commitment to the open source database, quelling the fears of some database admins. News | 15 Apr 2010
-
Oracle to Sun open source users: Don't worry
Oracle promised to continue Sun Microsystem's open source commitment for MySQL, Open Office, and Solaris but open source users are skeptical. Article | 27 Jan 2010
-
Oracle's MySQL buy shifts open source database market
Concerns about the fate of MySQL under Oracle ownership impacted the open source database market, with users increasing PostgreSQL adoption over MySQL. Article | 17 Dec 2009
-
Users cautious on Red Hat's stake in EnterpriseDB
Red Hat stake in EnterpriseDB called good strategy but users say impact depends on outcome of Oracle/Sun merger and the fate of MySQL. Article | 20 Nov 2009
-
EnterpriseDB says open source database saves big bucks
Open source databases have come a long way, offering potential savings and freedom from vendor lock-in. Article | 11 Sep 2009
-
Ingres and JBoss integration aimed at database market expansion
Ingres Corp. says its JBoss pact achieves mission-critical, end-to-end open source computing but expert doubts Ingres can overtake the database market. Among the customers using the integrated middleware is the Swiss-based financial services firm, BB... Article | 01 Jun 2009
-
MySQL fears dominate open source reaction to Oracle-Sun deal
The Oracle-Sun deal hit the wire on Monday, sending a shock wave through the open source community. Many users are fearful of MySQL support under Oracle, while the Linux Foundation and Canonical see the move as proof that open source is a major playe... News | 22 Apr 2009
-
Open source growth dims LAMP stack to symbolic status
LAMP's status as the undisputed open source stack has dimmed to a largely symbolic role as the number of open source applications has expanded. Article | 16 Nov 2008
-
MySQL VP outlines future roadmap, database trends
After MySQL was acquired by Santa Clara, Calif.-based Sun Microsystems Inc. on Feb. 26, data center pros wondered whether the open source database company would change its priorities. Zack Urlocker, Sun Microsystems' vice president of products for My... Interview | 21 Apr 2008
- See More: News on Open source databases
-
Improving security vulnerabilities in open source Web applications
Hackers thrive on exploiting open source Web application source code. But these tactics can protect your corporate applications from common security vulnerabilities and breaches. Tip
-
Installing and setting up OpenERP 6.0
OpenERP 6.0 provides open source enterprise resource planning software alternative to Oracle and SAP, perfect for businesses dealing with tightening IT budgets. Learn how to install and modify the software for your business. Tip
-
Making Sybase database upgrading easier with 'A Practitioner's Guide to upgrading to Sybase ASE 15'
Learn more about the nuances of the upgrade to Sybase ASE 15 in this Q&A with a veteran Sybase expert and author of 'A Practitioner's Guide to upgrading to Sybase ASE 15.' Tip
-
Optimizing MySQL database performance on Linux
MySQL production environment databases need to be closely monitored and managed for performance to ensure efficiency. Learn simple changes you can make to improve your MySQL DB, including shifting from 32-bit to 64-bit versions, using InnoDB instead ... Tip
-
What to expect from version 8.4 of PostreSQL database
The beta release of PostgreSQL is expected in early spring of 2009. PostgreSQL 8.4 has a major improvement that allows quicker discovery of dead tuples with the new free space map, and removal with VACUUM. It also includes a Visibility Map, which is ... Tip
-
Which database is best for multiple platforms: Windows, Linux and Unix
Linux expert Ken Milberg offers advice on database selection for the heterogeneous data center, and recommends Oracle based on market share, support and technical abilities. Tip
-
Installing the MySQL database server securely
Learn how to install the MySQL database securely with these essential steps and guidance. Assess your security risk level, prevent attacks and monitor your system effectively with this tip. Tip
-
High availability from a DB2 9 for Linux, Unix, and Windows Study Guide
Upgrade your V8 DBA certification to DB2 9 with "DB2 9 for Linux, Unix, and Windows Database Upgrade Administration Upgrade Certification Study Guide" by Roger E. Sanders. Download a sample chapter on high availability from this comprehensive study g... Tip
-
Chapter 8, Security from "DB2 9 for Linux, UNIX, and Windows Database Administration Study Guide"
Prepare for the DB2 9 UDB DBA Certification Test (731) with DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide by Roger E. Sanders. Download a sample chapter on security from this comprehensive study guide that cover... Tip
-
MySQL tutorial: Best practices for securing tables, triggers and privileges
Take advantage of this set of best practices for MySQL, an open source relational database management system. Learn about the differences between user and local variables, creating triggers to remove users and more in this MySQL tutorial. Tip
- See More: Tips on Open source databases
-
Incorporating multi-master support in MySQL
A MySQL expert describes two ways that the multi-master support can be used. Ask the Expert
-
OpenOffice 2.0 use with ODBC
An office suite expert describes how to use ODBC with OpenOffice 2.0. Ask the Expert
-
Detection deadlock algorithms in MySQL
An expert describes where to find information on detection deadlock algorithms in MySQL. Ask the Expert
-
MySQL query cache
An expert defines MySQL's query cache and describes when to use it and when to avoid it. Ask the Expert
-
Integrating applications with Linux
A Unix-Linux migration expert offers some key points to consider when transferring native applications from Unix to Linux. Ask the Expert
-
MySQL's query optimizer
A MySQL expert describes the role of the query optimizer and provides an example of how it works. Ask the Expert
-
Creating triggers to remove users
A MySQL expert gives an example of a foreign key and a trigger to use when removing users from tables. Ask the Expert
-
User vs. local variables
A MySQL expert describes the difference between user variables and local variables. Ask the Expert
-
Limiting table access with a stored procedure
An expert describes how to limit table access and viewing with a stored procedure instead of the GRANT statement. Ask the Expert
-
Modifying the GRANT statement
A MySQL expert describes how to modify the GRANT option, when issuing permissions for tables, with the WITH GRANT OPTION. Ask the Expert
- See More: Expert Advice on Open source databases
-
OSCON 2011 on SearchEnterpriseLinux.com
SearchEnterpriseLinux's coverage of the 2011 O'Reilly Open Source Convention, set to run July 25-29 at the Oregon Convention Center in Portland, Oregon. Feature
-
Improving security vulnerabilities in open source Web applications
Hackers thrive on exploiting open source Web application source code. But these tactics can protect your corporate applications from common security vulnerabilities and breaches. Tip
-
Installing and setting up OpenERP 6.0
OpenERP 6.0 provides open source enterprise resource planning software alternative to Oracle and SAP, perfect for businesses dealing with tightening IT budgets. Learn how to install and modify the software for your business. Tip
-
Google as a champion of open source?
It's easy to make Oracle the bully in its suit against Google over Android's use of Java, but users say Google isn't exactly a model of open source, either. News
-
MySQL 5.5 beta released by Oracle
The release of MySQL 5.5 beta is one affirmation of Oracle's commitment to the open source database, quelling the fears of some database admins. News
-
Making Sybase database upgrading easier with 'A Practitioner's Guide to upgrading to Sybase ASE 15'
Learn more about the nuances of the upgrade to Sybase ASE 15 in this Q&A with a veteran Sybase expert and author of 'A Practitioner's Guide to upgrading to Sybase ASE 15.' Tip
-
Oracle to Sun open source users: Don't worry
Oracle promised to continue Sun Microsystem's open source commitment for MySQL, Open Office, and Solaris but open source users are skeptical. Article
-
Oracle's MySQL buy shifts open source database market
Concerns about the fate of MySQL under Oracle ownership impacted the open source database market, with users increasing PostgreSQL adoption over MySQL. Article
-
Users cautious on Red Hat's stake in EnterpriseDB
Red Hat stake in EnterpriseDB called good strategy but users say impact depends on outcome of Oracle/Sun merger and the fate of MySQL. Article
-
EnterpriseDB says open source database saves big bucks
Open source databases have come a long way, offering potential savings and freedom from vendor lock-in. Article
- See More: All on Open source databases
About Open source databases
Open source databases offer companies increased flexibility in their database architecture as well as the potential for reduced costs compared with commercial database alternatives. And the open source database market offers several variants. Whether you use PostgreSQL database, MySQL, Oracle, SQL, Sybase, Firebird or MaxDB, the news, tips and advice in this section on Linux databases are designed to keep IT managers up to date on the latest Linux-compatible databases. This section also covers MySQL development, open source command-line tools for open source database management, MySQL management, PostgreSQL management and, given the Sun Microsystems acquisition by Oracle, how such market changes affect the fortunes of other open source database vendors. This topic also covers open source database upgrades, graphical reporting tools, stored procedure languages, database management and open source licensing.