151
New
The latest blog posts to take off on Hacker News. 265 posts.
152
153
Truth First, or Why You Should Mostly Implement Database-First Designs
In this much overdue article, I will explain why I think that in almost all cases, you should implement a “database first” design in your application’s data models, rather than a …
154
Using Countdown Clock Data to Understand the New York City Subway
Ranking the lines by reliability, the anatomy of a delay, and a case for the $19 billion subway plan
155
Archive.org and California to start a data sharing and preservation project
Research and cultural heritage institutions are facing increasing costs to provide long-term public access to historically valuable collections of scientific data, born-digital records, and other digital artifacts. With many institutions moving data to cloud services, data sharing and access costs have become more…
156
Fun with SQL: Window Functions in Postgres
Window functions in PostgreSQL are valuable when you want to compare & contrast data between rows. And window functions are key in analytics use cases. This post covers the basic structure of window functions as well as some of the more interesting things you can do with them.
157
Show HN: Domain-tailored CRDTs for collaboration without server involvement
An in-depth exploration of a new class of expressive, performant, and intuitive CRDTs, together with macOS and iOS sample code.
158
Predicting Stock Performance with Natural Language Deep Learning
We developed an NLP deep learning model using a one-dimensional convolutional neural network to predict future stock market performance of companies using Azure ML Workbench and Keras with open source for you to replicate.
159
160
161
About ZFS Performance
You likely know I like the ZFS filesystem a lot. ZFS stores the files in B-trees in a similar fashion as InnoDB stores data.
162
Parallel Index Scans in PostgreSQL
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequen...
163
ML Beyond Curve Fitting: An Intro to Causal Inference and Do-Calculus
Since writing this post back in 2018, I have extended this to a 4-part series on causal inference: * ➡️️ Part 1: Intro to causal inference and do-calculus [https://www.inference.vc/untitled] * Part 2: Illustrating Interventions with a Toy Example…
164
Postgres 11 Beta 1 released
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 11 is now available for download. This …
165
Showdown: MySQL 8 vs. PostgreSQL 10
Now that MySQL 8 and PostgreSQL 10 are out, it's a good time to revisit how the two major open source relational databases compete against each other. Before these versions, the general perception has been that while Postgres is superior in feature sets and its pedigree, MySQL is more battle
166
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
167
Recursive Common Table Expressions in Postgres
Common Table Expressions in PostgreSQL are a powerful SQL construct. You can think of CTEs as a view that is materialized only while the query is running. Recursive CTEs allow themselves to be called until some condition is met. This post from the Citus Data team explores how recursive CTEs work in Postgres.
168
PostgreSQL 11 Partitioning Improvements
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
169
Datasette Facets: Faceted Browse and a JSON API for any CSV File or SQLite DB
Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse. Datasette lets you deploy an instant web UI and JSON API for …
170
171
172
Amazon Aurora Backtrack
We’ve all been there! You need to make a quick, seemingly simple fix to an important production database. You compose the query, give it a once-over, and let it run. Seconds later you realize that you forgot the WHERE clause, dropped the wrong table, or made another serious mistake, and interrupt the query, but the […]
173
Glom – Restructured Data for Python
Thoughts on FOSS and fintech, layered by Mahmoud Hashemi
174
Cloud Memorystore: A fully managed in-memory data store service for Redis
Cloud Memorystore is fully compatible with open source Redis, letting you migrate your applications to Google Cloud with zero code changes.
175
176
FoundationDB community highlights, two weeks in
In two weeks since open sourcing FoundationDB , we’ve had an outpouring of interest.
177
Extracting Structured Data from Recipes Using Conditional Random Fields (2015)
Erica Greene describes the tool that she built to extract structured data from recipes.
178
179
The Internals of Postgres – Concurrency Control
Concurrency Control is a mechanism that maintains atomicity and isolation, which are two properties of the ACID, when multiple transactions run concurrently in a database.
180
Backblaze's Hard Drive Stats for Q1 2018
As of March 31, 2018 we had 100,110 spinning hard drives. This review looks at the quarterly and lifetime statistics for the data drive models (Seagate, HGST, WDC, and Toshiba) in operation in our data centers.