Re: [TUHS] cut, paste, join, etc.

[Will Senn <will.senn@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 1793 bytes --]

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





[-- Attachment #2: Type: text/html, Size: 2501 bytes --]