1321
New
The latest blog posts to take off on Hacker News. 2,338 posts.
1322
Noise Mapping with KSQL, a Raspberry Pi and a Software-Defined Radio
Our new cat, Snowy, is waking early. She is startled by the noise of jets flying over our house. Can I determine which plane is upsetting her by utilizing open source streaming solutions (Apache Kafka®), KSQL (the streaming SQL engine for Apache Kafka) a…
1323
1324
MySQL Challenge: 100k Connections
It's not beyond possibility to set up MySQL to achieve 100,000 concurrent connections if you balance network config and use thread pools. By Vadim Tkachenko
1325
Linux Fsync Issue for Buffered IO and Its Preliminary Fix for PostgreSQL
With the latest upgrades to PostgreSQL the fsync failure had been fixed. Avinash Vallarapu takes a look at why this issue might cause problems.
1326
Why Julia
it's faster than other scripting languages, allowing you to have the rapid development of Python/MATLAB/R while producing code that is as fast as C/Fortran
1327
Useful Postgres Extension: Pg_stat_statements
Inspired by a talk in the PostgreSQL devroom at FOSDEM, a post on the usefulness of the pg_stat_statements extension to Postgres and why every Postgres developer should have it in their toolbox. With sections on getting started, and how to extract insights with pg_stat_statements.
1328
Forecasting in Python with Prophet
A guided walkthrough of how to use the Prophet python library to solve a common forecasting problem.
1329
1330
1331
Red Hat Satellite to standardize on PostgreSQL backend
Red Hat Satellite is a complex offering and we wanted to spend some time talking about the underlying databases that make Satellite work as well as some upcoming changes to this underlying database structure that you should be aware of.
1332
1333
1334
Move Fast and Migrate Things: How We Automated Migrations in Postgres
At Benchling, we’re building a platform to help scientists do research. Hundreds of thousands of scientists across academia and enterprise…
1335
Why Nasa Converted Its Lessons-Learned Database into a Knowledge Graph
Learning from mistakes—your own and those made by others—is a mark of effective organizations. Fostering a learning environment means seeing every...
1336
1337
1338
Faster hash joiner with vectorized execution
How we built a 40x faster hash joiner using vectorized execution.
1339
Google Cloud Firestore NoSQL database is in GA
The Cloud Firestore database is a NoSQL, serverless solution for mobile and web application development -- now generally available globally.
1340
1341
CockroachDB's Consistency Model
CockroachDB's consistency model fits somewhere between serializability and linerarizability. We're proposing a new marketing phrase for CRDB's guarantees: no stale reads.
1342
Microsoft acquires Citus Data (YC S11)
Data and analytics are increasingly at the center of digital transformation, with the most leading-edge enterprises leveraging data to drive customer acquisition and satisfaction, long-term strategic planning, and expansion into net new markets. This digital revolution is placing an incredible demand on technology…
1343
1344
Backblaze Hard Drive Stats for 2018
This review looks at the hard drive failure rates by make and model for 100,000+ disk drives in operation in our data centers.
1345
Building CockroachDB on top of RocksDB
CockroachDB uses RocksDB for its storage engine because of RocksDB's rich feature set, which is necessary for a complex product like a distributed SQL database.
1346
ScyllaDB Open Source 3.0
With the release of ScyllaDB Open Source 3.0, we’ve introduced a rich set of new production-ready features that surpass the capabilities of Apache Cassandra.
1347
Oklahoma Department of Securities Leaked Millions of Files
A storage server configured for public access exposed millions of files belonging to the Oklahoma Securities Commission.
1348
President Signs Government-Wide Open Data Bill
The Data Coalition is dedicated to improving government, business, and society through open data and evidence-informed public policy
1349
FoundationDB Record Layer
Today, we are excited to announce the open source release of the FoundationDB Record Layer!
1350
Say no to Venn diagrams when explaining SQL joins (2016)
In recent times, there have been a couple of tremendously popular blog posts explaining JOINs using Venn Diagrams. After all, relational algebra and SQL are set oriented theories and languages, so …