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 pfeif...@cs.nmsu.edu 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

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 nunomagalh...@eu.ipp.pt wrote: On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer pfeif...@cs.nmsu.edu 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

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 joel.r...@gmail.com wrote: On Mon, Jul 7, 2014 at 7:54 PM, Nuno Magalhães nunomagalh...@eu.ipp.pt wrote: On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer pfeif...@cs.nmsu.edu wrote: My typical experience is that when people distinguish text vs binary

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 nunomagalh...@eu.ipp.pt wrote: On Mon, Jul 7, 2014 at 1:12 PM, Joel Rees joel.r...@gmail.com wrote: On Mon, Jul 7, 2014 at 7:54 PM, Nuno Magalhães nunomagalh...@eu.ipp.pt wrote: On Mon, Jul 7, 2014 at 4:09 AM, Joe Pfeiffer pfeif...@cs.nmsu.edu

Re: simple database solution without root access

2014-07-07 Thread Steve Litt
On Sun, 6 Jul 2014 21:05:10 -0600 Joe Pfeiffer jos...@pfeifferfamily.net 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

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 sl...@troubleshooters.com napísal: On Sun, 6 Jul 2014 21:05:10 -0600 Joe Pfeiffer jos...@pfeifferfamily.net 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,

Re: simple database solution without root access

2014-07-06 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 want to do

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 operations on

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

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 all the

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 raju.mailingli...@gmail.com 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.

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 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 I want to do

Re: simple database solution without root access

2014-07-06 Thread Joel Rees
2014/07/07 5:08 Nuno Magalhães nunomagalh...@eu.ipp.pt: On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi raju.mailingli...@gmail.com 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

Re: simple database solution without root access

2014-07-06 Thread Joe Pfeiffer
Joel Rees joel.r...@gmail.com writes: 2014/07/07 5:08 Nuno Magalhães nunomagalh...@eu.ipp.pt: On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi raju.mailingli...@gmail.com wrote: I am still exploring all the suggestions given by others. But SQLite looks very promising. There is a Perl

Re: simple database solution without root access

2014-07-06 Thread Joel Rees
2014/07/07 10:39 Joe Pfeiffer pfeif...@cs.nmsu.edu: Joel Rees joel.r...@gmail.com writes: 2014/07/07 5:08 Nuno Magalhães nunomagalh...@eu.ipp.pt: On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi raju.mailingli...@gmail.com wrote: I am still exploring all the suggestions given by

Re: simple database solution without root access

2014-07-06 Thread Joe Pfeiffer
Joel Rees joel.r...@gmail.com writes: 2014/07/07 10:39 Joe Pfeiffer pfeif...@cs.nmsu.edu: Joel Rees joel.r...@gmail.com writes: 2014/07/07 5:08 Nuno Magalhães nunomagalh...@eu.ipp.pt: On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi raju.mailingli...@gmail.com wrote: I am still

Re: simple database solution without root access

2014-07-06 Thread Joe Pfeiffer
Joel Rees writes: 2014/07/07 10:39 Joe Pfeiffer pfeif...@cs.nmsu.edu: Joel Rees joel.r...@gmail.com writes: 2014/07/07 5:08 Nuno Magalhães nunomagalh...@eu.ipp.pt: On Sun, Jul 6, 2014 at 9:03 PM, kamaraju kusumanchi raju.mailingli...@gmail.com wrote: I am still exploring all the

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 very

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

Re: simple database solution without root access

2014-07-05 Thread Bzzzz
On Sun, 6 Jul 2014 01:21:31 -0400 kamaraju kusumanchi raju.mailingli...@gmail.com 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