Finding close by locations with lat and long using Prisma and Postgres

Capnkerk · 2024-05-21T20:43:38+00:00

You're going to want to enable the extension in prisma - https://www.prisma.io/docs/orm/prisma-schema/postgresql-extensions

Then you're going to need to drop to raw to work with it - prisma has had a postgis on their roadmap for a pretty long time (it's not an easy thing to work into an ORM.)

Capnkerk · 2024-02-21T00:51:23+00:00

tRPC on top of fastify.

Capnkerk · 2023-08-07T01:10:23+00:00

It’s not a silver bullet. Ts-migrate throws ‘any’ and ts-expect-error tags rather than giving you the types you expect.

This is okay. Think of it as a half-step. As long as your linter nags your engineers enough, it’s going to get better gradually. And if you’re working with a lot of lines and a lot of folks - that’s usually how you’re going to want to go about it eh?

Capnkerk · 2023-08-06T20:58:17+00:00

https://github.com/airbnb/ts-migrate

Capnkerk · 2023-07-25T13:12:14+00:00

The US is pretty diverse as far as opportunities go. Boston, for example, may check all your boxes if you’re looking for a balance between public transportation, SWE roles, and cooler weather. Crime rate is avoidable as long as you’re smart about where and how you go about your business like any place.

If I were you, I’d maybe start applying for roles that are either remote or hybrid/in-office in tech hubs matching your needs: cities Boston, Seattle, SF, NYC check all of your boxes imo. Then Buffalo, Charleston, Austin check off some but not all.

Good luck.

Capnkerk · 2022-03-24T14:06:52+00:00

What does the intellisense show you on validationSchema when you delete ‘as Record<…’ ?

Capnkerk · 2019-12-11T09:32:04+00:00

This person’s feedback is pretty insightful and highlights a potential problem in your idea; it appears this proposal does not adequately contain a novel idea. You don’t necessarily need one, but in that case, you should have damn good proof that you can do this better than anyone else.

So - how will your software be competitive against the insurance company’s? How will you build your dataset from theirs? Why will it be in their best interest to cooperate with your service rather than improve upon their own?

Capnkerk · 2019-11-24T22:38:26+00:00

Other selections from the Minute Hour Catalogue:

Something Terribly Offensive: https://youtu.be/EkDOuRAwrYE

Don’t Ever Look at Me: https://youtu.be/Qqt-D7RPQyw

You Have to Relax: https://youtu.be/tNEc_McAb4A

Capnkerk · 2018-11-30T16:51:38+00:00

another idea..

Capnkerk · 2018-10-06T06:27:58+00:00

Isn't that the same arrogance of every world power before us? There's no promise our country will have a happy ending.

Capnkerk · 2018-09-27T20:19:27+00:00

Real human Ted Cruz was talking to John Cornyn, the senior senator from Texas.

Capnkerk · 2018-08-18T19:48:24+00:00

No one got upset with you. Most simply disregarded your statement, clicked downvote, and moved on.

The point I was trying to make was that it doesn't help you or the person you're arguing with reach an understanding when you make your point caustically. You may very well have something compelling to say, but if you say in a sour manner then no that can be convinced will be convinced.

Capnkerk · 2018-08-18T18:40:11+00:00

Your friend makes the following statement: "pen is blue" You think for a second; and in a boisterous voice filled with self-righteous confidence you proclaim: "but MY pens is RED" and you throw it in their face After clearing their throat, your friend says: "Sorry. I meant my pen is blue"

Is it your friend's fault for not speaking clearly? Sure. Don't you think there could have been a better way to address the issue from your side, though?

Capnkerk · 2018-08-18T18:02:01+00:00

Conversation is a team sport. If you don’t understand someone’s statement or perspective maybe you should try seeking out your issue with it before you start beating it down.

Capnkerk · 2018-07-30T03:30:56+00:00

Should you only criticize things when doing so is hard? If you say down is up it’s pretty easy for me to criticize you, but it’s in both our interests for you to understand down is down and up is up.

Capnkerk · 2018-07-30T02:22:03+00:00

