You should also be able to do `.schema my_table`, but it returns a syntax error, at least in the con

You should also be able to do

.schema my_table

.schema my_table

, but it returns a syntax error, at least in the console.

lokiwind•6/3/23, 10:35 AM

Hello.
I created a table. And this table will have three headers
key-time-value
a key will be recorded in this table as follows:
TESTKEY123-00:00:30-0
Is it possible to make the time value automatically change the value value to 1 after 30 seconds

lokiwind•6/3/23, 10:37 AM

After 30 seconds, the line will look like this.
TESTKEY123-00:00:00-1

MMatt Silverlock If you run into any other limits (we revised them all) let me know - they aren't...

Jason Hostetter•6/3/23, 11:25 AM

Are there any plans to increase the maximum expression depth of 20? I am refactoring to try and get around that limit but will wait if it’s going to change

Iitsmatteomanf You should also be able to do `.schema my_table`, but it returns a syntax error,...

Max (@rozenmd)•6/3/23, 2:20 PM

console as in the dashboard console?

MMax (@rozenmd)console as in the dashboard console?

Max (@rozenmd)•6/3/23, 2:20 PM

if so I can add it

MMax (@rozenmd)console as in the dashboard console?

itsmatteomanfOP•6/3/23, 2:20 PM

Yes…

itsmatteomanfOP•6/3/23, 2:20 PM

Not sure how that would work in the JS API given the weird formatting of the result.

Iitsmatteomanf Yes…

Max (@rozenmd)•6/3/23, 2:21 PM

(i want to add the same console into wrangler)

MMax (@rozenmd)(i want to add the same console into wrangler)

itsmatteomanfOP•6/3/23, 2:21 PM

That’s be nice, especially if you need to copy things.

Iitsmatteomanf Does D1 support `ALTER TABLE RENAME COLUMN`? It seems to be failing with `not au...

itsmatteomanfOP•6/3/23, 2:23 PM

I 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

Iitsmatteomanf I think you missed this, @rozenmd 🙂 that’s the bigger issue, but I’m not sure w...

Max (@rozenmd)•6/3/23, 2:24 PM

might be another function we didn't whitelist, do you mind adding an issue to workerd?

MMax (@rozenmd)might be another function we didn't whitelist, do you mind adding an issue to wo...

itsmatteomanfOP•6/3/23, 2:24 PM

Will do

Iitsmatteomanf Will do 🙂

itsmatteomanfOP•6/3/23, 2:32 PM

Done, https://github.com/cloudflare/workerd/issues/729

GitHub

🐛 Bug Report — Runtime APIs: : D1 Does Not Allow `ALTER TABLE RENAM...

The Experimental Backend doesn't allow using ALTER TABLE RENAME COLUMN which should be supported in latest SQLite.

Iitsmatteomanf Done, https://github.com/cloudflare/workerd/issues/729

Matt Silverlock•6/3/23, 3:18 PM

d1-database

MMatt Silverlock https://discord.com/channels/595317990191398933/992060581832032316/1109973517182...

itsmatteomanfOP•6/3/23, 3:18 PM

Oh, sorry… I tried searching, but resulted in nothing NotLikeThis

itsmatteomanfOP•6/3/23, 3:19 PM

Discord search is so bad

Llokiwind Hello. I created a table. And this table will have three headers **key-time-va...

lokiwind•6/3/23, 3:36 PM

I need some help with this. MeowHeartCloudflare

Llokiwind I need some help with this. <:MeowHeartCloudflare:897193652089155645> 🤔

itsmatteomanfOP•6/3/23, 3:36 PM

In which sense "automatically" change?

lokiwind•6/3/23, 3:37 PM

I want a saved data to update itself after 30 seconds

itsmatteomanfOP•6/3/23, 3:38 PM

Oh yeah, then that's not possible.

itsmatteomanfOP•6/3/23, 3:38 PM

You need to do a query to update it.

itsmatteomanfOP•6/3/23, 3:38 PM

It's SQLite after all...

lokiwind•6/3/23, 3:39 PM

How can I make a query for this?
Can you give advice

lokiwind•6/3/23, 3:41 PM

The time of recording the data are all different from each other

lokiwind•6/3/23, 3:41 PM

When I send a request every 30 seconds this will not work some data will change earlier

Zzszszsz I don't understand the problem. And I don't understand why.

lokiwind•6/3/23, 3:43 PM

Are you talking to me?

Llokiwind After 30 seconds, the line will look like this. **TESTKEY123-00:00:00-1**

lokiwind•6/3/23, 3:44 PM

I explained in detail here

lokiwind•6/3/23, 3:47 PM

I will explain in a simple way

lokiwind•6/3/23, 3:48 PM

Let's say I saved data with a value of 1 in a table with D1

lokiwind•6/3/23, 3:49 PM

I want this 1 value to be updated to 0 after 30 seconds

lokiwind•6/3/23, 3:50 PM

Required for my project

lokiwind•6/3/23, 3:50 PM

To set a key time

lokiwind•6/3/23, 3:51 PM

I just want to replace the expired value, that's all.

lokiwind•6/3/23, 3:53 PM

Hmm

lokiwind•6/3/23, 3:54 PM

Thank you, I will try

Zzszszsz hmm is it really what you want ?

lokiwind•6/3/23, 4:06 PM

If he can do what I want him to do.

yeehow•6/3/23, 5:16 PM

Running into this error (using Drizzle ORM)

Error: D1_ERROR
    at D1Database._send (index.js:2874:13)
    at async D1PreparedStatement.raw (index.js:2945:7)
    at async PreparedQuery2.all (index.js:2367:18)
    at async index.js:2761:18
    at async Object.handle [as fetch] (index.js:21:30) {
  stack: Error: D1_ERROR
    at D1Database._send (index.js:…t async Object.handle [as fetch] (index.js:21:30),
  message: D1_ERROR,
  cause: Error: Error: too many arguments on function json_array
    at D1Database._send (index.js:2875:16)
…
}

Error: D1_ERROR
    at D1Database._send (index.js:2874:13)
    at async D1PreparedStatement.raw (index.js:2945:7)
    at async PreparedQuery2.all (index.js:2367:18)
    at async index.js:2761:18
    at async Object.handle [as fetch] (index.js:21:30) {
  stack: Error: D1_ERROR
    at D1Database._send (index.js:…t async Object.handle [as fetch] (index.js:21:30),
  message: D1_ERROR,
  cause: Error: Error: too many arguments on function json_array
    at D1Database._send (index.js:2875:16)
…
}

Works fine when running locally, but gives this error when running remotely or deployed.

Leads me to believe D1 has a lower json_array()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

Yyeehow Running into this error (using Drizzle ORM) ``` Error: D1_ERROR at D1Databas...

Matt Silverlock•6/3/23, 5:21 PM

https://developers.cloudflare.com/d1/platform/limits/

(Function arguments are being bumped to 32 in the next week)

Limits · Cloudflare D1 docs

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 …

hanpolo•6/3/23, 6:28 PM

I 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?

Error: D1_ERROR at D1Database._send (index.js:2874:13) at async D1PreparedStatement.raw (index.js:2945:7) at async PreparedQuery2.all (index.js:2367:18) at async index.js:2761:18 at async Object.handle [as fetch] (index.js:21:30) { stack: Error: D1_ERROR at D1Database._send (index.js:…t async Object.handle [as fetch] (index.js:21:30), message: D1_ERROR, cause: Error: Error: too many arguments on function json_array at D1Database._send (index.js:2875:16) … }

You should also be able to do `.schema my_table`, but it returns a syntax error, at least in the con

Similar Threads