Earlier quoted context omitted.
Right. The code converts all expressions into $N-parameters. However Postgres does not support parameters in all locations, eg. this would fail: import { tableName } from "../shared" sql`SELECT * FROM ${tableName} WHERE id=${formData.get('id')}` The @vercel/postgres package needs a big disclaimer that it works very differently from node-postgres and what is and is not allowed.
They've looked at Postgres.js ( https://github.com/porsager/postgres ) before — wouldn't mind if they enabled those other cases in the same way. Also, node-postgres is ripe for sql injections because you just concatenate strings yourself when using it...
Storage on Vercel
121–130 of 144 posts
Re: Storage on Vercel
#122Earlier quoted context omitted.
What are the leading alternatives? I know about RemixJS, but not too up to date on others and how each of these compare against each other.
Remix is probably the most notable, but there’s Astro as well: https://astro.build/ My impression on Remix is fairly solid, but it doesn’t have quite the “just write and deploy” appeal that Vercel’s done quite a good job with, and they’re somewhat trailing behind Next.js in terms of tracking newer React features (which, in practical terms, doesn’t matter much, since even beta Next.js features tend to ship in a very a…
I just want to write my SSR applications with dynamic data and deploy them to Docker, Next is making it harder than it needs to be.
Re: Storage on Vercel
#123Am I the only Luddite who Deploys Go app containers. Pick a cloud. Use whatever they offer. Deploys static JS to cdn Calls it a day. I really do not understand these tools. Who is using them? I’ve built and worked on apps used by millions of people. Really don’t understand where the benefit is or if people are just over complicating basic things to extract money from chump developers?
Do you deploy just the JS to a CDN or a whole website? I wanted to do something similar, throw a static website on a CDN and use a Go API as its backend. But unsure how to get around CORS in a reliable way.
IMO biggest problem is that if your website is public facing, then just having an SPA is bad for crawlers and not great for UX.
Re: Storage on Vercel
#124Serverless everywhere yields apps with massive latency & loading times and if timeouts aren’t well tuned (read: set unreasonably high) you often get dropped connections on api calls. I am currently migrating an app off vercel to raw compute (EC2) and the difference is night and day.
Re: Storage on Vercel
#125Earlier quoted context omitted.
You will get better customer support from Vercel. Cloudflare gives almost zero customer support if you are pay-as-you-go plan.
The secret to great customer support from Cloudflare is to drop into their Discord and join the channel of the product / service you're having trouble with Most of the engineers and product leaders on the teams that make the services check those channels daily and jump into help where they can. There's also a huge community of power users there called Community Champions who help out as well.
I wish this never had to be said, it shouldn't be a secret.
Re: Storage on Vercel
#126Pricing for them: Blob: https://vercel.com/docs/storage/vercel-blob/usage-and-pricin... KV: https://vercel.com/docs/storage/vercel-kv/usage-and-pricing Postgres: https://vercel.com/docs/storage/vercel-postgres/usage-and-pr...
KV/Postgres are accurate, that Blob page sneaked in. Blob pricing should be figured out shortly, we'll update that page (it's in private beta, invite only currently).
Re: Storage on Vercel
#127I really can't stand this company and it's business model. It preys on inexperienced engineers, locks them into an ecosystem of SaaS products that abstracts away important concepts they should learn, and charges an absolutely absurd premium while doing it. No serious company is ever going to use these criminally expensive software, so it's quite clear what their target market is. Unfortunately, they have such a stron…
This managed to encapsulate something that has been in the tip of my tongue ever since I first encountered them. That company is just a sea of red flags to me.
Re: Storage on Vercel
#128the margin that vercel makes on these products that you can easily integrate with nextjs (or anything else that runs on their infra) is crazy. All of them offer easy integration with the edge or lambas functions... I don't see how vercel justifies this price outside of DX
Consumers have always been willing to pay a premium for simplicity & convenience. No difference here: devs will pay for DX.
Re: Storage on Vercel
#129> Simultaneously, as the world moves away from monolithic architectures to composable ones It's been the opposite for me. Back around 2015-2016 I was very excited about cloud functions, serverless, etc, but these past years I've gone back to mostly running VMs with regular persistent apps. Complexity has gone down considerably and there's zero lock in. With Docker I have full control over the platform and can run the…
This, feels to me like the opposite shift is happening. People moving away from microservices and going back to the monolithic arch because they realized they don’t need the scale and complexity FAANG is working on.
I know people are allergic to the word blockchain, but you can store variables on them for nearly free (its a one-time cost), have unlimited free read traffic, and have your users pay to update your state for you
your frontends just read that and update dynamically
cloud platforms aren't able to compete with that, and you can just do system design that is applicable to this infrastructure while scrapping every idea that doesn't work - just like in the before times
Re: Storage on Vercel
#130Earlier quoted context omitted.
I already lean away from S3/Azureblob/etc because their egress prices are terrible. .15/GB is borderline criminal.
150$ for a TB traffic?! Wtf
Needlessly to say, we're wrapping up testing on migrating our production (public) buckets to Cloudflare (R2) taking our cost from those $2,000 (and going up every month), to (drum roll)... $0,000/mo.
Have I mentioned AWS egress charges are borderline "extortionary"? :X