console as in the dashboard console?
console as in the dashboard console?
Mif so I can add it
IYes…
INot sure how that would work in the JS API given the weird formatting of the result.
M(i want to add the same console into wrangler)
IThat’s be nice, especially if you need to copy things.
II think you missed this, @rozenmd 
that’s the bigger issue, but I’m not sure what’s the version of SQLite that D1 is based upon
that’s the bigger issue, but I’m not sure what’s the version of SQLite that D1 is based uponMmight be another function we didn't whitelist, do you mind adding an issue to workerd?
IGitHub
The Experimental Backend doesn't allow using ALTER TABLE RENAME COLUMN which should be supported in latest SQLite.
IOh, sorry… I tried searching, but resulted in nothing 
IDiscord search is so bad 
LI need some help with this. 
IIn which sense "automatically" change?
LI want a saved data to update itself after 30 seconds
IOh yeah, then that's not possible.
IYou need to do a query to update it.
IIt's SQLite after all...
LHow can I make a query for this?
Can you give advice
Can you give advice
LThe time of recording the data are all different from each other
LWhen I send a request every 30 seconds this will not work some data will change earlier
LAre you talking to me?
LI explained in detail here
LI will explain in a simple way
LLet's say I saved data with a value of 1 in a table with D1
LI want this 1 value to be updated to 0 after 30 seconds
LRequired for my project
LTo set a key time
LI just want to replace the expired value, that's all.
LHmm
LThank you, I will try
LIf he can do what I want him to do.
YRunning into this error (using Drizzle ORM)
Works fine when running locally, but gives this error when running remotely or deployed.
Leads me to believe D1 has a lower
From my testing it seams to only work with up to 8 arguments.
Just a theory. Don't really know what I'm doing
Works fine when running locally, but gives this error when running remotely or deployed.
Leads me to believe D1 has a lower
json_array() argument limit than standard SQLite?From my testing it seams to only work with up to 8 arguments.
Just a theory. Don't really know what I'm doing
Mhttps://developers.cloudflare.com/d1/platform/limits/
(Function arguments are being bumped to 32 in the next week)
(Function arguments are being bumped to 32 in the next week)
Many of these limits will increase during D1’s public alpha. Join the #d1-open-alpha channel in the Cloudflare Developer Discord to keep up to date …
HI have upgraded to wrangler 3.0.1 and my previously persisted database no longer works. The error I get is that tables I created in the persisted database are not present. I ran my migrations again and noticed that two databases were created under .wrangler/state/v3/d1/<some random string> & .wrangler/state/v3/d1/my_d1 with the <some random string> database having the tables and my_d1 being empty. But even after this, when I tried accessing the database I got the same error. I did notice a line when wrangler initialized : "my_d1: local-my_d1 (my_d1)." Any ideas on what I have to do to get back to my database?
YSomeone how missed this... Great to hear thank you!
MWrangler 3 changed the location and format of persisted data - if you search this channel you’ll find a couple of others talking about it. Do you need the local data for some reason?
HNope, don't need the old data .. just need to be able to access local data ..
HI'll search some more
