True, and I'm certainly not putting blame on Postgres, but it would be nice if they had a pg_mysql_import_from_dump as MySQL's compatibility is b0rked.

I see various scripts out there, on Github for example, that claim to aid in the transfer. But it seems the consensus that manual fiddling is required. Perhaps I should make a name for myself by building something that eases the process. A "pg_mysql_import_from_dump" as it were.

I think what's missing is an easy upgrade path from MySQL to PostgreSQL.

For example:

• * mysqldump | psql doesn't work even with --compatibe=postgresql: ints have precision (int(11)) and comments don't work the same
• * Inside psql there isn't a handy "show create table" feature (that I've found)
• * No way to "use dbname" for switching DBs inside psql - must quit and restart with different dbname
• * Issues with double quotes vs single quotes vs ticks - no opinion on which is best way to go but would be nice if a translation were available
• * The commands aren't as easily memorable: \d vs show tables: another area where some compatibility would be nice. I kind of prefer the show tables, show databases, show create table style instead of \d, \l, \(can't do it in psql, use pg_dump)

Those are some things off of the top of my head.

Makes it so much more work to switch - each dumped table must be manually tweaked to load into psql.

I'm playing with it now, and growing more comfortable with psql but not sure I'm going to dump, edit, import all tables in all|any databases so I can have... 2 db servers running on my box.

I'm itching for a good reason to switch.

It's a shame that the new recently that Google is dropping MySQL didn't end with "and they're going to use Postgres" -- they have the resources to make a conversion suite / patches that would make it easy for a large scale adoption to occur.

Hang on a second. I read a page and a half of his / her posting history, and that's not a shill. I'm throwing away the mod points I've used in this thread to correct the unfair accusation. And, for the record, I hate MicroSoft (and Apple, and am very wary of Google).

I thought you'd uncovered one of those guys from a year or two ago that always got a lengthy first post on any MS or Google story with gushing, orgasmic MS-will-save-the-world or Google-will-destroy-western-civilisation diatribe.

This guy, MaWeiTao, has plenty of posts that have nothing to do with MS what-so-ever.

And in those that do refer to MS, things like:

I agree that Ballmer needs to go; Microsoft does have some fundamental problems. However, I take issue with how you dismissive you are of the things on your list. That many of those products have struggled is due more to poor perception than actual lack of quality.

Windows 8 may have it's issues but it's a legitimately good OS. Like it or not, it's been incredibly influential for user interface design. Notice that the flat look is in; so much so that even Apple has abandoned skeuomorphics in favor of the look. Windows 8's bigger problem is the persistent bad press.

...

It's difficult to deny that Microsoft doesn't deserve what they're getting. As a Windows Phone user myself I've found myself increasingly disenfranchised what seems like general indifference towards the platform from Microsoft.

are things you may disagree with, but they aren't the words of a bloody shill.

This is likely a better example of a possible shill: http://slashdot.org/~DCTech... They had uids in the 2,500,000 range, lengthy first-posts made at the moment the story went live, subscribers...

(posting to undo accidental troll moderation)

Great - he's the same twunt that claimed that no radiation could possibly survive past the fence enclosing Fukushima - at about the same time the first explosion happened.

His reaction was to say, "Oops, seems a bit worse than I thought", right? No, of course not. Even though there's corium blown a mile and a half from the reactors. Even though there were multiple melt-downs. Even though on-site experts with experience in nuke plants claim they don't know exactly what's going on (unlike omniscient Lewis fucking Page). Even though arguably the most dangerous steps still lie ahead - removal of spent fuel from its pool in the now-reinforced reactor 4 building.

So no, he's a blight on El Reg and I, for one, shall not be reading what his bullshit apologist rantings have to say; I'll remain here in reality and hope for the best with the spent fuel and radioactive water storage.

And let's not forget that reactor 4, where the spent fuel pool boiled / leaked dry, was not in operation at the time of the 'quake / tsunami.

News from reality, instead of from Page's ridiculous pro-nuclear, nothing-can-possibly-go-wrong, ignore-those-explosions ranting:

INADVERTENT CRITICALITY

"There is a risk of an inadvertent criticality if the bundles are distorted and get too close to each other," Gundersen said.

