AlexErrant Comments - Answer Overflow

AlexErrant

Explore posts from servers

CDCloudflare Developers SSolidJS KKysely

Posts Comments

SSolidJS

•Created by Misery on 8/26/2024 in #support

`ReferenceError: jQuery is not defined`

use clientOnly https://docs.solidjs.com/solid-start/reference/client/client-only

8 replies

SSolidJS

•Created by Hussein on 8/22/2024 in #support

isDev is false in dev

honestly I just use Vite for this; import.meta.env.DEV

5 replies

SSolidJS

•Created by Industrial on 8/25/2024 in #support

Using WASM in Solid(Start)

My proj (https://github.com/AlexErrant/Pentive/) has no problem with https://github.com/rhashimoto/wa-sqlite or https://github.com/open-spaced-repetition/fsrs-browser, the latter of which I built with wasm-bindgen. If you want a minimal project check out the sandbox of that project which is in Solid https://github.com/open-spaced-repetition/fsrs-browser/tree/main/sandbox . To be clear, I've not yet tried running WASM in solid start (or on the server) all my experience is with client-side wasm

10 replies

SSolidJS

•Created by Hussein on 8/22/2024 in #support

Race condition

@Hussein can you retry with

    throw redirect("/", { revalidate: "someWords" });

    throw redirect("/", { revalidate: "someWords" });

if your action is using SingleFlightMutations I've been noticing cookies don't get used on the rendered response

9 replies

CDCloudflare Developers

•Created by AlexErrant on 8/14/2024 in #pages-help

Solid's `clientOnly` only works with "Development Mode" enabled [solved]

I'm guessing SolidStart was using something that got minified away >_> probably hydration markers or something

4 replies

CDCloudflare Developers

•Created by AlexErrant on 8/14/2024 in #pages-help

Solid's `clientOnly` only works with "Development Mode" enabled [solved]

Wow, that was it; thank you!!! No idea why minification would screw everything up, but I'm just so glad to find a solution after debugging for 2 days now 😭

4 replies

KKysely

•Created by oof2win2 on 5/15/2024 in #help

Update on conflict clause

insert works for me on sqlite, what does your update stmnt look like https://github.com/AlexErrant/Pentive/blob/0d3dc078952176a4cdbdeeb45253719f191eea43/app/src/sqlite/card.ts#L404-L410

4 replies

KKysely

•Created by AlexErrant on 3/11/2024 in #help

Is `sql.join` the best way to concatenate sql templates?

To be clear, the generated SQL is parameterized:

SELECT
  "id",
  "first_name"
FROM
  "person"
WHERE
  noteFtsFv.rowid NOT IN (
    SELECT
      rowid
    FROM
      noteFtsFv
    WHERE
      noteFtsFv.fieldValues MATCH $1
  )
  AND $2

SELECT
  "id",
  "first_name"
FROM
  "person"
WHERE
  noteFtsFv.rowid NOT IN (
    SELECT
      rowid
    FROM
      noteFtsFv
    WHERE
      noteFtsFv.fieldValues MATCH $1
  )
  AND $2

https://kyse.link/gpJdB The SQL that I write will go into sql.raw. User queries go into the array as-is and are parameterized. I'm building a feature similar to Github's search syntax. https://gist.github.com/bonniss/4f0de4f599708c5268134225dda003e0 I've built the grammar and now I'm walking the syntax tree and incrementally building the SQL. My grammar has support for grouping, e.g. (X and Y) or (Z and Y). While it is possible to have Kysely to group WHERE clauses like the above... it isn't as easy to do in an incremental fashion. With strings, if I see a "Group" syntax node, I stringconcat a (, recursively call myself on the children, then concat ). Easy. With Kysely, I'd have to walk the group's children to find out if the contents are "AND" or "OR" and I just don't wanna do that 😅 Relevant code if you care https://github.com/AlexErrant/Pentive/blob/b6aaaba608483c66988351fc033581e0abe482ec/shared-dom/src/language/query2sql.ts#L70-L98 Feel free to ignore this paragraph just justifying my laziness 😅

8 replies

SSolidJS

•Created by Tommypop on 4/29/2023 in #support

Google Oauth in Solid: Best Practices

I used the github provider because google's Oauth is a huge PITA... at least initially for someone without a trademark lol

7 replies

SSolidJS

•Created by Tommypop on 4/29/2023 in #support

Google Oauth in Solid: Best Practices

some code to get you started https://github.com/AlexErrant/Pentive/blob/main/hub/src/routes/api/auth/%5B...solidAuth%5D.ts

7 replies

SSolidJS

•Created by Tommypop on 4/29/2023 in #support

Google Oauth in Solid: Best Practices

I tried using Auth.js's Solid adapter https://authjs.dev/ and it worked pretty well initially. However eventually it no longer met my business requirements (I want to set the set the User's primary key instead of it being autogenned) and they rejected my PR adding that feature, so I moved to oauth4webapi.

7 replies

SSolidJS

•Created by romanobro on 3/5/2023 in #support

with-auth unused export

yeah I guess its one caller got refactored out...?

2 replies

SSolidJS

•Created by jesseb34r on 3/9/2023 in #support

Redirect to current location from createServerAction$()

you can put it in a query param or a hidden form field

7 replies

Gaming

Programming