AnyhowStep

Results 105 comments of AnyhowStep
trafficstars

https://www.reddit.com/r/SQL/comments/fd8zij/when_have_you_used_numericdecimal_and_how_often/

So, if we have a `LIMIT` clause, just... wrap it inside another query

I can only assume SQLite thinks a parenthesized subquery is a scalar value, even if it fetches more than one row.

Hey, @phiresky , it's been a long time but I wanted to update you. https://anyhowstep.github.io/tsql-sqlite3-browser/test-playground/public/ I don't have an integration with better-sqlite3 yet. BUT! I have a Playground that runs...

That's a good question, actually. So, there are two kinds of SQL strings one can get. + SQL string (fast-ish to build) + Prettified SQL string (slow-ish to build) Internally,...

If you have more questions, fire away! I need to write documentation and all that other "fun" stuff

All right, if you go to the [Playground](https://anyhowstep.github.io/tsql-sqlite3-browser/test-playground/public/) again and hit the "Reset" button, you should see this in the TS editor, ```ts //Slower performance but pretty output. //See sqlite3.toSql()...

If you clone this repo, `npm install` and look at the `test/compile-time` directory, you should see that this library protects you from a large class of errors, and also does...

A sample from the compile time tests, https://github.com/AnyhowStep/tsql/blob/master/test/compile-time/input/unified-query/inner-join/cannot-reference-outer-query-joins-in-on-clause.ts And the expected compiler error from TS 3.5.1 https://github.com/AnyhowStep/tsql/blob/master/test/compile-time/expected-output/unified-query/inner-join/cannot-reference-outer-query-joins-in-on-clause.ts.errors > messageText": "Property '__compileError' is missing in type 'ExprImpl' but required in type...

I'll worry about public relations like type-safety evangelism when I feel like I have a more solid offering =P I try to be aware of burnout and switch between different...