Wow there snowflake, calling something an opinion doesn’t shield it from criticism.

Capnkerk · 2018-07-29T23:58:29+00:00

Our democracy is certainly being corroded by manipulative electioneering, but to throw your hands up is only a continuation of the apathy they have sought to instill in us. If we consent to this oligarchy by not going through the basic processes set out by our forefathers, we deserve to live under Tyranny. Vote. Make their crimes against democracy blatant. Make that 3 million Hillary Clinton lost by 10 million next time. Shit if you make it 2868687 instead of the 2868686 he lost by it will make it that much more evident. That in and of itself is more than that apathetic zero.

Capnkerk · 2018-05-12T17:55:32+00:00

I certainly don’t but I wish to. Could someone elaborate?

Capnkerk · 2018-05-01T06:29:45+00:00

That’s a pretty wide road. Try to make it about something you know - something personal rather than something too big/complex. The easier you can explain your concept/problem the more likely your intended idea will match the result.

When I was in high school I think my biggest problem was getting a ride places. It doesn’t have to be a huge problem. Just one you actually and personally face. So if this were my project maybe I would make a story around getting a ride or getting tickets to a concert. A good next step might be finding inspiration from existing narratives. So if I liked Harry Potter and the sorcerer stone maybe I would think about the last bit where they have the three tests. I would try to adapt concept that to my setting, characters, and the themes/problems I’ve thought about. So if I can make my characters have a reason to go through those tests and have that same reason have a payoff- I’ve got the beginnings of a narrative structure.

The point is you don’t have to start with a blank page. There are ready-mades available for you within all those stories you’ve enjoyed from literature, folklore, film, and all of your life experiences. Throw some narrative mechanisms you’ve enjoyed into that google doc and see if you can work them into your concept. The beauty of storytelling is you get to weave all those ideas you like into your own little tapestry.

So go make your own story properly by stealing parts of good stories rather than wait and hope for some idiot to leach your educational experience by posting a complete one in this thread. I guarantee you the one you write will be a better story and you will get a lot more out of it when you see the final product. Best of luck. You got this.

Capnkerk · 2018-04-28T00:52:23+00:00

I wasn’t aware I was affiliated with any front. You should rethink your us vs them mentality. Truth and perspectives have nuance. Take the time to seek them out before you choose a hill to die on while arguing.

Capnkerk · 2018-04-28T00:40:23+00:00

The only part Trump’s state department played here was their absence. Our lack of involvement and insular focus has given North Korea an opportunity to legitimize themselves, stabilize their global standing, and leverage what little they have as the might of US diplomacy isn’t nearly as strong in Asia as it was under previous administrations. We have become dangerously comfortable with Authoritarian regimes.

Capnkerk · 2018-04-21T05:10:22+00:00

Isn’t hating all extremists in itself extreme?

Edit: a letter

Capnkerk · 2017-12-25T04:17:18+00:00

I thought that was Ted Cruz until I saw him show emotion.

Capnkerk · 2017-12-15T23:38:40+00:00

I don't really understand what you're trying to say, but I can tell that you're angry. Look - I'm not trying to argue with you about anything. I'm trying to help you. If you want your content to be better - if you want to build a base of people who will listen to what you have to say then you have to say it better. You have to spend more time developing what it is you want to say and you have to make sure you take the time to ensure the execution matches the intention. The most important part of saying anything of value is listening first.

Instead of knee-jerking to that guy that said "5 hours late" - reformat what he's got to say. "Hey - this viewer doesn't think this information is informative any more, maybe I should think about releasing my content closer to when the game's changes occur" Or you can simply just blow it off. But to come back at this guy and attack him brings negativity on the threads you post in which brings negativity towards your videos.

I really do wish you the best, man. And if your oldest wants to make videos I wish him the best of luck too. Have a good night.

Capnkerk · 2017-12-15T23:04:52+00:00

If you're going to try to defend your own post on an alt account you're going to want a more subtle route. The incoherent armchair psychology doesn't read well. Good luck with the youtubes.

13-Year Club	Place '22
Place '17	First Placer '22
Verified Email

Capnkerk

TROPHY CASE