22
July - 2014
Tuesday
SUBSCRIBE TO NEWS
SUBSCRIBE TO COMMENTS

Ever Forward

Always discovering, learning, moving… ever forward

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.

Connecting KDE 4 to A Projector or TV

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 […]

Using ltree for Hierarchical Structures in PostgreSQL

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, […]

RECENT NEWS

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 →

Dia or Umbrello for College Database Class?

Posted by donp On January - 31 - 2013Comments Off

I am taking an introductory database class focused on designing databases.  The class uses Microsoft Visio, but the professor has made clear we can use the tools available for our operating system, as long as she can read the diagrams we submit in her chosen tool, Microsoft Office.  Not being sure which design tool would be most suitable, I downloaded both, Dia and Umbrello and tinkered with both for a bit.  Here are my thoughts on which of the two tools works best for this scenario. (more…)  Read More →

My Experience with the ZaTab

Posted by donp On November - 5 - 2012Comments Off

I am now the owner of a ZaTab from ZaReason.  I have long desired to have any of this company’s products, but I now actually have a 10-inch ZaTab running Android 4.0 (a.k.a., Ice Cream Sandwich).  I thought I would share my experience with it – the good, the bad and the ugly – to help those of you considering whether to buy one. (more…)  Read More →

technology

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),... (more...)

lDinero: Importing Transaction History from the Bank

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... (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...)