Re: [sqlite] What's the best way to organize this database?

[John Salerno]

Thanks so much for all the advice and information! I think I can get
started now! :)



On Sat, Mar 10, 2012 at 6:36 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 9 Mar 2012, at 4:00pm, John Salerno <johnj...@gmail.com> wrote:
>
>> On Fri, Mar 9, 2012 at 7:29 AM, Simon Slavin <slav...@bigfraud.org> wrote:
>>
>>> Sooner or later you're going to want to make a list which is sorted in 
>>> artist order.  And you're going to want to list 'The Beatles' (if you have 
>>> any taste at all).  But if you list artists in name order they'd come in 
>>> the Ts, not the Bs because 'The' is part of the band name.  So having a 
>>> "sortOrder" field lets you enter 'The Beatles' as the band name but 
>>> 'Beatles, The' in the sortOrder field.  Similarly, 'Elvis Presley' should 
>>> be sorted under 'P', not 'E'.  Of course you could enter 'Presley, Elvis' 
>>> instead of the name in the order humans would say it, but I consider that a 
>>> way of saying "The computer is more important that you so humans must adapt 
>>> to the computer way.", which is an attitude I despise.
>>
>> Do I have to manually edit the name of the band to insert the
>> information in the sortOrder field? Wouldn't that require me to know
>> something about the exact wording of the band/artist name? Or is there
>> some generic way to do this? Simply switching the first and last name
>> wouldn't work, since that would mess up band names that aren't people
>> names, etc.
>
> You can work some way towards it in software, by doing things like changing 
> "The " to ", The" and assuming any name with two words in 
> is a person's name (though there are exceptions like 'Pink Floyd'.  But no, 
> to get them all right you'd have to have a human look at them.  But you don't 
> have to get them all right on first entry:
>
> One great advantage of having three independent tables is that you can set up 
> your initial data import to do the conversion from "name" to the "sortOrder" 
> poorly, or even not at all (just copy "name" into the "sortOrder") and then 
> if someone changes the sortOrder field of an artist later, all your existing 
> data about the songs and plays will magically start showing up in the new 
> sort order without someone having to go through all the data which has 
> already been entered.  This is a great advantage of the 'normalization' we 
> keep going on about: just change one piece of data once, and many other 
> things immediately reflect the change.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the best way to organize this database?

[John Salerno]

On Fri, Mar 9, 2012 at 7:29 AM, Simon Slavin  wrote:

> Sooner or later you're going to want to make a list which is sorted in artist 
> order.  And you're going to want to list 'The Beatles' (if you have any taste 
> at all).  But if you list artists in name order they'd come in the Ts, not 
> the Bs because 'The' is part of the band name.  So having a "sortOrder" field 
> lets you enter 'The Beatles' as the band name but 'Beatles, The' in the 
> sortOrder field.  Similarly, 'Elvis Presley' should be sorted under 'P', not 
> 'E'.  Of course you could enter 'Presley, Elvis' instead of the name in the 
> order humans would say it, but I consider that a way of saying "The computer 
> is more important that you so humans must adapt to the computer way.", which 
> is an attitude I despise.

Do I have to manually edit the name of the band to insert the
information in the sortOrder field? Wouldn't that require me to know
something about the exact wording of the band/artist name? Or is there
some generic way to do this? Simply switching the first and last name
wouldn't work, since that would mess up band names that aren't people
names, etc.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the best way to organize this database?

[John Salerno]

On Mar 8, 7:46 am, Simon Slavin  wrote:

> Yes, this would be the 'normalised' form.  Something like
>
> artists: id, name, sortOrder
> songs: id, artistID, title
> plays: id, songID, playDate, playTime

