juicypt
It reads from a replication stream and allows you to trim/enrich the replicated data by running SQL queries from the database, then writing the result out to another database (also using a custom SQL query, so it's easy to do upserts or joining with other data on the destination database).
It's working really well, and I'm just sprucing up logging and documentation a bit before making the source code public on github. The idea is for it to be a much simpler alternative to things like Debezium for small to medium sized projects.
Currently supports postgres for input, and postgres and clickhouse for output with more databases coming down the road.
No need to reveal any trade secrets at all. The above stuff is not the secret sauce that makes people buy their watches anyway: they use some of the most basic hardware in the market at their price point.
These rip through our pipelines so much faster (and cheaper) than any managed CI offering we've tried, that we didn't even bother doing proper benchmarking.
I would assume 7900X or 7950X would be even better :D
I remember owning an Asus UL30VT [1] 10 or 15 years ago, and I could have it on my lap for hours without feeling any heat regardless of the CPU load. It was a bit crappy in other ways, but a joy to use on the go!
It seems like nowadays all manufacturers try to keep the components cool, but don't care much about the external chassis temperature. Even laptops that use ultra low voltage CPUs usually go for fanless setups instead of trying to improve external temperatures.
It supports at least Firebase and Supabase. I think self-hosting Supabase + AppSmith could be a good combo for quickly hashing out prototypes or internal company apps.
For your use case I would look at AppSmith (https://github.com/appsmithorg/appsmith) or ToolJet (https://github.com/ToolJet/ToolJet).
These are full-stack low-code frameworks, but it's easy to use them to do just the frontend and connect to a backend API you implement yourself separately.
Edit: forgot to mention that these support drag&drop for building user interfaces :)
You don't need to go out to the track once per tweak of course. You could very well do a few laps to test out the whole system once in a while.
It's still pretty new though, so I don't know how well it works just yet.
EDIT: I mentioned webpack since the thread is about react, but you can do the same thing manually by putting the base64-encoded data in a data URL on a CSS file.
Other than that I would recommend Bulma (https://bulma.io/). It's like bootstrap but with a different philosophy on how CSS should be implemented. Also, it doesn't include any javascript. I think that was a good decision on their part as you won't have to fight the default behaviors on their components if you want to do something slightly different.