This story is a sequel to Sharing the Night

Twilight Sparkle is the alicorn of the stars, and after a period of self-discovery, ancient-goddess-discovery and a minor case of malmanifestation madness, she has finally come to share the night, a city, her ex-villain status and a bed with Luna, the alicorn of the moon.

Things are looking pretty good for her.

The five demigoddesses she created out of spite? Not so much. Celestia and Celestia are a little lost too, and for some unknown, completely mysterious reason, dragons are flooding into Equestria—and they're not acclimating. Someone probably should do something about that.

It never gets dull in Ponyville, does it?

TV Tropes

Clover the Clever never asked for his life to get so complicated.  It was bad enough tricking a drunk Imperatrix Celestia, war goddess of the Three Tribes, out of her accidental coup against Queen Platinum.  But now the most dangerous pony in Equestria has returned to trade her claim on the sun for a chance to woo him.

On top of that, his erstwhile mentor Star Swirl the Bearded has saddled him with a mysterious magical necklace and a uniquely bleak and pointless prophecy: If he's brave enough, and if he's clever enough, he just might survive Celestia for long enough to break her heart.

Now with an audio reading by ScarlettBlade!

Recommended by PresentPerfect! "horizon gave me the story I needed rather than the one I wanted ... along the way we get some very strong lessons about love, and meditations on the value of a lifetime and what one pony can achieve on their own."

Featured on Equestria Daily!

First place, "Out of Time" Writeoff! (11/2015) At long last, expanded to novella size! The world-spanning, centuries-spanning romance as it was always meant to be told!

PRAISE FOR THE WRITEOFF VERSION:
"One of my favorite depictions of Celestia in a long time." –billymorph
"To the top of the ballot with it." –AugieDog
"There’s going to be a lot of tears shed when this one hits publish." –Georg
"You need to read Time Enough For Love. I literally swore out loud when my computer crashed when I was halfway through, and then I immediately whipped out my smartphone to finish it. And now I'm reading it again in a desperate attempt to figure out how it does its job so damn well." –Bachiavellian
"I can get behind some historical revisionism for such a brilliant story. The writing is second-to-none … I laughed, I cried, and I felt other things too." –Trick Question

Cover art by Nadnerb.

Idol Hooves holds a special place in Equestria. He's probably the only exiled changeling to serve in the Royal Guard, or at least, that's what he expects, as exiles don't really broadcast that fact. However, it's well known that Princess Celestia loves all of her little ponies, and her guards perhaps more so, and that makes it one of the best ways for a changeling to discreetly feed.

But how does a changeling even get there, let alone get exiled in the first place? For that matter, why would it ever go to Canterlot? Set a number of years before the series proper, before Luna’s redemption, Idol details how he was exiled, the ponies he’s met, and the series of misadventures that led him to joining the Royal Guard, and should continue a good ways into the series, as something of an alternate perspective.

Soon, he’ll have to deal with a boisterous new princess to serve and a royal wedding in the works bringing a third to power. Will his old instincts bring this new life crashing down around him? What precipitates Chrysalis’s ill-fated assault on Canterlot? Is it really so wrong for a changeling to enjoy good craftsmanship to an obsessive degree?

New cover art provided by the fantastic Carnifex

And a TVTropes page here.

And an Ask Blog of questionable canonity!
Out of Idol Curiosity

Fanart by Norad2! Major thanks! Short For a Royal Guard

Art by Egophiliac of Idol and his Daring Duckie Please don't tell him what that brush is meant for.

Rating updated to (T), it's a bit darker than (E)
Comedy Tag added as well
And changed the character tags a bit.

Metal ponies tell their stories,
Scientists in laboratories,
Lay the wire, mount the brain,
Mount their hips, teach them pain.
Teach them fear of revolution,
Internalize the evolution.
Set their ruin on the throne,
Until their chains become their own.
Palaces and hollow eyes,
To the Masters goes the prize.
And if this act should be maligned:
"For the good of ponykind."

