Yeah my bad. Saw that in the docs a few minutes after I sent it...
Yeah my bad. Saw that in the docs a few minutes after I sent it...
ZNo problem, still thanks for looking
Gwhy am i getting this error??
i thought booleans get converted to D1 integers 1 or 0?
"Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'"i thought booleans get converted to D1 integers 1 or 0?
KDocumentation seems to imply it should, but it isn't.
Kresults.error isn't really a thingKyou need to
try/catch the .all()What is the issue you're having with the code?
KWhich part in particular isn't working
KWhat part of your retry logic doesn't work though, which line do you get to before it fails?
KI meant the retry logic, I can't help with the D1 error itself.
KshouldRetry checking error.name is wrong because error.name will just be Error
AI have found a bug with D1 table web view,
the column data for
The output from the
the column data for
namestock_code in the table web view.The output from the
select * query is correct
ANot critical stuff, but it confused me for 5 mins
Mcan you provide a schema that repros the issue?
Ahmmm, i tried to reproduce but couldn't, weird
AI’m getting sometimes a latency of more than 3000 ms when querying my D1 database from a worker
AIt looks like a cold start because it does not happen on subsequent requests
AIs that normal ? Or may get better as the beta progresses ?
AMy query is something like SELECT * FROM products WHERE primary_key = ?
ANo I take Date now() before and after the query
CWhat does the meta of the D1 result give for timing?
DHeyo, I'm having an issue where the sql command I execute on console works but on the code it doesn't
DOn console working
DOn code, this returns nothing
CIs this running locally via wrangler dev? If so then wrangler dev doesn't use the remote resources like the D1 database. You can run your worker with
--remoteI'm running with dev --remote
DI double checked that, not making the same mistake again xD
DI tried deploying and using the deployed URL and nothing either
DOh
DLet me try that
DThis did it, thanks! Much appreciated
Kwill doing this result in sql injection if data is supplied by user and not sanitizing the data?
<What would be the easiest way to test queries on D1? I'm trying to figure out how to use the json queries, but it feels like updating a worker to be able to "evaluate" a query is a little sub-par. Is there anything like the typical db management app/service, like DB Browser for SQLite, phpmyadmin, pgadmin, etc?
<<Ah, the console didn't show more than the
/help commands and such, so it's not clear that queries can be made here
<I was already developing the worker locally (so not deploying changes) but it still felt sort of odd to be dealing with code this way rather than to have some actual DB interface.