Re: [sqlite] What's the best way to organize this database?
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 wrote: > > On 9 Mar 2012, at 4:00pm, John Salerno wrote: > >> 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. > > 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?
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?
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?
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?
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?
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
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
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
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
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
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] -
[sqlite] Re: two questions about formatting output
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] -
[sqlite] two questions about formatting output
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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
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
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?
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] -