Sun Report Builder: Better reporting in OpenOffice.org

Posted by suvi under Database, OpenOffice.org

OpenOffice.org Base is
undoubtedly a powerful database application, but when it comes to its
built-in reporting engine, words like "underpowered" and "outdated"
come to mind. Fortunately, you don’t have to put up with this situation
any longer: with the Sun Report Builder (SRB) extension, you can add nifty reporting features based on Pentaho reporting engine — assuming you can figure out how to use it without any help.

No Comments

Using Zotero to manage OpenOffice.org bibliographies

Posted by suvi under Database, OpenOffice.org

If OpenOffice.org’s own bibliography feature doesn’t really cut it for
you, you have several choices. One popular bibliography solution is Bibus,
a cross-platform tool that integrates nicely with OpenOffice.org. It
is, however, not the only bibliographical tool out there. In fact,
there is another nifty tool called Zotero
that turns Firefox into a powerful research tool. More importantly, it
comes with an OpenOffice.org extension that allows you to use Zotero as

No Comments

Creating a free CD or DVD database and labels in OpenOffice.org Base

Posted by suvi under Database, Graphics, OpenOffice.org

If you’re serious about music or DVDs, at some point you cross the
threshold of having more than you can keep track of easily. The box
full of index cards has served its purpose; it’s time to move on to
storing information about your CDs and DVDs in a database.

No Comments

ransform UML to COBOL with WebSphere Developer for System z, Part 1: Create COBOL programs and Web services without writing code

Posted by suvi under Database, Programming

Explore a new feature in Version 7 of WebSphere® Developer for System z™: z/OS Database Application Generator. z/OS Database Application Generator automatically generates CICS® COBOL programs that can access DB2®. It also generates a Web service, as well as the Job Control Language (JCL) to assist in the deployment of the generated code. In this tutorial, you will get a quick introduction to this feature and walk through an example scenario in which you transform UML to COBOL.

In this tutorial

Objectives

No Comments

Manage Your MySQL Database with Rails’ Migrations

Posted by suvi under Database, MySQL

"Over the past ten years, I’ve created and managed perhaps hundreds
of MySQL databases, and in the process have used all manner of tools
for facilitating the process. Among my stable of preferred tools
include PHPMyAdmin, a web-based table and data manager, and even the
MySQL client, a command-line interface that helps you get the job done
quickly and with minimum distraction. Yet I’m a programmer at heart,
and not a database administrator, and accordingly I’ve always thought
there was an unnatural disconnect between code and database management.

No Comments

Getting Started with MySQL Proxy

Posted by suvi under Database, MySQL

The launch of MySQL Proxy has caused quite a commotion in the community. And with reason. For feature-hungry people, this is undeniably the most exciting addition to MySQL set of tools.
If the last statement has left you baffled, because you don’t see the added value, don’t worry. This article aims to give you the feeling of what the Proxy can do.

Get ready for a wonderful trip to Proxyland.

No Comments

Installing Beryl Or Compiz Fusion On A Fedora 7 Desktop

Posted by suvi under Database, Fedora

This tutorial shows how you can install and use Beryl or Compiz Fusion
on a Fedora 7 desktop (the system must have a 3D-capable graphics
card). With both Beryl and Compiz Fusion, you can make your desktop use
beautiful 3D effects like wobbly windows or a desktop cube.

No Comments

Tuning LAMP systems, Part 3: Tuning your MySQL server

Posted by suvi under Apache, Database, Linux, MySQL, PHP, Server, Webserver

Make your MySQL server fly with these server tuning tips

Applications using the LAMP (Linux®, Apache, MySQL, PHP/Perl) architecture are constantly being developed and deployed. But often the server administrator has little control over the application itself because it’s written by someone else. This series of three articles discusses many of the server configuration items that can make or break an application’s performance. This third article, the last in the series, focuses on tuning the database layer for maximum efficiency.

About MySQL tuning

No Comments

Tuning LAMP systems, Part 2: Optimizing Apache and PHP

Posted by suvi under Apache, Database, Linux, MySQL, PHP, Server, Webserver

What slows Apache down, and how to get the most out of PHP

 Applications using the LAMP (Linux®, Apache, MySQL, PHP/Perl) architecture are constantly being developed and deployed. But often the server administrator has little control over the application itself because it’s written by someone else. This series of three articles discusses many of the server configuration items that can make or break an application’s performance. This second article focuses on steps you can take to optimize Apache and PHP.

No Comments

Tuning LAMP systems, Part 1: Understanding the LAMP architecture

Posted by suvi under Apache, Database, Linux, MySQL, PHP, Server, Webserver

How LAMP systems work, how to measure their performance, and how to tune the underlying operating system
   

No Comments