Ok, between you and Larry's last post, it's starting to make a lot
more sense (except I don't intend to track "listeners"). I see now I
need separate tables for the artists and songs, but just a few
questions:

1. What is the sortOrder entry in the artists table you created?

2. Would there need to be an extra entries I should be aware of before
I begin, or is the table outline you created complete?

3. What is the purpose of the id entry for the plays table? Is it used
much, or is it just for completeness?

Thanks!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the best way to organize this database?

[John Salerno]

On Mar 7, 7:33 am, Simon Slavin  wrote:

> I don't understand the purpose of the table you originally described.  If you 
> are listing the same tracks again and again, listing different times it was 
> played, then it would be useful to have three tables (artists, tracks, 
> plays). If each track is listed just once then I don't think you need a 
> separate table for tracks.
>
> Having three tables would make it very easy to list some statistics you might 
> not have originally planned on getting.  You could, for instance, very 
> quickly list how many times each track had been played.  Having people type 
> the full track name in every time would inevitably lead to them typing it 
> slightly differently sometimes, which would make full reporting untrustworthy.

Do you mean have a table that contains just the artist names, with an
ID for each; then another table with song names, an ID for each song,
and the ID for the artist; and then another table with play dates and
times, with the ID of the song connecting it? I'm trying to figure out
how it will all be connected.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the best way to organize this database?

[John Salerno]

Thanks to both of you. The question of normalization was one thing I was 
considering, I just wasn't sure how it should be done. A separate table 
with Artist ID and Artist Name fields could be useful. Would it be good to 
make an equivalent table for the songs, or should the songs simply be 
listed individually in the main table? I assume the dates and times have to 
be individual entries each time.

However, while reading the Wikipedia page on normalization, I noticed that 
some of the examples of a normalized table actually lists people's names as 
separate entries in the table. Of course, the alternative was some kind of 
nested tables, that looked messy, so perhaps the separate listings were the 
first step toward normalization, the next step being multiple tables with 
IDs for the names?

Thanks.
>
>___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] What's the best way to organize this database?

[John Salerno]

Hi all. I'm very new to all of this, so I'm not necessarily looking for 
over-the-top advice, although anything you tell me will be appreciated. I 
just want to create a simple script (in Python, using sqlite3) that reads a 
"|" delineated text file and extracts the following bits of information 
from each line in the file: a date, a time, a song artist, and a song title.

The point is that I want to create a database storing these four pieces of 
information and then later be able to retrieve the information in multiple 
ways, such as selecting a date and song and seeing how many times it was 
played that day, or selecting a date and person, or just a song, or just a 
person, etc.

So I'm wondering what the best way to create such a database would be. 
Should each of those four pieces of information be an entry in the table?

In case anyone knows Python (although I'm sure you can probably all read 
this anyway), here's what I came up with so far, just to see if it works, 
which it does:


import sqlite3

conn = sqlite3.connect('song_db')
c = conn.cursor()

c.execute('create table songs (date text, time text, artist text, title 
text)')

with open('song_list.txt') as song_file:
for line in song_file:
entries = tuple(line.strip().split('|'))
c.execute('insert into songs values (?, ?, ?, ?)', entries)

conn.commit
c.close()


This creates a table with as many entries as there are lines in the file. 
Is there a more efficient way?

Thanks!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Re: two questions about formatting output

[John Salerno]

If I'm going to do that, it seems easier to just add a .width line to
my .sqliterc file that specifies a larger width for about 10 or so
columns. Still not perfect though.



On 8/29/06, Fred Williams <[EMAIL PROTECTED]> wrote:

From experience.  Most "free form" output routines I have used utilizes
the content of the first row to establish the width of "columns." (i.e.
Reflected in the result per your "Administrative Assistant")

If you can "throw away" your first row of output, you could insert a
first row in your table with "X"'s in all positions out to your maximum
column widths.  Export the data and delete the first line.

Fred

