Re: simple database solution without root access

2014-07-07 Thread Slavko
Ahoj, Dňa Mon, 7 Jul 2014 11:45:32 -0400 Steve Litt napísal: > On Sun, 6 Jul 2014 21:05:10 -0600 > Joe Pfeiffer wrote: > > I've always thought that's *exactly* what makes it a text file. If > every character's ascii value is between 32 and 126, along with > CarriageReturn and Linefeed, it's a

Re: simple database solution without root access

2014-07-07 Thread Steve Litt
On Sun, 6 Jul 2014 21:05:10 -0600 Joe Pfeiffer wrote: > My typical experience is that when people distinguish "text" vs > "binary" files, they mean the whole file can reasonably be made sense > of in a text editor (that's not a precise definition, of course, but I > think it serves the purpose).

Re: simple database solution without root access

2014-07-07 Thread Joel Rees
On Mon, Jul 7, 2014 at 9:46 PM, Nuno Magalhães wrote: > On Mon, Jul 7, 2014 at 1:12 PM, Joel Rees wrote: >> On Mon, Jul 7, 2014 at 7:54 PM, Nuno Magalhães >> wrote: >>> On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer wrote: My typical experience is that when people distinguish "text" vs

Re: simple database solution without root access

2014-07-07 Thread Nuno Magalhães
On Mon, Jul 7, 2014 at 1:12 PM, Joel Rees wrote: > On Mon, Jul 7, 2014 at 7:54 PM, Nuno Magalhães > wrote: >> On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer wrote: >>> My typical experience is that when people distinguish "text" vs >>> "binary" files, they mean the whole file can reasonably be ma

Re: simple database solution without root access

2014-07-07 Thread Joel Rees
On Mon, Jul 7, 2014 at 7:54 PM, Nuno Magalhães wrote: > On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer wrote: >> My typical experience is that when people distinguish "text" vs >> "binary" files, they mean the whole file can reasonably be made sense >> of in a text editor (that's not a precise defi

Re: simple database solution without root access

2014-07-07 Thread Nuno Magalhães
On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer wrote: > My typical experience is that when people distinguish "text" vs > "binary" files, they mean the whole file can reasonably be made sense > of in a text editor (that's not a precise definition, of course, but I > think it serves the purpose). Wh

Re: simple database solution without root access

2014-07-06 Thread Bob Proulx
kamaraju kusumanchi wrote: > Bob Proulx wrote: > > Are you aware of SQLite? > > I am still exploring all the suggestions given by others. But SQLite looks > very promising. There is a Perl DBI Interface to SQLite which might be what > I am after. Using Perl with DBI with an SQLite database works

Re: simple database solution without root access

2014-07-06 Thread Joe Pfeiffer
Joel Rees writes: >2014/07/07 10:39 "Joe Pfeiffer" : >> >> Joel Rees writes: >> >> > 2014/07/07 5:08 "Nuno Magalhães" : >> >> >> >> On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi >> >> wrote: >> >> > I am still exploring all the suggestions given by others. But SQLite >> >> > looks >> >> >

Re: simple database solution without root access

2014-07-06 Thread Joe Pfeiffer
Joel Rees writes: > 2014/07/07 10:39 "Joe Pfeiffer" : >> >> Joel Rees writes: >> >> > 2014/07/07 5:08 "Nuno Magalhães" : >> >> >> >> On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi >> >> wrote: >> >> > I am still exploring all the suggestions given by others. But SQLite >> >> > looks >> >>

Re: simple database solution without root access

2014-07-06 Thread Joel Rees
2014/07/07 10:39 "Joe Pfeiffer" : > > Joel Rees writes: > > > 2014/07/07 5:08 "Nuno Magalhães" : > >> > >> On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi > >> wrote: > >> > I am still exploring all the suggestions given by others. But SQLite looks > >> > very promising. There is a Perl DBI I

Re: simple database solution without root access

2014-07-06 Thread Joe Pfeiffer
Joel Rees writes: > 2014/07/07 5:08 "Nuno Magalhães" : >> >> On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi >> wrote: >> > I am still exploring all the suggestions given by others. But SQLite looks >> > very promising. There is a Perl DBI Interface to SQLite which might be what >> > I am af

Re: simple database solution without root access

2014-07-06 Thread Joel Rees
2014/07/07 5:08 "Nuno Magalhães" : > > On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi > wrote: > > I am still exploring all the suggestions given by others. But SQLite looks > > very promising. There is a Perl DBI Interface to SQLite which might be what > > I am after. > > >> > 2) I want the

Re: simple database solution without root access

2014-07-06 Thread Joel Roth
Bob Proulx wrote: > kamaraju kusumanchi wrote: > > I have some data in text format organized as follows > > > > field_1,field_2,field_3,...,field_9 > > val_1_1,val_1_2,val_1_3,...,val_1_9 > > val_2_1,val_2_2,val_2_3,...,val_2_9 > > ... > > val_100_1,val_100_2,val_100_3,...,val_100_9 > > > > > >

Re: simple database solution without root access

2014-07-06 Thread Tom Furie
On Sun, Jul 06, 2014 at 04:03:26PM -0400, kamaraju kusumanchi wrote: Someone else wrote (attribution removed previously) >> > > If you are already sed/grep/awk then stop at awk. :-) > > > > Seriously though what do you want to do that can't be done easily with awk? > I do use awk and have some

Re: simple database solution without root access

2014-07-06 Thread Nuno Magalhães
On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi wrote: > I am still exploring all the suggestions given by others. But SQLite looks > very promising. There is a Perl DBI Interface to SQLite which might be what > I am after. >> > 2) I want the data to be in text format. SQLite keeps data in b

