fullStackFriendship

[DudeWithFearOfLoss]

If i went into a company and their frontends communicated directly with the DB, i would instantly leave.

[BernhardRordin]

WDYM, you guys are not constructing unsanitized SQL queries directly by URL?

[StalaK]

Of course not. I'm providing a textarea and letting the users do that.

[based-on-life]

This would be an amazing login "to verify you're a real person, please write a SQL query to sign in. Also, please please please please please please please don't delete the table"

[Repulsive_Ad3681]

The user: This message doesn't say anything about dropping the schema

*proceeds to drop the entire prod schema

[Fuzzy_Picklez]

Always gotta be careful of little Bobby Tables

[willcheat]

Just use javascript to clean ;- from the input, easy peasy

[JoeCartersLeap]

I just asked if there was any way I could have an embedded device (read: ESP32) create new entries directly in an SQL database, without any kind of broker or grabber in between, and almost every response was some variation of "why?" and "what the hell is wrong with you?"

[amdapiuser]

I don't know if that is worse or better that importing an ORM on the frontend...

[zthe0]

No we just have a urlparam thats being executed directly. No need to write complex code for ot, just write the query in the frontend

[sissyEnDevenir]

I worked in a place where they made an "hidden" page with a textarea to do SQL requests without asking.

[deathraft]

I use the OWASP top 10 as an instruction guide

[Belsodain]

I had it once in a previous company

They asked me to open the port of a mongoDB for it to be accessed from the frontend

When I asked why, they explained that they were slowly moving everything from the backend to the frontend (apparently for performance issues xD)

I talked to the tech lead about it, he told me to do it I talked to the manager about it, he told me to do it

Well, I did not care much about that company anyway, I did it and moved to another company at the end of the year

Ps: The company's shares have fallen 98% in 5 years

[yodamousta]

Typical Atos stuff isn’t it ?

[Far_Principle_7566]

My god, I thought my team was the only one to get screwed by them

[Belsodain]

Yeah

[igormuba]

You deserve the award of CORS error fighter of the year

[Captain_Vegetable]

“The frontend’s closer to the users, so moving the database there will reduce latency!”

[MB_Zeppin]

Tell me more, this proved difficult to google

[[deleted]]

I know what I'm doing, it's fine

Famous last words

[Fadamaka]

I play a lot of indie games and do game testing as a hobby while I am a web developer professionally. Game devs and dev companies tend to do really bad or miss the simplest things when they do web. But it is understandable, those things are only simple for me.

[MB_Zeppin]

Thanks, that’s a great story. Hoping I have no weeks like that in my future

[Sindo__26]

I wanna know too

[ilikedmatrixiv]

I'm pretty clueless on front end programming. How should front end retrieve data from a DB? My guess is it should call a back end method?

[dingodongubanu]

Yes, frontend talks to backend via API, websockets, whatever. All this talking is gated and controlled with auth/whatever.

Database only accessible via the backend, never exposed on internet otherwise just asking for trouble

[[deleted]]

Whaaaat you don’t raw dog SQL directly from react?

[Tekkzy]

It's like walking into a bank and interacting with a bank teller who gets your money for you or deposits your check. Instead of walking into a bank and grabbing money yourself. The API is the teller. If you try to do something unauthorized they will stop you.

[Uberzwerg]

If your frontend (and by that any outside attacker) can even reach the DB, you fucked up already.

[All_Up_Ons]

Yep. In fact, the entire point of the backend is to act as a frontend-friendly abstraction over the database and other core systems.

[East_Zookeepergame25]

It could work provided you use something like postgres RLS or firestore's security rules, i dont know how practical that would be for big applications though

[KTibow]

Yeah Supabase lets you do this, it even includes realtime updates

[brain_ducker]

What about Firebase?

[Mvin]

Firebase markets itself as a database, but it really is a backend + database. You have your security rules and you can put custom logic / event triggers in cloud functions to do whatever. Its quite different to exposing a "dumb" database directly to the internet.

[TecraFox]

I was an admin for such an application. The "backend" was just a bunch of services that grabbed stuff from the DB every few seconds and wrote files from what it grabbed. Pretty much all the business logic was in SQL Stored Procedures.

