331
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.
New
The latest blog posts to take off on Hacker News. 371 posts.
332
Big data is dead
Big data is dead. Long live easy data. | Reading time: 18 min read
333
They say that stocks go down during the day and up at night
Prompted by your blog post this morning, I attach a plot from Figure 3 of They Still Haven’t Told You showing overnight and intraday returns to AIG (with logarithmic vertical scale, updated with data through the end of October).
334
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…
335
Storing OpenAI embeddings in Postgres with pgvector
An example of how to build an AI-powered search engine using OpenAI's embeddings and PostgreSQL.
336
The technology behind GitHub’s new code search
A look at what went into building the world's largest public code search index.
337
Backblaze Drive Stats for 2022
Check out the 2022 year-end Drive Stats data, and let us know your thoughts in the comments.
338
SQL should be the default choice for data transformation logic
SQL should be the first option considered for new data engineering work. It’s robust, fast, future-proof and testable. With a bit of care, it’s clear and readable.
339
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.
340
A baffling scale transform on a chart of university course selection trends
Harvard Magazine printed the following chart that confirms a trend in undergraduate majors that we all know about: students are favoring STEM majors at the expense of humanities.
341
342
343
Features I'd Like in PostgreSQL
I’ve put in my fair share of time with PostgreSQL. It has no shortage of functionality and I believe its expansive feature set drove a lot of its growing popularity in the 2010s. As my time with the database has worn on I’ve come up with a handful of features that I wish the database had. Some of these are ideas…
344
The magic of small databases
Notes on personal libraries, collections and small indexes on the web
345
Surviving without a superuser in Postgres 16
As I've written about before , a PostgreSQL superuser always has the ability to take over the operating system account in which PostgreSQL i...
346
347
348
How to implement Q&A against your docs with GPT3 embeddings and Datasette
If you’ve spent any time with GPT-3 or ChatGPT, you’ve likely thought about how useful it would be if you could point them at a specific, current collection of text …
349
Replacing Pandas with Polars
I remember those days, oh so long ago, it seems like another lifetime. I haven’t used Pandas in many a year, decades, or whatever. We’ve all been there, done that. Pandas I mean. I would dare say it’s a rite of passage for most data folk. For those using Python, it’s probably one of the […]
350
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
351
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.
352
Short, friendly base32 slugs from timestamps
~4 lines of Go to produce succinct, stable, URL-friendly slugs from timestamps.
353
Datasette is my data hammer
If you're exploring or publishing data, you should give this open source tool a go.
354
How does it know I want CSV? – An HTTP trick
Forgotten parts of RFC2616
355
356
CTEs as lookup tables
How to use a CTE instead of complicated CASE expressions
357
Bullshit graph database performance benchmarks
Hey HackerNews, let me just drop my mixtape, checkout my soundcloud and “Death Row” is the label that pays me. How is the Graph Database category supposed to grow when vendors keep spou…
358
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.
359
Faster PostgresSQL to BigQuery Transfers
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
360
We're wasting money by only supporting gzip for raw DNA files
Stylised graphics of money with DNA helix in the foreground.