Submit your comments on this article |
Today's tech notes... |
2007-06-06 |
I'm in the process of migrating the comments from MySQL to Postgres, which is a more robust database. Right now we're making two copies of each comment, one to each database, while I copy the old comments a month at a time. Occasionally things will get out of synch, but I'm hoping they'll be brought back to where they're supposed to be when the process is done. Once I've moved the comments, which is the largest table, I'll move the articles. When they've been moved, I'll shut down MySQL. If Postgres isn't robust enough to handle the load -- which it should be -- I can always use Oracle. I'll just have to rewrite major chunks of my code, rather than the minor chunks I'm dealing with now. |
Posted by:Fred |
#25 It's still shaky. |
Posted by: Fred 2007-06-06 22:03 |
#24 Nice to see the site back up, I was starting to get the DT's. |
Posted by: Grumenk Philalzabod0723 2007-06-06 19:09 |
#23 Well, that's settled, at least. Anon5089 #21 & 22 wins the thread! :-D #21 is definitely ROFLMAO. Ya' got talent, 50. [I can call you 50, right, seeing as to how we're friends and all? ;-p] |
Posted by: Barbara Skolaut 2007-06-06 18:13 |
#22 |
Posted by: anonymous5089 2007-06-06 15:43 |
#21 |
Posted by: anonymous5089 2007-06-06 15:43 |
#20 http://www.lileks.com/nothere.html |
Posted by: mojo 2007-06-06 15:37 |
#19 regarding 404s From bash.org : http://www.bash.org/?120296 |
Posted by: bombay 2007-06-06 13:44 |
#18 Fred, something interesting popped up here (#2). |
Posted by: trailing wife 2007-06-06 12:06 |
#17 I got one yesterday that addressed me by name (TRAILING WIFE, all in caps, no less -- I don't know whether someone was being emphatic or case sensitive, or what). Quite unnerving. That's nothing. Early yesterday morning, one 404 page laughed at me, mocked my penis, and bitchslapped me. I felt very inadequate. |
Posted by: anonymous5089 2007-06-06 11:04 |
#16 While we're talking technicalities, there's a minor bug I talked about a couple of days ago : when one wishes to use the two po*rn pics found in ye ole RB Stash'o pics, the "po*rn" and the "po*rno-jeremy", even when there's just the code for the pic and no text, the words-filter delete the entry, and so, the two pics are basically unusable, which is a shame. I don't suggest altering the words-filter or anything, just to rename the pics. |
Posted by: anonymous5089 2007-06-06 11:02 |
#15 I got one yesterday that addressed me by name (TRAILING WIFE, all in caps, no less -- I don't know whether someone was being emphatic or case sensitive, or what). Quite unnerving. |
Posted by: trailing wife 2007-06-06 11:01 |
#14 Loves me some 404, baby. Maybe we could dress it up as long as it's decided to move in. "This page has gone 404, infidel! The page you requested will return insh'allah." |
Posted by: Seafarious 2007-06-06 10:54 |
#13 I'll try and fix it today. I know where the problem is, just have to think about the solution. |
Posted by: Fred 2007-06-06 10:26 |
#12 Oracle Aplication Server running on Linux interfacing with a separate Oracle database server also on Linux. Then you could do the code in PL/SQL. I know, it's easy for me to say and in reality it would be a heck of a lot of work. But it would be robust. Keep up the good work and keep smiling and it'll piss 'em off all the more. |
Posted by: treo 2007-06-06 10:23 |
#11 Bug reports : the number of comments are only reported for page 1; page 2 and following only have the name of the first commenter. |
Posted by: anonymous5089 2007-06-06 09:03 |
#10 And oracle is the devil for code work. Keep it up fred! |
Posted by: DarthVader 2007-06-06 08:08 |
#9 Test... |
Posted by: Dave D. 2007-06-06 07:26 |
#8 Because of the amount of code I'd have to rewrite. |
Posted by: Fred 2007-06-06 07:04 |
#7 Why not just go straight to Oracle? |
Posted by: Bright Pebbles in Blairistan 2007-06-06 06:52 |
#6 Top work lad. |
Posted by: Howard UK 2007-06-06 06:22 |
#5 Top work lad. |
Posted by: Howard UK 2007-06-06 06:21 |
#4 Hang in there, Fred. I'd like to say something corny like 'the free world is depending on you', but that's a given. :) |
Posted by: Phineter Thraviger 2007-06-06 01:48 |
#3 Yesterday I got in once via a Google Image search for "curly toed slippers" (don't ask). The first page of results had a July 2006 copy of the Defender-Scimitar and Times Picayune. Click on the pic, click on the googlecache, bada bing! I'm in. LOL. |
Posted by: Seafarious 2007-06-06 01:41 |
#2 we'll go with flo just let us kno. |
Posted by: RD 2007-06-06 01:02 |
#1 I'm sorry that you're having to deal with such a mess. It is much appreciated for all that you do to bring us Rantburg. Thanks, and I wouldn't mind registering either, if that would help. |
Posted by: Jan 2007-06-06 00:41 |