Forum Overview :: Deleted Posts
 
Re: I'll try to handle this. Speak his language. by jeep 04/17/2005, 3:50pm PDT
Ray of Light wrote:

jeep wrote:

The rule is: if you're going to do it twice, write a program. You're only going to do this once.


Haha what now? I think "once each, for ten thousand posts" also qualifies for the program.

Ray!


when you export it from postgres, it makes a text file whatever.sql. You can just run regexp replacements on it until it does what you want. For a one-time process of iterating 10000 tiny chunks of text, a text editor with regexp is the "program." I'm a lazy bastard, so I have to know when it's easier to write a script or use a text editor to massage the data. I also have to know when other people wrote stuff to do the heavy lifting for me, even if the apps are cheesy.

Since he's no going to be dealing with the consequences of SB_PG_Crazy.sql more than once, is there really a point to writing an application for it? You'll only ever have one blob of data to do this with. Do you expect anyone here will have to move pgsql -> mysql a lot in the future?

/jeep/
PREVIOUS NEXT REPLY QUOTE
 
If I had caltrops forum code, I could just put it up along with the archive. by Creexul :( 04/14/2005, 9:09pm PDT NEW
    Jesus Fuck NT by Entropy Stew 04/14/2005, 9:57pm PDT NEW
        Yes, you should hurry up and fix everything. :( NT by Creexul :( 04/14/2005, 10:04pm PDT NEW
            You should hurry up and jump up my ass! by Entropy Stew 04/14/2005, 10:13pm PDT NEW
                No and no. by Creexul :( 04/14/2005, 11:51pm PDT NEW
    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 NEW
        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 NEW
            Jesus Fuck NT by Entropy Stew 04/15/2005, 5:51pm PDT NEW
                I'll try to handle this. Speak his language. by Fussbett 04/16/2005, 4:00am PDT NEW
                    Re: I'll try to handle this. Speak his language. by Creexul :( 04/16/2005, 9:51am PDT NEW
                        I don't get it. NT by bink 04/16/2005, 12:01pm PDT NEW
                        Re: I'll try to handle this. Speak his language. by Ice Cream Jonsey 04/16/2005, 12:47pm PDT NEW
                            Re: I'll try to handle this. Speak his language. by jeep 04/16/2005, 10:52pm PDT NEW
                                Re: I'll try to handle this. Speak his language. by Ray of Light 04/16/2005, 11:26pm PDT NEW
                                    Re: I'll try to handle this. Speak his language. by jeep 04/17/2005, 3:50pm PDT NEW
                                Re: I'll try to handle this. Speak his language. by Fussbett 04/17/2005, 2:29am PDT NEW
                                    Re: I'll try to handle this. Speak his language. by Creexul :( 04/17/2005, 3:22am PDT NEW
                                Re: I'll try to handle this. Speak his language. by Creexul :( 04/17/2005, 3:21am PDT NEW
                        I could take an LOA from my job and hand-type them in. NT by Bill Dungsroman 04/17/2005, 10:19am PDT NEW
        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 NEW
            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 NEW
        I think I can help you out, there. by jeep 04/16/2005, 10:25pm PDT NEW
            You probably wouldn't need me to send you the old backup. by Creexul :( 04/17/2005, 3:29am PDT NEW
            Thank you, jeep by Ice Cream Jonsey 04/18/2005, 10:29am PDT NEW
                No problem by jeep 04/18/2005, 8:29pm PDT NEW
                    Re: No problem by Ice Cream Jonsey 04/19/2005, 10:26am PDT NEW
            Re: I think I can help you out, there. by Mischief Maker 04/18/2005, 10:33am PDT NEW
                Re: I think I can help you out, there. by jeep 04/18/2005, 8:31pm PDT NEW
    Blanket response to all "why Postgres?" questions by Entropy Stew 04/17/2005, 2:59pm PDT NEW
        Re: Blanket response to all "why Postgres?" questions by jeep 04/17/2005, 4:14pm PDT NEW
            Re: Blanket response to all "why Postgres?" questions by Entropy Stew 04/17/2005, 4:56pm PDT NEW
        It looks like I owe some people an apology. by Ice Cream Jonsey 04/18/2005, 10:26am PDT NEW
            Like sb? NT by Creexul :( 04/18/2005, 12:08pm PDT NEW
    I tried replacing all them /324/432 whatevers with br tags. by Creexul :( 04/19/2005, 2:51pm PDT NEW
        jeep - don't touch the stuff. This is too fucking funny NT by Entropy Stew 04/19/2005, 2:59pm PDT NEW
            It won't be funny if I get it working. >:( NT by Creexul :( 04/19/2005, 3:07pm PDT NEW
                That it actually the funniest outcome possible NT by Entropy Stew 04/19/2005, 3:11pm PDT NEW
                    IS NT by Entropy Stew 04/19/2005, 3:11pm PDT NEW
                        I gave up, sorry. :( by Creexul :( 04/19/2005, 8:33pm PDT NEW
                            And you're on a browser that can't disable picture display? How unfortunate. NT by Casual observer 04/19/2005, 9:46pm PDT NEW
                                I don't know, I probably am. NT by Creexul :( 04/19/2005, 11:49pm PDT NEW
 
powered by pointy