URLENG.COM - NFHN Reader

Serverless

CLICKHOUSE

URL Engine

Unlimited CLICKHOUSE CLOUD tables

Like a pastie for sql/json data

batteries included

SERVICE Features

No Special Clients or Drivers

Works from any ClickHouse Setup

Runs on the Edge. No backend.

Push, Share, Sync Data

Build anything you want

Serverless and Distributed

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.

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

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)

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))

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

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

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

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.

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.