Re: [sqlite] strict affinity mode

On Fri, 2007-03-23 at 18:53 +0100, stephan nies wrote: > Hi I read about a "strict affinity mode" > on http://www.sqlite.org/datatype3.html. > > But from searching the net, i get the impression > that this mode is not yet implemented. > > I think it seems to be a FAQ since it is even listed > in

[sqlite] Count of rows in every table

Using only SQLite and SQL, is there a way to get a count of rows in each table in the database? I know I can do this via an external application to query sqlite_master and using that list, query a row count of each table, but would prefer to find a pure SQL way if possible. Thanks, Noah

[sqlite] How does SQLite store data?

I created several tables that specified explicitly the size of each column. I put some bogus numbers and text into it but I didn't put numbers in it that would completely fill the column data. I was surprised to find that the resulting database file was smaller than I had expected. This

Re: [sqlite] SQLite installation problems

you need to open the file "tclsqlite.c" and write the follow sentence in the top!.. save and execute ./configure && make && make install #define NO_TCL and that should work On 23/03/07, Brian McCann <[EMAIL PROTECTED]> wrote: Hi, I'm trying to install SQLite in order to use Trac with our

Re: [sqlite] Why does this script fail?

[EMAIL PROTECTED] wrote: The Windows XP console command: sqlite3 baseSP.db < baseSP.sql Error message: SQL error near line 30: near ")": syntax error You will have to include your script in your post. This mailing list does not pass attachments through. Dennis Cote

Re: [sqlite] SQLite installation problems

you need to open the file "tclsqlite.c" and write the follow sentence in the top!.. save and execute ./configure && make && make install #define NO_TCL and that should work- Show quoted text - On 23/03/07, Brian McCann <[EMAIL PROTECTED]> wrote: Hi, I'm trying to install SQLite in order to

[sqlite] SQLite installation problems

Hi, I'm trying to install SQLite in order to use Trac with our SVN repositories. Where running RedHat 4 Ent. I downloaded the source code file sqlite-3.3.13.tgz and followed the README on how to compile but ran into the problem that the header file "tcl.h" could not be found, even though I

[sqlite] Why does this script fail?

The Windows XP console command: sqlite3 baseSP.db < baseSP.sql Error message: SQL error near line 30: near ")": syntax error - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] strict affinity mode

Hi I read about a "strict affinity mode" on http://www.sqlite.org/datatype3.html. But from searching the net, i get the impression that this mode is not yet implemented. I think it seems to be a FAQ since it is even listed in the WIKIFAQ: http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq but

Re: [sqlite] beginner's questions: atexit problem

Dev-CPP is an IDE which uses MinGW. It works well and compiles Sqlite in a very straightforward manner. Joe Wilson wrote: I haven't heard of Dev-Cpp. If you use MinGW gcc from http://mingw.org/ and MSYS, you shouldn't have any problems. --- timm2 <[EMAIL PROTECTED]> wrote: I use MMinGW as

Re: [sqlite] Questions on views

Dennis Volodomanov wrote: Is it quicker (slower or the same) to execute a query on a view or to execute the original query from which this view was created? I'm basically looking for the best (fastest) way to execute thousands of queries to check whether they return any results or not. At

[sqlite] A peculiar error

Hi All, Whenever a write operation is made on the database file, sqlite is creating some intermediate files with some extension (hundreds of files in minutes). And when I exit the program improperly (without calling sqlite3_close ()) all the files remain. If I try to open the