1771
Polars: Company Formation Announcement
We are excited to announce the start of company that will build around Polars, enabling data processing at any scale.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
1772
1773
Microsoft’s visual data explorer SandDance open sourced
SandDance, the beloved data visualization tool from Microsoft Research, has been re-released as an open source project on GitHub.
1774
An all-sky map of half a million supermassive black holes
The Black Hole Mapper reaches a milestone with its first southern hemisphere optical observations, coordinated eROSITA X-ray identification, and multi-epoch tracking of accreting black holes across the universe.
1775
1776
1777
Time-Series Compression Algorithms
These algorithms aren't magic – but combined they can save over 90% of storage costs and speed up queries. Here’s how 5 common ones work.
1778
SQLite Release 3.39.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
1779
You cannot have exactly-once delivery (2015)
I’m often surprised that people continually have fundamental misconceptions about how distributed systems behave. I myself shared many of these misconceptions, so I try not to demean or dismiss but rather educate and enlighten, hopefully while sounding less preachy than that just did. I continue to learn only by…
1780
The Most Gender-Switched Names in the U.S.
We use some names mostly for boys and some mostly for girls, but then there is a small percentage that, over time, switched from one gender to another. Which names made the biggest switch?
1781
The Universal Data Structure
Whether you write compilers, web services or Django admin panels, you probably use hash maps more than all other data structures combined. In fact, you may not remember the last time you used anything else. This is not a coincidence: any conceivable data structure can be implemented with a hash map; therefore, there…
1782
Timestamps and Time Zones in PostgreSQL (2016)
The nuance between timestamp with and without time zone
1783
Build an Air Quality Monitor with InfluxDB, Grafana and Docker on a Raspberry Pi
balenaSense reads temperature- humidity- barometric pressure- and air quality- and provides a dashboard that you can access from anywhere.
1784
Introduction to vector similarity search (2022)
Learn what vector search is and the metrics pertinent to decide the distance (or similarity) between objects.
1785
Etcd v3: increased scale and new APIs
No single cloud fits all. Explore how we build a more flexible future with hybrid cloud.
1786
One Year as a Data Scientist at Stack Overflow
One day in January 2013 I found myself wasting time on the internet.
1787
Playing with 80M Amazon Product Review Ratings Using Apache Spark
Manipulating actually-big-data is just as easy as performing an analysis on a dataset with only a few records.
1788
Using python and k-means to find dominant colors in images
I'm working on a little photography website for my Dad and thought it would be neat to extract color information from photographs. I tried a couple of different approaches before finding one that works pretty well. This approach uses k-means clustering to cluster the pixels in groups based on their color. The center…
1789
1790
1791
1792
Reasons to love SQLAlchemy
I've seen some bashing of ORMs of late, which I think is totally undeserved. I'm a big fan of SQLAlchemy ; I use it in most of my projects, and have contributed code to the library. I'm going to explain 10 good reasons you should love SQLAlchemy too! In fairness, there are a number of good ORMs around, and most of…
1793
PostgreSQL Performance on Raspberry Pi
Have you ever wondered how well PostgreSQL performs on a Raspberry Pi 3B ? Oh. You haven't? Oh well, I asked myself that question and put it to the test. This post covers how I used pgbench to answer this question and the results of what I found.
1794
How to create a dashboard in Python with Jupyter Notebook
Learn how to create a dashboard in Python with Jupyter Notebook, including interactive components and sharing options.
1795
Difference between running Postgres for yourself and for others
At Ubicloud, our managed cloud service enables us to run PostgreSQL for others. We open sourced our implementation, so we thought this was a good opportunity to talk about its features. This blog post summarizes features commonly available in a managed service. It also describes interesting differences between running…
1796
When an SQL Database Makes a Great Pub/Sub
We explore how databases be used as effective Pub/Subs in Go, demonstrating how SQL's unique features can enhance message-driven applications.
1797
Copy-on-write B-tree finally beaten.
Copy-on-write B-tree finally beaten by Andy Twigg, Andrew Byde, Grzegorz Mi?o´s, Tim Moreton, John Wilkesy and Tom Wilkie.
1798
How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design
A discussion of aggregation in PostgreSQL and how it integrates with the design of Timescale’s hyperfunctions.
1799
The 600+ Companies PayPal Shares Your Data With
One of the effects of GDPR—the new EU General Data Protection Regulation—is that we’re all going to be learning a lot more about who collects our data and what they do with it. Consider PayPal, that just released a list of over 600 companies they share customer data with. Here’s a good visualization of that data. Is…
1800
A Critique of SQL, 40 Years Later
Homepage of Carlin Eng