HN user

zernie

4 karma

https://zernie.com?utm_source=hackernews

Posts3
Comments3
View on HN

PostgreSQL is quite terrible at OLAP, though. We got a few orders of magnitude performance improvement in some aggregation queries by rewriting them with ClickHouse. It's incredible at it.

My rule of thumb is: PG for transactional data consistency, Clickhouse for OLAP. Maybe Elasticsearch if a full-text search is really needed.

SEEKING WORK Remote: yes

Location: Eastern Europe

Skills: Ruby on Rails, React.js/Redux, Rspec, Typescript, SQL, CSS;

Email: hnewsrails@boun.cr

Github: https://github.com/zernie

Linkedin: https://www.linkedin.com/in/zernie/

=====================================

I'm currently working as a senior full-stack dev on a blockhain startup that has raised more than 3 million $ in investments. My hourly rates are reasonable and negotiable.