#Streaming Database

[dromologue]

Stream processing has existed for decades. The adoption grows with open source frameworks like Apache Kafka and Flink in combination with fully managed cloud services. This blog post explores the past, present and future of stream processing, including the relation of machine learning and GenAI, streaming databases, and the integration between data streaming and data lakes with Apache Iceberg. The post The Past, Present and Future of Stream Processing appeared first on Kai Waehner.

[dawawae]

Drama so bad it resurrected me to yap

[clownkiwi]

it's been a while since we held a stream where i indulged on my special interests... it's time we change that now...

let's take a look at some old TV bumpers & VHS logos... this is an

AVID WIKI DEEP DIVE

going live at 8pm EST

[simeonscott]

Opening SHFs and Celebrating the Creators that got me into Toku! - Vacstream 8/29/2023

Gonna be streaming on Tuesday night, come join if ya can!

[goldendirk]

listening to a "obscure" music is wonderful until i want to actually know anything. anyways, the album on spotify is listed as being released by the edition: freispiel label (whose parent label is freibank), but on discogs and bandcamp the label is listed as klangbad. and on bandcamp they actually seem to only have the 2003 demos of the album, not the album itself. and that doesnt go over the fact that there is only this one album on spotify. an e wayzzz, something something god i hate streaming services, why and how are your databases always so ridiculously wrong

[saltiestbunny]

bunnification~ character: shibbuns art/animation: saltiestbun

[bunnygirl678]

someone stop me before i blow up

i literally cannot find anywhere streaming classic christmas movies

can't even watch them on tv like you have to join a stupid streaming service

god i wish i had these on dvd

[jcmarchi]

How Combining RAG with Streaming Databases Can Transform Real-Time Data Interaction

New Post has been published on https://thedigitalinsider.com/how-combining-rag-with-streaming-databases-can-transform-real-time-data-interaction/

How Combining RAG with Streaming Databases Can Transform Real-Time Data Interaction

While large language models (LLMs) like GPT-3 and Llama are impressive in their capabilities, they often need more information and more access to domain-specific data. Retrieval-augmented generation (RAG) solves these challenges by combining LLMs with information retrieval. This integration allows for smooth interactions with real-time data using natural language, leading to its growing popularity in various industries. However, as the demand for RAG increases, its dependence on static knowledge has become a significant limitation. This article will delve into this critical bottleneck and how merging RAG with data streams could unlock new applications in various domains.

How RAGs Redefine Interaction with Knowledge

Retrieval-Augmented Generation (RAG) combines large language models (LLMs) with information retrieval techniques. The key objective is to connect a model’s built-in knowledge with the vast and ever-growing information available in external databases and documents. Unlike traditional models that depend solely on pre-existing training data, RAG enables language models to access real-time external data repositories. This capability allows for generating contextually relevant and factually current responses.

When a user asks a question, RAG efficiently scans through relevant datasets or databases, retrieves the most pertinent information, and crafts a response based on the latest data. This dynamic functionality makes RAG more agile and accurate than models like GPT-3 or BERT, which rely on knowledge acquired during training that can quickly become outdated.

The ability to interact with external knowledge through natural language has made RAGs essential tools for businesses and individuals alike, especially in fields such as customer support, legal services, and academic research, where timely and accurate information is vital.

How RAG Works

Retrieval-augmented generation (RAG) operates in two key phases: retrieval and generation. In the first phase, retrieval, the model scans a knowledge base—such as a database, web documents, or a text corpus—to find relevant information that matches the input query. This process utilizes a vector database, which stores data as dense vector representations. These vectors are mathematical embeddings that capture the semantic meaning of documents or data. When a query is received, the model compares the vector representation of the query against those in the vector database to locate the most relevant documents or snippets efficiently.

Once the relevant information is identified, the generation phase begins. The language model processes the input query alongside the retrieved documents, integrating this external context to produce a response. This two-step approach is especially beneficial for tasks that demand real-time information updates, such as answering technical questions, summarizing current events, or addressing domain-specific inquiries.

The Challenges of Static RAGs

As AI development frameworks like LangChain and LlamaIndex simplify the creation of RAG systems, their industrial applications are rising. However, the increasing demand for RAGs has highlighted some limitations of traditional static models. These challenges mainly stem from the reliance on static data sources such as documents, PDFs, and fixed datasets. While static RAGs handle these types of information effectively, they often need help with dynamic or frequently changing data.

One significant limitation of static RAGs is their dependence on vector databases, which require complete re-indexing whenever updates occur. This process can significantly reduce efficiency, particularly when interacting with real-time or constantly evolving data. Although vector databases are adept at retrieving unstructured data through approximate search algorithms, they lack the ability to deal with SQL-based relational databases, which require querying structured, tabular data. This limitation presents a considerable challenge in sectors like finance and healthcare, where proprietary data is often developed through complex, structured pipelines over many years. Furthermore, the reliance on static data means that in fast-paced environments, the responses generated by static RAGs can quickly become outdated or irrelevant.

The Streaming Databases and RAGs

While traditional RAG systems rely on static databases, industries like finance, healthcare, and live news increasingly turn to stream databases for real-time data management. Unlike static databases, streaming databases continuously ingest and process information, ensuring updates are available instantly. This immediacy is crucial in fields where accuracy and timeliness matter, such as tracking stock market changes, monitoring patient health, or reporting breaking news. The event-driven nature of streaming databases allows fresh data to be accessed without the delays or inefficiencies of re-indexing, which is common in static systems.

However, the current ways of interacting with streaming databases still rely heavily on traditional querying methods, which can struggle to keep pace with the dynamic nature of real-time data. Manually querying streams or developing custom pipelines can be cumbersome, especially when vast data must be analyzed quickly. The lack of intelligent systems that can understand and generate insights from this continuous data flow highlights the need for innovation in real-time data interaction.

This situation creates an opportunity for a new era of AI-powered interaction, where RAG models seamlessly integrate with streaming databases. By combining RAG’s ability to generate responses with real-time knowledge, AI systems can retrieve the latest data and present it in a relevant and actionable way. Merging RAG with streaming databases could redefine how we handle dynamic information, offering businesses and individuals a more flexible, accurate, and efficient way to engage with ever-changing data. Imagine financial giants like Bloomberg using chatbots to perform real-time statistical analysis based on fresh market insights.

Use Cases

The integration of RAGs with data streams has the potential to transform various industries. Some of the notable use cases are:

Real-Time Financial Advisory Platforms: In the finance sector, integrating RAG and streaming databases can enable real-time advisory systems that offer immediate, data-driven insights into stock market movements, currency fluctuations, or investment opportunities. Investors could query these systems in natural language to receive up-to-the-minute analyses, helping them make informed decisions in rapidly changing environments.

Dynamic Healthcare Monitoring and Assistance: In healthcare, where real-time data is critical, the integration of RAG and streaming databases could redefine patient monitoring and diagnostics. Streaming databases would ingest patient data from wearables, sensors, or hospital records in real time. At the same time, RAG systems could generate personalized medical recommendations or alerts based on the most current information. For example, a doctor could ask an AI system for a patient’s latest vitals and receive real-time suggestions on possible interventions, considering historical records and immediate changes in the patient’s condition.

Live News Summarization and Analysis: News organizations often process vast amounts of data in real time. By combining RAG with streaming databases, journalists or readers could instantly access concise, real-time insights about news events, enhanced with the latest updates as they unfold. Such a system could quickly relate older information with live news feeds to generate context-aware narratives or insights about ongoing global events, offering timely, comprehensive coverage of dynamic situations like elections, natural disasters, or stock market crashes.

Live Sports Analytics: Sports analytics platforms can benefit from the convergence of RAG and streaming databases by offering real-time insights into ongoing games or tournaments. For example, a coach or analyst could query an AI system about a player’s performance during a live match, and the system would generate a report using historical data and real-time game statistics. This could enable sports teams to make informed decisions during games, such as adjusting strategies based on live data about player fatigue, opponent tactics, or game conditions.

The Bottom Line

While traditional RAG systems rely on static knowledge bases, their integration with streaming databases empowers businesses across various industries to harness the immediacy and accuracy of live data. From real-time financial advisories to dynamic healthcare monitoring and instant news analysis, this fusion enables more responsive, intelligent, and context-aware decision-making. The potential of RAG-powered systems to transform these sectors highlights the need for ongoing development and deployment to enable more agile and insightful data interactions.

[thedbahub]

Optimizing SQL Server Performance: Addressing Bottlenecks in Repartition Streams

Repartition Streams The term “Repartition Streams” in SQL Server refers to a phase in the query execution process, particularly in the context of parallel processing. It’s a mechanism used to redistribute data across different threads to ensure that the workload is evenly balanced among them. This operation is crucial for optimizing the performance of queries that are executed in parallel,…

[sayruq]

Officially the Palestinian death toll has passed 30,000. As this article will tell you, the official count is far below the actual death count

Gaza's health ministry said Thursday that the number of Palestinians killed in the war has surpassed 30,000. The official number now stands at 30,035 deaths. The figure is widely viewed as the most reliable one available. The health ministry provided NPR with one of its latest reports on the death toll, 38 pages long, to analyze. A close look at how Gaza's health ministry counts those killed in the war reveals a system that is buckling under the weight of war and unable to keep an accurate toll of the dead. Thousands remain unaccounted for — either missing under the rubble, buried hastily in side streets or decomposing in areas that can't be safely reached.

The Gaza health ministry says its daily tally now relies on a combination of accurate death counts from hospitals that are still partially operating, and on estimates from media reports to assess deaths in the north of Gaza, where Israeli forces control access. Its detailed daily report shows that its electronic system for counting the dead was disrupted on Nov. 12, when communication was lost with three major hospitals in the north, soon followed by more in other parts of Gaza. In the early days of the war, as the wounded and dead streamed into hospitals, Gaza's health ministry kept a detailed daily count of the number of people killed. Public and private hospitals were recording into an electronic database the names, ages, genders and ID numbers of the dead.

[rajaniesh]

Empower Data Analysis with Materialized Views in Databricks SQL

Envision a realm where your data is always ready for querying, with intricate queries stored in a format primed for swift retrieval and analysis. Picture a world where time is no longer a constraint, where data handling is both rapid and efficient.

[stellophiliac]

how to build a digital music collection and stuff

spotify sucks aaaass. so start downloading shit!!

file format glossary

.wav is highest quality and biggest

