781
SQLite Release 3.39.0
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. 2,337 posts.
782
Custom SQL functions for data analytics in PostgreSQL
There is a better way to explore and analyze time-series data with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler data.
783
Wikimedia Enterprise announces Google and Internet Archive as first customers
Wikimedia Enterprise announced its first customers: multinational technology company Google and nonprofit digital library Internet Archive. Wikimedia Enterprise was recently launched by the Wikimedia Foundation as an opt-in product.
784
How we made data aggregation on PostgreSQL better and faster
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster.
785
ReadySet Core: next-generation SQL caching, freely available
Today we’re announcing ReadySet Core, a freely available version of ReadySet that you can run anywhere from your own laptop to any cloud provider, on as many nodes as you need.
786
2022 Cloud Report
The 2022 Cloud Report is the only cloud performance report to compare AWS, Azure, and GCP on benchmarks that reflect critical applications and workloads.
787
How Palo Alto Networks Replaced Kafka with ScyllaDB for Stream Processing
Learn how Palo Alto Networks rearchitected their real time data systems using ScyllaDB’s monstrously fast and scalable NoSQL database.
788
Select ’Hello, World’: Serverless Postgres Built for the Cloud
We have just launched Neon to provide you with the best Postgres experience in the cloud. You can sign up to our waitlist right now and experience serverless Postgres enabled by the separation of storage and compute. The service is still gated by the waitlist as we are onboarding more and more users every day, and we…
789
How to create a dashboard in Python with Jupyter Notebook
Learn how to create a dashboard in Python with Jupyter Notebook, including interactive components and sharing options.
790
Important PostgreSQL 14 update to avoid silent corruption of indexes
Join thousands of people who own a premium domain. Affordable financing available.
791
Cache made consistent: Meta’s cache invalidation solution
Caches help reduce latency, scale read-heavy workloads, and save cost. They are literally everywhere. Caches run on your phone and in your browser. For example, CDNs and DNS are essentially geo-rep…
792
MongoDB Releases Queryable Encryption Preview
Today we are announcing the preview release of Queryable Encryption which allows customers to encrypt sensitive data from the client side, store it as fully randomized encrypted data on the database server side, and run expressive queries on the encrypted data. Learn more.
793
DeWitt Clause, or can you benchmark %database% and get away with it
The DeWitt clause lets database vendors forbid publishing benchmarks. What the clause is, which vendors still use it, and what you can legally publish.
794
795
Range joins in DuckDB
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.
796
AlloyDB for PostgreSQL under the hood: Columnar engine
In this technical deep dive, we take a look at the columnar engine that delivers industry leading query performance for AlloyDB for PostgreSQL.
797
Speeding up sort performance in Postgres 15
Deep dive into the sort performance improvements in PostgreSQL 15, along with charts to visualize what types of queries will be faster. Includes speedups in single column sorts, reduced memory consumption with generation memory context, specialized sort routines for common datatypes, & use of k-way merge.
798
How Airbnb Built “Wall” to prevent data bugs
Gaining trust in data with extensive data quality, accuracy, and anomaly checks.
799
Super-Structured Data: Rethinking the Schema
Dealing with real-world data is hard. You often end up stuck between the document model of JSON and the relational model of SQL databases. There's a better way. It's called super-structured data.
800
OpenTelemetry Traces and PostgreSQL
Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.
801
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
802
Time-Series Compression Algorithms
These algorithms aren't magic – but combined they can save over 90% of storage costs and speed up queries. Here’s how 5 common ones work.
803
SQLite in Go, with and Without Cgo
Most people use the mattn/go-sqlite3 package to interact with SQLite in Go. This package uses cgo and bundles the SQLite C amalgamation files with the Go source.
804
Friendlier SQL with DuckDB
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.
805
BERTopic: The Future of Topic Modeling
BERTopic takes advantage of the superior language capabilities of (not yet sentient) transformer models and uses some other ML magic like UMAP and HDBSCAN to produce what is one of the most advanced techniques in language topic modeling today.
806
D1: Our SQL database
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
807
I'm all-in on server-side SQLite
Ben Johnson has joined Fly.io
808
Demystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
809
Backblaze Drive Stats for Q1 2022
Backblaze wants to be as transparent as possible with our customers about our business. Here’s what you need to know about our drives in Q1 2022.
810
Introducing ArcticDB: A Database for Observability
Continuous profiling needed a columnar database, so we built it.