2611
Three things you should never put in your database
There are several things that are not usually appropriate to put into a relational database
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2612
Let's Build a Modern Hadoop
Not just another Hadoop rant — I promise
2613
Summing columns in remote Parquet files using DuckDB
vivym/midjourney-messages on Hugging Face is a large (~8GB) dataset consisting of 55,082,563 Midjourney images - each one with the prompt and a URL to the image hosted on Discord.
2614
A table that should exist in all projects with a database
Links to social profiles of Ioannis Cherouvim
2615
How we made data aggregation on PostgreSQL better and faster
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster.
2616
The next generation of Materialize
Today, we’re excited to announce a product that we feel is transformational: a persistent, scalable, cloud-native Materialize.
2617
Pruning RAG context down to what the answer actually needs
Pruning agent context down to what the answer actually needs, while keeping 96% of recall
2618
Approximate Nearest Neighbor Oh Yeah (Annoy)
Discover the capabilities of Annoy, an innovative algorithm revolutionizing approximate nearest neighbor searches for enhanced efficiency and precision.
2619
2620
Exploring Databases Visually
Things you can do with a terminal emulator that renders images: generate contextual entity-relationship diagrams and navigate your data model from the inside!
2621
Markov Chain Monte Carlo (MCMC) Sampling, Part 1: The Basics (2019)
In this first post of Tweag’s four-part series on Markov chain Monte Carlo sampling algorithms, you will learn about why and when to use them and the theoretical underpinnings of this powerful class of sampling methods. We discuss the famous Metropolis-Hastings algorithm and give an intuition on the choice of its free…
2622
Cloud SQL for PostgreSQL adds high availability and replication
Cloud SQL for PostgreSQL users, we heard you loud and clear, and added support for high availability (HA) and read replicas, helping you ensure your database workloads are fault tolerant.
2623
The Little Redis Book
Karl Seguin's Blog - A mix of coding and creative writing
2624
Global EV Charging Points with Open Charge Map
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
2625
Go and SQLite in the Cloud
Why SQLite and Go in the cloud are a great match, getting started, best practices, and more.
2626
NoSQL vs. RDBMS: Let the flames begin
I’ve been getting solidly flamed recently, as have my former coworkers at Digg, my friends at Twitter, etc. about our adoption and promotion of various NoSQL storage systems. It seems that some DBAs are very, very upset that us internet kids are considering abandoning SQL’s ship. I’m not here to throw out a bunch of…
2627
The Database Inside Your Codebase
Navigating codebases of any meaningful size is difficult. Most of a programmer's time is spent jumping through the codebase, reading or skimming to build a ment...
2628
The Birth of Parquet
15 years ago (2007-2011) I was at Yahoo! working with Map/Reduce and Apache Pig, which was the better Map/Reduce at the time. The Dremel paper just came out and, as everything I worked with seemed to be inspired from Google papers, I read it. I could see it applying to what we were doing at Yahoo! and this was to…
2629
Running Databases on Kubernetes
Things to consider when running a database on Kubernetes.
2630
12 Months with MongoDB
As previously blogged , Wordnik is a heavy user of 10gen’s MongoDB . One year ago today we started the investigation to find an alternative to MySQL to store, find, and retrieve our corpus data. After months of experimentation in the non-relational landscape (and running a scary number of nightly builds), we settled…
2631
Why Use Postgres - Part 2
This post is a list of many of the reasons to use Postgres, much this content as well as how to use these features will later be curated within PostgresGuide.com. If you need to get started check out Postgres.app for Mac, or get a Cloud instance at Heroku Postgres for free Last week I did a post on the many reasons to…
2632
R Passes SAS, but Python Leaves Them Both Behind
Examines market share or popularity of data science software by comparing the number of jobs available for each software package.
2633
SQLite's documentation about its durability properties is unclear
Is SQLite durable by default? What settings guarantee durability? The documentation and even comments from its creator give conflicting answers.
2634
MemoryDB: A fast and durable memory-first cloud database
Amazon MemoryDB for Redis is a database service designed for 11 9s of durability with in-memory performance. In this paper, we describe the architecture of MemoryDB and how we leverage open-source Redis, a popular data structure store, to build an enterprise-grade cloud database. MemoryDB offloads…
2635
Foreign data wrappers: PostgreSQL's secret weapon?
EnterpriseDB (“EDB”), the leader in accelerating Postgres® in the enterprise, today announced its acquisition of Splitgraph, an early-stage disruptor that provides a Postgres compatible serverless SQL API for building data driven applications from hundreds of datasources. This move is seen as a meaningful step in…
2636
2637
Unofficial Guide to Datomic Internals (2014)
This post is a compilation of publicly available information, Datomic docs and google group answers about Datomic internals. Intention is to help others understand implementation model and use Datomic more efficiently.
2638
2639
2640
Pivot – Rows to Columns
Pivot SQL tables with CASE or FILTER. Turn rows into columns for the entity-attribute-value model (EAV).