571
Git and Jupyter Notebooks Guide
We show you best practices, workflows, and tools to solve all Jupyter Notebooks <--> Git challenges.
New
The latest blog posts to take off on Hacker News. 2,337 posts.
572
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.
573
LiteFS Cloud: Distributed SQLite with Managed Backups
Documentation and guides from the team at Fly.io.
574
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…
575
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.
576
Are You Sure You Want to Use MMAP in Your Database Management System? (2022)
MMAP Databases = 💩
577
Case study: Algorithmic trading with Go
In this case study, we are excited to share an insider's perspective and look under the hood of how a Massive.com customer built an automated retail trading bot that is capable of monitoring the entire stock market in real-time.
578
579
Around the World with SQLite3 and Rsync
Run sqlite3 dbs in multiple regions with rsync
580
Unexpected downsides of UUID keys in PostgreSQL
Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.
581
Representing Enums in PostgreSQL
Recently, we had a discussion about whether we should use native enums in PostgreSQL, or rely on regular string columns with CHECK constraints. In the end, we decided that we wanted to go with the latter.
582
Getting 10TB of GitHub logs and extracting details of all users and repositories
Trickest workflow parses 15TB of GitHub Archive logs and extracts public details for every user and repository back to 2015.
583
584
Why PostgreSQL High Availability Matters and How to Achieve It
Achieving PostgreSQL high availability is vital for application uptime. Explore popular HA deployment options to make an informed choice that fits your needs.
585
586
Daft: A High-Performance Distributed Dataframe Library for Multimodal Data
Discover how Daft accelerates multimodal data processing with a high-performance distributed dataframe engine built for modern AI and analytics tasks.
587
Why SQLite is so great for the edge
Everyone already knows that SQLite is great. This article makes the praise much more specific though — it explains why we, the developers of libSQL, think that SQLite is a great choice for bringing your data to the edge.
588
The growing pains of database architecture
How the Figma infrastructure team reduced potential instability by scaling to multiple databases
589
Open-Source Data Collection Platform for LLM Fine-Tuning and RLHF
We are thrilled to introduce Argilla Feedback, completely open-source and designed to enhance the performance, safety and reliability of Large Language Models.
590
591
SVG Images from Postgres
We are excited to announce a new set of functions to generate svgs from Postgres and PostGIS! This gives you really easy maps, images, or charts directly from your database. Once you start reading through these samples, you'll want to start playing with images from your database.
592
When LIMIT 9 works but LIMIT 10 hangs
I got a Slack message from colleagues at a major partner. They’d updated their dev environment to support WebSockets, so that Neon’s serverless driver could be used there, but then they’d run into a weird issue. The nub of it was this: This hangs: This works Reproducibly, the query without an ORDER BY ran fine […]
593
594
ChatGPT plugins now support Postgres and Supabase
Supabase recently contributed to the OpenAI Retrieval Plugin repo with a Postgres and a Supabase implementation to help developers build ChatGPT plugins using pgvector.
595
PostgreSQL 16 Beta 1
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 16 is now [available for download](https://www.postgresql.org/download/). This …
596
SQLite builds for WASI since 3.41.0
A short recap of how SQLite now has a WASI build
597
WebAssembly is eating the database?
User-Defined Functions: powered by WebAssembly
598
CRDT Benchmarks
Open-source TypeScript library for collaborative JSON editing powered by CRDTs.
599
D1: Improvements to performance and scalability
We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.
600
