Earlier quoted context omitted.
I believe this is normally called innovation :-P
LPad was innovation too and that broke everything.
Prisma Raises $12M Series A
71–80 of 114 posts
Re: Prisma Raises $12M Series A
#72Earlier quoted context omitted.
> working with databases in Node.js and TypeScript has always been a painful experience Even after reading your (three) paragraphs from the article on why raw SQL and drivers are bad, I'm far from sold. 1. Establish connection 2. Execute SQL 3. Manipulate results 4. More SQL/Commit/close IME a lot of the struggle comes from not understanding how 1. or 2. work and trying to do all the heavy lifting in 3. The amount of…
On the other hand, working at a large company I saw a many-line SQL query that had been run monthly for a long while, looked at and edited by quite a few people, which down in the middle of it was comparing (for equality) a city id and a probability. There is absolutely room for improved tooling. I have no idea whether Prisma is it.
Re: Prisma Raises $12M Series A
#73Related and FWIW: I checked all solutions in this space and I stuck with type-graphql which is not only an amazing lib but offers a clean architecture: Decorated Typescript types as classes dictate the GraphQL schema and the DB model (either through further decorator libs or custom solutions). So, you end up with only one source of truth + stay DRY + very low level of abstractions. There is some debate around the rig…
TypeGraphQL and Prisma are not really comparable though. Prisma is an open-source database toolkit (much like an ORM), TypeGraphQL is a GraphQL schema construction library (like `graphql-js` or `@nexus/schema`), they solve very different problems! You can even combine Prisma with TypeGraphQL if you're building a GraphQL server that needs to access a databases. In that case, you'd use Prisma Client inside your TypeGra…
I saw that you integrate with type-graqhql but the integration hasn't convinced me yet, somehow type-graqhql loses its elegance with the resulting architecture.
Besides, did you sponsor type-graqhql's maintainer to collaborate with Prisma 2?
Re: Prisma Raises $12M Series A
#74Re: Prisma Raises $12M Series A
#75a similar open source project is Postgraphile: https://www.graphile.org/postgraphile/ I've used it on 3 non-trivial projects with great success
Re: Prisma Raises $12M Series A
#76Re: Prisma Raises $12M Series A
#77a similar open source project is Postgraphile: https://www.graphile.org/postgraphile/ I've used it on 3 non-trivial projects with great success
- Prisma is supposed to use as an ORM and not to be publicly exposed (although you can if you want)
- Postgraphile is a way to create an API using only your DB schema as reference. There are some tricks here and there, but you would need to do dig quite deep in SQL.
I tried postraphile and is quite cool for quick prototypes. Once you need something more custom, it gets tricky and weird (it is doable though). I haven’t tried Prisma in prod because, at the end, I am pretty happy with sqlc in Golang (code generator based on SQL queries).
Re: Prisma Raises $12M Series A
#78Re: Prisma Raises $12M Series A
#79I’m not seeing why I’d use this over sql. Can someone please enlighten me as I find this to be much more gobbledegook than sql.
My first instinct was to say type safety, but you don't really get that with JS either way. Maybe it would be popular for new engineers that don't feel like learning SQL. Same reason why MongoDB got popular.
> Maybe it would be popular for new engineers that don't feel like learning SQL. Same reason why MongoDB got popular.
We have more and more senior engineers who want to use Prisma, as they just realized that writing SQL by hand is a waste of time.
Let's be honest - learning SQL is still a great skill. Data analytics etc - there are great use-cases.
But if you want to get stuff done and scale your team when building an _application_ - you should have a data layer.
That's what Facebook, Lyft, Airbnb etc did - they have a dedicated data layer and a team working on that. Do you think an application engineer at Facebook writes SQL? No. Of course not, it would be a total waste of time to let them touch such a low level. It would not allow facebook to scale to where they are, if everyone would write direct SQL.
Now the thing is, most small teams don't have the capacity to write a really performant awesome data layer with caching, deduping etc.
That's where Prisma comes into play - Prisma gives the weekend producthunt warriors, but also the enterprise teams (like Tryg) a way to abstract away the database.
But it's just a library you say? That's true. So in that sense, Prisma is not really a "layer", a different component in your architecture that you can horizontally scale.
For that - stay tuned. The "client" part can already easily be separated from the "query engine" part (which btw is written in Rust) because they speak http. But step by step. For most people, being able to install an npm dependency is the most important part here. But one thing you can already get used to - Prisma will stick around and _not_ just be a thing that new engineers who don't feel like SQL use.
Re: Prisma Raises $12M Series A
#80The graphic under "Database tools are stuck with legacy paradigms" made me chuckle. Just because the tech under the "Legacy" column isn't the new hotness doesn't mean they're suddenly irrelevant or even a bad choice.
It's not like I need to choose between an ORM, query builder and plain SQL either... Why can't I use any of them as the problem dictates?