[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...
[LMG S7] Issue 83: Structured Query Language
Previously: A database system follows rules that enable multiple users to send commands to the database at the same time. The system attempts to execute each...
[LMG S7] Issue 82: Multiplayer databases
Previously: Putting all data into one table results in unnecessary duplication of data. Making data atomic by splitting it up into multiple tables makes the...
[LMG S7] Issue 81: Data Normalisation
Previously: An index is a separate table containing key terms in the database (usually names, IDs, or some other key identifier), alongside the row numbers...
[LMG S7] Issue 80: Indexing
Previously: Comma-separated value (CSV) files store all data in text form. Within each row, a separator divides each chunk of data, and rows are separated by...
[LMG S7] Issue 79: A Base for Data
Previously: Modern webpages rely on many third-party resources for their functionality. Blocking access to some domains may cause these webpages to break and...