Repeating Yourself Thrice Doesn’t Turn You into a 3x Developer

• htmx

  567 32,837 9.6 JavaScript

  </> htmx - high power tools for HTML

  

I've not used it myself, but https://htmx.org/ combined with a traditional web framework like Django or Rails seems like it should greatly reduce the need to triplicate logic. At least for apps where the UI needs to be good enough rather than as good as possible.

• SQLpage

  36 797 9.8 Rust

  SQL-only webapp builder, empowering data analysts to build websites and applications quickly

Hey Ophir here, I'm the co-author of the post.

What you say is on-point, and we should have mentioned it in the post.

The way I see it is: at the beginning, everything is repeated three times on the three layers. Then, as time advances, complexity grows, and you start having much more specific requirements that will need one of the layers to differ slightly.

The common approach is to just duplicate everything three times at the beginning to be ready for the moment when something needs to diverge.

What SQLPage [1] is saying, is: when you start, just think about the database. Make it the single source of truth, and iterate quickly to find out what form the data you work on will need to have. You won't get it right the first time, so it's crucial you don't find yourself having to do the work three times for every change. And then, when you need some frontend-specific feature, make just a react component for it and integrate it in the application. Then, as the app grows, you will progressively write a full frontend for it, and an external backend, but you will never have to re-do the work you have done in the beginning. This has allowed me to make some applications that I wouldn't even have thought I would have the courage to start before.

[1] https://sql.ophir.dev

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• datasette

  187 8,955 9.3 Python

  An open source multi-tool for exploring and publishing data

Oh, I hadn't noticed your username! On the topic of maintenance: could you have a look at this pull request I opened three years ago on a repo of yours : https://github.com/simonw/datasette/pull/1159 ?

• boilerplate

  1 39 9.4 TypeScript

  A boilerplate to build apps with effect/io and effect-ts-app/libs (by effect-ts-app)

  

• pugsql

  3 663 0.0 Python

  A HugSQL-inspired database library for Python

There's a tool called PugSQL that looks promising for Python, but it seems that async isn't directly supported yet[0]. If I ever find time, I'd love to jump on this and make it work, but nobody should hold their breath for that.

[0] https://github.com/mcfunley/pugsql/issues/44

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Suggest a related project