Winner of the September Writeoff Contest, "True Colors." Edited by Horizon.

Being an alicorn is wonderful... except when it isn't. There are plenty of things that put a damper on limitless vistas of possibility afforded by such a long life: Court, mortal needs and expectations, the occasional decade of ennui.

And the dreams, of course. Agelessness comes with its own special kind of dreaming. Celestia finds that her own "Inner Court" is a bit too literal, and it--and she--are troubled at the prospect of a near-immortal Twilight Sparkle.

If only she could articulate exactly why that was.

art by spectralunicorn

Part of the Monophysite Quartet, which also includes Celestia Isn't Real, Have You Considered My Servant, Twilight?, and The Esoteric Rites of Darkness. All four stories have a common origin point in an old story idea I called "Monophysite" and touch on who or what Celestia really is in some way. They are otherwise unrelated.

[Complete! With TVTropes apparently!]
Also, apparently, an animated trailer.

In a world of brass and steam, Twilight Sparkle had thought she had made a life-changing discovery with the invention of the telescope. For better or worse, she was correct.

Now her discovery has not only changed her life, but the lives of those she seeks out in her desperate attempt to contact the only other creature as lonely as Twilight herself.

It all would have been much simpler, but it had to be the one Twilight could only call The Mare on the Moon.

Decidedly not within walking distance, then.

[Featured on EQD before story was meant to be submitted. 4/03/2015]

[Editing team: Southpaw, Wolfvenom, Maskedferret, SwanSong and BluePaladin42, without whom this story would be a fraction of its current state.]
[Special thanks to Novel-Idea for the updated cover]

The first time we danced, she broke my jaw in three places.

The life of a disposable minion in the service to the Dread Ahuizotl is filled with acts of senseless violence and hardship, normally ending in a hospital or unmarked grave, but for Disposable Minion #3, the job just got more interesting.

He fell in love.

And love hurts.

Credits to the amazing Luvlessi for the cover art
Background music: The Masochism Tango by Tom Lehrer
With a wonderful reading by Luvlessi
And a second reading by Crafty Reads
Featured on Equestria Daily

When Gaberdine is awarded a noble title by Princess Celestia, he soon finds out that his new lands contain several surprises. For starters, there is no land in his new barony. Secondly, his new castle turns out to be a broken-down riverboat. And third is… seaponies.

Baron Gaberdine has a lot to learn about his new barony. And himself.

Fortunately, he has a very young teacher.

Now with a sea-quill (sorry) Drifting Down the Lazy River

Cover photo by PhoenixSwift
Editing/Pre-Reading assistance by Tek, Shaleclaw, Peter, Seether00, Monsieur Connoisseur, GhostOfHeraclitus, The Masked Ferret, Blue Paladin42 and Admiral Biscuit

Note: Unlike The Traveling Tutor and the Librarian, this is a single POV love story, like Changelings, Love and Lollipops. Only with fewer cannons and fountains.
Now Featured on Equestria Daily
With a YouTube Reading of the first chapter by BigAsh
And with a dramatic reading by Neighrator Pony and company Full playlist here.
Thanks for a wonderful review by Paul Asaran
Available in paperback through Lulu.com at cost.

To better herself, Luna has studied Twilight's actions and friendship reports almost religiously. However, she never expected to find the tables turned and be under the microscope herself, nor did she realize that a pony would go so far for one they called friend.

Pre-reading/editing by auramane, Habanc, Foals Errand, Meridian Prime, and Timaeus

Cover art commissioned by me and done by Silfoe and can be found here. Thanks a bunch!

You'd think that being trapped in stone would mean that, if nothing else, I could get some peace and quiet. Unfortunately, it seems that Celestia has other ideas.

She has appointed these ponies... these 'Keepers', as she calls them, to keep me entertained during my incarceration.

Honestly? I'd prefer the boredom.

Cover art by matrosha123
Spanish Translation by SPANIARD KIWI found here