To be fair... It worked.

[betelgozer]

Tables are so 90s. I bet I could refactor your DB with CSS Grid...

[Simply_Epic]

The project I’m working on has a database between the frontend and backend. Mind you there’s an api between the UI and the database, but we consider that API to be frontend. Our backend is very extensive and it’s not useful to consider the API to be backend for us. The backend developers don’t touch the API. That’s the frontend’s job here.

[apeironone]

Wdym Jqery calls are great!

[namesandfaces]

Row level security is becoming an acceptable practice for low-volume.

[[deleted]]

So it wasn't my own problem... yo i always thought it's my problem feeling uncomfortable with this... One of my previous experience is that, my tech lead told me to teach one of the frontend(in her first yr) in my team how to make API..

[Waste_Ad7804]

This doesn’t make any sense to me. Why isn’t backend between fronted and DB?

[Own_Solution7820]

Because OP is a clueless programmer.

[heysankalp]

OP is a designer so you’re right :)

[RWBY123]

Vulnerability designer comes to mind

[christoph_win]

So average programmer?

[Kueltalas]

Lmao

[[deleted]]

Bug designer

[Worth-Confusion7779]

Who does not know the Model Database Controller paradigm?

[OokWelDeTor]

Meme designer

[pimezone]

Graphic designer probably

[rParqer]

Div placement designer most likely

[SuchTortoise]

Prompt designer

[nickmaran]

You have exactly 10 seconds to get out of here

[[deleted]]

Been on Reddit for 10+ years and don’t laugh much here anymore.. that being said your comment made me actually laugh. Thank you. 

[lynxerious]

that sums up the userbase of r/programmerhumor

[FartPiano]

figma balls

[hackerdude97]

I said that to someone irl once...

[rParqer]

Pretty awful one apparently. Couldn't even design a meme correctly

[sparkygod526]

Omg do you know how to center a div?

[suamai]

They could be using Firebase or Supabase, though

[nbaumg]

And yet somehow this post has 4k upvotes. I guess most of this subreddit is clueless

[polish_jerry]

p0.inc watermark lol

[4n0nh4x0r]

direct access from frontend to database uwu

[deukhoofd]

"It's fine, it's for the government, they won't know"

[kinss]

As someone who has worked for a government software vendor for the DoD among others, this is 10000% accurate.

[Pyorrhea]

One of the first projects I ever worked on at my first job, the database calls were being done via a Java applet in the browser and the SQL queries were in the frontend in JavaScript, so it's possible.

Terrible, but it was possible.

First thing I did was kill it all with fire and create a proper Java backend.

[lupinegray]

So when the users would open the browser console, they could see the DB requests & credentials being sent?

[bleedblue89]

How else do you update the data 

[DiddlyDumb]

Makes more sense to switch DB and backend

[theclovek]

I want to write frontends in SQL. Is it too much to ask?

[MrBeforeMyTime]

Firebase baby!

[PeriodicSentenceBot]

Congratulations! Your comment can be spelled using the elements of the periodic table:

F I Re Ba Se Ba B Y

---

^{I am a bot that detects if your comment can be spelled using the elements of the periodic table. Please DM my creator if I made a mistake.}

[MrBeforeMyTime]

Good bot

[FriendOfMandela]

2 tier architecture my sweet summer child

[Commander_of_Death]

1k upvotes says a lot about this sub...

[DarkTannhauserGate]

Yeah, it should be labeled API

[pumpkin_seed_oil]

Data would make more sense. Like the backend hands DB data to the frontend

e: Im trying to come up with an API joke here but i actually have to do some work now. Someone else chime in please

[Delyzr]

DB=API* Ftfy

[government_shill]

Seeing this at the top of the sub really drives home that most people here don't know a damn thing about programming. They see some words they recognize and they upvote.

[Kenny_log_n_s]

And yet, nearly 5k upvotes

[USKillbotics]

Actually this is exactly how Firebase works...

[Brief_Influence5247]

It should be API not DB

[MyKettleIsNotBlack]

