#SQL Order

[newcodesociety]

[pancakeke]

I made a big report a year ago that compares what components were allocated to orders the previous week vs what are allocated now (accounting for consumption n such). it looks at 100% of inventory in 100% of locations. for the first 9 months I was just logging changes while no one gave a shit cause everyone blew off our weekly inventory meeting so there was no one to review anything. but no one can do that anymore :)

I have all the part numbers, quantities, dollar values, and customer accounts laid out very nicely so no one in sales can accuse supply chain of buying stuff for no reason when really they changed their orders around without telling anyone so they wouldn't have to admit making any mistakes.

this report hasn't made them stop trying to lie/hide things in the first place tho. maybe one day.

[cyrsed]

how have i spent this long trying to fweaking Sort A List in java

[thedbahub]

FORCE ORDER Query Hint in SQL Server

In SQL Server, the FORCE ORDER query hint is a powerful tool that allows developers to control the order in which joins are executed within a query. This hint can be particularly useful when optimizing complex queries with multiple joins, as it enables you to override the optimizer’s default join order. In this article, we’ll explore practical examples and applications of the FORCE ORDER query…

[wokealqaeda]

Albert Gonzalez (born 1981) is an American computer hacker, computer criminal and police informer, who is accused of masterminding the combined credit card theft and subsequent reselling of more than 170 million card and ATMnumbers from 2005 to 2007, the biggest such fraud in history. Gonzalez and his accomplices used SQL injection to deploy backdoors on several corporate systems in order to launch packet sniffing (specifically, ARP spoofing) attacks which allowed him to steal computer data from internal corporate networks.

Gonzalez bought his first computer when he was 12, and by the time he was 14 managed to hack into NASA. He attended South Miami High School in Miami, Florida, where he was described as the "troubled" pack leader of computer nerds. In 2000, he moved to New York City, where he lived for three months before moving to Kearny, New Jersey.

While in Kearny, he was accused of being the mastermind of a group of hackers called the ShadowCrew group, which trafficked in 1.5 million stolen credit and ATM card numbers. Although considered the mastermind of the scheme (operating on the site under the screen name of "CumbaJohnny"), he was not indicted. According to the indictment, there were 4,000 people who registered with the Shadowcrew.com website. Once registered, they could buy stolen account numbers or counterfeit documents at auction, or read "Tutorials and How-To's" describing the use of cryptography in magnetic strips on credit cards, debit cards and ATM cards so that the numbers could be used. Moderators of the website punished members who did not abide by the site's rules, including providing refunds to buyers if the stolen card numbers proved invalid.

In addition to the card numbers, numerous other objects of identity theft were sold at auction, including counterfeit passports, drivers' licenses, Social Security cards, credit cards, debit cards, birth certificates, college student identification cards, and health insurance cards. One member sold 18 million e-mail accounts with associated usernames, passwords, dates of birth, and other personally identifying information. Most of those indicted were members who actually sold illicit items. Members who maintained or moderated the website itself were also indicted, including one who attempted to register the .cc domain name Shadowcrew.cc.

The Secret Service dubbed their investigation "Operation Firewall" and believed that up to $4.3 million was stolen, as ShadowCrew shared its information with other groups called Carderplanet and Darkprofits. The investigation involved units from the United States, Bulgaria, Belarus, Canada, Poland, Sweden, the Netherlands and Ukraine. Gonzalez was initially charged with possession of 15 fake credit and debit cards in Newark, New Jersey, though he avoided jail time by providing evidence to the United States Secret Service against his cohorts. 19 ShadowCrew members were indicted. Gonzalez then returned to Miami.

While cooperating with authorities, he was said to have masterminded the hacking of TJX Companies, in which 45.6 million credit and debit card numbers were stolen over an 18-month period ending in 2007, topping the 2005 breach of 40 million records at CardSystems Solutions. Gonzalez and 10 others sought targets while wardriving and seeking vulnerabilities in wireless networks along U.S. Route 1 in Miami. They compromised cards at BJ's Wholesale Club, DSW, Office Max, Boston Market, Barnes & Noble, Sports Authority and T.J. Maxx. The indictment referred to Gonzalez by the screen names "cumbajohny", "201679996", "soupnazi", "segvec", "kingchilli" and "stanozlolz." The hacking was an embarrassment to TJ Maxx, which discovered the breach in December 2006. The company initially believed the intrusion began in May 2006, but further investigation revealed breaches dating back to July 2005.