He was referring to an atomic chain reaction that left unchecked could result in a large release of radiation and heat that the fuel pool cooling system isn't designed to absorb.

"The problem with a fuel pool criticality is that you can't stop it. There are no control rods to control it," Gundersen said. "The spent fuel pool cooling system is designed only to remove decay heat, not heat from an ongoing nuclear reaction."

...

Removing the rods from the pool is a delicate task normally assisted by computers, according to Toshio Kimura, a former Tepco technician, who worked at Fukushima Daiichi for 11 years.

"Previously it was a computer-controlled process that memorized the exact locations of the rods down to the millimeter and now they don't have that. It has to be done manually so there is a high risk that they will drop and break one of the fuel rods," Kimura said.

I'll admit I didn't read the *entire* post, but the "without ... firewall" part stuck out to me.

Craigslist put an IP block in place against 3taps. Whether it was with a firewall like iptables or whether it was enacted within the Craigslist software, it seems 3taps' argument has fallen apart already. There was, for all intents and purposes, a firewall in place to block them.

Thanks for the interesting quote.

One minor correction, I don't think it's "neckbeards" that malign Gore, it's the right-wingers. They seem to need to hate everything that isn't part of their tribe and aren't hesitant to make up stuff to hate against.

Dear Everyone,

We're working hard to fix that.

Love,

Stephan Harper

In my understanding, the problem is that the spent shots that sit in waterways contaminate them. They can also be ingested by ducks, fish, etc. Then those critters get eaten and the lead bio-accumulates.

There are different types of mercury with different effects on the body.

TL;DR, except saw this part:

Yeah, that describes private health care perfectly. Not Canadian (nor any other western industrialized country's) health care.

However, if there is only one thing that unites Canadians almost unanimously it is this: no. fucking. private. health. care.

My mom got a hip replacement on our socialized health care, plus ages in hospital with chemo treatments for two different bouts of cancer.

Also has faced 30 years of health complications due to that. It'd have bankrupted our family had they lived less than 200km farther south.

In BC I pay < $200 / month for health care for 2 adults. That's risen >100% in past 10 years. Includes everything but prescriptions and dentists. Unsure about eye-tests; might not be covered.

I get to walk in to clinic, or get booked with specialist professor of medicine at UBC. I walk in, show health card - see doctor, leave. Pay nothing.

Hospital visits are the same.

Waiting times: 7-10 days for specialist dermatologist (fairly urgent). Maybe 2 months for allergenist.

Bad example on the "socialized medicine" angle.

It's the private insurers that one needs to worry about: they'll use your health status to refuse you because they have a profit motive. At least with socialized medicine that doesn't happen.

http://www.healthcare.gov/what-if-i-have-a-pre-existing-health-condition/

Starting in 2014, health insurance plans can't refuse to cover you or charge you more just because you have a pre-existing health condition. Being sick doesn't keep you from getting coverage

Further interesting examples seen via something like this:

https://duckduckgo.com/?q=hmo+pre-existing+condition+refuse+coverage

In fairness, the one about "Authenticity" of the sheepskin covers had a reply with a link showing a cockpit with seemingly-similar seat covers, so I learned something there.

And the one about which software it ran was ok for Slashdot, although the reply to it, "He probably doesn't even know" was snotty.

Great - just because of this post, Slashdot is gonna have to revise their system to allow +10 funny.

Plants need light as least as much as they need warmth.

And vast swaths of terrain in Russia and Canada have very poor light levels during large amounts of the year.

Maybe lettuce and other greens can be grown a 2nd season. Perhaps moss salad will become haute cuisine.

But don't overlook the fact that a lot of the water to irrigate current agriculture comes from snow pack that melts all summer long... So - warmer weather = less snow pack / faster melt might just mean less agricultural productivity. Subterranean aquifers will not capture it all - it'll run off or require a whole lot of dams and new reservoirs.

But the Deniers are too dangerous and short-sighted to laugh at; the very real possibility that things won't magically resolve themselves and serious impacts on humanity can, just maybe, occur.

Nailed it except for the part about marriage having some fundamental meaning, everywhere, until this generation. That is fiction unless it's about procreation, in which case it wasn't necessarily then and isn't now.

And the part about wanting equal rights is an aspect of "the fanatical Left", unless one is so far right that they can't see the centre anymore.