zlacker

[return to "Running a Bakery on Emacs and PostgreSQL"]
1. istjoh+Pp[view] [source] 2019-02-26 14:32:34
>>flocia+(OP)
I have only ever been a tech hobbyist, but I have leveraged my Python skills in a similar way. I run a home cleaning service with my wife, and I started using Airtable to track clients, jobs, expenditures, employee hours, etc. The data entry became tedious due to having to make entries in multiple tables for each job, so I wrote a Python script to use a simple command line read-eval-print loop to collect job information and make entries in the appropriate Airtable tables through the Airtable API.

I also use Python to produce paycheck stubs, do simple business data analysis, and email me leads from our website.

A small tangent: I have recently become frustrated with the limitations of a command line interface (primarily the inability to display charts and graphs), but there is a dearth of solid alternatives. Both web frameworks and GUI frameworks add far too much complexity for a solo amateur developer to quickly iterate to meet a small business' needs.

I would love to have a product that let me produce ugly but practical GUIs in Python without having to learn a big framework like PyQT or Django. EasyGUI comes close, but isn't quite good enough.

For now, I update an HTML file to display graphical output in Python and use a Firefox extension to auto-refresh the page on changes.

◧◩
2. roel_v+xW1[view] [source] 2019-02-27 02:43:23
>>istjoh+Pp
I have the exact same problem, I've tried many things over the last 10 years and the solution you're using is (imo) by far the easiest, most flexible and robust. It feels hacky but it just works. If you want some interactivity (different graphs in tabs for example) you can just add some jquery or bootstrap - basically a serverless SPA (real serverless, not the 'cloud hosted' thing they call 'serverless' nowadays). I have 'apps' for recipe management, investing, and food forest design that work this way (the food forest one even incorporates Sketchup 3d models and generates a clickmap that lets you click on 2d renders of 3d models to let you interactively select areas using the canvas api - so yes you can make it as complicated as you want, but the easy things remain easy).
[go to top]