.mp3 is very small, but uses lossy compression which means it's lower quality

.flac is smaller than .wav, but uses lossless compression so it's high quality

.m4a is an audio file format that apple uses. that's all i really know

downloading the music

doubledouble.top is a life saver. you can download from a variety of services including but not limited to apple music, spotify, soundcloud, tidal, deezer, etc.

i'd recommend ripping your music from tidal or apple music since they're the best quality (i think apple music gives you lossless audio anyway. .m4a can be both lossy and lossless, but from the text on doubledouble i assume they're ripping HQ files off apple music)

i also love love love cobalt.tools for ripping audio/video from youtube (they support a lot of other platforms too!)

of course, many artists have their music on bandcamp — purchase or download directly from them if you can. bandcamp offers a variety of file formats for download

file conversion

if you're downloading from apple music with doubledouble, it spits out an .m4a file.

.m4a is ok for some people but if you prefer .flac, you may wanna convert it. ffmpeg is a CLI (terminal) tool to help with media conversion

if you're on linux or macOS, you can use parameter expansion to batch convert all files in a folder. put the files in one place first, then with your terminal, cd into the directory and run:

for i in *.m4a; do ffmpeg -i "$i" "${i%.*}.flac"; done

this converts from .m4a to .flac — change the file extensions if needed.

soulseek

another way to get music is through soulseek. soulseek is a peer-to-peer file sharing network which is mainly used for music. nicotine+ is a pretty intuitive (and open-source) client if you don't like the official one.

you can probably find a better tutorial on soulseek somewhere else. just wanted to make this option known

it's bad etiquette to download from people without sharing files of your own, so make sure you've got something shared. also try to avoid queuing up more than 1-2 albums from one person in a row

tagging & organizing your music

tagging: adding metadata to a music file (eg. song name, artist name, album) that music players can recognize and display

if you've ripped music from a streaming platform, chances are it's already tagged. i've gotten files with slightly incorrect tags from doubledouble though, so if you care about that then you might wanna look into it

i use musicbrainz picard for my tagging. they've got pretty extensive documentation, which will probably be more useful than me

basically, you can look up album data from an online database into the program, and then match each track with its file. the program will tag each file correctly for you (there's also options for renaming the file according to a certain structure if you're into that!)

there's also beets, which is a CLI tool for... a lot of music collection management stuff. i haven't really used it myself, but if you feel up to it then they've got extensive documentation too. for most people, though, it's not really a necessity

how you wanna organize your music is completely up to you. my preferred filestructure is:

artist > album > track # track

using a music player

the options for this are pretty expansive. commonly used players i see include VLC, foobar2000, clementine (or a fork of it called strawberry), and cmus (for the terminal)

you can also totally use iTunes or something. i don't know what audio players other systems come with

i personally use dopamine. it's a little bit slow, but it's got a nice UI and is themeable plus has last.fm support (!!!)

don't let the github page fool you, you don't have to build from source. you can find the releases here

click the "assets" dropdown on the most recent release, and download whichever one is compatible with your OS

syncing

if you're fine with your files just being on one device (perhaps your computer, but perhaps also an USB drive or an mp3 player), you don't have to do this

you can sync with something like google drive, but i hate google more than i hate spotify

you can get a free nextcloud account from one of their providers with 2GB of free storage. you can use webDAV to access your files from an app on your phone or other device (documents by readdle has webDAV support, which is what i use)

disroot and blahaj.land are a couple providers i know that offer other services as well as nextcloud (so you get more with your account), but accounts are manually approved. do give them a look though!!

if you're tech-savvy and have an unused machine lying around, look into self-hosting your own nextcloud, or better yet, your own media server. i've heard that navidrome is a pretty good audio server. i unfortunately don't have experience with self-hosting at the moment so i have like zero advice to give here. yunohost seems to be a really easy way to manage a server

afterword

i don't know if any of this is helpful, but i just wanted to consolidate my personal advice in one place. fuck big tech. own your media, they could take it away from you at any moment

[dollerinna]

WOULD YOU LIKE AN ALMOND JOY .ᐣ

( black noir x gn!crime analyst reader )

summary: after a long day of work, you try to unwind by watching your comfort show, but your solitude is interrupted by yet another visit from noir, who seems to be finding more and more excuses to spend time with you… (includes a C.AI bot as part 2 below!)

wordcount: 2k

tags: brief mention of NSFW pop-up ads, nerdy n’ socially awkward reader, noir’s disdain for almond joys but he makes up for it at the end <3

It had been a long day at the crime analytics office in Vought. As the sun began to set, exhaustion crept over you after reviewing incident report after report. Your eyes strained from the blue glare of your computer screen. You knew you had promised your boss you would organize the ever-growing database, but the tiny voice of procrastination was pleading for rest before your overworked brain turned into a pile of mush.

Rather than more paperwork—you, being the slacker of all slackers in this department, decided a well-deserved break was in order. And what better way to recharge than turning off the noggin and filling it with good ol’ fashioned mindless entertainment?

With a few tired clicks of your mouse, you booted up your go-to streaming site, which was none other than 123movies. Scrolling through the options, your cursor hovered over the play button of your favorite trashy drama. The kind of cheesy, perfectly predictable melodrama spun from the worst of amateur YA plots. It was practically comfort food for your fatigued mind, just what you needed to loosen up after the mental marathon that was this long day.

As the opening credits began to roll, your computer began to whir and hiss like an overtaxed engine, emitting gusts of unusually hot air from the vents. Suddenly, its screen slowed to a sluggish crawl, cluttered with a barrage of not-so-savory pop-up ads. Barely a minute in, the pixels already scrambled to form images better to left unseen—half naked women in risqué yet tacky mermaid-like attire, claiming they were ‘just around the corner and ready for a good aquatic fuck.’

First of all, what the absolute living hell is an “aquatic fuck”??

Did you even want to know? And most importantly, what happened to the ad blocker you installed just the other day? Judging by the contents, you had a sneaking suspicion that slimy, sea-dwelling degenerate, The Deep, had tampered with your computer… yet again.

“For the love of-… what’s with all these pop-up ads?” you muttered under your breath as excessively explicit ads crowded out the episode. Your eyes darted furtively around the room to check for wandering glances, hoping against hope that none of your coworkers had noticed the unwanted filth invading your screen. Heart pounding, you squeezed your chair closer to your monitor into a makeshift barricade, shielding the display as best you could while hastily clicking away at the intrusive ads.

As you hurriedly closed the remaining windows, an ominous shadow fell across the screen. Dreading what—or who—might be behind you, you slowly swiveled your chair around to find Black Noir's stoic stare boring into your own.

You stifled a yelp as you instinctively clutched the armrests, catching yourself on the edge of your seat before an ungainly spill to the floor. Noir had a way of materializing without warning, and it never failed to unnerve.

“N-Noir!” you managed, inwardly cringing as your voice broke on his name. “Fancy seeing you in these parts. I was just taking a quick break and y’know- stretching ‘em brain cells.” You tried for a lighthearted chuckle, but it emerged as more of a strained squeak that faded into an anxious hum.

With a jerky flurry of clicks and the browser minimized from view, whatever dignity you still retained disappearing along with it. All that did remain was you praying to the heavens above that he hadn't noticed its questionable contents (even if he most definitely had and simply chose not to comment)

When Noir offered no response, you of course charmingly barreled ahead in your frazzled daze. “But anyways, s-sorry about that… how uh, can I help you today?” your words tumbled out in a breathless rush, punctuated by a shrill laugh you hoped disguised the mortification simmering beneath.

Noir cocked his head, observing you with that same silent intensity. You fidgeted, hands twisting in knotted discomfort, the heat in your ears now engulfing your entire face. Was it the invasive pop-ups that had you squirming in your seat? Or the fact he could snuff out your existence faster than you can say “workers’ comp”?

Either way, beneath the weight of his stare, you already felt as if you were some peculiar, freakish creature pinned for study, rather than some bumbling employee just trying to unwind and watch their comfort show.

And to him, you indeed were a fascinating, bizarre little human.

Mercifully, Noir chose to extend a folder toward you, putting an end to your somewhat pathetic withering. You accepted it with a wordless nod, nearly sagging in your chair as tension drained from your shoulders.

Whirling towards the familiar clutter of your desk once more, you pretended absorption in the folder’s material, hoping this signaled Noir’s leave. After all, has anyone seen the state of you? It certainly wasn’t a flattering one. Yet from the corner of your eye, you detected no movement, no receding footsteps—his shadowy form remained statuesquely in place.

Believe it or not, this has been becoming a thing, a growing habit of late—and a suspicious one at that. Lately his breaks had grown longer, minutes lengthening to quarters of an hour, all spent hovering at your desk as you worked. However, his focus was solely on watching and observing you. He never exhibited a hint of thought or motive for his reason there, only leaving you with questions that seemed to multiply by each and every visit.

Noir, on the other hand, was somehow utterly convinced that you and him were two peas in a tightly-knit pod. He swore you two were best of buds for life—even if "life" so far had only amounted to the past two weeks' worth of half-hour stretches where he silently observed your work from the corner.

Ironically, you didn’t have the slightest inkling of how he really felt. Instead, you always assumed that he, like most supes, regarded you as little more than a puny mortal—a fragile, near-useless sack of flesh and bones whose skull he was one misstep away from caving in with bare hands.

But nope, Noir was simply here to bless you, the nerdy but cute crime analyst, with his presence—his rather… unsettling presence.

The familiar hush settled as you reluctantly returned focus to the task at hand. Hocus-pocus-focus, you chanted mentally, peeling away the last shreds of stray thoughts to tap into the zone of productivity. Unfurling the dossier Noir provided, you began sifting through documents for insight on his purpose in approaching you. Meanwhile, a flick of movement in the edge of your vision revealed Noir's attention veer off course, the almond joy perched beside your keyboard capturing his notice.

You tensed, hocus-pocus-focus breaking, all too aware of past disappearances of snacks in these briefings. Sure enough, his hand drifted noiselessly toward the candy bar, no doubt spurred by ingrained impulse to dispose of it per his usual custom. But you'd grown wise to his methods by now.

Not again, you sighed inwardly, snatching the almond joy and cradling it protectively as if it were your dear, beloved child.

Noir made no move to withdraw, palm outstretched expectantly. You frowned, struggling to keep frustration at bay. "Please, come on- not this time!.. It's my last one for the day." Brows pinching, your tone threatened to rise before steadying with a slow and calm inhale. No use losing composure over candy, no matter the principle. So all you could do was peer beseechingly at Noir in silent appeal, legs jittering restlessly under your desk in building apprehension.

Unfortunately, you found no signs of leniency in his obscured face—only his hand beckoning relentlessly for the almond joy. You plea was once again met with stony resolve, as if he was internally distressed by the mere presence of it. What was he? Deathly allergic to almond joys or something?

With a resigned breath, you delivered the almond joy towards Noir's waiting glove, unable to hide the disappointment dimming your features. Your lips curled into a slight pout, gaze sinking heavy into your lap at being parted from the treat. Though Noir was never one for words, it really didn’t take a rocket scientist to see you felt bullied into submission by his demands. At the end of the day, what power did a measly analyst like yourself hold against one of the Seven? As your fingers uncurled, releasing the candy into Noir's grasp, you couldn't help but feel a bit put upon, even if that wasn’t his intention at all.

Noir was well aware of the upset feelings his request had caused, so in an attempt to remedy the situation, his arm was sent in a backwards reach for the notepad he often used to communicate. However, he found himself at a loss as words eluded him, his thoughts swirling in frustrating circles of “What should I even say?”—muddled and incoherent. For a moment he stared at you, mask betraying no emotion as he grappled to find the right words, despite the prick of guilt nibbling at his conscience. Then, lacking any better option, he simply tossed the offending candy into the trash, perhaps with more force than intended.

Clearly, socializing was not Noir’s strong suit.

With no further acknowledgment, Noir spun on his heel and marched away. You watched his retreating, rigid form with discomfort clenching your insides, eyes falling onto the lonely candy discarded in the trash, its colorful wrapper mocking your current disheartened state.

Wearily, you turned away from the almond joy, redirecting your attention toward the computer as a means to divert your now soured mood. Maximizing the browser, you hoped that your planned show may have had time to load during the interaction. But upon inspecting the screen, you found the video remained stubbornly stalled, stuck on buffering dots and refusing to roll despite the minutes passed.

Just. Peachy.

One (super)human encounter had sucked the very life source out of your dog-tired body, and now this. It was really shaping up to be one of those days.

Thoroughly worn out, you gently laid your head down onto the desk, pillowing it against the crook of your folded arms as eyelids slid shut. All you craved was to simply sleep away the remaining time until you could finally escape this wretched shift and retreat to the sanctuary of your home sweet home.

─────────────────

As your shift wound down to its end, you were finally stirring from your slumber. Rubbing the sleep from your bleary eyes, your blurred vision sharpened to show your colleagues had long since departed while you were snoozing away.

Rising and squaring your shoulders, you began to gather your belongings in preparation to leave as well. Once you had collected everything and lifted to your feet, something in the far corner of your desk caught your eye. Approaching for a closer look in the dim lighting, the fuzzy outline gradually came into focus—a cluttered collection of Hershey's Kisses, their jumbled placement grouped to form the shape of a heart.

You blinked in bewilderment, rubbing your eyes once more to ensure you weren't imagining things. Stepping closer, you spotted a sticky note nestled within the heart of chocolates, scrawled upon in a crude, blocky hand. At first, you assumed it was some silly prank from one of your coworkers, but you knew you recognized the handwriting anywhere—it was Noir's.

Gingerly, you plucked the sticky note from the desk, lifting it to your line of sight to read the message. “Kisses taste better than almond joys…Sorry.” you read softly, your voice trailing off as confusion crept in.

Designed as a very apparent flirty gesture, the intent behind the note and chocolates still managed to whoosh straight over your head. As always seemed the case, even the most painfully obvious social cues could so easily evade your understanding—this proving no exception.

You slipped the sticky note into your pocket, then selected a foil-wrapped Kiss from the pile. Gently rolling the chocolate between your fingers, you unwrapped it and popped one into your mouth. You took time to savor its light cream filling beneath a smooth outer shell, face crinkling in thought and head tilting as you considered your verdict. “Eh… I’d beg to differ.” you mused with a shrug, slinging your bag over your shoulder as you took your leave from the office.

-------☆-------

Pssst- likes, comments, and reblogs are greatly appreciated in this household and keep me motivated! <3

-------☆-------

a C.AI bot as your very own part 2 where you thank Noir the following day:

a/n: saw somewhere that kisses don’t contain nuts but then I also saw someone else say they actually do??? So let’s just pretend the kisses Noir chose are completely nut-free for the sake of the plot 😭

also, the reader is very much based off Anika if it wasn’t obvious enough haha! She’s so y/n coded 😤💗

♡ divider credits: @/ianrkives

[arabicfornerds]

A CLASSIC: How Spotify can be used to learn Arabic Spotify (also the free version) can display the lyrics of the song you are playing in real time. This works well for Arabic songs; a great study tool! https://arabic-for-nerds.com/tools/spotify-arabic-lyrics/?feed_id=4312

[the-original-skipps]

|| Yandere Hacker!Scaramouche x Reader ||Headcanons || Genshin Impact ||

so I was watching hoyofair and this came up so I thought I’d do a quick something mehehe I mean I did spy scara before so might as well continue the tradition

cw: mentions of cyber stalking. privacy breach. slight mention of violence involving firearms.

Hacker!Scaramouche has your phone and laptop/computer bugged with his own personally made virus, which basically acts as a listening device. He can also remotely access both devices without you even knowing.

Hacker!Scaramouche who basically knows everything about you. He can hack into the government database to find out any personal information you have. Any records, all the names of your family members; he can just find out with a tap of his finger.

Hacker!Scaramouche knows your whereabouts at all times, a tracking software installed into your phone which you’ll never find. You can be in any part of the world and he’d still be able to find you. You don’t have your phone with you? Not a problem, he’ll just assess the satellite and look for you.

Hacker!Scaramouche who because of the virus on your phone, he pretty much listens to you go about your day. In this day and age, a person’s smartphone is an essential tool after all and he knows you’d always have it with you. He can be going about his day and your voice would be heard from this headphones. What you’re saying as you browse the internet, your personal mumblings - he hears them all. Especially the phone calls you have with other people.

Hacker!Scaramouche knows your current interests and wants. He knows you have that item in your basket on your shopping app that you’re putting off buying. So, he makes things easier for you and buys it for you. He’ll have it delivered straight to your house. A little gift from him.

Hacker!Scaramouche who has access to your phone’s photo gallery. He saves all the pictures you’ve taken into his own personal computer and phone. The pictures of the food you’re about to eat, the pretty scenery of the sky - they’re all backed up and saved. Though, he has a special folder for pictures with you in it.

Hacker!Scaramouche can hack into any security camera in any part of the world. He has a live stream of the security camera feed running in front of your house/apartment so he’d know when you’re home. He also keeps watch in case you bring any visitors home. If you do, a simple facial recognition program is all he needs to know who they are and if they’re a threat to him.

Hacker!Scaramouche who spends majority of his time behind a screen but isn’t afraid to come in person when needed. This new person you’re seeing? He already knows who they are and where they live. He’ll ruin them - drain them of their assets, enter false criminal records; anything to get them away from you. If they don’t get the message, a gun to the face will be sure to change their mind. 

[blushofeve]

Cam Girl 3

PART 1 & PART 2

pairing: Caleb x Cam girl!reader

summary: Caleb stalks you and uses your mutual friend, MC, to finally get to fuck you irl.

themes: the reader is a cam girl, strangers to lovers(?), sexual tension, sexual content, porn with plot stalker Caleb

word count: 2.7K

tags (bc they asked): @calebswife , @mcdepressed290

A/N: This is not proofread, please let me know if there are any mistakes :)

