Topics /
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
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.
Support for spatial data and geospatial indexing is one of the most requested features in the history of CockroachDB.
TaBERT is the first model that has been pretrained to learn representations for both natural language sentences and tabular data.
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 […]
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.
Database queries are a pretty surprisingly powerful tool that can solve seemingly intractable problems.
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?
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…
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…
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!
As steer and drplokta pointed out yesterday , the Nielsen diagram was grossly out of proportion, so it looked like RIM and MS were better than they were. I passed the data to steer, who then played around with R (code is in the other post), and produced the second diagram. I've tried to line them…
We believe that charts with two different y-axes make it hard for most people to intuitively make right statements about two data series.
I’m a huge proponent of designing your code around the data, rather than the other way around, and I think it’s one of the reasons git has been fairly successful… I will, in fact, claim that the difference between a bad programmer and a good one is whether he considers his code or his data structures more important…
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).
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
Analysis and visualization of the New York City bike share system
Sculpt AI was built by a team of machine learning experts and SALT.agency and is a code-free AI platform. Keep reading to learn more about the benefits of this.
Discover Snowflake Postgres Mirroring. Learn how push-based change data capture delivers transactional replication to your data lake with zero lag.
An interactive essay on the joys and pitfalls of histograms
Jim Calabro
For quite some time now, i have been working on and off on a fully self-hosted search engine , in hope to make it easier to search across Personal data in an end to end manner. Even as individuals, we are hoarding and generating more and more data with no end in sight. Such "personal" data is being stored from local…
There's some sort of inflection point where a "long read" becomes an "epic article." I'm not quite sure where that inflection point is, bu...
In a previous [0] post I’ve discussed why I ditched sea-query and why sql is almostalways the best way to not re-learn something new from the beginning...
