Serverless
CLICKHOUSE
URL Engine
Unlimited CLICKHOUSE CLOUD tables
Like a pastie for sql/json data
batteries included
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
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
TRT IT 👇
No ClickHouse handy? No problem! Try it using a public chDB instance.
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.