xoelop
Time Duration in JavaScript
Text Search at Scale with ClickHouse
Free tool to monitor Scrapy spiders
SaaS Benchmarks Report from Chartmogul's data (TL;DR: raise your prices)
I've put all data about 978 founders from YC W22 in one place (emails too)
A year ago I started scraping job posts all over the internet. Now I have a database with 600k+ jobs from tens of thousands of companies.
I've extracted which technologies they're using, based on those job posts. This lets one know things that other sites like BuiltWith can't, because they only analyze the frontend of websites.
It can be useful, for example, to know what companies use technologies that your SaaS integrates to, and then to reach out to those companies.
This is still in a closed beta but I reached out to some companies already and got my first customers. If it sounds like you'd benefit from it, let me know!
Best, Xoel
TheirStack: Find 1000s of Companies Using Any Given Technology [OC]
Inspired by this great post on how to do Pandas stuff with Postgres, I wrote this guide on how to do all that on ClickHouse.
Hope you like it! Xoel
Generating Time-Series on ClickHouse
Modern Data Engineering practices at Buffer with David Gasquez
Thoughts about the Principal Role
From running daily pre-aggregations to having answers in real-time
Avoiding making joins on ClickHouse prefiltering data
Adding and Subtracting Intervals on ClickHouse
Window functions are coming to ClickHouse
Data at Basecamp
Principles of DataOps
Why we are hiring open source devs to contribute to ClickHouse full-time
Speeding up your analytical queries on Postgres by 100X with this cron command
Debugging ClickHouse on VSCode
I went for Telegram because I saw it working well for similar projects and it lets me reach the people directly, instead of them having to come to a site.
For the people that don't use Telegram I have a blog too and a newsletter at https://bloc.noicejobs.com
Some people told me that the jobs posted are too senior for them and they'd like some channels with more junior jobs.
I think getting a remote job as a junior may not be the best in terms of the rate of learning when you can't still figure out things fast on your own. But office jobs are also a no-no given the current COVID state of affairs, so I thought this could help some people.
Let me know what you think. Cheers! Xoel
Show HN: I've made 10 Telegram channels where juniors can find remote jobs
Analyzing Nginx logs with SQL and publishing the queries as API endpoints
Our data SaaS integrates with Git
I save a bunch of interesting links by liking tweets, but after time passes it's almost impossible to find them. So I made a small project to store them on the cloud and make searches on them easily
The tools I used are all free and the post has all the instructions to do it for your own account.
Let me know what you think!