public inbox for [email protected]
help / color / mirror / Atom feedFrom: Justin Pryzby <[email protected]>
To: Corey Huinker <[email protected]>
Cc: [email protected]
Subject: Re: Add A Glossary
Date: Wed, 1 Apr 2020 20:09:34 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CADkLM=e0_0Vhks_AQnCq9broqZKR0BCv4WzUe4mHhODFW1cj8w@mail.gmail.com>
References: <CADkLM=eP6HOeqDjn0FdXuGRusQu4oWH_LFsKjjafmhvWD=aSpQ@mail.gmail.com>
<[email protected]>
<CADkLM=e0_0Vhks_AQnCq9broqZKR0BCv4WzUe4mHhODFW1cj8w@mail.gmail.com>
On Tue, Mar 31, 2020 at 03:26:02PM -0400, Corey Huinker wrote:
> Just so I can prioritize my work, which of these things, along with your
> suggestions in previous emails, would you say is a barrier to considering
> this ready for a committer?
To answer your off-list inquiry, I'm not likely to mark it "ready" myself.
I don't know if any of these would be a "blocker" for someone else.
> > Here's some ideas; I'm *not* suggesting to include all of everything, but
> > hopefully start with a coherent, self-contained list.
>
> > grep -roh '<firstterm>[^<]*' doc/src/ |sed 's/.*/\L&/' |sort |uniq -c
> > |sort -nr |less
I looked through that list and found these that might be good to include now or
in the future. Probably all of these need language polishing; I'm not
requesting you to just copy them in just to say they're there.
join: concept of combining columns from two tables or other relations. The
result of joining a table with N rows to another table with M rows might have
up to N*M rows (if every row from the first table "joins to" every row on the
second table).
normalized: A database schema is said to be "normalized" if its redundancy has
been removed. Typically a "normalized" schema has a larger number of tables,
which include ID columns, and queries typically involve joining together
multiple tables.
query: a request send by a client to a server, usually to return results or to
modify data on the server;
query plan: the particular procedure by which the database server executes a
query. A simple query involving a single table could might be planned using a
sequential scan or an index scan. For a complex query involving multiple
tables joined togther, the optimizer attempts to determine the
cheapest/fastest/best way to execute the query, by joining tables in the
optimal order, and with the optimal join strategy.
planner/optimizer: ...
transaction isolation:
psql: ...
synchronous: An action is said to be "synchronous" if it does not return to its
requestor until its completion;
bind parameters: arguments to a SQL query that are sent separately from the
query text. For example, the query text "SELECT * FROM tbl WHERE col=$1" might
be executed for some certain value of the $1 parameter. If parameters are sent
"in-line" as a part of the query text, they need to be properly
quoted/escaped/sanitized, to avoid accidental or malicious misbehavior if the
input contains special characters like semicolons or quotes.
> > Maybe also:
> > object identifier
> > operator classes
> > operator family
> > visibility map
--
Justin
view thread (97+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Add A Glossary
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox