On: Single dependency stacks

[chishaku]

What other examples are there of "single dependency stacks"?

This article is really about the versatility and reliability of postgres.

And I'm all in agreement.

Reminiscent of:

https://www.craigkerstiens.com/2017/04/30/why-postgres-five-...

https://webapp.io/blog/postgres-is-the-answer/

http://rachbelaid.com/postgres-full-text-search-is-good-enou...

http://boringtechnology.club/

As much as HN could lead you astray with the hype of this and that tech, articles like the above are some of the most consistently upvoted on this website.

[chubot → chishaku]

Also:

https://sive.rs/pg2 - Simplify: move code into database functions

https://sive.rs/pg - PostgreSQL example of self-contained stored procedures

some linked examples: https://github.com/sivers/store/tree/master/store/functions

I like this idea in theory ... although it would cause me to need to know a lot more SQL, which is a powerful but hostile language :-/

I care about factoring stuff out into expressions / functions and SQL fails in that regard ...

https://www.scattered-thoughts.net/writing/against-sql/

It's hard to imagine doing this with a ton of duplication. I have written SQL by hand and there are probably more confusing corners than in shell, which is saying a lot!

[7steps2much → chubot]

Depending on what database server you are on you might not he constrained to just SQL.

Now, PSQL isn't exactly all that friendly of a language either, but it does you to somewhat break stuff up into functions and reuse code across different SQL statements.

[lawn → chishaku]

While it's not exactly the same, Elixir + Phoenix is really all you need for full-stack development.