[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Format of lists and alists required for displaying lists of tabulate
From: |
Jean Louis |
Subject: |
Re: Format of lists and alists required for displaying lists of tabulated data |
Date: |
Mon, 19 Jun 2023 21:49:17 +0300 |
User-agent: |
Mutt/2.2.10+64 (b470a9a) (2023-06-05) |
* Christopher Dimech <dimech@gmx.com> [2023-06-18 22:16]:
> The functions could be difficult to use because of the many calls to your
> "rcd-" functions.
> Perhaps we can come up with something more adept to users to try. Using same
> idea of
> an ID followed by values.
Yes, good idea. But I did not find use of it for me. All my PostgreSQL database
tables follow certain pattern as described by:
GeDaFe - PostgreSQL Generic Database Interface:
http://gedafe.github.io/doc/gedafe-sql.en.html
and should be compatible with the web interface as well in that
sense. I did not test it for years, since I switched to Emacs
interface.
They follow this pattern "mytable_" plus "_id", so there is always
"ID" which serves handy for tabulated-list-mode
-- ------------------------------------------
-- ------------ Table mytable
-- ------------------------------------------
DROP SEQUENCE mytable_id_seq;
CREATE TABLE mytable (
mytable_id SERIAL NOT NULL PRIMARY KEY,
mytable_uuid UUID NOT NULL DEFAULT gen_random_uuid() UNIQUE,
mytable_datecreated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
mytable_datemodified TIMESTAMP,
mytable_usercreated TEXT NOT NULL DEFAULT current_user,
mytable_usermodified TEXT NOT NULL DEFAULT current_user,
mytable_name TEXT,
mytable_title TEXT,
mytable_description TEXT,
mytable_ TEXT
);
--
Jean
Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns
In support of Richard M. Stallman
https://stallmansupport.org/
- Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/16
- Re: Format of lists and alists required for displaying lists of tabulated data, Bruno Barbier, 2023/06/17
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/17
- Re: Format of lists and alists required for displaying lists of tabulated data, Christopher Dimech, 2023/06/18
- Re: Format of lists and alists required for displaying lists of tabulated data,
Jean Louis <=
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/19
- Re: Format of lists and alists required for displaying lists of tabulated data, Jean Louis, 2023/06/21
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/21
- Re: Format of lists and alists required for displaying lists of tabulated data, Jean Louis, 2023/06/24
- Re: Format of lists and alists required for displaying lists of tabulated data, Tim Landscheidt, 2023/06/18
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/18
- Re: Format of lists and alists required for displaying lists of tabulated data, Tim Landscheidt, 2023/06/18
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/18
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/18
- Re: Format of lists and alists required for displaying lists of tabulated data, uzibalqa, 2023/06/18