661
New
The latest blog posts to take off on Hacker News. 2,337 posts.
662
Tips for a healthier Postgres database (2021)
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
663
Apache Kafka Beyond the Basics: Windowing
Learn what windowing is, the difference between the four types of windows (hopping and tumbling, or session and sliding), and how to create them.
664
Meilisearch 1.0 – Open-source search engine built in Rust
Meilisearch launches the first completely stable, forward-compatible, and enterprise-ready version of its highly performant open-source search engine.
665
Big data is dead
Big data is dead. Long live easy data. | Reading time: 18 min read
666
The Dutch benefits scandal: a cautionary tale for algorithmic enforcement
On January 15, the Dutch government was forced to resign amidst a scandal around its child-care benefits scheme. Systems that were meant to detect misuse of the benefits scheme, mistakenly labelled over 20,000 parents as fraudsters. More crucially, a disproportionate amount of those labelled as fraudsters had an…
667
Storing OpenAI embeddings in Postgres with pgvector
An example of how to build an AI-powered search engine using OpenAI's embeddings and PostgreSQL.
668
The technology behind GitHub’s new code search
A look at what went into building the world's largest public code search index.
669
Backblaze Drive Stats for 2022
Check out the 2022 year-end Drive Stats data, and let us know your thoughts in the comments.
670
PageRank algorithm for graph databases
What is PageRank algorithm? How can it be used in various graph database use cases? How to use it in Memgraph? If these questions are keeping you up at night, here is a blog post that will finally put your mind at ease.
671
672
673
Choosing a Postgres primary key
Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out
674
AcousticBrainz: Making a hard decision to end the project (2022)
We created AcousticBrainz 7 years ago and started to collect data with the goal of using that data down the road once we had collected enough. We finally got around to doing this recenty, and realised that the data simply isn’t of high enough quality to be useful for much at all.
675
How does it know I want CSV? – An HTTP trick
Forgotten parts of RFC2616
676
677
Apache Hudi vs. Delta Lake vs. Apache Iceberg Lakehouse Feature Comparison
A thorough comparison of the Apache Hudi™, Delta Lake, and Apache Iceberg™ data lakehouse projects across features, community, and performance benchmarks. This includes a focus on common use cases such as change data capture (CDC) and data ingestion.
678
679
Faster MySQL with HTTP/3
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
680
WAL Mode in LiteFS
LiteFS v0.3.0 now supports SQLite's write-ahead log journal mode.
681
Databases in 2022: A Year in Review
Andy Pavlo - Carnegie Mellon University,
682
SQLite 2022 Recap
There have been many improvements to SQLite during 2022. Listed below or just a few of the bigger changes. See the change logs or the trunk timeline for a more complete list of enhancements and improvements.
683
U.S. universities, rich in data, struggle to capture its value, study finds
A UCLA–MIT Press paper highlights a lack of data infrastructure and data strategy in U.S. higher education.
684
Facebook increased satisfaction and usage by sending fewer notifications
We are members of the Facebook Notifications Data Science team at Meta. We ran surveys on how users felt about on-site notifications…
685
WordPress to support SQLite back end
A few months ago, a proposal was published to make WordPress officially support SQLite. After the proposal received a lot of positive feedback from the community, we started working on an implement…
686
Supabase Vault is now in Beta
A Postgres extension to store encrypted secrets and encrypt data.
687
DBT Cloud increase Team plan price by 100% and limit features at the same time
We’re updating the dbt Cloud Developer and Team plans to better reflect product maturity after years of improvements.
688
Supabase Wrappers: A framework for building Postgres foreign data wrappers
A framework for building Postgres Foreign Data Wrappers which connects to Stripe, Firebase, Clickhouse, and more.
689
690
The top programming languages
Explore the top programming languages on GitHub—and what languages are growing the fastest.