1021
SQLite 3.43
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 .
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1022
1023
Open source LLM with 32k Context Length
Following up on the work from our previous blog post, we are releasing today an arXiv paper titled “Giraffe: Adventures in Expanding Context Lengths in LLMs”. Giraffe is a new family of models that are...
1024
The broad set of computer science problems faced at cloud database companies
A couple of weeks ago, I was in an internal meeting where our CTO (Adam Prout) was giving a talk to our summer interns. The talk was about the current state of database companies, and how different providers are competing on different facets of their products. As the talk was
1025
All of the vehicle license plates available in America
States now offer a vast menu of personalized plate options for a dizzying array of organizations, professions, sports teams, causes and other groups.
1026
Most companies do not need Snowflake or Databricks
The cost for something that can be replicated free and open source is absurd. The Fortune 100 have a use case for these companies, the rest…
1027
1028
Pg_later: Asynchronous Queries for Postgres
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
1029
Retrieving 1TB of data from a faulty drive with the help of woodworking tools
So, a while ago I built a gaming PC with the following specification: Case Dan A4 v4.1 Motherboard Z690I Strix Gaming Pro...
1030
1031
Uses and abuses of cloud data warehouses
Data Warehouses are great for many things but often misused for operational workloads.
1032
Modern CSV version 2
And I think you’ll love it. I focused on several areas: Improved UI and user experience Faster performance Useful features Updated documentation For Mac users, Native Apple Silicon (ARM – M1, M2) compatibility If that’s all you need to know, you can buy a license here. Or if you already have a version 1 license, you…
1033
Analysis of the data job market using HN job posts
I parse HackerNews (HN) “Ask HN: Who is hiring?” posts from 2013 to time of writing and analyse them to better understand the trends in the data job market with a focus on the fate of data science. Here are my main conclusions:
1034
Python: Just Write SQL
I have been writing a lot more Go this past year. For those not familiar, Go favours a non-ORM, non-query-builder approach to interacting with databases. This comes naturally due to the sql package : A common interface to be used alongside database drivers. It’s very common to see actual SQL in Go, even in large…
1035
1036
1037
1038
When did Postgres become cool?
Craig takes a look at the history of Postgres. From the origins of the project through some of the key production features that make Postgres what it is today.
1039
Kafka is dead, long live Kafka
Chances are you probably had a strong reaction to the title of this post. In our experience, Kafka is one of the most polarizing technologies in the data space. Some people hate it, some people swear by it, but almost every technology company uses it.
1040
Polars: Company Formation Announcement
We are excited to announce the start of company that will build around Polars, enabling data processing at any scale.
1041
1042
Which vector database should I use? A comparison cheatsheet
Semantic search and retrieval-augmented generation (RAG) applications require systems to be able to save lots of embedding vectors…
1043
So, you want to deploy on the edge?
Application developers often deploy their apps into a single area, generally represented by a handful of AZs in a single region. No matter where their …
1044
Gzip beats BERT? Part 2: dataset issues, improved speed, and results
Summary : Update to my last post analyzing the gzip+knn paper. Some of the datasets have heavily contaminated train/test tests. I show some ways to significantly speed-up the gzip method. I present more results of my "fair" reimplementation .
1045
Ways to shoot yourself in the foot with Redis
Personal website of Phil Booth
1046
LLaMA2 Chat 70B outperformed ChatGPT
AlpacaEval an LLM-based automatic evaluation that is fast, cheap, and reliable. It is based on the AlpacaFarm evaluation set, which tests the ability of models to follow general user instructions. These responses are then compared to reference responses (Davinci003 for AlpacaEval, GPT-4 Preview for AlpacaEval 2.0) by…
1047
SQLite Begin Concurrent
Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands.
1048
Data diffs: Algorithms for explaining what changed in a dataset (2022)
tl;dr: part 1 explains what an explanation algorithm is, and part 2 describes an open source SQL data differ.
1049
1050
WordPress Core to start using SQLite
This post is an update to the proposal for officially support SQLite in WordPress. The initial implementation was included in the Performance Lab plugin and then released as a stand-alone plugin. T…