[sqlite] CSV to SQLite to web page display
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 the job. Are there any tools or operators to make this job simple ? I have little experience with SQLite and was concerned that I might be going down the wrong path. b2 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Possible bug when rebuilding amalgamation without triggers or altertable
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 SQLite-9fb7da6904e479f4.tar.gz 4) cd SQLite-9fb7da6904e479f4 5) OPT_FEATURE_FLAGS=-DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS4 \ -DSQLITE_ENABLE_LOCKING_STYLE=0 -DSQLITE_ENABLE_MEMORY_MANAGEMENT \ -DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \ -DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM -DSQLITE_OMIT_BUILTIN_TEST \ -DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DATETIME_FUNCS \ -DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \ -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \ -DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_TRACE \ -DSQLITE_OMIT_TRIGGER -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \ ./configure --disable-tcl --disable-readline 6) make sqlite3.c 8) Compile - gcc -c -Wall -DSQLITE_ENABLE_FTS3_PARENTHESIS \ -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_LOCKING_STYLE=0 \ -DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_ENABLE_MEMSYS5 \ -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \ -DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM \ -DSQLITE_OMIT_BUILTIN_TEST -DSQLITE_OMIT_COMPLETE \ -DSQLITE_OMIT_DATETIME_FUNCS -DSQLITE_OMIT_DEPRECATED \ -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \ -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \ -DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE \ -DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRIGGER \ -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \ -DSQLITE_ZERO_MALLOC sqlite3.c This will produce the following errors: sqlite3.c:(.text+0x462d2): undefined reference to `sqlite3AlterBeginAddColumn' sqlite3.c:(.text+0x462fe): undefined reference to `sqlite3AlterFinishAddColumn' sqlite3.c:(.text+0x46331): undefined reference to `sqlite3AlterRenameTable' sqlite3.c:(.text+0x46482): undefined reference to `sqlite3DropTrigger' sqlite3.c:(.text+0x4657b): undefined reference to `sqlite3TriggerSelectStep' sqlite3.c:(.text+0x465b9): undefined reference to `sqlite3TriggerDeleteStep' sqlite3.c:(.text+0x4660a): undefined reference to `sqlite3TriggerInsertStep' sqlite3.c:(.text+0x46661): undefined reference to `sqlite3TriggerInsertStep' sqlite3.c:(.text+0x466b0): undefined reference to `sqlite3TriggerUpdateStep' sqlite3.c:(.text+0x4688d): undefined reference to `sqlite3BeginTrigger' sqlite3.c:(.text+0x468f8): undefined reference to `sqlite3FinishTrigger' ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable
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. SQLITE_OMIT_* compile-time options only work correctly when SQLite is built from canonical source files.* -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] CSV to SQLite to web page display
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. MySQL is an overkill for this and I was hoping that SQLite might do the job. Are there any tools or operators to make this job simple ? I have little experience with SQLite and was concerned that I might be going down the wrong path. Are you a programmer ? SQLite interfaces well with pretty-much every programming language I've found. Writing something to turn the output from a SELECT into HTML is easy. If not, SQLite has a shell tool which will prepare the results of a SELECT in the format of an HTML table, from the 'table' tag to the '/table' tag. See this page for details on the shell tool: http://www.sqlite.org/sqlite.html So you could prepare the rest of your web page, and slot the up-to-date output into an existing web page, or make a 'beforeTable.txt' file and an 'afterTable.txt' file and concatenate them all together. Doing all this in a usable form would probably require you to understand at least a scripting system, though. Batch files if you're using Windows, Automator if you're using a Mac, or a shell script if you're using Unix. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] CSV to SQLite to web page display
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 need to pass the data through a database. If I'm not mistaken, Perl has at least one module for reading CSV data; no doubt so have other scripting languages. Sounds like a nice exercise! Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 column widths
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 less arbitrary than the current logic for determining the default column width. On Wed, Apr 25, 2012 at 9:00 AM, sqlite-users-requ...@sqlite.org wrote: Message: 23 Date: Tue, 24 Apr 2012 13:43:25 -0700 From: Roger Binns rog...@rogerbinns.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3 column widths Message-ID: 4f97106d.7080...@rogerbinns.com Content-Type: text/plain; charset=ISO-8859-1 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/04/12 13:26, Pete wrote: Is there way to have sqlite3 display the columns in the result of a SELECT statement using their defined widths in the schema? For example if a column is defined as Name(40) TEXT, I want the column to be 40 chars wide. Those numbers you put in the schema are ignored by SQLite and do not limit or provide any hints to any SQLite code. How SQLite deals with types is detailed here: http://www.sqlite.org/datatype3.html Separately from that the SQLite source code is public domain and you have the full rights to modify it, redistribute it etc. You can modify the code to work however you want. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk+XEG0ACgkQmOOfHg372QRCpgCdEVfimkFYA8kx3WQixtfEVEAs DpEAoLY1FVYSbQVNZoRM0dTa1fmUbsKj =uuvW -END PGP SIGNATURE- -- Pete Molly's Revenge http://www.mollysrevenge.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 column widths
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 want, otherwise why bother defining it? That would seem to be a lot less arbitrary than the current logic for determining the default column width. If you're talking about the CLI program called sqlite3, then as has been stated, it has no information pertaining to how wide you want the column to be. As I understand it, classical SQL (if that's the term) allowed you in your table definition to define and thereby limit a column width. Personally I see no merit in that and am glad that SQLite doesn't enforce it, just as PHP, for example, doesn't expect you to pre-define the length of a string. I suppose SQLite allows you to give a width but then ignores it, as is well documented. Nothing to stop you adding some code to the sqlite3 CLI program to have extra commands, allowing you to define column widths for display purposes. E.g: sqlite3 .colwidth x 27 where x is the name of a column in some table. -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Logging of sqlite3 commands
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 there a way that I can turn on some kind of command logging, where everything I typed in could be echoed to a file? From a standard DOS command line I might do something like: doskey /h c:\logfile.txt Thanks in advance for any pointers, champl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Logging of sqlite3 commands
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 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 there a way that I can turn on some kind of command logging, where everything I typed in could be echoed to a file? From a standard DOS command line I might do something like: doskey /hc:\logfile.txt Thanks in advance for any pointers, champl ___ 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
[sqlite] SQLite/LINQ?
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 works great, not sure how. Builds it's own connect. I can use ADO.Net no problem, just seems can't find a Linq provider. So if my thinking is right buy Visual Studio or use ADO.Net seems to be the choice or maybe ALing ($$) Thought I'd give the list a shot before I give up and just resort to ADO. Ideas? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Logging of sqlite3 commands
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 commands. I would like to capture all of those commands into a file. Is there a way that I can turn on some kind of command logging, where everything I typed in could be echoed to a file? From a standard DOS command line I might do something like: doskey /h c:\logfile.txt The .trace command was added to the command-line shell on 2012-04-04http://www.sqlite.org/src/info/b9ac3d7e34. It will be in the next release. Or you can grab the latest source from the VCS http://www.sqlite.org/src/timeline and compile them yourself if you are in a hurry. Thanks in advance for any pointers, champl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite/LINQ?
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 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 works great, not sure how. Builds it's own connect. I can use ADO.Net no problem, just seems can't find a Linq provider. So if my thinking is right buy Visual Studio or use ADO.Net seems to be the choice or maybe ALing ($$) Thought I'd give the list a shot before I give up and just resort to ADO. Ideas? __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://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] SQLite/LINQ?
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 taleeban...@gmail.comwrote: 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 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 works great, not sure how. Builds it's own connect. I can use ADO.Net no problem, just seems can't find a Linq provider. So if my thinking is right buy Visual Studio or use ADO.Net seems to be the choice or maybe ALing ($$) Thought I'd give the list a shot before I give up and just resort to ADO. Ideas? __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://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
