Jeff Duntemann's Contrapositive Diary Rotating Header Image

software

Open-Source Database App Builders

Some folks I know are asking me something I can’t answer: What are people using these days to build small-scale client-server GUI front ends? They have an app created with FileMaker Pro years back that they want to re-create. The catch is this: They want it to be built with something cheap (ideally open-source) and widely used, so that one person isn’t stuck supporting it forever.

The number of records in typical use is not high; from what I can tell, fewer than three hundred in the largest table. There are eight or ten tables, depending on how you slice up the database. There is a need for a certain amount of scripting in addition to table indexes and relationships. The app doesn’t have to scale. Again, 300-500 records is probably as many as the main table will ever need to hold. The database itself must reside on a server, accessible over the Internet from the front end, which will be on laptops and/or desktops.

I used to do things like that in Delphi, and have done simple apps for local tables in MS Access. Access is not cheap, nor is Delphi, and few people are learning Delphi anymore. Lazarus could work, but again, the real question is what’s out there that a lot of people use so that expertise is easy to find.

I wasn’t even aware that FileMaker was still being sold. I haven’t seen it since I had a review copy at VDM circa 2000. Did anyone ever create an open-source equivalent? A quick look around failed to spot one. Any insights?

Why I Like Old Software

I still use Office 2000. I still use Visio 2000. I still use InDesign 2.0. I still use VMWare Workstation 5. Hell, I still use Windows XP. Am I lazy? Am I cheap? Am I nuts? No, no, and hell no. Every piece of software I use is the result of a calculated decision and a certain amount of research. I am by no means averse to paying for software, and I do so regularly. But I don’t always upgrade, especially if the upgrades cost money and/or deliver 80% of their value to the vendor. By that I mean software designed to win what I call “pip wars” (feature-comparison charts on review sites) or place new restrictions on installation and use ostensibly to limit piracy. (Mostly what anti-piracy features do is massage titanic corporate egos.) There are loads of people who will stand there drooling in wait of the next major release, money in hand, never suspecting that the largest single reason for the upgrade is to keep the revenue stream flowing.

The longer I use my Old, Old, Software, the better I like it. Here are a few reasons why:

  • It’s already paid for. The longer I use it, the more hours of use I get for my buck.
  • By and large, old software (at least pre-2002 or so) doesn’t activate. The benefits of activation flow entirely to the vendor, at least in circumstances where the benefits are not entirely imaginary. Most of the time, they are. Activation delivers nothing but annoyance and occasionally downtime to the end user–and in doing so, trains many otherwise honest users to be pirates.
  • Old software is smaller and faster on new machines. Bloat is real, even if it’s not the result of fighting pip wars somewhere. Office 2000 seems almost supersonic on my quadcore, doubly so on my quadcore from my new SSD.
  • Old software respects the skills I’ve developed over the years. Most of the changes I’ve seen across major upgrades are gratuitous, and don’t add any value over the old versions. UI changes in particular had better deliver spectacular new value, because while I learn them they slow me way down.
  • Tutorial books on old software can be had for almost nothing. I routinely buy books on early-mid 2000’s software for $5 or so…books that had original cover prices in the $40-$50 range. Many of these books are unused remainder copies that are essentially new.
  • The argument I hear when I make this point mostly cook down to, Isn’t it eventually obsolete? That depends on what “obsolete” means. Backward compatibility is usually retained, because people rebel when it isn’t. (Windows 8? Are those peasants carrying registered torches and pitchforks?) The only significant thing that Word 2000 doesn’t do is handle docx files. I bought Atlantis to convert any docx files I might need to keep on hand. (Atlantis also creates extremely clean epubs.) Word 2000 is weak on PDF skills, so I bought PDF Xchange Pro to handle that, and as a bonus eliminate any need for the exploit farm we know as Adobe Reader.

I do upgrade software when I see a need. Windows XP eventually replaced Win2K here, even though it activates, because it had certain things I eventually judged useful. I’ve purchased InDesign three times, because I make money laying out books and the new features were useful, but I stopped when Adobe added their uniquely paranoid activation. (Interestingly, I haven’t felt any compelling need to upgrade since V2.0, and I’m interviewing Scribus.) I dumped Dreamweaver when I wanted to move my Web pages to CSS, because Komposer did CSS as well as I needed it to, for free and without activation. It pains me to say it, but with Delphi pricing now up in four figures (and encumbered by activation) I’ve moved all my Pascal programming to Lazarus 1.0.6.

This last issue is important. Open source has changed a great many things. I used to pay for email clients, including Eudora and Poco Mail. Since I discovered Thunderbird, I’ve stayed with Thunderbird. Why? Email is a mature technology. I’m not sure there’s much innovation left to be wrung from it. This is less true of Web browsers, and I now use Chrome most of the time. But man, what’s new in word processing? What? Lemme think for a second… Hang on, it’ll come to me…

