2521
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2522
Statistical Arbitrage – An Easy Walkthrough
Statistical arbitrage (stat arb) is a pillar of quantitative trading that relies on mean reversion to predict the future returns of an asset. Mean reversion believes that if a stock has risen higher it’s more likely to revert in the short term which is the opposite of a momentum strategy that believes if a stock has…
2523
The simple joys of scaling up
Explores why scale-out became so dominant, whether those rationales still hold, and some joyful advantages of scale-up architecture. | Reading time: 16 min read
2524
2525
2526
Visual Guide to NoSQL Systems
There are so many NoSQL systems these days that it's hard to get a quick overview of the major trade-offs involved when evaluating relational and non-relational systems in non-single-server...
2527
2528
Dragon: A distributed graph query engine
Visit the post for more.
2529
Optimizing Top K in Postgres
How ParadeDB uses principles from search engines to optimize Postgres' Top K performance.
2530
2531
Apache Arrow Flight SQL: Accelerating Database Access
This post introduces Arrow Flight SQL, a protocol for interacting with SQL databases over Arrow Flight. We have been working on this protocol over the last six months, and are looking for feedback, interested contributors, and early adopters.
2532
Exploring Word2Vec
In my previous blog post, I explored some of the early ways of word embeddings and their shortcomings. The purpose of this post is to explo...
2533
PostgreSQL 11 Reestablishes Window Functions Leadership
PostgreSQL 11 offers the best OVER clause support among its competitors, true procedures, and improvements in FETCH FIRST and XML.
2534
2535
Gradient Boosted Decision Trees
From zero to gradient boosted decision trees
2536
Azure dropping database support for MariaDB. Users advised to migrate to MySQL
Subscribe to Microsoft Azure today for service updates, all in one place. Check out the new Cloud Platform roadmap to see our latest product plans.
2537
UCLA professor refuses to cover for Dan Ariely in issue of data provenance
In one of the more bizarre twists of the Dan Ariely saga, there is a huge issue of provenance in one of Dan Ariely’s studies. The study in question is Dan Ariely’s Ten Commandments study at JMR. The hugely impactful paper has over 3,000 citations but unfortunately failed to replicate in a large-scale systematic…
2538
In Praise of ZFS on Linux's ZED 'ZFS Event Daemon'
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…
2539
Soma Water Filters Are Worthless
This experiment was inspired by a light-hearted argument with my wife, a stylish but atrocious water filter, and the explosion of start-ups attempting to turn everything you purchase into a subscription service.
2540
The Idiot's Guide to High Frequency Trading
First, let me say what you read here is going to be wrong in several ways. HFT covers such a wide path of trading that different parties participate or are impacted in different ways. I wanted to put this out there as a starting point . Hopefully the comments will help further educate us all
2541
How I work with Postgres – psql, My PostgreSQL Admin
On at least a weekly basis and not uncommonly multiple times in a single week I get this question: @neilmiddleton I’ve been hunting for a nice PG interface that works within other things. PGAdmin kinda works, except the SQL editor is a piece of shit Sometimes it leans more to, what is the Sequel Pro equivilant for…
2542
Beringei: A high-performance time series storage engine
Visit the post for more.
2543
RethinkDB 1.13: pull data via HTTP, push data via changefeeds
Today, we’re happy to announce RethinkDB 1.13 ( My Name is Nobody ). Download it now!
2544
2545
RethinkDB Driver for Java now available
Today, we’re pleased to announce the release of our Java client driver for RethinkDB. Visit the installation instructions for details about how to use it in your Java project.
2546
Why I'm Lukewarm on Graph Neural Networks
{{ content|truncate(160) }}
2547
2548
Lessons Learned from Scaling to Multi-Terabyte Datasets
This post is meant to guide you through some of the lessons I’ve learned while working with multi-terabyte datasets. The lessons shared are focused on what someone may face as the size of the…
2549
Zmij: Faster floating point double-to-string conversion
There comes a time in every software engineer’s life when they come up with a new binary-to-decimal floating-point conversion method. I guess my time has come. I just wrote one, mostly over a weekend: https://github.com/vitaut/zmij .
2550
