Welcome to Squishdot Squishdot How-To Newbies Websites
 about
 search
 post article
 Documentation
 Mailing Lists
 Bug Tracking
 Development
 Installation
 Upgrading
 Download
 admin
 rdf

 main


Squishdot on RDMBS such as MySQL?
Squishdot Posted by Seo Young-Jin on Saturday February 10, 03:31PM, 2001
from the dept.
I install Squishdot on my home page. It works well. :) But already I had some postings with other software. I want to migrate thie mysql based data to squishdot. But squishdot uses its own time value and Persistent storage...

Is there any RDBMS-based squishdot?

<  |  >

 

Related Links
  • Articles on Squishdot
  • Also by Seo Young-Jin
  • Contact author
  • The Fine Print: The following comments are owned by whoever posted them.
    ( Reply )

    Re: Squishdot on RDMBS such as MySQL?
    by Chris Withers on Sunday February 11, 03:32PM, 2001
    There isn't an RDBMS-based version of Squishdot, I can't really see the point of it.
    Squishdot uses Zope's Object Database, not it's own ;-)

    As for importing your old postings, you should be able to hack something up pretty quickly with a ZSQL method and a python script that calls Squishdot's addPosting method.

    If you give it a go and get stuck, drop a mail to squishdot@egroups.com and I'll see if I can help.

    cheers,

    Chris
    [ Reply to this ]
    • Re: Squishdot on RDMBS such as MySQL?
      by Kurt Bollacker on Saturday February 24, 02:40AM, 2001
      Squishdot is amazing, but the real reason to use a
      RDMBS is simply scaling. What happens when you want to:

    • Exceed the 2GB file size limit in Linux (and you can't upgrade to the 2.4 kernel)?
    • Want to migrate the discussion groups to/from Squishdot?
    • Want an easy method of separating the backup/restore of Squishdot from the back/restore of the rest of your Zope installation?
    • Start reaching 100,000s of messages?
    • want to link squishdot data with tables already in MySQL?

      As a stopgap, it looks like I may have to hack together a custom backup/restore facility simply to implement backups.

      Comments are welcome.

    • [ Reply to this ]
      • Re: Squishdot on RDMBS such as MySQL?
        by Chris Withers on Monday March 19, 06:42PM, 2001
        Exceed the 2GB file size limit in Linux (and you can't upgrade to the 2.4 kernel)?

        Partioned FileStorage or Berkley DB storage, which is being touted by DC

        Want to migrate the discussion groups to/from Squishdot?

        I'd write an External Method that did the importing, then you can get posts from anywhere... someone did one to suck in messages posted to yahoo ;-)

        Want an easy method of separating the backup/restore of Squishdot from the back/restore of the rest of your Zope installation?

        No reason why you can't just take a .zexp of the Squishdot Site object, that's a pretty good backup ;-)

        Start reaching 100,000s of messages?

        Berkley DB or, perhaps, Oracle Storage. I did't say it when I mentioned these before, but they are still ZODB, they just change the ZODB from being stored in a flat file (FileStorage)

        want to link squishdot data with tables already in MySQL?

        Hmmm, that's not something I'm interested in taking Squishdot to, I'd go the importer route

        As a stopgap, it looks like I may have to hack together a custom backup/restore facility simply to implement backups.

        As you please...

        cheers,

        Chris


        [ Reply to this ]
    Re: Squishdot on RDMBS such as MySQL?
    by Unanimous Howard on Monday February 26, 10:40PM, 2001
    Is the 'squish' in Squishdot a not-so-subtle hidden reference to grits?

    Just curious!
    [ Reply to this ]
    • Grits?
      by Chris Withers on Tuesday February 27, 08:48AM, 2001
      Dunno, sorry, before my time :-S

      What are grits anyway?

      Chris - from the UK ;-)

      [ Reply to this ]
      • Re: Grits?
        by Darrick Wong on Wednesday February 28, 02:48AM, 2001
        Grits...several definitions. Sharp, hard granules of rock or sand...the quality of stone that suits it to grinding...or firmness of mind and spirit.

        I've also heard of the word being used to describe coarse food. <cough>collegecafeteriafood<cough>

        As for any relation to 'squish', I don't know of any. Perhaps the original poster would care to enlighten us?

        [ Reply to this ]

     
    The Fine Print: The following comments are owned by whoever posted them.
    ( Reply )

    Powered by Zope  Squishdot Powered
      "Any system that depends on reliability is unreliable." -- Nogg's Postulate
    All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest ©1999 Butch Landingin, ©2000-2002 Chris Withers.