From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on inbox.vuxu.org X-Spam-Level: X-Spam-Status: No, score=-1.1 required=5.0 tests=DKIM_SIGNED,DKIM_VALID, DKIM_VALID_AU,FREEMAIL_FROM,HTML_MESSAGE,MAILING_LIST_MULTI, NICE_REPLY_A,RCVD_IN_DNSWL_NONE autolearn=ham autolearn_force=no version=3.4.4 Received: (qmail 10213 invoked from network); 17 Feb 2021 02:30:31 -0000 Received: from minnie.tuhs.org (45.79.103.53) by inbox.vuxu.org with ESMTPUTF8; 17 Feb 2021 02:30:31 -0000 Received: by minnie.tuhs.org (Postfix, from userid 112) id 257BA9CA6F; Wed, 17 Feb 2021 12:30:25 +1000 (AEST) Received: from minnie.tuhs.org (localhost [127.0.0.1]) by minnie.tuhs.org (Postfix) with ESMTP id 37B079BA4D; Wed, 17 Feb 2021 12:29:57 +1000 (AEST) Authentication-Results: minnie.tuhs.org; dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.b="XQM1sR40"; dkim-atps=neutral Received: by minnie.tuhs.org (Postfix, from userid 112) id 469709BA4D; Wed, 17 Feb 2021 12:26:14 +1000 (AEST) Received: from mail-oi1-f175.google.com (mail-oi1-f175.google.com [209.85.167.175]) by minnie.tuhs.org (Postfix) with ESMTPS id 90D409B968 for ; Wed, 17 Feb 2021 12:26:13 +1000 (AEST) Received: by mail-oi1-f175.google.com with SMTP id k204so13471199oih.3 for ; Tue, 16 Feb 2021 18:26:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=IVDRvc0V5Yk5SEGseiAutnS4Oijlkcdp6FE62n1bxfE=; b=XQM1sR40V3mHZ+7AIlTwfwW4FyhOOiwzfs8CSaPMrOx3XbPycxIurUSBy36Ab+boMo rhzq3z0gIFQwRcjSsF7yif9jbacH28vDxa7xqTbQR94eQvMcuFG5a4vYXUPWJzxpntYm QWhKcWacYriPP9Ax13yXo7XaoRACevBzNK4zbOCL6ZQ/CIXrxJsQWCwQoQxaIttLsIdT wfvMssCEXLS4x5JBfSQJtT/WZ7/vONRK4b4Nj/0QoWCvOIBkNkWRxUw8nZv/IfSZ1Y01 lyd6XLmmOI4a7VheuNGUkHWYRgMnaJyLetRMBPSF+Gieg0qSDPO8PgU1LMVdpoIf1RHG wMcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=IVDRvc0V5Yk5SEGseiAutnS4Oijlkcdp6FE62n1bxfE=; b=A9/glt4rHXET2fQpK3q4wUie5Lmc6ZOoZUDWdDm5ct5LgP5iBQBOvhoWSybxS66/Cz DbbCy9kx0xv1lG9NFSSvayd2wPNsORe8RkUdepo9y/Q9gOD07ILKb7xZe0OPBMOoXSMZ xJYiz01eAi1C9x2kablPATFDpzApTywzTuVzB+duAhrcGPpmAdEfAV8ZwjWOCDxWvQBM df48cyVzqUCLQPwihmDdbK2zjed8qcf/fy8NQ0NYuXoL1oxJdEE1LQhq2bdkL0trhOBD rwmP0HRFBd4kn3rGFVqo1QBjcY6MhnoSqoeq+L/zIUslN4ap8j2Cxn+78cEZSIya+sTy mS8w== X-Gm-Message-State: AOAM533kfKUBzzyOCS0HAQzlw/V7v5nPlVQZi8CRNuysVOO3l8IEz0Og idqGgr24i/eukkji23RWuTYCVkiwHgmjWA== X-Google-Smtp-Source: ABdhPJxENHpvXoG0vcrXMx+UF7eFC5shUPpAEiAW1lZ3lWVDxu+WObnLUfbvzNZMs0Kjtt0gJW9FIA== X-Received: by 2002:aca:3306:: with SMTP id z6mr4181841oiz.141.1613528772603; Tue, 16 Feb 2021 18:26:12 -0800 (PST) Received: from terra.local (99-139-148-170.lightspeed.rcsntx.sbcglobal.net. [99.139.148.170]) by smtp.gmail.com with ESMTPSA id y27sm176760oix.37.2021.02.16.18.26.12 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 Feb 2021 18:26:12 -0800 (PST) To: tuhs@minnie.tuhs.org References: <26484818-2f05-37d3-adff-6e34d383e117@gmail.com> <399f2cdc-d790-c4fe-18e3-0cb6b4c76554@spamtrap.tnetconsulting.net> From: Will Senn Message-ID: <55d60220-c22d-c99f-f40c-68a741183213@gmail.com> Date: Tue, 16 Feb 2021 20:26:11 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 MIME-Version: 1.0 In-Reply-To: <399f2cdc-d790-c4fe-18e3-0cb6b4c76554@spamtrap.tnetconsulting.net> Content-Type: multipart/alternative; boundary="------------C8677C81B764C1C85766C9F9" Content-Language: en-US Subject: Re: [TUHS] cut, paste, join, etc. X-BeenThere: tuhs@minnie.tuhs.org X-Mailman-Version: 2.1.26 Precedence: list List-Id: The Unix Heritage Society mailing list List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: tuhs-bounces@minnie.tuhs.org Sender: "TUHS" This is a multi-part message in MIME format. --------------C8677C81B764C1C85766C9F9 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 2/16/21 7:43 PM, Grant Taylor via TUHS wrote: > On 2/16/21 6:16 PM, Will Senn wrote: >> Nice! Thanks Doug. Too bad, though... one gets ever tired of having >> to log into db's and a simple text db system would be useful. Even >> sqlite, which I love, requires login to get at information... I'm >> already logged in, why can't I just ask for my info and have it >> returned? > > What do you mean by "log into db's" in relation to SQLite?  I've never > needed to enter a username and password to access SQLite. > > If you /do/ mean username and password, I believe that some DBs will > allow you to authenticate using Kerberos.  Thus you should be able to > streamline DB access along with access to many other things. > > If you /don't/ mean username and password, then what do you mean? Are > you referring to needing to run a command to open and access the > SQLite DB?  Taking a quick gander at sqlite3 --help makes me think > that you can append the SQL(ite) command that you want to run to the > command line. > > > Oops. That's right, no username & password, but you still need to bring it up and interact with it... accept, as you say, you can enter your sql as an argument to the executable. OK, I suppose ... grump, grump... Not quite what I was thinking, but I'd be hard pressed to argue the difference between creating a handful of files in the filesystem (vs tables in sqlite) and then using some unix filter utilities to access and combine the file relations (vs passing sql to sqlite) other than, it'd be fun if there were select, col, row (grep?), join (inner, outer, natural), utils that worked with text without the need to worry about the finickiness of the database (don't stone me as a database unbeliever, I've used plenty in my day). Will --------------C8677C81B764C1C85766C9F9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 2/16/21 7:43 PM, Grant Taylor via TUHS wrote:
On 2/16/21 6:16 PM, Will Senn wrote:
Nice! Thanks Doug. Too bad, though... one gets ever tired of having to log into db's and a simple text db system would be useful. Even sqlite, which I love, requires login to get at information... I'm already logged in, why can't I just ask for my info and have it returned?

What do you mean by "log into db's" in relation to SQLite?  I've never needed to enter a username and password to access SQLite.

If you /do/ mean username and password, I believe that some DBs will allow you to authenticate using Kerberos.  Thus you should be able to streamline DB access along with access to many other things.

If you /don't/ mean username and password, then what do you mean?  Are you referring to needing to run a command to open and access the SQLite DB?  Taking a quick gander at sqlite3 --help makes me think that you can append the SQL(ite) command that you want to run to the command line.



Oops. That's right, no username & password, but you still need to bring it up and interact with it... accept, as you say, you can enter your sql as an argument to the executable. OK, I suppose ... grump, grump... Not quite what I was thinking, but I'd be hard pressed to argue the difference between creating a handful of files in the filesystem (vs tables in sqlite) and then using some unix filter utilities to access and combine the file relations (vs passing sql to sqlite) other than, it'd be fun if there were select, col, row (grep?), join (inner, outer, natural), utils that worked with text without the need to worry about the finickiness of the database (don't stone me as a database unbeliever, I've used plenty in my day).

Will




 --------------C8677C81B764C1C85766C9F9--