Is there a way to make this work with https://github.com/porsager/postgres ? It's very close to raw SQL but with safe substitutions. I use it with Zod, but it would be great to have the types derived automatically.
Unfortunately I haven't found a way to make it work.
It would be quite easy to extract the queries to compute the types, but TypeScript doesn't handle tagged template literals well enough to link the query passed to the sql`` template to the return type.
A full-stack generalist with 26 years of experience.
I currently hold a position as a Software Architect at a software consultancy, but I'm not attached to the title. I can quickly prototype things on my own, making me ideal for bootstrapping startups, or I can assemble and train a team.
For the past 7 years, I've primarily been working with, and am most proficient in, TypeScript, React, React Native, iOS/Swift/ObjC, Node.js, and Postgres. I've worked with many other languages and technologies and can easily pick up new ones if needed.
Here is a list of some other languages and technologies I’ve worked with previously: C, C++, Ruby, Rails, Lua, PHP, C#, .NET, Java (J2ME), OpenGL, WebGL, Cocoa, Qt, QML, MFC, ATL, QNX, Linux/Windows device drivers, Blockchain (miner development, wallet integrations, monitoring, Solidity), etc.
Fastify is absolutely fantastic. It has the concept of "type providers", allowing you to pair it with fastify-type-provider-json-schema-to-ts (for JSON schemas) or another typing system of choice, such as Zod, to obtain strongly typed queries, request bodies, and responses in handlers with TS types derived on the fly at compile time. It also validates data returned from handlers to conform to schemas, reducing the likelihood of accidentally leaking sensitive information. And it's faster than Express, even with validation.
If the interview is structured in a way that overloads your short-term memory, which is often the case, you'll have problems remembering things from a long time ago. Ask someone questions about recent events for a few minutes, and they won't even be able to remember not only what they worked on in projects many years ago but also their grandfather's name. Everyone has this problem; it's just how memory works, and poorly structured interviews trigger this effect. A workaround is to prepare beforehand and keep a list of things to talk about nearby.
Another approach that can work is to give your memory a bit of time to adapt. For instance, if you're asked to share a story from the past and you don't have one prepared and can't recall anything, suggest starting by discussing your past in general. For example, list the projects you've worked on and briefly describe them. You will feel how, during this process, the ability to recall events returns.
I think mine were. I strained my eyes really bad over days of work, and then one day before going to sleep rubbed them. When I opened the eyes, I seen a brown clot in the middle of vision which after a month of treatment with eyedrops fell apart into lots of floaters / worms. 2 years later most of them dissolved, but some remain and vision is blurred a bit. It also turned out that most people I asked have floaters too, but if there aren't many, they're filtered out by brain. If you aren't looking for them specifically, they aren't visible. They are hard to unsee though once you seen them, so better not to try. )
Eyedrops name of which I don't remember, but I can try find if needed as they're commonly prescribed in Russia for this condition. I wouldn't recommend them though as turning a single clot into long wormy things was scary and annoying. I seen similar complaints from others who were prescribed these eyedrops. I'm not sure if they helped with dissolving the floaters, as I had smaller recurrence recently and not used any eyedrops and it's still slowly going away. Btw, if floaters are in the center, try moving the eyes up and down 10 times in succession - most of them should stick outside of vision.
I also think so. Often script needs to access a file in actual current dir (for example a config file) or process files with relative paths supplied by user and changing working dir makes this hard.
I think an easier way is to find script's location and construct paths for accessing script dependencies, for example (works on Linux & macOS):
Location: Europe (PST is also fine)
Remote: Yes
Willing to relocate: Yes
Technologies: TypeScript, React, React Native, NodeJS; Swift, ObjC, C++
Résumé/CV: Upon request
Email: afidrya81@gmail.com
Hello! My name is Andrey, I'm full-stack dev with systems programming background. Nowadays, I specialize in web app development and native apps for iOS and macOS, can adapt to your stack or do something very niche / low level (write a device driver etc). Please let me know what you're working on and I'll describe my relevant experience.
Looking to join a team as a full-time contractor on a 3+ mo project. Small teams / early stage startups preferred. Relocation is possible if needed.
reply