Re: On "write function for each reference"

[Eduardo Ochs]

On Sun, 8 Jan 2023 at 08:48, Jean Louis <bugs@gnu.support> wrote:
>
> * Eduardo Ochs <eduardoochs@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