Serverless

CLICKHOUSE

URL Engine


Unlimited CLICKHOUSE CLOUD tables

Like a pastie for sql/json data

batteries included

SERVICE Features

NATIVE

No Special Clients or Drivers

Works from any ClickHouse Setup

ON EDGE

Runs on the Edge. No backend.

Powered by CloudFlare Workers

FLEXIBLE

Push, Share, Sync Data

Build anything you want

OPEN & FREE

No setup, No Signup

100% Open-Source

ALWAYS ON

Serverless and Distributed

Powered by CloudFlare Workers

:)

LET'S GET STARTED


You're about to create your very own serverless, storage persistent URL Engine table, accessible from anywhere. Since there are no logins or signups, all data is hidden in public. The only protection is your own Secret URL


Launch your ClickHouse client and choose your URL path wisely - or just use the random UUID below.



PICK A UNIQUE URL


:) SET param_url = 'https://urleng.com/'


INSERT DATA

It's time to insert some data. The serverless table will automatically adapt to the schema inserts


:) INSERT INTO FUNCTION url({url:String}, JSONEachRow, 'key String, value UInt64') VALUES ('hello', 1)


EXPIRE DATA

You can auto expire data by using or adding an __expires key/column with a future unix timestamp.


:) INSERT INTO FUNCTION url({url:String}, JSONEachRow, 'key String, value UInt64, __expires UInt64')
VALUES ('hello', 1, toUnixTimestamp(now()+300))


SELECT DATA

Let's read our data back or apply any WHERE logic.


:) SELECT * FROM url({url:String}, JSONEachRow)
:) SELECT count(*) FROM url({url:String}, JSONEachRow)

PERSISTENT URL Table

If you plan on using the data frequently, you can create a persistent URL Engine table with any schema.


:) CREATE TABLE default.url_engine_distributed (`key` String,`value` UInt64)
ENGINE = URL('https://urleng.com/', 'JSONEachRow')
:) INSERT INTO url_engine_distributed VALUES ('hello', 1), ('world', 2)
:) SELECT * FROM url_engine_distributed


💡 There's so much more you can do with URLEng! Check the documentation for more Examples











><-- console -->

TRT IT 👇

No ClickHouse handy? No problem! Try it using a public chDB instance.


Service Disclaimers

Terms of Use

No warranties of any kind, either express or implied. Data can be removed or lost at any moment of time. Use at your own risk.

Security

This service does not provide any security or privacy. Traffic is secured by Cloudflare and data stored on Deta cloud. Use at your own risk.

Limitations

This public demo service is limited. Workers might limits might limit or crop large INSERT queries. Launch your own instance on deta.space

Acknowledgements

ClickHouse is a trademark of ClickHouse Inc. All rights reserved by their respective owners. Any logos or names included under fair use policy.