557 karma · joined August 8, 2016
Not too long ago, I was asked to work on some analytics project and it required time-series data. I'm not a rockstar programmer and don't really know much about trends. So, I ended up googling and stumble upon InfluxDB. It felt like that right choice and I started playing with it. As the time passed, I realized that it might be a good software and I'm sure people love InfluxDB, but it wasn't the right choice for me. I didn't really like the docs, maybe its good now. And I had the same feeling about query syntax, it felt weird.
I moved to TimescaleDB and never looked back. I have it production for almost 2 months now. 20 tables and over 100Million writes/week. One of things I really liked was staging, I don't use docker and or anything fancy. I have bash script that and it runs on centos box and all timescale extension and postgres database are packaged together.
I was impressed by the timescale compression feature. I wasn't using it earlier because I had to be careful about what columns I need to segmentby. I would love to see some more features but I'm sure timescaledb team is already on it.
This bring back memories. I was preparing for GATE in 2006 after getting my bachelors. Actually started preparing from 2004. I was so bad at Automata Theory and discreet maths. I never got admitted to the prestigious IITs, but that preparation and learning was helpful later in my career when I got admitted to MS program in a US university.
How do we classify the 127 hours is a movie or a time value?
Reminds me of the "Shirts without stripes"
https://github.com/elsamuko/Shirt-without-Stripes
Edit: Removing that space between 127 and hours somehow makes it work. "how long is 127hours"
I have been always fascinated by unsolved problems in mathematics. Have you written something before or maybe you could write an essay on one of those problems.
I'm working on a module that send notifications to a user when an alert is generated. I have PostGreSQL as the database and NodeJS is the handler and for connection pooling. Are there any good pub/sub tools that I can use. Thanks in advance.
I might be really bad, because few of the questions were challenging and difficult. I was expecting a rant how bad the google interview process is, which is usually what I come across. I do agree the questions are fun and are helpful to someone who is preparing for an interview. The interview and programming questions covered lot of topics.
Macbook Pro, 15inch, Mid 2015 2.5GHz i7 16GB RAM 500GB SSD
I have almost 8 tables with over 60Million rows and I'm very happy with the performance. Considering I have a t2.medium instance(2 CPUs with 4GB RAM). Like, everyone else mentioned, having AWS hosted option will be awesome!
Is there a way to optimize storage? I have set chunk size to 1 day interval . About 2 million rows per day writes.
My many thanks to the engineering team.
Also, reminds me of the Silicon Valley where Richard was able to disproof Patent troll by using his music/search app.
P.S I don't work for slack or have any affiliation.