There have been multiple accounts created with the sole purpose of posting advertisement posts or replies containing unsolicited advertising.

Accounts which solely post advertisements, or persistently post them may be terminated.

programmer_humor

This magazine is from a federated server and may be incomplete. Browse more on the original instance.

agent_flounder , (edited ) in what's the difference?
@agent_flounder@lemmy.world avatar

That…isn’t quite right.

Git is a distributed version control system for software development^1.

Version control allows you to manage code versions and changes to code. You take snapshots, so to speak, of every change you make.

Distributed, in this context, means multiple developers can write code on each of their development computers and merge the changes, usually to a centralized git server.

GitHub runs a web-based git server at GitHub.com so teams can store their code in a central location on the internet.

  1. Ok, technically, even though It’s often used for software source code, it can be used for any set of files and directories.
kernelle ,

If you read it as “a website providing a service, but that service is also available elsewhere” the analogy makes perfect sense.

kevincox ,
@kevincox@lemmy.ml avatar

I don’t see anything you said that it isn’t quite right.

Porn is a distributed form of entertainment.

Porn allows you to get your rocks off. You take views, so to speak and do your thing.

Distributed, in this context, means multiple enjoyers can watch porn on each of their entertainment computers and share the videos, usually to a centralized porn server.

PornHub runs a web-based porn server at pornhub.com so viewers can store their porn in a central location on the internet.

agent_flounder ,
@agent_flounder@lemmy.world avatar

So in the analogy porn corresponds to git? Or to source code?

spiderplant ,

In this analogy it could be that:

  • the filesystem is git and the porn is source code
  • the file is git and the data is source code
  • you don’t consider the source code because you can host anything on github
  • we shouldn’t be reading into the analogy this deeply because its a silly analogy meant for absolute beginners
Rodeo ,

Ok, now explain the part you think is not right.

agent_flounder ,
@agent_flounder@lemmy.world avatar

Git is a tool. GitHub is one implementation of a git server. Git is used to manage source code. GitHub hosts / manages source code.

Porn is content. Pornhub is one service that hosts content. Porn is not a tool. Git isn’t content. Source code is content.

So porn isn’t really analogous to git.

Maybe a better analogy would be… Git is to GitHub as outlook mail client is to outlook server–or Gmail app to Gmail server.

Rootiest ,
@Rootiest@lemmy.world avatar

GitHub runs a web-based git server at GitHub.org so teams can store their code in a central location on the internet.

Wait… it’s GitHub.org?

I always assumed it was GitHub.com…

Edit: GitHub.org only seems to support HTTP and then it just does a permanent redirect to GitHub.com

agent_flounder ,
@agent_flounder@lemmy.world avatar

Ugh I’m an idiot. Thanks.

Rootiest ,
@Rootiest@lemmy.world avatar

All good 😊 you had me going for a minute though

fruitycoder , in Need a rust version too.

You have rust, you decide to rewrite the C plan but the only library that supports it uses unsafe code so you go back and rewrite it. Wait what were you working on?

spudwart , in what's the difference?

Grub and GrubHub

nxdefiant , (edited )

Using food as the analogy:

Food…Code

Kitchen…Dev Environment (IDE, PC, etc)

Serving…Deploying

ok good so far

When I’m done with code I’m not going to deploy yet I commit and store it on a branch in git.

When I’m done making food that I’m not going to serve yet, I store it in a fridge or pantry.

When I need external code, I grab it from GitHub. When I need ingredients, I grab them from the grocery store.

So I think Food Storage, is the closest analog to git. I have local storage (pantry, fridge) that I can use to store food I have acquired.

Which would mean the grocery store is the closest analogy, but not a restaurant. Or maybe a grocery store with a restaurant.

WindowsEnjoyer , in what's the difference?

In Lemmy people are not aware that GitHub is not just git server with lots of code. :)

merc , in what's the difference?

A key difference:

If you rely too much on PornHub, you’re never going to get fucked.

If you rely too much on GitHub, you’re eventually going to get fucked.

mindbleach , in Need a rust version too.

You have Perl.

%_=~aj/dy/hfiw8i/g;
$_/a(h0w8)y@;
FWA/E.*FW[tu29uy]/;
%(1)hjc/f4ifh38/y;

The princess is saved, but all you can think about is rescuing another, with an entirely different plan. Which is just as well because you have no fucking idea how to explain the one you just wrote and executed.

