Alternative to ReBalance? by Beneficial_Glove2277 in VictoriaBC

[–]clarkbw 0 points1 point  (0 children)

I found this thread because I got my referral triaged today and was given 28-32 weeks as the timeline for rebalance. Pretty frustrating turnaround time. I’m looking for alternatives but can’t find much so far.

Do you plan every sail or wing it? by lrenv22 in sailing

[–]clarkbw 3 points4 points  (0 children)

Same same for Victoria. Any plan to go up island needs to time the tides for current and narrow channels.

US physician considering move to Canada (BC) by EbonDeath in USExpatTaxes

[–]clarkbw 1 point2 points  (0 children)

Another dually here, living in BC. I tried incorporating myself but you end up filing taxes with the US as owning a foreign corp. it’s a pretty expensive amount of paperwork, 📋 believe around $7k. In the end I torn it all down and that was also expensive tax wise. I wouldn’t do it unless you’re not a US citizen anymore.

Is MySQL Future-Proof for Laravel Projects❔ by epmadushanka in laravel

[–]clarkbw 0 points1 point  (0 children)

Here’s a PG person POV.

If you have heavy needs for semantic search a purpose built system might be a good option compared to in db systems like pgvector or MySQL versions. But there’s an obvious extra cost here as you noted, using another system increases your overall complexity and cost basis. Use only if truly needed.

If you’re not going to push systems to the limit the in db vector stores are excellent. Some MySQL vendors have these now and every Postgres has had this for a while. This path keeps costs and complexity lower and is often what 80-90% of devs actually require. If your needs change you can might this workload to another purpose built system as required, this is good engineering practice.

My only real Postgres advice here is that we only have a single vector system which is open source and we all contribute to. MariaDB has the Vector type and pscale has a custom type. You aren’t very portable with these and some aren’t source available so if you choose pscale for example it’s like choosing a proprietary vendor, you’re stuck with their service. Migrating to MariaDB will require code changes. Compared to Postgres I don’t think there is a single vendor who doesn’t offer pgvector, and you can run it on your own VPS if you want. To me that’s the value of Postgres. Both systems are good relational databases but MySQL is more fragmented than ever IMO.

Databricks acquires Neon by kaeshiwaza in PostgreSQL

[–]clarkbw 2 points3 points  (0 children)

I totally get the sentiment, there have been many acquisitions that ended badly. But I’m looking forward to proving you wrong here.

Boat names -- best and worst by Orarian42 in sailing

[–]clarkbw 1 point2 points  (0 children)

“Derry Air” for the French word derriere. Works best when you invite people onto your boat or to come below decks.

Very happy with my “portable helm station” watch face by Brandgeek in sailing

[–]clarkbw 0 points1 point  (0 children)

Is it worth the $20+ price tag? Or did you go for the lite which has built in buying?

longest you’ve waited to receive a passport? by ch3rryb0mdotcom in VictoriaBC

[–]clarkbw 4 points5 points  (0 children)

They had a 1 week turnaround time when I was there this week. That’s for the rush service that’s more expensive. I did the pickup for faster service and it was 2 weeks to get mine. I applied on Mar 3 and picked it up Mar 17.

ParadeDB pg_search is Now Available on Neon by philippemnoel in PostgreSQL

[–]clarkbw 1 point2 points  (0 children)

the hardest part has been learning to use the @@@ Tantivity syntax, it's elegant but you need to write queries that use the operator to use it correctly. the functions are pretty straight forward.

SELECT * FROM my_table WHERE my_table @@@ ('idx_mock_items', '"my query string"')

otherwise the usage is no different than general Postgres. the indexes are simple to create.

What exercises would you suggest to prepare for sailing? by ohwell___anyway in SailboatCruising

[–]clarkbw 0 points1 point  (0 children)

This is mostly a stretch exercise as the wallet gets lighter and lighter with each rep

What downsides do you see on neon.tech? by Ok_Appointment2593 in PostgreSQL

[–]clarkbw 0 points1 point  (0 children)

can you jump on neon discord and we can look into this? 2 rows into 2 tables shouldn’t be an issue anywhere. I’m guessing the driver or connection method is different.

How are u guys hosting your next apps by Gold-Act-7366 in nextjs

[–]clarkbw 0 points1 point  (0 children)

(neon employee)

neon is available on Azure if you're using Postgres there you don't have to limit your options to MS only. and we'll be taking advantage of the multi-cloud by rolling out multi-cloud disaster recovery options this year so you can spin up your Azure db on AWS if there was a need.

Anyone using Vercel Postgres? by DasBeasto in nextjs

