Also noticing workers sets Date.now() to something like 1695750600382 while D1 sets unixepoch('now')
Also noticing workers sets Date.now() to something like 1695750600382 while D1 sets unixepoch('now') to 1695750600
IDate.now() is in ms, SQLite is in secs.
Cwondering if that would make sense if they were more aligned to both either be in ms or secs?
IIt might, but that would deviate from SQLite behavior, which I doubt they'd want to do.
IIt would mean every time someone imported a SQLite database the user would need to know to convert manually.
Ctrue
Cperhaps the D1 wizzards could deviate slightly and created a new unixepoch function ie, unixepochD1
Cthat would use ms, given the environment its used in
Cidk maybe its a silly idea
Ci am going to set time_stamp_updated INTEGER DEFAULT (unixepoch('now') * 1000) to aleviate confusion
Mtimestamp_updated_ms - give your names units
Chow would one define that...? I tried time_stamp_updated INTEGER DEFAULT (timestamp_updated_ms('now')) AND time_stamp_updated INTEGER DEFAULT timestamp_updated_ms
Cbut no success
Cor are you just saying label it with the expected units?
M^ that. Give your column the name of the units it contains. Not a requirement - just a tip
Cgot it! I just set it via: time_stamp_updated INTEGER DEFAULT (unixepoch('now') * 1000)
Cto normalize things which works for mee
Cbut that said, if setting time_stamp_updated INTEGER DEFAULT CURRENT_TIMESTAMP, i think wrangle should flag that as an error
Cwith 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
wrangler could check for that when the following line is executed:
wrangler d1 execute <DB_NAME> --file=dbtablecreate.sql
Cwrangler could check for that when the following line is executed:
wrangler d1 execute <DB_NAME> --file=dbtablecreate.sql
wrangler d1 execute <DB_NAME> --file=dbtablecreate.sql
Chttps://developers.cloudflare.com/vectorize/ seeing this in the realease notes (3.10)...but its a dead link
MWhich specific math functions?
MMGitHub
The JavaScript / Wasm runtime that powers Cloudflare Workers - cloudflare/workerd
KHave you actually used
COS (i.e all caps) or cos?KHmm.
KI might just be blind, but I don't see anything in workerd indicating that it even has the maths functions enabled.
K
EHey 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?
SSQLite 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
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
SMay 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
.
.
UAfaik theres never been data loss with D1 and I doubt there will be any
SThat's great to hear!May I know when the official version will be released?
UTheres no GA release date it will come eventually
JHello 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?
J
JYeah I was using script-format workers, whoops
ECongrats to the team for all the hard work they've put in getting D1 to beta status! 
MThe Cloudflare Blog
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
M
MD1 is now in public beta, and storage limits have been increased:
- Developers with a Workers paid plan now have a 2 GB per-database limit (up from 500MB) and can create 50,000 databases per account (up from 10). These limits will continue to increase automatically during the public beta.
- Developers with a Workers free plan retain the 500 MB per-database limit and can create up to 10 databases per account.Databases must be using D1's [new storage subsystem](/d1/changelog/#new-default-storage-subsystem) to benefit from the increased database limits. See the announcement blog for more details about what's new in the beta and what's coming in the future for D1.
WHi, need some help guys, new dev here so let me know if I am posting to the wrong channel. I am running wrangler d1 migrations in postCommands after deployment which gives an error but it used to work just fine in the preCommands of the "yml" file. Now, I am getting the error "non-zero exit code"
EIs support for a large number of d1 instances going to be solely tied to Workers for Platforms users (which needs ent contract), or is it something which would be generally available?
MWe can increase on a case-by-case basis. We intend to substantially increase the # of databases per account (per the blog) during the beta period as well.
MAt "100k databases" there are other things that make you want to use WfP in terms of how many bindings you can have per script, how you are managing user scripts, etc.
