[LMG S8] Issue 103: Why apps hang even with multiple threads
Previously: Applications are assigned a thread by the OS for running a sequence of instructions. The instructions are executed sequentially, and the app...
[LMG S8] Issue 102: Threading
Previously: An app crashes when it encounters a situation it can’t handle, or when it attempts to perform an operation that is disallowed by the operating...
[LMG S8] Issue 101: Why apps crash
Previously: Windows systems categorise data into two types: files, and settings. Files are stored under an appropriate subfolder in C:\, while other storage...
[LMG S8] Issue 100: Where does all the app data go? A look at Windows systems
Previously: MacOS, Linux, and other similar systems treat everything as a file, organised into appropriate subfolders. Previous issue: Mac- and Linux-like...
[LMG S8] Issue 99: Where does all the app data go? A look at Mac-like systems
Previously: Apps generally handle three categories of files: its own (permanent) app files, (shared) user files, and (ephemeral) temporary files. What we are...
[LMG S8] Issue 98: Temporary files
Previously: A laptop app can do practically anything, if it is running through the Administrator/root account. Sandboxing is carried out through permission...
[LMG S8] Issue 97: Laptop apps
Previously: Mobile apps are sandboxed by the operating system. As a result, they have to bundle all the libraries they need, and are not allowed to share...
[LMG S8] Issue 96: Why are mobile apps so large in size?
Previously: Mobile apps, unlike web apps, can bundle resources and libraries to be installed to a mobile device. They can also request access to storage, and...
[LMG S8] Issue 95: What’s in a mobile app?
Previously: Web apps require the browser to request memory on their behalf, and thus their memory usage shows up under the browser process in the OS Task...
![[LMG S8] Issue 94: Why do web browsers take up so much memory?](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season8/issue094/issue094_01.png)
[LMG S8] Issue 94: Why do web browsers take up so much memory?
Previously: Web apps have limited access to the device’ storage, and can only store data in browser-managed databases. Progressive Web Apps (PWAs) can...
![[LMG S8] Issue 93: What's in a web app?](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season8/issue092/issue092_01.png)
[LMG S8] Issue 93: What's in a web app?
Previously: Sandboxing is a catch-all term for the concept of ensuring apps don’t have access to resources outside of their privileges. Sandboxed apps are...
[LMG S8] Issue 92: All about apps
Previously: Depending on what you need a database for, there may be online database platforms that can manage and automate much of the work for you....
[LMG S7] Issue 91: Commercial database alternatives
Oops, I misscheduled this week’s issue and it didn’t go out yesterday as it should have 🙈 sorry about that! Previously: A URI (Uniform Resource Identifier)...
[LMG S7] Issue 90: Using a database
Previously: Graph databases treat the details of things as secondary, and optimise for managing the network of relationships. A graph database can quickly...
![[LMG S7] Issue 89: Graph Databases](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season7/issue089/issue089_01.png)
[LMG S7] Issue 89: Graph Databases
Previously: Document databases organise data into documents, each containing a number of field-value pairs. each value can itself be a document, and multiple...
[LMG S7] Issue 88: Document Databases
Previously: Relational databases are designed to maintain a well-structured set of data tables through constraint rules. This makes them very useful for...
![[LMG S7] Issue 87: Relational Databases](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season7/issue084/issue084_04.png)
[LMG S7] Issue 87: Relational Databases
Previously: To increase the performance of a distributed database, we can scale up/scale vertically by increasing the computers’ performance, or scale...
[LMG S7] Issue 86: Distributed databases
Previously: Forms that naïvely inject user-submitted data into a SQL query template may end up sending valid SQL commands to the database, with disastrous...
![[LMG S7] Issue 85: SQL Injections](https://imgs.xkcd.com/comics/exploits_of_a_mom.png)
[LMG S7] Issue 85: SQL Injections
Previously: SQL queries let you join multiple tables based on specified conditions using the JOIN keyword. This enables crafting complex queries to return...
![[LMG S7] Issue 84: JOIN – supercharged VLOOKUP](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season7/issue084/issue084_01.png)
[LMG S7] Issue 84: JOIN – supercharged VLOOKUP
Previously: Structured Query Language (SQL) is a computer language for managing data in databases. It has keywords and keyphrases that let you filter rows...