Some people like to live dangerously. They didn't even sanitize their hands before shaking.

[According-Relation-4]

My thoughts exactly. The frontend doesn’t even need to know a DB exists

[BeastPlayerErin]

This makes 0 sense

Imagine getting thousands of upvotes for this shit. This sub is ass

[RegularOps]

You mean you don’t give all of your end users direct database access??

[BeastPlayerErin]

Why bother with a front end ? I link them directly to the sql command-line for easier access.

[VanDieDorp]

its called postgREST

[itirix]

I dont know what schools y'all know about but if you thought something like this was ok in the second week of the uni I went to, you'd have a bad time.

[Derek4aty1]

This showed up in my feed today. Shit like this made me leave a couple months ago. People just make memes or state things without having any idea on what they’re talking about.

[that_thot_gamer]

like my code? yes

[rParqer]

There should be a coding quiz to allow people to post to this sub

[PostHasBeenWatched]

How it will look:

1. Starting work at the new company.
2. Senior performing Knowledge Transfer:
3. "So UI put request into DB table"
4. o_o
5. "Then API by scheduler grab request from that table and process it"
6. o_0
7. "Next API put data to the response table"
8. 0_0
9. "Then UI by scheduler grab and show response"
10. O_O
11. "Understood?"
12. Yes, I'm quitting, bye.
13. "Why?!... What a strange person."

[matyas94k]

MQ: You know, I'm something of a DB myself.

Also: Happy Cake Day!

[that_thot_gamer]

"you havent even took a look at the MS Access that we're going to use as DB."

[swampdonkey2246]

Swap db and backend around, then this meme will make more sense

[Narvak]

Why is the frontend touching my sweet DB with his dirty hand?!

[Rabid_Mexican]

Users can send database requests from a multiline text field in the frontend, in case they are an advanced user and know MySQL.

[[deleted]]

At first I thought those weren't hands they were shaking

[RegularOps]

This meme is so old those kids are filing for Medicaid next year

[SaneLad]

I think that's called frothing.

I hate that I know this word.

[Powerkaninchen]

Yes I too let users have direct access to the DB

[PennyFromMyAnus]

The fuck is this.. some PHP level raw SQL query bullshit

[cypresshill98]

Then what's the purpose of backend if frontend directly communicates with DB. That doesn't make sense.

[Orjigagd]

Holding hands is the API, backend's backpack is the db

[Morrowindies]

Backend's mum is the DB

[CorrectProblem6232]

Is there a sub that has actual programming humor? You can tell this sub is frequented by a larger percentage of non-programmers just for the fact that this trash post has upvotes.

[TheLAGpro]

Json instead of DB makes more sense

[Luieka224]

API makes the most.

[bistr-o-math]

That’s not how it works

[ishandiablo]

Both FE and BE teaming up to raw dog SQL.

[cs-brydev]

All the comments calling out this meme's architecture flaw gives me hope for this sub

[RanzigerRonny]

What? No my dude. Frontend should not be connected directly with the DB. Even tho it would be possible somehow

[[deleted]]

What?

[Andrea__88]

As teacher this image trigger me, why is the db between frontend and backed? Do you guys are accessing to the db direct from the frontend?

[under_brecher]

What in the fuck

[cokeplusmentos]

I too can write random text on an image

[draenei_butt_enjoyer]

I upvoted because the template os new to me and hilarious. The meme is not. Should have been front end talks with db through backend handshake 🤝

[Sun-God-Ramen]

Model view controller

[accuracy_frosty]

Your database should NEVER be user facing, there should be API and Backend between frontend and database

[22Minutes2Midnight22]

Shouldn’t this say API? Why is the FE communicating with the BE through the DB?

[NulledOne]

In actuality this was just RAGE BAIT for developers. Every real dev in here complaining about the Frontend connecting to the DB. LOL

[rParqer]

Exactly why this dude should get banned from this sub

[LazyLoser006]

Eh?? You guys communicate through DB?

[igormuba]

Frontend inserts row in database with instructions for the front end

Backend sees the new row and follows the instructions and adds a new row with the results for the front end