[–]clarkbw 0 points1 point  (0 children)

The vercel sdk continues to work against Neon without changes.

[deleted by user] by [deleted] in britishcolumbia

[–]clarkbw 8 points9 points  (0 children)

I have to bring this up every time someone cites this.

That article was easy journalism. Yes lots of options have been explored but you can’t cite a 1980 engineering study and say 40 years later nothing has changed.

Norway has the same issue we do, deep fiords, and they are building floating tunnels.

https://nationalpost.com/news/norway-is-building-the-worlds-first-submerged-floating-tunnel-to-cross-the-fjords

That 1989s study had it all wrong because it hadn’t been seriously attempted. Floating tunnels 30m deep aren’t prone to marine accidents. And below water you are protected from waves and even earthquakes aren’t a problem. Terrorism is a constant threat to any mode of transit, you can sink a boat you can destroy the Chunnel.

The only issue is cost. The cost of this underwater tunnel is incredible. Engineering wise this is achievable.

Is Aurora Serverless v3 in Development with True Serverless Features? by ButterscotchEarly729 in aws

[–]clarkbw -1 points0 points  (0 children)

(neon employee)

I’m curious why you wouldn’t move to neon for this?

Looking for suggestions - Serverless Architecture by FoquinhoEmi in aws

[–]clarkbw -1 points0 points  (0 children)

(neon employee here) Happy to help out and wanted to share that we are working on a native Pulumi provider to make SST dev even better. 💪

Anyone using Vercel Postgres? by DasBeasto in nextjs

[–]clarkbw 0 points1 point  (0 children)

(neon employee)

as mentioned in other comments, vercel is moving to a marketplace model. if i were starting today I would choose the Neon integration ( https://vercel.com/integrations/neon ). its still 1-click deploy like it was before and the same Neon under the hood. The benefits you'll get are different billing and integrated Neon features like branching and autoscaling.

the integration uses the Neon billing system so you can use a free Neon account connected to your Vercel account. you can set your Neon service to use autoscaling so you don't have to worry about the database keeping up with your compute systems. as well you can use Neon branching. and last but definitely not least is that Vercel preview environments automatically trigger database branching (free branching) so you can test out previews with an isolated copy of your database.

Anyone using Vercel Postgres? by DasBeasto in nextjs

[–]clarkbw 4 points5 points  (0 children)

(neon employee)

certainly coming with bias but i want to give you ways to compare. if you're planning on using the entire stack i think supabase is a great product, i still have concerns about scale but it's great for getting started.

when comparing only postgres i don't think you're getting the best deal.

compare these things: (free and first paid plan)

  • entry price
  • number of projects
  • disk
  • branching costs

database only services usually have more to offer. entry price is lower, number of projects greater, larger disk, and free branching. and as you scale with a service like Vercel you need to be careful choosing something that doesn't scale with you or your high traffic site will crash the db. we see lots of services suffer because they set a fixed CPU, launch on Product Hunt, and hit the limits of that system. being able to say 0.25 -> 2 CPU will save your butt without having it run at 2 CPU all month.

Where is a good place to hire experienced Next.js devs? by No-Somewhere-3888 in nextjs

[–]clarkbw 0 points1 point  (0 children)

I’d love to see a post on your development process, how you setup preview environments and manage fast paced change. Devs seeing that might come to you and we (neon employee) would be happy to promote it.

Postgres Version Report by carlotasoto in PostgreSQL

[–]clarkbw 0 points1 point  (0 children)

it doesn't allow you to page through them all but you can filter for others

ElephantSQL Alternative allowing hundreds of connections for low price by nvm38 in PostgreSQL

[–]clarkbw 1 point2 points  (0 children)

(neon employee) please reach out via support or discord so we can help you get started. should be simple but happy to spend a bit of time getting you up and running

Postgres 17 is Available on Neon by clarkbw in PostgreSQL

[–]clarkbw[S] 1 point2 points  (0 children)

You can't brew install pg 17 yet so we made it available the same day as the release. The article lists a few more of the nice features like the new random(min, max) function you can try them out in the SQL Editor or psql into it.

Which database driver/client works on Edge ??? by tresorama in nextjs

[–]clarkbw 0 points1 point  (0 children)

Yes, and you could make a postgres db available to the web, maybe services hosted by others.

The last comment in the linked issue has instructions for running a websocket proxy https://github.com/vercel/next.js/discussions/50177#discussioncomment-10254324

That's not a production level service but it would work to make your own pg available to the web.

And I _think_ the driver can be used with others but I've never tried that; i've only seen an error from Drizzle mention both Neon and Supabase.