• Uncategorized
  • humor
  • finance
  • lifehack
  • trends
  • trading
  • culture
  • tech
  • aide-memoire
  • programming

Infinite Curiosity

~ Exploring ideas related to tech, code, finance, markets, adtech, AI, humor and more!

Tag Archives: database

Timeseries Databases

20 Sunday Dec 2020

Posted by Grynn in aide-memoire, programming

≈ Leave a comment

Tags

choice, database

tl;dr use Timescale (open source extensions to postgres) – All the power, expressivity and ease of SQL w/horizontal scalability via partitioning. Like your own, Amazon RedShift. Faster and obvs. much cheaper than RedShit.

Other options:

  • InfluxDb (and cloud) – simplicity of ingest
  • ElasticSearch – needs a custom browse component (Kibana too complex)
  • Clickhouse, Vertica, Pilosa and others – “exotic” options, not really worth the effort, esp. given how good TimescaleDb is.

How to ingest:

  • v0: statsD -> influx (fast, cheap, quick, scalable)
  • v2 rsyslog (on each server) => central rsyslog => beanstalkd / kafka => (fan out) postgres (timescaledb) + mongo + influx + es

Recent Posts

  • macOS Allow CLI binaries from third-party devs
  • AI Tools you can use *today*
  • YouTube Revenue Stats (2010-2021)
  • Thoughts on Bitcoin/Crypto
  • Apple Earnings Call – Jan 27 2021

Twitter Stream

  • Not sure if anyone’s noticed, but Telegram is becoming the defacto/goto for “free” speech! And its been super 🤖 fri… twitter.com/i/web/status/1… 6 hours ago
  • Interesting thread below. May be true in Mumbai too? Restaurants are full! And yet inflation is high, growth / mark… twitter.com/i/web/status/1… 1 day ago
  • @alifarhat79 @elonmusk If only your printer hadn’t jammed up, just as the party was getting good 😊 2 days ago
  • RT @elonmusk: @catturd2 They began brewing attacks of all kinds as soon as the Twitter acquisition was announced. In my 30 year career, in… 2 days ago
  • #Elongate twitter.com/elonmusk/statu… 2 days ago

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Infinite Curiosity
    • Join 438 other followers
    • Already have a WordPress.com account? Log in now.
    • Infinite Curiosity
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar