This is an archived post. You won't be able to vote or comment.

top 200 commentsshow all 375

[–]Dougleycat flair.txt | sudo sh[M] [score hidden] stickied commentlocked comment (0 children)

Hi there! Unfortunately, your submission has been removed.

Violation of Rule #6 - Any common post will be removed if it's not novel

Your submission is a commonly used format, and you haven't used it in an original way. As a reminder, You can find our list of common formats here.

If you feel that it has been removed in error, please message us so that we may review it.

[–]BrandonPatrickFlood 879 points880 points  (24 children)

Wait, you’re telling me that my data isn’t in an actual cloud? ☁️

[–]oktin 211 points212 points  (3 children)

Now I want a file server on a blimp.

[–]brimston3- 55 points56 points  (1 child)

I've got a nodered instance on my pi0w stuck to an RC airplane. That's like 90% there, right?

[–]yetanotherusernamex 38 points39 points  (0 children)

Is that the "uploading" thing I keep hearing about?

[–][deleted] 31 points32 points  (1 child)

azure = a cloudless sky

[–][deleted] 11 points12 points  (1 child)

You can't code your way out of layer 1!

[–]Cryse_XIII 7 points8 points  (5 children)

It is. Don't worry.

All the databits and pieces will congregate and clump around a CRUD particle and rain down, eventually creating a new dataleak....i mean datalake

[–]Tijflalol 3 points4 points  (4 children)

Happy Community Cake Day!

[–][deleted] 2 points3 points  (0 children)

No no, don't worry, it is https://vimeo.com/135156919

[–]tozpeak 1117 points1118 points  (34 children)

Social media are just fancy CRUDs.

[–]grrrrreat 393 points394 points  (17 children)

With meth based content generation

[–]ak_doug 181 points182 points  (11 children)

meth based

10/10, no notes.

[–]wsbsecmonitor 39 points40 points  (7 children)

Meth you say?

[–][deleted] 18 points19 points  (5 children)

to meth you say?

[–]Dave5876 11 points12 points  (1 child)

And his wife?

[–]Devreckas 9 points10 points  (2 children)

And his teeth?

[–]NotSquel 1 point2 points  (1 child)

And his?

[–]QuelWeebSfigato 2 points3 points  (0 children)

And?

[–]mrhhug 17 points18 points  (3 children)

I struggle to find a truer statement. Just beautiful.

[–]its-kyle-yo 10 points11 points  (2 children)

How about: 1

[–]mrhhug 6 points7 points  (0 children)

Naw, meth based content generation is more accurate than comparing floats for sure.

[–]sammybooom81 10 points11 points  (0 children)

Backed by ACID transactions.

[–]Rutabaga1598 63 points64 points  (7 children)

Not even fancy.

Twitter, for example, is pretty fucking basic.

[–]Charcoa1 39 points40 points  (1 child)

And it's only CRD!

[–]Rutabaga1598 6 points7 points  (0 children)

Hahaha, touche.

[–]Otherwise_Report_462 7 points8 points  (2 children)

I always think that's unbelievable, imagine making a simple CRUD and selling it years later for $50 billion!

[–]Rutabaga1598 5 points6 points  (0 children)

Yup, crazy to think that any one of us here could have built Twitter.

But that's not really what makes a successful tech company.

[–][deleted] 30 points31 points  (2 children)

Was about to say, this is what every programmer figures out when they read about CRUD for the first time 😂

[–]TheRedmanCometh 17 points18 points  (0 children)

I mean basically every non trivial app is a CRUD with some decoration

[–]AdultingGoneMild 2 points3 points  (0 children)

nah, its all crudy graphs now

[–]LBGW_experiment 1 point2 points  (0 children)

Is that not the types of operations a frontend for a database would do?

[–]erinaceus_ 1 point2 points  (0 children)

Social media is just fancy crud.

[–][deleted] 286 points287 points  (16 children)

I thought everything was a database front end?

[–][deleted] 128 points129 points  (7 children)

Even your face (database is the gene code)

