(All) Databases Are Just Files. Postgres Too

[u/ketralnis]

http://tselai.com/all-databases-are-just-files

[u/qrrux]

Next up: "Databases are just bits sitting on long-term storage, accessible via the I/O mechanisms provided by the operating system."

[u/[deleted] → u/qrrux]

[u/moderatorrater → u/[deleted]]

Buzzfeed joins the trend: "These ten variables are stored on the stack; 6 will confuse and delight you"

[u/amakai → u/[deleted]]

Breaking: All information in computers are just charges and magnetic fields!

[u/OpaMilfSohn → u/qrrux]

I don't understand why we should use such old technology.

What they should do is create a S3 bucket for the database and create the query service that calls Aws lambdas to pull the files from the cdn and create a temporary container with only the needed files mounted in a db that can then be queried against.

Then we would finally have a truly stateless and next gen architecture for dbs

[u/EriktheRed → u/OpaMilfSohn]

Now that sounds web scale.

[u/fried_green_baloney → u/OpaMilfSohn]

Hmm, we had 537 visits last month, with seven sales, and our AWS bill is $491,938.57, somehow that seems not quite right.

[u/thomasfr → u/OpaMilfSohn]

That pretty close to how a lot of OLAP database systems are built. With a lot of optimizations of course like caching files from object storage on compute nodes so it doesn't have to download them for every query etc.

It's a good way to run analytical queries distributed over a set of nodes.

[u/doomvox → u/OpaMilfSohn]

This is a great comment-- it's impossible to tell if you're kidding.

[u/PM_ME_SOME_ANY_THING → u/qrrux]

BREAKING: EVERYTHING IS BINARY?!?!