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 »
Installing Joomla! as a local server

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 »

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)

DevOps

Reinvent your network with DevOps tools and techniques:

Opportunities and Risks: Containers for DevOps
Automated Builds Using CentOS 7 and Kickstart
Elasticsearch, Logstash, and Kibana – The ELK stack
Are you ready for DevOps? Try your luck with the beta version of Linux Professional Institute's new DevOps exam.

News

LibreOffice 5.4 Released

Comes with improved support for Microsoft Office file formats.
Red Hat to Drop Support for Btrfs

The company is building their own storage solution called Stratis.
Reinvent your network with DevOps tools and techniques:

Opportunities and Risks: Containers for DevOps
Automated Builds Using CentOS 7 and Kickstart
Elasticsearch, Logstash, and Kibana – The ELK stack
Are you ready for DevOps? Try your luck with the beta version of Linux Professional Institute's new DevOps exam.
Kolab Now Integrates Collabora Online

Kolab Now subscribers now have access to Collabora Online.
Endless OS, a Distribution Without Internet

A new version of Endless OS has been released.
GitHub Announces Open Source Friday Program

They encourage people to take time out and work on open source projects on Friday.
System76 Announces Their Own Distro, Pop!_OS

Pop!_OS is based on Ubuntu and uses the Gnome stack.
Linus Torvalds Talks About His Motivation

He never tires of working on the Linux kernel.
Debian 9 Stretches Its Wings

The new release of Debian has a very strong focus on security.
Trojan Turns Raspberry Pi into a Cryptocurrency Mining Device

Two trojans in the wild are targeting Linux machines.