Results 591 comments of Stephen Haberman

A good approach for diagnosis might be: * Load up the problematic query (i.e. revert the fix that moved to `ReactiveQueryField`s, and go back to just `ReactiveField`s) * Add instrumentation...

An example of why this is a problem, from one of our CSV uploads: - We upload ~300 TLIs - Each TLI calculates its `TLI.roomRpl -> ReadyPlanLocation` derived field -...

:tada: This issue has been resolved in version 1.234.2 :tada: The release is available on: - `v1.234.2` - [GitHub release](https://github.com/joist-orm/joist-orm/releases/tag/v1.234.2) Your **[semantic-release](https://github.com/semantic-release/semantic-release)** bot :package::rocket:

Maybe something like: ```ts const fs = require("fs/promises"); const path = require("path"); module.exports = { name: "fast-joist-rewrite", setup(build) { build.onLoad({ filter: /\.ts$/ }, async (args) => { let source =...

Hi @skycrazyk ; I'm not sure what the issue is here; this github comment: https://github.com/microsoft/TypeScript/issues/5711#issuecomment-157793294 Insinuates that adding an import of `MessageFns` to `clients.ts` will fix things. Can you try...

An initial fix of this issue tried to use `LATERAL JOIN`s that would: * `CROSS JOIN LATERAL` into child1 * Use an aggregate query like `count(*) as _` to ensure...

What we want to ensure is that, within the query's complex condition, any child alias is "consistently evaluated", i.e. given rows like: * `books id=b:1 title=b1 notes=b1` * `books id=b:2...

Also an example of why CTEs might perform better than `CROSS JOIN LATERAL`s: ```sql -- 360ms (execution 84 ms, fetching 273 ms) select a. * from approvals as a cross...

This is problematic query from our production app: ```sql select b.* from bills as b inner join project_stages as ps on b.project_stage_id = ps.id inner join projects as p on...

Fundamentally, the `BOOL_OR` approach represents an "any child" / "fuzzy child" match. And if we end up with `WHERE` clauses like: * `(any child) OR (any child)` ==> this is...