25
October - 2014
Saturday
SUBSCRIBE TO NEWS
SUBSCRIBE TO COMMENTS

Ever Forward

Always discovering, learning, moving… ever forward

Libre AMS Advances One Step Further

In my previous post (opens in new tab) I wrote about creating a database in LibreOffice Base that one can use to compare a variety of products and services.  I am currently calling it the Libre Acquisitions Management System (or LAMS).  Not only that, but I also managed to create a management console that I […]

Using LibreOffice Base to Compare Products and Services

In my work as a Facility Services Coordinator, I frequently need to organize the information in project proposals, bids and quotes into a readable format for my boss and the upper management. The usual routine involves manually setting up new spreadsheets, as each project is so different from the last one. I finally figured out […]

Distributing Your LibreOffice – PostgreSQL Database Across Systems and Users – The Basics

I think it says something about the simplicity of distributing your LibreOffice-PostgresQL database across multiple users and remote systems when I can get off of work, and in just an hour or two of tinkering around (and not much hard experience using LibreOffice Base with PostgreSQL across remote connections), have a working remote connection and […]

I’ll Call It lDinero

If you’ve been reading my blog, you know I’ve been working on a database project to manage my finances – or at least to track my financial transactions.  I started out using PostgreSQL as the back-end “engine” to power this thing.  Now I am taking advantage of LibreOffice Base to create the simple front-end forms […]

SouthEast LinuxFest: What You Missed

I have to say, if you missed the SouthEast Linux Fest, you definitely missed out!  It’s still a small, but growing Fest, and I missed a couple of notable groups this year.  Even so, the speakers and their subjects were fantastic.

RECENT NEWS

Libre AMS Advances One Step Further

Posted by donp On September - 14 - 2014Comments Off

In my previous post (opens in new tab) I wrote about creating a database in LibreOffice Base that one can use to compare a variety of products and services.  I am currently calling it the Libre Acquisitions Management System (or LAMS).  Not only that, but I also managed to create a management console that I think if kind of cool.  O.k., well, you’ll just have to judge for yourself. Let me start by saying that I wanted to divide the project management console into sections.  I originally... (more...)

Using LibreOffice Base to Compare Products and Services

Posted by donp On September - 9 - 2014Comments Off

In my work as a Facility Services Coordinator, I frequently need to organize the information in project proposals, bids and quotes into a readable format for my boss and the upper management. The usual routine involves manually setting up new spreadsheets, as each project is so different from the last one. I finally figured out a good format that we can use to organize the information in our spreadsheets, regardless of project type. But at home, in my free time, I have taken things one step further. I... (more...)

I think it says something about the simplicity of distributing your LibreOffice-PostgresQL database across multiple users and remote systems when I can get off of work, and in just an hour or two of tinkering around (and not much hard experience using LibreOffice Base with PostgreSQL across remote connections), have a working remote connection and able to share with other users.  Frankly, both, connecting remotely and sharing with multiple users, are really dead simple and can be done in less than... (more...)

lDinero: Importing Transaction History from the Bank

Posted by donp On July - 29 - 2013Comments Off

I decided I want to be able to import my transaction history into lDinero to be able to ensure a higher level of accuracy in my records.  Doing so allows me to ensure I’m not forgetting to add transactions like automatic payments or lost receipts.  I religiously enter the printed receipts we bring home, but what if I get a receipt by e-mail?  The import process is really dead simple, so no real problem there.  But how to ensure the transactions will actually match up against the transactions... (more...)

I’ll Call It lDinero

Posted by donp On July - 22 - 2013Comments Off

If you’ve been reading my blog, you know I’ve been working on a database project to manage my finances – or at least to track my financial transactions.  I started out using PostgreSQL as the back-end “engine” to power this thing.  Now I am taking advantage of LibreOffice Base to create the simple front-end forms I need to really be able to interact with the back-end in a friendlier manner than using say, psql.  Don’t get me wrong.  I like psql just fine as... (more...)

SELF 2013 Ltree Slides

Posted by donp On June - 11 - 2013Comments Off

I gave a presentation on using the ltree add-on module for PostgreSQL as an alternative to resorting to adjacency lists, nested sets or the path enumeration model.  If you need category trees and other hierarchical structures, ltree makes things so much simpler.  You can download my Ltree-PostgreSQL slides here (in OpenDocument format – *.ODP):  postgresql-ltree If your office suite does not handle the OpenDocument format well, I suggest downloading LibreOffice. The image below is just a... (more...)

SouthEast LinuxFest: What You Missed

Posted by donp On June - 11 - 2013Comments Off

I have to say, if you missed the SouthEast Linux Fest, you definitely missed out!  It’s still a small, but growing Fest, and I missed a couple of notable groups this year.  Even so, the speakers and their subjects were fantastic. (more…)  Read More →

Connecting KDE 4 to A Projector or TV

Posted by donp On May - 13 - 2013Comments Off

Suffice it to say I have not needed to use a projector with my laptop in a few years. I can’t really say what changed or when, but I’ve used various libre systems over the years, and always seemed to be able to just get up and running whenever I needed to connect my laptop to a projector, I just used a Function+Fn key combination to switch between one of three modes – laptop only, projector only or both. Lately, though, my efforts to use my laptop running Kubuntu just left me frustrated... (more...)

Using ltree for Hierarchical Structures in PostgreSQL

Posted by donp On February - 24 - 2013Comments Off

If you ever need to work with hierarchical structures in a relational database system, I would like to recommend using PostgreSQL with the ltree module.  Trust me, it will save time and nerves both.  It may not cure cancer, but it might help to greatly reduce stress.  For those following my financial transaction database project, I have been trying to use – for lack of a better way of saying it – the “old-fashioned” approach to managing hierarchical structures.  From what... (more...)

Hierarchical Categories in an RDBMS – Summing and Grouping

Posted by donp On February - 13 - 2013Comments Off

Well, I finally figured it out.  Most of you have long forgotten about my struggles with a hierarchical category tree structure in a relational database management system.  After all, it was August of 2011 when I grouched about how difficult it was to come up with what I thought should be a relatively simple query – one that would let me summarize expenses under the umbrella of a 2nd-tier category, where the expense categories can run 3 levels deep. (more…)  Read More →

technology

Libre AMS Advances One Step Further

In my previous post (opens in new tab) I wrote about creating a database in LibreOffice Base that one can use to compare a variety of products and services.  I am currently calling it the Libre Acquisitions Management System (or LAMS).  Not only that, but I also managed to create a management console... (more...)

Using LibreOffice Base to Compare Products and Services

In my work as a Facility Services Coordinator, I frequently need to organize the information in project proposals, bids and quotes into a readable format for my boss and the upper management. The usual routine involves manually setting up new spreadsheets, as each project is so different from the last... (more...)

travel

Perú Trip – General Observations

I thought I would add some general notes about our trip to Perú.  This isn’t so much a story as it is a collection of observations, for those who might have an interest in traveling to Perú at some point.  This is about traveling to and from, as well as in Central Lima. (more…)  Read More →

Visiting the Presidential Palace

We woke up early Saturday and went into Central Lima to visit the Presidential Palace.  We saw the changing of the guard, performed this time by the Peruvian Marines, and even a little something extra. (more…)  Read More →

hobbies

Photos: Orchids and Stowe Botanical Gardens

I did two different photo shoots this weekend.  First, Maty and I went to Daniel Stowe Botanical Garden on an invitation Saturday evening.  Then I did a separate shoot of an orchid. (more…)  Read More →

Toying With Aperture and Shutter Speed

As I have previously mentioned, I am learning to put a little more thought into the photos I take.  I have managed to take quite few pretty darned good photos over the years, but I see some of my shots might have turned out better, or at least a little differently, if I had put more thought into the... (more...)

language

Brash es tu administrador de basura por Bash

No borras tus archivos!  Puedes guardarlos!  Brash es un administrador de basura por el shell Bash.  Puedes descartar tus archivos en la basura, restaurarles y ver que tienes en la basura.  Hay programas de basura por el GNOME y KDE, pero falta algo bueno por el Bash.  Ahora, Brash es el programa... (more...)

Of Ardillas y Rodillas

Yet another Spanish pronunciation goof.  Imagine that just a week ago you learned the Spanish word for squirrel, which is ardilla.  Now imagine that you are currently walking along the sidewalk or footpath and you – wanting to show off your great Spanish skills – decide to point out one... (more...)