(cardinals33) Ever wanted to combine the power and ease of the .NET platform with a free database like MySQL? Well thanks to ODBC database functions in ADO.NET it’s really easy. All you need is the latest drivers for ADO.NET and MySQL installed. For this tutorial we will use C# to build a simple app
Tag: Open Source
Jajja Communications Optimizes Search Engine Traffic with MySQL Network
Jajja Communications is one of Europe’s leading Search Engine Optimization (SEO) companies. It has clients in 23 countries including Procter & Gamble, H&M, eBay, Dell and IKEA. The company is privately held and has been profitable since it was founded in the year 2000. Jajja Communications today
Logging in Apache
(Tony Mobily) In this chapter I will first explain how to configure Apache for logging purposes, highlighting the most common problems. I will then introduce remote logging using syslogd, the standard logging server that comes with Unix. Finally, I will propose a remote logging solution, which will
Configuring Database Access in Eclipse 3.0 with SQLExplorer
(Deepak Vohra) SQLExplorer is an Eclipse IDE database plugin that may be used to connect to a database from Eclipse. The SQLExplorer plugin adds a graphical user interface (GUI) to access a database with SQL. With SQLExplorer, you can display the tables, table structure, and data in the tables, and
Take advantage of MySQL flexibility with this overview of table types
As one of the most advanced open-source RDBMS currently available, it’s no surprise that MySQL can store data using a variety of different table formats. Indeed, the only surprise is the sheer number of table formats – as of MySQL 4.1, the RDBMS supports no fewer than eight different table formats.
Chapter 5: Joins, Temporary Tables, and Transactions
(Jon Stephens and Chad Russell) In this chapter, we’ll discuss three additional features you can use to speed up your MySQL applications. While these aren’t directly related to one another, each represents an opportunity to decrease the amount of database or code overhead required to perform useful
A Database Journal Guide to MySQL Certification: Part 2, Professional Certification
(Ian Gilfillan) Last month we looked at the MySQL Core certification, aimed at MySQL users and developers. For people wanting to go even further, there is another MySQL certification – the MySQL Professional certification, aimed at database administrators. The Core certification is a prerequisite fo
The Advantages of Adopting Open Source Software (Sample Chapter)
(Jason Williams, Peter Clegg and Emmett Dulaney) Before you commit to the adoption of open source, Critical Thinking 101 mandates that you ask the question, “Why?” This section attempts to answer that question from a variety of perspectives. Open source has impact not just for developers and in-hous
First Steps with Java Struts
(John Topley) Just over a year ago, I started to learn how to use the Jakarta Struts J2EE Web application framework. During this journey, I realised that I found some aspects of Struts confusing at first, and that many other developers might well suffer the same difficulties. This article is an atte
Install OpenBSD to Secure Your Web Server
(Gregory L. Magnusson) Designed to be “secure by default”, the OpenBSD server operating system offers comprehensive security features. Learn how to perform a network install of this OS—along with PHP4 and MySQL—to keep sensitive data protected.