Live data from Hacker News

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

news.ycombinator.com

211–220 of 327 posts

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

#212
post #169

Earlier quoted context omitted.

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-c…

Is there a way to write and import the queries from a SQL file in Go? Like HugSQL (Clojure) or PugSQL (Python). To benefit from the SQL tooling (syntax highlighting, autocomplete and so on).

https://github.com/kyleconroy/sqlc

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

#213
Still haven't finished shipping the product, but the newest thing I've been working on is a site/app for analysing asset prices (stocks, commodities, land/homes).

> What is your tech stack?

Ruby, Rails, Postgres, Sidekiq, Redis, Hotwire, Stimulus, TailwindCSS and Echarts for visualizations. Heroku hosting because I don't want to deal with devops and hosting costs are the least of my worries (data's expensive these days!).

> Why did you choose it?

My background is in economics, trading and business (among other things). I picked a tech stack that makes the parts I have the least experience with (web development) easy and the Rails ecosystem really can't be beat. The 'default' Rails tech stack is also nicely curated and seems to just work.

For the parts I do know very well (economics, financial analysis) Ruby is a great language. Python/R have a few more packages (and I've used R quite a bit) but I'm rolling my own business logic anyway and I prefer Ruby as a language to both.

> Do you think your choices had any impact on your success?

Progress has been surprisingly quick so hopefully!

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

#214
post #76

Earlier quoted context omitted.

Thank you. I do get an affiliate fee for each sale. Most retailers provide csv feeds when you join their affiliate program. Parsing and organising the data can be quite difficult as there is no uniform structure and most retailers provide bad/incomplete data. There are a lot of weird edge cases I need to work around.

Hey, great service! Just FYI (you probably already know tho): - some links automatically close after loading (e.g. the first link for the iPhone 12). Maybe the deal doesn't exist anymore? - some sites seem to strip your affiliate id from the URL (e.g. the second link for the iPhone 12, metrofone.co.uk)

Thanks!

Some ad blockers are very aggressive at blocking affiliate links. uBlock Origin blocks all track.webgains.com links and even closes the tab if there's a redirect, which is probably what is happening with the first link. I'm adding a feature that will call an ajax request first, and if it's blocked then I will simply redirect to an untracked link. Unfortunately I will lose potential commission this way, but at least the website will still work for everyone. It should hopefully work if you disable your adblocker.

As for the Metrofone link, it's just a redirect on their part. I did a curl request to check this:

> GET /pclick.php?p=29805977293&a=119158&m=6506 HTTP/1.1

> Host: www.awin1.com

> GET /basket/add/contract/iphone-12-5g-128gb-black/three-100gb-new-24-month-14.00/free-delivery?source=awin&awc=6506_1629914525_c508aa142e90213248adbdee4b995550&utm_source=[redacted]&utm_medium=AWIN&utm_campaign=[redacted] HTTP/2

> Host: www.metrofone.co.uk

> GET /contract-phone-deals/iphone-12-5g-128gb-black?basketRedirect=true HTTP/2

> Host: www.metrofone.co.uk

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

#215
post #120
post #76

Earlier quoted context omitted.

Thank you. I do get an affiliate fee for each sale. Most retailers provide csv feeds when you join their affiliate program. Parsing and organising the data can be quite difficult as there is no uniform structure and most retailers provide bad/incomplete data. There are a lot of weird edge cases I need to work around.

There are a lot of weird edge cases I need to work around. This sounds like a potentially more valuable product to me. Any time I find myself doing integration work like that in an e-commerce setting I think "hm, could this be the Stripe of X".

Yep, I've definitely thought about it. There's only one other company in the UK that does this. They supply their feed/API as a service to nearly all the big comparison sites.

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

#216
For my game, I started with unity + a bunch of plugins, but switched to unreal a few months later for a variety of reasons. C++ and a lot of custom systems - third party game plugins seem to have a lot more issues than in full stack dev. It’s not really about tech stack so much as good system design choices that lets you work really fast. I put a little site up for my prototype at https://barbariangrunge.com

I also have a app for tabletop rpg prep but it isn’t live yet: node, mongo (for a certain type of user editable schema), nginx, react, redux, the usual. I replaced chef with some bash scripts in my projects a while ago and it’s been great

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

#217
Just got everything running about 2 week ago for my jobs site, https://waitwhatdoyoudo.com.

> What is your tech stack? Frontend - React Backend - Django (Python) Database - Postgres All hosted through Heroku.

Also, Data Pipelines - Airflow (Python hosted on GCE) Analytics - Google Analytics Email - Mailchimp

> Why did you choose it? I am a Data Engineer by day so regularly use Python and GCP. Where I could, I chose tools I'm already working with to limit the learning curve of using them. Where I couldn't, I chose whichever option was most hands off.

> Do you think your choices had any impact on your success? We will see. After I get the current feature I am working on, I plan to transition to marketing the site rather than working on the site. Success will be whether or not I have to jump back into maintenance mode.

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

#218
post #169

Earlier quoted context omitted.

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-c…

Is there a way to write and import the queries from a SQL file in Go? Like HugSQL (Clojure) or PugSQL (Python). To benefit from the SQL tooling (syntax highlighting, autocomplete and so on).

Yes, and it's super easy to do nowdays with embed since Go 1.16 https://blog.carlmjohnson.net/post/2021/how-to-use-go-embed/

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

#219
Golang backend, some light vanilla Javascript frontend. postgres db. running on podman (docker-compose), fedora server.

I have some background in C programming, so Go was easy to pick up. the standard libs are great for building server-side webapps with a sql backend. templates lib and some glue javascript make front-end pages a breeze.

I'm a linux guy thru-and-thru, so running fedora server on the latest kernel. latest podman from RedHat and docker-compose to orchestrate.

I'm one guy so I don't do any HA or cloud or any other funny business. My one server is racked nearby and I've had good history with the colo.

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

#220

My app is https://bioviz-studio.com , a web-based tool to create beautiful video visualizations of molecular structures. App itself is at https://app.bioviz-studio.com . Front end: Vue, vuetify, vuex, NGL, three.js/webgl, d3.js, 100% typescript, yarn, webpack Back end: node.js, express, Firebase, GCE, Blender, ffmpeg, docker, CUDA Why? Vue for pretty UI & ease of coding, NGL for beautiful molecular graphics, Firebase…

This looks great, congrats!

Since academic researchers are your customers, would you mind sharing a few tips on how to get your product in front of academic staff?

I'd assume the university department has to approve this expense, or do researchers pay out of their own pocket to avoid budget justification?

Post reply on HN