zacharyc

This is the fifth post about putting dynamic forms on a static Hugo site. Please see the previous steps to understand where we are: Web Forms On Hugo Sites - Part 1 Web Forms On Hugo Sites - Part 2 Web Forms On Hugo Sites - Part 3 Web Forms On Hugo Sites - Part 4 Now it is time for SQL and input! Talking about input The plan for input is something like the following. The body of the post request should look like this: ...

This post is about fonts. It’s for you if you care about the nitty-gritty details of how letters are lined out. If not, it’s probably not worth your time. Secretly, I’ve always wanted to be a designer. It’s not that secret because I’ll tell anyone. The truth is that technology is not helpful unless it is easy to use. To that end, I’m a font nerd. I’m currently reading Comic Sans, a book about a font people love to hate. I’m also a member of the Secret Type Club, run by the famous Dan Cederholm of SimpleBits. ...

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. ...