diff options
| -rw-r--r-- | blog/content/notes/index.gmi | 1 | ||||
| -rw-r--r-- | blog/content/notes/tech/about-relational-databases.gmi (renamed from programming/about_relational_databases.md) | 17 |
2 files changed, 8 insertions, 10 deletions
diff --git a/blog/content/notes/index.gmi b/blog/content/notes/index.gmi index 4c406e81..18311889 100644 --- a/blog/content/notes/index.gmi +++ b/blog/content/notes/index.gmi @@ -21,6 +21,7 @@ Notes about some books I like: => tech/migadu Migadu => tech/ripping Ripping => tech/about-apis About APIs +=> tech/about-relational-databases About relational databases ### Gadgets diff --git a/programming/about_relational_databases.md b/blog/content/notes/tech/about-relational-databases.gmi index 464de330..c66a530f 100644 --- a/programming/about_relational_databases.md +++ b/blog/content/notes/tech/about-relational-databases.gmi @@ -8,23 +8,20 @@ Actually, the relations in a relational database are the tables. A relation "relates" a set of values with another set of values. -For example, a relation can relate the name of a person with their birth date and birth place. -For example: +For example, a relation can relate the name of a person with their birth date and birth place. For example: -``` (person name) => (birth date, birth place) (Alice) => (1979-12-03, Barcelona) (Bob) => (1995-03-04, Paris) ... -``` Many computer languages have similar concepts: -* [Python mapping types such as `dict`](https://docs.python.org/3/library/stdtypes.html#mapping-types-dict) -* C++ `std::map` -* Java `java.util.Map` -* [C# `System.Collections.Generic.Dictionary`](https://learn.microsoft.com/en-us/dotnet/api/system.collections.generic.dictionary-2?view=net-9.0) -* [Javascript `Object`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object) -* [PHP arrays](https://www.php.net/manual/en/language.types.array.php) +* Python mapping types such as dict +* C++ std::map +* Java java.util.Map +* C# System.Collections.Generic.Dictionary +* Javascript Object +* PHP arrays Relations are a natural concept, so although non-relational data systems exist, most data can be stored as relations. |