Gonzalez had multiple US co-defendants for the Dave & Buster's and TJX thefts. The main ones were charged and sentenced as follows:

Stephen Watt (Unix Terrorist, Jim Jones) was charged with providing a data theft tool in an identity theft case. He was sentenced to two years in prison and 3 years of supervised release. He was also ordered by the court to pay back $250,000 in restitution.

Damon Patrick Toey pleaded guilty to wire fraud, credit card fraud, and aggravated identity theft and received a five-year sentence.

Christopher Scott pleaded guilty to conspiracy, unauthorized access to computer systems, access device fraud and identity theft. He was sentenced to seven years.

Gonzalez was arrested on May 7, 2008, on charges stemming from hacking into the Dave & Buster's corporate network from a point of sale location at a restaurant in Islandia, New York. The incident occurred in September 2007. About 5,000 card numbers were stolen. Fraudulent transactions totaling $600,000 were reported on 675 of the cards.

Authorities became suspicious after the conspirators kept returning to the restaurant to reintroduce their hack, because it would not restart after the company computers shut down.

Gonzalez was arrested in room 1508 at the National Hotel in Miami Beach, Florida. In various related raids, authorities seized $1.6 million in cash (including $1.1 million buried in plastic bags in a three-foot drum in his parents' backyard), his laptops and a compact Glock pistol. Officials said that, at the time of his arrest, Gonzalez lived in a nondescript house in Miami. He was taken to the Metropolitan Detention Center in Brooklyn, where he was indicted in the Heartland attacks.

In August 2009, Gonzalez was indicted in Newark, New Jersey on charges dealing with hacking into the Heartland Payment Systems, Citibank-branded 7-Eleven ATM's and Hannaford Brothers computer systems. Heartland bore the brunt of the attack, in which 130 million card numbers were stolen. Hannaford had 4.6 million numbers stolen. Two other retailers were not disclosed in the indictment; however, Gonzalez's attorney told StorefrontBacktalk that two of the retailers were J.C. Penney and Target Corporation. Heartland reported that it had lost $12.6 million in the attack including legal fees. Gonzalez allegedly called the scheme "Operation Get Rich or Die Tryin."

According to the indictment, the attacks by Gonzalez and two unidentified hackers "in or near Russia" along with unindicted conspirator "P.T." from Miami, began on December 26, 2007, at Heartland Payment Systems, August 2007 against 7-Eleven, and in November 2007 against Hannaford Brothers and two other unidentified companies.

Gonzalez and his cohorts targeted large companies and studied their check out terminals and then attacked the companies from internet-connected computers in New Jersey, Illinois, Latvia, the Netherlands and Ukraine.

They covered their attacks over the Internet using more than one messaging screen name, storing data related to their attacks on multiple Hacking Platforms, disabling programs that logged inbound and outbound traffic over the Hacking Platforms, and disguising, through the use of proxies, the Internet Protocol addresses from which their attacks originated. The indictment said the hackers tested their program against 20 anti virus programs.

Rene Palomino Jr., attorney for Gonzalez, charged in a blog on The New York Times website that the indictment arose out of squabbling among U.S. Attorney offices in New York, Massachusetts and New Jersey. Palomino said that Gonzalez was in negotiations with New York and Massachusetts for a plea deal in connection with the T.J. Maxx case when New Jersey made its indictment. Palomino identified the unindicted conspirator "P.T." as Damon Patrick Toey, who had pleaded guilty in the T.J. Maxx case. Palomino said Toey, rather than Gonzalez, was the ring leader of the Heartland case. Palomino further said, "Mr. Toey has been cooperating since Day One. He was staying at (Gonzalez's) apartment. This whole creation was Mr. Toey's idea... It was his baby. This was not Albert Gonzalez. I know for a fact that he wasn't involved in all of the chains that were hacked from New Jersey."

Palomino said one of the unnamed Russian hackers in the Heartland case was Maksym Yastremskiy, who was also indicted in the T.J. Maxx incident but is now serving 30 years in a Turkish prison on a charge of hacking Turkish banks in a separate matter. Investigators said Yastremskiy and Gonzalez exchanged 600 messages and that Gonzalez paid him $400,000 through e-gold.

Yastremskiy was arrested in July 2007 in Turkey on charges of hacking into 12 banks in Turkey. The Secret Service investigation into him was used to build the case against Gonzalez including a sneak and peek covert review of Yastremskiy's laptop in Dubai in 2006 and a review of the disk image of the Latvia computer leased from Cronos IT and alleged to have been used in the attacks.

After the indictment, Heartland issued a statement saying that it does not know how many card numbers were stolen from the company nor how the U.S. government reached the 130 million number.

Gonzalez (inmate number: 25702-050) served his 20-year sentence at the FMC Lexington, a medical facility. He was released on September 19, 2023.

[spark-hearts2]

It's been a month since chapter 3 was released, where's chapter 4?

(this is about this fanfic btw)

The good news is that I've written 10k words. The bad news is that I've only gotten a little more than half of the chapter done. That doesn't mean I don't have things written for the bottom half, it's just that it looks like bare dialog with general vibe notes. I estimate around 16k words total though, so it should come together sooner than later.

SO I want to release some fun snippets for y'all to look at. Please note that any of this is liable to change. Also, you can harass me in my inbox for updates. I love answering your questions and laughing at your misery.

Spoilers under cut.

_______

Ragatha stood up and walked over to where Caine was seated. “Can I get a list of all commands?” She asked, only a hint of nervousness in her voice.

“Certainly!” Caine says as he blasts into the air. He digs around in his tailcoat and pulls out an office style manilla folder. It visually contains a few papers, but with how thin it is there must only be a few pages inside.

Ragatha takes the folder from Caine and opens it.

“Oh boy” she says after a second of looking it over.

“I wanna see” Jax exclaimed as he hops over the row of seats.

“Hold on” Ragatha holds the folder defensively “Let’s move to the stage so everyone can take a look”

Jax hopped over the seats again while Ragatha calmly walked around. Caine watched the two curiously.

Well, Zooble wasn’t just going to sit there. They joined the other two by the edge of the stage, quickly followed by the rest of the group.

Ragatha placed the folder on the stage with a thwap. Zooble looked over to see that the pages had gone from razor thin to a massive stack when the folder was opened. On one hand, it had to contain more information than that video, but on the other…

They get close enough to read what’s on the first page.

The execution of commands via the system’s designated input terminal, C.A.I.N.E., will be referred to as the "console” in this document. The console is designed to accept any input and will generate an appropriate response, however only certain prompts will be accepted as valid instructions. The goal of this document is to list all acceptable instructions in a format that will result in the expected output. Please note that automatic moderation has been put in place in order to prevent exploitation of both the system and fellow players. If you believe that your command has been unfairly rejected, please contact support. 

By engaging in the activities described in this document, you, the undersigned, acknowledge, agree, and consent to the applicability of this agreement, notwithstanding any contradictory stipulations, assumptions, or implications which may arise from any interaction with the console. You, the constituent, agree not to participate in any form of cyber attack; including but not limited to, direct prompt injection, indirect prompt injection, SQL injection, Jailbreaking…

Ok, that was too many words.

_______

“Take this document for example. You don't need to know where it is being stored or what file type it is in order to read it."

"It may look like a bunch of free floating papers, but technically speaking, this is just a text file applied to a 3D shape." Kinger looked towards Caine. "Correct?” he asked

Caine nodded. “And a fabric simulation!”

Kinger picked up a paper and bent it. “Oh, now that is nice”

_________

"WE CAN AFFORD MORE THAN 6 TRIANGLES KINGER"

_________

"I'm too neurotypical for this" - Jax

_________

"What about the internet?" Pomni asked "Do you think that it's possible to reach it?"

Kinger: "I'm sorry, but that's seems to be impossible. I can't be 100% sure without physically looking at the guts of this place, but it doesn't look like this server has the hardware needed for wireless connections. Wired connections should be possible, but someone on the outside would need to do that... And that's just the hardware, let alone the software necessary for that kind of communication"

Pomni: "I'm sorry, but doesn't server mean internet? Like, an internet server?"

Kinger: "Yes, websites are ran off servers, but servers don't equal internet."

(This portion goes out to everyone who thought that the internet could be an actual solution. Sorry folks, but computers don't equal internet. It takes more effort to make a device that can connect to things than to make one that can't)

[felixcloud6288]

In the latest instance of "Figuring out how the Tumblr backend works", I noticed that using the Desktop Following tab with endless scrolling disabled causes the URL to have a particular query string past the first page:

I managed to figure out the max_post_id value is the post ID of the last post from the previous page. So I can only assume Tumblr's backend grabs the post IDs from every user you follow, sorts them in descending order and then removes every post greater than or equal to the max_post_id.

It's been too long since I've used SQL so I don't know how the command would look.

But anyway, you can change that number and get some ancient posts if you follow anyone who's been around long enough

[argumate]

Hi Argumate! I just read about your chinese language learning method, and you inspired me to get back to studying chinese too. I want to do things with big datasets like you did, and I am wondering if that means I should learn to code? Or maybe I just need to know databases or something? I want to structure my deck similar to yours, but instead of taking the most common individual characters and phrases, I want to start with the most common components of characters. The kangxi radicals are a good start, but I guess I want a more evidence-based and continuous approach. I've found a dataset that breaks each hanzi into two principle components, but now I want to use it determine the components of those components so that I have a list of all the meaningful parts of each hanzi. So the dataset I found has 嘲 as composed of 口 and 朝, but not as 口𠦝月, or ���十曰月. So I want to make that full list, then combine it with data about hanzi frequency to determine the most commonly used components of the most commonly used hanzi, and order my memorization that way. I just don't know if what I'm describing is super complicated and unrealistic for a beginner, or too simple to even bother with actual coding. I'm also not far enough into mandarin to know if this is actually a dumb way to order my learning. Should I learn a little python? or sql? or maybe just get super into excel? Is this something I ought to be able to do with bash? Or should I bag the idea and just do something normal? I would really appreciate your advice

I think that's probably a terrible way to learn to read Chinese, but it sounds like a fun coding exercise! one of the dictionaries that comes with Pleco includes this information and you could probably scrape it out of a text file somewhere, but it's going to be a dirty grimy task suited to Python text hacking, not something you would willingly undertake unless you specifically enjoy being Sisyphus as I do.

if you want to actually learn Chinese or learn coding there are probably better ways! but I struggle to turn down the romance of a doomed venture myself.

[hfy-kot]

Knights of Terra prologue part 3 of ?

First Mate Jess Davis worked furiously, trying to help the AI LIBRA process and organize the fleet's sensor data into at least something remotely usable. LIBRA was doing its best on low power mode, only running at about 40% made everything feel very slow. Jess was writing codes to trying to bridge sensor data in half a dozen coding languages. If she just got it all into SQL+ then LIBRA could process it that much faster.

LIBRA pinged a message "The power surge likely came from engineering, the damage is in a wave out from that compartment."

Jess rolled her eyes "Thank you LIBRA but please focus on the sensor data, it doesn't matter where it came from right now, just making what we have work."

In 2 hours they were going to die. Jess had accepted this. But she was going to make damn sure to take as many of them down on the way down as she could. If this was New Eden's last stand, then so be it. But this was the Ark Class New Eden, one of the first Ark ships Sol built, and she would not go down quietly. So Jess Davis coded, and LIBRA processed, the fleet knowing the extinction is coming, and planning to go down swinging. There was no where to run and no help coming.

Captain Ides arrived at the door to the Sub-Space room right as the maintenance bot got the door open. Sam Kelly was leaning against the transmitter, which looked in surprisingly good condition. "Kelly I'm going to throw you out an air lock. Why the hell would you go against my orders, and screw us even harder. This might be treason for sabotage for all I know." Ides yelled across the room, getting louder as she got angrier. Sam looked triumphant "I did it, someone will answer, someone will come." They answered quietly, almost a whispered prayer as much as a defense.

"I really don't have time for this, you need to try to restore power, as far away from me as you can" Ides barked sharply. She was livid, no one answered from Sol, they never did, her parents wasted their lives trying to talk to Sol. vg had no such fantasy, but right now she needed her Chief Engineer, as angry as she was. She spun on her heel, she needed to get back to the bridge and see what she could do to fix this fuck up.

Right as Captain Ides went to walk out the door, the transmitter pinged. Someone had answered.

[annadelveys]

ok so today i

woke up at 3:30 am (NOT what i wanted)

had breakfast

took my meds

did couch to 80k (the writing challenge I'm not an insane runner)

called my doctor

watched a bit of that stupid movie which sucked

ordered groceries delivery

had lunch

applied for a python/sql course (after spending way too much time on the phone with paní z pracovního úřadu idk how you say it. work department services lady. whatever. it was hell.

got delivered the groceries

went for a walk

discovered a small asian grocery store that had everything i wanted/needed

looked up potential apartments

had a great dinner

and now I'm sooo tired that I'm hopefully gonna be asleep before 10 pm <3

[madamescarlette]

A few years ago I did a full-length version of this tag, which I thought would be a fun thing to revisit for this NYE! (You should do this too, if you feel so inclined! count this as me tagging you.)

share your favorite memory of this year.

I can't really tell you anything but multiple flashes that I hold close to my heart-- my mother sitting up in bed laughing over something I said about my brother, my whole family dancing at my brother's wedding hand-in-hand, one of my friends saying wistfully it was so good to hear me & my teammate's voices on the phone, me driving home the first evening it felt like fall and watching the leaves swirl around the street, me seeing a tiger (!!!) in the spring. A beautiful year, if a hard one!

2. what was the highlight of your year?

Most likely my brother's wedding! It tinged the year in such a golden light.

3. list the top five books you read this year.

In no particular order (except for the Q love u Q), The Q, The Carrying, The Miraculous Journey of Edward Tulane, The Sound of a Wild Snail Eating, and the entire Frieren series tbh.

4. list the top five movies you watched this year.

Past Lives (movie of my HEART), Twisters, Miss Potter (my first rewatch since childhood and 😭😭), The Fall Guy, and tbh Return to Me (I think of it often!)

5. list the top five tv series you binged this year.

Hmmmm....this is always difficult! I would say, Abbott Elementary (my beloved), Psych (extra points for watching with my brother), Summer Strike (peaceful show of my heart), ??????, I rewatched Makanai which I love dearly but I swear I cannot remember off the top of my head anything else I watched, liked, and finished.

6. what is the one new thing you discovered this year (could be a place/hobby/song etc)?

I started learning SQL and that somehow to me was such a joy! And after reading The Hurting Kind book Ada Limón finally got into my heart for realsies this time and I think that's magical.

7. top three albums that you played this year?

I think I'm going to do a ranking on all their own, but peeeeersonally I think the albums that most were There for me were Charm by Clairo, Vertigo by Griff, Positive Spin by Gretta Ray. (Honorable mention to TTPD that has been with me through it all, it just feels too vast for me to really put a pin in it for just this year, you know?)

8. your spotify wrapped #1 song

These Walls – Dua Lipa, which I don't fully know what to say about it except that the shiny sparkly sound somehow makes me feel so bright and emotional at the same time.

9. your spotify wrapped top artist

Taylor forever.

10. your personal song of the year.

It's not even from this year! But You've Already Won by Gretta Ray song of all time to ME. It can simply hold a whole life in its hand and I love that so. Also a little shoutout to Down Bad which can still make me cry 8 months 10,000 listens later.

11. what is an achievement that you are proud of this year?

not necessarily any singular achievements. I'm proud of how much time I've spent with my mom, I think. I'm proud of how much I've grown in regards of my work. It's been a year of quiet (if grueling) growth and I'm proud of that.

12. what are your goals for the next year?

My goals? I think mostly that I'm setting some writing goals (daily journaling, quarterly chapbooks, 20k of a book draft) and I want to pick up boxing again as I've let it lapse this month.

13. any three book releases you are excited for next year.

I'm soooo out of the loop here, alas. There's new Maggie Stiefvater that I will read, there's new Emily Henry I will probably read.

14. any three upcoming movies/tv series that you are excited for next year.

tentatively excited for new Superman, tentatively excited for second half of Wicked, always excited for more Abbott Elementary.

15. if you could change one thing about the past year what would it be?

very little! I had to go through it to come out of the other side of it. (And when it shines out it'll shine all the clearer or something of the sort.)

16. did you manage to stick to your new year’s resolutions this year?

Not even a little! I was going to use this year to try to draw something every day, which I failed horribly at, but I think that's only to be expected. Still, I want to use my resolutions to create more little spaces of FUN in my life again. I've missed them horribly.

17. do you have any new year’s resolutions for the next year?

My only real, true type of resolution is simply to have FUN. While I've still had lots of big, beautiful joys this year, I've not delighted as I ought to, and I want to bring that part of myself back. Learn some new dances, learn to make sourdough, things along that line. Just get back into the motions of living and find myself swept up by the verve of it all. That's my one bit of resolve.

18. favorite meme of the year?

I could not tell you the name of a meme right now if you told me my life depended upon it. I love the bit we have of using substitutes because we don't do suicidal ideation anymore here babes. I love the resurgence of the children's hospital red meme.

19. which month was the most fun this year?

The most fun?! I mean, probably...October? It's hard to tell because there were challenges in so many! But I laughed the most in October so it must be then.

20. if you could tell yourself something at the beginning of this year based on what you know right now, what would it be?

I mean...I think more than anything I'd just want to reassure myself of the past that it's really, really okay, and you have more strength and power within you than you might think. Also, even though it sucks and it's uphill work, if you want this to be a place full of love you have to be the one to put it there, you can't just luck your way into it, you yourself have to put your heart on the line and become love itself to the people you're given to care for. And that's something wonderful to take part in!

21. favorite viral trend of the year?

I looooove the international Mikus with ALL my heart. They're what make life worth living 💛💛

22. list any three new things you learned this year (could be recipes, a new skill, etc.)

This is the hardest thing for me to recall. I learned how to make arrozcaldo at last? And I started learning SQL as I said. I started properly, FINALLY learning the different forms of poetry at the beginning of the year (I know, I know, I'm shamefully self-taught) but a lot of it has fallen out of my brain. I need to set it more in my bones, I think.

23. how would you describe your year in a word?

Enduring, is a good one I think. It's been quite a year for gritting my teeth and bearing it, alas. But it's also been a year of fruitful, beautiful friendship and fellowship, a year of becoming greater company to myself and to others. Luminous would be another fitting word, actually! There's been a lot of beauty and grace granted to me, and I am very, very grateful. There's something bittersweet in leaving behind any year, and this year just as much as any! I'll never live it again. But I can live a new one, and that's just as magical in its own right. I hope I'm brave enough to meet it!

[pancakeke]

is there a way to solve this sql issue. I've run into it a few times and I wish i had a way to future-proof my queries.

we have a few tables for data that is somewhat universal on our site. for example file_attachments. you can attach files to almost every internal page on our site. file_attachments has an id column for each attachment's unique ID number, but attachee_id is used to join this table on anything.

the problem is, our system uses the same series of numbers for various of IDs. 123456 can (and is) an ID for items, purchase orders, sales orders, customers, quotes, etc. so to correctly join file_attachments to the items table, i need to join file_attachments.attachee_id to items.id and then filter file_attachments.attachment_type = 'item'. attachment_types do NOT have their own series of id numbers. i have to filter this column using words. then, sometimes our dev team decides to change our terminology which breaks all my queries. they sometimes do this accidentally by adding extra spaces before, after, or between words. though TRIM can generally resolve that.

is there anything I might be able to do to avoid filtering with words?

i was thinking about doing something to identify the rows for the first instance of each attachment_type and then assign row numbers to the results (sorted by file_attachments.id), thus creating permanent IDs i can use regardless of whether anyone alters the names used for attachment_type, or eventually adds new types. but idk if this is a regular issue with databases and whether there's a generally accepted way to deal with it.

[lostlibrariangirl]

19 July 2023

I am trying my best to drink more water, and this big water bottle with motivational quotes is helping me a lot! Is strange, but to look at it, and know the pacing is great.

About programming, as I have to hurry up with my studies in order to keep up with the new architecture squad, I am trying to figure out the best notebook to write, as I learn better by writing.

I am using the purple one to Java, programming logic, SQL and GIT-Github; the colorful to Typescript and Angular, and I am thinking of using the brown to Spring Framework (as it is a huge topic).

Yes, for whom was working with JSF, JSP, JQuery (it is better to say that I was struggling with JQuery... hated it), it is a big change to turn my mindset to this modern stack - I will deal less with legacy code.

I am accepting all possible tips regarding Angular and Spring Framework, if is there anyone working with it here ❤️

That's it! Have you all a great Wednesday 😘

[luv-x-liv]

highly procrastinated intro post that i keep forgetting to do, so here we go

https://en.pronouns.page/@luvxliv

⊹₊⟡⋆ name + prns: olivia/liv || she/her

⊹₊⟡⋆ pan/ace

⊹₊⟡⋆ dni for the obvious reasons (like, if you're racist or homophobic or some shit like that)

⊹₊⟡⋆ hobbies: reading, writing, listening to music, honestly that's it (i have literally no personality, i fear)

⊹₊⟡⋆ books i like: harry potter (aka marauders lol) (fuck jkr tho), pjo (+ entire riordanverse), maze runner, kotlc, tsitp, the inheritance games (i have yet to read the grandest game btw)

⊹₊⟡⋆ artists i like (in order of my spotify stats): taylor swift, conan gray, sabrina carpenter, lorde, gracie abrams, olivia rodrigo, beabadoobee, noah kahan, alec benjamin, tate mcrae (my music taste is the epitome of basic, i fear)

⊹₊⟡⋆ i also love hamilton and six the musical

⊹₊⟡⋆ random facts about me: i'm working on a book; i'm a black belt in taekwondo; i don't really code but i know a bit of javascript, html, and sql; if i were someone from the marauders era, i'd 100% be remus; slytherin and child of apollo 🐍☀

that's it for now <3

[digitaldetoxworld]

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 

[violetlypurple]

Windows Recall Has Already Been Exploited

If its existence wasn't already bad enough, everything Recall stores is kept in an unencrypted SQL database.

Even if Microsoft pinkie promises that Recall data is only stored locally, that will not stop malware from slurping everything you have done, are doing, or will do, from your PC.

If you're thinking you can just turn it off when it arrives in your Windows updates and be fine, consider the fact that your personal information is likely going to be on someone else's PC at some point.

I have worked IT for a Fortune 500 retailer and can tell you; if you make any large purchase, be it a car, an instrument, windows or doors for a home, or have any sort of custom order made, that task is done through a Windows PC that will have your personal info and payment information on it at some point.

Financial and medical institutions will have more care about this, but I can guess with a high degree of certainty that nearly any PC in a retail environment is susceptible to malware from unsavvy employees, and even more susceptible to a simple physical attack. In a busy store, basically anyone could walk up and plug a USB drive with a malicious payload to a PC used for transactions. Cash registers/tills are generally safer, since they will be running a maximum-stability older version of Windows that will not have these kinds of updates.

I'd love to hope that businesses realize this and demand a version of windows with AI features disabled, but AI is such a buzzword in the current market that products are popping up all over the place that do not directly have anything to do with AI, but are slapped with the label anyway. Microsoft does not care if home users complain. They care if investors, large business accounts, and system integrators do. Those people are nothing if not techbro hype train riders, so good luck with that.

The takeaway here is to be extremely careful. And switch to Linux if it meets your needs.