HN user

auxten

90 karma

Database Guy

Posts38
Comments32
View on HN
wasm.chdb.io 21d ago

Show HN: ChDB-WASM – ClickHouse running in the browser via WebAssembly

auxten
3pts0
myown.news 3mo ago

Show HN: A web newspaper that looks like a newspaper

auxten
2pts0
twitter.com 4mo ago

Context Management Is the Real Bottleneck for AI Agents

auxten
1pts0
botschat.app 5mo ago

Show HN: BotsChat, Chat UI Designed for OpenClaw

auxten
1pts0
macmate.app 5mo ago

A Frustrated Openclawer Ended Up Building a Headless Mac Utility

auxten
1pts0
github.com 1y ago

Show HN: ClickAgent: Multilingual RAG System with Batteries Included

auxten
2pts0
auxten.com 1y ago

Common Misconceptions of Vector Database

auxten
3pts0
github.com 1y ago

Show HN: chDB 3.0 released, 12% faster than DuckDB

auxten
5pts1
www.runportcullis.co 1y ago

Use Cases for ChDB, a Powerful In-Memory OLAP SQL Engine

auxten
9pts2
github.com 1y ago

Show HN: SQLite like API of ClickHouse engine in Python

auxten
1pts0
gist.github.com 1y ago

Show HN: Export PostgreSQL table to 10 Parquet files with chDB in 15 lines

auxten
3pts0
code.auxten.com 1y ago

Show HN: Console Style Code Card Generator

auxten
2pts0
auxten.com 1y ago

Show HN: ClickHouse on Pandas Dataframe

auxten
1pts0
clickhouse.com 1y ago

Show HN: How we made querying Pandas DataFrames 87x faster

auxten
2pts0
github.com 1y ago

Show HN: ClickHouse User Defined Table Function in Python

auxten
8pts3
clickhouse.com 1y ago

How we made querying Pandas DataFrames with chDB 87x faster

auxten
1pts0
github.com 3y ago

ClickHouse-local and chdb performance issue on clickbench Q.23 Q28

auxten
3pts4
chdb.fly.dev 3y ago

ServerLess OLAP with Chdb

auxten
3pts2
pypi.org 3y ago

Show HN: ChDB is an in-process SQL OLAP Engine powered by ClickHouse

auxten
4pts0
news.ycombinator.com 4y ago

I Put Apache Superset to Mac App Store

auxten
3pts1
www.github.com 5y ago

A toy SQL DB in 2000 lines of Golang

auxten
2pts0
github.com 5y ago

Show HN: Pure Golang PostgreSQL Parser powered by CockroachDB

auxten
2pts0
news.ycombinator.com 7y ago

Open Source Website Cookie Compliance Reporter

auxten
9pts6
github.com 7y ago

Show HN: Cookie Usage Tester and Reporter

auxten
6pts0
foreseaz.github.io 7y ago

Show HN: Animated Progress Bar on Favicon

auxten
4pts1
github.com 7y ago

Store Public Data in IPv6 DNS

auxten
6pts2
medium.com 7y ago

Internet Data Privacy Tug-of-War

auxten
5pts0
github.com 7y ago

GitHub made paid user PRO. So, I guess i'm NOT PRO

auxten
6pts3
news.ycombinator.com 7y ago

Twitter bot records your tweet to the blockchain

auxten
9pts7
github.com 7y ago

CovenantForum – A decentralized forum powered by CovenantSQL

auxten
50pts21

Data operations are increasingly happening near the GPU side to boost efficiency—especially for compute-heavy workflows. Talking about Arrow file processing and zero-copy queries on DataFrames, which are becoming crucial for modern data pipelines. I think another option worth considering is chdb, which supports these features and fits well with this shift. (author of chdb here)

I think Human Layer is a great idea. Recently, my baby turned one year old, which made me reflect on many issues. We train AI with a lot of data but overlook the impact that decades of seemingly useless data from human growth experiences have on our brain development. As a result, humans still have an incomparable advantage over LLMs in terms of the so-called "big picture." For example, a recent experience I had was when I asked Claude 3.5-sonnet to write a bash script; it inadvertently modified the PATH variable, costing me a lot of time to fix it. Such attention to detail in work is difficult to avoid through vector db recall or manual context completion. But I believe that a true bash expert would not make such mistakes.

Golang's forward compatibility and static compilation allow developers to quickly download and use the latest Golang release without the pain of upgrading like interpreted languages or VM-dependent languages.

[dead] 5 years ago

With JFS we can use S3 as a cheap backend of HDFS.

CovenantSQL uses a CA less protocol to distribute log.

To implement a decentralized system, I wrote a TLS like P2P net stack. The main idea is removing CA Cert from the whole system by using a DHT for Naming and Key Exchange. I am not a crypto expert, so if there's any flaw please point it out for me here or Github I use an Elliptic Curve for asymmetric encryption

DH-RPC NodeID is generated by hash of Node PublicKey and an Uint256 Nonce:

    NodeID := sha256(blake2b-512(NodePublicKey + Uint256Nonce))
I refer to S/Kad idea to define the number of consecutive 0s in front of the NodeID as difficulty and to impose a minimum limit on the difficulty of the NodeID allowed to be stored on the DHT. DHT is used to hold the NodeID:PublicKey NodeID:Addr map. NodeID and Nonce are sent to do ECDH getting shared secret after TCP connection established. GenECDHSharedSecret(APub, BPriv) == GenECDHSharedSecret(BPub, APriv) The main procedure is described as sequence chart: https://github.com/CovenantSQL/CovenantSQL/blob/develop/logo... Because in the decentralized system NodeID is the URI, not "Bob/Alice.com". So anyone tries to fake NodeB by overwriting the address or public key on DHT without the private key of NodeB will be failed to get the correct shared secret.

Github: https://github.com/CovenantSQL/CovenantSQL/tree/develop/rpc

I refer to S/Kademlia's idea to define the number of consecutive 0s in front of the NodeID as difficulty and to impose a minimum limit on the difficulty of the NodeID allowed to be stored on the DHT. As the S/Kademlia paper said, they just use the PoW NodeID way to obviate Eclipse Attack(Make Kademlia Network Fork), Sybil Attack(Fake Nodes), Churn Attack(Frequently Join & Leave), Adversarial Routing(Spread Bad Route).

Adversarial Routing is a bit related to DOS Attack you described. As the DHT is a gossip protocol organized network, maybe some Peer Rating stuff with PoW NodeId will work out an intergalactic-internet scale DHT. Just a well behaved proper difficulty NodeID will be trusted to spread more NodeID routing info.