3601
Around the World with SQLite3 and Rsync
Run sqlite3 dbs in multiple regions with rsync
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
3602
MySQL Text vs. Varchar Performance
Starting with MySQL 5.0.3, the maximum field length for VARCHAR fields was increased from 255 characters to 65,535 characters. This is good news, as VARCHAR fields, as opposed to TEXT fields, are stored in-row for the MyISAM storage engine (InnoDB has different characteristics). TEXT and BLOB fields are not stored…
3603
How Powerful Are Microsoft Azure’s Free Jupyter Notebooks?
For a while now, Microsoft have provided a free Jupyter Notebook service on Microsoft Azure. At the moment they provide compute kernels for Python, R and F# providing up to 4Gb of memory per sessio…
3604
Implementing Backup
How we implemented consistent, distributed, incremental backup in CockroachDB.
3605
Analyzing the Limits of Connection Scalability in Postgres
Why it’s important to improve Postgres connection scalability, plus an analysis on the limits of connection scalability today.
3606
An Introduction to Hierarchical Modeling
A visual explanation of multi-level modeling
3607
The Perilous World of Machine Learning for Fun and Profit
john-foreman.com is your first and best source for information about john foreman. Here you will also find topics relating to issues of general interest. We hope you find what you are looking for!
3608
VisiData in 60 Seconds
Download faa-wildlife-strikes.csv , a dataset of all aircraft-wildlife collisions reported to the Federal Aviation Administration between 2010 and mid-2016.
3609
Building a State of the Art Bacterial Classifier with Fast.ai and Paperspace
In this post, we’re going to be demonstrating how to to build a state of the art Bacterial Classification model on Gradient using the Fast.ai machine learning library.
3610
3611
Generate QR Codes with Pure SQL in PostgreSQL
As my cat woke me up way too early for a Saturday morning, I decided to put all this extra time (and my ChatGPT Pro subscription) into good use and generated a QR-code generator for PostgreSQL, written as a single pure SQL statement. No external libraries or Postgres extension installation needed! The pqr.sql example…
3612
3613
3614
Modelling a Basic Income with Python and Monte Carlo Simulation
Basic Income is a popular policy floating around the internet lately. The idea consists of declaring that the government will pay each living adult a fixed amount of money every month - an amount comparable to a minimum wage job. This policy would then replace all current welfare programs - welfare, unemployment …
3615
3616
Understanding the N + 1 queries problem
In this post, I am going to talk about the N + 1 queries problem. While trying to solve this problem myself recently, I noticed most of the blog posts only talk about the very simple version of the problem and the proposed solutions would break down when the use cases get complex. I will try to get into more depth and…
3617
Disk Utility still can't check and repair APFS volumes and containers (2021)
Don’t waste time trying to discover which files are still open when you want to check or repair an APFS disk and Disk Utility throws an error. Here’s the solution.
3618
HBase Deprecation at Pinterest
Alberto Ordonez Pereira | Senior Staff Software Engineer; Lianghong Xu | Senior Manager, Engineering;
3619
Datomic Pro Starter Edition
The free database designed for immutable values and a time-aware information model.
3620
3621
High Frequency Trading on the Coinbase Exchange
by Andrew Barisser
3622
The effect of switching to TCMalloc on RocksDB memory use
Memory allocator is an important part of the system, so choosing the right allocator for a workload can give huge benefits. Here is a story of how we decreased service memory usage by almost three times.
3623
SQLite builds for WASI since 3.41.0
A short recap of how SQLite now has a WASI build
3624
A one-size-fits-all database doesn't fit anyone
The days of the one-size-fits-all monolithic database are behind us, and developers are using a multitude of purpose-built databases.
3625
3626
DuckDB Isn't Just Fast
A whistlestop tour of the cool bits of DuckDB
3627
Kyoto Tycoon in 2019
I've been interested in using Kyoto Tycoon for some time. Kyoto Tycoon, successor to Tokyo Tyrant , is a key/value database with a number of desirable features:
3628
3629
3630
The Unreasonable Effectiveness of Random Forests
It’s very common for machine learning practitioners to have favorite algorithms. It’s a bit irrational, since no algorithm strictly…