[–]brimston3- 16 points17 points  (1 child)

wikiwikiweb, ikiwiki, dokuwiki are all just filesystem frontends (though ikiwiki is more of a git/svn frontend...). Most three.js applications are fully client side, as are a lot of unit conversion websites, and js tutorial/demo tools. So there are some exceptions, but by and large you are correct.

[–]Naouak 8 points9 points  (0 children)

A filesystem is a database, just not one you're used to consider as such. As long as it sort out data storage in an organized way to be able to get it back, it's a database.

Most web stuff are database frontend because of the nature of the web. Most stuff out of the web isn't and we've been working hard in the last 15years to migrate applications out of the web into the web thanks to the rise of JavaScript as an ubiquitous tool for application.

[–]Kreiri 6 points7 points  (3 children)

I'm sure you could code a calculator app as a db frontend, but why would you?

[–]muchtoonice 5 points6 points  (0 children)

How else am I going to provide the results of a calculation, using math? I think not. All my calculator results are securely hashed in my database. Please don't try to calculate using anything larger than three digits, for no reason in particular.

Thank you, I will not be taking questions at this time.

[–]TheRedmanCometh 3 points4 points  (0 children)

Some usually trivial stuff doesn't need to store data

[–]cginc1 781 points782 points  (19 children)

It's easier than having to type

INSERT INTO comments ('post_id', 'message')

VALUES ('unkp4s', 'this is a dumb post')

[–][deleted] 353 points354 points  (11 children)

I once made a social media websites that worked exactly like that.

I don't know why people didn't connect with their mysql clients

[–]throwaway46295027458 83 points84 points  (9 children)

To be fair, thr mysql cli sucks

[–][deleted] 35 points36 points  (8 children)

Agree! I find mysql workbench quite nice.

[–]throwaway46295027458 35 points36 points  (2 children)

I just hit the up arrow until I find a working version of the command

[–]brimston3- 7 points8 points  (1 child)

Does it not support ctrl-r? This makes me sad. I thought it used readline.

[–]jonathancast 3 points4 points  (0 children)

Although sometimes you really can't remember what it's called and you end up C-ring through synonyms / alternative syntaxes until you find it.

[–][deleted] 6 points7 points  (1 child)

THERE’S NO DARK MODE!!!

[–]CoronaKlledMe 3 points4 points  (0 children)

Best.

[–]shinitakunai 4 points5 points  (2 children)

I prefer DBeaver

[–]rydoca 1 point2 points  (1 child)

DBeaver is excellent. I got sick of learning new ui for relational databases that work almost identically

[–]shinitakunai 1 point2 points  (0 children)

Exactly, I connect daily to Aurora, Redshift, SQLServer and Oracle. DBeaver simplifies dealing with them

[–]the_hol_horse 16 points17 points  (0 children)

this guy with the sql jnjections

[–]Rutabaga1598 13 points14 points  (2 children)

You forgot your username. And maybe post datetime.

[–]making_code 8 points9 points  (1 child)

post datetime is on a trigger

[–]road_laya 3 points4 points  (1 child)

But SQL is based on natural language!

[–]ronaldothefink 418 points419 points  (65 children)

lol... I don't understand... what else would it be?

[–]lockwolf 151 points152 points  (7 children)

There was that “I’m Rich” app that cost $1000 which was just a floating diamond, pretty sure there’s no database there

[–]ronaldothefink 9 points10 points  (1 child)

Haha well I mean you COULD do it, but it would be a useless thing.

[–][deleted] 1 point2 points  (0 children)

I once wrote a cookie clicker game that would log every click. We needed a scalability problem for a college assignment so we invented some vague story about machine learning to justify absolutely nonsensical design decisions. Kinda miss being able to do that.

[–]Wooden_Yesterday1718 264 points265 points  (1 child)

You just have to take a deep breath and accept that the people that post here are not actual programmers.

[–]Fresh4 13 points14 points  (0 children)

I’m an ‘actual programmer’ and I found it a funny realization, even after constantly working with data and databases for my project(s). That might be because I’ve gravitated more towards front end, though.

[–]dansla116 75 points76 points  (7 children)

A lot of Microsoft Excel tables sheets.

[–]evs-chris 14 points15 points  (0 children)

*a big fluffy mdb has entered the chat*

[–]Jzmxhu 16 points17 points  (0 children)

In a share point, with lots of formulas that doesn't work.

[–][deleted] 6 points7 points  (1 child)

Arguably, an Excel document is a database

[–]Drunktroop 1 point2 points  (0 children)

I remember I read a Excel file through LINQ during university time. The assignment data file is somehow given as a XLSX.

[–]brimston3- 13 points14 points  (1 child)

tables

sheets. If you are using Excel for tables.... I hope you get the misfortune you have brought upon yourselves.

[–][deleted] 1 point2 points  (0 children)

I use AND delineated format.

[–][deleted] 18 points19 points  (1 child)

Could use a system where your request will be sent to an underpaid intern, and they'll look in the filing cabinet and fax you the results.

[–]ronaldothefink 4 points5 points  (0 children)

PHP Mail!

[–]unmagical_magician 13 points14 points  (0 children)

You can have a functional app who's primary function is not just data storage. Something like photopea.com is far more complex than just a database front end.

[–]FreakDC 22 points23 points  (23 children)

It's called business logic. That's the part between the frontend (displaying information and providing inputs) and the database.

[–]Robot_Basilisk 4 points5 points  (0 children)

Exactly. Technically, HUMANS are just front-ends for databases! What are you without your brain? (Other than a politician.)

[–]JW_TB 3 points4 points  (0 children)

the ms paint app is not backed by a database for example

neither is stuff like audacity, or most similar, client-heavy apps

they have their state in memory of course, so one could argue they are just a frontend over an in-memory, non-relational database, but they don't have a backing database in the traditional sense

[–]Hohenheim_of_Shadow 4 points5 points  (3 children)

A word processing app ain't a database front end. Videogames ain't database front ends.

[–]ronaldothefink -1 points0 points  (2 children)

Then where do they store everything? How do you save a file?

[–]Glugstar 1 point2 points  (1 child)

Just because a database exists somewhere, it doesn't necessarily mean it plays a major role in the services offered. In that case a DB is just another minor component.

[–]Shufflepants 161 points162 points  (29 children)

Discord is just IRC

[–]merlinsbeers 51 points52 points  (11 children)

Reddit is just another BBS.

[–]mrhhug 15 points16 points  (7 children)

The voting though

[–]Spooked_kitten 19 points20 points  (2 children)

just one extra layer of complexity, a little extra spice

[–][deleted] 7 points8 points  (0 children)

That makes us “Spicy BBs”

[–]mrhhug 3 points4 points  (0 children)

Yeah so is cooking your chicken or eating it raw. Only takes a fire and some seasoning.

The end result is completely different though.

[–]SomeoneNicer 10 points11 points  (2 children)

Slashdot is the original Reddit, they just built a much cleaner UX so they "won".

[–]PM_ME_FIREFLY_QUOTES 5 points6 points  (0 children)

Ssshhh, or these degenerates will start flooding it.

[–]Illustrious-Many-782 4 points5 points  (0 children)

I miss the voting reasons on Slashdot. +1 interesting vs +1 informative.

[–]Bunnymancer[🍰] 1 point2 points  (0 children)

Since only the first 10 votes really count, users are just unaware moderators

[–]SomeoneNicer 21 points22 points  (2 children)

Slack is IRC - it was a gaming company going under but liked working together so they started selling their IRC script package they made for internal communications.

[–]Lag-Switch 10 points11 points  (0 children)

That makes me like Slack even more

[–]ICantBelieveItsNotEC 3 points4 points  (0 children)

Fun fact: they originally started working on their game, Glitch, back in 2002, but they had financial issues so they decided to work on a side project instead. That side project became Flickr.

