Does this support prepared statements? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Aries

A

AriesOP•9/4/23, 8:02 AM

I cannot seem to find any references.

Aries

AAries Does this support prepared statements?

itsmatteomanf

I

itsmatteomanf•9/4/23, 8:03 AM

In the sense that you save them prior to calling them or you do pepare them in your code prior to sending them, and then call them directly like D1 does?

itsmatteomanf

Iitsmatteomanf In the sense that you save them prior to calling them or you do pepare them in y...

Aries

A

AriesOP•9/4/23, 8:04 AM

To prevent SQL injection, where you can pass values seperately from the query.

Aries

AAries To prevent SQL injection, where you can pass values seperately from the query.

itsmatteomanf

I

itsmatteomanf•9/4/23, 8:05 AM

Yeah, then no, it's a REST api, there is no direct binding for querying it.
https://developers.cloudflare.com/analytics/analytics-engine/worker-querying/#worker-script

Aries

A

AriesOP•9/4/23, 8:05 AM

It would be nice if the REST API accepted a body like {sql: string, values: string}{sql: string, values: string} so that wouldn't be an issue.

Aries

A

AriesOP•9/4/23, 8:09 AM

https://files.aries.fyi/2023/09/04/Code_6e32d17f8bd23031.png

Aries

A

AriesOP•9/4/23, 8:10 AM

https://files.aries.fyi/2023/09/04/Code_3490596e08bdb62c.png

riskiidrus

R

riskiidrus•9/5/23, 5:03 AM

Hi, can I know how long my and my customers' analytics data is stored?

I just want to make sure that the data can still be accessed for a long time.

Erisa

E

Erisa•9/5/23, 5:34 AM

3 months at the moment https://developers.cloudflare.com/analytics/analytics-engine/get-started/#data-retention

Aries

A

AriesOP•9/6/23, 12:23 AM

why does

(intDiv(toUInt32(timestamp), 120) * 120) * 1000 as x

(intDiv(toUInt32(timestamp), 120) * 120) * 1000 as x

end up as a string?

Aries

A

AriesOP•9/6/23, 12:23 AM

https://files.aries.fyi/2023/09/05/Code_f04483f7b576c9d4.png

Aries

A

AriesOP•9/6/23, 12:41 AM

same with toUnixTimestamp(timestamp) * 1000toUnixTimestamp(timestamp) * 1000

Aries

A

AriesOP•9/6/23, 12:42 AM

I assume because it doesn't fit in a 32int but still, pretty weird.

Original message was deleted

Aries

A

AriesOP•9/6/23, 12:47 AM

?? 16938009000001693800900000 is a perfectly valid js number.

Unsmart

U

Unsmart•9/6/23, 12:48 AM

A Uint64 can contain more precise numbers than js numbers can though so all the Uint64 will be string and you can look at meta for the type

Aries

A

AriesOP•9/6/23, 12:57 AM

I suppose that's true.

miki / 46bit

Mmiki / 46bit We discussed a few times what to do in our SQL API - it's safest to pass through...

Aries

A

AriesOP•9/6/23, 9:09 PM

It looks like it's configurable in Clickhouse? https://github.com/ClickHouse/ClickHouse/issues/114#issuecomment-251463427

GitHub

JSON UInt64 as string · Issue #114 · ClickHouse/ClickHouse

Is there a reason why Int64 and UInt64 are output as string in JSON? :) select toUInt64(1) as n format JSONEachRow; {"n":"1"} :) select toUInt32(1) as n format JSONEachRow; {&qu...

Aries

A

AriesOP•9/11/23, 1:09 AM

Are these functions planned to be supported?
https://clickhouse.com/docs/en/sql-reference/functions/rounding-functions

Rounding Functions | ClickHouse Docs

floor(x[, N])

vikasaditya

V

vikasaditya•10/3/23, 1:56 PM

I am getting error

 Input was invalid: cannot combine the DateTime and String types with the >= operator: "timestamp" >= '2023-03-01 00:00:00'

 Input was invalid: cannot combine the DateTime and String types with the >= operator: "timestamp" >= '2023-03-01 00:00:00'

when trying the billing query given at https://developers.cloudflare.com/analytics/analytics-engine/recipes/usage-based-billing-for-your-saas-product/

Usage-based billing for your SaaS product · Cloudflare Analytics docs

Many Cloudflare customers run software-as-a-service products with multiple customers. A big concern for such companies is understanding the cost of …

vikasaditya

V

vikasaditya•10/3/23, 1:57 PM

while

WHERE timestamp > NOW() - INTERVAL '7' DAY

WHERE timestamp > NOW() - INTERVAL '7' DAY

works

vikasaditya

V

vikasaditya•10/4/23, 5:48 AM

yes, that worked. Also docs don't say that table name is CASE sensitive and show that in lower case where as upper case in bindings. And the query doesn't give any error, actually returns a response with meta filled but data blank with row 0.

zegevlier

Z

zegevlier•10/11/23, 1:43 PM

analytics-engine This is the latest news we have afaik

MarkB

M

MarkB•10/12/23, 7:15 AM

hi, I added site and transferred domain to cloudflare successfully, but overview page is empty, please let me know how I can see analytics on overview tab

jimh

Jjimh They should appear once you have some traffic on your site. It might take a few ...

MarkB

M

MarkB•10/12/23, 11:01 AM

it needs 24 hours to show it? I transferred domain to cloudflare almost 12 hours ago

bour

Bbour Hi. How to delete data? I tried DELETE sql statement, but it is not supported

John Spurlock

J

John Spurlock•10/22/23, 3:16 PM

you can't - it will expire after 93 days

bour

Bbour Any plans to support it?

John Spurlock

J

John Spurlock•10/22/23, 3:30 PM

from what they've said, I don't think so - although I would personally think they would have to before going GA/charging for it etc - also a TTL or auto-thinning would be nice!

analytics-engine

Cezar Sampao

C

Cezar Sampao•10/24/23, 2:30 PM

Hey guys, I was going through some past conversation here regarding writeDataPointwriteDataPoint and waitUntilwaitUntil. It's not clear to me if I need to call waitUntilwaitUntil and wrap writeDataPointwriteDataPoint into a PromisePromise.

Does writeDataPointwriteDataPoint affect or add latency to my worker response? My team is afraid we need to wrap it and use waitUntilwaitUntil but I'd need to do some hacks with performance.now()performance.now() because it would return a different value if it's executed inside waitUntilwaitUntil.

Could somebody clarify? Thanks!

Cezar Sampao

CCezar Sampao Hey guys, I was going through some past conversation here regarding `writeDataPo...

Chaika

C

Chaika•10/24/23, 2:42 PM

You don't need to await it or worry about it, it returns instantly and pushes data after the event, shouldn't effect latency at all

Chaika

C

Chaika•10/24/23, 2:42 PM

Calls to writeDataPoint will return immediately while processing of the data point continues in the background.

https://developers.cloudflare.com/analytics/analytics-engine/get-started/

Cezar Sampao

C

Cezar Sampao•10/24/23, 2:45 PM

Alright, thank you @chaika.me

Cezar Sampao

C

Cezar Sampao•10/24/23, 2:49 PM

plans to integrate WAE with Datadog?

Elliot Hesp

E

Elliot Hesp•10/26/23, 10:45 AM

Hey,

Is it expected we'll get longer data retention times in the future, longer than 3 months?

AlCalzone

AAlCalzone Can I pass a timestamp to `writeDataPoint`? I'm considering migrating analytics ...

John Spurlock

J

John Spurlock•10/26/23, 3:00 PM

while not an exact replacement, you can write your timestamp as a double, then use toDateTimetoDateTime and friends to query - works almost just as well

https://developers.cloudflare.com/analytics/analytics-engine/sql-reference/#todatetime

Unsmart

U

Unsmart•10/28/23, 4:06 AM

For anyone who uses grafana do you know if it is possible to set the "Graph styles -> Disconnect values -> Threshold" option to be exactly the query interval?

Causes a lot of annoyance when it is not set exactly to the interval :/

Advany

A

Advany•11/2/23, 11:51 AM

Seems that analytics is not working (getting errors when fetching data that authentication failed)