> -Original Message-
> From: John Salerno [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 29, 2006 11:39 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Re: two questions about formatting output
>
>
> Alright, one final note, because now I'm really confused. Here was my
> original row data:
>
> Secretary, Programmer, Programmer II
>
> It displayed like this:
>
> title
> --
> Secretary
> Programmer
> Programmer
>
> I changed Secretary to Administrative Assistant and now it
> shows like this:
>
> title
> --
> Administrative Assistant
> Programmer
> Programmer II
>
> So why didn't it expand for Programmer II, but it does expand for AA?
>
> Thanks,
> John
>
>
>
>
>
>
> On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> > Just as a follow-up, I noticed that one of my columns *did*
> expand to
> > fit a longer name, yet another column didn't. Could it be
> because the
> > one that expanded contained a string of a single word, while the
> > column that didn't expand contained multiple words, i.e. 'Programmer
> > II'?
> >
> > Thanks.
> >
> >
> >
> > On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> > > Is it possible to change the width of columns in column
> mode in some
> > > general way? What I mean is, I know I can do .width X X X
> etc., but
> > > that requires knowing how many columns you have. Is there
> some way to
> > > set it so that the column will simply expand to fit the
> information?
> > >
> > > Second, I created a row entry like this:
> > >
> > > salary double(6, 2)
> > >
> > > and then entered a number such as 45000.00, but the
> output shows it as 45000.0
> > >
> > > Maybe this comes from ignorance of how SQL works in general, but
> > > shouldn't it show the second 0, since I typed it that way and I
> > > declared the field to have 2 decimal places?
> > >
> > > Thanks,
> > > John
> > >
> >
>
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: two questions about formatting output

[John Salerno]

On 8/29/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:

John Salerno wrote:

> So why didn't it expand for Programmer II, but it does expand for AA?

AIUI, the default column width is the greater of 10 and the width of the
first line of output.


Ah, thanks! I had even read about this, but I misunderstood it to mean
something else.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: two questions about formatting output

[John Salerno]

But if you do .mode column (and .header on, if that matters), it outputs:

a

Secretary
Programmer
Programmer


John




On 8/29/06, P Kishor <[EMAIL PROTECTED]> wrote:

>"C:\Program Files\sqlite3" tmp.db
SQLite version 3.3.7
Enter ".help" for instructions
sqlite> create table t (a text);
sqlite> .s
CREATE TABLE t (a text);
sqlite> insert into t values ('Secretary');
sqlite> insert into t values ('Programmer');
sqlite> insert into t values ('Programmer II');
sqlite> select * from t;
Secretary
Programmer
Programmer II
sqlite>


On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> Alright, one final note, because now I'm really confused. Here was my
> original row data:
>
> Secretary, Programmer, Programmer II
>
> It displayed like this:
>
> title
> --
> Secretary
> Programmer
> Programmer
>
> I changed Secretary to Administrative Assistant and now it shows like this:
>
> title
> --
> Administrative Assistant
> Programmer
> Programmer II
>
> So why didn't it expand for Programmer II, but it does expand for AA?
>
> Thanks,
> John
>
>
>
>
>
>
> On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> > Just as a follow-up, I noticed that one of my columns *did* expand to
> > fit a longer name, yet another column didn't. Could it be because the
> > one that expanded contained a string of a single word, while the
> > column that didn't expand contained multiple words, i.e. 'Programmer
> > II'?
> >
> > Thanks.
> >
> >
> >
> > On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> > > Is it possible to change the width of columns in column mode in some
> > > general way? What I mean is, I know I can do .width X X X etc., but
> > > that requires knowing how many columns you have. Is there some way to
> > > set it so that the column will simply expand to fit the information?
> > >
> > > Second, I created a row entry like this:
> > >
> > > salary double(6, 2)
> > >
> > > and then entered a number such as 45000.00, but the output shows it as 
45000.0
> > >
> > > Maybe this comes from ignorance of how SQL works in general, but
> > > shouldn't it show the second 0, since I typed it that way and I
> > > declared the field to have 2 decimal places?
> > >
> > > Thanks,
> > > John
> > >
> >
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] two questions about formatting output

