Hacker News Reader

Ok, why then do we pick Postgres for many projects that could be build on something simpler?

The ”YAGNI” motto usually needs to be combined with ”don’t paint yourself into a corner”.

What's simpler than Postgres?

SQLite, plain localStorage in the browser, the file system for desktop apps, …?

You're going to definitely need a schema, so you want a SQL database, which leaves SQLite and Postgres. The only difference between the two is one requires a server. If that's too inconvenient, SQLite is a solid choice.

> .The only difference between the two is one requires a server.

Lol, no. Postgres has tons of features that SQLite lacks.

Except we're talking about Postgres being more complex than SQLite, please follow the thread.

Regardless of the context, your statement that the only difference between SQLite and Postgres is that one requires a server is plain wrong. That would be like discussing Emacs being more complex than Vim, and then saying, "The only difference that Emacs has from Vim is that Emacs typically uses a client/server architecture".

How often have you seen desktop apps pick postgres over sqlite or the file system?

Reply on news.ycombinator.com