Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
Planet Labs' open satellite feed
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
Interpretable Machine Learning
Machine learning is part of our products, processes, and research. But computers usually don’t explain their predictions , which can cause many problems, ranging from trust issues to undetected bugs. This book is about making machine learning models and their decisions interpretable.
Machine Learning 101: An Intro to Utilizing Decision Trees
Stay up-to-date with the latest news, practical tips & best practices from Qlik on data analytics, data integration, data literacy, and big data analytics.
Phrase matching in Marginalia Search
Marginalia Search now properly supports phrase matching. This not only permits a more robust implementation of quoted search queries, but also helps promote results where the search terms occur in the document exactly in the same order as they do in the query. This is a write-up about implementing this change. This is…
Data Infrastructure at IFTTT
Get more from the services you love on IFTTT. Explore the latest tips and tricks, browse by category, or search by name.
Postgres tips for Rails developers
At RailsConf, the Citus engineering team found themselves sharing lots of useful Postgres tips on how to debug and improve the performance of your Postgres database from your Rails app. Includes topics like long-running queries, misbehaving queries, pg_stat_statements, pgBouncer, and more.
Faster LZ is not the answer to 150-250 GB video game downloads
When the JPEG folks were working on image compression, they didn't create a better or faster LZ. Instead they developed new approaches. I se...
PostgreSQL 9.3 Beta 1 Released
The first beta release of PostgreSQL 9.3, the latest version of the world's best open source database, is now available. …
How Wikipedia influences judicial behavior
Mixed appraisals of one of the Internet’s great friends (or foes), Wikipedia, are reflected in the slightly dystopian article “List of Wikipedia Scandals”, which sits below a Wikipedia web address. Scrutiny aside, billions of users routinely flock to the online, anonymously editable encyclopedia knowledge bank for…
How we saved money by replacing Mixpanel with BigQuery and K8S
Insights, guides, and product updates from Cloud Intelligence™.
People Keep Inventing Prolly Trees
A novel data structure has been invented four times now, with three different names. We think that's a good sign.
Getting the Most Out of Sqlite3 with Python
Simplex Sigillum Veri
Maxar's Open Satellite Feed
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
The secret ingredients of word2vec (2016)
Word2vec is a pervasive tool for learning word embeddings. Its success, however, is mostly due to particular architecture choices. Transferring these choices to traditional distributional methods makes them competitive with popular word embedding methods.
What category theory teaches us about dataframes
Every dataframe library ships with hundreds of operations. pandas alone has over 200 methods on a DataFrame. Is pivot different from melt? Is apply different from map? What about transform, agg, applymap, pipe? Some of these seem like the same operation wearing different hats. Others seem genuinely distinct. Without a…
Prolog for data science
I demonstrate a widely applicable pattern which integrates Prolog as a critical component in a data science analysis. Analytic methods are used to generate properties about the data under study and Prolog is used to reason about the data via the generated properties. The post includes some examples of piece-wise…