Blog : Posts tagged with 'databases'

*

On sucking

In which we discuss some design flaws in Lotus Notes


Spent quite a while last night reading Lotus Notes Sucks, a collection of reasons why, as you could probably guess, Lotus Notes sucks. I have to use the thing at work every day, and it is indeed truly awful; but I didn’t really like the site. It lists 80-something superficial bad things about Lotus Notes, without listing any of the truly awful things about it.

Aside from the slightly smug nature of the site – every entry on it ends with “Conclusion: Lotus Notes Sucks”, repeated over and over again with the subtlety of a 10-ton cartoon weight – it’s written solely from the point of view of someone who uses Lotus Notes purely as an email program. That is, to be fair, probably what most people use it for; but that’s not what it is. It’s really a generic data-filing and data-sharing program* that has been shoehorned into an email mould, and doesn’t properly fit. So, all the complaints are fairly trivial ones, and a lot boil down to: “it’s slightly different to Outlook”.

There are some true horrors inside Lotus Notes, if you ever have to do any programming or development work with it. The help files, for example, are all just specialised Notes data stores with a suitable interface on the front. This is completely fine, right up until you have a buggy bit of program code that you want to step through in the debugger.** If you’re running something in the debugger, you can’t access any other Notes data. Which, stupidly, includes the help files. Programmers have no access at all to the help files at the very time they’re most likely to need it.

There are other horrible things too. Things go wrong in unfixable ways. Files can mysteriously corrupt themselves and be unrepairable. If a file is deleted, shortcuts to it can become undeletable. If you accidentally delete half your email and ask your IT people to recover it from a backup,*** then unless IT knows the necessary cunning tricks,**** when you open the backup copy of your mail file Notes will happily go “aha! this is the same datastore, but it’s out of date!” and delete everything in the backup too. Oh, joy. Lotus Notes Sucks doesn’t even mention some non-programming problems that I thought were obvious: you can’t search for empty fields, for example. You can search for documents where Field X contains “wibble”, no problem, but you can’t search for documents where Field X is blank. Well, you can do it if you’re a programmer and you write some code to do it for you, but there’s no way to trick the normal search interface into doing it.

In short, Lotus Notes is a horrible can of worms which will trip you up whenever you try to do something the programmers didn’t think of. So it’s a shame that Lotus Notes Sucks finds so many trivial surface-level problems with the email part of the program, when if you try to do more than just email with it, there are so many deeper faults lurking under the surface.

* it doesn’t really count as a database, if you ask me – I don’t think it’s structured enough. IBM/Lotus like to use the word “database” to refer to Notes data files, though.

** Don’t worry if you don’t understand this. It means: run the program one line at a time so you can spot the point where it goes horribly wrong.

*** Of course, normally, I am the IT person in these scenes, and the deleter is someone in Senior Management

**** Which we do, the second time it happens, of course.

2 comments so far. »

Keyword noise: , , , ,

*

Mythology

In which the Tree of Everything keeps springing to mind


Feeling dark and downtrodden still, and nothing creative has been coming to mind. When I’m home from work, all I want to do is stretch out on the sofa and let my mind idle. When I’m at work, I’m too busy, well, working, rebuilding and reindexing database after database in desperate attempts to shave percentage points off their performance.

When I sit back and let my mind idle, there are usually a few images that float into my head by themselves. Lately, when I relax, I start thinking about yggdrasil, the tree that binds the worlds together. I’m not sure why, but it helps to remind me that everything we do is interconnected.

One comment. »

Keyword noise: , , , , , , ,

*

Trackable

In which we wonder where road safety meets surveillance


The police have come up with a cunning plan to track every car on the British motorway network. Oh, wonderful. I’m an innocent person.* In theory I’ve got nothing to fear from the police. I’m still uncomfortable at the idea of them having 2 years’ records of my travels around the country, though.

A proposed speed-limit crackdown has already been in the news; and cameras tracking you every quarter-mile of your journey would be an ideal tool to do it with. My own belief – which is entirely unscientific, of course – is that I’m a less safe driver when I think the limit is being strictly checked, because I spend more of my time checking the speed needle rather than checking the road.

* well, I tend to drive at 75mph, but that’s all.

3 comments so far. »

Keyword noise: , , , , , , , ,

*

Search this site

*

Contact

E: feedback [at] symbolicforest [dot] com

IM: Ask me if you'd like to know

*

Post Categories

Artistic (118)
Dear Diary (349)
Feeling Meh (48)
Geekery (109)
In With The Old (34)
Linkery (37)
Media Addict (164)
Meta (79)
Photobloggery (94)
Political (113)
Polling (7)
Sub category (19)
The Family (31)
The Office (70)
Unbelievable (53)