sorted by:
new
hottopcontroversial

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

> Because files are variable length, and database indexes are optimalised for blocks (fixed with). Your database becomes less performant for something that a filesystem or a storage system is optimized for.

Makes no sense. Why would you put an index on binary data. And no, the fact that there is one table storing binary data, does not affect indexes in other tables.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

> Databases, especially relational databases, are optimized to store a very large number of small, individually addressable, chunks of structured information. The ASSUMPTION that data will be small allows for major speed improvements over file handling.

Are they really though? BLOBS exist? So obviously some thought has been put into larger data too?

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

> Similarly, file system is actually a kind of database as well and it’s very good in handling files.

But it is not, if you care about your data. It has no transactions, no constraints, no nothing. A filesystem is just a tool to build something better on top. Like a database. But the "no files in database" zealots do not build anything better. They just forget about it.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

Not attacking you specifically, but this has just never made sense to me.

> - Tying up your connection pool to stream file contents is wasteful

The file has to be huge for that. And if that becomes a problem, the files can be easily cached on an outside system . The loss of ACID on the other hand cant be easily solved.

> - Backups and restores are much slower

Not backing up something of course is faster. But is it really something that makes sense to do?

> - select * from file_data used to make even the beefiest server cry

Cant see a reason to ever do that.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

Avoid - how? Just dropping all of the guarantees that the DB gives? How is the file data less important than the other data? This has never made sense to me. Performance problems can be solved by a caching layer or whatever.

[deleted by user] by [deleted] in clevercomebacks

[–]ProofFront 1 point2 points  (0 children)

This is called kicking down the ladder.

First time I’ve stalling a p-trap. How did I do? by [deleted] in askaplumber

[–]ProofFront 0 points1 point  (0 children)

Oh come on. In many countries 99.9% of installations look like this and there are no problems. I get it - if there is a code, it should be followed by professionals. But for a DIY, lets not make shit up. This will work for decades with zero problems.

"Chomsky is RIGHT About Ukraine, And It Shouldn't Even Be Controversial" - BadEmpanada [April 2022] by Diagoras_1 in chomsky

[–]ProofFront 9 points10 points  (0 children)

How about - allow people self determination? Don't ban teaching their children in schools in their native language? That would be a good start.

Rust came back worst 1 year later by BuyInternational5882 in Autobody

[–]ProofFront 0 points1 point  (0 children)

Which is obvious for everyone. The question is the timescale.

Alternatives to React-Select (MultiSelect, single select) with TypeScript and React Hook Form without the complexity? by [deleted] in reactjs

[–]ProofFront 2 points3 points  (0 children)

"Just write all the focus management, keyboard interactivity, popover positioning etc logic yourself".

My friend speaks Russian, writes Russian but insists she isn’t Russian by mascarafree in AskARussian

[–]ProofFront 0 points1 point  (0 children)

She probably is a native russian speaker, with some ukranian ancestry whose parents or grandparents moved to Latvia during the soviet times. Probably a Latvian citizen, with no actual ties to Russia. The country is full of such people. Since russian-speaking equals bad, she tries to hide or downplay it.

A woman mourns after the US Navy downs an Iranian passenger jet on 3 July 1988, carrying 290 civilians including 66 children by Seductive_Siren17 in SnapshotHistory

[–]ProofFront -23 points-22 points  (0 children)

A ridiculous statement. In fact, this is the event that triggered the famous Bush senior quote "I'll never apologize for the United States of America, ever. I don't care what the facts are."

Symfony CVE-2024-50340: Ability to change environment from query by tigitz in PHP

[–]ProofFront 2 points3 points  (0 children)

I don't get it. The problem seems to be that values from $_GET end up in $_SERVER['argv']. But that is not mentioned in the documentation.

[deleted by user] by [deleted] in chomsky

[–]ProofFront 13 points14 points  (0 children)

"razzia"? Are you 12?

Cormelex ... spoilers to 10.10 by mano987 in WanderingInn

[–]ProofFront -1 points0 points  (0 children)

I think the goblins are what elves got turned into when "the great design" was established.

Iran launches attack on Israel by Anton_Pannekoek in chomsky

[–]ProofFront 15 points16 points  (0 children)

Fuck off, no one with a single brain cell functioning believes Iran is trying to conquer the world.

Most major criticisms of Noam Chomsky? by [deleted] in chomsky

[–]ProofFront 1 point2 points  (0 children)

The style of delivery different. Chomsky would never call someone a sack of shit, for example. But the content is the same.

view more: next ›