Quotulatiousness

July 22, 2009

Hurrah for Alex Nolan

Filed under: Technology — Tags: , , — Nicholas @ 18:33

I’ve had a bunch of Microsoft Access database files kicking around for the last several months, but due to version incompatibilities, I’ve been unable to open them. I didn’t want to buy a license for the program, just to pull my data out, so I’d looked for alternative ways to free my data from the proprietary clutches of Access.

I’d tried using Open Office, which includes a database program, but ran into the consequences of my own bad planning: Base (the OOo database component) could open Access files, but couldn’t do anything useful with them if they didn’t have a primary key. Most of my files were pretty basic flat files with a single table, so I’d never bothered to add a primary key (yes, I know: bad database practice).

Base would also let me export individual tables or queries to Calc (the spreadsheet component), but the process seemed pretty dicey — it locked up on me three times as I tried to save a new Calc spreadsheet as a .CSV file. I wasn’t comfortable that all the data in the table had been properly captured in the output, either.

Enter Mr. Nolan’s neat little MDB Viewer Plus utility (downloadable from here). It’s just a simple viewer for Microsoft Access files, but it worked a treat on extracting the tables I needed out of the proprietary MDB format to a .CSV I can import into something else (after this experience, something open source by preference).

Update: Aagh! Not quite as clean as I first thought. It appears that any date that has a value of greater than 12 for the day has been dropped. I wonder if this is an artifact of the difference between British and American usage (D/M/Y versus M/D/Y). Data normalization looks to be a lengthy task after all.

Tinkering with “the engine of poverty”

Filed under: Economics, Politics — Tags: , , , — Nicholas @ 14:42

Jon sent me this link with the comment “Don’t know if the article is bloggable, but I liked the opening salvo”:

Natural disasters can cause enormous human misery, and require massive relief operations, to provide food and medical aid. To cause serious, long-term, grinding poverty, however, you need government involvement.

I have to agree with Jon, the opening to the post is quite good. After digging into some of the examples (the Ukraine under Stalin, Ethiopia in the 70s-80’s, and the US experiment with the “Great Society”), the first point at which an apolitical or undecided reader would say “Now, hold on there . . .”

Of course, the meaning of “poverty” has changed a lot over the years. The poor of the United States have a higher standard of living than the middle class in much of the rest of the world. They also have a higher standard of living than the filthy rich of a hundred years ago, or the crowned royalty of the centuries before that. This improved standard of living has very little to do with the government.

Poverty is something any civilized society wants to reduce and then eliminate, but it never seems to happen. The reason for that, aside from the vast amounts of time, effort, money, and resources being wasted through inefficiency, incompetence, and bureaucratic delay, is that the problem cannot be solved in most countries by definition. Most of the time when people use the term “poverty” they mean relative poverty. For most of the western world, absolute poverty affects a vanishingly small number of people (it’s not gone, but it’s lower than it’s ever been for any civilization in history). Relative poverty, however, is usually linked to a formula (like a set percentage of the average family income), which means that even as individuals’ and families’ financial situations improve, they will still be proportionally lower than the average (which will have improved over the same relative period of time). Statistically, no improvement will appear.

Popular belief, shaped by the official statistics, is that many people live in dire circumstances. Some do, but most who are technically below the poverty line are doing better than the average family from a few decades back. Proportionally, they’re still below the line, but from the standpoint of access to food, shelter, health care, and transportation, they’re better off.

If you are motivated by a humanitarian desire to help the poor – the ostensible mission of much of the modern liberal state – you must realize that nothing helps them more than the increased standard of living and economic opportunity brought about by the private sector.

However, the public perception is quite different: that it is the modern liberal state that has made these improvements against the active resistance of the private sector.

Here, in a nutshell, is the crucial difference between reality and the perception of most voters:

The value of every wasted government dollar must be judged by what free enterprise could have accomplished with it.

Most westerners think that General Motors, Chrysler, and AIG are the perfect exemplars of the free enterprise system, replacing the earlier capitalist icons of Enron and Worldcom.

When you say “capitalist”, most people hear a very different word than the one you’re using. “Free enterprise”, to far too many people, means vast corporations with dozens of legislators (or even legislatures) in their back pockets, using their tame politicians to obtain tax credits, advantageous labour codes, or “eminent domain-ing” their way through neighborhoods. The “private sector” decodes to “rich, secretive plutocrats”.

What you say and what they hear bear very little resemblance to one another. You’re not speaking the same language.

