Live data from Hacker News

Running a Bakery on Emacs and PostgreSQL (2019)

bofh.org.uk

51–52 of 52 posts

Re: Running a Bakery on Emacs and PostgreSQL (2019)

#51
post #6
post #3

I‘ve been using MS Access some twenty years ago to do all sorts of magic for small businesses. That was from the 90s to the early 2000s. - Later I‘d use Python to do magic for companies who didn‘t know anything better than MS Excel to handle large sets of data, and when they were lost in chaos, I‘d start to streamline, process, tidy their data and help them make sense. Just two examples that showed me: Use whatever h…

Emacs (esp. with org-mode) sits close to the barycenter of the space of problems like this, where the vector sum of "effort to use the solution to solve the problem" and "engineering effort needed to build the solution" is quite low. Building a React web app, or a Visual Basic bespoke app, might yield a nicer to use program, but would require more effort than throwing something together with Emacs Lisp, SQLite, and o…

One problem is you have to learn emacs. Then for employees they have to learn the command line etc... so reduce friction I guess is why we have webapps.

Re: Running a Bakery on Emacs and PostgreSQL (2019)

#52
post #43
post #40

Earlier quoted context omitted.

It is forcing the engine to do more work though, because it demands a distinct result set, so it adds extra nodes to the plan to remove duplicates. If you know your query doesn't have duplicates, it's much smarter to not add an extra whole sort/distinct when totally unnecessary for correct results.

I'm fairly sure that a bakery doesn't produce the amounts of data where you need to worry about such things.

I don't know, when a baker needs a dozen of something, they tend to bake 13. Maybe things get out of hand.
Post reply on HN