This is a key point: The basic mechanisms of computing are mature. There has been time for the slower dev cycles of open source to catch up with commercial software. The action is out on the edges, in speech recognition, automated translation, vertical markets of many kinds, and niche-y mobile apps. We’re still seeing some useful evolution in Web browsers, but there’s damned little in releases of Office past 2000 that I find compelling. Most of the new features are UI tweaks and useless gimmicks.

Old software still has fizz: The best we could want already is!

Odd Lots

Odd Lots

The Adobe CS2 Copyright Conundrum

People have mostly stopped talking about the link page that Adobe exposed a few weeks ago, allowing the download of an activation-free copy of the entire Creative Suite 2. The page is still there, still wide open, and you no longer even have to sign in to your Adobe account to get it. What they’re up to remains unknown, though the firm has said many times and in many places that the downloads are for customers who already own the software. Adobe turned off the CS2 activation servers late last year, for reasons that remain unexplained. I’m thinking that they did the math and realized (duhhh!) that activation has its costs, and just cutting off paying customers who legitimately need to reinstall will only make those customers hate them, and very likely turn them into pirates.

I’ve said this for years: There’s no better way to teach honest people to be pirates than by “grabbing back” the use of content (software, ebooks–1984, anybody? music, anything) that they’ve already paid for. It’s untested in the courts as best I know, but to me this is very clearly fraud.

So the mystery remains. This morning, a backchannel friend (“backchannel” means email or texts relating to something on Contra) pointed me to all the original used copies of CS2 that can be had on eBay for as little as $40 or $50. He asked if it would be legal to buy one of those copies, which are original CDs in their original packaging, and then download the activation-free images from Adobe and install them.

Good question, and with a lot of questions pertaining to copyright, subject to interpretation. Big software firms have furiously fought the First Sale doctrine on software, and have pretty much won on products that are pure downloads without any physical media. They can deny activation on used software, and claim that it’s their right to do so. Adobe is very fussy about transferring ownership of their licenses, which is one reason I have not upgraded my 2002-era copy of InDesign 2.0. I consider this a sort of “hardass tax” that firms like Adobe seem willing to pay: They don’t get money I would gladly pay for an activation-free product.

Here’s the real question: If I have the original physical CDs for CS2, is my use of the activation-free download images legal? I don’t know. Could Adobe come after me (or anybody else) in court for doing so? There is some way-thin chance that they might, but it would open the gates of Hell upon their heads.

Will I try this? Still thinking. When I come to a decision I’ll let you know.

Odd Lots

  • From the “…And Then We Win” Department: Lulu is eliminating DRM on ebooks published through the site. (I was notified by email.)
  • The Adobe CS2 download link everybody’s talking about (see my entry for January 10, 2013) is still wide-open. If it was indeed a mistake, you’d think they would have fixed it by now. New suggestion: They’re arguing about it. New hope: They’re really going to allow CS2’s general use without charge.
  • I didn’t get the art gene from my mother, but I did indeed enjoy the Museum of Forgotten Art Supplies. I still have my full drafting set in a drawer somewhere, replete with bow compasses, French curves, triangles, and so on. How many years will it be before nobody under 50 has any idea what those are? (Thanks to Jim Rittenhouse for the link.)
  • And while we’re doing peculiar museums, check out this selection of implements from the International Spy Museum. I believe the surplus houses were selling CIA turd transmitters twenty or thirty years ago. Shoulda bought one when I could. As the late, great George M. Ewing would have said: “Forget it, Jeff. Nobody will pick that up.”
  • Strange transmitters you want? From Bruce Baker comes a video link that no steampunker will want to miss: The annual fire-up of the only Alexanderson alternator left in the world, station SAQ in Sweden. From the sparks to the swinging meter needles, it’s just like Frankenstein, only it’s real–and sends Morse telegraphy at 100 KHz or so. No vacuum tubes, and I don’t see any reason why it couldn’t have been in operation in 1890.
  • Every wonder who was behind Information Unlimited? Here’s the guy.
  • Here’s more on how fructose messes with your brain. It’s not just the number of calories. It’s the chemical composition of those calories. Whoever says “a calorie is a calorie” is wrong, and probably has an agenda.
  • It’s almost pointless to link to the first video ever made of a giant squid (since we won’t see the whole thing until January 27) but Ars Technica has a background page that’s worth reading. “Hello, beastie!”
  • The BMI is worse than worthless. But I told you that years ago.
  • Brand fanboys may have low self-esteem. Or they may just be tribalists. Or tribalists may be people with low self-esteem. No matter: Defend no brand but your own. Big Brands can damned well defend themselves.

CS2 Flies In From Adobe’s Left Field

Colds are like…well, you know what colds are like. Right now, everybody has one. I’ve been climbing out of this one now for about six days, and the top is not yet in sight. At least my flu shot worked, or I could have been in lots worse shape. If I’ve been quiet, that’s most of it.