you can also read this on ao3

Weeks had passed since that livestream. You’d done more sessions—some cute, some teasing, a few downright sinful—but no matter what you posted, you always noticed him. @Apple.Prince. He was watching everything, always first to comment, always sending little hearts, and gifts off your wishlist and paying for private calls like clockwork. He’d become your favourite. You’d never admit it aloud, but his username gave you a little flutter each time it popped up. You didn’t know much about him, just his voice from your one private call, and the feeling that you were never quite alone when he was watching.

And you were right.

What you didn’t know was that Caleb wasn’t just watching you online. He had access to things others didn’t. After all, being the Farspace Fleet’s Colonel had its perks— classified databases, surveillance tools, and tech most civilians couldn’t even imagine. And he was already breaking the rules just to be near you.

It started with the voice match. He’d run a background trace on your voice from the stream, imagine his surprise when he finds out you and MC were friends, he found videos and pictures of the two of you in group hangouts on your Moments page. He was speechless. Even though he didn’t expect anything less, you were beautiful. It’s safe to say that he didn’t get much sleep that night.

That mutual friend was the thread. He pulled on it gently at first, asking MC harmless questions, subtly steering conversations. Then, more directly. He knew MC had met with you recently, though she didn’t mention your name.

Caleb already knew it was you.

So, when MC invited a few friends to go to a bar. He pulled strings to make sure he’d be there too. “My vacation is almost up. We should hang out together as much as possible before I leave yea?” He had been slipping in quiet suggestions like these and talking about places to go, places that usually involved groups.