[John Salerno]

I'll definitely move on to using Python to work with SQLite, so I
guess this won't be a problem eventually, but for now the command line
program is a very easy way to test out things and just use a database
on the fly, without having to write the extra code involved in
connecting to it via a separate language.



On 8/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

"John Salerno" <[EMAIL PROTECTED]> wrote:
> Just as a follow-up, I noticed that one of my columns *did* expand to
> fit a longer name, yet another column didn't. Could it be because the
> one that expanded contained a string of a single word, while the
> column that didn't expand contained multiple words, i.e. 'Programmer
> II'?
>
> Thanks.
>
>
>
> On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> > Is it possible to change the width of columns in column mode in some
> > general way? What I mean is, I know I can do .width X X X etc., but
> > that requires knowing how many columns you have. Is there some way to
> > set it so that the column will simply expand to fit the information?
> >

Please do not confuse "SQLite" and the command-line shell.
The command-line shell is a small (and stupid) program that
uses SQLite to access an SQLite database.  The complete
source code to the command-line shell is in the file "shell.c".

The command-line shell is rather limited in what it can do
in terms of output formatting.  If you need something more
elaborate (which you apparently do) then I would suggest
writing a short script in your favorite dynamic language
to open the database, extract the information you want, then
present it in whatever format seems appropriate.  A full-featured
language is a much better tool for doing that sort of thing
than a simple command-line shell.
--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: two questions about formatting output

[John Salerno]

Alright, one final note, because now I'm really confused. Here was my
original row data:

Secretary, Programmer, Programmer II

It displayed like this:

title
--
Secretary
Programmer
Programmer

I changed Secretary to Administrative Assistant and now it shows like this:

title
--
Administrative Assistant
Programmer
Programmer II

So why didn't it expand for Programmer II, but it does expand for AA?

Thanks,
John






On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:

Just as a follow-up, I noticed that one of my columns *did* expand to
fit a longer name, yet another column didn't. Could it be because the
one that expanded contained a string of a single word, while the
column that didn't expand contained multiple words, i.e. 'Programmer
II'?

Thanks.



On 8/29/06, John Salerno <[EMAIL PROTECTED]> wrote:
> Is it possible to change the width of columns in column mode in some
> general way? What I mean is, I know I can do .width X X X etc., but
> that requires knowing how many columns you have. Is there some way to
> set it so that the column will simply expand to fit the information?
>
> Second, I created a row entry like this:
>
> salary double(6, 2)
>
> and then entered a number such as 45000.00, but the output shows it as 45000.0
>
> Maybe this comes from ignorance of how SQL works in general, but
> shouldn't it show the second 0, since I typed it that way and I
> declared the field to have 2 decimal places?
>
> Thanks,
> John
>



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] formatting the output on the command line?

[John Salerno]

Thanks, I'll give this a try!

John

On 8/25/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:

John Salerno wrote:
> Well, I figured out the sqlite commands, but how would I make these
> settings the default each time I use the sqlite command line program?
> (i.e. .he on and .mo col)

If you're on Linux etc, put the commands in a file called .sqliterc in
your home directory.

If you're on Windows, open a command prompt, type "set" and see if you
have an environment variable called "HOME". If you have, put .sqliterc
in that directory. If not, go to the control panel and find the tool
which sets the environment variables (System|Advanced on XP), specify a
directory there and then create the .sqliterc file. You'll probably have
to log out/in before the variable is created in new command prompts.

When you start sqlite it will say that it has loaded commands from a
file and print the fully qualified pathname of that file.

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] formatting the output on the command line?

[John Salerno]

Well, I figured out the sqlite commands, but how would I make these
settings the default each time I use the sqlite command line program?
(i.e. .he on and .mo col)

John




On 8/25/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:

There are a load of nice text processing programs for this sort
of thing in Unix/Linux/BSD. Take a look at sed, ed, awk, or shell scripting.
Any of them should do it without much effort.

