ruslan_talpa

12 ms·

91.
by ruslan_talpa 7y ago
You haven't really looked into postgrest, it does not force the database schema on to the client. You expose a schema with views that are tailored for the frontend and can be totally different from the underlying tables that hold the a
92.
by ruslan_talpa 7y ago
Why would you prefer that? In all other intermediate layer you would write "imperative" stuff for how to transform the data and eforce it's correctnes. In the Db you "define" how it should look/behave/ and
93.
by ruslan_talpa 7y ago
what's wrong with views (which should have been used formt he start)? What were the pain points?
94.
by ruslan_talpa 7y ago
for the first one, read my other comments, this is solved. The second one, you can start here https://www.pgadmin.org/docs/pgadmin4/4.13/debugger.html
95.
by ruslan_talpa 7y ago
https://github.com/mevdschee/php-crud-api
96.
by ruslan_talpa 7y ago
more on this topic here https://docs.subzero.cloud/iterative-development-workflow/
97.
by ruslan_talpa 7y ago
you don't expose your tables directly, you expose a schema that consists only of views and stored procedures. If you really need a totally different version then you jsut exppose a new schema but more often it's the same situation
98.
by ruslan_talpa 7y ago
That was the surprise part behind my other (downvoted) comment, surprised that it still comes up on homepage with direct links (as oposed to some new development around it)
99.
by ruslan_talpa 7y ago
Yeah i know, didn’t know ho to exactly express the feeling (nice surprise)
100.
by ruslan_talpa 7y ago
It’s not marketing (100% sure :). Do you have some info on it’s usage in production?
101.
by ruslan_talpa 7y ago
This is a solved problem https://github.com/subzerocloud/postgrest-starter-kit It’just the tools you linked didnt prioritize the development workflow from the point of view od a backend developer (code in files, git, t
102.
by ruslan_talpa 7y ago
Nothing wrong with it, it’s just weird to me seing a link directly to the homepage of a product that’s been around for 5 years now, and not something like “how to do x with postgrest”. Don’t get me wrong, it’s a good thing, just a little we
103.
by ruslan_talpa 7y ago
Have you just discovered this and posted to HN? :)
104.
by ruslan_talpa 7y ago
I am not sure i get the idea, can you be more specific? + do you know ML :)?
105.
by ruslan_talpa 7y ago
The idea looks researched a bit. Send me over email the database table definitions an we can take it from there. One thing i suggest to donfirst is to spin up a wordpress and use that as an admin interface for your fruends to fill in the da
106.
by ruslan_talpa 7y ago
What’s the project about?
107.
Ask HN: Need an API for your weekend project? I'll build one for you
11 points by ruslan_talpa 7y ago|7 comments
108.
by ruslan_talpa 7y ago
It was meant in the style of "Setup and .. NginX/Redis/PostgreSQL", it assumed the reader knows about PostgREST (that's why the link is to a landing page and not to the homepage). subzero.cloud is BaaS (GraphQL &amp
109.
Show HN: PostgREST as a Service(subzero.cloud)
11 points by ruslan_talpa 7y ago|2 comments
110.
by ruslan_talpa 7y ago
* only simple CRUD apps - I've implemented with this type of stack a service similar to Parse/Firebase. I've also designed/implemented something like Basecamp+Freshbooks (in traditional PHP style, not a toy/demo app
111.
by ruslan_talpa 8y ago
How is it different/better then apgdiff?
112.
by ruslan_talpa 8y ago
Can you share what tool was the final choice and what were the quirks that influenced your decision?
113.
by ruslan_talpa 8y ago
https://docs.subzero.cloud/managing-migrations/
114.
by ruslan_talpa 8y ago
This is nothing like postgrest :) In postgrest the query is mostly determined by the the user calling the API, in SQLer the query is hardcoded by the api developer, the user just supplies the parameters to the query.
115.
by ruslan_talpa 8y ago
permissions are not a problem, you can specify exactly down to a cell what permissions a user has (read/write/delete). The problem is D.O.S., One can write a query that takes down any database without having access to any tables&
116.
Ask HN: Flatbed food printer from China
1 points by ruslan_talpa 8y ago|0 comments
117.
by ruslan_talpa 8y ago
Slightly related question about chinese products and their quality. I am planning on buying (from china) a flatbed food printer based on epson print head. Is it a good idea? It’s about 2k. Anyone know a us/eu manufacturer that makes&#x
118.
by ruslan_talpa 8y ago
> I haven't seen a single backend framework which doesn't actively encourage an N+1 problem on any query which returns multiple objects of data Well then you haven't really looked :) https://join-monster.readthe
119.
by ruslan_talpa 8y ago
The comparison is quite unfair. Elm manages a system of 1k nodes accessed by one user while sql manages a system of 1m records accessed by 1k users (i am counting browsers) soo... yeah, leaky. You never ever have to optimize anything in sql
120.
by ruslan_talpa 8y ago
in relation to your concerns about PostgREST check out these links http://docs.subzero.cloud/postgrest-starter-kit/ http://docs.subzero.cloud/architecture-and-project-structure...

More ›