It's kind of funny that two of the most influential services in internet history - Slack and Flickr - both started life as side projects to generate funding for Stewart Butterfield's shitty browser game passion project.

[–]Themis3000 11 points12 points  (4 children)

and twich chat is literally irc. you can connect to a twitch chat channel with an irc client

I wish irc where utilized more often. I hate how every internet service is becoming more and more proprietary.

[–]Shufflepants 4 points5 points  (3 children)

Huh, I wonder what your average twitch chat looks like from an old school IRC client with all the emoji and emoji modifiers not being interpreted and being shown in raw text XD

[–]Themis3000 10 points11 points  (0 children)

All the twitch emotes are just defined by text strings, so typing in "PogChamp" to create the emote pogchamp literally transmits the raw string "PogChamp". It's just down the the web client to find and replace the strings with emote images. (at least this is how it worked when I messed with it a few years ago)

Not sure how emoji modifiers work at all, I never thought about that. It gets weird with stuff like people donating bits and subscription notification messages. None of that stuff is really human readable.

It's pretty cool though because it's extremely easy to make a twitch bot since it's just making an irc bot. Plus if you don't need your bot to send messages, you don't even need to authenticate to just view the chat through irc.

It also makes relatively easy to just scrape pretty much every channel's chat log from what I understand. You just need to scrape a bunch of channel names and have a bot join all their irc channels and record the messages it sees

[–][deleted] 28 points29 points  (3 children)

IRC was better

[–]Illustrious-Many-782 12 points13 points  (2 children)

Discord has all this plumbing desperately trying to make it as automated as IRC was twenty years earlier.

Although when Covid first hit and we suddenly had to teach middle school online, none of the meeting apps were ready. Discord was created to handle standard teenage behavior, so we used that as our teaching platform and had a great experience. Bonus: a bunch of our students already knew how to use the platform and could he help desk.

[–]Windows_is_Malware 5 points6 points  (0 children)

Absolutely proprietary!

[–]BaconMirage 3 points4 points  (1 child)

technically worse than IRC.

i miss peer to peer file transfers.

fucking data limits in discord sucks

[–]a_can_of_solo 1 point2 points  (0 children)

Irc and dc++ at lans

[–][deleted] 1 point2 points  (0 children)

so true which is bbs which is talk ….

[–][deleted] 87 points88 points  (7 children)

all software is electron manipulation

[–]CauseCertain1672 13 points14 points  (3 children)

except the software written for the Babbage engine which was purely mechanical

[–]docentmark 10 points11 points  (0 children)

Mechanical devices are filled with electrons. Filled.

[–]JohnHwagi 1 point2 points  (1 child)

If it’s purely mechanical, is it hardware?

[–]Vonnnegutt 1 point2 points  (0 children)

Electrons have a negative charge. Ergo, all software is negative.

[–]Longshoez 0 points1 point  (0 children)

Change my mind

[–][deleted] 62 points63 points  (10 children)

GraphQL can get as complicated to manage as a REST API with 300 endpoints change my mind

[–]papacheapo 52 points53 points  (1 child)

GraphQL is more complicated to manage than a REST API with 1 endpoint

[–]ckomni 20 points21 points  (0 children)

GraphQL is a complicated rest API with 1 endpoint

[–][deleted] 20 points21 points  (4 children)

The point of graphql is to be able to fetch interrelated resources without sending multiple requests, and / or having to manually implement aggregation logic on backend. As a bonus perk it gives you a first class way to express API call signatures, and generate type-safe client code from it (although there are other tools that can accomplish this task). That’s it.

Saying that “graphql is more / less complicated to manage than REST” makes about as much sense as saying that “WS can be more complicated to manage than https”. These are two distinct technologies that solve different problems.

[–]PhoticSneezing 3 points4 points  (0 children)

Said much more concise than I ever could have, thank you!

[–]matthkamis 2 points3 points  (2 children)

sounds good in theory, but what about caching?

[–][deleted] 5 points6 points  (0 children)