You were hesitant when MC invited you, you had plans to do a stream that night but it could wait. “It’s just a small get-together,” she’d said. “Simone said you’ve been swamped with work all week. A change of scenery would be good.” “Besides, I’m bringing a friend. You’ll like him.” You’d rolled your eyes, expecting the usual suspects: some cocky guy with a too-tight shirt and even tighter opinions. You weren’t here to be impressed. You were just here to get out of your head.

The bar was buzzing, with low music, dim lights, the comforting clink of glasses and casual laughter. The air smelled like citrus peels and whiskey. You perched on a velvet bar stool, legs crossed, fingers wrapped around a chilled glass. A blush-hued cocktail MC had ordered it for you. “It looks like you,” she’d grinned. Then came the voice. Deep. Polished. Familiar in a way that made your skin prickle. “Is this seat taken?” You looked up… and up. He was tall and broad in the chest and shoulders. Tousled brown hair, an edge of gold from the warm bar lighting. Not the type you’d forget easily. His expression was relaxed, but his eyes were sharp, calculating quietly. “No,” you said, lifting your glass slightly. “All yours.”

MC returned just then and nudged the guy with her elbow. “There you are. Took you long enough.” He gave her a pouty look. “You’re the one who said ‘casual timing.’ I took it literally.” MC rolled her eyes and turned to you, grin stretching. “This is Caleb, my childhood friend. I told you I’d drag someone cool out tonight.” “Caleb,” you echoed, letting the name sit on your tongue. It was… familiar. Not in a memory sense, but more like a distant tug in your chest. You couldn’t quite place it. He smiled as he extended a hand to shake yours. His palm was warm, his touch firm but gentle. “Nice to meet you.” Your stomach flipped for no good reason. “You too.”

