(W. Jason Gilmore) Hasta la revolución! Any doubt about the growing influence of open source should be erased by Microsoft’s recent capitulations in the field. Even the Redmond, Wash.-based software giant is now making friends with open source software vendors like SugarCRM and getting involved,

The purpose of this handout is to give you mini-example of the different types of joins we covered in class using two tables. We will illustrate cross join, inner join, left outer join, right outer join, and the full outer join. For this example, I used MS Access (the screen shots look much nicer t

(David E. Wheeler) One of the most powerful features of PostgreSQL is its support for user-defined functions written in various programming languages, including pure SQL, C, Perl, Python, and PHP. Perhaps the most common programming language for PostgreSQL functions, however, is PL/pgSQL (don’t ask

(le quang anh – leadershipqa) This article is about creating Crystal Reports using Visual C#.NET and MySQL. We all know that MySQL is an open source DBMS and .NET Framework is free. We have used MySQL and Visual Studion.NET 2003 in developing some of our projects with the help of MySQL Connector .NE

(Jon Stephens and Chad Russell) Unnamed views became possible in MySQL 4.1 with the inclusion of subselects that allow for the use of derived tables. Beginning with version 5.0.1, MySQL includes support for named views, usually referred to simply as “views.” Before we demonstrate how these are imple

(Jay Greenspan) In Lesson 1 of this tutorial, you leaned how to approximate transaction-like behavior with MyISAM tables. In this lesson, you’ll see how you can achieve real transactions with each of MySQL’s three transactional table types: BDB, InnoDB, and Gemini. But before I get to specifics surr

(Bernard Golden) Databases are a key piece of every organization’s software infrastructure. They are complex pieces of software that we rely on to rapidly spit out data in response to queries and to reliably track transactions, never losing track of the fact that a payment has been made (or received

(Sarah Lacy) Key to its appeal is the try-it-before-you-buy-it nature of the open source movement. When the software works and it’s easy, it catches on fast within companies and quickly builds a grassroots following. Increasingly, open source designers understand that their audience is counting on t

(Robin Schumacher) It’s amazing in an age where relational databases reign supreme when it comes to managing data that so much information still exists outside RDBMS engines in the form of flat files and other such constructs. In most enterprises, data is passed back and forth between disparate

(Dawn Kawamoto) MySQL has issued a security update to address flaws in its client-server protocol that could allow a malicious attacker to exploit buffer overflow vulnerabilities and gain access to sensitive information.