Ask HN: Companies of one, what is your tech stack? • Hacker News Board

Re: Ask HN: Companies of one, what is your tech stack?

#161

Post by jjice » Wed, Aug 25, 2021, 2:14 PM UTC

buro9 wrote: post #5

Getting very close in my large side projects for everything to just be Go + PostgreSQL. Go is the API, business logic, and very soon the entire web layer. This is all on Linode, there are no containers I just put a binary on an LTS Ubuntu and then iptables to just those ports (with SSH configured in their Cloud Firewall to only be possible from my home IP). I have a long term itch that I want to scratch soon, whether…

How do you handle DB interactions in Go? I've been interested in how people choose between ORMs and hand written wrappers and how they structure them recently.

Re: Ask HN: Companies of one, what is your tech stack?

#162

Post by DrNuke » Wed, Aug 25, 2021, 2:23 PM UTC

Content project at https://www.tenproblems.com/ , Literature Reviews for Inquisitive Minds. Democratizing academic debates for the 2020s against fake news, sensationalism and outright biased agendas.

Wordpress (anchor website & free content) + Amazon Kindle (paid content & casual customers management) while using Google and Google Scholar as the main source for up to date references and a word processor to write the booklets.

Still tinkering about blog posts (more free content on the website to attract more traffic through SEO buzzwords) vs simple dedicated software demos on github (to create a portfolio while testing which ones to pursue commercially down the line).

Success? Break even in terms of sales for now, plus thousand visitors from all over the world enjoying the free content, and someone kindly commenting to help or just to say thank you.

Re: Ask HN: Companies of one, what is your tech stack?

#163

Post by jjice » Wed, Aug 25, 2021, 2:30 PM UTC

Crazyontap wrote: post #63