You talked for a while. All surface-level at first, music, drinks, random takes on bar aesthetics. He was surprisingly funny, dry with his humour, but earnest with his eyes. There was a softness beneath the smoothness. A type of stillness in the way he listened when you spoke. But then there were moments. Little things. When he said little jokes you swore you’d only said on stream before. When he looked at your necklace a moment too long, his purple eyes lingered on the gold apple charm. When he said your name and it curled in your gut the same way it had during that call. You shook it off. Maybe you were just projecting. But the way his gaze shifted to your mouth as you sipped your drink… The way he smiled when you laughed… The subtle flush on his cheeks when you teased him…

You didn’t even notice how close he’d gotten until you felt the warmth of his arm along yours, just brushing at the elbow. Caleb had a way of leaning in when you spoke like nothing else in the room existed. It was disarming. Flattering. Dangerous. You swirled the last of your drink, the melted ice clinking against the glass. “So, what do you do?” you asked, glancing at him over the rim. He paused. “He is the Farspace Fleet’s Colonel.” MC cut in and he nodded You blinked. “Really?” He smirked. “You don’t believe me?” “No, I do,” you said, setting the glass down. “It just… fits.” “How so?” You shrugged, suddenly feeling like the room had gotten a little warmer. “You sit like someone used to giving orders. And… you look like someone used to getting his way.” MC let out a laugh beside you. “She’s got you pegged, Caleb.” His gaze slid to yours. Something flickered there—amusement, maybe. Or something heavier. He leaned closer. “You’re pretty observant.” His mouth lifted in a slight smile, but it didn’t reach his eyes. Not completely. “That’s a nice necklace,” he said in a low voice. Your fingers instinctively moved to touch the apple charm. “Thanks. Guess it’s kind of a signature thing.” You spoke slowly, it was just a harmless compliment but it felt like more… MC mumbled something about going to find the rest of your friends and left.

