Adding to my database?

Mar. 27th, 2026 10:18 pm
artemisdart: (math)
[personal profile] artemisdart
It occurred to me that the people I've given and received gifts for are getting difficult to remember with my fleshy human brain. I've joined a several dozen exchanges, and it's hard for me to keep everyone's aliases in mind! So maybe I should add a few tables to my database to account for this.

I already have a Dim_Work table for the things I've written, and a Dim_User table to store info on users, and those are joined by a Fact_Kudos table to link a user to a work by the date of the kudos they left me.

I could add a new Fact table for Dim_GiftWork, which would mark the date, exchange, and user who gave me a gift, along with what date the gift was revealed. (I don't care what date they posted their gift; their wordcount over time means nothing to me, so I wouldn't track that.)

So I think I'm going to add the following:

Dim_Exchange
  • Exchange_key (PK) - Surrogate key

  • Exchange_name - e.g., “Yuletide”

  • Exchange_type - Optional (e.g., “Secret Santa”, “Big Bang”)

  • Exchange_year - Useful for reporting

  • Exchange_notes - freeform in case I have notes to store


~~~

Dim_Ship
  • Ship_key (PK) - Surrogate key

  • Ship_name - e.g., "Gingerpilot"

  • Ship_fandom - I might make this into a table of its own later

  • Ship_notes - for alternate names, tags, or clarifications


~~~

Bridge_WorkShip
  • Work_key (FK) - Links to Dim_Work

  • Ship_key (FK) - Links to Dim_Ship


This bridge table is necessary because a single work can have more than one ship, and of course a single ship can exist in more than one work. So it's a classic Many-to-Many relationship, which causes ALL sorts of problems if the data isn't normalized into a nice bridge table like this one. :)

~~~

Bridge_WorkRecipient
  • Work_key (FK) - Links to Dim_Work

  • Recipient_user_key (FK) - Links to Dim_User


This bridge table links Dim_Work → Dim_User to track the recipient(s) of works I wrote as gifts (there can be more than one).

~~~

Dim_GiftWork
  • GiftWork_key (PK) - Surrogate key

  • GiftWork_title

  • GiftWork_exchange_key (FK) - Links to Dim_Exchange

  • GiftWork_ship_key (FK) - Links to Dim_Ship

  • GiftWork_author_key (FK) - Links to Dim_User

  • GiftWork_reveal_date - The date the gift was revealed


This table would be for gifts that were given to me.

~~~

Fact_GiftWork
  • GiftFact_key (PK) - Surrogate key

  • GiftWork_key (FK) - The gift work

  • Recipient_user_key (FK) - The user I wrote it for

  • Reveal_date - helps with reporting over time


