On Sun, 8 Jan 2023 at 08:48, Jean Louis <bugs@gnu.support> wrote: > > * Eduardo Ochs <eduardoo...@gmail.com> [2023-01-08 12:38]: > > You use either PostGres or SQLite to handle your ementary objects, > > right? I have both of them installed here, but I still don't know how > > to use them... =( > > I will send you example, soon. > > > In my current situation databases are "very complex"/"too complex" and > > plain text is "simple"... so I'm still using an approach that is based > > on text files, and only that approach... > > It is opposite. Plain text is disorganized way of keeping information > as compared to database systems.
Hi Jean, take a look here: https://lists.gnu.org/archive/html/help-gnu-emacs/2022-10/msg00807.html I know how to run SQLite in a shell prompt, but I've played very little with M-x sql-sqlite... I stumbled on this, (find-es "sqlite" "bypass-prompt") http://angg.twu.net/e/sqlite.e.html#bypass-prompt asked that question, got no answers, and decided to play with other things instead. Can you help me to write a series of examples of how to use SQLite and PostGres starting from examples that are "simple" in the sense below? I tend to use a notion of "simplicity" that comes from Forth. Imagine that we have a personal computer like the ones from the 70s, in which reading keys from the keyboard is done by reading a position from the memory, and each byte in a certain other region of the memory is inerpreted as a character in the screen ("text-mapped display RAM"). Imagine that we can program its ROM, or EPROM, ourselves. Then with less than 1KB we can implement a very basic Forth in it - one that has a very simple screen editor that executes the current line when we type RET, and that we can to bootstrap a Forth with more features by adding more functions to it one by one. I consider that that initial Forth with 1KB is "simpler" than the one that we get by adding more functions to that one and obtaining a Forth with 4KB. The Forth with 1KB is "simpler" for someone who needs to understand what each function does; someone who doesn't need that will probably consider that the Forth with 4KB is "simpler to use", and more "user-friendly". Using this notion of simplicity running SQLite in a shell prompt in "simpler" than using sql.el to run SQLite with another interface. Cheers, Eduardo