⋆｡‧˚ʚ♡ɞ˚‧｡⋆

You and Caleb were left in the dim golden light of the booth, the bass from the speakers pulsing through the floor and into your feet. You sipped your drink, aware of the silence settling between you. He looked at you. The kind of look that made your spine straighten. “I think I’ve seen you before,” you said before you could stop yourself. “But I can’t figure out where.” His expression didn’t change, but his fingers stilled on his glass. “Same here,” he said softly. Something was off. Not in a bad way, but in a familiar way. A heat curled low in your belly. Your skin buzzed in anticipation. You played with the charm between your fingers. “Weird.” Then he said it, carefully. Almost too casually: “I always liked that necklace.” Your blood ran warm. Not cold—warm. Like embarrassment, like recognition, like something falling into place. He hadn’t said your necklace. He’d said that necklace. Like he’d seen it before. Like he knew it. You tilted your head to the side. “Are you sure we don’t know each other?” He shrugged, “I know you.” Your chest tightened at his words. He leaned in closer, his warm breath tickling your ear as he spoke, “You looked so pretty in that set I bought you. I wanna see you in it again.”

Oh. It suddenly clicked into place.

“I.. don’t know what you’re talking about.” There’s no way this was actually happening. You thought you had done a good job concealing your identity and personal life. Caleb’s fingers ghosted over your collarbone and landed on the apple charm. “You know what I mean.” the tone of his voice immediately sobered you up. Your breath caught in your throat. You didn’t move. Your heart was pounding so loud you were sure he could hear it, feel it through the small space still left between you. His fingertips rested lightly on the charm like he was waiting for you to flinch. But you didn’t. You couldn’t. Your eyes met his, and there it was—that same voice that had whispered to you, the same low growl that had drawn out breathy thank yous and soft moans from your parted lips. This wasn’t a coincidence. This was intentional. Calculated. And somehow, it didn’t feel wrong. “You stalked me?” you said, barely above a whisper. His thumb brushed over the apple, a quiet caress. “I just… wanted to meet you. For real. Not just through a screen.” You should’ve been angry. Violated. You should’ve pulled away, demanded answers, and stormed out. But instead, you stared at him, really stared. “You’re insane.” “I know.” Despite the absurdity of the situation, your body quietly screamed for him. As if reading your mind, Caleb kissed your neck. He didn’t fail to notice how your breath hitched and thighs pressed together. It wasn’t lost on either of you that you were in a public space. “Do you want to go somewhere more private?” Common sense is screaming at you not to go, but come on— it was him. The guy who had been stuck in your mind for the last few weeks.

⋆｡‧˚ʚ♡ɞ˚‧｡⋆

