3361
Diffing Coronaviruses
Comparing the genome sequences of the Wuhan coronavirus and a bat coronavirus using `diff` and NCBI BLAST reveals an 89% similarity.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
3362
Make Patterns Pop Out of Heatmaps with Seriation (2018)
One of the easiest ways to start visualizing data is to turn a table into a heatmap: every cell gets a colour, the higher the number the brighter the colour. Unfortunately, this is often a fairly unrewarding exercise, yielding graphics that look like plaid or tartan fabric. Part of the problem is that the rows and…
3363
Uber's Move Away from PostgreSQL
Last week, a blog post by an Uber engineer explained why Uber chose to move from PostgreSQL to MySQL . This article was widely reported and...
3364
MitM-ing Postgres
I recently had to set up a new postgres instance at work. While we’re already using Heroku Postgres for production loads, we had some requirements for this one that couldn’t be solved without being database admin, and thus had to go self-hosted. That...
3365
Optimizers: The Low-Key MVP
The query optimizer is an important part of any analytical database system as it provides considerable performance improvements compared to hand-optimized queries, even as the state of your data changes.
3366
3367
MongoDB is to NoSQL like MySQL to SQL - in the most harmful way
MySQL and MongoDB are both popular, yet poor representatives of their species
3368
Understanding ETF “Flash Crashes”
Join your peers in reading the latest perspectives and insights from FactSet experts across topics that matter to you.
3369
3370
3371
Amazon Aurora with PostgreSQL Compatibility
Late last year I told you about our plans to add PostgreSQL compatibility to Amazon Aurora. We launched the private beta shortly after that announcement, and followed it up earlier this year with an open preview. We’ve received lots of great feedback during the beta and the preview and have done our best to make […]
3372
Data Wrangling at Slack
For a company like Slack that strives to be as data-driven as possible, understanding how our users use our product is essential. The Data Engineering team at Slack works to provide an ecosystem to help people in the company quickly and easily answer questions about usage, so they can make better and data informed…
3373
Why Cassandra Doesn't Need Vector Clocks
Deepening watsonx capabilities to address enterprise gen AI data needs with DataStax.
3374
AWS Managed Workflows for Apache Airflow
As the volume and complexity of your data processing pipelines increase, you can simplify the overall process by decomposing it into a series of smaller tasks and coordinate the execution of these tasks as part of a workflow. To do so, many developers and data engineers use Apache Airflow, a platform created by the…
3375
3376
The challenges of supporting foreign key constraints
Today, PlanetScale launched support for foreign key constraints. This article covers some of the behind-the-scenes technical challenges we had to overcome to support them.
3377
Ask questions of SQLite databases and CSV/JSON files in your terminal
I built a new plugin for my sqlite-utils CLI tool that lets you ask human-language questions directly of SQLite databases and CSV/JSON files on your computer. It’s called sqlite-utils-ask. Here’s …
3378
Ggplot2 version 2.0.0 released by Hadley Wickham
ggplot2 2.0.0: official extension mechanism, new geoms (geom_count, geom_curve, geom_label), appearance tweaks, and facet labels.
3379
3380
A Statistical Portrait of a Y Combinator Batch
ไลฟ์สไตล์ ธุรกิจ กีฬา ไอที บันเทิง แม่และเด็ก ความรู้รอบตัว รถยนต์ สัตว์เลี้ยง อสังหาริมทรัพย์ กิน-เที่ยว การเงินและการลงทุน สุขภาพ การศึกษา บ้านและสวน
3381
K-Nearest Neighbors
One Machine Learning algorithm that relies on the concepts of proximity and similarity is K-Nearest Neighbor (KNN). KNN is a supervised learning algorithm capable of performing both classification and regression tasks.
3382
3383
Thread-Per-Core Buffer Management for a modern storage system
Redpanda powers an Agentic Data Plane and Data Streaming platform for real-time performance, AI innovation, and simplified operations.
3384
Project Jupyter Celebrates 20 Years, Fernando Pérez Reflects on How It Started
UC Berkeley Division of Computing, Data Science and Society2021118 points34 commentsDatabases & Data details
Twenty years ago, UC Berkeley Associate Statistics Professor Fernando Pérez started one of the foundational tools for analyzing large amounts of data in a transparent and collaborative way. We spoke with Pérez about why he started this project, what challenges he’s faced and what to expect from him and Project Jupyter…
3385
3386
RethinkDB 1.11 is out: query profiler, new streaming algorithm, devops features
Today, we’re happy to announce RethinkDB 1.11 ( Breakfast at Tiffany’s ), which improves the experience of operating live RethinkDB deployments. Download it now!
3387
Reduce GPS data error on Android with Kalman filter and accelerometer
IT blog about developing and managing enterprise-level software solutions for blockchain, fintech, transportation & logistics, security, edtech, and advertising industries.
3388
Map Simplification with Visvalingam's Algorithm
An interesting challenge in cartography is getting data of the appropriate resolution. As Lewis Fry Richardson observed , the more precisely you measure the length of a coastline, the longer it appears; geographic shapes have infinite complexity. Digital displays, in contrast, are limited by pixels. Choosing too high…
3389
Dumb statistical models, always making people look bad
This is Jessica. In my Prediction for Decision-making class last quarter we talked about human predictions and decisions relative to algorithmic ones. This led to a discussion about why it’s often hard to demonstrate the value of human knowledge once you have a decent statistical model.
3390