cobra89 , in what's the difference?

Git = bittorrent

GitHub = the pirate bay

Code = content

Even that’s not the perfect analogy but it’s better than the OP.

vinhill ,

Though OPs example is easier for the general population to understand.

CmdrKeen ,
@CmdrKeen@lemmy.today avatar

Yes, but mostly because the general population likely isn’t super familiar with Bittorrent and PirateBay.

A better, yet similarly correct explanation would be to say GitHub is to Git what GMail is to email.

This also doesn’t confuse protocol and content, and it doesn’t require knowledge of piracy.

SHBI7368 , in It's that time of the year again!

Love it keep em coming

guy , in It's that time of the year again!
@guy@lemmy.world avatar

Guess that settles the debate, we got to pronounce it “sequel” then to optimally match syllables

db2 ,

Squirrel works too though.

Doug ,

Yes but he serves a different community

jadero ,

!squirrels

squiblet ,
@squiblet@kbin.social avatar

The Australian pronunciation works… “squi-rell”. Common American one is somehow just one syllable, “Skwurl”

jaybone ,

How do you pronounce Smurf?

squiblet ,
@squiblet@kbin.social avatar

I'm not Australian.

_danny ,

The only people I know who actually call it ess queue ell are either too new to know the “sequel” pronunciation, or the type of person you generally smell before you see.

relevants ,

Here in Germany everyone I know pronounces the letters individually – as German letters that is, which means the Q is pronounced “coo” rather than “cue”. I don’t mind it, it’s not quite as clunky as in English.

I do say sequel when speaking English though.

mctoasterson ,

Do you get irritated when Americans refer to the famous Austrian bullpup rifle as the Steyr “Ogg”?

SpeakinTelnet ,

I say ess cue ell for the sake of uniformity because it’s not Mysequel nor Postgresequel and the language changed from Sequel to the acronym SQL in the 70s so not really in the “too new” ballpark anymore.

_danny ,

I think those make sense as deviations. I’ve heard “my sequel” but you’re absolutely right about postgresql.

The name is kinda irrelevant like hard vs soft g in gif. People know what you mean when you say either.

But in that same vein, the creator of the “graphics interchange format” says the pronunciation is soft g, but basically everyone says hard g… So “official” pronunciation is kinda irrelevant.

I don’t judge anyone who uses whichever term they want, but I’ve just noticed the general trend in my smallish interaction bubble.

hakunawazo , (edited )

Don’t start the gif war again.

cm0002 ,

I’m neither, I refuse to pronounce acronyms if it doesn’t make sense to do so.

Same thing with ‘gooey’ for GUI, except I hate that even more because that straight up elicits feelings of disgust, I don’t want anything gooey anywhere near any electronics

_danny ,

I’ve literally never heard GUI said as “gee ewe eye” before.

You could just say UI, avoids the gooey phobia and sounds less weird than g u i.

RiikkaTheIcePrincess ,
@RiikkaTheIcePrincess@pawb.social avatar

Uuugghhh noooo! Ess Kyoo Ell!! ESS KYOO ELL!!! brandishes flaming pitchfork!

threelonmusketeers ,

“Squill”

pythonoob ,

Sequel to what?

GBU_28 , in It's that time of the year again!

No closing semicolon, anyone got any extras to throw on this thing?

epyon22 ,

; found this in the back for you should still work though

db2 ,

Can confirm.

Moops , (edited )

At the very least I’d try to clean up that fuzzy condition on behavior to anticipate any bad or inconsistent data entry.

WHERE UPPER(TRIM(behavior)) = ‘NICE’

Depending on the possible values in behavior, adding a wildcard or two might be useful but would need to know more about that field to be certain. Personally I’d rather see if there was a methodology using code values or existing indicators instead of a string, but that’s often just wishful thinking.

Edit: Also, why dafuq we doing a select all? What is this, intro to compsci? List out the values you need, ya heathen ;)

(This is my favorite Xmas meme lol)

mp04610 ,

behavior is an ENUM.

moroni ,
@moroni@lemmy.ca avatar

That’s a table scan, right there. Naughty.

krotti ,

Honest question, which ones wouldn’t it work with? Most add a semicolon to the end automatically or have libraries and interfaces saved me a million times?

jaybone ,

Usually with libraries like jdbc or whatever and prepared statements you don’t need the semicolon.

