[sqlite] sqlite3 -has_codec in test suite

2010-09-06 Thread Martin Jenkins
Given: > ./testfixture % sqlite3 -has_codec Error: wrong # args: should be "sqlite3 HANDLE FILENAME ?-vfs VFSNAME? ?-readonly BOOLEAN? ?-create BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex BOOLEAN?" % sqlite3 -has-codec 0 and: src/tclsqlite.c:if( strcmp(zArg,"-has-codec")==0 ){ are the

[sqlite] Docs patch

2010-08-05 Thread Martin Jenkins
Hi, I sent a patch which fixes a fairly large number of typos in the 3.7.0 HTML documentation to the list on the 25th July. It was sent from an unsubscribed address and apart from a message saying it would need to be moderated, it appears to have vanished without trace. Is this the sort of

[sqlite] Patch to fix typos in SQLite 3.7.0 HTML documentation.

2010-07-27 Thread Martin Jenkins
nd successors. We intend this dedication to be an overt act of relinquishment in perpetuity of all present and future rights to this code under copyright law. " Regards, Martin Jenkins ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Quick Review/Reference

2008-04-15 Thread Martin Jenkins
metro wrote: > is this what everybody is looking for?? > http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html > there are other sources for free ebooks > > Laurie > It did the rounds on alt.binaries.e-book.technical last year. The buyer's email address had been

Re: [sqlite] SQL Quick Review/Reference

2008-04-15 Thread Martin Jenkins
Mike Owens wrote: >> Mike Owens wrote: >> > I've been lobbying Apress to release the book in electronic form for >> > free. >> That seems a bit extreme > I wasn't referring to releasing the book as an exclusive solution to > the index problem, but rather for the community and SQLite in

Re: [sqlite] SQL Quick Review/Reference

2008-04-14 Thread Martin Jenkins
Mike Owens wrote: > I've been lobbying Apress to release the book in electronic form for > free. It's currently under consideration, but I've not heard anything > back yet. > That seems a bit extreme - how about a user generated/funded index on the web somewhere? Download and print a PDF,

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

