Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Prisma Raises $12M Series A

prisma.io

Post reply on HN
Print view View original

81–90 of 114 posts

Re: Prisma Raises $12M Series A

#81

Post by nogabebop23 »

sorenbs wrote: post #65
kevas wrote: post #13

I’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.

I'd suggest you watch the Prisma Day talks when they are published or give it a try. If you are a grumpy HN troll, then Prisma might not be for you, and that's okay. SQL is great for many cases, and you might not need to expand your horizon. If you do choose to look into Prisma and have serious thoughts on how we could improve, then I would love to get on a call to talk about it (contact info in bio).

>> If you are a grumpy HN troll

I guess I am, since I expect a new company with a confusing value proposition to show me why they're better than 50+ years of proven RDBMS technology vs. an "OK Boomer" watch a video and "serious questions only".

And you WORK for this company? Better develop a thicker skin...

Re: Prisma Raises $12M Series A

#84

Post by SkyPuncher »

nogabebop23 wrote: post #81
sorenbs wrote: post #65

Earlier quoted context omitted.

I'd suggest you watch the Prisma Day talks when they are published or give it a try. If you are a grumpy HN troll, then Prisma might not be for you, and that's okay. SQL is great for many cases, and you might not need to expand your horizon. If you do choose to look into Prisma and have serious thoughts on how we could improve, then I would love to get on a call to talk about it (contact info in bio).

>> If you are a grumpy HN troll I guess I am, since I expect a new company with a confusing value proposition to show me why they're better than 50+ years of proven RDBMS technology vs. an "OK Boomer" watch a video and "serious questions only". And you WORK for this company? Better develop a thicker skin...

> And you WORK for this company? Better develop a thicker skin...

Not only does he work for this company. He co-founded it. Unbelievable response from a co-founder.

I've had my reservations about Prisma (I don't think it solves a problem for me), but this pretty much discourages me from using it entirely.

Re: Prisma Raises $12M Series A

#85

Post by jasonhero »

I've been using prisma for a couple months now at my employer. The longer I use it, the more frustrated I find myself with the tool.

Here's a list of a few things out of many that you can't do with this tool (Prisma Migrate):

* Renaming columns/tables

* Migrating data from one column/table to another column/table.

* Write anything that isn't a table definition, such as procedures, functions, events, transactions, etc.

I think people are attracted to prisma at first because a single state definition of your database seems nice, but then once you wisen up you realize you're sacrificing a lot for it. There's just no way to effectively track changes like the name changing of a column between states with this sort of system.

Writing your migrations in SQL with tools like Flyway is a much more flexible and sustainable approach, in my opinion.

Re: Prisma Raises $12M Series A

#86

Post by SkyPuncher »

sorenbs wrote: post #65
kevas wrote: post #13

I’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.

I'd suggest you watch the Prisma Day talks when they are published or give it a try. If you are a grumpy HN troll, then Prisma might not be for you, and that's okay. SQL is great for many cases, and you might not need to expand your horizon. If you do choose to look into Prisma and have serious thoughts on how we could improve, then I would love to get on a call to talk about it (contact info in bio).

I just cannot wrap my head around the co-founder reacting this way in a thread about his company.

I too don't understand what I would use this product for. That doesn't mean it's a bad product, I just don't have a personal need for it.

I don't really like eating grapefruit. If you're a grapefruit farmer, it doesn't mean you farm a bad fruit. Lots of people like grapefruit. I just don't like it personally.

Calling someone like me an "HN troll" because they're critical of your product is a pretty bad look.

Re: Prisma Raises $12M Series A

#87

Post by gsvclass »

gsvclass wrote: post #30
gsvclass wrote: post #12

Looking for something similar but not VC backed checkout Super Graph. It's very similar and in GO. Also it's not VC funded or even a startup just a good old open source project with a fast growing community. Super Graph can learn your DB schema and relationships and automatically compile GraphQL to a single efficient SQL query. Use it as a standalone service or a library in your own code. It also works with Rails aut…

FYI Super Graph has a built-in migrations framework and you can write seed scripts in javascript with built-in fake data functions. https://supergraph.dev/docs/seed

Also we currently expose a `GraphQL` function that can be used within your own GO apps as a way to replace ORMs and managing SQL. Just write the GraphQL and Super Graph will figure out the join, etc and build the most efficient single SQL query to do the job. We're expanding on this to expose the entire Super Graph service as an API.

GO is a great language for web development (especially API backends) and Super Graph is a natural fit. Using it as a library gives you unlimited flexibility. The link below shows you a GraphQL example fetching posts, comments, threads, votes, etc all related imagine the code you don't have to write and maintain. when you use Super Graph.

https://imgur.com/a/RNnoqXg

Re: Prisma Raises $12M Series A

#88

Post by jaeming »

I'm very excited about the work Prisma is doing. I didn't get it at first but after trying it out, it was the best ORM experience I've had in Javascript.

It introspects your DB and generates a client that provides typescript definitions for your queries. When I try to select a non-existent field or relation, I get warned via ts.

Right now it's mainly their client that is production ready but they are making great progress on their migrations tooling. For now I still write my migrations in raw SQL, but I'll probably swicth to prisma-based migrations once it's a bit more mature.

Re: Prisma Raises $12M Series A

#89

Post by joshring »

jasonhero wrote: post #85

I've been using prisma for a couple months now at my employer. The longer I use it, the more frustrated I find myself with the tool. Here's a list of a few things out of many that you can't do with this tool (Prisma Migrate): * Renaming columns/tables * Migrating data from one column/table to another column/table. * Write anything that isn't a table definition, such as procedures, functions, events, transactions, etc…

I agree, all of the "do it all" database tools have always hurt in the long term in every system I've worked on that uses them (TypeOrm, Prisma, etc..)

From what I can tell it is always better to just learn and understand the database you are using and create it by hand. You may spend a tiny bit longer with basic crud boiler plate, but it will benefit you greatly in the long term to just have solid native migrations setup. And a framework that simply works with your database schema, rather than having an opinion forced on your database.

In Prisma, Typeorm, etc you are a slave to what the ORM wants the database to look like. Tools like Objection, jOOQ, etc are all much easier to work with in the long term and allow you to tune your database by hand and without random framework constraints.

Prisma is great if you plan on never maintaining past your MVP, so I guess it makes sense that startups use it and get stuff out the door quickly, but I don't find it as a long term solution or for it to ever be able to handle complicated situations that _will happen_ to your database in the future.

Edited: Spelling

Re: Prisma Raises $12M Series A

#90

Post by purplerabbit »

gsvclass wrote: post #12

Looking for something similar but not VC backed checkout Super Graph. It's very similar and in GO. Also it's not VC funded or even a startup just a good old open source project with a fast growing community. Super Graph can learn your DB schema and relationships and automatically compile GraphQL to a single efficient SQL query. Use it as a standalone service or a library in your own code. It also works with Rails aut…

Are there any tools out there that provide generated GQL APIs with auth provided via middleware? This looks nice, but I'm hesitant to use anything this config-file driven
Post reply on HN