> What is your tech stack? Backend: LAMP (Linux Apache Mysql Php) Backend Framework: Php no framework only composer Frontend Framework: Vuejs 2.6 Deployment: rsync Hosting: contabo (8gb/€5) Email: SES Error reporting: Honeybadger (it's free) > Why did you choose it? It's something I've known my entire life and it works great for me.

> LAMP

> PHP no framework

> rsync

Simple and to the point, can't go wrong. I always like seeing some classic LAMP stack on postings like this.

Re: Ask HN: Companies of one, what is your tech stack?

#164

Post by theragra » Wed, Aug 25, 2021, 2:37 PM UTC

ggregoire wrote: post #154

Lot of PostgreSQL but not a single commenter uses PostgREST. Curious if it's just because the tool isn't well known enough or if it's because it has some serious drawbacks? Or people don't like writing SQL?

My friend uses it, I think, for for his single man GIS startup.

Re: Ask HN: Companies of one, what is your tech stack?

#165

Post by theragra » Wed, Aug 25, 2021, 2:37 PM UTC

theragra wrote: post #164

ggregoire wrote: post #154

Lot of PostgreSQL but not a single commenter uses PostgREST. Curious if it's just because the tool isn't well known enough or if it's because it has some serious drawbacks? Or people don't like writing SQL?

My friend uses it, I think, for for his single man GIS startup.

Works well, does what he needs it to.

Re: Ask HN: Companies of one, what is your tech stack?

#166

Post by _bqdo » Wed, Aug 25, 2021, 2:40 PM UTC

I run personal food storage inventory system as a webapp/pwa: [link redacted]

Front end runs Vue 2 with Quasar, JsBarcode, custom service worker, and PouchDB for local data persistence. The stack is optimized for ease of adding features with the pre-build GUI components, and front end PouchDB facilitates offline capability as well as keeping a user's various clients in sync.

The backend uses an nginx proxy to CouchDB for data persistence and replication, a small node.js API, and product data from various free repositories. CouchDB serves as the master store as well as the hub of replicating data between clients on the same account.

The architecture and tech choices are very closely tied to client desires. Clients planning for disasters demand the software continue to function offline or in degraded network environments, so this feature drives the overall offline-first data architecture. Data needs to remain in sync across a family's devices so the replication and keeping all the clients up to date is a big value add.

Re: Ask HN: Companies of one, what is your tech stack?

#167

Post by BilalBudhani » Wed, Aug 25, 2021, 2:40 PM UTC

rishav_sharan wrote: post #85

Not really a company yet, just a WIP product. Vanillajs for the frontend, crystal for the backend, postgres for the db, fly.io for the app hosting, Cloudinary for the CDN, trello and Github issues for management. IMO, simple vanillajs blows any other js framework out of the water in simplicity. Crystal is an amazing and very performant language for the backend. If you love ruby, you would love Crystal.

What Crystal framework are you using? Coming from Ruby I gave serious try to Crystal a few months back but couldn't move forward because of the current state of Crystal ecosystem. I do hope it improves.

Re: Ask HN: Companies of one, what is your tech stack?

#168

Post by cweagans » Wed, Aug 25, 2021, 2:44 PM UTC

justsomeuser wrote: post #158

buro9 wrote: post #5

Getting very close in my large side projects for everything to just be Go + PostgreSQL. Go is the API, business logic, and very soon the entire web layer. This is all on Linode, there are no containers I just put a binary on an LTS Ubuntu and then iptables to just those ports (with SSH configured in their Cloud Firewall to only be possible from my home IP). I have a long term itch that I want to scratch soon, whether…

Opinion: Don’t put your business data in s3 objects! It can work if all you will ever need is a key value store, but as soon as you need SQL-like queries (joins, filtering, transactions) you will be stuck reimplementing a sql engine in your app code. I recommend to try SQLite with some kind of replication (either Linode disk snapshots, Litestream etc). Having your state observable and local to your application instea…

+1 for SQLite. You might take a look at https://github.com/rqlite/rqlite if you really need replication. SQLite can go pretty far on its own though.

Re: Ask HN: Companies of one, what is your tech stack?

#169

Post by buro9 » Wed, Aug 25, 2021, 2:50 PM UTC

jjice wrote: post #161

buro9 wrote: post #5

Getting very close in my large side projects for everything to just be Go + PostgreSQL. Go is the API, business logic, and very soon the entire web layer. This is all on Linode, there are no containers I just put a binary on an LTS Ubuntu and then iptables to just those ports (with SSH configured in their Cloud Firewall to only be possible from my home IP). I have a long term itch that I want to scratch soon, whether…

How do you handle DB interactions in Go? I've been interested in how people choose between ORMs and hand written wrappers and how they structure them recently.

Manual via https://pkg.go.dev/database/sql with handwritten SQL in the majority of places... but with a wrapper to handle the more complex search scenarios.

For example these from a multi-tenant SaaS forum platform (it's old, but it's also OSS so I can show you)...

This helper to get connections: https://github.com/microcosm-cc/microcosm/blob/master/helper... used like this for inserts: https://github.com/microcosm-cc/microcosm/blob/master/models... and this for reads https://github.com/microcosm-cc/microcosm/blob/master/models... .

But searches... i.e. highly consistent SELECT queries with different WHERE statements (and potentially FROM statements), then in each project I tend to have an idea of a search struct ( https://github.com/microcosm-cc/microcosm/blob/master/models... ) that will validate the inputs and represent the search query, and then something that will consume that and build the SQL for it ( https://github.com/microcosm-cc/microcosm/blob/master/models... ). This isn't pretty... but it's easy for me to tune, debug, and keeps the rest of the code base very maintainable... all the complexity is here in the search.

The vast majority of SQL is very very simple and needs no ORM, and the complexity is just in the search scenario where I want to be able to tune the performance more than an ORM would allow me to do so.

Re: Ask HN: Companies of one, what is your tech stack?

#170

Post by adamhp » Wed, Aug 25, 2021, 2:57 PM UTC

I'm building a web-app called Tripmix, that lets you build travel guides for your friends (like FB Recommendations meets Canva).

I use Postgres, FastAPI, and TypeScript React. I wouldn't recommend TypeScript for solo developers who need to iterate and prototype quickly. That's been my biggest regret thus far. I think the end result will be much cleaner but I've sacrificed a lot of time getting it there, when I could have been shipping. It's all been a good learning experience though, and that's how I'm treating it.

Picked all of them out of familiarity.