1441
New
The latest blog posts to take off on Hacker News. 2,338 posts.
1442
PostgreSQL Features You May Not Have Tried but Should
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.
1443
A Performance Cheat Sheet for PostgreSQL
Performance tuning is not trivial, but you can go a long way with a few basic guidelines. In this blog, we will discuss how you analyze the workload of the database, and then review a list of important configuration parameters to improve the performance of PostgreSQL.
1444
Caching Beyond RAM: The Case for NVMe
memcached
1445
1446
Do We Need Distributed Stream Processing?
In the era of big data and AI, many data-intensive applications exhibit requirements that cannot be satisfied by traditional batch processing models. Streaming applications, such as click stream analytics , IoT data processing, network monitoring , or financial fraud detection , must support high processing rates…
1447
Faster – A key-value store for large state management
At SIGMOD 2018, a team from Microsoft Research will be presenting a new embedded key-value store called FASTER, described in their paper “FASTER: A Concurrent Key-Value Store with In-Place Updates”. As its name suggests, FASTER makes a major leap forward in terms of supporting fast and frequent lookups and updates of…
1448
1449
1450
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 …
1451
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…
1452
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.
1453
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.
1454
1455
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.
1456
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 …
1457
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
1458
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
1459
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.
1460
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.
1461
1462
1463
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 […]
1464
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.
1465
FoundationDB community highlights, two weeks in
In two weeks since open sourcing FoundationDB , we’ve had an outpouring of interest.
1466
Extracting Structured Data from Recipes Using Conditional Random Fields (2015)
Erica Greene describes the tool that she built to extract structured data from recipes.
1467
1468
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.
1469
A Look at MyRocks Performance
Taking a look at MyRocks performance through some benchmark testing.
1470
The False Allure of Hashing for Anonymization
Why using cryptographic hashes doesn't make data anonymous.