(I might add this later -- it's optional. This table would be helpful if I needed easier metrics over time, reporting on the gifts given to me. I don't think I really need it -- I haven't received THAT many gift works!)

current fandom events

Mar. 25th, 2026 10:50 pm
svgurl: (narnia: susan)
[personal profile] svgurl
[community profile] latam is a community for people to come together to talk about Latin American music, films, food, culture, fandom, etc. The official languages of the community are Spanish, Portuguese and English.

[community profile] vforvictoryexchange, a multi-fandom exchange about V-shaped polyamory ships, is open for nominations until March 27th, 10PM Eastern.

[community profile] bitesizedfandomsex, an exchange for fandoms whose canons can be read, watched, played, or otherwise experienced in 8 or fewer hours, is accepting nominations until March 28th, 11:59PM Eastern.

[community profile] narniaexchange, a community/exchange based on the Chronicles of Narnia books/movies is running a adult oriented prompt fest on AO3. Prompting is open and will close on March 30th.

[community profile] fangfrenzyficexchange, a vampire themed (canon and AUs of non-vampire fandoms) fic exchange, is open for sign-ups until March 31st, 10AM Eastern.

Sunset Archive, a site using AO3's code dedicated to F/F, NB/F and NB/NB fanworks, is running its inaugural prompt meme. Prompting will close on March 31st but fills are open indefinitely.

[community profile] fandom5k, a multi-fandom gift exchange for fic with a 5,000-word minimum and comics with a 5-page minimum, is accepting nominations until April 1st. It will then close temporarily and reopen when sign-ups do.

[community profile] seasons_of_fandom, a multifandom community where you join a team and participate in challenges to earn your team points, is starting a new round on April 4th! Find out more info and sign up HERE. (And let them know I sent you if you do!)

[community profile] seasonalremix, a quarterly, trope-based multifandom event focused on remixing an already existing work, has opened sign-ups for its Spring 2026 Round until April 11th, 11:59PM GMT.

The Solution

Mar. 24th, 2026 11:25 pm
artemisdart: (angel)
[personal profile] artemisdart
JayneSilver posted a comment on the Discord server today that amused me greatly, re someone bragging about what a nice clean colon they had for their colonoscopy. She wrote:

JayneSilver: This is giving "Mitaka, come look at this," 😌
Mitaka: I really shouldn't be so aroused by this 🥵

ArtemisDart: Literally laughing out loud, yes exactly
Damn, I have other things to write

JayneSilver: Oh my god please 😂
Post colonoscopy Hitaka 🤣
We can get even more niche

ArtemisDart: There is no niche the solution did not flush out 😂🥵


Haha! It struck me as hilarious, so I took a couple of hours and banged out a short story on the prompt.

The Solution
Author: ArtemisDart
Fandom: Star Wars Sequel Trilogy
Ship: Armitage Hux/Dopheld Mitaka
Rating: Explicit
Warnings: No Archive Warnings Apply
Wordcount: 2,482

Summary: Lieutenant Dopheld Mitaka gets flustered when his superior officer goes into graphic detail about his recent medical procedure. Surely it cannot be seemly to discuss these matters!

But Mitaka has no objections to checking the medical team's work in a more intimate setting...


I gave the fic to Jayne as a gift, and she was very amused by it!

Live Wire Chapter 13

Mar. 23rd, 2026 08:11 pm
artemisdart: (Garden)
[personal profile] artemisdart
I stayed up late writing Chapter 13 of Live Wire! Finally, with this chapter, the fic has earned the Explicit rating I gave it way back in July 2025 when I started it. (One could argue that Chapters 7 and 8 already contained some adult material -- and they did -- but I regard those chapters as rated Mature, haha.)

So far in this fic I've used three points of view in this order:

Chapters 1 & 2 - Mitaka
Chapter 3 - Techie
Chapters 4 & 5 - Mitaka
Chapter 6 - Techie
Chapter 7 - Hux

Chapters 8 & 9 - Mitaka
Chapter 10 - Techie
Chapters 11 & 12 - Mitaka
Chapter 13 - Techie

So that means next chapter will be Hux again!

I particularly enjoy the juxtaposition of Techie's point of view, which I'm trying to write in a different way from many of the other characters I often use, with Hux's point of view. Hux is so very good at fooling himself; his huge, overengineered brain and layers of complex trauma all conspire to mire him in traps of his own making. Techie is much more clear-eyed. He regards himself as simple, or even dumb -- which, of course, isn't true at all -- but it informs how he thinks about the situations he encounters. The fun part for me is that Techie and Hux are genetically identical. It's a fascinating challenge to write the same person -- genetically, at least -- in two completely different ways!

I have to say that Brendol Hux and the First Order dabbling around in cloning technology is the plot hook that keeps on giving. I can find a way to shoehorn any one of Domnhall Gleeson's characters into the Star Wars Sequel Trilogy universe... and perhaps I shall.

Lavender and Other Delights

Mar. 23rd, 2026 12:33 am
artemisdart: (horny bird)
[personal profile] artemisdart
One of my writing friends published a collection of erotic short stories, and asked me to write the introduction! This is the first time "Artemis Dart" has appeared in a legit, non-fanfic publication, haha!

Lavender and Other Delights
By Cynthia Hamilton

Summary: "A heady hotel room encounter with an online crush... What starts out as a surprise revelation ends up as a spicy threesome... A vendor of pleasure products on a space station tries out one of her new toys with the lucky pilot who made the delivery... A prince seeks the right princess who matches his particular kinks in a less-than-wholesome retelling of "The Princess and the Pea"... A woman wandering through an erotic museum ends up as performance art herself... A man realizes he recognizes his latest hookup from a billboard he passes on his way to work...

These and more sizzling short stories by celebrated author Cynthia Hamilton await your one-handed reading pleasure inside the pages of LAVENDER AND OTHER DELIGHTS."

Media consumption: SPY×FAMILY S03

Mar. 22nd, 2026 01:43 pm
tropicsbear: Yuri Briar from SPYxFAMILY looking serious (SPYxFAMILY: Yuri)
[personal profile] tropicsbear

⚠️ Mild spoilers

Personal rating 9/10

There were some very interesting story beats this season even if we didn't get much movement on the Operation Strix front!

Cut for mild spoilers. )

