Everybody who wants to install a web server database but does not know which software is necessary and how it is installed should benefit from reading this text. This text provides all information necessary to get a SQL database for a web server going; it does not go into any detail of CGI programming, nor does it explain the SQL database language. Excellent books are available on both topics, and it is the intention of this text to provide a working platform based on which a user can then study CGI programming and SQL. For getting a small scale SQL system running (not the notorious example of a major airline booking system, or space mission management database) it will be sufficient to have the software described in this text and the documentation accompanying it. The user manual of msql (a database introduced in this text) provides sufficient information on SQL for building your own database.
Read the rest of this entry »

• 0 Comments

This guide will walk you through the setup process and installation steps for eFront version 3.1.3. SiteGround and cPanel were selected as reference, but the procedure is pretty much the same for any hosting provider. The guide assumes you have some experience in using cPanel as well as setting up a domain. For the sake of the examples, we will use the “venakis.org” domain.
Read the rest of this entry »

• 0 Comments

You can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 4.0 at the time of writing.
Read the rest of this entry »

• 0 Comments

SQLYog Enterprise Edition Version 6.55 Review
This software is one of the most popular GUI-based tools for MySQL. Most of the features of the software are geared to help the daily work of DBAs and developers. The software is rich in features and therefore this review will only highlight some of the cool capabilities.

Connection to Remote Servers
Most companies require you to use the ssh protocol to access their servers. While it is easy to setup your own ssh tunnel to connect to your remote database, it is quite cumbersome to do that. SQLYog allows you to easily do this and lets you save your secure MySQL connection. I use this all the time and I do not even think about ssh tunneling anymore.

On the downside, when I tried to connect to another database, the software opened a separate window for me. This made it difficult for me to switch from one window to another. This can be annoying if you want to compare two databases but it could also be a security measure so that you do not accidentally apply the wrong SQL statements to the wrong database.

Download pdf MySQL Magazine

• 0 Comments

In this document, we describe a simple application that keeps track of payments made to client accounts. Setup: The current version of the application is configured to use an HSQLDB database (although connections to a MySQL database and an MS Access database are also included in comments at the beginning of ClientBillingDB.java).
Read the rest of this entry »

• 0 Comments

This document will help a user install FreeBSD 4.7 Release, Snort 1.9.0, MySQL 3.23.53, and ACID-0.9.6b21. It will also guide the user through the process of securing the machine and getting the snort sensor(s) to log to a central database over stunnel. The intention is to give users that are new to any of the software the opportunity to build an enterprise-class system based completely on free, open-source tools. Following the instructions in this document will get you the following:
Read the rest of this entry »

• 0 Comments

This document discusses some general principles in developing database applications using
C#, .NET, and Microsoft SQL Server. We’ll develop a command line database application to manage contacts. General ideas apply to the GUI oriented version—in fact, that’s the homework: To create a GUI version of this thing.

For this whole scheme to work, you need a few tools. These include:
• .NET Framework SDK
• Microsoft SQL Server
Read the rest of this entry »

• 0 Comments