Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Running a Bakery on Emacs and PostgreSQL (2019)

bofh.org.uk

Post reply on HN
Print view View original

31–40 of 52 posts

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

#31

Post by tyingq »

jsilence wrote: post #7
submeta wrote: 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…

Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?

Commercial Web-Based Databases: http://quickbase.com https://www.zoho.com/creator/ https://www.knack.com/ https://bubble.io/ https://airtable.com/ https://www.claris.com/filemaker/ https://www.appsheet.com/ https://ninox.com/en https://www.honeycode.aws/ https://www.ragic.com/ https://www.fusioo.com/

Surprisingly, there's not much in the way of open source with the same level of functionality as above. Here's a few:

https://cortezaproject.org/ https://www.openxava.org/ https://www.joget.org/ https://www.nubuilder.com/ https://www.openoffice.org/product/base.html https://baserow.io/

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

#32

Post by [deleted] »

codemonkey-zeta wrote: post #26
ed25519FUUU wrote: post #5

This is super cool, but I’d worry a lot about passing on the domain knowledge to somebody else without a dead-simple TUI/GUI. Eventually somebody else will need to run things.

Will this be software the author will ever have to pass on? I'd guess probably not, considering it's software for his small bakery. It's software directly tied to his identity - he's the sole consumers. That's exactly the kind of software emacs is great for, and precisely the kind of software "hacker" types use. He's not going to sell this as a "bakery management system" and become a software company, he's just going…

[deleted]

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

#33

Post by brandonmenc »

jsilence wrote: post #7
submeta wrote: 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…

Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?

> what would be the Access equivalent of today

Access.

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

#35

Post by chevman »

jsilence wrote: post #7
submeta wrote: 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…

Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?

Sharepoint forms.

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

#36

Post by hypermachine »

jsilence wrote: post #7
submeta wrote: 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…

Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?

We are working on it (starting from the VBA interpreter).

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

#37

Post by machawinka »

submeta wrote: post #8
bitwize wrote: post #6

Earlier quoted context omitted.

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…

I love Emacs and Orgmode, especially in combination with Sqlite. And I am convinced that VS Code - despite doing so many things right - does not have the versatility and the capability of Emacs, no matter how many packages are written for it because it is not intended to be configured by it‘s end users in a way where they read the code of the packages, learn from them, change them according to their needs and automat…

Viscose is impressive, but emacs is a lisp machine.

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

#38

Post by snuxoll »

jsilence wrote: post #7
submeta wrote: 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…

Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?

Force.com/Salesforce - literally the reason I pushed our business unit to purchase a couple dozen Force.com-only licenses was we had teams that needed really simple apps to store and track data and my team (internal development) did not have the bandwidth to make them with our traditional stacks.

Had something up within 48 hours, still working and worth it to this day.

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

#39

Post by jimmyed »

submeta wrote: 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…

On almost all Emacs posts, I see folks go like,

" PS: I love Emacs"

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

#40

Post by Tostino »

radiowave wrote: post #11
Topgamer7 wrote: post #4

In his follow up post he talks about union combining identical results. If the author ever reads this, you can prevent that by using `union all` instead of just `union`. That won't remove duplicates.

Indeed, though his work-around of adding a path column is something is worth having anyway, because it makes it much easier to see where the generated output has come from.

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.
Post reply on HN