Please enable JavaScript.
Coggle requires JavaScript to display documents.
CLOUDFLARE D1 - Coggle Diagram
CLOUDFLARE D1
USE INDEXES
-
Indexes will add an additional written row when writes include the indexed column, as there are two rows written: one to the table itself, and one to the index. The performance benefit of an index and reduction in rows read will, in nearly all cases, offset this additional write.
email addresses, usernames, user IDs and/or dates are good choices for columns to index in typical web applications or services
Tables that use the default primary key (an INTEGER based ROWID), or that define their own INTEGER PRIMARY KEY, do not need to create an index for that column.
A common naming format for indexes is idx_TABLE_NAME_COLUMN_NAMES, so that you can identify the table and column(s) your indexes are for when managing your database.
-
The wrangler command-line interface is Cloudflare’s tool for managing and deploying Workers applications and D1 databases in your terminal.
-
-
-
-
D1 is built on SQLite, has built-in JSON parsing and querying functions with support for full-text search triggers.