2041
New
The latest blog posts to take off on Hacker News. 4,224 posts.
2042
Using SQL to find my best photo of a pelican according to Apple Photos
According to the Apple Photos internal SQLite database, this is the most aesthetically pleasing photograph I have ever taken of a pelican: Here’s the SQL query that found me my …
2043
PostgreSQL 13 Beta 1 Released
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 13 is now [available for download](https://www.postgresql.org/download/). This …
2044
Three bugs in the Go MySQL driver
Check out what we learned from shipping our busiest Go service in production—we found 3 bugs in the Go MySQL driver.
2045
Kafka Removing Zookeeper Dependency
Say goodbye to Kafka ZooKeeper dependency! KIP-500 introduces a new way of storing data in Kafka itself, rather than in external systems such as ZooKeeper.
2046
What every software engineer should know about Apache Kafka
To help fellow engineers wrap their head around Apache Kafka and event streaming, I wrote a 4-part series on the Confluent blog on Kafka’s core fundamentals....
2047
Backblaze Hard Drive Stats Q1 2020
We take a look at the Q1 2020 and lifetime performance of 129,764 hard drives used in the Backblaze data centers.
2048
CockroachDB 20.1
We want to give you a database that allows you to quickly and simply build and manage data-intensive applications in the cloud—without worrying about the performance, scale or resilience of those apps. To support that mission, our latest release includes updates that let you build fast and build to last.
2049
Improved vacuum in PostgreSQL 13
Vacuum is one of the sub-systems in PostgreSQL which gets improved with each release. I have checked past five releases and each has qu...
2050
Advanced SQL and database books and resources
For people who've worked through Mastery with SQL , a common question I get is "What's next?" If you completed the course and all 150+ exercises, at this point you'll have a very strong grasp of SQL and should be comfortable writing all sorts of complex queries. However, there's more to working with databases…
2051
Understanding Raft Consensus
Recently I was digging deeper into Raft , an important algorithm in the field of distributed systems. Raft is a consensus algorithm , meaning that it is designed to facilitate a set of computers agreeing on a state of the world (more on exactly how the state of the world is represented later), even when communications…
2052
A visual explanation for regularization of linear models
A deep dive into exactly how regularization works, using visualizations rather than (just) mathematics. This article also dispels some myths and answer some important questions about Lasso and Ridge regression.
2053
How to get stock fundamentals data with Python
Learn how to download fundamentals data with Python using the yahoo_fin package, including P/E and P/S ratios, return on equity, and more.
2054
2055
Backblaze B2 Cloud Storage Now Has S3 Compatible APIs
With B2 Cloud Storage S3 Compatible APIs, we’re making the choice for something different a no-brainer.
2056
Oracle vs. PostgreSQL: First Glance
We are facing some interesting times at work as we are going to start changing our technology stack in the near future. Most of our Oracle ...
2057
2058
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...
2059
A synthetic control causal analysis of Musk's tweet on Tesla stock price
a terse analysis of tesla stock prices and how one of elon’s tweets moves them
2060
Comprehensive Tutorial on Time Series Modelling and Forecasting
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for Auto-Regressive and MA stands for Moving Average
2061
Jepsen: Dgraph 1.1.1
Dgraph is a graph database which aims to provide scalable, highly-available, and snapshot-isolated transactions over a labeled directed graph, while minimizing network communication for performance. Conceptually, Dgraph stores a set of (entity, attribute, value) triples. Entities (also known as subjects), are compact…
2062
2063
Guide to Making 3D Maps with Satellite Imagery in R
E ver since I released rayshader to the public, there’s been one question that comes up time and time again: “How do I use rayshader to overlay satellite imagery onto a 3D surface?” And I can see why: 3D maps with real satellite images are super cool, and there are few detailed tutorials out there on how it’s done in…
2064
SELECT wat FROM sql
Thanks to Nikhil Benesch, Justin Jaffray and several decades of "wouldn't it be nice if..." for contributions.
2065
Analyzing Analytics (Featuring: The FBI)
Recently while conducting some research, I found myself down the path of Google Analytics ID's as well as other analytics services. I was investigating ways to not only identify varying analytics code in sites, but to correlate them with ot…
2066
2067
Combining event sourcing and stateful systems
Bridging the gap between stateful and event sourced sub-systems
2068
2069
2070
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.