Re: simple database solution without root access

2014-07-06 Thread kamaraju kusumanchi
> > I looked at mysql (http://zetcode.com/databases/mysqltutorial/), but > there > > the configuration seems to focus on having a central database that could > be > > shared across different users. This does not work for me for three > reasons: > > Are you aware of SQLite? > I am still exploring a

Re: simple database solution without root access

2014-07-06 Thread Miles Fidelman
Bob Proulx wrote: kamaraju kusumanchi wrote: I have some data in text format organized as follows field_1,field_2,field_3,...,field_9 val_1_1,val_1_2,val_1_3,...,val_1_9 val_2_1,val_2_2,val_2_3,...,val_2_9 ... val_100_1,val_100_2,val_100_3,...,val_100_9 I want to do database (sql) like operat

Re: simple database solution without root access

2014-07-06 Thread Bob Proulx
kamaraju kusumanchi wrote: > I have some data in text format organized as follows > > field_1,field_2,field_3,...,field_9 > val_1_1,val_1_2,val_1_3,...,val_1_9 > val_2_1,val_2_2,val_2_3,...,val_2_9 > ... > val_100_1,val_100_2,val_100_3,...,val_100_9 > > > I want to do database (sql) like operati

Re: simple database solution without root access

2014-07-05 Thread Neal Murphy
On Sunday, July 06, 2014 01:21:31 AM kamaraju kusumanchi wrote: > I have some data in text format organized as follows > > field_1,field_2,field_3,...,field_9 > val_1_1,val_1_2,val_1_3,...,val_1_9 > val_2_1,val_2_2,val_2_3,...,val_2_9 > ... > val_100_1,val_100_2,val_100_3,...,val_100_9 > > > I w

Re: simple database solution without root access

2014-07-05 Thread Bzzzz
On Sun, 6 Jul 2014 01:21:31 -0400 kamaraju kusumanchi wrote: > I want to do database (sql) like operations on this data. For As you're the only user and not in a hurry, use sqlite (also install sqlitebrowser that eases sqlite DBs exploration). Search on the web how to pour data from your flat f

simple database solution without root access

2014-07-05 Thread kamaraju kusumanchi
I have some data in text format organized as follows field_1,field_2,field_3,...,field_9 val_1_1,val_1_2,val_1_3,...,val_1_9 val_2_1,val_2_2,val_2_3,...,val_2_9 ... val_100_1,val_100_2,val_100_3,...,val_100_9 I want to do database (sql) like operations on this data. For example, - I want