--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] formatting the output on the command line?

[John Salerno]

Thanks guys!

On 8/24/06, Gary Kruck <[EMAIL PROTECTED]> wrote:

There is a tutorial Here
<http://www.sqlite.org/sqlite.html> .

Gary

Martin Jenkins wrote:
> John Salerno wrote:
>> Is there any special command I need to use to get
these options
>> listed? I didn't see the particular abbreviations
that you told me
>> about.
>
> You can abbreviate the commands - enter enough to be
unambiguous.
>
> SQLite version 3.3.6
> Enter ".help" for instructions
> sqlite> .h
> .databases List names and files of
attached databases
> .dump ?TABLE? ...  Dump the database in an SQL
text format
> .echo ON|OFF   Turn command echo on or off
> .exit  Exit this program
> .explain ON|OFFTurn output mode suitable for
EXPLAIN on or off.
> .header(s) ON|OFF  Turn display of headers on or
off
> .help  Show this message
> .import FILE TABLE Import data from FILE into
TABLE
> .indices TABLE Show names of all indices on
TABLE
> .mode MODE ?TABLE? Set output mode where MODE is
one of:
>  csv  Comma-separated
values
>  column   Left-aligned
columns.  (See .width)
>  html HTML  code
>  insert   SQL insert
statements for TABLE
>  line One value per line
>  list Values delimited
by .separator string
>  tabs Tab-separated
values
>  tcl  TCL list elements
> .nullvalue STRING  Print STRING in place of NULL
values
> .output FILENAME   Send output to FILENAME
> .output stdout Send output to the screen
> .prompt MAIN CONTINUE  Replace the standard prompts
> .quit  Exit this program
> .read FILENAME Execute SQL in FILENAME
> .schema ?TABLE?Show the CREATE statements
> .separator STRING  Change separator used by
output mode and .import
> .show  Show the current values for
various settings
> .tables ?PATTERN?  List names of tables matching
a LIKE pattern
> .timeout MSTry opening locked tables for
MS milliseconds
> .width NUM NUM ... Set column widths for
"column" mode
> sqlite>
>
> Martin
>
>
-

>
> To unsubscribe, send email to
[EMAIL PROTECTED]
>
-

>
>
>
>

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] formatting the output on the command line?

[John Salerno]

Is there any special command I need to use to get these options
listed? I didn't see the particular abbreviations that you told me
about.

John

On 8/24/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:

John Salerno wrote:
> Thanks! Boxes aren't necessary, but it's nice to have the columns like
> that. I'll have to look into these options more.

.h is your friend. You can set the output format to HTML etc

Martin [off for a pint]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] formatting the output on the command line?

[John Salerno]

Thanks! Boxes aren't necessary, but it's nice to have the columns like
that. I'll have to look into these options more.

John

On 8/24/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:

John Salerno wrote:
> Hi everyone. Is it possible to format the output of a query
> differently when using the command line program? I'm thinking along
> the lines of MySQL, which puts rows and columns in boxes, and has the
> column names at the top. It's very nice and easy to read. I find the
> default format hard to read and too close together.

To get column separators and headings (but not boxes) issue the
following commands at the prompt.

.mo co
.he on

The .w [20 30 40] command lets you change column widths - as many as
you've specified - three in my example.

I think you can put these commands into a .sqliterc file so that they're
loaded when you start the command line client, but I've not tried that.

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] formatting the output on the command line?

[John Salerno]

Hi everyone. Is it possible to format the output of a query
differently when using the command line program? I'm thinking along
the lines of MySQL, which puts rows and columns in boxes, and has the
column names at the top. It's very nice and easy to read. I find the
default format hard to read and too close together.

Thanks,
John

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] running a script?

[John Salerno]

Thanks guys. Does any of this change for Windows though? I don't
believe I can use cat or | in the command prompt. I've also tried some
of those structures already and there seems to be a problem with my
file paths: C:\name\name\file.ext

