TimescaleDB 1.0: An Enterprise-Ready Time-Series Database
source link: https://www.tuicool.com/articles/hit/yqU7BfZ
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
TimescaleDB 1.0: An Enterprise-Ready Time-Series Database — First launched 18 months ago, Timescale is a database built as an extension to PostgreSQL that’s now in used in numerous large scale deployments for time-series work.
How to Extract a Data-Rich Service From a Monolith — A series of steps for separating part of a monolithic application, with its data store, to an independent service. Published and recommended by Martin Fowler.
Setting Up a MongoDB Service Under Windows via PowerShell — We'll show you how to use PowerShell to set up a MongoDB service on Windows, plus highlight how Studio 3T can help with user authentication and management.
Studio 3T sponsor
LogDevice: Distributed Storage for Sequential Data — A newly open sourced scalable distributed log storage system from Facebook that’s designed for workloads like event streaming, replication pipelines, transaction logs, and deferred work journals.
PostgreSQL 11's Just In Time (JIT) Query Compilation — The forthcoming Postgres 11’s new JIT expression compiler gives it a major speed boost over Postgres 10 on TPC-H Q1.
The Anna Key-Value Store Boasts 355x the Performance of DynamoDB — “we measured Anna providing 355x the performance of DynamoDB for the dollar. (..) Anna is now orders of magnitude more efficient than competing systems, in addition to being orders of magnitude faster.”
Several MySQL SQL Query Optimization Tips — Although the concepts can be applied to many other relational databases.
Time Series Data and MongoDB: An Introduction — TimescaleDB (above) is one option for time-series data, but did you know MongoDB can also step up to the task?
Robert Walter (MongoDB)
▶ Data Lake vs Data Warehouse — This is very entry level but if you’ve been confused as to the difference between the two, this keeps it simple.
LOLWUT: A Piece of Art Inside a Database Command — The creator of Redis has been inspired to add a new, just-for-fun command to the popular data structure server.
Moving to BigQuery — Hike moved from a Hive + BigQuery approach to BigQuery alone and improved querying speed by up to 50x.
Lessons from Building a Serverless Data Pipeline with AWS Kinesis and Lambda — Get ready for ‘inception’ as IOpipe explains how they monitor other people’s AWS Lambda functions using a data pipeline built around.. Lambda.
Increased Complexity is Dragging on Big Data — Nothing new in this report by Qubole. Complexity is continuing to bog down companies hoping to make progress on big data projects. No doubt we’ll continue to see more new tools and approaches coming out to attempt to remedy this.
Aggregate valuable and interesting links.
Joyk means Joy of geeK