But something remarkable happened yesterday that still has a lot of people scratching their heads. Michael Covington and several other people alerted me to the fact that Adobe had opened a download link to an installable instance of Creative Suite 2 that didn’t require activation. Rumors were thronging like Illinois mosquitoes that Adobe was just turning it loose. This is outside of type for them, let’s say.

The truth is subtler: Adobe is shutting off CS2’s activation servers, and once it does, people who have legitimate licenses to CS2 will not be able to reinstall it after a hard disk crash or whatever. So they’re providing an activation-free instance to those customers.

Why, then, did they put the download links to the installer files right out where anyone could see them? The links have been live for several days and were still live this morning, though the server has been choked here and there by activity that suggests more than just CS2 atavists clicking on the links. One would expect at very least a requirement for users to log into their Adobe accounts to get the install suite, but not so. Any code monkey could suggest four or five other ways to do it that would not present all of CS2 on a platter to the whole world.

Adobe insists that they’re not giving CS2 to everybody. So what’s really going on here? I’ll hazard a guess: They’re afraid of the Gimp, and to a lesser extent, Scribus. I think they’ve been afraid of both programs (and a scattering of others) for a long time. At some point, a bean counter probably did some spreadsheeting and realized that activation support on a long-tail product isn’t worth what it costs, and told the techies to shut it off and send the phone reps home.

Faced with that decision, somebody there may have gotten clever enough to realize that people were leaving the CS plantation for cheaper realms. The Gimp is good enough for most Photoshoppish work, according to people I respect, and if I didn’t already own InDesign 2.0, I’d probably be laying out books in Scribus. I think Adobe may be quietly trying to get more people hooked on the CS product, which is a huge revenue-generator for them. Photoshop is probably the most pirated non-OS in software history, and I wonder if they’re just making CS2 easier to pirate and looking the other way to pull a little pressure off CS6, while allowing the curious to give Creative Suite a go. There are legal reasons why they won’t admit to a strategy like that. Furthermore, as many have said, never attribute to cleverness what is better explained by incompetence. It may just be a booboo. If it is, it’s one of the longest-lived booboos of its sort I’ve ever seen.

I won’t post the link here, out of respect for Adobe’s copyrights. Trust me, you won’t have to flatten your nose to find it. I have only one more point to make: I’d like to buy that software. Yes indeed: Adobe, I’ll give you money! I won’t pay several grand for CS6. But I’ll pay a couple hundred for CS2. Alas, the product is not for sale. So what could be a revenue generator for Adobe is just another gift to the pirates, with people like me who’d like to remain legal looking on enviously.

I respect their copyrights. But still. Dumbasses!

Odd Lots

Odd Lots

Odd Lots

  • Don’t forget the annular solar eclipse that will touch the Southwestern US this Sunday, May 20.
  • From the Words-I-Didn’t-Know-Until-Yesterday Department: Ignorosphere, the region from about 120,000 feet altitude to the lowest stable orbit. (It’s a flip term for the mesosphere.) It’s too high for winged aircraft or balloons, and not empty enough for orbiting spacecraft. Sampling it is difficult (one-shot sounding rockets are all we have in terms of tools) and we know less about it than any other region of near space.
  • After a long conversation on the subject with mobile developer David Beers the other day, I stumbled on an article that drives home the problematic nature of Android app development: There are actually four thousand different Androids. (Maybe more.)
  • I’m seeing more and more videos in, um, bad taste being posted to my friends’ Facebook feeds by something called Socialcam. The suggestion is that those who post have actually viewed the videos, but that’s not true. Socialcam reserves the right to post stuff to your Facebook feed that you have not viewed and have no knowledge of. Tear that damned thing out by the roots.
  • This certainly makes me wish that I liked corn more than I do.
  • An interesting study here adds fuel to the fire over suggestions that keeping a consistent sleep schedule helps you lose weight. I.e., don’t try to “make up” lost sleep on the weekends. Doesn’t work. I’ve been saying this for years, based on a lecture series I took at the Mayo Clinic: Getting five hours of sleep a night will make you fat and kill you before your time. People get angry at me for suggesting that they be in bed, lights-out, between 9:30 and 10 PM if they have to get up at six to get to school or work, but that’s probably what it takes. A handful of people may be able to get by on five or six hours a night. The usual human-traits bell curve suggests that you are almost certainly not one of them.
  • If you remember a speculation I made some time back about dogs and human origins, well here’s another: That dogs helped us drive the Neanderthals to extinction. I’m dubious. My sense is that their lack of dogs allowed the Neanderthals to drive themselves to extinction via dawn raids. Dogs made dawn raids difficult, and so we failed to wipe our own species out. (I haven’t seen any evidence yet that Neanderthals kept dogs, but of course I’m still looking.)
  • If you don’t know what a “zoetrope” is, go look it up before you behold the pizzoetrope, which is essentially an edible animation created by spinning a pizza. Sounds loopy (as it were) but it works.