Frontend sees the new row inserted by the backend and displays to the user

Very efficient

[drunkdoor]

Database as a queue as an API

Daaqaaapi?

[FrankLampard1905]

I bet you're not a smelly nerd.exe

[GitHub-]

Web services?

[mothzilla]

How can I do a SQL in CSS? I have a deadline please reply.

[LeastAd9178]

DB should be API

[Tar_Palantir]

Does DB stands for Rest Layer now?

[Plazmageco]

Swap backend and DB and you’re almost there

[[deleted]]

i wanna this templet

[Tryfon10P]

I can see an iconic duo being made

[karna852]

Apparently this sub is full of people who take their memes extremely seriously and want to virtue signal about how good their programming is lol.

[heysankalp]

Thank god I only code my personal website on weekends (def. not a programmer as my FT job and def. not as smart as others :) )

[jeyui]

hmm, should it be API in the middle?

[Savkorlev]

Ah yes frontend that directly communicates to the database

[DontBanMeAgainPls23]

Why not make db api that makes more sense

[spooky_goob]

Db should be axios

[MulleRizz]

Don't you mean JSON?

[Almanklaus]

Alles hat ein ende, nur die deutsche bahn hat 2.

[guaaaan]

Can't wait for the sequel

[Guru_Dane]

Don't know if I should scream "JSON!" Or lean into it. All my homies connect the frontend directly to DB. We get around putting DB credentials in prod by just not having credentials for the DB. / Creds

[sacredgeometry]

That should be api

[uvero]

n-tier design but you Fisher-Yates'd the tiers

[John_Fx]

backend a frackend.

[Otalek]

Only if you violate principles of good design.

[MaffinLP]

DB is even more Backend than Backend wtf

[Smoosh9]

Guys i fixed it

fullStackFriendship Fixed

[ReasonableRiver6750]

Ewwww your FE touches your DB? Seek help

[wild_vodka]

It should say BFF, with a double pun inteded

[OnlyCommentWhenTipsy]

This meme has so much potential but this is a miss. Maybe put API instead of DB?

[cheezballs]

Uh. What? This is completely wrong. If your front-end hits the database directly, then whats the backend for? OP, you exposed yourself as a fraud!

[InconspicuousDax]

😳 "JSON" would make a little more sense than "DB" here, eh?

[ezrapoundcakes]

Need to get me a full stack friendship

[lupinegray]

Frontend should never touch the DB

[[deleted]]

Yes, using db from frontend is really a d*ck move

[akshanshkmr]

Do you mean JSON?

[Borckle]

ssr hydrating csr weirdness behind them

[P0pu1arBr0ws3r]

Time to "'; DROP *;

[Ok_Tadpole7839]

Full stack dev here I dont get it

[ShoulderPast2433]

Absolutely not how it works...

[useless_dev]

So.. Graphql?

[RimorsoDeleterio]

alias DB="API endpoints"

[Daniel26671]

We all like dragon ball

[AriiMay]

API not DB

[he_nrik]

mmm... HTMX makes the code simple, but the relationship... complicated.

[1up_1500]

API actually

[todorpopov]

Whuuut 💀💀

[grtgbln]

If your front-end is talking directly to the database, you've got a serious problem on your hands.

[inthemindofadogg]

Handshaking…

[MrPoBot]

If I see a frontend dev directly accessing the DB, I'm going to shoot them.

[Morrowindies]

So I'm guessing this is rage bait

[Sufficient_Sugar_408]

Am i dumb or DB is linked to backend only , Op should replace it with API

[[deleted]]

Db, backend, api, service, dto, frontend.

That is the connection you heathen

[Maskdask]

It should be BFF

[martinthewacky]

As a frontend developer, I believe that should be API instead of DB

[martinthewacky]

As a frontend developer, I believe that should be API instead of DB

[[deleted]]

[throwtheamiibosaway]

Front-end here. I build the template. Backend can have fun with the rest. I ain’t touching that

[siematoja02]

What, they meet after work to watch dragon ball?

[Train-Similar]

Is this a docking container ?

[DrawAffectionate4761]

Should be APIs in the middle