Notes

SQLite is an embedded database that holds a SQL database in a single file. It is one of the most frequently chosen options for local storage in desktop and mobile apps.

21 views

cmd.exe is the command processor on Windows NT-family systems. It debuted in 1993 with Windows NT 3.1 and ships with every Windows release. Since PowerShell arrived, cmd's role as an entry point for new code has shrunk,…

20 views

iOS app builds go through similar steps to Android (compile → bundle resources → sign → package), but the tools, distribution channels, and policies look quite different. The biggest difference is that macOS and the App…

13 views

The trend of running large language models directly on personal computers has taken hold rapidly since 2023. Where there used to be only cloud APIs, the combination of quantization formats like GGUF, inference runtimes…

13 views

Even with the same language and the same code, the basics like paths, line endings, shells, and permissions shift once the operating system changes. Linux falls on the macOS side of this split (both are Unix-flavored).

13 views

PowerShell is Microsoft's shell and scripting language. It pipes .NET objects rather than text, which gives it a different grain from the bash family.

Collecting public web data touches not only technology but ethics and law. Hitting too often burdens the target server, and skipping the terms of service can spill into legal trouble.

There is a standard for expressing the shape of an HTTP API as a machine-readable document. That is the OpenAPI Specification (OAS). Once it is written well, doc pages, client SDKs, mocks, and contract tests all flow fr…

The word "agent" is used in several senses, which is a confusing situation. Script automation is called an agent, and so is the shape of an LLM calling tools.

What sets desktop and mobile apps apart from web apps is usually OS integration. Toast notifications, system trays, file dialogs, clipboard, autostart, global shortcuts, and deep links are frequent items in that list.

AWS network firewalling has two layers: the Security Group (SG) attached to instances, and the Network ACL (NACL) attached to subnets. The names are similar, but the operating models differ quite a bit.

There's a saying that "a good question is half the answer." Faced with the same blocker, one person gets an answer in 5 minutes while another wanders for days. The difference usually sits in two places. First, asking be…

A skeleton flicker on a fast page is unpleasant. A long blank screen on a slow page is anxious. Both share the same root cause — fallback only sits at the route level.

Firebase started as a small startup in 2011 and was acquired by Google in 2014. Being a managed-first service, "no way to run it locally" was the right answer for a long time, but in March 2020 the picture changed when…

The question "is this code fast?" has different answers depending on environment, hardware, and input. So computer science describes — as a function — how time (or memory) grows as input size grows. That notation is Big…

Tailwind CSS is the flagship of the so-called utility-first approach to styling.