LibreOffice Version Control

While working on a manuscript, it is a good idea to keep different versions of the document (1st draft, 2nd draft, 3rd draft, etc.) in case you need to go back to an earlier version of your work. Many times this is accomplished by saving the document under a new name. Another approach is using some kind of version control software that allows you to track changes. However, LibreOffice does have a basic version control system built in and contains all the versions in one file. Continue reading

Troubleshooting Christmas Mini-Lights

The Christmas season is upon us. Along with the season comes decorating. With decorating, you have 100′s of little mini Christmas lights. Christmas lights are great when they work, and sometimes troublesome when they don’t. You are likely to run into two different breeds of mini-lights. One that just goes dead causing the whole series of 50 bulbs to go dead, and the newer style that goes dead but allows the others to continue to glow. Continue reading

LibreOffice Base SQL: Altering Tables

So far, we have looked at the different data types and creating tables using SQL in LibreOffice Base with the default HSQLDB database management system. Sometimes when you create a table using SQL, you don’t always get it right the first time, so SQL allows you to alter, or change, the structure and layout of the table. Continue reading

LibreOffice Base SQL: Creating Tables

While LibreOffice allows you to create tables using the GUI, knowing how to create tables using SQL can help you better understand how relational databases work. Once you create a database, you can access the SQL command dialog by Tools > SQL. SQL is a acronym for Structured Query Language and is the standard language for accessing and manipulating databases. Continue reading

LibreOffice Base Data Types

By default LibreOffice Base uses the HSQLDB database management system. Like any database system, HSQLDB has a rich set of data types to choose from when building your database. An understanding of the types and when you might, if ever, use them will help you as you create your tables for your database projects. We will look at five categories of data types in LibreOffice base: integers, floating point, text, time, and other. Continue reading