2731
A Minimalist Guide to SQLite
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
New
The latest blog posts to take off on Hacker News. 4,224 posts.
2732
Apache Kafka Goes 1.0
Major milestone release Apache Kafka 4.0 removes ZooKeeper entirely, provides early access to Queues for Kafka, and enables faster rebalances, in addition to many other new KIPs.
2733
Do we need a third Apache project for columnar data representation?
Apache Parquet and Apache ORC have become a popular file formats for storing data in the Hadoop ecosystem. Their primary value proposition ...
2734
2735
Scaling the GitLab database
An in-depth look at the challenges faced when scaling the GitLab database and the solutions we applied to help solve the problems with our database setup.
2736
The often-overlooked random forest kernel
Ryan Marcus, assistant professor at the University of Pennsylvania. Using machine learning to build the next generation of data systems.
2737
2738
Implementing Stripe-Like Idempotency Keys in Postgres
Building resilient services by identifying foreign state mutations and grouping local changes into restartable atomic phases so that every request can be driven to completion.
2739
Anaconda 5.0 Released
Anaconda Scale Customer Event Join us live October 15th Save Your Seat Anaconda Blog
2740
The Upspin manifesto: On the ownership and sharing of data (2014)
Here follows the original "manifesto" from late 2014 proposing the idea for what became Upspin . The text has been lightly edited to remove...
2741
2742
Hard Drive Stats for Q3 2017
We take a look at the performance of our 86,529 hard drives and break down the failure rates by manufacturer and model size.
2743
Amazon Aurora with PostgreSQL Compatibility
Late last year I told you about our plans to add PostgreSQL compatibility to Amazon Aurora. We launched the private beta shortly after that announcement, and followed it up earlier this year with an open preview. We’ve received lots of great feedback during the beta and the preview and have done our best to make […]
2744
2745
2746
Getting the Most Out of Sqlite3 with Python
Simplex Sigillum Veri
2747
2748
Word vectors are awesome but you don’t need a neural network to find them
When I started playing with word2vec four years ago I needed (and luckily had) tons of supercomputer time. But because of advances in our understanding of w...
2749
2750
2751
Efficient pagination of a SQL table with 100M records
Compilation of my favorite SQL queries after a decade of dealing with relational databases. Today we talk about scanning a table with 100 million records.
2752
2753
Unbalanced reads from SSDs in software RAID mirrors in Linux
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…
2754
Analysing C# code on GitHub with BigQuery
Just over a year ago Google made all the open source code on GitHub available for querying within BigQuery and as if that wasn’t enough you can run a terabyte of queries each month for free!
2755
Dear Postgres
Dear Postgres, I’ve always felt an affinity for you in my 9 years of working with you. I know others have known you longer, but that doesn’t mean they love you more. Years ago when others complained about your rigidness or that you weren’t as accommodating as others I found solace in your steadfast values: Don’t lose…
2756
CockroachDB 1.1 Released: Production Made Easy
CockroachDB 1.1 includes support for faster migrations from legacy databases, simplified cluster management, and improved performance.
2757
2758
Ways to paginate in Postgres (2016)
Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as well as more exotic techniques.
2759
A Data-Driven Guide to Becoming a Consistent Billionaire
Did You Really Think All Billionaires Were the Same? Recently, I became a bit obsessed with the one percent of the one percent – Billionaires. I was intrigued when I stumbled on articles telling us…
2760