zacharyc

Previous posts: Web Forms On Hugo Sites - Part 1 Web Forms On Hugo Sites - Part 2 Web Forms On Hugo Sites - Part 3 The saga of the web forms continues. Last, we left our intrepid project and were dealing with an issue with the self-signed certificate for our database. After poking around TLS, one of my brilliant friends sent me the following links: For postgres - https://github.com/porsager/postgres#ssl For pg - https://node-postgres.com/features/ssl#self-signed-cert To use the pg library we would use the second one. The issue is that I only have the self-signed certificate. ...

Previous posts: Web Forms On Hugo Sites - Part 1 Web Forms On Hugo Sites - Part 2 The next step in the process is writing the serverless function on the Digital Ocean App Platform to connect to the database. Warning: this post will not be a happy one. I’m in the middle of figuring out the best way to do this, but I’ve learned some things, and so I decided to share them. ...

Designing The Table Building on Web Forms On Hugo Sites - Part 1, the next step, discusses the database table. Database normalization is usually something I’m particularly interested in. Still, for the sake of simplicity, the approach here is designed for speed of entry and retrieval and not for minimization of data. If, for some reason, space becomes the more significant concern, there is room for optimization in this design. Each form question will be tagged with the form and submission. For example, if Alice submits a form with a collection of answers and Bob submits it with different answers, the question and answers will be tied to the submissions from Alice and Bob, respectively. ...

The Hanukkah Coffee Box was made using Hugo, a static site generator. This means it creates static code you then deploy to the web. There is no server-side execution part of the code base. This is fine if you want to show content, but if you want to interact with the visitor to your site and collect feedback on a great coffee box, you will need to do something a little creative. ...

I have a running conversation with my friend Scott about how good modern generative LLMs are at solving problems. What roles will they replace? Will we be out of work in the next couple of years? It is true; Copilot is a must-have in VSCode. It often saves time when writing repetitive code in commonly used programming languages. When I want to know some piece of information, better and quicker results can be had by asking an LLM than searching and reading through all the ad-dense articles on the internet. ...