Google Mail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Generating static pages from database?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Follow-up To:
Add Cc | Add Follow-up to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers that you hear
 
sol  
View profile   Translate to Translated (View Original)
 More options 4 May, 14:46
From: sol <ch.bl...@gmail.com>
Date: Mon, 4 May 2009 06:46:05 -0700 (PDT)
Local: Mon 4 May 2009 14:46
Subject: Generating static pages from database?
Hey,

I used staticmatic a long time ago, so I'm not sure about it's
(current) features...

I need to create static html sites (around 200 000) from a database,
and I would like to use ruby for this - so staticmatic was the first
thing I thought about since I need a template system to easily change
and regenerate everything ... but I remember it needed files
describing the pages...

Is this possible with staticmatic or does anyone have suggestions how
to do this?

Thank you in advance,
Christoph


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Joshaven Potter  
View profile   Translate to Translated (View Original)
 More options 4 May, 15:15
From: Joshaven Potter <yourt...@gmail.com>
Date: Mon, 4 May 2009 10:15:23 -0400
Local: Mon 4 May 2009 15:15
Subject: Re: Generating static pages from database?

Sure its possible.
You can use a ruby module to connect to your database...
http://www.kitebird.com/articles/ruby-mysql.html

--
Sincerely,
Joshaven Potter

"No man making a profession of faith ought to sin, nor one possessed of love
to hate his brother. For He that said, “Thou shalt love the Lord thy God,”
 said also, “and thy neighbor as thyself.”  Those that profess themselves to
be Christ’s are known not only by what they say, but by what they practice.
“For the tree is known by its fruit.”" -- Ignatius


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sol  
View profile   Translate to Translated (View Original)
 More options 4 May, 15:44
From: sol <ch.bl...@gmail.com>
Date: Mon, 4 May 2009 07:44:22 -0700 (PDT)
Local: Mon 4 May 2009 15:44
Subject: Re: Generating static pages from database?
Hi,

I meant, how would you create the actual pages?
Just run a script that outputs rows as files into pages/, or is there
a better way?

On 4 May, 16:15, Joshaven Potter <yourt...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Joshaven Potter  
View profile   Translate to Translated (View Original)
 More options 4 May, 21:25
From: Joshaven Potter <yourt...@gmail.com>
Date: Mon, 4 May 2009 16:25:01 -0400
Local: Mon 4 May 2009 21:25
Subject: Re: Generating static pages from database?

It depends upon your circumstances.

What type of data is in the database?  Do you need a static page for each
record?

You said: "I need to create static html sites (around 200 000) from a
database,"

Is that two-hundred thousand sites?  Two hundred thousand pages?

If you need 200,000 pages then I cannot imagine the database not needing to
change regularly... why not use something like Ruby On Rails or Even write
your own framework?

Actually, with that much data, I would imagine that you would be best off
with a framework like Django or Rails.

--
Sincerely,
Joshaven Potter

"No man making a profession of faith ought to sin, nor one possessed of love
to hate his brother. For He that said, “Thou shalt love the Lord thy God,”
 said also, “and thy neighbor as thyself.”  Those that profess themselves to
be Christ’s are known not only by what they say, but by what they practice.
“For the tree is known by its fruit.”" -- Ignatius


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sol  
View profile   Translate to Translated (View Original)
 More options 4 May, 21:36
From: sol <ch.bl...@gmail.com>
Date: Mon, 4 May 2009 13:36:54 -0700 (PDT)
Local: Mon 4 May 2009 21:36
Subject: Re: Generating static pages from database?
Hi,

Sorry for not beeing too specific, I'll explain it:

The reason I want static sites that can be re-generated if needed, is
mainly serving speed
and that the database does not change very often (the pages are hosted
on some old internal machine).

I have a lot of similar pages that are constructed from various linked
tables, so basically one large row.

Since this data is pretty much static, we decided we just generate a
bunch of static sites, which are indexed
and searchable by a crawling machine.

To simplify it, I have a table where each row is a site, and I want to
create static pages out of it.
I could of course write a script that just outputs all this into .html
files using erb, but I want to reuse something that gives me
a little more power for linking, templates etc, like staticmatic.

So, I wondered how you would do something like this, for example with
staticmatic (or maybe there is something more suitable for this task,
just wanted to ask)

Thanks for the input,
Christoph

On 4 May, 22:25, Joshaven Potter <yourt...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google