Apr 25, 2009 GMTWe all have our area of expertise, but how can you actually convert your knowledge into an accessible and searchable form? To do this, you need software that allows you to create and maintain knowledgebases -- something like Piggydb. Piggydb comes as a single .zip archive which contains everything you need to get started. Unpack the archive, switch to the resulting directory in the terminal, execute the sh run.sh command, and Piggydb is ready to go. Point your browser to http://localhost:8080 and log in using "owner" as both the user name and password. You can then start populating the database with entries (called fragments in Piggydb) by clicking on the Create a new...
Apr 22, 2009 GMTIdenti.ca may not generate the same buzz as Twitter, but the open source microblogging service based on the Laconica engine is quickly gaining popularity among open source developers, enthusiasts, and casual users alike. While you can post and read status updates -- or dents in Identi.ca's parlance -- using the service's Web front-end, a dedicated client can help you to manage your microblogging activites more efficiently. After trying a few available microblogging tools such as Gwibber and twidge, I finally settled for IdentiFox. It's essentially a tweaked version of the popular TwitterFox extension for Firefox, and as such it offers pretty much the same feature set. It supports...
Apr 17, 2009 GMTAlthough OpenOffice.org Writer can't replace a dedicated outlining application, there are two ways to turn the word processor into a lightweight outliner. The easiest one is to press the Numbering On/Off button in the main toolbar or the F12 key. This turns the current line in the documents into a numbered entry and displays the Bullets and Numbering context toolbar which offers basic outlining tools. The Promote, Demote, Move Up and Move Down buttons in the toolbar allow you to easily rearrange outline entries, while Bullet and Numbering opens the dialog window which lets you tweak different settings such as Numbering type, Outline, Position, etc. You can also create a custom outlining...
Apr 15, 2009 GMTSay you use a simple OpenOffice.org Base database to keep track of your invoices and you want to analyze the invoicing data. One way to do this is to create reports and SQL queries, but this requires skill and a lot of time. Another approach is to pull database records into a Calc spreadsheet and then use Calc's tools to analyze the data. To do this, you have to register the invoice database as a data source in OpenOffice.org. Choose Tools -> Options, select OpenOffice.org Base -> Databases and press the New button. Select then the database and give the new connection a name. Press OK -> OK to save the settings and close the window. Create a new Calc spreadsheet and press...
Apr 10, 2009 GMTWhile OpenOffice.org has always sported the ability to talk to MySQL databases, connecting the productivity suite to the popular database engine wasn't particularly straightforward. Establishing a connection to MySQL involved installing and configuring a connector software, which did require some skills and made the whole idea less attractive. But it seems that you don't have to put up with this situation for much longer. A recent post on the GullFOSS blog has announced the availability of a native MySQL driver for OpenOffice.org. You can download the alpha version of the driver which works with OpenOffice.org 3.1. The blog points out that you should use the stock version of...
Apr 08, 2009 GMTThe Writer's Tools extension for OpenOffice.org developed by yours truly comes with a simple Visual Word Counter tool written using OpenOffice.org Basic. While this tool does the job, it has one serious drawback: once evoked, it doesn't allow you to do anything until you close its window. There are two solutions to this problem: you can either rewrite the macro from the ground up to add a so-called non-modal dialog window (i.e., a window you can keep opened while working on your documents), or you can use an already available Python-based macro from Yawar's Journal. The latter approach, obviously, makes more sense than the former. To make it easier for you, here is the macro in its...
Apr 02, 2009 GMTTime tracking tools are a dime a dozen these days, so what makes timebook so special? Two things: tiny size and simplicity. This command-line time tracking utility requires hardly any resources at all and it's extremely easy to get to grips with. timebook is written in Python, and it's pretty easy to install. Download the archived version of the utility and unpack it. In the terminal, switch to the resulting directory, and run the python setup.py install command as root. Using timebook is also pretty straightforward. The utility uses timesheets for grouping timing sessions. For example, you can create a timesheet called "writing" for all your writing activities using the switch...
Should you trust an online service to store your online passwords?
New B+ board lets you build cool things without the complication of a powered USB hub.
Redmond rushes in to root out alleged malware haven.
New initiative will bring futuristic virtual reality effects to the web surfing experience.
Dyreza malware launches a man-in-the-middle attack that compromises SSL.
New cloud combines worldwide access with local attention to data security.
A first cousin of the recent Heartbleed attack affects EAP-based wireless and peer-to-peer authentication.
FOSS community acts to protect freedom of choice for laptop devices.
Quintessential open source browser shores up its market share with a step toward the proprietary dark side.
Authorities in 16 countries take action against users of the imfamous BlackShades malware tool.