|
|
| |
Forum Overview
::
Deleted Posts
|
| |
|
by jeep 04/16/2005, 10:25pm PDT |
|
 |
|
 |
|
It just so happens that I have 10 workstations at my office with beardy guru linux on them, and they each have either postgresql, mysql, or oracle installed. It is not trivial to manipulate that much data, but I'm guessing from a technology standpoint I'm in a better spot to fix this than most. I am by no means a programming guru, but I know my way around perl and python, c and java, and more importantly: I know how to extract and manipulate whole databases full of data, since we're constantly moving all or part of our 50 years' worth of records from one server to the next.
Ice Cream Jonsey wrote:
The database is in Postgresql. The database option supported for this host and for 99% of all webhosts is MySQL. If you would like this thread to become entertaining ask why SB picked Postgresql over MySQL and the processor wars can start hotting up.
Postgresql is more secure and performs better under load (like say if you decided to change the front page color to edgy black and an avalanche of former voodooextreme readers showed up). Postgresql is also compliant with a lot more standards than mysql, which is usually considered a child's toy by serious developers, and PGSQL is the database shipped with Red Hat Enterprise Linux (under the pseudonym Red Hat Database). However, mysql is great for websites that spend their time pushing text around. SB chose postgresql because he liked BSD and postgres was developed by the same people way back before he was born. Also: he was very...security-conscious, and gawd knows we wouldn't want the government to find out his secret plans to get married, move to Boston and play Star Wars Galaxies.
Ice Cream Jonsey wrote:
There does not exist -- as far as I've found -- a software tool that will take a Postgresql database and export it into MySQL format. I've been looking for a couple months and not uncovered anything. So a tool needs to be created that will accomplish that.
Not really. This is going to sound really cheap - and it is - but so far the easiest way to move the non-critical data we store has been phpmyadmin and pgsqladmin. Since I'm a lazy fuck, I install these two things on the workstation I'm sitting at, use one to export everything to whatever approximates ANSI SQL, then use the other to import it, watch the website explode, then tweak the exported sql by hand until it works. It's a little tedious, but me and the techs are pretty good with replacement regexps since we do this all the time.
As the nominal sysadmin, I also have the ability to make it convenient for #1 Cable Soul Brother to transmit the data from/to wherever. So I'm at this location and I figure I'm going to need a copy of the old database, a copy of the new one, a copy of the web code, and about a week, maybe two if crisis interferes, at the end of which I can hand you the old database data in a seamlessly importable format. It would be great to do something that isn't "for the betterment of mankind" or whatever my job is. Or you can just take care of it. Seriously, one fast linux desktop with both rdbms, apache and the two phpadmin tools and you're already halfway done...or I'm already halfway done, since I'm sitting at one now.
/jeep/
...and no, I won't GPL the forum code chet stole from "Building Websites With PHP and MySQL." The respective secret shame of everyone who has ever developed for this code is safe with me. |
|
 |
|
 |
|
|
|
| |
If I had caltrops forum code, I could just put it up along with the archive. by Creexul :( 04/14/2005, 9:09pm PDT 
Jesus Fuck NT by Entropy Stew 04/14/2005, 9:57pm PDT
Yes, you should hurry up and fix everything. :( NT by Creexul :( 04/14/2005, 10:04pm PDT
You should hurry up and jump up my ass! by Entropy Stew 04/14/2005, 10:13pm PDT
No and no. by Creexul :( 04/14/2005, 11:51pm PDT
Re: If I had caltrops forum code, I could just put it up along with the archive. by Ice Cream Jonsey 04/15/2005, 12:25am PDT
Re: If I had caltrops forum code, I could just put it up along with the archive. by Creexul :( 04/15/2005, 12:44am PDT
Jesus Fuck NT by Entropy Stew 04/15/2005, 5:51pm PDT
I'll try to handle this. Speak his language. by Fussbett 04/16/2005, 4:00am PDT
Re: I'll try to handle this. Speak his language. by Creexul :( 04/16/2005, 9:51am PDT
I don't get it. NT by bink 04/16/2005, 12:01pm PDT
Re: I'll try to handle this. Speak his language. by Ice Cream Jonsey 04/16/2005, 12:47pm PDT
Re: I'll try to handle this. Speak his language. by jeep 04/16/2005, 10:52pm PDT
Re: I'll try to handle this. Speak his language. by Ray of Light 04/16/2005, 11:26pm PDT
Re: I'll try to handle this. Speak his language. by jeep 04/17/2005, 3:50pm PDT
Re: I'll try to handle this. Speak his language. by Fussbett 04/17/2005, 2:29am PDT
Re: I'll try to handle this. Speak his language. by Creexul :( 04/17/2005, 3:22am PDT
Re: I'll try to handle this. Speak his language. by Creexul :( 04/17/2005, 3:21am PDT
I could take an LOA from my job and hand-type them in. NT by Bill Dungsroman 04/17/2005, 10:19am PDT
Re: If I had caltrops forum code, I could just put it up along with the archive. by Mischief Maker 04/16/2005, 9:23am PDT
Because it's the best, if you're a huge fucking dork. That's just a guess. NT by Fullofkittens 04/16/2005, 11:55am PDT
I think I can help you out, there. by jeep 04/16/2005, 10:25pm PDT
You probably wouldn't need me to send you the old backup. by Creexul :( 04/17/2005, 3:29am PDT
Thank you, jeep by Ice Cream Jonsey 04/18/2005, 10:29am PDT
No problem by jeep 04/18/2005, 8:29pm PDT
Re: No problem by Ice Cream Jonsey 04/19/2005, 10:26am PDT
Re: I think I can help you out, there. by Mischief Maker 04/18/2005, 10:33am PDT
Re: I think I can help you out, there. by jeep 04/18/2005, 8:31pm PDT
Blanket response to all "why Postgres?" questions by Entropy Stew 04/17/2005, 2:59pm PDT
Re: Blanket response to all "why Postgres?" questions by jeep 04/17/2005, 4:14pm PDT
Re: Blanket response to all "why Postgres?" questions by Entropy Stew 04/17/2005, 4:56pm PDT
It looks like I owe some people an apology. by Ice Cream Jonsey 04/18/2005, 10:26am PDT
Like sb? NT by Creexul :( 04/18/2005, 12:08pm PDT
I tried replacing all them /324/432 whatevers with br tags. by Creexul :( 04/19/2005, 2:51pm PDT
jeep - don't touch the stuff. This is too fucking funny NT by Entropy Stew 04/19/2005, 2:59pm PDT
It won't be funny if I get it working. >:( NT by Creexul :( 04/19/2005, 3:07pm PDT
That it actually the funniest outcome possible NT by Entropy Stew 04/19/2005, 3:11pm PDT
IS NT by Entropy Stew 04/19/2005, 3:11pm PDT
I gave up, sorry. :( by Creexul :( 04/19/2005, 8:33pm PDT
And you're on a browser that can't disable picture display? How unfortunate. NT by Casual observer 04/19/2005, 9:46pm PDT
I don't know, I probably am. NT by Creexul :( 04/19/2005, 11:49pm PDT
|
|
| |
|
| |
