1051
Visualizing every job in the world
A visualization of every single job in the world (or at least in the EU)
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1052
Teach your LLM to answer with facts, not fiction
Learn how to train LLM for accurate answers with VectorSQL which allows you to execute finely-grained vector searches to target and retrieve the required information
1053
Why SQLite does not use Git (2018)
The document you seek is not available. Please consider one of the links below or use the Search feature on the right-hand side of the menu bar above.
1054
JPEG XL: How it started, how it’s going
Significance of Apple's support for JPEG XL and what this means for the widespread adoption of this next-generation image compression format.
1055
Full-text search engine with PostgreSQL (part 2): Postgres vs. Elasticsearch
Using PostgreSQL as a full-text search engine is tempting because it requires less infrastructure. But is its set of search-related features enough to compete with the Lucene based alternatives?
1056
Citus 12: Schema-based sharding for PostgreSQL
Release blog post for the 12.0 release of the Citus extension to Postgres. Dive into new Citus 12 features such as schema-based sharding for multi-tenant SaaS applications (and microservices) as well improvements in the Citus support for the Postgres 15 MERGE feature.
1057
Statistical Arbitrage – An Easy Walkthrough
Statistical arbitrage (stat arb) is a pillar of quantitative trading that relies on mean reversion to predict the future returns of an asset. Mean reversion believes that if a stock has risen higher it’s more likely to revert in the short term which is the opposite of a momentum strategy that believes if a stock has…
1058
Bad numbers in the “gzip beats BERT” paper?
The recent paper, “Low-Resource” Text Classification: A Parameter-Free Classification Method with Compressors by Jiang et al. [ link ] recently received a lot of attention on twitter.
1059
PostgreSQL: No More Vacuum, No More Bloat
PostgreSQL, a powerful open-source object-relational database system, has been lauded for its robustness, functionality, and flexibility. However, it is not without its challenges – one of which is the notorious VACUUM process. However, the dawn of a new era is upon us with OrioleDB, a novel engine designed for…
1060
There is no data engineering roadmap
Data Engineering is booming and many are looking for a cheat sheet to get started. Do you really need to learn 200 tools before you get your first job?
1061
Understanding Kafka with Factorio (2019)
While playing Factorio the other day, I was struck by the many similarities with Apache Kafka.
1062
Faster neural networks straight from JPEG (2018)
Uber AI Labs introduces a method for making neural networks that process images faster and more accurately by leveraging JPEG representations.
1063
Creating a search engine with PostgreSQL
PostgreSQL provides the necessary building blocks for you to combine and create your own search engine for full-text search. Let's see how far we can take it.
1064
20x faster than pgvector: HNSW index in Postgres with pg_embedding
We’re excited to announce the release of our pg_embedding extension for Postgres and LangChain! The new pg_embedding extension brings 20x the speed for 99% accuracy to graph-based approximate nearest neighbor search to your Postgres databases. While the pgvector extension with IVFFlat indexing has been a popular…
1065
1066
UCLA professor refuses to cover for Dan Ariely in issue of data provenance
In one of the more bizarre twists of the Dan Ariely saga, there is a huge issue of provenance in one of Dan Ariely’s studies. The study in question is Dan Ariely’s Ten Commandments study at JMR. The hugely impactful paper has over 3,000 citations but unfortunately failed to replicate in a large-scale systematic…
1067
HTTP vs. WebSockets: Which one is the fastest for Postgres queries at the edge?
Faster is always better, especially when executing SQL queries. We recently introduced SQL-over-HTTP to our driver, which previously only supported WebSockets. Why did we do that? And which approach is faster? Our journey developing the WebSockets serverless driver We first developed the Neon driver to help developers…
1068
1069
ScyllaDB is Moving to a New Replication Algorithm: Tablets
How moving from Vnode-based replication to tablets helps dynamically distribute data across the cluster, ultimately increasing ScyllaDB’s elasticity.
1070
We put a distributed database in the browser and made a game of it
TigerBeetle is a distributed financial transactions database, designed for mission critical safety. How do you test something so critical? Well, we could tell you (and we will), but why not show you?
1071
Introduction to vector similarity search (2022)
Learn what vector search is and the metrics pertinent to decide the distance (or similarity) between objects.
1072
Git and Jupyter Notebooks Guide
We show you best practices, workflows, and tools to solve all Jupyter Notebooks <--> Git challenges.
1073
PlanetScale Scaler Pro
See how Scaler Pro combines the best of our current plans for companies of all sizes while enabling you to grow with the best database for serverless.
1074
Demystifying Text Data with the Unstructured Python Library
In the world of data, textual data stands out as being particularly complex. It doesn’t fall into neat rows and columns like numerical data does. As a side project, I’m in the process of developing my own personal AI assistant. The objective is to use the data within my notes and documents to answer my questions. The…
1075
LiteFS Cloud: Distributed SQLite with Managed Backups
Documentation and guides from the team at Fly.io.
1076
Our Journey with Apache Arrow (Part 2): Adaptive Schemas and Sorting
In the previous article, we discussed our use of Apache Arrow within the context of the OpenTelemetry project. We investigated various techniques to maximize the efficiency of Apache Arrow, aiming to find the optimal balance between data compression ratio and queryability. The compression results speak for themselves…
1077
SQLite-based databases on the Postgres protocol? Yes we can
libSQL “server mode” (sqld) enables access to SQLite-based databases using Postgres and HTTP network protocols.
1078
Things that surprised me while running SQLite in production
I've been using SQLite in several production projects for six months, and I've encountered some surprising aspects.
1079
Joins 13 Ways
Relational (inner) joins are really common in the world of databases, and one weird thing about them is that it seems like everyone has a different idea of what they are. In this post I’ve aggregated a bunch of different definitions, ways of thinking about them, and ways of implementing them that will hopefully be…
1080
Are You Sure You Want to Use MMAP in Your Database Management System? (2022)
MMAP Databases = 💩