SQLite small blob storage: 35% Faster Than the Filesystem
SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 4,916 posts.
SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().
An SQLite database file with a defined schema often makes an excellent application file format. Here are a dozen reasons why this is so:
Explore data on COVID-19 vaccinations across the world.
Facebook owner Meta’s dangerous algorithms and reckless pursuit of profit substantially contributed to the atrocities perpetrated by the Myanmar military against the Rohingya people in 2017, Amnesty International said in a new report published today.
Build your software factory on Warp: factories as code, any model or harness, with evals, benchmarks, and self-improvement built in.
The American pattern of development creates the illusion of wealth. Today we are in the process of seeing that illusion destroyed…and with it the prosperity we have come to take for granted.
Posted by Ian Beer & Samuel Groß of Google Project Zero We want to thank Citizen Lab ...
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully…
Guide on using remote attestation in a way that's compatible with GrapheneOS.
PEP 3107 introduced syntax for function annotations, but the semantics were deliberately left undefined. There has now been enough 3rd party usage for static type analysis that the community would benefit from a standard vocabulary and baseline tools w...
"Political language... is designed to make lies sound truthful and murder respectable, and to give an appearance of solidity to pure wind."
How much do electricity, transport, and land use contribute to different greenhouse gas emissions?
In fiscal year 2014, the federal government will spend around $3.8 trillion. These trillions of dollars make up a considerable chunk - around 22 percent - of the US. economy, as measured by Gross Domestic Product (GDP). That means that federal government spending makes up a sizable share of all money spent in the…
by John Perry Barlow Governments of the Industrial World, you weary giants of flesh and steel, I come from Cyberspace, the new home of Mind. On behalf of the future, I ask you of the past to leave us alone. You are not welcome among us. You have no sovereignty where we gather.We have no elected...
In the beginning there was NCSA Mosaic , and Mosaic called itself NCSA_Mosaic/2.0 (Windows 3.1) , and Mosaic displayed pictures along with text, and there was much rejoicing.
Once Stripe is supported in your country, you’ll be able to accept payments from customers anywhere in the world.
Death rates are measured based on deaths from accidents and air pollution per terawatt-hour of electricity.
In order to make progress against poverty in the future, we need to understand poverty around the world today and how it has changed.
Quarterly Bulletin 2014 Q1
Because our product is written in C++, which can easily be compiled into WebAssembly, Figma is a perfect demonstration of this new format’s power.
In early 1982, the Lisa software team was trying to buckle down for the big push to ship the software within the next six months. Some of the managers decided that it would be a good idea to track the progress of each individual engineer in terms of the amount of code that they wrote from week to week. They devised a…
We are the home of quality software such as dwm , dmenu , st and plenty of other tools , with a focus on simplicity, clarity and frugality. Our philosophy is about keeping things simple, minimal and usable. We believe this should become the mainstream philosophy in the IT sector. Unfortunately, the tendency for…
Get the key facts about CrowdStrike's work with the Democratic Natiional Committee in 2016 and debunk the false claims that have been made about our work.
Anthropic's latest interpretability research: a new microscope to understand Claude's internal mechanisms
The Chromium project finds that around 70% of our serious security bugs are memory safety problems . Our next major project is to prevent such bugs at source.
Reproducibility is a bedrock of scientific progress. However, it’s remarkably difficult to get reproducible results out of large language models. For example, you might observe that asking ChatGPT the same question multiple times provides different results. This by itself is not surprising, since getting a result from…