181
Apache Druid vs. Time-Series Databases
Although Druid draws ideas from a number of TSDB concepts, it is designed for a wider range of analytic use cases than those for which a TSDB is usually employed.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 269 posts.
182
183
Gradient Boosted Decision Trees
From zero to gradient boosted decision trees
184
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…
185
186
Do NLP Beyond English
7000+ languages are spoken around the world but NLP research has mostly focused on English. This post outlines why you should work on languages other than English.
187
You probably don't need PostGIS
PostGIS is a fantastic, battle-tested suite of GIS extensions for Postgres. It handles most aspects of it, and is widely used, for example in OpenStreetMap’s Mapnik. But for your project, it’s most likely overkill. In a Q and A fashion, let’s discuss reasons for (not) using it.
188
Markov Chain Monte Carlo (MCMC) Sampling, Part 1: The Basics (2019)
In this first post of Tweag’s four-part series on Markov chain Monte Carlo sampling algorithms, you will learn about why and when to use them and the theoretical underpinnings of this powerful class of sampling methods. We discuss the famous Metropolis-Hastings algorithm and give an intuition on the choice of its free…
189
Foreign data wrappers: PostgreSQL's secret weapon?
EnterpriseDB (“EDB”), the leader in accelerating Postgres® in the enterprise, today announced its acquisition of Splitgraph, an early-stage disruptor that provides a Postgres compatible serverless SQL API for building data driven applications from hundreds of datasources. This move is seen as a meaningful step in…
190
Unofficial Guide to Datomic Internals (2014)
This post is a compilation of publicly available information, Datomic docs and google group answers about Datomic internals. Intention is to help others understand implementation model and use Datomic more efficiently.
191
Serving Dynamic Vector Tiles from PostGIS
Guide to building up a tile server and map client from scratch with PostGIS and PostgreSQL.
192
Improving Postgres Connection Scalability: Snapshots
Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.
193
194
Fixing Google Map Transit Feed Mistakes in Taiwan
Probably one of the nerdier things I do in my free time is fix and report transit errors on Google Maps. Accurate transit directions and schedules are extremely important if we want more people to take transit more often, especially in scenarios where good transit options exist! I do these bug reports and the…
195
196
Prepared statements and their surprising performance implications
Or: How To Increase Your Elixir/Postgres Performance 20x With One Weird Trick
197
Null Values in SQL Queries
*If you’re the owner of this website and have questions, reach out to Bluehost. We’re happy to help.
198
Finding unique items: hash vs. sort
A while back, I was trying to speed up some code which finds unique items in a collection. For example, transforming "AABBADCAB" => "ABDC" . There are two ways to do this efficiently - one is based on sorting, the other based on hashing. So, which is faster? I couldn't find the answer, so I ran some experiments and…
199
200
Bay Area Regional GTFS Feed: 31 transit agency feeds together in one API
Last year, Interline began a "startup in residence" at the Metropolitan Transportation Commission. Now we're pleased to publicly release our first creation: the San Francisco Bay Area's Regional GTFS Feed.
201
202
Flyte: A Cloud Native Machine Learning and Data Processing Platform
Today Lyft is excited to announce the open sourcing of Flyte, a structured programming and distributed processing platform for highly…
203
Using Neural Networks to Find Answers in Tables
Posted by Thomas Müller, Software Engineer, Google Research Much of the world’s information is stored in the form of tables, which can be found o...
204
Cash Is King: Flows, Balances, and Buffer Days
See how our clients and partners—from small business owners to workforce training leaders—work with JPMorganChase to drive meaningful impact and economic growth where they live and work.
205
Pg_stat_monitor – better insights into query performance in PostgreSQL
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights.
206
Scaling SQLite to 4M QPS on a Single Server (EC2 vs. Bare Metal)
Discover how Expensify achieved remarkable scaling: 4M QPS on one server! Dive into optimizing SQLite for impressive performance gains.
207
Making Netflix's Data Infrastructure Cost-Effective
By Torio Risianto, Bhargavi Reddy, Tanvi Sahni, Andrew Park
208
209
Why ZFS is not good at growing and reshaping pools, or shrinking them
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…
210
Combining event sourcing and stateful systems
Bridging the gap between stateful and event sourced sub-systems