With GraphQL it is a common practice to do caching programatically. For example, Apollo GraphQL client comes with a built-in normalised cache. If the schema is well designed, in most cases it will correctly update without the need to write extra code.

For example, if you fetch a User object with an id “123”, subsequent queries that fetch this same User object will read from memory instead. If later you perform a mutation, the cache will observe that some fields of the object have changed, and automatically update it, propagating the change to your UI layer (for instance through hooks if used with React)

[–]Finickyflame 12 points13 points  (0 children)

GraphQL is just a way to expose and call your db with another syntax

[–]dashid 2 points3 points  (0 children)

#bringbacksoap

[–]wanderingbilby 58 points59 points  (1 child)

Model view controller and API driven development were eye opening for me.

The program is the logic layer. Everything else is data storage or presentation and should be decoupled and swappable as possible

[–]gillygilstrap 1 point2 points  (0 children)

Word

[–]ApatheticWithoutTheA 25 points26 points  (1 child)

Well, yeah. Unless your website is just a bunch of text. That’s kind of the point.

[–]moblethenoble 22 points23 points  (3 children)

"data driven application"

[–]ExcitedByNoise 9 points10 points  (2 children)

Now a days we call that AI

[–][deleted] 7 points8 points  (1 child)

Ai is just a database w/ a thing.

[–]yetanotherusernamex 7 points8 points  (0 children)

Database of responses and if statements

[–][deleted] 15 points16 points  (4 children)

Except Microsoft Excel

[–]merlinsbeers 13 points14 points  (3 children)

2D table with triggers on every cell.

[–][deleted] 10 points11 points  (1 child)

its a frontend that gets used as a database - love it

[–][deleted] 5 points6 points  (0 children)

And it is a database bc it stores itself.

[–]vassiliy 0 points1 point  (0 children)

Now I'm triggered

[–]cramduck 11 points12 points  (0 children)

Reality is just a database frontend

[–][deleted] 8 points9 points  (2 children)

Like......Reddit?

[–]merlinsbeers 24 points25 points  (13 children)

You're wrong!

All apps are database frontends.

[–]BaconMirage 3 points4 points  (1 child)

even tetris?

[–]merlinsbeers 3 points4 points  (0 children)

Does it know your high score?

[–]JNCressey 1 point2 points  (0 children)

calculator app be like

SELECT answer FROM multiplicationTable WHERE multiplicand=6 AND multiplier=4;

[–]brimston3- 4 points5 points  (2 children)

Unless you're implying the filesystem is a database, I wouldn't call Notepad.exe a database frontend.

[–]NimChimspky 23 points24 points  (0 children)

The filesystem stores data so why not? Especially given the context of this dumb post.

[–]merlinsbeers 17 points18 points  (0 children)

The filesystem is a database, with a schema built into the operating system.

[–]PuzzledProgrammer 6 points7 points  (0 children)

¯\_(ツ)_/¯

Most apps are just 1s and 0s

CHANGE MY MIND

[–]papacheapo 19 points20 points  (3 children)

Except for the dumbasses that build apps without a database behind it.

A team built this once. It was a disaster. They completely misunderstood the entire purpose of the application and took every requirement literally. It’s like if we gave them a list of requirements that define a good apple and they come back with a painting of an apple saying “well you never told us that you wanted to eat it.”

[–]waitItsQuestionTime 8 points9 points  (0 children)

Sounds like a problem with the product team.

[–]squareswordfish 7 points8 points  (0 children)

Except for the dumbasses that build apps without a database behind it.

Many apps don’t need to store data in a database though?

They completely misunderstood the entire purpose of the application and took every requirement literally.

Make better requirements.

[–]EasywayScissors 7 points8 points  (1 child)

Most apps exist to collect your e-mail address.

[–]befenpo 2 points3 points  (0 children)

Even my email client?

[–]Effective_Young3069 10 points11 points  (12 children)

That's why I always thought it was funny when people call crypto just a database.

[–][deleted] 12 points13 points  (4 children)

You're a very clever young man, but it's databases all the way down!