I don't know if it's the colon or the slashes, but it won't work properly.

And about using .read and .import, does this mean you can't use them
on files that have semicolons in them?



On 8/23/06, Ulrich Schöbel <[EMAIL PROTECTED]> wrote:

On Wednesday 23 August 2006 21:45, John Salerno wrote:
> Hi everyone. Can someone tell me the proper syntax for running a sql
> script when starting up sqlite from the command line interface?
>
> Thanks,
> John
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

cat scriptfile | sqlite3 mydb

or

sqlite3 -init scriptfile mydb

or

sqlite3 mydb < scriptfile

or (for a single sql command)

sqlite3 mydb 'sqlcmd'

Kind regards

Ulrich

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] running a script?

[John Salerno]

I'm asking about an actual file, though, not just a single query. I've
tried something like what you suggest with the file path, but it
doesn't work.



On 8/23/06, Scott Baker <[EMAIL PROTECTED]> wrote:

echo "SELECT * FROM Table" | sqlite database.bin

John Salerno wrote:
> Hi everyone. Can someone tell me the proper syntax for running a sql
> script when starting up sqlite from the command line interface?
>
> Thanks,
> John
>
> -
>
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
>
>

--
Scott Baker - RHCE
Canby Telcom System Administrator
503.266.8253

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] running a script?

[John Salerno]

Hi everyone. Can someone tell me the proper syntax for running a sql
script when starting up sqlite from the command line interface?

Thanks,
John

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] importing csv files into a sqlite db?

[John Salerno]

Let's say I have many csv files (25, to be exact) and want to create a
sqlite database out of them? How do I do that?

Furthermore, in addition to the 25 text files of data, there are 25
corresponding sql files that define the tables, so does this mean
those would have to be rewritten in sqlite? Are the text files
themselves useless with the definition files?

Thanks,
John

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Loading a mysql file into a sqlite database?

[John Salerno]

Hi guys. Is it possible to load a sql file that is for a MySQL
database into a SQLite database? Does it just work normally, or would
some tweaking be needed? Or does this just not work?

Thanks,
John

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] opening a database in command prompt in Windows

[John Salerno]

Yeah, I just moved the exe file elsewhere on my hard drive and put
it's destination in my PATH. So now I can type 'sqlite3 ' and
open a database.


On 8/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

"John Salerno" <[EMAIL PROTECTED]> wrote:
> I downloaded the command line utility, and it is an exe file that
> automatically opens the sqlite prompt. Given this, how am I supposed
> to open or create databases? The only way I'm aware so far is that you
> have to specify the db after the sqlite3 command which opens the
> prompt, but in this case I'm already in the prompt.
>
> Or is this exe file not meant to be used this way? Am I supposed to
> put it in my PATH and then run it from the command line?
>

The easiest solutioni is to run it from the command-line.  I
assume from the above that you are double clicking on it or
something?

Another solution is to use ATTACH to attach new disk databases to
the in-memory database you are using when the prompt first
appears.
--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] opening a database in command prompt in Windows

[John Salerno]

I downloaded the command line utility, and it is an exe file that
automatically opens the sqlite prompt. Given this, how am I supposed
to open or create databases? The only way I'm aware so far is that you
have to specify the db after the sqlite3 command which opens the
prompt, but in this case I'm already in the prompt.

Or is this exe file not meant to be used this way? Am I supposed to
put it in my PATH and then run it from the command line?

Thanks,
John

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] switching databases?

[John Salerno]

Hi everyone. I'm just getting started with sqlite and I was testing it
on the command line. Is there a way to switch between databases while
at the sqlite command prompt, or must you start the command prompt
with a database? For example, must you always type:

$ sqlite3 

or is there some kind of 'switch' type of statement to choose a
different database to work on once you've entered the sqlite command
line?

Thanks!
John

-
To unsubscribe, send email to [EMAIL PROTECTED]
-