298 karma · joined August 7, 2018
If you'd like to get in touch, you can email my username at my username dot com.
(Disclaimer: I work at Timescale)
As you note, a comparison between InfluxDB IOx and TimescaleDB is not possible at this time, due InfluxDB IOx being still under development and unavailable for comparison, so that blog is the next best thing for developers looking for answers today.
[1]: https://blog.timescale.com/blog/timescaledb-vs-influxdb-for-...
For more information on TimescaleDB licensing, check out this blog post: https://blog.timescale.com/blog/building-open-source-busines...
(Disclaimer/ fyi: I work at Timescale)
I don't think we were alone in that
"Marc Andreessen came up with the concept of the “product-market fit.” I would expand that to “product-market-founder fit,” taking into account how well a founder is personally suited to the business. The combination of the three should be your overwhelming goal." [2]
The startup example was one where I wasn't aware that I'd outsourced my thinking and it came back to bite me in the long run
You get the ownership of your own site, and the reach and SEO of medium and 3rd party publications.
Sharing so others who want to be more creative and better problem solvers can benefit
Good lesson for budding founders or indie devs.
Shows you the power of "Just ask". If you don't ask, the answer is always no.
For those looking for similar Postgres related resources, I've found this handy Postgres Cheat Sheet [1] to be really useful.
What's difficult is to find a database that has good performance on both narrow and deep queries (e.g Price of stock X for past 5 years) as well as shallow and wide queries (e.g Price of all stocks in past 15mins)
Time-series databases offer better performance and usability for dealing with time-series data (think DevOps metrics, data from IoT devices, stock prices etc, anything where you're monitoring and analyzing how things change over time)
They allow you answer questions where time is the main component of interest much more quickly and easily:
eg 1: IoT Sensors) Show me the average of temperature over all my devices over the past 3 days in 15 minute intervals
eg 2: Financial data) What's the price of stock X over the past 5 years
eg 3: DevOps data) What's the average memory and CPU used by all my servers of the past 5 mins
A normal database could be a purely relational database (e.g Postgres) or a non-relational database (e.g MongoDB). In both these cases, while you could use these databases for time-series data, they tend to offer worse performance at scale and a worse experience for doing common things (e.g real-time aggregations of data, data retention policies etc)
For more on time-series data and when you'd need a time-series database, check out: https://blog.timescale.com/blog/what-the-heck-is-time-series...
As a student you're on CPT and OPT. And after you graduate, OPT.
Is there a huge difference?
I especially like the last point about teaching what you learn and how you use accountability mechanisms like signing up to do a public talk to force yourself to learn the details. Great hack!
I think more of us should share what you learn and document our learning process
I know you can go down the H1-B, O-1 or Green Card route, but what do you commonly advise?
Here's some instructions on how to do so: https://github.com/slashdotdash/til/blob/master/postgres/ins...