No confirmation yet on a fourth season, but I'd be very surprised if we didn't get one.

(no subject)

Mar. 22nd, 2026 12:37 pm
tropicsbear: The main characters of Saiyuki as pandas stacked on top of each other (Saiyuki: Sanzo-ikkou panda)
[personal profile] tropicsbear

Link nabbed from [personal profile] goodbyebird!

Fifty years after New Zealand stopped whaling, humpback population showing signs of recovery

As the decades rolled on, female whales had more options, and the males were getting more competitive.

"Then we see as the population gets bigger, there's this kind of preference towards older males. And it just shows us that whaling and the reduction in the population size has led to changes in these behaviours through time."

lannamichaels: Astronaut Dale Gardner holds up For Sale sign after EVA. (Default)
[personal profile] lannamichaels


Title: The People You Meet Along The Way.
Author: [personal profile] lannamichaels
Fandom: The Parent Trap (1998)
Rating: G
Archives: Archive Of Our Own, SquidgeWorld

Summary: Twelve years later, they meet at an airport.


Meredith is so fun to write )

Friday 5

Mar. 20th, 2026 12:55 pm
oceangrey: Scene from Withnail and I, showing Marwood peering over a newspaper. (Default)
[personal profile] oceangrey
Today's questions from [community profile] thefridayfive:

  1. What was the reason you began a Dreamwidth or LiveJournal account (or both)?

    • I began my Dreamwidth account as an alternative to Tumblr, a couple of terrible updates back. I did briefly create a LiveJournal account to try and find some fics but I no longer use that account.


  2. How many DW or LJ communities do you subscribe to?

    • I'm currently subscribed to 10 communities on here, including this one ([community profile] thefridayfive) :)


  3. Do you have a favorite community or one you check out often to see what's new?

    • Most of the communities I follow don't regularly update (as they're mostly seasonal ones, for example fic exchanges), so I wouldn't say I currently have a favourite community.


  4. How did you pick your user name?

    • I picked it from an old Tumblr user name! It's from an episode of Red Dwarf :D


  5. If you could change your user name, would you?

    • Probably not, no. I go mostly by another user name on different sites, but I think I'm gonna keep this one as it is.
oceangrey: Scene from Withnail and I, showing Marwood peering over a newspaper. (Default)
[personal profile] oceangrey
posted on [site community profile] dw_community_promo:

[community profile] warrington_runcorn_ntdp is a new fan-run community focused on the music of electronic project Warrington-Runcorn New Town Development Plan.

Anyone is free to join, even those who have never listened before! Although if that is you, I'd recommend checking out the project's Soundcloud, Bandcamp, and Youtube to get acquainted :D

Discussion on the community will include, but is not limited to, avourite songs/albums/album artwork, physical media, how you discovered the music, recommendations for similar music, etc.

The current rules are pretty standard: no harassment/discrimination against any other Dreamwidth users; no NSFW/explicit content unless it's directly connected to the community's theme; and please keep any posts/comments on topic as much as possible. Anything else can be decided on in the future.

I ([personal profile] oceangrey) am the current only moderator/admin, but if anyone else wants a similar role just message me or comment on the community's pinned post!

Withnail & I Community Promo

Mar. 18th, 2026 09:39 am
oceangrey: Scene from Withnail and I, showing Marwood peering over a newspaper. (Default)
[personal profile] oceangrey
posted on [site community profile] dw_community_promo:

[community profile] withnailandi is a community for everything related to Withnail & I (1987). Fanworks/recommendations, meta/discussions, whatever, all are welcome here! Another related community is [community profile] withnailandinsfw, for any more explicit fanworks/discussions.

Although not entirely new (made in October 2025) both communities are unused as of yet, due to most of the fandom being on other platforms. Feel free to join whether you're a casual fan, or if it's your favourite film of all time, or if you're somewhere in between!

[community profile] withnailandi is open for anyone to join, and [community profile] withnailandinsfw is set to administrator-approved due to the community's content.
lannamichaels: Astronaut Dale Gardner holds up For Sale sign after EVA. (Default)
[personal profile] lannamichaels


Does anyone have or have access to the The Polychrome Historical Haggadah by Jacob Freedman? I'm curious as to what kind of hagadah text it has. I can find a write-up that lists the levels and one of them is Contemporary, defined as beginning in 1900. What's the contemporary stuff? Are there notable things this hagadah includes/doesn't include?

It having contemporary things/cup of Miriam/etc is not a downside, I just want to know what sort of thing is in this before I decide if I wanna get it for this year or not. My utmost value in a hagadah is "is this usable", not really "is this beautiful", and my "is this historically interesting" niche is already fulfilled by the hagadah shelaimah. So is this the sort of thing that would perfectly slot next to the hagadah shelaimah on the shelf, or is it more of a gimmick? The last hagadah I got because it was artistic, I ended up giving away, because it was pretty but not actually functional.

16.03.2026: Music and Planning

Mar. 16th, 2026 09:09 pm
oceangrey: The cover for the album "Public Works and Utilities" by Warrington-Runcorn New Town Development Plan. (planning)
[personal profile] oceangrey
I've been listening to a lot more electronic music recently, and I discovered a music (project? band? artist?) called Warrington-Runcorn New Town Development Plan, whose name (with some relevance to my uni course, lol) immediately drew me in.

All the albums and tracks are very... I'd hate to say "conceptual", although that probably applies. They're very tied to the idea of urban planning and the promises that were made through the New Town developments of the mid-late 20th century (although the artist would, perhaps rightly, argue whether those promises were actually delivered on or not). It's an interesting reflection on the importance of public consideration in planning in the UK, supported by eerie, ambient 70's synths, and with some eye-catching album covers to boot.

Needless to say, I used last Bandcamp Friday to get a CD of my favourite album, 'Public Works and Utilities'. It arrived today and it looks absolutely beautiful! Unfortunately I'm away from my CD player at the moment, but I just can't wait to listen to it :D



Another planning-related media I've looked into recently is the short film "I Love This Dirty Town", released in 1969 and narrated by the author Margaret Drabble. It's interesting to see people outside the architectural/planning fields weigh in on the social impacts of some of the less-thought-out planning decisions of the past, the ones where the public interest perhaps wasn't prioritised over the experts' own egos. A lot of the discussion in the film reminded me significantly of Jane Jacobs' social analyses of planning (such as with the "eyes on the street" concept), but I feel it did lack depth and nuance, possibly because most of the people being interviewed were all from very similar creative roles as Drabble herself (designers, scuptors, other authors, etc.) rather than just... people who live in London.

The main concerns made about planning were the lack of public consultation (and to be fair to the film, public participation as a requirement to the planning process wasn't law until the Town and Country Planning Act of the previous year, and so the after-effects of the previous technocratic focus were still being felt in new projects), but there was very little, if at all, discussion about what could be done to improve public input.

Overall, it does feel more like a letter of complaint rather than a manifesto. It that was its intention, then... fine. The best thing about it was a great deal of footage of London in the 1960s, which I found fascinating. It makes me want to binge-watch similar short films on BFI Player... which I unfortunately can't do because it seems to hate my laptop for some reason. Alas.
artemisdart: (fractal)
[personal profile] artemisdart
It took all weekend and nothing else got done, writing-wise, but I finally managed to finish Chapter 12 of Live Wire. I posted it just now. So all four people who are reading this fic have something new to chew on; hooray!

In other exciting news, a new chapter of The Black Chrysalis just dropped! The previous chapter was posted on May 20, 2025, so that's almost ten whole months. It's good stuff. The big reveal STILL HASN'T HAPPENED despite LITERALLY EVERY INDICATION THAT IT MUST HAPPEN SOON. The edging is getting extreme! I can't wait for stuff to happen -- finally, f-i-n-a-l-l-y -- yet I'm dreading the results when it does finally happen. That's great writing!
Page generated Mar. 29th, 2026 08:21 am
Powered by Dreamwidth Studios