HN user

damidekronik

140 karma
Posts0
Comments46
View on HN
No posts found.
Malleable Software 11 months ago

So we need to create tools with very high flexibility, not-so-fantastic onboarding that take a long time to setup and hard to get right - so that AI can fix them? I would rather use Linear (as per example).

Prisma doesn't cover plenty of SQL features. custom types, more complex indexes (like where clause). It is also a VC backed biznes, need to be ready to drop it at almost any time, SQL/postgres on the other hand is here to stay.

RLS is hard to work with, hard to debug, hard to reason about, cumbersome. It is however powerful.

I am using both prisma and kysely in the same codebase with a great success. The db schema is driven by SQL, not prisma. It is then introspected by both kysely and prisma, prisma is used in 95% of the places while kysely is used whenever performance is critical or when prisma doesn't support the SQL features we need.

"The obsessive need for AI developers (...)" - Of product product/business people trying to fit into the "AI era". Developers, if given a chance, wouldn't probably built this.

As someone interested in the gaming sector but with a web dev/full stack experience this seems like an amazing offer. It is however a shame you are not disclosing the salary range. I am not willing spend several hours on the interviweing process just to get to know what you are offering.

From this year's Iq:

Botany: Jacob White and Felipe Yamashita, for finding that certain plants imitate the leaf shape of nearby plastic plants and concluding that "plant vision" is plausible.

This somehow doesn't fit the Iq award in my mind.

I think a nicer takeaway is what the author summarized with:

1. Always use BUFFERS when running an EXPLAIN. It gives some data that may be crucial for the investigation.

2. Always, always try to get an Index Cond (called Index range scan in MySQL) instead of a Filter.

3. Always, always, always assume PostgreSQL and MySQL will behave differently. Because they do.

I am using the Pro version, "MacBook Pro M2 24GB 13-inch 2022". Backend and frontend mostly, several docker containers running constantly, several chrome and firefox instances with about 10s of tabs opened, DB tools (pgAdmin etc). All of this works great, battery life ~5 hours when doing heavy work, fans very very rarerly turning on, maybe few times over the last 10 months I was using it.

One issue I experience is that "Virtual Machine Service for Docker" is consistently sitting at 6gb ram. I am running in "linux/amd64" mode as I had some compatibility issues.

Another issue is that for some reason WebStorm sometimes works much worse than on linux which I used before the mac. As if WebStorm completely turns off some features (highlight, typechecking...) from time to time.

Just a note to anyone considering using PDFs for their CVs. Plenty of companies use Applicant Tracking Software (ATS) to manage recruitment process. Most often keywords are extracted from the CVs. PDFs are harder to extract from meaning you might not even be considered (or even ever seen) by a recruiter due to a far from perfect implementation. Of course the case here is different all together but maybe this insight will save someone's a fair bit of frustration.