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

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

#201

Post by Zababa » Wed, Aug 25, 2021, 5:02 PM UTC

traceroute66 wrote: post #133

The problem with this question is it is akin to those people on photography forums and elsewhere asking "what camera / lens / ISO /shutter speed / aperture" did you use ? As if somehow having the same combination will give them the same results. Surely the correct and only answer is "the right tech stack for the job". Trying to shoehorn everything into one chosen stack is only likely to end in dismal failure. Switchi…

> Surely the correct and only answer is "the right tech stack for the job".

That is assuming that there is a "right" stack in the first place. That thread is mostly proving the opposite, that the stack doesn't really matter.

"use the right tool for the right job", "don't focus on the flavor of the month", "focus on getting users before scalability" and "KISS" all have been said a thousand times. Saying that again leads to no new insight.

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

#202

Post by Fornax96 » Wed, Aug 25, 2021, 5:10 PM UTC

wooque wrote: post #200

Fornax96 wrote: post #151

Earlier quoted context omitted.

Thanks My content delivery servers cost me about €2000 per month. I experiment a lot with different providers to drive cost down here. My storage servers are €800 per month. For that money I get about 500 TB of usable capacity (all my servers run raidz2). And then I spend about €150 on database servers. My Constellix DNS bill is €50 per month, and Mailgun is €5. So about €3000 / month worth of infrastructure. I start…

How do you keep yourself motivated to work on a product if it does not turn profit for years?

I'm hoping to find a way to make it profitable somehow. There must be something that I can sell to these millions of people who visit my site every day.

And I simply like the technical challenges it provides. I like optimizing and scaling systems and designing database schemas. I'm learning tons of stuff this way. If an opportunity provides itself to apply this knowledge I'll have it ready.

Pixeldrain as it's running right now could probably do 20 PB / month. But I have systems in mind which could take it to 100 PB / month at little additional cost.

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

#203

Post by CerebralCerb » Wed, Aug 25, 2021, 5:15 PM UTC

CerebralCerb wrote: post #59

foxbee wrote: post #53

Earlier quoted context omitted.

I would try Budibase instead of appsmith

Thanks, I'll check it out. Definitely seems like Budibase fits my use case.

I found Budibase cumbersome to use. It looks sleek, but the overall usability is worse.

To delete a component you have to find it in the component list, open a hamburger menu and delete. This despite having a panel with component details open with plenty of screen real estate for action buttons.

The API I use outputs data in a nested json ("results: ..."). As such Budi parsed everything into a single column. There was no clear way around it. Automations maybe?

In general there was very little use of the screen with most things being empty. I guess it is earlier in development than Appsmith. I do like the aesthetics and SSO support though. It was also much easier than Appsmith to install self-hosted. I'll keep following the project.

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

#204

Post by CerebralCerb » Wed, Aug 25, 2021, 5:17 PM UTC

kinj28 wrote: post #71

CerebralCerb wrote: post #6

An environment-health-security app for the B2B market * Flutter frontend iOS/Android * Parse Platform backend backed by MongoDb, hosted on Hetzner dedicated server with backups in Azure - Migrated from Firebase * ASP.NET 5.0 backend for various other integrations and periodic back office jobs - Migrated from Firebase Functions * Back office tools (CRM, billing etc) in React/Redux - Currently experimenting with Appsmi…

or you could check Dronahq.com

No self-hosted option unfortunately. It seems to be a more mature solution than Appsmith though.

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

#205

Post by ggregoire » Wed, Aug 25, 2021, 5:18 PM UTC

buro9 wrote: post #169

jjice wrote: post #161

Earlier quoted context omitted.

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

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

#206

Post by Hermitian909 » Wed, Aug 25, 2021, 5:19 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…

> you will be stuck reimplementing a sql engine in your app code.

Only if you're intent on keeping the s3-only architecture when it no longer makes sense, and the transition to SQL need need not be hard if you've been disciplined about your data structures from the get go.

I've been part of a transition from s3 only to s3/sql when business requirements changed, it only took us a week to set up a db, set up a workflow manager to insert necessary data into the db when something uploaded to s3, and ran some batch jobs for data that already existed. Total data in s3 was ~1pb.

IMO it's all about whether your problem space fits well with s3-only, and sometimes it does!

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

#207

Post by ggregoire » Wed, Aug 25, 2021, 5:31 PM UTC

_n7kw wrote: post #76

adulion wrote: post #68

Earlier quoted context omitted.

this is fantastic- do you get an affiliate fee? i'm looking a new phone and total cost of ownership might swing buying it through this site where do you source the deals? is there an api?

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)

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

#208

Post by otoolep » Wed, Aug 25, 2021, 5:40 PM UTC

cweagans wrote: post #168

justsomeuser wrote: post #158

Earlier quoted context omitted.

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.

rqlite author here, happy to answer questions about it. I should note that rqlite is a distributed database that uses SQLite as its database engine. This means in practice it does replicate a SQLite database to each node on the rqlite cluster -- but it's not a SQLite replication system per-se.

https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md

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

#209

Post by ativzzz » Wed, Aug 25, 2021, 5:41 PM UTC

Aulig wrote: post #26

I turn existing websites into apps at https://webtoapp.design I went with Flask (python) + Bootstrap for my website. The apps are created in Flutter, which was a great choice looking back on it. This allows me to have 1 codebase for both Android & iOS apps (most customers want both). If developing an app for just Android would be 100% effort, developing an app for Android and iOS with Flutter is around 130% effort I'…

Any particular reason for choosing Flutter over React Native?

Also seems like a very low price tag, I guess you're working with cheaper developers, have some automation in place and/or take on simple websites? Or maybe I overestimate the difficulty of doing this?

$850 for both android + ios is about a day's worth of work as a medium paid contractor in the U.S, and I imagine it takes longer than that to do this.

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

#210

Post by rakshazi » Wed, Aug 25, 2021, 5:47 PM UTC

I started https://etke.cc service not long ago.

Tech stack: ansible (automatization), docker (simplify deployments and maintenance), matrix (protocol) and golang (internal tools)

The idea of the service is to provide painless setup of matrix homeservers with huge customization options (not listed on website, otherwise it will be 3 desktop-screens-form in size), because if you went your matrix hs you must suffer :D and I'm trying to make it as simple as possible for newcomers to matrix world.