1561
PostgreSQL: Kubegres is available as open source
[Kubegres](https://www.kubegres.io) is an open-source Kubernetes operator allowing to deploy a cluster of PostgreSql instances with data replication enabled out-of-the box. …
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
1562
Shopify's Data Science and Engineering Foundations (2020)
Shopify’s Data team uses these foundational approaches to data warehousing and analysis empowering us to deliver the best results for our ecosystem.
1563
1564
Wyvern's Open Satellite Feed
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
1565
When Citi Bikes Are Faster Than Taxis in New York City
Over 50% of peak hour taxi trips would be faster as Citi Bike rides, and taxis are only getting slower
1566
UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
How to decide what to use for autogenerated primary keys: UUID, serial or identity column? Recommendations are given!
1567
The program is the database is the interface
That transfer to John Smith isn't covered by any of the tagging rules. So I select the date, switch to the editor window and paste the date into the date->tag definition:
1568
1569
Goodreads offloads DynamoDB tables to S3 and queries them with Athena
In this post, we show you how to export data from a DynamoDB table, convert it into a more efficient format with AWS Glue, and query the data with Athena. This approach gives you a way to pull insights from your data stored in DynamoDB.
1570
1571
How to Store Data on Paper?
How to print my voice? How to put music on paper? How to print an executable program? All this boils down to storing digital data on paper. This is also called paper data storage . Arrived in this domain from poetry, I’ve been investigating the area for some time. Here is what I found.
1572
How discord stores billions of messages (2017)
We decided early on to store all chat history forever so users can come back at any time and have their data available. This is a lot of data: how do we do it?
1573
Optimizing Postgres table layout for maximum efficiency
Introduction When modeling a Postgres database, you probably don’t give much thought to the order of columns in your tables. After all, it seems like the kind of thing that wouldn’t affect storage or performance. But what if I told you that simply reordering your columns could reduce the size of your tables and…
1574
1575
How We Found All of Optimizely's Clients
Search Engine For Source Code. Find websites using technology, HTML, Javascript, CSS Tags.
1576
1577
Data diffs: Algorithms for explaining what changed in a dataset (2022)
tl;dr: part 1 explains what an explanation algorithm is, and part 2 describes an open source SQL data differ.
1578
Distributed Consensus – How Shared Data Is Stored
If you don’t work in computers, you probably haven’t spent much time thinking about how data gets stored on computers or in the cloud. I’m…
1579
1580
1581
Improvements to data analysis in ChatGPT
Improvements to data analysis in ChatGPT Interact with tables and charts and add files directly from Google Drive and Microsoft OneDrive.
1582
Searching 20 GB/sec: Systems Engineering Before Algorithms
SentinelOne unifies AI-powered endpoint, cloud, identity, and data protection—enhanced by our Security Data Lake for seamless and efficient cybersecurity.
1583
5NF and Database Design
Author: Alexey Makhotkin squadette@gmail.com, (~3900 words) One of the goals of this publication is to deconstruct the traditional ways of teaching basic topics in relational databases. Previously we discussed the fourth normal form (4NF): “Historically, 4NF explanations are needlessly confusing”. Let’s discuss the…
1584
An introduction to data processing on the Linux command line
This article will provide the reader with a brief overview for a number of different Linux commands. A special emphasis will be placed on explaining how each command can be used in the context of performing data science tasks. The goal will be to convince the reader that each of these commands can be extremely useful…
1585
Postgres 11 Beta 1 released
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 11 is now available for download. This …
1586
What Kagglers Are Using for Text Classification
With the problem of Image Classification is more or less solved by Deep learning, Text Classification is the next new developing theme in deep learning. For those who don’t know, Text classification is a common task in natural language processing, which transforms a sequence of text of indefinite length into a…
1587
Jepsen: Dgraph 1.1.1
Dgraph is a graph database which aims to provide scalable, highly-available, and snapshot-isolated transactions over a labeled directed graph, while minimizing network communication for performance. Conceptually, Dgraph stores a set of (entity, attribute, value) triples. Entities (also known as subjects), are compact…
1588
1589
Good CTE, Bad CTE
The planner treats CTEs very differently depending on how you write them. Here's what happens under the hood, version by version, through PostgreSQL 18.
1590
DuckDB 1.1.0 Released
The DuckDB team is happy to announce that today we're releasing DuckDB version 1.1.0, codenamed “Eatoni”.