• 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

Pages

  • About

Recent Posts

  • Enterprise / Server Cloud Storage (not “Personal” cloud storage)
  • “Free” SQL Databases
  • Timeseries Databases
  • June 2020 🔥🔥 New JS Bundlers/Builders
  • Quarantine one liners that will crack you up!

Twitter Stream

  • RT @joannalayton: This photo. What do you see? What jobs do you think they do? https://t.co/av0hlqLTQo 3 hours ago
  • @RonnieKStocks What's the best way to get in touch? I can't DM you: could you either set your DMs to "open" for all… twitter.com/i/web/status/1… 11 hours ago
  • @SJosephBurns 6. Low vol / Low Beta everything falls at the same time in a pandemic ;) - Not a good hedge. 11 hours ago
  • @SJosephBurns 4. Selling too early (esp. after a big up move). I now #hodl much longer and manage the fear by addin… twitter.com/i/web/status/1… 11 hours ago
  • @SJosephBurns 2. Buying #stonks based on tips from well meaning frnds and acquaintances, without actually understan… twitter.com/i/web/status/1… 11 hours 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