#raymond: round 4
Explore tagged Tumblr posts
Text
I'm alive! Round 4 of the Raymond household is up and ready to read on my Dreamwidth here :D
#sims 2#ts2#bacc#ts2 bacc#sims 2 bacc#bacc seaport#the sims 2#round 4#raymond: round 4#sim: wesley raymond#sim: elijah fowler#sim: margie#sim: solty revant#sim: link wilde#sim: nico macleod#sim: nils
9 notes
·
View notes
Text
parallel movement
[1]===============================================
TG: no rose look were dj crabapple so when we hang out its a mashup i dont get what the problem is
TT: Disregarding the unsavoury implications of you "mashing up" with Karkat, I find it very interesting that you won't even say the word.
TG: i dont need to say the word because it is not even relevant to the situation it is lightyears away dude youre lost in fuckin space with this
[2]==============================================
GA: Very Well Then
GA: Tell Me Karkat What Did You Do Yesterday Again
CG: WE WENT TO SEE A RERUN OF THE EARTH MOVIE "SHARK TALE (2004)" ON ITS "VENICE FILM FESTIVAL PREMIER ANNIVERSARY" OF SEPTEMBER 10TH.
GA: You Remembered All That
CG: YES?
GA: Well
CG: ????
GA: So Anyways You Had Gone To See A Movie Together
CG: YES, KANAYA. BUT KEEP YOUR IGNORANCE-SHAFT'S LOWER MANDIBLE FROM CRATERING THE GROUND JUST YET, BECAUSE WE EVEN HAD A *MEAL* AFTERWARDS!
GA: Interesting
GA: And At What Time Did You Eat Together
[3]==============================================
TG: i dunno man like 7:40:13 pm we didnt book so we had to wait a shitload of time but thats irrelevant
TT: So you had dinner together?
TG: i swear to god if youre on this psychoanalysis non sense again im gonna flip
TG: dont you dare lift your hand up and stroke your chin in consideration with that index finger and hum in a thoughtful tone dont you do it
[4]==============================================
GA: Hmmm
CG: WOW! NOW YOU'RE EVEN STOOPING SO LOW AS TO REPLICATE LALONDE'S CONTEMPTIBLE LITTLE "PSYCHOANALYSIS" ROUTINE. CLASSIC! WHY DON'T WE JUST INVITE HER OVER HERE RIGHT NOW SO I CAN PROSTRATE MYSELF FULLY TO THE WHOLE AUDIENCE! BUT GASP, WATCH AS THE PERFORMER SKIRTS AROUND THAT THINKPAN-MELTING PITFALL LIKE AN ANGELIC FUCKING BALLERINA ROUND THE TRAPDOOR, BECAUSE THAT HOLE LEADS STRAIGHT TO--
GA: Karkat Please Relax Im Just Trying To Ascertain How Your D-
[5]==============================================
TG: --mashup
TT: "Mashup" went.
TG: yknow whats funny i dont ever hear an usher raymond iv of that word while you and kanaya are all tuckin each others hair behind yalls ears and blushing demurely
TT: You have it all wrong, Dave; Kanaya and I's regular meetings of intercultural exchange are just that, not --
[6]==============================================
CG: HMMMMM.
GA: Touché
#davekat#dave strider#karkat vantas#homestuck#rose lalonde#kanaya maryam#sorry i had to make small. if i did it full size this post would be a mile long#comix#parallel movement
3K notes
·
View notes
Text
OFFICIAL HOTEL SPOTIFY PLAYLIST ROUND UP TO GET YOU THRU THE LEAN TIMES LETS GOOOOOOO
opening track: Yes I Am - Margo Guryan
last added: Cadence feminine - Teho Tearado
opening track: Powerhouse - Raymond Scott
last added: Time Becomes - Orbital
opening track: La boheme, SC 67/Act 4: Vecchia zimarra, senti - Puccini
last added: Everything About You - Ugly Kid Joe
opening track: Anything You Can Do - Ethel Merman, Ray Middleton
last added: Halloween TV Commercial - Halloween 3 soundtrack
opening track: Kahn's Pets - James Horner
last added: Futamomo - Hannibal season 2 soundtrack
opening track: Lullaby - The Cure
last added: Warped Tour - Mom
opening track: Everything You Know Is Wrong - Weird Al
last added: We Will All Go Together When We Go - Tom Lehrer
opening track: Main Title (The Shining) - Wendy Carlos, Rachel Elkind
last added track: The Martian Boogie - Brownville Station
opening track: Song of the Sewer - John Lithgow, Wayne Knight
last added track: The Check's In The Mail - Weird Al
opening track: Doreen - Frank Zappa
last added Jim Cain - Bill Callahan
(Noreen art by @parasitic-saint!!)
I still add to these all the time, enjoy enjoy enjoy.
139 notes
·
View notes
Text
Who is most important to the history of Doctor Who?
TOURNAMENT MASTERPOST
propaganda under the cut
Raymond Cusick – designed the original Daleks
he designed the daleks, and was involved in many set designs of early doctor who. (anonymous)
103 notes
·
View notes
Text
King of the Graveyard Slot (3/16)
Vote for which Round 1 banished hottie should rule over them all!
The winners of these polls will go on to a Semifinals poll tomorrow to see who will win the crown!








