[sqlite] CSV to SQLite to web page display

2012-04-25 Thread b2
I have data that is exported to comma delimited format(CSV) daily / weekly and want to be able to display on the web. Read only with no calculations but more readable date price formats. Number of records will be less than 100. MySQL is an overkill for this and I was hoping that SQLite might do

[sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-25 Thread nn6eumtr
Steps to recreate: 1) wget -nd -nH -c -t 0 -w 1 http://www.sqlite.org/src/tarball/SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b 2) mv -v SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b SQLite-9fb7da6904e479f4.tar.gz 3) tar -xzf

Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-25 Thread Stephan Beal
On Wed, Apr 25, 2012 at 7:09 AM, nn6eumtr nn6eu...@gmail.com wrote: Steps to recreate: http://www.sqlite.org/compile.html#omitfeatures says: *Important Note: The SQLITE_OMIT_* options do not work with the amalgamationhttp://www.sqlite.org/amalgamation.html or with pre-packaged C code files.

Re: [sqlite] CSV to SQLite to web page display

2012-04-25 Thread Simon Slavin
On 24 Apr 2012, at 3:53pm, b2 bruce.black...@gmail.com wrote: I have data that is exported to comma delimited format(CSV) daily / weekly and want to be able to display on the web. Read only with no calculations but more readable date price formats. Number of records will be less than 100.

Re: [sqlite] CSV to SQLite to web page display

2012-04-25 Thread Niall O'Reilly
On 24 Apr 2012, at 15:53, b2 wrote: I have data that is exported to comma delimited format(CSV) daily / weekly and want to be able to display on the web. If all you need to do is to transform some data from one text format (CSV) to another (HTML), I don't see why you would

Re: [sqlite] sqlite3 column widths

2012-04-25 Thread Pete
So I guess that's a No then? I'm fully aware of how sqlite3 treats datatypes and column width specifications, but surely if someone defines a column with a specific max width, it's reasonable to assume that's the max width they want, otherwise why bother defining it? That would seem to be a lot

Re: [sqlite] sqlite3 column widths

2012-04-25 Thread Tim Streater
On 25 Apr 2012 at 17:36, Pete p...@mollysrevenge.com wrote: So I guess that's a No then? I'm fully aware of how sqlite3 treats datatypes and column width specifications, but surely if someone defines a column with a specific max width, it's reasonable to assume that's the max width they

[sqlite] Logging of sqlite3 commands

2012-04-25 Thread Champ Lee
Hello List, I am using the sqlite3 client on MS windows from a command prompt. I frequently issue a number of select commands while exploring data, and before I know it, have entered several dozen, fairly complex select commands. I would like to capture all of those commands into a file. Is

Re: [sqlite] Logging of sqlite3 commands

2012-04-25 Thread Mircea Neacsu
Personally, I do it the other way around: I keep a text editor opened and type my commands there, than paste it into the sqlite prompt window. In the end I have a list of nicely formatted commands in my text editor. Mircea On 25/04/2012 4:59 PM, Champ Lee wrote: Hello List, I am using the

[sqlite] SQLite/LINQ?

2012-04-25 Thread Ken godee
Is there any way to use SQLite/LINQ/C# - programmatically? I'm new to the C# world and once I read about LINQ it sure seemed the way to go. Maybe I'm missing something but I've really beat this to death trying to find a solution. I'm not using Visual Studio. DBLing is dead. LingPad

Re: [sqlite] Logging of sqlite3 commands

2012-04-25 Thread Richard Hipp
On Wed, Apr 25, 2012 at 4:59 PM, Champ Lee champ...@gmail.com wrote: Hello List, I am using the sqlite3 client on MS windows from a command prompt. I frequently issue a number of select commands while exploring data, and before I know it, have entered several dozen, fairly complex select

Re: [sqlite] SQLite/LINQ?

2012-04-25 Thread Taleeb Anwar
I've never tried it - but dblinq http://code.google.com/p/dblinq2007/seems to be one option worth trying. Thanks Regards Taleeb Anwar *Hai Ab bhi Tera Shwarma Afsana Khwan Humara!!* On Thu, Apr 26, 2012 at 5:13 AM, Ken godee k...@perfect-image.com wrote: Is there any way to use

Re: [sqlite] SQLite/LINQ?

2012-04-25 Thread Taleeb Anwar
Oh sorry! there is no update of dbLinq (as you noted) for some time now. What about dotconnect for sqlitehttp://www.devart.com/dotconnect/sqlite/features.html Thanks Regards Taleeb Anwar *Hai Ab bhi Tera Shwarma Afsana Khwan Humara!!* On Thu, Apr 26, 2012 at 10:12 AM, Taleeb Anwar