Creating a notebook application with OpenOffice and MySQL

EASY NOTEBOOK

Article from Issue 77/2007

Author(s): DMITRI POPOV

You don’t need to be an expert to hook up OpenOffice Writer with a MySQL database.

OpenOffice.org has some powerful features that let you create custom solutions. For example, the Base application supports different database engines, such as MySQL, and it can connect and manage remote databases. The data from the remote database is then available for other OpenOffice.org applications, so you can, for example, access and manipulate database records directly from within Writer.

You can put OpenOffice’s database access capabilities to some creative uses. For example, you may need a tool to informally store your research notes and text snippets. Several ready-made tools provide this capability; however, they do not offer direct integration with Open-Office Writer. If you work in Writer, you may be looking for a simple web-based notebook application that submits data to a database. The versatile OpenOffice ecosystem lets you create such a tool.

Buy this article as PDF

Express-Checkout as PDF

Price $2.95
(incl. VAT)

Buy Linux Magazine

SINGLE ISSUES

SUBSCRIPTIONS

Print Subs

Digisubs

TABLET & SMARTPHONE APPS

US / Canada

UK / Australia

Related content

OpenOffice 2.0 Preview

At first glance,OpenOffice 2.0 might scare current users with a GUI that closely resembles Microsoft’s competitor product. But on closer inspection, the beast turns out to be a beauty.

more »
Oracle Supports MySQL and OpenOffice

Following the European Commission's OK to Oracle's takeover of Sun Microsystems, Oracle has now released a statement from their top management about MySQL and Solaris.

more »
OpenOffice 2.0

After many pre-release versions and preliminary reports, the new OpenOffice has finally arrived.

more »
Open Database Alliance to Save MySQL

MySQL founder Monty Widenius and the Finnish MySQL services and support company Percona have joined forces to create the Open Database Alliance. The intention of the new consortium is to protect the open source status of essential MySQL components.

more »
Installing Joomla! as a local server

more »

comments powered by Disqus

Visit Our Shop

Trial Subscription

Digital Subscription

Subscribe

Direct Download

Read full article as PDF:

Workspace_OOo_with_MySQL.pdf (186.89 kB)

News

Trojan Turns Raspberry Pi into a Cryptocurrency Mining Device

Two trojans in the wild are targeting Linux machines.
Fedora 26 Beta Comes with New Features

The workstation comes with the latest Gnome desktop environment and support for many application build systems.
Raspberry Pi Foundation Merges with CoderDojo Foundation

The two foundations join forces to expand their efforts to reach young people.
Samba Security Hole Patched but Risk is Bigger

Millions of devices that use Samba Server are vulnerable to attacks.
Red Hat Announces OpenShift.io

Red Hat takes its IDE online.
Microsoft Bakes Linux into Windows Server

Microsoft is slowly becoming a Linux vendor.
Fearless Coyote, Linux Kernel 4.11 is Out

The new kernel makes swap implementation more scalable, which will help cloud providers.
Docker Appoints Steve Singh CEO

The new CEO comes from a very strong SaaS background.
Docker Announces Linux Kit and Moby Project

Both projects help organizations build their own containerized systems.
Ubuntu Returns to Gnome as Its Mobile Plans Shatter

Mark Shuttleworth has resumed the position of CEO of Canonical.