2007-06-22 Thread Martin Jenkins
litenoob wrote: Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename "SELECT name FROM tablename WHERE name='smith' LIMIT 1;"` However, if I want to do anything with multiple lines,

Re: [sqlite] Cache invalidation after insert statements.

2007-06-20 Thread Martin Jenkins
Joe Wilson wrote: A non-volatile RAM drive is the way to go if you got the bucks. 16 Processor machine ~40Gb ram EMC storage suggests he does. ;) I worked on a project where the end client had Sun kit of this spec, and they claimed the systems cost 7 figures GBP back in 2005. Martin

Re: [sqlite] Custom Aggregation Not Working

2007-06-19 Thread Martin Jenkins
wcmadness wrote: Hey, Folks: I'm writing a financial application and MUST have exact math decimals (no floats). So, I'm using Python's decimal module. My database is Sqlite (and my language is Python with Pysqlite); Sqlite doesn't offer a non-floating point decimal type. But, it does have

Re: [sqlite] PRAGMA cache_size = 0

2007-06-15 Thread Martin Jenkins
B V, Phanisekhar wrote: What exactly happens when I change the cache_size (both increase and decrease size)? A variable is set. It seems this term is a misnomer. What are we achieving by setting this variable? [...] Will there be any memory that will be freed up when I reduce the size

Re: [sqlite] Override LIKE

2007-05-16 Thread Martin Jenkins
Jonas Sandman wrote: > I am using LIKE to make a simple query for filename '%path%' and it > works well as long as I am only using ANSI characters, LIKE thinks > 'a' and 'A' are the same. When coming up on Greek characters (i.e.) > it doesn't work that well anymore. Suddenly LIKE is

Re: [sqlite] Re: Re: Order of result of a query?

2007-05-16 Thread Martin Jenkins
B V, Phanisekhar wrote: Kennedy, You are using Join that's going to take time. I need the most efficient query. Dan's one of the SQLite developers, so presumably has a rough idea of what his suggested query will be doing... ;) Martin

Re: [sqlite] Multiple connections to the same database and CREATE TABLE command

2007-05-11 Thread Martin Jenkins
Vivien Malerba wrote: Hi! In a single process, I open two connections (C1 and C2) to the same database (this is actually a corner case which could happen) and the following sequence of operations fail: 1- on C1 execute "CREATE table actor (...)" => Ok 2- on C1 execute "SELECT * FROM actor" =>

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-30 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Martin Jenkins <[EMAIL PROTECTED]> wrote: I agree, it is slightly odd for neither of them to reply. Why is it odd? Because you normally reply to these things, if only to say something lie "the pre-processed source for Windows is provided as a courtesy

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-30 Thread Martin Jenkins
Bennett, Patrick wrote: I wasn't sure who maintained the binary distribution and based on the recent list activity, I assumed someone who was responsible would've already replied. As fas as I know, the dev team is Dr Hipp and Dan Kennedy (apologies if there's someone else and I missed you)

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-30 Thread Martin Jenkins
Bennett, Patrick wrote: No comment at all? That's three users asking for this now. :( Dr Hipp usually responds pretty quickly, but sometimes he's away on business. You know, supporting the paying customers... ;) Martin

Re: [sqlite] Recommended wrapper for Python?

2007-04-23 Thread Martin Jenkins
Gilles Ganault wrote: At 14:40 23/04/2007 +0200, Stef Mientki wrote: I've no experience whatsover, but if I see the list, the top one is the best choice, because it'll be integrated in the standard Python. Thanks. I didn't know SQLite was part of Python 2.5. pysqlite implements Python's

Re: [sqlite] Optimize a query

2007-04-17 Thread Martin Jenkins
Marco Bambini wrote: This query on a small database sometimes takes more than 40 seconds: select _rowid, public_id, vote_count, status, summary, component, date(date_modified), quickfix from reports where public = 1 AND _rowid IN (select distinct r._rowid from reports r, segments s where

Re: [sqlite] Looking for sqlite3_fds.h and fds.c

2007-04-13 Thread Martin Jenkins
Huian Li wrote: I have a package which uses functions like sqlite3_get_database_file_fd() and sqlite3_get_journal_file_fd(). Supposedly sqlite3_fds.h has these two functions and fds.c defines them, but I searched both sqlite-3.3.4 and sqlite-3.3.15, and could not find anything. Does anyone know

Re: [sqlite] Data structure

2007-04-11 Thread Martin Jenkins
Lloyd wrote: hi Puneet and Martin, On Wed, 2007-04-11 at 14:27 +0100, Martin Jenkins wrote: File system cache and plenty of RAM? It is meant to run on an end user system (eg. Pentium 4 1GB RAM). If you mean Swap space as file system cache, it is also limited, may be 2GB. I was just

Re: [sqlite] Data structure

2007-04-11 Thread Martin Jenkins
Lloyd wrote: Hi, I don't know whether this is an irrelevant question in SQLite list, but I don't see a better place to ask. Which data structure is best to store and retrieve data very fastly? There is a 95% chance that the searched data to be present in the data structure. There will be 1000s

Re: [sqlite] Journal files not deleted.

2007-04-10 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: www.wipro.com Would this be Wipro, the outsourcing company? Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] SQL and SQLite pronounciation?

2007-04-05 Thread Martin Jenkins
Dennis Cote wrote: P Kishor wrote: Anyway a little digging on wikipedia found this: /SQL/ is commonly spoken either as the names of the letters /ess-cue-el/ I pronounce XQP as ex queue pee so I reckon SQL should be ess queue ell, even if it was around twenty years before I was. Anyone who

Re: [sqlite] SQL and SQLite pronounciation?

2007-04-05 Thread Martin Jenkins
P Kishor wrote: In any case, unless DRH establishes a semi-official policy, let the pronounciation be in public domain as well... to each her own. Well there is that Google video. You could look at that to get Dr Hipp's definitive pronunciation, but ISTR even he wasn't 100% consistent. ;)

Re: [sqlite] multiple request handling

2007-03-30 Thread Martin Jenkins
Pavan wrote: Does SQLite handle multiple request handling ? Yes. Martin - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-29 Thread Martin Jenkins
fangles wrote: When I have text pasted into an sqlite string field, it is stored okay but when I retrieve a string, it is truncated at the first CR (0D). Hi fangles, Did you get this sorted? Martin - To unsubscribe,

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-29 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Martin Jenkins <[EMAIL PROTECTED]> wrote: Very true. Furthermore, the B-Tree interface layer is not a part of the published API and as such it is subject to change without notice and between point releases. I nearly said that the B-Tree interface was unpub

Re: [sqlite] RE: Maintaining Master-Child relationships

2007-03-29 Thread Martin Jenkins
Arora, Ajay wrote: Can anyone please look into my query, I've tables Master ( id integer primary key, field1 text) And Child (id integer, name text) Might be worth looking for Celko's "Hierarchies in SQL". I've not read it but I've seen good reviews and Celko seems well

Re: [sqlite] Difference in these indices?

2007-03-29 Thread Martin Jenkins
John Stanton wrote: Perl would not do a good job. You need to use the Sqlite page structures and they are defined in C terms. But Tcl might. The test suite pokes about with SQLite internals. Martin - To unsubscribe,

Re: [sqlite] CREATE INDEX performance

2007-03-27 Thread Martin Jenkins
Stephen Toney wrote: Meta-question: this is the second time I've asked this question. The first was about a month ago and got not a single reply. Is there something wrong with my postings? Or is this just not an interesting topic? I think it just boils down to how much time people have.

Re: [sqlite] Error reporting problem

2007-03-27 Thread Martin Jenkins
Dan Kennedy wrote: Even using the prepare_v2() interface, the database handle error-code and error-message (the stuff returned by sqlite3_errcode() and sqlite3_errmsg() respectively) are not populated by sqlite3_step(). After sqlite3_step() reports an error you need to call either

Re: [sqlite] Questions on views

2007-03-27 Thread Martin Jenkins
Dennis Volodomanov wrote: [...] The reason that such a huge amount of statements needs to be executed so many times very quickly is that we have a tree built up based on those statements and that tree needs to be pruned if the results of statements are empty in real-time as the user is typing a

Re: [sqlite] Error reporting problem

2007-03-26 Thread Martin Jenkins
Vivien Malerba wrote: Here is a sample test case, just uncompress, run "make" and "./test". Here is what I get using SQLite 3.3.13 (On Linux): SQL error (step): SQL logic error or missing database SQL error (step): column name is not unique It shows that calling sqlite3_reset() seems to be

Re: [sqlite] Error reporting problem

2007-03-26 Thread Martin Jenkins
Vivien Malerba wrote: Hi! I've got an error reporting problem when trying to insert a row which breaks a UNIQUE constraint in a table in a C program, I get the following error with sqlite3_errmsg(): "SQL logic error or missing database" If I fire the sqlite3 program and run the same SQL query,

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

2007-03-26 Thread Martin Jenkins
fangles wrote: SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by whatever wrapper you use on top of SQLite, or simply an artifact of the way you inspect the data (e.g. you look at the string in a debugger, and the debugger just

Re: [sqlite] Index creation on huge table will never finish.

2007-03-22 Thread Martin Jenkins
P Kishor wrote: Mac/Unix person meself, but the Windows XP sort is pretty darn good as well. I'll take a look. Last time I used it it was useless. Win9x days? these days (especially for a one off) I'd probably go straight to doing it in Python to avoid x-platform syntax issues. Martin

Re: [sqlite] Index creation on huge table will never finish.

2007-03-22 Thread Martin Jenkins
Chris Jones wrote: realized that the unix "sort" If I'd known you were on 'nix I'd have suggested using 'sort' and/or 'md5sum' about 12 hours ago. ;) Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Saving binary files

2007-03-18 Thread Martin Jenkins
Dimitris P. Servis wrote: I have to provide evidence that such an anorthodox solution is also feasible If it was me I'd "investigate" the problem by doing the "right" thing in the first place, by which time I'd know enough to knock up the "wrong" solution for the doubters before presenting

Re: [sqlite] Pragma table_info(), why no fields like UNIQUE, AUTOINCREMENT

2007-03-13 Thread Martin Jenkins
Vivien Malerba wrote: I've already sent a proposal along with a patch some time ago about that, but nobody seemed to care, see http://www.mail-archive.com/sqlite-users@sqlite.org/msg21285.html Vivien, I can't see any patch attached to that post. Perhaps you should resubmit it? And I'll guess

Re: [sqlite] notice: embedded system and locked database

2007-03-12 Thread Martin Jenkins
Jakub Ladman wrote: Problem is, that this is pretty obscure system. Renesas SuperH SH4 CPU Heavily patched 2.4.18 kernel. (patches will be presented on internet, but not at this time) Gentoo-embedded linux, based on uclibc 0.9.28 and busybox . Main storage is SD flash card. I must confess,

Re: [sqlite] SQlite 2.8.16 -> SQLite 3

2007-03-12 Thread Martin Jenkins
Mitchell Vincent wrote: So is a 60%ish reduction in DB size from 2.8.16 to 3.3.13 normal? Don't know about "normal" but ISTR version 3 did bring some fairly major improvements in file size. Given that you have your data in both SQLite formats would it not be fairly easy to dump both

Re: [sqlite] Re: Argh, this must be a very stupid question ...

2007-03-12 Thread Martin Jenkins
Stef Mientki wrote: so it was indeed a stupid question ! No, it was a well phrased question with a simple answer. A stupid question is when the message is "I CANT OPEN A DATABSE!!! WHY [EMAIL PROTECTED] IT WORK? IS IT A BUG!!!" and nothing else. ;) mj

Re: [sqlite] stupid man's manual to sqlite?

2007-03-08 Thread Martin Jenkins
Jakub Ladman wrote: Thank you i will try my possibilities buying from amazon, while i am based in the Czech republic. Unfortunately it is little bit expensive for me, to buy it without looking into it before. I don't know if would help, but Apress sell an e-book (PDF) version for about half

Re: [sqlite] notice: embedded system and locked database

2007-03-08 Thread Martin Jenkins
Jakub Ladman wrote: Now i have discovered, that this appears only if the database file is stored on the nfs filesystem (posibly too slow, or something similar) There have been many threads on this list about NFS locking being broken, but few reports of it actually happening. Could you post a

Re: [sqlite] import operation - primary key need to be automatically generated by SQLite (not from csv file)

2007-03-07 Thread Martin Jenkins
RohitPatel wrote: /* SQLite 3.3.8 (Windows) used */ /* table t1 */ /* only two columns are given because other columns are irrelevant here */ create table t1 (id INTEGER PRIMARY KEY, name TEXT); /* few sample records from csv file data.csv */ 1,'name_text_1' 2,'name_text_2' 3,'name_text_3'

Re: [sqlite] Lemon example

2007-03-06 Thread Martin Jenkins
Cesar Rodas wrote: The URL is ok, I opened here... Works fine in .uk too Martin - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] How fast is the sqlite connection created?

2007-03-01 Thread Martin Jenkins
Samuel R. Neff wrote: Eric, Sorry if this is obvious to everyone else but not to me.. what exactly is cursor()? I don't see it anywhere in the C API and the wrapper I'm using (SQLite .NET) doesn't have any corresponding method. A cursor is the thing that you use to run your queries. Eg in

Re: [sqlite] How fast is the sqlite connection created?

2007-02-28 Thread Martin Jenkins
Samuel R. Neff wrote: One last set of performance numbers for opening a connection. :-) All points on the curve. ;) So the impact of open/closing connections on a real-world db really is huge. You're right, that's a huge difference. Good bit of benchmarking there. These tests with

Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-28 Thread Martin Jenkins
Jakub Ladman wrote: But there is not tcl library at the time and when I tried to build sqlite without -DNO_TCL it failed. I think you will have fewer problems building Tcl than you did building SQLite because the automake code will be more up to date. You'v ebuilt SQLite so you're an expert

Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Martin Jenkins
Jakub Ladman wrote: Problem is, that i do not know tcl. I know only that it exist. Jakub That's OK, it's just another target (make test) in the Makefile. You don't need to know any Tcl, you just have to install the source code and know where you've installed it. make test builds a program

Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Martin Jenkins
Jakub Ladman wrote: And what should i do with this? SQLite version 3.3.13 Enter ".help" for instructions sqlite> create table tbl1(one varchar(10), two smallint); SQL error: database is locked sqlite> What was the command line? Can you get Tcl running on your machine? As you've

Re: [sqlite] developers mailing list

2007-02-26 Thread Martin Jenkins
Jakub Ladman wrote: but after correction of this i get: libsqlite3.a -lpthread libsqlite3.a(os_unix.o): In function `sqlite3UnixDlopen': os_unix.c:(.text+0x848): undefined reference to `dlopen' libsqlite3.a(os_unix.o): In function `sqlite3UnixDlsym': os_unix.c:(.text+0x85c):

Re: [sqlite] How fast is the sqlite connection created?

2007-02-26 Thread Martin Jenkins
Samuel R. Neff wrote: Thank you for the testing and information. ;) When I have time to run some tests using our actual schema (120+ tables, several hundred indexes) I'll post back here in case others are interested in our results. From your tests it looks like more complex schemas probably

Re: [sqlite] How fast is the sqlite connection created?

2007-02-26 Thread Martin Jenkins
Martin Jenkins wrote: So the difference in connect times between a database with 1 table and 10 tables is ... It appears that adding indexes (and triggers?) increases the time at about the same rate as adding tables. That is a connect/first select to a database with 1 table and 3 indexes

Re: [sqlite] How fast is the sqlite connection created?

2007-02-26 Thread Martin Jenkins
Peter van Dijk wrote: every time you open an sqlite database file, the sqlite library has to parse all table structures. It is much better to keep your connection/handle open for longer periods of time. On my XP box it takes about 220us to connect to an SQLite database from Python, whether

Re: [sqlite] The best way to delete a column ?

2007-02-26 Thread Martin Jenkins
Stef Mientki wrote: I just read it's not possible to delete a column in an existing table. Now what would be the best way to remove the column indirect (from Delphi code), I've never needed to do this so the following are just hints. The special table "sqlite_master" contains the SQL that was

Re: [sqlite] Sqlite3 in MAC Os

2007-02-26 Thread Martin Jenkins
Kirrthana M wrote: Im developing an application using sqlite3 in MAC OS,I just wanted to know wheather sqlite3 can be used in MAC OS. I don't use Mac, but I *think* SQLite is bundled with later versions. If so can the same sqlite3 library and the executable used in windows can be used in MAC

Re: [sqlite] Using same database with multiple processes

2007-02-25 Thread Martin Jenkins
Thomas Dybdahl Ahle wrote: Hi, I'm running a project using pysqlite for database support. It's awsome. Now I have a user who produces this warning: "Warning: You can only execute one statement at a time." Hard to say without knowing the value of sql in cur.execute(sql) pysqlite's execute

Re: [sqlite] developers mailing list

2007-02-25 Thread Martin Jenkins
Jakub Ladman wrote: You want "make -f Makefile.linux-gcc" This > make Makefile.linux-gcc Will try to build "Makefile.linux-gcc" from a file called "Makefile" Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] How fast is the sqlite connection created?

2007-02-25 Thread Martin Jenkins
Alex Cheng wrote: Hi, I want to know how many time is spent when create a sqlite connection. > Is it effeciency? My application creates a connection and close it > when access DB everytime, is it OK? Going by your sig, here are the times for Python 2.5 running under XP SP2 on a 1.6GHZ

Re: [sqlite] compiling with VC++

2007-02-25 Thread Martin Jenkins
RB Smissaert wrote: OK, I understand better now. This though doesn't seem quite right to me: 0, //sqlite3_libversion, It looks sqlite3_libversion should be a string. No, this is a list of function pointers. C has no notion of the *name* of the function, only its address. Functions are

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Due to me not knowing C I hadn't realized that this structure had to be left intact. It's not a C thing as such, it's the way Dr Hipp has designed it. It's an interface - the third entry in the list always does the same thing but the function that actually runs to do

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Will give that a try and see if it gives any less warnings. OK, but as Dennis suggested and Dr Hipp has confirmed this isn't the way to go. I was assuming the VB thing was a bit of a hack and didn't really read enough of the C code. Martin

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: How would I do this: compile with -DSQLITE_OMIT_LOAD_EXTENSION=1 to leave it out. Remember that link tab I said about earlier? There's a C/C++ tab next to it with a Preprocessor definitions edit box. I think what you want is to put ",SQLITE_OMIT_LOAD_EXTENSION=1" at the

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Microsoft Visual C++ 6 Enterprise edition. Hmm. I'm using VC6++ Pro. I wonder if it's safe to assume the compilers are the same and the difference is that I don't have the Enterprisey middleware gubbins. I think it is the latest before .net came in. Dunno. I kind of

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Thanks, that is very helpful and reassuring as well. Will see if I can figure out then what is causing this one: warning C4028, as you say that could be a typo. I've just built 3.3.12 source with VC6 and didn't see that error. I changed the warning level to 4 and got 500

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Did you make the alterations to make the dll VB compatible? I don't think Dennis was building the VB version. The lines that Todd says you have to comment out - did you comment them out or replace them with a 0? I haven't analysed the code fully but I'm a bit suspicious

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Martin Jenkins
mxs wrote: I had to google around to find out what is wxWidgets ... I decided I'd like to try Python and SQLite Check out wxPython too. Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] sqlite ebuild - my problem, i have half year ago, is still here.

2007-02-24 Thread Martin Jenkins
Jakub Ladman wrote: Hi Friends Please help me I need crosscompile sqlite for my sh4 cpu based linux system, but configure script (any version of sqlite i have tryed, even the actual one from sqlite homepage) fails if crosscompilation is selected. Crosscompiler works good in other cases. Thank

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: When compiling this source code I get 265 warning, which doesn't really worry me that much as it all seems to be working fine, but in general what kind of warning should be taken seriously? This has come up the list before. Dr Hipp assigns a lot more weight to his tests

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Now what do I do make it compile a dll called SQLite3VB.dll? I think it defaults to the project name, but have a look at the Link tab in the Project|Settings dialog (Alt-F7) - there's an edit box titled "Output file name" which might do what you want. Martin

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Thanks, will have a look at that. Do you know from experience that it will compile OK with VC6++? I'm pretty sure I've compiled it with VC6++. I've been compiling on Debian and Solaris machines recently and have sort of lost track of building stuff on Windows. I tried

Re: [sqlite] compiling with VC++

2007-02-24 Thread Martin Jenkins
RB Smissaert wrote: Could anybody pass me step by step instructions to compile the source with MS VC++ ? I don't code or compile in C at all and only code in VB/VBA. There a some instructions at: http://www.sqlite.org/cvstrac/wiki?p=HowToCompile and a zip file - sqlite-source-3_3_13.zip -

Re: [sqlite] BLOB question

2007-02-23 Thread Martin Jenkins
Cesar Rodas wrote: while ( (n=fread(buff,Buffsize,1,file)) > 0) { if (i>0) *value = realloc(*value, (i+1) * Buffsize); memcpy(*value + (i * Buffsize), buff, Buffsize); *len += n; i++; } An afterthought, why don't you just stat the file and

Re: [sqlite] about default file permission of SQLite database file

2007-02-23 Thread Martin Jenkins
Joe Wilson wrote: I can never remember the umask number's effect without experimentation DESCRIPTION umask sets the umask to mask & 0777. The umask is used by open(2) to set initial file permissions on a newly-created file. Specifically, permissions in the umask are turned off from

Re: [sqlite] BLOB question

2007-02-23 Thread Martin Jenkins
Cesar Rodas wrote: > #define uchar unsigned char * suggests it's a char but is in fact a pointer to a char so the signature of LoadFileContent is actually int LoadFileContent(unsigned char **path, unsigned char ***value, ... and that triggers my "three levels of indirection is usually an

Re: [sqlite] Nested Parens Stack Overflow

2007-02-22 Thread Martin Jenkins
Matt Froncek wrote: Martin, Thank you for looking into this. The SQLite3.exe I tested with was 3.1.3. And yes the SQL statement works fine as it. If you add one more nested OR to the SQL statement then it stops working. I don't get a stack overflow like I do in the ODBC driver I was testing

Re: [sqlite] Precision of dates stores as Julian "real"

2007-02-21 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Guess you can't please everybody :-) Right now we have some documentation in the source tree and some on the wiki, which I suppose is guaranteed to please nobody. So make the wiki available for download. ;) Martin

Re: [sqlite] SQLite db lock problem

2007-02-20 Thread Martin Jenkins
Christian Smith wrote: > SQLite has been known to be problematic using NFS drives, mainly due > to flaky NFS locking implementations. I'm not sure it's fair to say SQLite is "problematic". It's susceptible to NFS locking problems in certain situations, but so is any other app which assumes

Re: [sqlite] Search all collumns with LIKE at once

2007-02-19 Thread Martin Jenkins
fangles wrote: PK? I'm sorry but I am not familiar with that term.. Sorry, in this example a Primary Key is a column (eg an integer) which uniquely specifies a row in a table. In the example above you: select all columns from the rows which have a PK in the set ( select the PK from

Re: [sqlite] Search all collumns with LIKE at once

2007-02-18 Thread Martin Jenkins
fangles wrote: I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema? If you had a PK on that table and

Re: [sqlite] Search all collumns with LIKE at once

2007-02-18 Thread Martin Jenkins
fangles wrote: I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema? SELECT * FROM addresses WHERE title

Re: [sqlite] Month string from yyyy-mm-dd

2007-02-18 Thread Martin Jenkins
RB Smissaert wrote: Analyzing the lookup table knocks the time down from 0.36 to 0.31 secs, something I didn't expect. That shows the importance of testing. I ported the SQLite benchmarks to Python and was surprised to see some of the tests taking minutes to run versus a few (or a few tens

Re: [sqlite] Month string from yyyy-mm-dd

2007-02-18 Thread Martin Jenkins
RB Smissaert wrote: Yes, it looks it isn't there. I guess it isn't really SQLite's place to know how to spell this month's name in your locale. It's a presentation issue at the end of the day and a lookup table is a nice easy solution. to update the table and 25000 records takes about a

Re: [sqlite] Month string from yyyy-mm-dd

2007-02-18 Thread Martin Jenkins
RB Smissaert wrote: Is it possible with the date-time functions to get the month as a string, so January etc. from the date in the format -mm-dd? Doesn't look like it. Nothing in the wiki and I couldn't see anything in the source either. I suppose you could use a big case statement if you

Re: [sqlite] SQLite-3.3.13

2007-02-15 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Martin Jenkins <[EMAIL PROTECTED]> wrote: Raised as ticket http://www.sqlite.org/cvstrac/tktview?tn=2232 Thanks. Bug reports are always welcomed. But this problem was fixed yesterday. When you see problems in SQLite, especially problems that have been dis

Re: [sqlite] SQLite-3.3.13

2007-02-15 Thread Martin Jenkins
Raised as ticket http://www.sqlite.org/cvstrac/tktview?tn=2232 Martin - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Difference between sqlite and sqlite3

2007-02-15 Thread Martin Jenkins
Dan Kennedy wrote: On Thu, 2007-02-15 at 11:49 +0100, Pavan wrote: Can anyone tell me what is the difference between sqlite and sqlite3. Also: "SQLite - an embedded database library" "sqlite3 - a shell to allow command line access to SQLite" Martin

Re: [sqlite] Storing contacts list for each user

2007-02-15 Thread Martin Jenkins
Pavan wrote: The idea is that at any point of time user1 should not access user2 details and vice-versa. SQLite doesn't have a concept of access control so if you want to stop user1 from seeing user2's data then you'll either have to use a database that does provide access control or , as

Re: [sqlite] Storing contacts list for each user

2007-02-15 Thread Martin Jenkins
Pavan wrote: Should i create different tables for each user, so hat at any point of time only one users data will be accessed ? Should i store all the information in one table and then acess it ? The word you want is "normalisation" and you could have a look at, say,

Re: [sqlite] SQLite-3.3.13

2007-02-14 Thread Martin Jenkins
Martin Jenkins wrote: I haven't tested the other versions of Tcl yet. I have now. s/a/RDRW/ makes corrupt2.test work with Tcl 8.4.9, 8.4.12, 8.4.14 and 8.5a5 on recent versions of Debian/Ubuntu on sparc64 and x86. Martin

Re: [sqlite] SQLite-3.3.13

2007-02-14 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: I get the same problem on OS-X. But it appears to be a bug in the older version of TCL you have installed, not in SQLite itself. Nothing to worry about. Thanks for reporting it, though. I was trying to make a test case to report the Tcl bug and noticed that (in

Re: [sqlite] SQLite-3.3.13

2007-02-13 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: > in the older version of TCL you have installed, not in SQLite Hmm. It's definitely a Tcl bug, but I'm not convinced about it being in the older Tcl that I have - the SPARC machine that fails corrupt2.test has a newer version than the PC that passes. [later] I

Re: [sqlite] SQLite-3.3.13

2007-02-13 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: I get the same problem on OS-X. But it appears to be a bug in the older version of TCL you have installed, not in SQLite It's definitely a bug in Tcl. I'll post the log for posterity and get a newer version. [EMAIL PROTECTED]:~/dev/sqlite/bld$ echo "Hello SQLite" >

Re: [sqlite] SQLite-3.3.13

2007-02-13 Thread Martin Jenkins
Martin Jenkins wrote: corrupt2 tests fail on Solaris 9/Ultra5/csw tools Test file is not actually corrupted (ie altered at all AFAICS) Exact same failure on a fresh Debian 3.1r4 install too. All other tests passed OK. [EMAIL PROTECTED]:~/dev/sqlite/bld$ uname -a Linux ultra5b 2.4.27-3

Re: [sqlite] SQLite-3.3.13

2007-02-13 Thread Martin Jenkins
Martin Jenkins wrote: Build fails on Solaris 9/Ultra5/csw tools Can't find 'ar' so substitutes and attempts to fun 'false' TMP FIX: AR=gar ../configure... Forgot - fdatasync is in librt so most of the executables need $(TLIBS) added to the end of their recipe. Martin

Re: [sqlite] SQLite-3.3.13

2007-02-13 Thread Martin Jenkins
Build fails on Solaris 9/Ultra5/csw tools Can't find 'ar' so substitutes and attempts to fun 'false' TMP FIX: AR=gar ../configure... corrupt2 tests fail on Solaris 9/Ultra5/csw tools Test file is not actually corrupted (ie altered at all AFAICS) Not sure how many people (outside of

Re: [sqlite] Running out of disk space.

2007-02-09 Thread Martin Jenkins
Jeffrey Rennie wrote: Debugging the code: winWrite returns SQLITE_FULL, which propagates back up the stack to vdbeaux.c, line 1270, in function sqlite3VdbeHalt(Vdbe *p): }else if( rc!=SQLITE_OK ){ p->rc = rc; sqlite3RollbackAll(db); Which is good, it's putting the

Re: [sqlite] x000 line queries - only for benchmarks?

2007-02-08 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: There is no problem running queries of whatever length, so I could do benchmarks fine, it is just that VBA has a problem with array elements holding over 1823 characters. OIC. Sorry, just pulled an all-nighter and misread your message. I don't do VB/VBA so wasn't

Re: [sqlite] x000 line queries - only for benchmarks?

2007-02-08 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: In my (commercial) app I regularly have queries with over 1000 characters. Not over 1000 lines though. As VBA (not sure now about VB6) has a problem with array elements having over 1823 characters I had to truncate my SQL logging routine. Under 2k? That seems a bit

  1   2   3   >