3 ms·
I recently built a search engine backend for our rock climbing database. Web dev is new to me (I'm an iOS dev primarily). From all the stuff I've read on hn I c
by fatboy 4y ago
I recently built a search engine backend for our rock climbing database. Web dev is new to me (I'm an iOS dev primarily). From all the stuff I've read on hn I chose to write a typescript api that uses Zapatos to interface with a postgres db and I could not be happier with it (for the most part - node errors can be vague and disconnected due to async/await but perhaps I've not figured that part out yet).
Writing typescript is a real pleasure once I figured out the incantations necessary for the tsconfig and package.json files, and Zapatos allows pretty elegant composition of sql fragments that can all be typesafe and injection proof. The way Zapatos can type the return of complex sql seems like magic.
As an outsider I'd say im a fan of what I've seen of the current js ecosystem, although I'm only talking backend stuff, no idea about frontend.
- wunderlust 4y ago> a search engine backend for our rock climbing database Sounds cool! I code (hobby/fun/learning/career prep) but am really more interested in the world outside of computers (inc. some climbing). I'd love to talk if there are any opportunities with UKC! (I should mention I'm US based and have experience mainly with Python but some Javascript, too.)
- fatboy 4y agoWe're not hiring at the moment I'm afraid, and I suspect a US candidate probably wouldn't be considered due to the time zone difference.
- wunderlust 4y agoFair enough!
- cpursley 4y agoDepending on your search requirements, you may be able to manage what you need with just Postgres and JS as an interface. Postgres is seriously awesome. https://gist.github.com/cpursley/e3586382c3a42c54ca7f5fef1665be7b https://gist.github.com/cpursley/e3586382c3a42c54ca7f5fef166... (some maybe useful links at the bottom)
- fatboy 4y agoHey thanks I'll take a look at that.
- eurasiantiger 4y agoHow much data do you have in terms of number of entities and raw bytes?