ruslan_talpa

Spin up your hasura instance using a docker container in something like fly.io or whatever you use do run docker containers (you can email me if you want)

I’ve got a lib/executable that you spin up and it gives you a rest api (read and write) for clickhouse if you are interested

Put them in a jar?

Exactly what you describe but not free [1]

1. https://subzero.cloud/

Interesting example. I was thinking about this more in the direction of "protecting the IP/investment" rather then "abuse the users" but i get your point.

With the telegram example, i don't see it very much different from a SaaS where you get to talk to an API however you want. My question was more in the space where the customer gets the entire codebase (to deploy it themselves) where just the core is closed (or proprietary with maybe source available)

would seeing the source for the core (but no rights to alter/reuse) improve your opinion as to "doing some scam"?

Sorry for the late reply, my email is in my profile (and the link to the product if you want to see before contacting me, though in would prefer to get in touch either by email or discord that you can find on the main page)

This exists (commercial) https://subzero.cloud/

I think i’ve built just that, can we get in touch? I would appreciate the feedback

Over the time (as part of researching competition) i also hear a lot of fans of retool with rave review (though never specifics as to what they are using it for). And i get it's appeal for building the UI, drag and drop, you see it directly and all the props of all components are there in the UI with documentation. But putting together the UIs is not what i find hard (using libraries like Reach-Admin). For me it seems way more time consuming having the UI interact with the actual backend/db and when i see in retool that this is done by "write a bunch of SQL for each table/button/screen" and they are just there in a list ... i just don't see how this is scalable/manageable for a internal tool with 10-20 screens. Also all the input validation is on the frontend ... did i miss some docs somewhere?

* localStorage is small, volatile, OPFS is big/durable

* main thread <-> db vs main thread <-> worker <-> db:

  - firstly, sqlite with OPFS has to run in a webworker

  - even if it was possible to run in main thread, this approach allows for a code structure that is similar to a traditional architecture (frontend/backend split) and it's easy to route some request to the web worker while let over request fall through and reach backend server and not needing to worry about that in the "frontend code"

in principle yes, i agree but one aspect the desktop apps lose, the distribution model. it's way easier to just say "go to this link" and the app is running (no install step, no central store, no "code signing").

since this is basically running in a (modern) browser, doesn't it follow that it works on all platforms where there is a browser?

although naively implemented [1] you write a migration in the new version

1. https://github.com/subzerocloud/my-way-track/blob/main/src/s...

I was just made aware TursoDB has a version of their client [1] with the same underlying technology so it seems it might be possible to have the best of both worlds, interacting locally with the db in the browser while it's being synced to the remote instance (not 100% sure though).

1. https://www.npmjs.com/package/@libsql/client-wasm

Weird seeing Oradea in a “top 10” list :)

Drop me a line if you ever visit.

You are wrong on both statements :) It does not stop working and this “customization” is easy.

Exactly that (same api structure) https://docs.subzero.cloud/

If by backend you mean your db (and not your python/rails code) and you want django admin functionality but with react on the frontend, check out https://subzero.cloud (ts lib), i am building it

Unlike retool, you almost never need to touch backend because the system already provides 90% of your needs just by introspecting the database, you only implement super custom endpoints where you need custom complicated queries or you need to call 3rd party systems

I am building https://subzero.cloud

If your data is in pg/mysql/sqlite/clickhouse this might work for you

That is for js/ts stack

what other stack would you pick if it also had admin?

What changed since the blog post? Employees? Cofounder?

1) The similarity is with "django admin" specifically (not django). The way i saw this was: "if you have models setup with django, django-admin gives you a admin UI for the data without any setup", with subzero "if you have a database (with any schema), subzero gives you an UI for the data without any setup" and both of these systems can be customized with code. Another way to put it: you have your db, you point subzero to it, and you get the UI linked here, no configuration needed, and if desired, it can be customized to any degree

2) actually the overview of the docs is a bit old, it was written some months ago when there was no UI (just the backend stuff) so the positioning changed a bit. While the copy on the homepage was indeed intended for "managers/CTOs" it should have certainly made sense to a developer too so i have to fix that somehow.

Thank you very much for the feedback, really valuable.

Since i can no longer edit the link of the post, here is the link directly to the login page so that the "back hijack" is avoided

https://demo.subzero.cloud/login (thank you syndicatedjelly)

Thank you for the feedback, - I though in the TLDR world, people would prefer to just see the demo instead of the "homepage" ... i guess i was wrong, anyway the link is [1]

- The back button isn't hijacked (but i get what you are saying), i linked to the / of the demo but it immediately redirects to login. I'll change the link to login so that there is no "back hijack"

[1] https://getsubzero.today/

I guess i am only 20% there with authentication/authorization/rest/db :(

It exists [0] but does not seem to be that interesting to users

[0] https://github.com/subzerocloud/pg-event-proxy-example

subZero [0] - The TypeScript library to build internal tools fast

In technical terms, it's PostgREST + GoTrue as TS library (written in rust and go, compiled to wasm, with support for Ppostgres/MySql/Sqlite/ClickHouse)

[0] https://getsubzero.today/

There is a postgrest for sqlite in rust (with js bindings)

https://github.com/subzerocloud/showcase/tree/main/flyio-sql...

This exists https://github.com/subzerocloud/showcase/tree/main/flyio-sql...