are you sure the way Standard SQL lite does thing behind the scenes i the same as how D1 does it? I don't think its always a 1 to 1 situation...only the cloudflare wizards would know what lies beyond the veil
how would one define that...? I tried time_stamp_updated INTEGER DEFAULT (timestamp_updated_ms('now')) AND time_stamp_updated INTEGER DEFAULT timestamp_updated_ms
with type mismatch of some sort given CURRENT_TIMESTAMP will save a non integer result wrangler could check for that when the following line is executed: wrangler d1 execute <DB_NAME> --file=dbtablecreate.sql
Hey guys, I was wondering - is there any actual uptime or analytics for the D1 database? On the cloudflarestatus.com website, there's no status for D1 specifically but there are Workers and Durable Objects (I believe D1 is based on them). Is it safe to assume that D1 uptime is basically the same as DO/Workers?
SQLite is very loose on data types (by default), and won't complain if you put the wrong thing in a given column. To make it more strict you can use: https://www.sqlite.org/stricttables.html And then on the date/times, you can get a more precise time (sub second) and a human readable ISO form with:
The DATETIME isn't a specific Sqlite datatype, but it distinguishes it from TEXT. Also if you're setting the value from Javascript, use the Date.toISOString(). More info on the SQLite handling of dates/times: https://www.sqlite.org/lang_datefunc.html
May I know when the official version will be released? I am eagerly looking forward to using D1 for my personal project. As long as the subsequent updates do not result in data loss, I am okay with it.
Hello all, when I try to deploy/test my worker it says 'D1 bindings require module-format workers. [code: 10021]'. Could someone pls explain what this means? Am I missing a node module?
D1 is now in open beta, and the theme is “scale”: with higher per-database storage limits and the ability to create more databases, we’re unlocking the ability for developers to build production-scale applications on D1