LoriP

9 ms·

1. 31.▲
   by LoriP 5y ago

   Agree here. Helps those who follow to separate clean=up/optimisation work from change of function and specific bug fix work. Seems it would totally help code quality over time.
2. 32.▲
   by LoriP 5y ago

   Oracle RDBMS probably counts as cursing here :) but there's a nice (old) post that works through the considerations around auditing records https://blogs.oracle.com/oraclemagazine/post/a-fresh-look-at...
3. 33.▲
   Climate Anxiety – reactions to unprecedented threats hardly surprising(irishtimes.com)

   3 points by LoriP 5y ago|0 comments
4. 34.▲
   A different and often better way to downsample your Prometheus metrics(blog.timescale.com)

   96 points by LoriP 5y ago|21 comments
5. 35.▲
   by LoriP 5y ago

   Ah, that's a pity but at the same time totally respect the decision the Committee has made. It would have been a horrible choice to have to make.
6. 36.▲
   by LoriP 5y ago

   I know this is not on topic but thank you! We'd love to know more about what you do with TimescaleDB if you should want to share.
7. 37.▲
   by LoriP 5y ago

   I think the name originally came from company/project origin and how the whole thing started... Recently set up as their own entity, ClickHouse came from Yandex. There are probably others better able to give that history, but that&#x27
8. 38.▲
   by LoriP 5y ago

   Here's some posts from users on the Timescale blog https://blog.timescale.com/tag/dev-q-a/
9. 39.▲
   by LoriP 5y ago

   ClickHouse has gained a huge following and honestly that's been pretty well earned. For the kinds of apps that they target it's a great choice, it's great technology with a very able team behind it.
10. 40.▲
    Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data(blog.timescale.com)

    251 points by LoriP 5y ago|175 comments
11. 41.▲
    by LoriP 5y ago

    Poor dogs will be terrified but got to hope the best for them. It feels like a tall order though, in and out in 8 minutes... Not sure I can watch tbh
12. 42.▲
    by LoriP 5y ago

    TimescaleDB also implements compression. From the docs: When compression is enabled, TimescaleDB converts data stored in many rows into an array. This means that instead of using lots of rows to store the data, it stores the same data in a
13. 43.▲
    by LoriP 5y ago

    You likely already know that TimescaleDB is an extension to PostgreSQL, so you get everything you'd get with PostgreSQL plus the added goodies of TimescaleDB. All that said, you can drop (or detach) data partitions in PostgreSQL (howev
14. 44.▲
    by LoriP 5y ago

    Your comment on Boring Technology (tm) made me smile... At Timescale as you'll see in this blog we are happy to celebrate the boring, there's an awful lot to be said for it :) https://blog.timescale.com/blog/
15. 45.▲
    by LoriP 5y ago

    Now that you have covered Grafana Prometheus and InfluxDB would love to see you cover a SQL time series db in the same way. For transparency I should mention that I'm from Timescale ... :)
16. 46.▲
    by LoriP 5y ago

    Thanks for sharing the info about the Open-Meteo APIs. As you mentioned PostgreSQL I thought I'd share that maybe between PostGIS and TimescaleDB extensions you might get much closer to a relational database that overcomes some of thos
17. 47.▲
    by LoriP 5y ago

    Thanks for sharing... did you get to the point where there was just too much data to handle or does it pretty much handle anything that storable in a file?
18. 48.▲
    by LoriP 5y ago

    It's notable how often, too, folk turn to craft analogies when talking about code. So many people in tech (including me) try to turn to craft/art as a way of 'escaping' the grind. It's often not the coding that gets
19. 49.▲
    by LoriP 5y ago

    Starting again after a break is a big help. Likewise trying to do something else for a while and realizing that the grass is always greener helps to get things in perspective. I also think if you love coding then moving up the ladder is nei
20. 50.▲
    Analyzing OpenTelemetry traces using SQL to gain better insights(blog.timescale.com)

    33 points by LoriP 5y ago|0 comments
21. 51.▲
    Grow worry-free: storage autoscaling on Timescale Cloud(blog.timescale.com)

    8 points by LoriP 5y ago|0 comments
22. 52.▲
    by LoriP 5y ago

    From the author's summary thread: - DBaaS is Familiar and Flexible - Serverless data platforms may be scalable and easy but are not so much Familiar and Flexible. This new Timescale Cloud approach offers : Easy and Scalable - Modern cl
23. 53.▲
    PostgreSQL vs. Python for data evaluation: what, why, and how(blog.timescale.com)

    5 points by LoriP 5y ago|0 comments
24. 54.▲
    by LoriP 5y ago

    Thanks for the feedback we've made the change. Appreciated!
25. 55.▲
    by LoriP 5y ago

    Thanks, we corrected this quite quickly. Appreciated!
26. 56.▲
    by LoriP 5y ago

    One thing I like about this post is that it explains things in an accessible way before getting into a deep dive. Might be worth sharing with the marketing team as they'll "get" long tail in the context of web search, so the
27. 57.▲
    by LoriP 5y ago

    I might be tempted to add Daniel Pink's Drive though perhaps that might be for a little down the track rather than for starting-out...
28. 58.▲
    Speeding up data analysis with TimescaleDB and PostgreSQL(blog.timescale.com)

    8 points by LoriP 5y ago|0 comments
29. 59.▲
    Enterprise Content: 5 Favorite Features in the Latest Version of WordPress(wpvip.com)

    1 points by LoriP 5y ago|0 comments
30. 60.▲
    by LoriP 5y ago

    TimescaleDB also offers a good lot of supplementary functions to the PostgeSQL core product to help with time series data analysis... saves a lot of SQL acrobatics!