The latest blog posts to take off on Hacker News. 265 posts.
Ethereum and other cryptocurrencies have captured the imagination of technologists, financiers, and economists. Digital currencies are only one application of the underlying blockchain technology. Earlier this year, we made the Bitcoin dataset publicly available for analysis in Google BigQuery. Today we’re making the…
PostgreSQL has a rich collection of extensions and nearly 100 different data types, each with their own tuned indexing or specialized functions. You probably already use integers and text, and today we're going to explore a few less-used but incredibly powerful PostgreSQL data types.
Lesser-known but idiomatic pandas features for those already comfortable with Pandas' basic functionality and concepts.
How a seemingly minor enhancement in Postgres 11 fills one of the system’s biggest operational holes.
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
At JupyterCon, I learned three things: reactive notebooks are the future, Jupyter is the new Bash, and data science is a gateway drug.
2019-04-10: The long fork test used in this analysis contained a bug which caused it to (in many cases) fail to identify long fork anomalies—though we did find instances of long fork using other tests. We have re-checked Dgraph 1.0.13 with a corrected checker, and its long fork tests still pass.
Event sourcing and CQRS gained a lot of popularity recently. The advantages are obvious and they share a very peculiar symbiosis with the…
This article gives an overview of the implementation and performance of two recent additions to LocustDB, an extremely fast open-source analytics database built in Rust. The first addition is suppo…
Get an in-depth look at how two leading time-series databases stack up. We compare data models, query language, reliability, performance, and more.
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
This'll be my first blog post on the internet, ever. Hopefully it's interesting and accurate. Please point out any mistakes if you see any!
I was trying to run a simple join query on MariaDB (MySQL) and its performance was horrendous. Here’s how I cut down the query’s run time from over 380 hours to under 12 hours by executing part of it with two simple Unix commands.
A high-level overview of Numba and Cython architectures
Meltano is an open source tool for the entire data science lifecycle, and we want your contributions and feature requests!
A collection of tools that help you deal with color gradients & color palettes, to design better data visualizations.
In this post, we show you how to export data from a DynamoDB table, convert it into a more efficient format with AWS Glue, and query the data with Athena. This approach gives you a way to pull insights from your data stored in DynamoDB.
By Jay Judkowitz, Sr. Product Manager Like all good IT organizations, you religiously measure the performance and availability of your ser...
Posted by Umar Syed and Sergei Vassilvitskii, Research Scientists, Google AI, NYC Google BigQuery allows interactive analysis of large datasets, ma...
This review looks at the quarterly and lifetime statistics for 98,184 hard drives with a focus on consumer vs. enterprise drive reliability.
We’re on a mission to keep the magic of human connection alive. Learn more about life at Tinder and the many ways we're igniting our impact—for our employees and the millions of people seeking connection on our app.
In this article, we'll use Quilt to transfer versioned training data to a remote machine. We'll start with the Berkeley Segmentation Dataset, package the dataset, then train a PyTorch model for super-resolution imaging.
We’ve calculated Backblaze’s storage durability at 99.999999999%. What does that impressively large number mean, and does it actually matter for your data?