GBU_28 ,

Other reply s accurate but it’s always a good practice to include the semicolon else you can get

“Bobby tables’ed” look that xkcd comic up

krotti ,

Wouldn’t that still apply, if you can inject straight SQL, such as “query’ OR 1=1?”

docAvid ,

I’m not sure how including a final semicolon can protect against an injection attack. In fact, the “Bobby Tables” attack specifically adds in a semicolon, to be able to start a new command. If inputs are sanitized, or much better, passed as parameters rather than string concatenated, you should be fine - nothing can be injected, regardless of the semicolon. If you concatenate untrusted strings straight into your query, an injection can be crafted to take advantage, with or without a semicolon.

GBU_28 ,

Yep it would only work if you didn’t sanitize a user input string in this case ‘nice’

They could write ‘’; drop table blah;

pruwybn , (edited )
@pruwybn@discuss.tchncs.de avatar

Need to normalize the database. I would add a join to a BehaviorTypes table.

Edit: or, if the only options are naughty or nice, make it a boolean.

takeda ,

You need semicolons if it is a script with multiple commands to separate them. It is not needed for a single statement, like you would use in most language libraries.

mellejwz ,

If you don’t use a semicolon directly in MySQL it won’t do anything until you add it.

takeda ,

In the MySQL client console where you can run multiple commands.

If you add semicolon in language library commands such as fetch() you will get an error.

fmstrat ,

Can we get a SIMILARITY?

BolexForSoup , (edited ) in It's that time of the year again!
@BolexForSoup@kbin.social avatar

He sees you when you’re bashing

He’s hacked your VPN

jballs ,
@jballs@sh.itjust.works avatar

He knows you’re not in the sudoers file

So he’ll report your ass again

Masimatutu ,
@Masimatutu@mander.xyz avatar

He sees you when you’re sleeping, he knows when you’re awake, he’s copied on /var/spool/mail/root, so be good for goodness’ sake.

jballs ,
@jballs@sh.itjust.works avatar

I’ll be damned if that’s not the most relevant xkcd that I’ve ever seen.

Akrenion , in It's that time of the year again!

Can anyone recommend a cheap receipt printer that takes pictures from a pc or phone? I want to print mtg tokens on the fly.

meliaesc ,

Pencil

halcyondays ,

deleted_by_author

    •
    jasondj ,

    Weird that we never consider that for retail workers though…

    jasondj ,

    Gameboy Pocket. Gameboy Camera. Gameboy Printer.

    Both the perfect balance of “nostalgia” and “ridiculous”.

    neuracnu , in It's that time of the year again!
    @neuracnu@lemmy.blahaj.zone avatar

    I was reading that to the tune of the chorus of The Distance by Cake. It worked until the last line.

    Cwilliams ,

    Lol that actually works so well

    aspitzer Bot , in It's that time of the year again!

    wait until it hits little bobby tables…

    xkcd.com/327/

    JohnDClay ,

    Her daughter is named Help I’m trapped in a driver’s license facility

    jaybone ,

    He drops when you are sleeping. He drops when you’re awake.

    rufus ,

    Come they told me, pa rum pum pum pum A new born King to see, pa rum pum pum pum Our finest gifts we bring, pa rum pum pum pum To lay before the King, pa rum pum pum pum, rum pum pum pum, rum pum pum pum,

    So to honor Him, pa rum pum pum pum, When we come.

    Little Bobby, pa rum pum pum pum I am a poor boy too, pa rum pum pum pum I have no gift to bring, pa rum pum pum pum That’s fit to give the King, pa rum pum pum pum, rum pum pum pum, rum pum pum pum,

    Shall I play for you, pa rum pum pum pum, On my unsanitized database inputs?

    …

    Truck_kun , in It's that time of the year again!

    That SELECT and WHERE are all caps, but from is not is bugging me.

    I don’t care if you choose to uppercase keywords or lowercase, but consistency please.

    Also, great, love it.

    cupcakezealot ,
    @cupcakezealot@lemmy.blahaj.zone avatar

    it also implies that naughty or nice is an either or thing and not a weighted thing from an incidents table. the good place lied to us.

    ursakhiin ,

    It could be a materialized view that is generated off of a weighting where you are nice until you have a certain number of incidents.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • random
  • [email protected]
  • lifeLocal
  • goranko
  • All magazines
    •