I agree. Databases are useless. You don't even need to load it into the memory. Reading it from the disk when there is a need to read something must be ok. I don't believe the case that there are billions of records so the database must be something optimized for handling it. That amount of records most likely is something like access logs etc, I think they should not be stored at all, for such case.

Even it's postgres, it is still a file on disk. If there is need something like like partitioning the data, it is much more easier to write the code that partitions the data.

If there is a need to adding something with textinputs, checkboxes etc, database with their admin tools may be a good thing. If the data is something that imported exported etc, database may be a good thing too. But still I don't believe such cases, in my ten something years of software development career, something like that never happened.

▲

zeroonetwothree 11 hours ago | parent | next [-]

Poe’s law in action?

▲

Sharlin 12 hours ago | parent | prev | next [-]

Not sure if sarcastic…

▲

fatih-erikli-cg 6 hours ago | parent [-]

It isnt sarcasm. I don't really find a case that a database that has it's own query language like SQL is needed. It won't be different than storing a JSON file and filter the content with a for loop, the dev (e.g. me) will be returning a JSON on REST API at the end. A query language may be a good thing if you are working in a team, thats it. SQL is indeed isnt a good thing.

▲

Sharlin 4 hours ago | parent [-]

Um, so your use cases are extremely narrow and limited. That's an astonising failure of imagination and a lack of understanding of real-world computer systems if you cannot understand why people have a real need of both the power of SQL and the performance of RDBMSs.

	▲	fatih-erikli-cg an hour ago \| parent [-]
		PostGIS is an extension of PostgreSQL. It claims that it has some geography features. I think it is not really related with a database. It brings only a function (HAVERSINE) that gets distance of two points on earth. It is couple of lines of code. It is not really a software project, but a detail about how the earth coordinates are calculated, and I think it is a total made up story. The real computed thing works like math.sqrt function.

▲

bsenftner 12 hours ago | parent | prev [-]

I worked as a software engineer for 30 years before being forced to use a database, and that was for a web site. I've been coding actively, daily, since the 70's. Forever we just wrote proprietary files to disk, and that was the norm, for decades. Many a new developer can't even imagine writing their own proprietary file formats, the idea literally scares them. The engineers produced today are a shadow of what they used to be.

	▲	anonymars 12 hours ago \| parent \| next [-]
		Yeah, it scares me because I'm experienced enough to know all the difficulties involved in keeping durable data consistent, correct, and performant
	▲	vlapec 11 hours ago \| parent \| prev \| next [-]
		>The engineers produced today are a shadow of what they used to be. …and it won’t get better anytime soon.
	▲	pythonaut_16 9 hours ago \| parent \| prev [-]
		> we just wrote proprietary files to disk That alone is a terrible thing. Open formats are so much more user friendly