1351
Seeing Like a Data Structure
Our data-centric way of seeing the world isn't serving us well. Barath Raghavan and Bruce Schneier argue that we need new socio-technical systems that leave room for the inherent messiness of reality.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
1352
1353
1354
Cloudera taken private for $5.3B, acquires Datacoral and Cazena
Cloudera Blog is your source for expert guidance on the latest data and AI trends, technology innovation, best practices, success stories, and more.
1355
1356
Moving a billion Postgres rows on a $100 budget
Inspired by the 1BR Challenge, I wanted to see how much it would cost to transfer 1 billion rows from Postgres to Snowflake. Moving 1 billion rows is no…
1357
1358
Give me /events, not webhooks
Learn about the challenges of webhooks for service-to-service notifications. And why an `/events` endpoint is often preferable.
1359
De-anonymizing ransomware domains on the dark web
* We have developed three techniques to identify ransomware operators' dark websites hosted on public IP addresses, allowing us to uncover previously unknown infrastructure for the DarkAngels, Snatch, Quantum and Nokoyawa ransomware groups. * The methods we used to identify the public internet IPs involved matching…
1360
IPv6 Support for Amazon S3
Update October 1, 2021 – This post has been edited to remove outdated S3 buckets. As you probably know, every server and device that is connected to the Internet must have a unique IP address. Way back in 1981, RFC 791 (“Internet Protocol”) defined an IP address as a 32-bit entity, with three distinct network […]
1361
Efficient String Compression for Modern Database Systems
CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools and tomorrow’s challenges.
1362
Tips for Shipping Data Products Fast
Shipping a new data-centric product is hard, and under tight time constraints it's even harder. Here are 4 tips that are proven to help you ship new products fast.
1363
PostgreSQL 15: Stats Collector Gone? What’s New?
Yes, the stats collector is gone from PostgreSQL 15, but there's lots of new exciting features to talk about!
1364
We are splitting our database into Main and CI
We are splitting our database into Main and CI to improve the scalability and reliability of GitLab.com.
1365
1366
Postgres Count Performance
Everybody counts, but not always quickly. This post looks into how the PostgreSQL database optimizes counting. In Postgres, there are ways to count orders of magnitude faster. We’ll look at exact counts (distinct counts) as well as estimated counts, using approximation algorithms such as HyperLogLog (HLL) in Postgres.
1367
How we built scalable spatial indexing in CockroachDB
Support for spatial data and geospatial indexing is one of the most requested features in the history of CockroachDB.
1368
TaBERT: A new model for understanding queries over tabular data
TaBERT is the first model that has been pretrained to learn representations for both natural language sentences and tabular data.
1369
Amazon S3 Lifecycle Management for Versioned Objects
Today I would like to tell you about a powerful new AWS feature that bridges a pair of existing AWS services and makes another pair of existing features far more useful! Let’s start with a quick review. S3 & Versioned Objects I’m sure that you already know about Amazon S3. First launched in 2006, S3 […]
1370
Math in Data Science
Find out how much math is involved in data science and what math you need to know to get started in a data science role.
1371
Have the Tables Turned on NoSQL?
NoSQL was the next big thing in system architecture in 2011, but overall interest in it has plateaued recently. What is NoSQL, what does it have to do with modern development, and is it worth implementing in your project?
1372
Let’s make WordPress officially support SQLite
WordPress can be (and is) used for any kind of site, regardless of size or complexity. Some common use-cases include: Single-page landing sitesSimple company sites with just a few pages. These site…
1373
Amazon RDS on Graviton2 Processors
I recently wrote a post to announce the availability of M6g, R6g and C6g families of instances on Amazon Elastic Compute Cloud (Amazon EC2). These instances offer better cost-performance ratio than their x86 counterparts. They are based on AWS-designed AWS Graviton2 processors, utilizing 64-bit Arm Neoverse N1 cores…
1374
InfluxDB v0.10 GA with hundreds of thousands writes/sec, 98% better compression
The team at InfluxData is excited to announce the stable version of InfluxDB 0.10! Read about it here and see what are the new changes!
1375
The case against dual axis charts (and what to use instead) (2018)
We believe that charts with two different y-axes make it hard for most people to intuitively make right statements about two data series.
1376
1377
PostgreSQL used fsync incorrectly for 20 years (2019) [video]
About a year ago the PostgreSQL community discovered that fsync (on Linux and some BSD systems) may not work the way we always thought it is, with possibly disastrous consequences for data durability/consistency (which is something the PostgreSQL community really values).
1378
Why Semantic Layers Matter (and how to build one with DuckDB)
Learn what a semantic layer is, why it matters, and how to build a simple one with DuckDB and Ibis using just YAML and Python | Reading time: 22 min read
1379
1380