Django SQLite Production Config
Optimize your Django SQLite configuration for production.
Topics /
The most popular blog posts about software engineering on Hacker News. 1,116 posts.
Optimize your Django SQLite configuration for production.
Projects and articles by Chris Gioran
A guide to domain-specific types that make sense.
An implemenation of the SuperMemo-2 algorithm.
Update : I forgot that I did a brief analysis on this many years ago, using ROT13 as example.
Inspired by Felix Geisendorfer blog post I implemented a database FSM (Finite-State Machine) with Postgresql. I brought some improvements to Felix’s implementation but before reading the following I recommend you to read carefully the original post.
Machine learning models are rapidly becoming more capable; how can we make use of these powerful new tools in our Go applications?
The first manual was duplicated for a very small coterie. In order to channel queries directly to the horses’ mouths, authorship was attributed to individuals. Later, as authorship diffused, on the principle of”You touched it last; it’s yours,” authorship was attributed only in the segregated chapter of unofficial…
Garbage collectors are expected to be invisible: if programmers (or even users) notice them, something is wrong. Usually, such problems are are performance problems, but there could be correctness issues as well. This makes implementing them a bit scary.
If you find this piece worthwhile, consider the Go Fund Me that’s funding ongoing cancer care. A story from Dan Luu, from back when he “TA’ed EE 202, a second year class on signals and systems at P…
I would simply use delimiter characters to delimit data.
Backpressure is something nearly every software engineer will have to deal with at some point, and for some it’s a frequent problem. But…
I just did a massive spring cleaning of one of my servers, trying to clean up what has become quite the mess of clutter. For every website on the server, I either:
MS-DOS as well as Windows 98 come with a debugger program named DEBUG.EXE that can be used to work with assembly language instructions and machine code. In MS-DOS version 6.22, this program is named DEBUG.EXE and it is typically present at C:\DOS\DEBUG.EXE . On Windows 98, this program is usually present at…
Once upon a time I was given the following problem for a technical programming interview:
UPDATE 2/20/2006: After about a month, the project is now finished. You can go through the series and read my explanations for each step, or you can just page through and gander at the pretty pictures. If you’re the impatient sort, you could just jump to part 10 right now and see how it turned out.
A somewhat compact implementation of the awk programming language
Memory-mapping a file is convenient, but it's a hazard when used with async/await concurrent code: it means a "simple" memory index does blocking IO.
Master the art of efficient text navigation and editing in Vim with this comprehensive command workflow tutorial. Explore key commands and practical examples to enhance your productivity in Vim.
I’ve long been enamored of the sparkline, a graphical device which its inventor Edward Tufte defines thusly: A sparkline is a small intense, simple, word-sized graphic with typographic resolu…
Anyone trying to make a new mainstream language is completely insane, unless they're backed by a large corporation. 0
Inspired by Jack Wrenn’s post on Undroppable Types in Rust, I set out to see if it’s possible to create types that must be used exactly once. From my understanding, those things are called linear types, but don’t quote me on that1. Unless you are quoting the title of this article which explicitly says linear types… I…
A blog about modern PHP, the web, and programming in general. Follow my newsletter and YouTube channel as well.
I've been playing around with SQLite the last couple of days. I thought I knew a little about SQLite, but I didn't, and am getting my remedial education through an accelerated gauntlet. Some of what …
It's well known that syscalls are expensive. And that software mitigations against CPU bugs (such as Meltdown) even have made them more expensive. But how expensive are they really? To begin to answer this question I wrote a small micro-benchmark in order to measure the minimal costs of a syscall …
My own concatenative programming language
I discuss various models of biased bit sequences, and how to extract uniform random (or close to it) output bit sequences from them, illustrated with Python code.
If you work with Protocol Buffers (protobuf), you can really save time, boredom, and headache by parsing your defin…