No propaganda this round, you have 1 day to vote with your heart!
70 notes
·
View notes
Text
By Your Side - Chapter 4
Chapter 3 | By Your Side Series | Chapter 5 (coming soon)
Summary: You experience what it’s like being on a film production for the very first time, whilst thinking about home. Luckily, your fellow castmates and film crew seem friendly enough...
Word Count: 2,772 words
---
February 18, 1998
---
“Alright,” the director clapped his hands together, bringing everyone in the room to his attention. “Now I know we all practically know each other by now, but since everyone’s here, let’s begin by introducing ourselves and our cast roles. I’ll go first, and then we go round clockwise from there.” He nods to the group and takes his seat down at the table.
“So! I’m Robert Rodriguez, and I’ll be your director for this movie.” He motions to the person sitting to the left beside him to continue, to which a young man with speaks up.
“Hey guys, I’m Josh Hartnett, and I’ll be playing as Zeke Tyler.” He nods shortly.
“Jordana Brewster, and I’m playing Delilah Profitt. I’m looking forward to be working with you all.” The gorgeous brunette flashed a brilliant smile.
Next was a tomboyish looking blonde, though you had a hunch it may have been stylized that way for her role. “Hi, I’m Clea DuVall, and my role is Stokely Mitchell. Cool.” The group shared a small chuckle.
“Uh, hi, I’m Shawn Hatosy, playing as Stan Rosado.” He quickly runs a hand through his curly hair as he spoke.
“Hello everyone! I’m Laura Harris, and I’ll be playing Marybeth Hutchinson.” Her gentle voice matched her kind looks as she offered a small smile. Beside her, one of the smallest of the group, perked up as he introduced himself right after.
“Hi guys, I’m Elijah Wood. Really excited to be here, and I’ll be playing Casey Connor.” He spoke quite self assuredly despite sharing most of the group’s slightly nervous jitters, having been on multiple film productions in the past.
“...”
“Uh, Y/N? That’s your cue.” Robert whispered across the table, and suddenly you realized it was your turn, but not before you caught Elijah’s eye as he gently prodded you with his elbow.
‘Oh shit.’
“Oh shhh...oot.” You caught yourself at the last second, not wanting to look bad in front of your peers by cursing. “Yeah! Yeah, it’s my turn.” The table shared a lighthearted laugh, though you weren’t sure if it was meant to be comforting or not.
“Uh... hi guys!” You introduced yourself, first name and last. “I’ll be playing as... Jordan Fulcher. Nice to meet you all.” A ripple of amusement sounded throughout the table, and you were half tempted to just lay your head down on the surface with embarrassment.
Instead, you added: “Sorry, first day on the job.” A couple of people you heard responded with “Same here”, good naturedly.
Luckily or not, the person you sat beside - whom you’ve already been introduced to as Usher - took the attention off of you to charismatically introduce himself.
“Alright, alright! How’s it going y’all? You might’ve heard of me, you might’ve not. But that’s aight if you don’t; You can call me Usher!” He pauses, letting the room quiet down after another round of laughs and playful cheers. “Usher Raymond, and I’ll be playing Stan Rosado, thank you all for comin.”
Half of you felt grateful that the fellow beside you was able to shift the attention off of you so quickly, though the other half admonished yourself for messing up within the first day of production. ‘Great job, dumbass.’ You thought to yourself.
Looking up, you met the eye of another castmate across from you; The kind eye of Robert Patrick gave you a slight nod of reassurance as he silently mouthed: “You’re okay.”
Feeling comforted as the far more experienced actor gave you his approval, you let yourself smile back.
It’s always nice to know you’ve got THE T-1000 as a cast member to learn from, as well as other friendly-enough faces.
No longer cornered by your awkward first introduction, you gently prodded Elijah back with your elbow to whisper: “Just wanna let you know: You did a great job in Flipper last year.”
His eyes widened in surprise. “Oh, thanks! It was a ton of fun, I’m glad you liked it.”
...
Sighing in frustration, you forced yourself to take a seat once you entered your assigned dressing room’s chairs, after pacing around the room, nothing short of stressed and anxious. Unable to shake the feeling of uneasiness, you leaned down, burying your face into your arms as they lay atop the vanity table, not daring to look at yourself in the mirror right in front of you.
‘How the hell did they decide to cast someone with a face like mine?’ You thought, running a hand over it.
Did anything go wrong today? No, actually, if any other person would be asked this question, the most agreed answer would be: No, things went quite well for the first day.
You weren’t any other person, unfortunately; Or at least, you concluded that you cannot be any other person even if you wanted. In fact, you still felt the absolute embarrassment of messing your introduction up; Anyone else would have long forgotten by now; you however, couldn’t shake the fear of wondering if people were about to use that slight slip-up against you, or if they wouldn’t let you live it down, or-
Someone called your name as they knocked on your door. “You doing alright in there?” Robert called, and you shot up, any admonishing thoughts upon yourself being flash frozen for the time being.
“Uh... hang on just a second!” You called back, giving yourself a once-over in the mirror to rid yourself of any evidence of stress upon your face before beelining towards the door. “Ah, hey there sir.” You gave him a welcoming smile, hiding away your inner turmoil. “What’s up?”
From the initial look on his face, you had already guessed there was something else he wanted to ask. Still, he returned the friendly expression as he replied: “Just wanted to check in on you, also wanted to say that you did great today. Don’t sweat it, just take it easy and enjoy yourself, okay?”
Nodding, you gave him a thumbs up. “Noted. Sorry about that. I... just want to make sure I can give you guys the best performance I can, so...”
“Oh, no need to worry at all.” The director laughs a little. “Everyone’s been talking about how quickly you change into your character like this.” He snapped his fingers. “It’s just the table-read, but it already looks like you’ve got your character down just like that.” You slightly bowed your head in thanks.
“I do my best, and my best is what I can only give, even on day one.” You shrugged lightly. While his words did comfort your nerves somewhat, it’ll mean nothing if not applied to the final product.
Robert gives you a clap on the shoulder. “That’s the spirit! Now, come on, you don’t want to be eating alone on your first lunch break on the job. Everyone’s been waiting for you!”
You sighed, this time with a bemused look. “Alright alright, as long as they don’t start applauding the moment I enter the room, I’ll hang around more often.” Quickly turning to grab your headset and walkman, making sure the cassette inside still held Marshall’s new EP that you’ve been listening to more often than you would’ve liked to admit, you followed your boss to lunch. “I appreciate it, you know.” You added, genuinely grateful.
“Oh, it’s no problem at all. Don’t burn yourself out by pushing yourself too hard. You’re gonna do fine, trust in the process and you.”
---
Several weeks later...
---
“What’re ye listening to?”
Raising your head to look at whomever interrupted your peaceful quiet time before another set of rehearsals, you gave Usher a deadpan look and replied: “Nothing your ears should be hearing.”
He raised his hands in surrender. “I mean, if you know my kind of songwriting, pretty sure that means you’re listening to the HARD, hard stuff.” He angled his neck to try and take a peek at the cassette slotted inside to no avail. “You’ve been leaving us at a cliffhanger for like, what, two and a half weeks? I wanna know what’s made this tape so special, honest to god!”
“Now that,” Clea, having heard your response, came up and sat down beside you. “Is something I’m interested in knowing about; Considering you’ve shot down all of our guesses as to who you’re listening to.”
Sighing, you groaned, facepalming. “Ugh... not you too, Clea.” Though, you couldn’t help but smile along as your two co-stars laughed. “At this point, you’re gonna get the whole gang in on the investigation-”
“Hold up, did I miss something?”
‘... Speak of the devil.’ You thought as Shawn sidles up beside Usher to look alongside him. “Are we finally gonna hear what you’ve been playing on that walkman?” He inquired.
“If I could, I would.” You replied, keeping your face stone cold with fake annoyance. “But like I said, give it time till this guy’s made it big enough for the mainstream, and then y’all won’t look at me and think: ‘Wow, this kid is a nutcase.’“
“Oooooh, so it’s a guy.” Clea leaned in a bit, raising her eyebrows. Meanwhile, the other two boys followed along with teasing “Oooooooh’s”, like a group of gossiping fangirls.
You didn’t say a thing, except look across the room where Kidada Jones was sitting, making eye contact, you gave her a pleading look of ‘help me’.
Tragically for you, she just shrugged, grinning playfully. “Sorry babe, you know I’m just as obsessed as the rest of ‘em.”
“Auuuugggghhhh.” Throwing your head back in exasperation, you called out your two other co-stars that weren’t even here. “Jeez, Laura? Josh? Why must you two not be here in this very moment to defend my pride?!” The group cracked up laughing at your dramatic bemoaning. It was all in good fun, you were hardly even offended at their sibling like pestering to reveal your secrets, but god, sometimes you really needed someplace more introverted than this.
Shoving your walkman back into your pocket and got up from the couch. “I’m being held hostage here, so I’m just gonna... make my escape. See ya.” Leaving the break room to find some other place to chill.
”Only a matter of time!” Usher called as you left. You looked back and gave him a shake of your head with a smirk, determined to win this war.
Unknowingly to them, your muscles were sore from training on another movie production, set to start filming practically right after this one ended. If you could, you’d hole up in your trailer and sleep the rest of the day away. Stretching out your back with a wince, feeling your overworked sinews creak and stretch, you continued walking down the hall to find Elijah and Robert in another room, playing a game on the Super Nintendo.
“Hey guys-” You greeted before realizing what they were playing, your eyes lighting up. “Oh shoot, is that DOOM?”
“Yeah!” Elijah briefly turned to reply to you before focusing back onto the level. “You wanna try after we finish this level?”
“Hell yeah, say no more.” Taking a seat on one of the chairs to watch the two play out their match, you stifled a pained groan as you bent your legs to sit down. “Man, I’m already feeling like an old person.”
Robert chuckled, his character reloading their shotgun shells. “You’ve got a long way to go before you actually start feeling that way, kid.” The room was comfortably silent as you watched them play, before he piped up again: “So, how was training with Ed and Brad? Tough crowd, huh?”
You let out a single “Ha!” before responding:
“Honestly, I’d rather have everyone here pester me about my musical choices before having Mr. Norton urge me to keep going after like, twenty reps? Don’t tell him I said that.”
“Lips are sealed.” Elijah said, as his character turned the corner of a hidden path to collect a blue keycard. “Got it.”
You clapped your hands once. “Nice! You’re almost there.”
Figuring you may as well resume listening to your music as you watched the gory video game, you quickly put your headphones back on to hear the middle of Just Don’t Give A Fuck, muttering along to the lyrics as if on instinct.
But if you see me on the street and duck ‘Cause you gon’ get stuck, stole, and snuffed ‘Cause I just don’t give a fu-
“Hey! Language.” Robert lightly reprimanded you, breaking you out of your trance.
“Oop, sorry.”
“...Interesting music choice you got there.”
You gave a grimace-sort of a smile. “Exactly why I’m not showing my cassettes off to anyone. Not for the faint of heart.”
“Pfft.” Elijah waved the warning off. “We’re all adults here, honestly. What’s a couple of swear words and dark topics gonna hurt anyone?”
‘Ohhhh boy, you have no clue, Eli.’ You thought, leaning back in your seat.
---
Another few weeks later, March Break, 1998...
---
Your pager bleeped loudly within your pocket, taking you out of your well earned peaceful zone-out of just letting the world go by, watching Quinn play around in the grassy park fields.
Nearly deciding against checking, you reluctantly took your pager out of your pocket, unsurprised to see your agent’s number displayed on the little screen.
Unsurprised yet somehow not having the strength today to feel irritated, you just sighed and dialed him up on your phone. Pretty handy these days, despite being manufactured a few years ago, it was a worthwhile investment if it meant being able to take calls outside the house.
As soon as you heard him pick up, you didn’t let him have a chance to say hello: “I swear to god, you better have a good reas-”
“Pack your bags, we’re going to L.A.”
You blinked.
“...Why?”
Usually you’d be far too happy to make a beeline for the airport, but Shaun specifically agreed to not contact you during March Break, just so you could spend some time alone with your family. Having him break that protocol, despite not having any written in agreement, well, let’s just say you had a right to ask why.
Luckily, your agent seemed both excited and probably in a slight state of panic as he explained. “You remember the demo tape I told you to give to me before you left for the first table-read, right?” Not waiting for your confirmation, he quickly got to the point. “Well, someone here wants you to get that song out ASAP, if you can, you get to perform live on the 31′st as THE opening act for another artist’s debut!”
Huh.
Running a hand over your face, you shut your notebook and began to pack your things to leave the park, phone pressed between your ear and shoulder. “Which one, exactly?”
“Florentine Garde- oh, no wait, that’s not what you meant - All of them! Well, pretty much all of them. Look, just, you got a song that’s pretty much done in there right? Which one is the quickest to be produced from now before the 29th this month?”
“Alright, alright, calm down. I know which one I’m gonna do. Just let them know I’ll be there hopefully by tomorrow.”
“Already booked your flight.”
“Wow, great. Thanks for doing all this stuff before letting me know beforehand so I can tell my parents and nephew-slash-son know that I’m going back to work whilst on vacation.” You snipped.
“Look, I’m sorry, I really am. It’s just... this is an opportunity you can’t miss if you want to make it big in the music industry. I told you before that I saw your potential in your songs you showed me, and now’s the time to show an audience what you’ve got! C’mon, please, work with me here. I promise, I’ll show you the best places there to get the best ice cream. I know you like ice cream, right?”
You just chuckled, zipping up your bag. “Alright. You don’t have to bribe me like a child, but now that you mentioned it, you better uphold to that promise or so god help me if shit goes south. I’ll see you tomorrow in L.A.”
Quickly bidding him goodbye, you hung up and called Quinn over, beckoning him to come tidy up and leave. He was fairly understanding every time you told him you had to go to work, which meant not always being able to pick him up from school or taking him outside to play like today, which you were grateful for.
Hopefully, he would forgive you for having to leave so soon, once again.
‘I’ll be back home soon, baby boy. I promise.’
----
(End of Chapter 4)
----
A/N: GET READY FOR THE REUNION YOU’VE ALL BEEN WAITING FOR IN CHAPTER 5. MORE MARSHALL CONTENT FROM THERE ON OUT LET’S GOOOOOOO-
Tagged List: @eminemsorangejuice , @slimshay-castle , @jackiehollanderr , @mizzysx , @esposadomd , @dimitrampl , @hallecarey1 , @krillfromsky , @nabiiturner, @swimregulas , @olivesarenicetoeat17 , @linnottt , @harryswif3 , @liathelioness , @roundbrownlover , @crimsonincursive , @akemiixx01 , @lizzy06 , @chxe-zdechnac , @ellies-femme , @qwerrry , @born2wyn , @thefemalestorywriter , @milllieeee , @neozen-23 , @in0320
(Let me know if you would like to be added to the tag list! Preferably by ask box <3)
#eminem x reader#by your side series#bys series#eminem fanfiction#eminem x you#eminem imagine#eminem imagines#marshall mathers fanfiction#marshall mathers x reader#marshall mathers imagine#marshall mathers x you
114 notes
·
View notes
Text
Little Bit Better Than I Used To Be
Catch up: Chapter 1 (Starry Eyes) || Chapter 2 (Save Our Souls) || Chapter 3 (Dancing On Glass)|| Chapter 4 (Merry-Go-Round)|| Backstage (1) || Backstage (2) || Chapter 5 (Danger)|| Backstage (3) || Chapter 6A (Love Walked In) || Chapter 6B (Without You) || Backstage (4) || Chapter 7 (Stick To Your Guns) || Chapter 8 (Time For Change) || Backstage (5) || Chapter 9 (Take Me To The Top) || Backstage (6) || Chapter 10 (Home Sweet Home) || Backstage (7) || Chapter 11a (Nightrain) || Chapter 11b (Nothing Else Matters) || Chapter 12a (Handle With Care) || Chapter 12b (I’m So Tired of Being Lonely) || Chapter 13a (Angel) || Chapter 13b (She’s My Addiction) || Chapter 13c (Patience) || Chapter 14a (Where Do We Go Now?) || Chapter 14b (Where Do We Go Now?) || Chapter 14c (Where Do We Go Now?) || Chapter 15a (Dreams) || Chapter 15b (I Sing A Song of Love) || Chapter 15c (You Can Do This If You Try) || Chapter 16 (Let That Feeling Grab You Deep Inside || Chapter 17A: Never Tear Us Apart || Chapter 17B: It’s Tough To Be Somebody, And It’s Hard Not To Fall Apart || Chapter 17C: I’m Wishing, Lord, That I Was Stoned || Chapter 18: Turn The Page || Chapter 19A: When You’re Alone, Do You Let Go? || Chapter 19B: Heading For A Spin || Chapter 20A: I Don’t Need Nothing When I’m By Your Side || Chapter 20B: I’m Walkin’ Down This Rocky Road || Chapter 20C: You're The Only One Who Gets Through To Me || Chapter 20D: Together We Can Make It A Dream ||| Also posted at AO3
Chapter 20E: My Main Objective Is To Get You To Turn Your Mind Around
You are in my system Got me right down to the wire You are in my system Help my equilibrium You are in my system…
-- “You Are In My System,” Robert Palmer (1983) [click here to listen]
North Carolina || February 1989
Raymond scribbled on a fresh sheet in his notebook. Absently running his hand through his hair. Clearly thinking.
“All right,” he said, after a while. “Before I walk you through my plan – I need to ask you something. Both of you.”
“Anything,” Claire replied instantly.
“I need you to commit to this. To therapy. To getting better and stronger, as individuals and as a couple.”
“Of course,” Jamie breathed.
“Yes,” Claire echoed.
Raymond tilted his head, just a bit. “What I am going to ask of you will be a significant commitment of time and energy and effort. Obviously we’ll need to modify things to account for travel, but you need to agree to prioritize this.”
“Yes, I agree.” Jamie reached across the table for Raymond’s notebook. He flipped to an empty page, wrote I commit to Raymond’s plan, signed his name and wrote the date. He pulled back to let Claire sign her pledge and name as well.
“You don’t know what you’re agreeing to yet,” Raymond said quietly.
Jamie met his skeptical gaze. “It doesn’t matter. You’re here for a reason. I – we – want your help. So whatever you recommend, I will commit to doing.”
“Me too,” Claire added, pushing the notebook back across the table.
Raymond cleared his throat. “Well then. On typical days I’d like to have three sessions. Half an hour with each of you individually, and then an hour with both of you together. With the individual sessions taking place before our group session.”
“We can definitely do that.” Claire gripped Jamie’s hand on top of the table. “What do you think?”
Jamie nodded. “Yes. We will make it work. This is important. And you’ll of course be available if we need more time?”
“Definitely. To the extent you want time with me, I will make myself available. Nobody else – not your bandmates, Colum, not anyone on the crew – will be a client. I will quite literally be on call for you, 24/7. Jamie, if you start to have a panic attack, I don’t care what time it is or where we are, if you’re comfortable with me being there then I want to be there to help you.”
“And to support Claire,” Jamie added. “I won’t put all of that burden on her. It’s not fair to her.”
Claire squeezed her husband’s hand.
Raymond pivoted to face Claire across the table. “And Claire – I’m here for you in equal measure. I know you’re still adjusting to your sobriety. And I doubt you’ve worked through all of the trauma associated with your ex-husband.”
Claire swallowed. Jamie pulled her a little closer.
“So – if it ever feels too much, and especially if you start feeling like you’re losing a sense of yourself, when you’re so far away from home, and so out of your element…I want you to come to me. I want you to talk it through with me. And when you’re ready, we can talk with Jamie about it.”
She nodded, grateful.
“This goes without saying, but I’ll need you to continue to be as honest and open with me as possible. Our therapy isn’t going to work, otherwise. I’ve had clients in the past who struggled to be honest, and it ended up undermining their recovery. Especially the addicts.”
Claire poured a fresh glass of water for Raymond. He drank it all at once. Clearly choosing his next words very carefully.
“I will never judge you for anything you do or say – about your past or present selves. But the more you share, the more I can help you. And nothing you say to me will ever make its way to anyone else. Not Colum, not Ian and Angus, certainly not the crew. Definitely not the press. I’m bound by my professional code of ethics. And of course I’d never put you in that position.”
“Thank you,” Jamie breathed. “I want so hard for the most important things in my life to stay private.”
“But,” Raymond added, “If something comes up in one of our individual sessions that I think would benefit being discussed in our group session, I hope you’ll give me your permission to raise it. You’re already very open with each other, which makes my job easier. But I’m sure that both of you have things you haven’t told the other person about. So, I want you to know that if I bring up something one of you told me, in the presence of the other person, it’s purely because I want to get to the heart of a topic. To prompt a fruitful discussion.”
“I’m all right with that. I want to get better.” Jamie looked at Claire. Raised their joined hands to his lips, for a kiss. “I want us to get better, and stronger.”
“All the more reason to be honest with each other, and with me. Because as my favorite medical school professor told us – honesty has room for secrets, but not for lies. Do you agree?”
Jamie and Claire nodded.
Raymond smiled kindly. “I am so glad to have this opportunity to help and support you, at such this pivotal moment in your lives.”
Jamie laughed. “Don’t thank us yet. See how you feel in August, when you’ve been on the road for four months and you’re in bumfuck nowhere in Scandinavia and the blackout curtains won’t work in the hotel so that you can sleep.”
Raymond flipped to a new sheet in his notebook, smiling. “I’m going to recommend you do something, Jamie. Earlier we were talking about how it’s good to get a little separation sometimes.”
Jamie nodded, curious.
“I’m suggesting that you go out to L.A. in two and a half weeks, but on your own, with Claire staying here. She may fly out, let’s say, the final week. Or maybe not at all. What would you think about that?”
Jamie pursed his lips. Jaw clenching.
“I know why you’re suggesting it, Raymond. But…”
Raymond let the moment stretch. Watching, with Claire, Jamie process his thoughts.
“I want to say, no, I’ll never agree to that. I can’t go that long without having Claire with me.” He dropped Claire’s hand and crossed his arms.
“Why?”
“Besides the fact that I’ll miss her every second we’re apart? Because when I’m on the road, and doing industry stuff, and playing gigs, I know I’m going to see the things that I’m addicted to.”
“And you’re afraid that you’ll slide right back into that life, if you’re by yourself?”
Jamie heaved a deep breath. Raymond watched Claire hold herself back from giving her husband even the gentlest, most reassuring touch.
“Do you think he’d do that, Claire?”
She shook her head. “No way.”
Jamie huffed skeptically. “You have too much faith in me.”
“You should have more faith in yourself!” She stood, hands on her hips. “You’re so much stronger than you give yourself credit for, Jamie. Why don’t you see that?”
He covered his face with his hands, breathing deeply. “I know what I can do, Claire, when I lose control.”
“So do I, Jamie. But I know what you can do when you keep control. I know what you can say no to. Do you not remember that party in New York? It was hard, so fucking hard, but even though people were drinking all around us, and that model was doing coke two feet away from you,you were fine!”
Raymond kept his voice steady. “Do you really believe that at the drop of a hat, you’d forget your vows to Claire, Jamie? That you’d forget your commitment to sobriety?”
He nodded.
“But that’s never happened.” Claire lay a calm hand on Jamie’s shoulder, squeezing. “And just because I won’t be right next to you, or in the hotel room waiting for you, doesn’t mean that you will forget your promises.”
She rubbed his shoulder, so gentle.
“And, Jamie – to be honest, I could use the time here. To get to know the people at the clinic a bit better, get to know what kind of support they need. Obviously I won’t be around when we’re in Europe, and maybe not even after that if I come home pregnant. But I want them to get to know me, and I want to get to know them. And the best way I can do that is by spending time there, on my own. I can’t do that if I’m in L.A.”
Jamie pulled back to look up at his wife. She smiled down at him, pushing his hair out of his eyes.
Raymond gave them a moment before speaking. “When I suggested you go to L.A. alone, Jamie, you mentioned how you would feel, but you didn’t mention how you thought Claire would feel. Does what she wants not matter to you?”
“Of course it matters to me.” Jamie sounded a bit hurt.
“But you didn’t use those words to say that,” Raymond replied. “And you didn’t ask her what she thought about my idea. Claire does have a life beyond being your wife. She’s trying to find her footing. And she needs more space to do that. Has she ever told you that?”
Jamie looked directly at his wife. “Not like that,” he said softly. “Am I being too selfish?”
“You can be, sometimes.” Claire took a deep breath. “I know we’re both still healing, and figuring out how we live our lives together when everything is so complicated. This life we have together – it’s so wonderful, but it’s also so overwhelming. I want a family with you, Jamie – but I also want my career back. I know it won’t look like it did before, and I don’t want it to. And not right this instant, maybe not for a few more years. We have time to talk about it and figure that out.” She smiled at him. “That’s why I’m so glad that Raymond is here. Because he’ll give us the space to talk about these things.”
“Creating that space helps. So does re-framing a situation.” Raymond shifted in his chair. “Consider this: instead of feeling loss that you’re not together when Jamie is in L.A., or being afraid of what the world is like without the other…think of it as, two or so weeks of building new memories to eventually share. Two weeks of anticipation, to the buildup to being back together.”
“I like that,” Jamie said quietly. “And I see what you’re doing, Raymond. Turning something that could be negative, into something positive.”
“He’s not wrong, Jamie.”
Jamie sighed. “I know, Claire. I need time for me, and you need time for you. But I’ll still call you every day. Probably annoy the hell out of you.”
She laughed. “Of course you will. I want you to.” She turned to Raymond. “Can we start our sessions with you while he’s in L.A.?”
“Of course. We can do it all over the phone. But we can start tomorrow, if you like.”
Claire turned back to her husband. “Raymond asked us to be honest, Jamie. So when you speak with him, be honest. And when we have our session together, be honest. This is why we need his help. If you feel like you’re cracking, you need to fucking tell us. Do you understand?”
Jamie nodded. “I love you,” he rasped.
“I love you,” she laughed. “It’s just a few weeks, Jamie. Then we’ll be in Europe. You’ll get sick of me.”
He laughed, and it transformed his face. “Not possible.” He turned to look at Raymond. “I think you’ve got your work cut out for you, Doc.”
Raymond closed his notebook. “Well, you two will certainly keep things interesting.”
72 notes
·
View notes
Text
Author Stats for BFB
When putting together the Best Fantasy Book polls, I noticed that a lot of authors were popular choices, so I thought I'd do a little post about our most popular authors from ones that are in the list only twice to the most common author we have!
The preliminary round for BFB starts tomorrow!
2 Times
J. R. R. Tolkien
Erin Morgenstern
Cassandra Clare
Eoin Colfer
Terry Pratchett
Laini Taylor
Jim Butcher
Robin Hobb
R. F. Kuang
Samantha Shannon
Shannon Hale
Jonathan Stroud
Seanan McGuire
Enid Blyton
Clive Barker
Alix E. Harrow
Scott Westerfeld
Raymond E. Feist
Wayne Thomas Batson
Xiran Jay Zhao
Lloyd Alexander
Meagan Spooner
Katherine Addison
Christina Henry
Gene Wolfe
N. D. Wilson
Emily Rodda
Jude Watson
Ellen Kushner
Cliff McNish
C. J. Cherryh
Garry Kilworth
3 Times
Rick Riordan
Roald Dahl
Brandon Sanderson
Cornelia Funke
Gail Carson Levine
Garth Nix
T. Kingfisher
Patricia C. Wrede
Robin McKinley
Kieron Gillen
Francis Hardinge
4 Times
Holly Black
V. E. Schwab
Naomi Novik
5 Times
Diana Wynne Jones
6 Times
Tamora Pierce
9 Times
Neil Gaiman
Mercedes Lackey
#best fantasy book#info#stats#mercedes lackey#neil gaiman#tamora pierce#diana wynne jones#naomi novik#v e schwab#holly black#rick riordan#brandon sanderson#gail carson levine#roald dahl#cornelia funke#j r r tolkien#erin morgenstern#cassandra clare#eoin colfer#terry pratchett
29 notes
·
View notes
Note
Hello again. I it's alright with you, I had a "superlist" of Nintendo characters I wanted to suggest for the poll.
Kiwi (Pilotwings)
Goose (Pilotwings)
Ibis (Pilotwings)
Hawk (Pilotwings)
Robin [Hooter in Japan] (Pilotwings)
Ryota Hayami (Wave Race)
Akari Hayami (1080°)
Sakura Samurai
Trax
Monita (Nintendo Land)
Yuka (Rhythm Heaven)
Dr. Lobe (Big Brain Academy)
Dr. Kawashima (Brain Age)
Dr. Wright (SimCity)
Vince (Art Academy)
Harry (Teleroboxer)
Icarus (Glory of Heracles)
Frey and Freya (Zangeki no Reginleiv)
Raymond Bryce (Disaster: Day of Crisis)
Qbby (BOXBOY)
Eddy (Fluidity)
Nikki (Swapnote)
Wonder-Red (The Wonderful 101)
Zael (The Last Story)
Calista (The Last Story)
Aeron (Pandora's Tower)
Elena (Pandora's Tower)
Tamagon (Devil World)
Barbara the Bat (Jam with the Band)
Mallo (Pushmo)
Hunter (Fossil Fighters)
Dillon (Dillon's Rolling Western)
Mach Rider
F-Type (Stunt Race FX)
Kageshina Kurabe (Nintendouji)
Excitebiker
Balloon Fighter
Alice (Balloon Kid)
Bubbles (Clu Clu Land)
DeMille (Tomato Adventure)
Kururin (Kuru Kuru Kururin)
Hakkun (Sutte Hakkun)
Dion (Marvelous: Another Treasure Island)
Sheriff
Muddy Mole (Mole Mania)
Michael Anderson (Battle Clash)
Fighter Hayabusa (Pro Wrestling)
Ouendan (Ryuta Ippongi, Atsushi Saito, Ittetsu Suzuki)
Ouendan Cheerleaders (Sayaka Amemiya, Aoi Kanda, Anna Lindhurst
Elite Beat Divas (Starr, Missy, Foxx)
Mr. Stevenson (Gumshoe)
Ray (Custom Robo)
Alexandra Roivas (Eternal Darkness)
Jonathan Raimi (Geist)
Naomi Moriha (Jet Impulse)
Satoru (from Card Hero)
Satoru Amatsubo (Project H.A.C.K.E.R.)
Goku (Yuyuki)
Chao (Yuyuki)
Donbe (Shin Onigashima)
Hikari (Shin Onigashima)
Saki Amamiya (Sin & Punishment)
Ando Kensaku (And-Kensaku)
Arcade Bunny (Nintendo Badge Arcade)
Orville (Takt of Magic) Doshin (Doshin the Giant)
Jashin (Doshin the Giant)
Cupid (Sennen Kazoku)
Aisya (ASH: Archaic Sealed Heat)
Diskun
Jill (Drill Dozer)
Tempo (HarmoKnight)
Welt (Soma Bringer)
Idea (Soma Bringer)
Warrior Mech Gauss (Chōsōjū Mecha MG)
I could make a round 4 from this list alone. Plus some other suggestions. But I’ll wait until round 3 is done
EDIT: Wonderful 101 isn’t Nintendo, so It’ll be added to another idea I have (Non Nintendo Nintendo characters. Characters not owned by Nintendo but associated with them )
9 notes
·
View notes
Text
A lot of ups and downs at the Iron and Powder Hair Salon
#the sims 2#sims 2#ts2#bacc#the sims 2 bacc#sims 2 bacc#ts2 bacc#bacc seaport#seaport#macleod: round 4#round 4#sim: nico macleod#sim: kristi#sim: lily everett#sim: elspeth#sim: james barnett#sim: zach hall#sim: lou long#sim: margie#sim: wesley raymond#sim: yves
7 notes
·
View notes
Text
Tavian’s unofficial list of flash gordon adaptations. I haven’t actually read that many.
1- Dan Schkades newspaper run I trust his characterization deeply.
2- the dynamite run it’s fun I like it
3- buster crabbe serials. Have I seen any? No. The only thing I know is I like him the most aesthetically. He’s hot imo so he gets points from me.
4- the kings crossing etc etc comics they’re fine he has cute moments haha
5- ummm I don’t know anything about the DC run Dan jurgens drew stuff for but I like booster gold so he gets brownie points from me
6- the 90s cartoon where he has a crop top and a skateboard. It’s funny.
7- defenders of the earth. Man idk. Up in the sky. His rockets ignite. Etc etc
8- the current run by mad cave studios I haven’t read this. I just don’t enjoy the art style haha maybe it’s good
9- the like original Alex Raymond comics. Don’t enjoy the Sinophobia. Points i guess for always making him half naked and in panties
10- the movie I have such vitriol for its Hes not even hot
Bonus round: Flash Gordon and the baby animals

7 notes
·
View notes
Text
. . NEXT ON STAGE!
🎀 o A BOYBAND SUBSYS [SUPPORTING ROLE!] FOR ANON! under the cut cause it's pretty long!
name (s) ;; Crest, Doe, Cap, Indigo, Autumn
pronoun(s) ;; She/Her, Fall/Fall, Hum/Hum, Emo/Emos
gender(s) ;; Transmasc Girl, Bigender
sexuality;; Aromantic, Asexual
subsys role ;; Trauma Holder, Soother
source(s) ;; None, “The Moody one”
faceclaim(s) ;; n/a
silly meter ;; 7/10
interaction level ;; interact with care
name (s) ;; Valentine, Hero, Darling, Starlo
pronoun(s) ;; Them/Them, Luv/Luvs, Kiss/Kiss, Hart/Harts
gender(s) ;; Cis, Lovegender
sexuality;; Gay, Greysexual
subsys role ;; Host, Protector
source(s) ;; None, The “Heartthrob”
faceclaim(s) ;; n/a
silly meter ;; 6/10
interaction level ;; free to interact!
name (s) ;; Blooky, Dash, Sheep, Ram, Tim
pronoun(s) ;; He/Him, Hide/Hides, Tune/Tunes, Violin/Violins
gender(s) ;; Musicgender, Nonbinary
sexuality;; Homoflexible
subsys role ;; Anxiety Holder, Co-Host
source(s) ;; None, The “Shy One”
faceclaim(s) ;; n/a
silly meter ;; 4/10
interaction level ;; Safe To Interact
name (s) ;; Mickey, Raymond, Jean, Leslie, Spencer
pronoun(s) ;; Lead/Leads, Mic/Mics, They/Them, Piano/Pianos
gender(s) ;; Unlabled
sexuality;; Acespec, Unlabled
subsys role ;; Middle
source(s) ;; None, the “Rounded Leader”
faceclaim(s) ;; n/a
silly meter ;; 7/10
interaction level ;; interact with extreme caution
name (s) ;; Honey, Deer, Charm, Plushie, Bunny
pronoun(s) ;; Cute/Cute, They/Them, It/it's, Squeak/Squeaks, Paw/Paws
gender(s) ;; Agender, Demiboy
sexuality;; Lesbian, Lesboy
subsys role ;; Anger Holder
source(s) ;; None, The “Cute One”
faceclaim(s) ;; n/a
silly meter ;; 10/10
interaction level ;; interact with caution
3 notes
·
View notes
Text
Who is most important to the history of Doctor Who?
With 61 years under its belt, Doctor Who has changed a lot since it began all those years ago. Its continued survival has relied on that change and the countless people who made it happen. Trying to single out any one person as the most important to the history of the show would be near impossible, but hell if we aren't going to try.
bar a few of the most recognisable names, contestants for this tournament were decided by nomination only, so there are inevitably people missing who's contributions were just as valuable, please don't take anyone's absence as a slight against them or their work
the submission form for propaganda is still open
SEMIFINALS
Verity Lambert vs All the thousands of people who've worked behind the scenes
Sydney Newman vs Terry Nation
QUARTERFINALS
Verity Lambert vs Roger Delgado
Russell T Davies vs All the thousands of people who've worked behind the scenes
William Hartnell vs Sydney Newman
Terry Nation vs Murray Gold
previous rounds under the cut
ROUND 4
Verity Lambert vs Delia Derbyshire
June Hudson vs Roger Delgado
Russell T Davies vs Nicholas Courtney
David Whitaker vs All the thousands of people who've worked behind the scenes
William Hartnell vs Waris Hussein
Liz Sladen vs Sydney Newman
Terry Nation vs Christopher Eccleston
Jodie Whittaker vs Murray Gold
ROUND 3
Verity Lambert vs The BBC Radiophonic Workshop
Delia Derbyshire vs Gary Russell
Robert Shearman vs June Hudson
David Tennant vs Roger Delgado
Russell T Davies vs David Graham & Peter Hawkins
Nicholas Courtney vs Rona Munro
Paul McGann vs David Whitaker
Terrance Dicks vs All the theousands of people who've worked behind the scenes
William Hartnell vs Julie Gardner
Tom Baker vs Waris Hussein
Liz Sladen vs Nicholas Briggs
Billie Piper vs Sydney Newman
Terry Nation vs Alice Troughton
Ron Grainer vs Christopher Eccleston
Jodie Whitteker vs Kate Orman
Murray Gold vs Dudley Simpson
ROUND 2
DAY 2
William Hartnell vs Philip Hinchcliffe
Julie Gardner vs Ncuti Gatwa
Tom Baker vs Jacqueline Hill
Craig Ferguson vs Waris Hussein
Liz Sladen vs Colin Baker
Douglas Adams vs Nicholas Briggs
Sophie Aldred vs Billie Piper
Peter Davison vs Sydney Newman
Terry Nation vs Steven Moffat
Alice Troughton vs Marc Platt
Patrick Troughton vs Ron Grainer
Jonathan Blum vs Christopher Eccleston
Jodie Whittaker vs Lisa Bowerman
Anthony Coburn vs Kate Orman
Murray Gold vs Rachel Talalay
Dudley Simpson vs Sue from Catering
DAY 1
Verity Lambert vs Segun Akinola
Graeme Harper vs The BBC Radiophonic Workshop
Delia Derbyshire vs Robert Holmes
Gary Russell vs The Audience
Robert Shearman vs Peter Cregeen
June Hudson vs Raymond Cusick
David Tennant vs Sylvester McCoy
Kit Pedler vs Roger Delgado
Russell T Davies vs Barry Letts
David Graham & Peter Hawkins vs John F Kennedy
Paul Cornell vs Nicholas Courtney
Rona Munro vs the anonymous creator of TARDIS wiki
Paul McGann vs William Shakespeare
David Whitaker vs Lawrence Miles
Peter Capaldi vs Terrance Dicks
Justin Richards vs All the thousands of people who’ve worked behind the scenes
ROUND 1 (group stage)
Group 1
Carole Ann Ford
Jacqueline Hill
William Hartnell
William Russell
David Graham and Peter Hawkins
Group 2
Patrick Troughton
Frazer Hines
Nicholas Courtney
Jon Pertwee
Roger Delgado
Group 3
Liz Sladen
Pat Gorman
Stuart Fell
Tom Baker
Peter Davison
Colin Baker
Group 4
Sylvester McCoy
Sophie Aldred
Paul McGann
Lisa Bowerman
India Fisher
Sean Carlsen
Group 5
Christopher Eccleston
Billie Piper
David Tennant
Freema Agyeman
John Simm
Group 6
Matt Smith
Peter Capaldi
Jodie Whittaker
Ncuti Gatwa
Group 7
Michael Grade
Peter Cregeen
Sydney Newman
Gary Russell
Nicholas Briggs
Donald Wilson
Group 8
all the thousands of people who’ve worked behind the scenes
June Hudson
Peter Brachacki
Raymond Cusick
Group 9
John F Kennedy
Sue from Catering
the real people who have been portrayed in the show
William Russell
Group 10
Marnal Gate
Person who created TARDIS wiki
Craig Ferguson
The Audience
Group 11
BBC Radiophonic Workshop
Delia Derbyshire
Ron Grainer
Dudley Simpson
Paddy Kingsland
Peter Howell
Robert Harvey
Segun Akinola
Murray Gold
Group 12
Graeme Harper
Paddy Russell
Rachel Talalay
Waris Hussein
Christopher Barry
Richard Martin
Alice Troughton
Group 13
Barry Letts
Graham Williams
John Nathan Turner
Philip Hinchcliffe
Verity Lambert
Julie Gardner
Group 14
Alan Moore
Grant Morrison
Marc Platt
Paul Cornell
Kate Orman
Group 15
Justin Richards
Dave Stone
Lawrence Miles
Lance Parkin
Jonathan Blum
Robert Shearman
Group 16
David Whitaker
Terry Nation
Anthony Coburn
John Lucarotti
Gerry Davis
Kit Pedler
Terrance Dicks
Group 17
Robert Holmes
Douglas Adams
Eric Saward
Andrew Cartmel
Rona Munro
Russell T Davies
Steven Moffat
Chris Chibnall
links to previous tournaments
52 notes
·
View notes
Text
Loser Bracket Round 3, Match 4
Canoness Selena Agna (Warhammer 40000: Dawn of War - Soulstorm) vs Sister Monica Joan (Call The Midwife)


Canoness Selena Agna is a Sister of Battle of the Order of the Sacred Rose.
Sister Monica Joan is an Anglican nun of the Order of St. Raymond Nonnatus and is a retired midwife.
Canoness Selena Agna
No propaganda submitted.
Sister Monica Joan
She may not be all there upstairs all the time but she provides essential spiritual guidance to the Popular community when they need it most, and fun facts when they are just chilling. She served the community for so long many of the residents are either babies she helped deliver or their children. When she became a nun, the call took her to a life of service from a life of comfort and security. Plus she is a total Doctor Who girl
#best nun tournament#poll#poll tournament#Loser Bracket#Loser Bracket Round 3#Selena Agna#warhammer 40k#warhammer#warhammer 40000#dawn of war#sisters of battle#adepta sororitas#Sister Monica Joan#Call the Midwife
8 notes
·
View notes
Text
RULES: list 5 of your favorite books on a poll, so your followers can vote which book they think captures your vibe the best Thank you @some-anonymity-preferred for the tag!
There is a v. real chance that, given my druthers, I would just endlessly re-read Wodehouse novels forever so picking just one is nigh impossible. I chose this one because it's the American release of "Much Obliged, Jeeves" wherein there's typical Jeeves and Wooster shenanigans involving Bertie trying to help his gormless friends with well-meaning ineptitude, MULTIPLE mistaken engagements to break, and Jeeves temporarily hanging Bertie out to dry, but ultimately cleverly saving the day, but (spoilers for a book that's older than I am, I guess) the American editor didn't believe that Jeeves would vandalize the Club Book that causes all the problems without good reason, and so there's an extra three pages or so where he explains that the club doesn't need to know about Bertie's bad behavior because the purpose of the book is to let prospective employees know what they're in for, and Jeeves doesn't intend to ever let anyone else but him work for Bertie because "there's a tie that binds." I mean, really!
Phillip Marlow gets hired to find the missing wife of a perfume magnate, which, of course, leads through a noir-stravaganza of bodies stacking up like cord wood and seemingly unrelated threads that all weave together in the end to form a tapestry of femme fatales and mistaken identities.
A post-modern multiple embedded-frame-narrative about a film that doesn't exist about a house that CAN'T exist, the blind amateur academic who deconstructs it, and the LA burnout who found and assembled the academic's disparate scriblings (and sometimes his editors). But also it's about how the fracturing of interpersonal relationships fragments fractally out into every aspect of your life and how the cost of pursuing single-minded obsession/excellence is a kind of haunting in itself.
Hey! You got your medieval high fantasy in my fully automated luxury sci-fi utopia (post-apocalyptic edition). A lady wizard and her magic-bonded troth-knight platonic husband leads a gaggle of youths from a tiny village in the back-end of nowhere on a journey of danger and excitement because one of them is the prophesized reincarnation of the man that was responsible for the breaking of the world and this go 'round will either ultimately save the world from the forces of Evil or fall to the Shadow himself. But also we're deconstructing the hero narrative.
Get in, loser - we're hunting Dracula. By reading our dad's love letters.
Tagging (no presh!) @nicnacsnonsense, @poetic----nonsense, @chocolatepot, @neverbelessthan & @blakbonnet
6 notes
·
View notes
Text
Structured Query Language (SQL): A Comprehensive Guide
Structured Query Language, popularly called SQL (reported "ess-que-ell" or sometimes "sequel"), is the same old language used for managing and manipulating relational databases. Developed in the early 1970s by using IBM researchers Donald D. Chamberlin and Raymond F. Boyce, SQL has when you consider that end up the dominant language for database structures round the world.
Structured query language commands with examples
Today, certainly every important relational database control system (RDBMS)—such as MySQL, PostgreSQL, Oracle, SQL Server, and SQLite—uses SQL as its core question language.
What is SQL?
SQL is a website-specific language used to:
Retrieve facts from a database.
Insert, replace, and delete statistics.
Create and modify database structures (tables, indexes, perspectives).
Manage get entry to permissions and security.
Perform data analytics and reporting.
In easy phrases, SQL permits customers to speak with databases to shop and retrieve structured information.
Key Characteristics of SQL
Declarative Language: SQL focuses on what to do, now not the way to do it. For instance, whilst you write SELECT * FROM users, you don’t need to inform SQL the way to fetch the facts—it figures that out.
Standardized: SQL has been standardized through agencies like ANSI and ISO, with maximum database structures enforcing the core language and including their very own extensions.
Relational Model-Based: SQL is designed to work with tables (also called members of the family) in which records is organized in rows and columns.
Core Components of SQL
SQL may be damaged down into numerous predominant categories of instructions, each with unique functions.
1. Data Definition Language (DDL)
DDL commands are used to outline or modify the shape of database gadgets like tables, schemas, indexes, and so forth.
Common DDL commands:
CREATE: To create a brand new table or database.
ALTER: To modify an present table (add or put off columns).
DROP: To delete a table or database.
TRUNCATE: To delete all rows from a table but preserve its shape.
Example:
sq.
Copy
Edit
CREATE TABLE personnel (
id INT PRIMARY KEY,
call VARCHAR(one hundred),
income DECIMAL(10,2)
);
2. Data Manipulation Language (DML)
DML commands are used for statistics operations which include inserting, updating, or deleting information.
Common DML commands:
SELECT: Retrieve data from one or more tables.
INSERT: Add new records.
UPDATE: Modify existing statistics.
DELETE: Remove information.
Example:
square
Copy
Edit
INSERT INTO employees (id, name, earnings)
VALUES (1, 'Alice Johnson', 75000.00);
three. Data Query Language (DQL)
Some specialists separate SELECT from DML and treat it as its very own category: DQL.
Example:
square
Copy
Edit
SELECT name, income FROM personnel WHERE profits > 60000;
This command retrieves names and salaries of employees earning more than 60,000.
4. Data Control Language (DCL)
DCL instructions cope with permissions and access manage.
Common DCL instructions:
GRANT: Give get right of entry to to users.
REVOKE: Remove access.
Example:
square
Copy
Edit
GRANT SELECT, INSERT ON personnel TO john_doe;
five. Transaction Control Language (TCL)
TCL commands manage transactions to ensure data integrity.
Common TCL instructions:
BEGIN: Start a transaction.
COMMIT: Save changes.
ROLLBACK: Undo changes.
SAVEPOINT: Set a savepoint inside a transaction.
Example:
square
Copy
Edit
BEGIN;
UPDATE personnel SET earnings = income * 1.10;
COMMIT;
SQL Clauses and Syntax Elements
WHERE: Filters rows.
ORDER BY: Sorts effects.
GROUP BY: Groups rows sharing a assets.
HAVING: Filters companies.
JOIN: Combines rows from or greater tables.
Example with JOIN:
square
Copy
Edit
SELECT personnel.Name, departments.Name
FROM personnel
JOIN departments ON personnel.Dept_id = departments.Identity;
Types of Joins in SQL
INNER JOIN: Returns statistics with matching values in each tables.
LEFT JOIN: Returns all statistics from the left table, and matched statistics from the right.
RIGHT JOIN: Opposite of LEFT JOIN.
FULL JOIN: Returns all records while there is a in shape in either desk.
SELF JOIN: Joins a table to itself.
Subqueries and Nested Queries
A subquery is a query inside any other query.
Example:
sq.
Copy
Edit
SELECT name FROM employees
WHERE earnings > (SELECT AVG(earnings) FROM personnel);
This reveals employees who earn above common earnings.
Functions in SQL
SQL includes built-in features for acting calculations and formatting:
Aggregate Functions: SUM(), AVG(), COUNT(), MAX(), MIN()
String Functions: UPPER(), LOWER(), CONCAT()
Date Functions: NOW(), CURDATE(), DATEADD()
Conversion Functions: CAST(), CONVERT()
Indexes in SQL
An index is used to hurry up searches.
Example:
sq.
Copy
Edit
CREATE INDEX idx_name ON employees(call);
Indexes help improve the performance of queries concerning massive information.
Views in SQL
A view is a digital desk created through a question.
Example:
square
Copy
Edit
CREATE VIEW high_earners AS
SELECT call, salary FROM employees WHERE earnings > 80000;
Views are beneficial for:
Security (disguise positive columns)
Simplifying complex queries
Reusability
Normalization in SQL
Normalization is the system of organizing facts to reduce redundancy. It entails breaking a database into multiple related tables and defining overseas keys to link them.
1NF: No repeating groups.
2NF: No partial dependency.
3NF: No transitive dependency.
SQL in Real-World Applications
Web Development: Most web apps use SQL to manipulate customers, periods, orders, and content.
Data Analysis: SQL is extensively used in information analytics systems like Power BI, Tableau, and even Excel (thru Power Query).
Finance and Banking: SQL handles transaction logs, audit trails, and reporting systems.
Healthcare: Managing patient statistics, remedy records, and billing.
Retail: Inventory systems, sales analysis, and consumer statistics.
Government and Research: For storing and querying massive datasets.
Popular SQL Database Systems
MySQL: Open-supply and extensively used in internet apps.
PostgreSQL: Advanced capabilities and standards compliance.
Oracle DB: Commercial, especially scalable, agency-degree.
SQL Server: Microsoft’s relational database.
SQLite: Lightweight, file-based database used in cellular and desktop apps.
Limitations of SQL
SQL can be verbose and complicated for positive operations.
Not perfect for unstructured information (NoSQL databases like MongoDB are better acceptable).
Vendor-unique extensions can reduce portability.
Java Programming Language Tutorial
Dot Net Programming Language
C ++ Online Compliers
C Language Compliers
2 notes
·
View notes