ruslan_talpa

15 ms·

31.
by ruslan_talpa 3y ago
I guess i am only 20% there with authentication/authorization/rest/db :(
32.
by ruslan_talpa 3y ago
It exists [0] but does not seem to be that interesting to users [0] https://github.com/subzerocloud/pg-event-proxy-example
33.
by ruslan_talpa 3y ago
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) [
34.
by ruslan_talpa 3y ago
There is a postgrest for sqlite in rust (with js bindings) https://github.com/subzerocloud/showcase/tree/main/flyio-sql...
35.
by ruslan_talpa 4y ago
This exists https://github.com/subzerocloud/showcase/tree/main/flyio-sql...
36.
by ruslan_talpa 4y ago
Give me access to your PG with a user that has no privileges, can not run queries longer then X ms and see how easy it would be to DOS the db :)
37.
by ruslan_talpa 4y ago
Soon (in the works now, it will be particularly interesting in the context of cloudflare workers talking to planetscale) https://github.com/subzerocloud/showcase
38.
by ruslan_talpa 4y ago
Because queries like this will kill any db, and you don’t need any privileges SELECT crypt( encode(digest(gen_random_bytes(1024), 'sha512'), 'base64'), gen_salt('bf', 20) )FROM generate_series(1,
39.
by ruslan_talpa 4y ago
Such a thing exists https://github.com/subzerocloud/showcase/tree/main/cloudflar...
40.
by ruslan_talpa 5y ago
Been feeling lately the fatigue of managing 3-5 different services for a every single trivial project. This pushed me to explore adding SQLite support in my product [1], i think I'll wrap a Litestream [2] process in the same container
41.
by ruslan_talpa 5y ago
You can query and write to SQLite over http with [1] (i wrote it) but it's not through the method you describe (range for files). https://github.com/subzerocloud/blue-steel
42.
Show HN: The power of PostgREST in a Rust library(github.com)
1 points by ruslan_talpa 5y ago|0 comments
43.
by ruslan_talpa 5y ago
Hey @todsacerdoti thanks for posting this :) did you try it out? I think the repo did not yet have the actual rust code (which it does now)
44.
by ruslan_talpa 6y ago
And even the frontend is probably already written for the use-case that you have https://github.com/priyank-purohit/PostGUI “ A React web application to query and share any PostgreSQL database”
45.
by ruslan_talpa 6y ago
And you can have the postgrest api up and running with https://subzero.cloud/ you just bring your own db that you control
46.
by ruslan_talpa 6y ago
I have a proof of concept for that :) (the db is PostgreSQL of course)
47.
by ruslan_talpa 6y ago
fargate with 0.25 vcpu 1gb m (lowest option) is ~$10/m ((0.01012 + 0.004445) * 24 * 30), article states it's $3 which is wrong + $16 ALB (that you need with fargate) that is $26/m for the lowest option.
48.
by ruslan_talpa 6y ago
You can setup a view (accessed by postgrest) that returns an error when there are no (correct) filters in the query so that takes care of select *... problem (also you can have the same logic in the proxy (nginx) layer
49.
by ruslan_talpa 6y ago
A “ton” is very relative. Those tables still have to be written even with ORM. And as for views/rls/triggers the total LOC i would say is orders of magnitude smaller then in traditional stacks and a lot more readable (it’s static
50.
by ruslan_talpa 6y ago
This is the “corect” response to the question above. :)
51.
by ruslan_talpa 6y ago
The things you said are a pain (or can’t be done) here is how you do it https://github.com/subzerocloud/postgrest-starter-kit Specifically, testing the sql side with sql (pgtap) and having your sql code in files that g
52.
by ruslan_talpa 6y ago
I’ve heard the same type of argument a long time ago against choosing wordpress when it was still relatively new (usually from custom webdev shops when talking to clients)
53.
by ruslan_talpa 6y ago
You keep talking about db views as though you can only read from them (an not write to them) :)
54.
by ruslan_talpa 6y ago
It works for me (focus)
55.
by ruslan_talpa 6y ago
Although part of a bigger stack, this can be used independently for postgresql https://docs.subzero.cloud/managing-migrations/ Internally it uses sqitch and apgdiff. The process is almost exactly like the one you descr
56.
by ruslan_talpa 7y ago
Postgrest? :)
57.
by ruslan_talpa 7y ago
You can submit this link as a PR to this page https://github.com/PostgREST/postgrest-docs/blob/v6.0/ecosys...
58.
by ruslan_talpa 7y ago
is there a github repo with all this sample code?
59.
by ruslan_talpa 7y ago
> no one can fix Really? No one? I learned haskell (my first FP lang) and rewrote the core of PostgREST (in my spare time) in about 6m... so stop scaring people :)
60.
by ruslan_talpa 7y ago
you CAN track the latest "CREATE" statement and deploy to a real system. Conceptually you only need to do a "diff" between your current "CREATE" and the on in the system where you are deploying. https:/&#

More ›