Then, the touching statement of hope:

If the six long months of this Administration serve any constructive purpose, it should be permanently dissolving the illusion that a small group of political appointees can predict what the economy will do, and control it to produce an improved outcome.

Most people, in times of stress, look for that man on the white horse. Most Americans still think they found one.

Further adventures with eBay, now with extra PayPal goodness

Filed under: Economics — Tags: , — Nicholas @ 10:27

Jon had an unhappy experience buying an old magazine on eBay (see here). It apparently got even better, once PayPal entered the picture:

Remember the magazine I told you about? The one with the $12 shipping?

It gets better.

I have a PC Financial chequing account associated with my PayPal account so that I can get money out of PayPal and into my bank. I do not keep any money in this account as I don’t want PayPal sneaking off with anything. Turns out that not keeping money in there was a bad idea.

When I paid for the magazine, PayPal first tried to use the BANK ACCOUNT, rather than my Visa, to pay for the purchase. The transaction was declined by PC Financial and I was charged a $40 NSF fee.

Forty. F**king. Dollars.

I just paid forty dollars to have Galen Weston f**k my ass.

PayPal then went ahead and billed my Visa for the transaction, which I what I expected them to do in the first place.

When the f**k did PayPal change how they fund transactions? They have ALWAYS billed my Visa for purchases — they have NEVER tried to pull the amount from my bank account before. I this something they have changed recently, or what?

Total cost for the magazine so far: $54.19

Expensive magazine! I asked if it was okay to post the follow-on to the original story and he wrote:

Be sure to highlight the bit about Galen Weston and my ass.

I know it’s not really his bank — it’s CIBC — but it’s his brand. Which somehow makes it even more of a rip-off.

Humph.

[. . .]

About funding the account: it turns out that what I experienced is their new default when you have a bank account associated with your PayPal account. I don’t recall being notified of that, so it’s my own damn fault for not reading the fine print, but still — that sort of change in behavior should not happen automatically.

[. . .]

Total cost for the magazine: $56.28.

Oh — on shipping: I looked up the shipping cost for the USPS Flat Rate Envelope the guy used. His surcharge was only $2.00 — the actual postage was, indeed, over ten bucks. Does not really make me feel all that much better, but I guess the guy was not really being a total jerk about it.

Looking for Canadian health stats?

Filed under: Bureaucracy, Cancon, Health — Tags: , , — Nicholas @ 09:59

Kathy Shaidle has some useful advice for Americans who may be looking for information on the Canadian healthcare system.

Up here, the key word in discussions is “wait times”. That’s what we say, when you say “rationing.” The ONLY way for our system to work is to “hope” somebody ahead of you in the line for care dies, and you can take their place. A very cynical, nasty way to run a country, to say the least.

So go to Google.ca (especially the “News” section) and look up “wait times” if you want to get the real Canadian conversation on our health care system.

Lottery winner receives extra prize

Filed under: Cancon, Law — Tags: , — Nicholas @ 08:45

A recent lottery winner in Ontario got an extra on top of the multi-million dollar cheque: a free arrest:

Some guys have all the luck.

That’s what Barry Shell of Brampton likely thought Monday when he went to pick up his nearly $4.4 million jackpot at Ontario Lottery and Gaming headquarters on Dundas St. W.

But after a smiling Shell, 45, had posed for an OLG photo holding his cheque for $4,377,298, he was arrested outside the building on outstanding criminal charges and taken into police custody.

The most interesting part, however, was this statement from the lottery officials:

Asked how a lottery win could result in the discovery of outstanding warrants, Rui Brum from OLG said last night: “A rigorous investigation process is followed any time a prize is claimed.

“Any flags that are raised are immediately forwarded to the OPP Bureau attached to the AGCO (the Alcohol and Gaming Commission of Ontario) for further investigation.”

H/T to Jon, who said “come to attention in the media or in some other way, and the state starts looking into you.”

QotD: Republican government

Filed under: Government, Law, Politics, Quotations, USA — Tags: , — Nicholas @ 00:04

Republican government is impossible in an age where not only are the bills too long for a reasonably engaged citizen to read, not only are they too long for a legislator to read, but they’re too long to write down before they’re passed into law. We just have to trust our rulers, and they just have to trust whichever aides negotiated whichever boondoggles with whichever lobbyists.

Mark Steyn, “Jacksonian America”, National Review, 2009-07-20

Powered by WordPress