1291
The Use of assert() in SQLite
The assert(X) macro is part of standard C , in the <assert.h> header file. SQLite adds three other assert()-like macros named NEVER(X), ALWAYS(X), and testcase(X).
New
The latest blog posts to take off on Hacker News. 2,338 posts.
1292
Open-sourcing F14 for memory-efficient hash tables
Hash tables provide a fast way to maintain a set of keys or map keys to values, even if the keys are objects, like strings. They are such a ubiquitous tool in computer science that even incremental…
1293
Technical Challenges Developing a Distributed SQL Database
Here is an outline of some of architectural issues addressed as we build YugabyteDB, our high-performance distributed SQL database.
1294
Python overtakes JavaScript as most questioned language on StackOverflow
Discover some of the most common software bugs that businesses are struggling with and unlock effective strategies to overcome them.
1295
1296
Pyodide: Bringing the scientific Python stack to the browser
Pyodide is an experimental project from Mozilla to create a full Python data science stack that runs entirely in the browser. We think it’s worthwhile to work on moving the ...
1297
1298
The Difference Between SQL’s JOIN .. ON Clause and the Where Clause
A question that is frequently occurring among my SQL training’s participants is: What’s the difference between putting a predicate in the JOIN .. ON clause and the WHERE clause? I can d…
1299
1300
CVE-2019-9193: Not a Security Vulnerability
There is widespread mention in the media of a security vulnerability in PostgreSQL, registered as [CVE-2019-9193](https://nvd.nist.gov/vuln/detail/CVE-2019-9193). The PostgreSQL Security Team …
1301
Migrating 23TB from S3 to B2 in 7 hours
Nodecraft moved 23TB of customer backup files from AWS S3 to Backblaze B2 in just 7 hours, and saved big on egrees fees with Cloudflare's Bandwidth Alliance.
1302
Ice cold archive storage
Get the latest cloud storage news here from Google Cloud, with a new archive storage class and Persistent Disk updates.
1303
PostgreSQL Count(*) Performance Improvements
count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.
1304
PostgreSQL Performance on Raspberry Pi
Have you ever wondered how well PostgreSQL performs on a Raspberry Pi 3B ? Oh. You haven't? Oh well, I asked myself that question and put it to the test. This post covers how I used pgbench to answer this question and the results of what I found.
1305
Unreasonable Effectiveness of SQL
Read Couchbase engineering tutorials, product news, and customer stories on AI agents, Capella, vector search, mobile sync, and real-time analytics.
1306
Amundsen – Lyft’s data discovery and metadata engine
In order to increase productivity of data scientists and research scientists at Lyft, we developed a data discovery application built on…
1307
Averages Can Be Misleading: Try a Percentile (2014)
With the release of Elasticsearch 1.1.0, there is a new metric aggregation available to users: the Percentile metric. Percentiles tell you the value at which a certain percentage of your data is incl...
1308
Build an Air Quality Monitor with InfluxDB, Grafana and Docker on a Raspberry Pi
balenaSense reads temperature- humidity- barometric pressure- and air quality- and provides a dashboard that you can access from anywhere.
1309
Was MongoDB Ever the Right Choice?
I was reading a post recently about Red Hat removing MongoDB support from Satellite (and yes, some folks say it is because of the license changes). It made me think how often over the last few years I’ve seen post after angry post about how terrible MongoDB is and how no one should ever use. However, […]
1310
Jepsen: YugaByte DB 1.1.9
2019-04-10: The long fork test used in this analysis contained a bug which caused it to (in many cases) fail to identify long fork anomalies. We have re-checked YugaByte DB 1.1.15.0-b16 with a corrected checker, and its long fork tests still pass.
1311
Microsoft, UW demonstrate first fully automated DNA data storage
Researchers encode the word “hello” in fabricated DNA, convert it back to digital using fully automated DNA storage system.
1312
Vertically Scaling PostgreSQL
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
1313
Azure Data Studio: An Open-Source GUI Editor for Postgres
When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it’s pretty powerful, but some people much prefer a graphical editor.
1314
Iodide: An experimental Mozilla tool for data exploration on the web
Meet Iodide, an experimental open source tool to help scientists write beautiful interactive documents using web technologies, all within a browser-based iterative workflow that will be familiar to many scientists.
1315
Keeping Open Source Open – Open Distro for Elasticsearch
中文版 – At AWS, we focus on solving problems for customers. Over the years, customer usage and dependencies on open source technologies have been steadily increasing; this is why we’ve long been committed to open source, and our pace of contributions to open source projects – both our own and others’ – continues to…
1316
Beware the data science pin factory: The power of the data science generalist
This post discusses the benefits of full-stack data science generalists over narrow functional specialists. The later will help you execute and bring process...
1317
1318
1319
1320
FaunaDB 2.5.4
In 2012, Thomson, Diamond, Weng, et al. published Calvin: Fast Distributed Transactions for Partitioned Database Systems : a transactional protocol optimized for geographic replication. Each Calvin cluster is comprised of multiple replicas , where a replica is a collection of nodes which store a complete copy of the…