Red Ogre Review @info@talk.ogre.red

@matt

Always the hardest part with DB design, segmenting records.

If you have traffic stats on what gets the most requests? It could be a scenario where the most recent material stays in the main or live table(s), for kind of obvious reasons.

The older but high activity segments get their own table(s) with some advance caching.

Low traffic / nobody ever looks at it? Archive. Not worth the bandwidth or overhead.

@matt

It might not be a quick fix, but spinning off older entries into their own quasi-archive tables could help, especially if they're ones that are rarely accessed. You'd need a routing mechanism somewhere to detect when to jump from the main table to the archives.

And do you have something like Redis in place for caching common / recent queries? That could help for material that's frequently accessed but doesn't change often.

Our August issue is live!

https://ogre.red/issues/2023-08/2023-08-introduction

With this issue, we trended back to how we started the zine: no prose, but a lot of poetry, with some visual art that ties in conceptually to the verse.

@ferngirl

They're both wonderful pieces, and we're happy to have them in the issue.

Our April issue is live!

https://ogre.red/issues/2023-04/2023-04-introduction

This issue leans into our literary roots with a number of pieces incorporating sci-fi and fantasy elements, critical theory, and absurdist humor.

#Poetry #Art #WritingCommunity #ScienceFiction #Fantasy #CriticalTheory

Our April issue is nearly full!

We have 3 slots left for poetry, prose poetry, and visual art.

If you've already submitted, as usual, absent an express decline email - we roll over submissions to the next reading period.

https://redogrereview.submittable.com/submit

Exciting news - Kate, one of our founding editors, has just launched a new zine in our group of projects.

The first issue is live. Please take a look!

https://redwolfperiodical.com/2023-03-editors-introduction/

And the next issue will be open for subs soon. Poetry, flash, and visual art.

Fundraising for indie presses can be tough, so we're excited to partner with Givebacks @GivebacksGenie.

Givebacks is a shopping rewards program that automatically donates at no extra cost to your purchases.

If you're familiar with the now-defunct AmazonSmile program, it works much the same way. The merchant donates a % of the purchase automatically.

Check out our page:

https://www.givebacks.com/causes/detail/8ae3db77-7837-437d-bd8f-86d98fd9dd24

For a fun kind of weekend side project, we just launched Grim Tales Radio, an online radio station for classic fairy tales:

https://grim.radio.fm

Narration by a text-to-speech AI.

Please be patient while the site loads. It uses a lot of photos along with the audio stream.

And if you really like it, feel free to tip us a buck or two for server time & fees. Donation link at the bottom of the page. 😃

Our April issue is now open for submissions!

https://redogrereview.submittable.com/submit

Poetry, prose poetry, visual art and hybrid forms.

Stylistically, we prefer detail-focused descriptions, natural language, and often longer pieces.

For specifics, please refer to our editorial guidelines:

https://drive.google.com/file/d/1zhtGoP6WyYcm1MUYYE1Zc1gBRw6-Eolq/view

After a few days of giving our site a top to bottom code cleaning and polishing, the site now pulls a perfect score on Lighthouse benchmarks.

Most of the time dependent on network speed, etc., and not that those benchmarks are too meaningful - but nice to see!

One of the reasons we went with a custom-coded static site.

Our February issue is filling up!

By request, we've extended the deadline a little longer:

https://redogrereview.submittable.com/submit

Now is the perfect time to send something along.

Poetry, visual art, or hybrid forms. Pop culture themes would be particularly welcome.

Alan Gillis, Professor of Modern Poetry at Edinburgh University, says about the collection:

"Oisin Breen is writing at a pitch few other poets of his generation can muster. These are tremendously exciting poems."

We agree.

Looking for something to read?

One of our authors, Oisín Breen, has just published a new poetry collection with Beir Bua Press:

Lilies on the Deathbed of Étaín and Other Poems

https://beirbuapress.com/2023/01/01/lilies-on-the-deathbed-of-etain-and-other-poems-by-oisin-breen

Check it out!

@UncoveredMyths

I actually met Karina and Benjamin, the owners / developers, at one of their Zoom meet ups. Very nice people - they're putting a lot of work into building out the site.

@UncoveredMyths

Chill Subs is a newer platform / directory:

https://chillsubs.com

Thinking about publishing a chapbook next year?

We just posted the submission guidelines for our upcoming 2023 chapbook series:

https://redogrereview.submittable.com/submit/245157/chapbooks-speculative-experimental-poetry

We're looking for speculative and experimental poetry, prose poetry, and hybrid forms.

#Poetry #Chapbook #Submissions

We are thrilled to say that the Science Fiction & Fantasy Writers Association has approved us for a grant to fund a project we've wanted to do for some time, a series of single-author chapbooks.

https://sfwa.org

More details on the way as we firm up our planning over the next several weeks.

Ahead of time, if you have an idea for a chapbook, or know someone who might be interested, it's not a bad idea to make a note to keep us in mind.

This mug features our banner image, a Gustave Doré illustration from an 1862 French version of the Puss in Boots fairytale. Specifically, the scene where the cat gets into a battle of wits with an ogre sorcerer.

Looking for a holiday present or a stocking stuffer?

Take 25% off our mugs and t-shirts through the 24th! Two designs for each. Shipping included.

Coupon code: REDOGRE25

https://etsy.com/shop/RedOgreReview?coupon=REDOGRE25

Proceeds will be used fund our 2023 projects.