To any normal person’s surprise, you found yourself in the back of your stalker fan’s car, all over each other. Caleb was ecstatic. Your kisses and touch were far more intoxicating than any alcohol he had that night. As you straddled him, his hands slipped up your dress and firmly gripped your ass. He dreamed of this. How soft you felt under his touch. Your soft moans as he kissed and marked your neck and chest. And how incredibly hard he was with you pressed against him. You couldn’t help yourself but grind up against him. Caleb let out a whiny moan into the crook of your neck and pulled you closer. “Please… please… let me fuck you. I wanna show you how good I am. I’ll be so much better than your toys.” He begged as he bucked his hips up into you. His needy, whiny tone snapped something inside you. You lifted yourself off his lap and narrowed your eyes. “No.” The word seemed to break something in him. His purple eyes seemed to gloss over with tears. “No?” He was so close to getting what he wanted— needed. “W-what’s wrong? A-are you mad at me?” You nodded and crossed your arms. “Yes. You stalked me, disregarding my privacy, and you think I’m just going to let you fuck me?” Caleb’s mouth opened and closed as he tried to think of what to say. “Please…” He moved so that you were beneath him and he lay down the seat. “I’m sorry,” He inched his face closer to yours and you moved back until you were fully laid down on the seat. “I just wanted you so bad. Really bad.” He returned to placing kissing on your neck. “And you want me too.” He sucked on your skin, leaving a dark mark. “I’m sorry. I’m sorry. I’m sorry.” He repeated apologies as he moved down your body, coming to a stop between your thighs. “Let me make it up to you. Please” Your heartbeat pounded in your ears. Caleb’s pleading yet hungry look sent blood rushing to your face.

Before the word okay fully left your mouth, Caleb had buried himself between your thighs. He licked his tongue over your panties, making them even more wet. He moaned as he inhaled your scent and let out curses as his pants became increasingly tight. Your mind had filled with cotton. The feeling of his tongue through your underwear sent electric shocks through your body. Your panties found their way off you and into Caleb’s hand as he jerked himself off while burying his tongue in you. The feeling was euphoric. Caleb devoured you like a man starved, moaning shamelessly into you as if your pleasure was his only purpose. His tongue moved with practised precision like he’d memorised you—where to lick, where to suck, how to curl it just right to make your hips twitch and your thighs tremble. You gripped the seat for stability, one hand tangled in his hair, tugging hard enough to make him groan against you. The sound of it vibrated through your core, and you nearly came undone right then. “Fuck, Caleb—” you gasped, voice catching in your throat. Your body arched off the seat, thighs clenched around his head, and he just grabbed your hips and pulled you closer like he couldn’t get enough. When you came, it was sudden, loud, and shattering. He didn’t stop. He kept licking you through it, groaning as you grinded against his mouth. And even after you finally slumped back, breathing hard and completely wrecked, Caleb just looked up at you—lips swollen, chin wet, eyes wild. “You taste even better than I imagined,” he whispered, voice rough with restraint.

“Are you still mad at me?” Still catching your breath, you shook your head. “Can I please fuck you? Please.” You nodded. “Fuck… I promise,” he said, breathless, “I’ll make you forget every toy. Every other name. You won’t want anyone but me after this.” He crawled up and hovered above you. You watched him fumble for a condom in his pockets, the urgency in his movements making your pulse quicken. He tore it open, rolled it on with practiced ease, and looked down at you like he still couldn’t believe you were real. “You sure?” he asked, voice rough, body hovering over yours. You pulled him down by the collar of his shirt, pressing your mouth to his like it was the only answer you had. Your kiss was hot, messy, full of every dizzying want that had been building since the call. The stretch of him as he pushed in made you gasp, your fingers digging into his shoulders. Caleb groaned, low and guttural, forehead pressing against yours as he slid deeper, inch by inch. “Fuck— so tight,” he whispered, trembling with restraint. He bit his lip to stop another moan from escaping. He felt so good he almost came right there and then. You couldn’t breathe. Could barely think. He filled you completely, like he belonged there, like he was made for this. Once he was fully in, he paused, letting you adjust. His lips found your jaw, your neck, and he whispered your name like a prayer. You clenched around him in response, and he choked out a moan. He finally moved, slow, pleasuring thrusts that had you arching your back and your mouth falling open with each one. He kissed you like he needed to keep you quiet, swallowing your moans, like every sound you made would drive him over the edge.

“Oh god- Caleb,” Your nails dug into his back, “You feel so good.” That broke something in him. He picked up the pace, snapping his hips into you harder, deeper. The car rocked beneath you both, the windows fogged up, the space filled with your gasps, your whimpers, his soft curses. “Wanted this so fucking bad,” he said through gritted teeth. “Every night. Thought of you like this. Begging. Shaking. Needing me.” You were already close again— your legs wrapped around his waist, pulling him impossibly closer. “Caleb— I’m gonna—” “I’ve got you,” he whispered, his hand slipping between your bodies, thumb circling your clit. “Come for me, baby. Let me feel it.” You shattered again. Your whole body tightened, hips jerking, thighs trembling as the pleasure overtook you. He groaned, the feeling of you clenching around him pushing him over the edge. “Shit—fuck—I’m coming—” he moaned, burying himself deep as his whole body tensed.

He stayed there, chest heaving, forehead pressed against yours as you both caught your breath. Your hands moved to his hair, brushing it back from his face. He looked at you like you were the only thing in the galaxy worth chasing.

And maybe… you were.

Thank you for reading<3

Want to be added to my tag list?