1351
The Holes in the Map: England’s Unregistered Land
Coding and writing by Anna Powell-Smith. Around 15% of the freehold land in England & Wales is unregistered. What this means is that if you go to the Land Registry and ask them ‘Who owns …
New
The latest blog posts to take off on Hacker News. 2,338 posts.
1352
Use perfect hashing, instead of binary search, for keyword lookup
We've been speculating for a long time that hash-based keyword lookup ought to be faster than binary search, but up to now we hadn't found a suitable tool for generating the hash function. Joerg Sonnenberger provided the inspiration, and sample code, to show us that rolling our own generator wasn't a ridiculous idea…
1353
LiteCLI – A user-friendly command-line client for SQLite database
LiteCLI is written in python using the wonderful prompt-toolkit library. It is cross-platform compatible and it is tested on Linux, MacOS and Windows.
1354
1355
1356
Sqlite – Most Deployed Database in the World
SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. SQLite is found in:
1357
Improving compression at scale with Zstandard
Two years ago, Facebook open-sourced Zstandard v1.0, a landmark data compression solution that offers best-in-kind performance. Since then, we’ve released a variety of enhancements and advanc…
1358
AWS Outperforms GCP in the 2018 Cloud Report
Customers rely on us to help navigate the increasingly competitive cloud wars. This inspired the 2018 Cloud Report, a benchmark of AWS and GCP on performance, latency, CPU, network, I/O, and cost.
1359
1360
At 22 years old, Postgres might just be the most advanced database yet
From Pub-Sub messaging to Foreign Data Wrappers - five extraordinary features that made Postgres our backend of choice for Arcentry
1361
1362
FoundationDB Document Layer
Today we’re open sourcing the FoundationDB Document Layer, a document-oriented database that extends the core functionality of the FoundationDB key-value store.
1363
1364
How Postgres is more than a relational database: Extensions
Extensions allow Postgres to be customized and extended in powerful new ways. Here we find a tour of extensions and how they can make Postgres into much more than a relational database
1365
Progress in performance and scalability with CockroachDB
CockroachDB 2.1 is 50x more scalable than Amazon Aurora at less than 2% of the price per tpmC. Read on to see performance benchmarks of CockroachDB 2.1, including the latest TPC-C results.
1366
Amazon DynamoDB On Demand
January 31, 2025: Post updated to clarify the reduced on-demand pricing and workloads recommendations. Just a few years ago, creating a database that could support your business at any scale while providing consistent low latency was a daunting task. That changed for me in 2012 while reading Werner Vogels’ blog post…
1367
Amazon DynamoDB Transactions
May 20, 2024: As of September 2022, DynamoDB now supports 100 items per transactions. March 13, 2020: Post updated to clarify how to use transactions with global tables and the increase in the maximum number of items per transaction from 10 to 25. Over the years, customers have used Amazon DynamoDB for lots of…
1368
FoundationDB 6.0 released, featuring multi-region support
FoundationDB 6.0.15, our first major release since open sourcing FoundationDB in April, is now officially available!
1369
Translating Between Statistics and Machine Learning
This SEI Blog post explores the differences between statistics and machine learning and how to translate statistical models into machine learning models.
1370
OpenZFS vs. Btrfs and other file systems (2017)
Michael Dexter returns to update his blog post on the different file systems and details some key developments that are unfolding. He covers what's being added to these respective file systems: OpenZFS, Btrfs, and bcachefs. Michael Dexter has invested his volunteer time and career in Open Source hypervisors and file…
1371
The State of the Octoverse: top programming languages of 2018
Take a closer look into why—and where—top programming languages are popular.
1372
1373
Python Data Visualization 2018: Why So Many Libraries?
Anaconda Scale Customer Event Join us live October 15th Save Your Seat Anaconda Blog
1374
Best practices for migrating an Oracle database to Amazon PostgreSQL
An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog series covers the environment and configuration setups for your source Oracle database, the AWS Database Migration…
1375
Using a Keras Long Short-Term Memory Model to Predict Stock Prices
Editor’s note: This tutorial illustrates how to get started forecasting time series with LSTM models. Stock market data is a great choice for this because it’s quite regular and widely available to everyone. Please don’t take this as financial advice… Continue reading Using a Keras Long Short-Term Memory (LSTM) Model…
1376
1377
Optimal Shard Placement in a Petabyte Scale Elasticsearch Cluster
At the heart of Meltwater’s and Fairhair.ai’s information retrieval systems lies a collection of Elasticsearch clusters containing billions of social media posts and editorial articles. The index shards in our clusters vary greatly in their access pattern, workload and size which presents some very interesting…
1378
How We Built a Cost-Based SQL Optimizer
CockroachDB 2.1 includes a brand-new, built-from-scratch, cost-based SQL optimizer. This post explains what a cost-based SQL optimizer is, and tells the story of how we decided we really, really needed one.
1379
LMDB: Intel Optane SSD Microbenchmark
Since the point of these tests is to explore the performance of the Optane SSDs, the tests are configured much like the previous ondisk benchmark, using a database approximately 5x larger than RAM, to minimize the impact of caching in RAM and force the storage devices to be exercised. However, there are some twists to…
1380