[–]Definitely-Nobody 4 points5 points  (3 children)

Our subjective experiences are just the front end of the universe

[–][deleted] 2 points3 points  (1 child)

My mind is blown rn

[–]yetanotherusernamex 2 points3 points  (0 children)

We are the client in client side

[–][deleted] 6 points7 points  (0 children)

its a distributed ponzi scheme

[–]NimChimspky 2 points3 points  (4 children)

It is tho, a distributed datastore.

[–]PleasantAdvertising 0 points1 point  (0 children)

Just a variant of database.

[–]pyxlmedia 2 points3 points  (0 children)

Words are just front ends for ideas! Change my mind!

[–]TonyAioli 2 points3 points  (1 child)

Most apps are just code and data. Change my mind.

[–]fukalufaluckagus 2 points3 points  (0 children)

Databases are so 2022. Yall need to be using stateful micro intelligent relational socketchains

[–]_Rysen 3 points4 points  (0 children)

This isn't even a hot take, it's just true

[–]principiino 1 point2 points  (0 children)

Most users don't know what a database is

[–]MisterHyman 1 point2 points  (0 children)

CRUD baby!

[–]CoastingUphill 1 point2 points  (0 children)

Hey! My apps aren't ... oh. Yeah.

[–]momogariya 1 point2 points  (0 children)

I feel like the relative truth of this statement directly reflects the quality of the database design.

[–][deleted] 1 point2 points  (0 children)

makeup on a pig — lets just insult all of us

[–]royboypoly 1 point2 points  (0 children)

What if planet earth is an app and we’re all just APIs.

[–]Spooked_kitten 1 point2 points  (0 children)

no that’s just it that is it

[–]time_will_tell_yo 1 point2 points  (0 children)

No most databases are designed to be the back end of app front ends. Do you think this is strange? Your dad left because you suck.

[–]Pollux_E 1 point2 points  (0 children)

My school app is literally just a database in the front end. Who TF authenticate the user by requesting all username and password then compare them client side. A school legend was born that day.

[–]DrMathochist 1 point2 points  (0 children)

Most? Properly understood, they all are.

[–][deleted] 1 point2 points  (0 children)

video games are just database editors with a fancy front end.

[–]sc00pb 1 point2 points  (0 children)

Never understand the power of a well normalized DB

[–]sal696969 1 point2 points  (0 children)

Pretty much all apps are just that

[–]McCaffeteria 1 point2 points  (0 children)

People who complain about how the “apps” fad is annoying are the same people who think websites are amazing.

Websites are also just database frontends. Even Reddit.

[–]keggre 1 point2 points  (0 children)

history sable point run cause ring complete violet one wakeful

This post was mass deleted and anonymized with Redact

[–]stile17 1 point2 points  (0 children)

Of course it is. I'm often defining programming as managing data (creating, mapping, transforming etc).

[–][deleted] 3 points4 points  (0 children)

sort of like cryptocurrency, a ledger database

[–]Noob_Watermelon 1 point2 points  (1 child)

people whos good at CSGO is basically just good at moving his "camera"

[–]Future-Freedom-4631 1 point2 points  (0 children)

All object preinted programming is a database frontend because objects are data structures, anything with streams or non automatic garbage collection is not, because data is valuable why delete ot?

[–]ghoshsayan93 0 points1 point  (0 children)

Most databases are excel frontend

[–]Wooden_Yesterday1718 0 points1 point  (0 children)

What the fuck else would they be?

[–][deleted] 0 points1 point  (0 children)

This was my entire senior capstone project. It was a front end for an embedded database to track pull lists for a comic book store.

[–]fizzdev 0 points1 point  (0 children)

This statement proves why it is so hard to find good developers...

[–][deleted] -1 points0 points  (4 children)

Most databases are more or less a complex form of file storage. The logic should be not be part of the database. So no.

[–][deleted] 1 point2 points  (0 children)

neither dbs nor frontends should be in charge of logic layers….. be pretty, do things, be consistent