151
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 332 posts.
152
153
154
How to Scale PostgreSQL on AWS: Learnings from Citus Cloud
Lessons learned in scaling out the PostgreSQL database in the cloud using Citus, an open source extension to Postgres that is also available as a fully-managed database as a service. From operational pain points like HA to disaster recovery to backups to monitoring and logging and alerts.
155
156
157
Introducing Dash – Reactive Web Apps for Python
Create Reactive Web Apps in pure Python
158
Sorting number strings numerically
The only enterprise AI data platform that cuts complexity, reduces costs, and gets you to production faster.
159
Inside Cloud Spanner and the CAP Theorem
Building systems that manage globally distributed data, provide data consistency and are also highly available is really hard. The beauty of the cloud is that someone else can build that for you.
160
Study: carpooling apps could reduce traffic 3x in NYC
Traffic is not just a nuisance for drivers: it’s also a public-health hazard and bad news for the economy. Transportation studies put the annual cost of congestion at $160 billion , which includes 7 billion hours of time lost to sitting in traffic and an extra 3 billion gallons of fuel burned. One way to improve…
161
Migration from Postgres to Datomic
Recently, I migrated my Clojure-driven pet project from PostgreSQL to Datomic. This is Queryfeed , a web application to fetch data from social networks. I’ve been running it for several years considering it as a playground for some experiments. Long ago, it was written in Python, then I ported it to Clojure.
162
Using logistic regression to predict parking difficulty
Posted by James Cook, Yechen Li, Software Engineers and Ravi Kumar, Research Scientist"When Solomon said there was a time and a place for everythin...
163
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.
164
Switching Jobs
When people move to different jobs, here’s where they go.
165
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 ...
166
APFS – A Backup Software Developer’s Perspective
A backup-software developer's deep dive into Apple's APFS file system — snapshots, cloning, space sharing, and what it all means for reliable Mac backups.
167
168
Advantages of Using R Notebooks for Data Analysis Instead of Jupyter Notebooks
The relatively new R Notebooks improve the workflows of common data analysis in ways Jupyter Notebooks can’t.
169
170
171
CockroachDB 1.1 Released: Production Made Easy
CockroachDB 1.1 includes support for faster migrations from legacy databases, simplified cluster management, and improved performance.
172
How should you build a high-performance column store for the 2020s?
Though most relational databases (like MySQL) are "row oriented", in that they keep rows stored together... experience has taught us that pivoting the data arrow so that columns, and not rows, are stored together can be beneficial. This is an old observation that most experienced programmers know about as the…
173
Deploying PostgreSQL Clusters Using StatefulSets
Editor’s note: Today’s guest post is by Jeff McCormick, a developer at Crunchy Data, showing how to build a PostgreSQL cluster using the new Kubernetes StatefulSet feature. In an earlier post, I described how to deploy a PostgreSQL cluster using Helm, a Kubernetes package manager. The following example provides the…
174
175
Postgres performance analysis resulted in a 10x improvement in CPU use
Heap is the only digital insights platform that shows everything users do on your site, revealing the "unknown unknowns" that stay invisible with other tools. Learn about how we improved our performance and saved millions!
176
177
How to Learn Hadoop for Free
KOITOTO LOGIN menghadirkan akses cepat, aman, dan praktis untuk pengalaman hiburan online modern dengan navigasi responsif, performa stabil, serta kenyamanan maksimal setiap waktu.
178
Connecting to Google Sheets with Python
I wrote up my experience using Python to process data from a shared Google Sheets spreadsheet
179
ZFS from a MySQL perspective
As the purpose of a database system is to store data, there is close relationship with the filesystem. Yves Trudeau reconsiders the use of ZFS with MySQL.
180
MySQL vs. MariaDB: Reality Check
Choosing between MariaDB and MySQL? In this blog, we provide an overview of the key differences between MariaDB vs. MySQL and explore their unique use cases.