Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,926

The new LGF Pages re-design is now in launch mode, and the first thing you’ll notice is that it looks a lot like the rest of the site. And that’s a good thing.

The old LGF Pages index had its own design, which actually started as a coding experiment way back in the day. Now it’s completely integrated into the design of the rest of LGF.

It’s more than a design integration, though; I also lavished a lot of attention on the plumbing, the MySQL queries that manipulate the LGF Pages database tables. Many of these queries worked very well as long as the whole list of Pages wasn’t too large — but with the number of Pages approaching 300,000, those queries were becoming unacceptably slow. In the lingo, they weren’t scaleable. That’s why I had to take the LGF Pages index offline when we installed our new servers.

Now these queries are very scaleable; I’ve optimized and refactored the queries and the PHP code behind them to make this new version respond much more quickly — again, like the rest of LGF.

If you’re signed in to an LGF account, some of the stats displayed on LGF Pages indexes are now “live,” updated at 5-second intervals, including the last comment and the page views. The Twitter counter is updated too, but at 90-second intervals.

When you scroll all the way to the bottom of the list of Pages, there’s a big button labeled “Show More Pages.” If you’re so inclined you can just keep clicking this button and showing more Pages until you reach the end, or your browser explodes, whichever comes first.

(Disclaimer: LGF not responsible for exploding browsers.)

Individual authors of Pages have their own indexes, just as in the old version, but again they now appear in a style consistent with the rest of LGF. You can get to any author’s LGF Pages by clicking their username in one of their Pages. The URL for your Pages looks like this (giving you a personal LGF web address):

littlegreenfootballs.com

And… one of the main problems with the old LGF Pages index was the search function. Basically, it sucked, and I say that as the author. Mea culpa. The biggest reason it sucked was because MySQL doesn’t have FULLTEXT indexing for tables of the InnoDB type, but you don’t really care about that. All you care about, and I don’t blame you, is that it’s fast. And the old LGF Pages search feature was the opposite of fast.

The solution: I’ve been noticing for a while that Google is crawling the heck out of LGF, and LGF Pages often show up in Google search results almost immediately after being posted, so I used Google’s “Custom Search Engine” feature to set up a special tool that searches LGF Pages. To use the custom Google search, type your search terms into the field in the left sidebar labeled “Google LGF Pages…”

Google’s search is ridiculously fast. Damned near instantaneous, in fact. Check it out and see how it compares to the old LGF Pages search feature.

Jump to top

Create a Page

This is the LGF Pages posting bookmarklet. To use it, drag this button to your browser's bookmark bar, and title it 'LGF Pages' (or whatever you like). Then browse to a site you want to post, select some text on the page to use for a quote, click the bookmarklet, and the Pages posting window will appear with the title, text, and any embedded video or audio files already filled in, ready to go.

Or... you can just click this button to open the Pages posting window right away.

Last updated: 2016-01-01 10:29 am PST

LGF User's Guide RSS Feeds

Help support Little Green Footballs!

Subscribe now for ad-free access!

Recent Pages
amirbasiri
Hoax is the right definition of moderation in Iran
Following the election of Iranian President Hassan Rouhani back in 2013, time and again the international community has learned – at times through hard lessons – of the notion moderation inside Iran being nothing but a hoax. The most ...

3 hours, 43 minutes ago
Views: 53 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
BeachDem
February 8, 1968—The Orangeburg Massacre
Everyone remembers, or knows about, the students killed at Kent State in 1970. It has been memorialized in photos, stories and songs. Most know about the killings at Jackson State, which also took place in 1970. But in February of ...

3 hours, 50 minutes ago
Views: 67 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
Future Islands - the Chase
Filmed live at The Music Farm in Charleston, SC on April 14, 2015 by Allen Alcantara on a GoPro Hero4. US Tour Crew:Live Sound: Dan FromeLighting Designer: Phil WeinholtTour Manager: Allen AlcantaraKing of Shirts: Dan GaetaLive drums: Michael Lowry ...

11 hours, 18 minutes ago
Views: 100 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
Kimbra - ‘Goldmine’ a Day at Salvation Mountain Ft Nicholas Slick Stewart
My extremely talented friend Slick wanted to film a dance to Goldmine, a song from The Golden Echo that he was particularly inspired by. So on the day of my 25th birthday Kenny took us all to Salvation Mountain ...

1 day, 7 hours ago
Views: 193 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
Polica - Wedding (Live on the Current)
Polica perform "Wedding" off the album 'United Crushers' live in The Current studio. Listen to the full in-studio session: thecurrent.orgConnect with The Current:thecurrent.orgyoutube.comtwitter.comfacebook.cominstagram.com Become a member:contribute.publicradio.org Current

1 day, 7 hours ago
Views: 204 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
Tom Winter - Catalyst - Multi-Tracked Acoustic Guitar
An original composition by Tom Winter dedicated to and inspired by the late Michael Hedges. For more of Tom Winter's music, including original music and acoustic video-game arrangements, check out his YouTube channel: youtube.com Follow his Facebook fan page ...

2 days, 6 hours ago
Views: 317 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
David Bowie - Wild Is the Wind - Live
2 days, 6 hours ago
Views: 345 • Comments: 2 • Rating: 2
Tweets: 1 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
Earth Wind & Fire - After the Love Is Gone
Earth Wind & Fire - Live in Japan

2 days, 6 hours ago
Views: 274 • Comments: 0 • Rating: 0
Tweets: 9 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Thanos
Earth, Wind & Fire Founder Maurice White Dead at 74 - SFGate
Earth, Wind & Fire founder Maurice White, whose horn-driven band sold more than 90 million albums and made hits like "September," ''Shining Star" and "Boogie Wonderland," died Wednesday at his home in Los Angeles, his brother Verdine said. White, ...

2 days, 7 hours ago
Views: 203 • Comments: 1 • Rating: 1
Tweets: 1 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0
Great White Snark
Someone (Mostly) 3-D Printed a Working Semi-Automatic Gun
Seriously, semi auto handguns should have a universal registration law. Even if you home build it. Say 30 days from the moment it can fire. Felons of course would be subject to arrest just possessing the gun, serial number ...

3 days, 11 hours ago
Views: 671 • Comments: 0 • Rating: 1
Tweets: 12 • Share to Facebook

Shares: 0
Likes: 0
Comments: 0
: 0