Cloudflare Developers•3y ago

https://developers.cloudflare.com/d1/learning/local-development/

MMatt Silverlock https://developers.cloudflare.com/d1/learning/local-development/

LeftSpace•6/2/23, 12:12 PM

thanks i made it working already!

Original message was deleted

Matt SilverlockOP•6/2/23, 6:04 PM

LIKELIKE and GLOBGLOB can use indexes - see The LIKE OptimizationThe LIKE Optimization

https://www.sqlite.org/optoverview.html

Ggotfredsen ok what is the current state regarding primary key in D1 .. is simple auto incre...

Matt SilverlockOP•6/2/23, 6:05 PM

https://developers.cloudflare.com/d1/learning/using-indexes/#create-an-index

see the note there. If you don't specify a primary key there is an implicit ROWID INTEGER PRIMARY KEYROWID INTEGER PRIMARY KEY that is used.

Ggotfredsen ok what is the current state regarding primary key in D1 .. is simple auto incre...

Matt SilverlockOP•6/2/23, 6:06 PM

If you're doing lookups by some form of UUID, then you should create an index on that column so that your WHERE order_id = ?1WHERE order_id = ?1 queries benefit from the index.

Matt SilverlockOP•6/2/23, 6:12 PM

The implicit ROWIDROWID is unique, but (per my comments above):

If you're doing lookups by some form of UUID, then you should create an index on that column so that your WHERE order_id = ?1 queries benefit from the index.

Take a look at the docs in full - you can also define a UNIQUEUNIQUE index to prevent duplicate UUIDs (which should be near impossible, but an application bug on your side could re-use the same UUID) - https://developers.cloudflare.com/d1/learning/using-indexes/#when-is-an-index-useful

Ggotfredsen may I ask how that is handled on a global scale . if two orders is placed at the...

Matt SilverlockOP•6/2/23, 6:35 PM

There is only ever one leader (writer).

OOr experimental backend is throwing "too many arguments on function JSON_OBJECT" er...

Matt SilverlockOP•6/2/23, 6:36 PM

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

it's 8 on the experimental backend. It's being upped to 32, but waiting on next week's release.

OOr experimental backend is throwing "too many arguments on function JSON_OBJECT" er...

Matt SilverlockOP•6/2/23, 6:36 PM

If you run into any other limits (we revised them all) let me know - they aren't set in stone but the original defaults were too permissive/large.

lokiwind•6/2/23, 7:12 PM

@leftspace D1 ne için kullanacaksınız?

lokiwind•6/2/23, 7:14 PM

Anlık çok sayıda veri girişi ya da çok sayıda anlık veri okumada dump yiyor haberiniz olsun anlıktan kasıt 1-2k

LeftSpace•6/2/23, 7:31 PM

just for experimental stuff

LeftSpace•6/2/23, 7:31 PM

i didn't have any issues with 1k write batch.

LeftSpace•6/2/23, 7:55 PM

@lokiwind

LLeftSpace @lokiwind

lokiwind•6/2/23, 8:05 PM

https://prnt.sc/_nho8Gck6Lc2

LeftSpace•6/2/23, 8:05 PM

what's your code?

LeftSpace•6/2/23, 8:06 PM

for write

lokiwind•6/2/23, 8:06 PM

Türkçe biliyor musun

lokiwind•6/2/23, 8:06 PM

d1-databaseBetter to post it here we can t formally

James•6/2/23, 8:17 PM

The most recent blog post during dev week mentioned there'd be more news around open beta in the coming weeks, so hopefully we'll hear more soon!

https://blog.cloudflare.com/d1-turning-it-up-to-11/#on-the-roadmap

Zzszszsz May I ask, when would the experimental backend become default ?

Max (@rozenmd)•6/3/23, 7:55 AM

i think it'll be when we announce the beta

Ggotfredsen stupid question if I´m duing a cart D1 table for security I totaly get that usin...

Max (@rozenmd)•6/3/23, 7:56 AM

in my own projects i have a kind of "hashing" function that converts internal ids (regular numbers) to youtube-like public ids

Max (@rozenmd)•6/3/23, 7:57 AM

https://hashids.org/

Zzszszsz Is it a one way function or is it revertible ?

Max (@rozenmd)•6/3/23, 9:29 AM

hashids go both ways

itsmatteomanf•6/3/23, 10:09 AM

Does D1 support ALTER TABLE RENAME COLUMNALTER TABLE RENAME COLUMN? It seems to be failing with not authorized to use function: sqlite_rename_testnot authorized to use function: sqlite_rename_test...

itsmatteomanf•6/3/23, 10:21 AM

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?

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

Yes…

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

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

https://developers.cloudflare.com/d1/learning/local-development/

Similar Threads