Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

2014-04-18 Thread Christian Smith
On Tue, Apr 01, 2014 at 01:08:59PM +, Harmen de Jong - CoachR Group B.V. wrote: > We have built our own SQLite database server application and are considering > making this open source. Since there will be some time involved into making > it an open source project and maintaining it, we

Re: [sqlite] NOP INSERT still writes to the DB/journal

2014-05-06 Thread Christian Smith
On Mon, May 05, 2014 at 05:00:08PM -0400, Richard Hipp wrote: > On Mon, May 5, 2014 at 4:53 PM, Patrick Donnelly wrote: > > > Hi, > > > > I have an INSERT that looks like > > > > INSERT INTO T > > SELECT ... > > > > which I'm running numerous times a second that

Re: [sqlite] fsync and ext3 ordered mode, data integrity.

2011-08-26 Thread Christian Smith
On Tue, Aug 23, 2011 at 09:28:35AM +0200, Sébastien Escudier wrote: > Hi, > > I am currently using sqlite on an ext3 file system with ordered mode. > But we have serious performance issues when sqlite calls fsync, > especially on RAID devices. > > We noticed that disabling fsync in sqlite OR

Re: [sqlite] SQLite on AIX

2011-09-19 Thread Christian Smith
On Thu, Sep 15, 2011 at 05:47:47AM +, Grice, Lynton (L) wrote: > Hi Ross, > > Many thanks for your response, I really appreciate it and will definitely > drop you a quick email if I have any issues with the build. > > I am going to install GCC onto the AIX 5.3 box and will give it a try. I

Re: [sqlite] SQLite disc and I/O usage

2011-09-19 Thread Christian Smith
On Mon, Sep 19, 2011 at 02:42:42PM +0100, Jaco Breitenbach wrote: > Hi Simon, > > Thanks for the reply. > > On 19 September 2011 13:23, Simon Slavin wrote: > > > > I run the database (3.7.7.1) in WAL mode, with checkpointing performed at > > 10 > > > minute intervals. > >

Re: [sqlite] SQLite on armv7l GNU/Linux - JDBC issues - any suggestions?!

2011-09-25 Thread Christian Smith
On Sun, Sep 25, 2011 at 11:08:38AM +0100, Katie Blake wrote: > Hello, Hello, Katie! > > I hope that this is the correct list to send this question. > I am trying to use SQLite on a Gumstix Linux module running Angstrom armv7l > GNU/Linux. (32-bit­). > > I have installed the sqlite packages

Re: [sqlite] SQLite on armv7l GNU/Linux - JDBC issues - any suggestions?!

2011-09-25 Thread Christian Smith
On Sun, Sep 25, 2011 at 09:52:00PM +0100, Christian Smith wrote: > On Sun, Sep 25, 2011 at 11:08:38AM +0100, Katie Blake wrote: > > > > I hope that this is the correct list to send this question. > > I am trying to use SQLite on a Gumstix Linux module running Angstrom armv7l

Re: [sqlite] Auto Vaccum and fragmentation?

2007-04-16 Thread Christian Smith
Ludvig Strigeus uttered: Assuming I have an autovacuum database that primarily stores 32k blobs. If I add/remove lots of rows, will this lead to excessive fragmentation of the overflow chains, or does Sqlite do anything to try to unfragment the pages belonging to a single row? I believe

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-29 Thread Christian Smith
Kalyani Tummala uttered: I am planning to use sqlite as a database for storing and retrieving media data of about 5-10k records in a device whose main memory is extremely small. A sequence of insert statements increasing the heap usage to nearly 70K(almost saturating point) which is crashing my

Re: [sqlite] Does Attach improve Concurrency ?

2007-06-05 Thread Christian Smith
[EMAIL PROTECTED] uttered: When you have a connection with multiple attached databases and the connection acquires an exclusive lock, does it always lock all attached databases or does it keep track of which databases require the lock? 1st process: C:\Documents and

Re: [sqlite] Does Attach improve Concurrency ?

2007-06-05 Thread Christian Smith
Eduardo Morras uttered: At 19:32 01/06/2007, you wrote: When you have a connection with multiple attached databases and the connection acquires an exclusive lock, does it always lock all attached databases or does it keep track of which databases require the lock? Does using separate

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Christian Smith
Rich Rattanni uttered: The databases will be in flux, and I didnt necessairly want to suspend the application that is performs reads and writes into the database. A simple copy worries me because it seems like messing with SQLITE on the file level is dangerous since you circumvent all the

Re: [sqlite] Journal File Optimization

2007-06-18 Thread Christian Smith
Andre du Plessis uttered: How can one optimize the creation of the journal file. The problem is this, for our system which is an event based one each message needs to be insterted and committed to the database (guaranteed), this results in a commit per insert, this was obviously unacceptably

Re: [sqlite] Recovery After Crash

2007-06-18 Thread Christian Smith
Asif Lodhi uttered: Hi Kees, Thanks for replying. On 6/17/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: >... thankful if you experts would give me an "accurate" and fair >picture of the crash-recovery aspects of SQLite - without any hype. I'm not sure if you would qualify this as hype, but

Re: [sqlite] Lemon Parser - Modular & Extensible ?

2007-06-18 Thread Christian Smith
Uma Krishnan uttered: Hello: Is lemon parser modular and extensible? Extensible to do what? It generates parsers, and is self contained. It does a single job, and does it well. What more could you ask for? Thanks Uma Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi Everybody, I have

Re: [sqlite] Lemon Parser - Modular & Extensible ?

2007-06-19 Thread Christian Smith
Uma Krishnan uttered: Hey, There's no need to be offensive. I did not mean to be critical. Far from it, it does a great a job (far more than I'm capable of producing). What I was trying to find out was, if it is possible for a .y files to be broken such that it can be built on top on other .y

Re: [sqlite] Cache invalidation after insert statements.

2007-06-19 Thread Christian Smith
pompomJuice uttered: I suspected something like this, as it makes sense. I have multiple binaries/different connections ( and I cannot make them share a connection ) using this one lookup table and depending on which connection checks first, it will update the table. What is your working

Re: [sqlite] Converting from 2.8.x to 3.x?

2007-06-20 Thread Christian Smith
Gilles Ganault uttered: Hello As we move from a 2.8.x file-based solution to a 3.x c/s solution, we'll have to convert databases from one format to the other. What's the easiest way to do this? sqlite olddb .dump | sqlite3 newdb Thank you G. Christian -- /"\ \ /ASCII

Re: [sqlite] Milliseconds

2007-07-13 Thread Christian Smith
John Stanton uttered: The Sqlite date/time routimes have a resolution to seconds, not milliseconds. If you want milliseconds from SQL implement your own user defined functions which give you milliseconds. You would access the time functions using the API of the underlying OS. You might

Re: [sqlite] Get the data from previous months: please, help me to optimize the query...

2007-07-13 Thread Christian Smith
Joe Wilson uttered: CREATE TABLE 'Months' ( IDMonth INTEGER PRIMARY KEY NOT NULL, MonthRef INTEGER ); (where MonthRef is the date of the first day of the month - created in the code) Using what epoc? CustomerData -- CREATE TABLE

Re: [sqlite] Milliseconds

2007-07-15 Thread Christian Smith
Scott Baker uttered: Christian Smith wrote: If you use the julianday representation, the integer component is the number of days since "noon in Greenwich on November 24, 4714 B.C", with the fractional part being the fraction of that day. Hence, the resolution is determined by the

Re: [sqlite] In-Memory Database: Delete rows on a Table increases the memory usage.

2007-08-01 Thread Christian Smith
Lokesh Babu uttered: Hello Folks, When I perform the DELETE operation on a Table using In-Memory Database (":memory:"), the memory usage increases. I tried using PRAGMA auto_vacuum=1; /* result - nothing works */ Even I tried using VACUUM table_name; /* this too isn't work */ if I perform

Re: [sqlite] In-Memory Database: Delete rows on a Table increases the memory usage.

2007-08-02 Thread Christian Smith
memory back to the operating system. I don't know of specific instances of libc that do this, so I can't help further, sorry. Thanks On 8/1/07, Christian Smith <[EMAIL PROTECTED]> wrote: Lokesh Babu uttered: Hello Folks, When I perform the DELETE operation on a Table using In-

Re: [sqlite] In-Memory Database: Delete rows on a Table increases the memory usage.

2007-08-03 Thread Christian Smith
. Christian Smith wrote: Lokesh Babu uttered: Hello Folks, When I perform the DELETE operation on a Table using In-Memory Database (":memory:"), the memory usage increases. I tried using PRAGMA auto_vacuum=1; /* result - nothing works */ Even I tried using VACUUM table_name; /* this too

Re: [sqlite] [SQLite improve productivity]

2007-08-05 Thread Christian Smith
A common issue of high latency transactions. SQLite has a high per-transaction overhead, which can be amortized across multiple INSERTs or UPDATEs to improve the average INSERT rate. You are doing a single INSERT per transaction, so wrap multiple INSERTs inside a single "BEGIN" ... "END"

Re: [sqlite] sqlite as server queries

2007-08-06 Thread Christian Smith
Edwin Eyan Moragas uttered: hi group, i have several small questions for the group any experiences or thoughts shared would be greatly appreciated. 1) anybody used sqlite as a sql server? i'm thinking of say using the embedded sqlite in PHP5 or similar. 2) anybody ever implemented something

Re: [sqlite] [SQLite improve productivity]

2007-08-06 Thread Christian Smith
Igor Mironchick uttered: Thx, very helpfull reply. One more question: is it need to do "END" after "BEGIN" or enought "COMMIT"? You can use "COMMIT". Probably should do, as it is more descriptive about what is happening. Check the docs for transaction commands:

Re: [sqlite] sqlite as server queries

2007-08-07 Thread Christian Smith
Edwin Eyan Moragas uttered: On 8/6/07, Christian Smith <[EMAIL PROTECTED]> wrote: 2) anybody ever implemented something like a single process of sqlite doing queries for a lot of networked clients? A few people have implemented such a solution. It loses one of the benefits of

Re: [sqlite] version 3.5.0 - Segv

2007-09-02 Thread Christian Smith
[EMAIL PROTECTED] uttered: [EMAIL PROTECTED] wrote: Ken <[EMAIL PROTECTED]> wrote: Recompiled with: gcc -DSQLITE_THREADSAFE -I. -I../src ^^^ Should be -DSQLITE_THREADSAFE=1 The =1 is important in this case. This problem will likely come up again. To try and work

Re: [sqlite] Difference between OR and IN [http://www.sqlite.org/php2004/page-052.html]

2007-09-02 Thread Christian Smith
Once you get your first row back (corresponding to (a==1), simply halt there and sqlite3_finalize() or sqlite3_reset the statement. You control the execution and how many rows you want back. RaghavendraK 70574 uttered: Hi, Ok. Is there any way to tell the VDBE to stop execution moment it

Re: [sqlite] multiple connections

2007-09-10 Thread Christian Smith
Joe Wilson uttered: --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: In 3.5, cache can be shared between all threads, but shared cache is still disabled by default. You have to invoke sqlite3_enable_shared_cache() to turn it on. I put a comment in the documentation that we might turn shared

Re: [sqlite] using lemon to create a c++ parser class

2007-12-09 Thread Christian Smith
Wilson, Ron uttered: It has been a very long time since I have tinkered with lex/yacc but my current project requires a parser. I'm thinking of learning lemon. Frankly, the sqlite code base is far more complex than what I will implement. Is anyone willing to share a lemon parse.y code

Re: [sqlite] Avoiding Fragmentation of SQLite database file ???

2006-06-14 Thread Christian Smith
John Stanton uttered: Jay Sprenkle wrote: On 6/14/06, RohitPatel <[EMAIL PROTECTED]> wrote: Any solution to that (which does not force end-user of app to manage sqlite file fragments or to defragment disk) ? A scheduled task or cron job is trivial to implement and does not add any

Re: [sqlite] SQLite Vs VistaDB - Comparison ???

2006-06-16 Thread Christian Smith
Bogus�aw Brandys uttered: [EMAIL PROTECTED] wrote: Mikey C <[EMAIL PROTECTED]> wrote: Please implement table and row level locking. :-) People commonly believe that doing so must be easy. I certainly get a lot of requests for it from people who think they know how. But in fact, row-level

Re: [sqlite] How to port SQLite to a uc/os-II OS with customized file system?

2006-06-21 Thread Christian Smith
Ҷ�� uttered: Hi,all I'm trying to bulid a database engine based on uc/os-II RTOS with my own customized file system(similar with FAT16, but not exactly the same). I find that SQLite is a good choice. I have read the SQLite source code for several days, but I still have no idea where I

Re: [sqlite] Delete performance vs. Insert performance

2006-06-21 Thread Christian Smith
Insun Kang uttered: Hi. I tested big deletes performance and big insert performance on a Windows CE device in various cache size configurations. ( 1MB, 100KB, 50KB ) Insert 3000 records performs within 23sec, 43sec and 61sec, with respect to each cache size configuration. However, delete 1000

Re: [sqlite] Re: Opening the database file for read on Windows XP

2006-06-21 Thread Christian Smith
Igor Tandetnik uttered: Ran <[EMAIL PROTECTED]> wrote: Thanks for your reply. I know that I should lock the file before copying it, and the "BEGIN IMMEDIATE" is indeed a nice trick. However, I think I didn't explain my problem clearly. I would like to copy that file _without_ using the sqlite

Re: [sqlite] Delete performance vs. Insert performance

2006-06-22 Thread Christian Smith
Jay Sprenkle uttered: On 6/21/06, Christian Smith <[EMAIL PROTECTED]> Adding to the free list will touch each page at most once, and thus caching adds no benefit (and has no loss for a smaller cache.) Inserting may touch each page multiple times, for such operations as rebalancing th

Re: [sqlite] Re: Re: Opening the database file for read on Windows XP

2006-06-22 Thread Christian Smith
Igor Tandetnik uttered: Christian Smith <[EMAIL PROTECTED]> wrote: Igor Tandetnik uttered: You want to enable sharing. Pass FILE_SHARE_READ | FILE_SHARE_WRITE as the third parameter. Surely not FILE_SHARE_WRITE! You don't want other processes writing the database while you're c

Re: [sqlite] How to port SQLite to a uc/os-II OS with customized file system?

2006-06-23 Thread Christian Smith
Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, June 21, 2006 7:04 PM Subject: Re: [sqlite] How to port SQLite to a uc/os-II OS with customized file system? Ҷ uttered: Hi,all I'm trying to bulid a database engine based on

Re: [sqlite] sqlite3_free()

2006-06-27 Thread Christian Smith
[EMAIL PROTECTED] uttered: Two SQLite APIs, sqlite3_exec() and sqlite3_mprintf(), return strings in memory obtained from a malloc-like memory allocator. The documentation has always said that you need to use sqlite3_free() in order to free those strings. But, as it happens, it has until now

Re: [sqlite] sqlite3_free()

2006-06-27 Thread Christian Smith
[EMAIL PROTECTED] uttered: Christian Smith <[EMAIL PROTECTED]> wrote: My own personal opinion on these coding style issues is if the API requires special handling of cleanup, then the API should do the cleanup. Returning an allocated string that requires special cleanup r

Re: [sqlite] sqlite3_free()

2006-06-27 Thread Christian Smith
Dennis Cote uttered: Christian Smith wrote: Yes, of course, Windows sticks it's oar in again. Going back to the previous DLL discussion, this alone is surely confirmation of why the Windows DLL system sucks. This really has nothing to do with the Windows DLL system. It is simply the case

Re: [sqlite] sqlite3_free()

2006-06-27 Thread Christian Smith
Andrew Piskorski uttered: On Tue, Jun 27, 2006 at 04:14:37PM +0100, Christian Smith wrote: Anyway, it's not difficult to provide thread local storage. HP-UX's netdb.h functions (gethostbyname etc.) are fully re-entrant despite returning 'static' data, for example. Other UNIXs got hamstrung

Re: [sqlite] Huge performance difference between SQLite on Windows XP and Windows 2000

2006-06-27 Thread Christian Smith
Lukáš Neumann uttered: Hello, I am using SQLite DLL version 3.2.1 to access a single file database. I use sqlite3_exec() to call this simple query: BEGIN; INSERT INTO Messages (IDMessage, Body) VALUES (1054, 'Test'); COMMIT; When the application runs under Windows XP, the query takes

Re: [sqlite] sqlite3_free_table question

2006-06-29 Thread Christian Smith
Dennis Cote uttered: Your call to sqlite3_free_table is correct. You free the error message by calling sqlite3_free(tresult.err_msg). If either pointer returned by sqlite3_get_table() is NULL, then no memory was allocated, so there is no need to free it, however I believe it should be safe

Re: [sqlite] Problem with compiling under HP-UX

2006-07-03 Thread Christian Smith
Henrik Goldman uttered: Hi, I have a new HP-UX maching running latest official OS B.11.23 and has gcc 4.1.1. The problem is that when I try to configure I get an error: bash-3.00# ./configure CFLAGS="-O2 -lp64" --enable-threadsafe checking build system type... ia64-hp-hpux11.23 checking

RE: [sqlite] endian-specific code in pure c source release?

2006-07-04 Thread Christian Smith
Pat Wibbeler uttered: A quick search through the sqlite source release led me to believe that the source may be coded around endian issues. I guess what I'm looking for is affirmation or denial of my cursory reading. If the source is endian dependent, how does sqlite configure and/or make

Re: [sqlite] Using sqlite on Nintendo DS / PSP

2006-07-06 Thread Christian Smith
ahochan uttered: I'm building a dictionary application that will run on Nintendo DS and PSP. I'm considering using sqlite to store the database which will will be read-only, and embedded on rom. Is it possible to get sqlite to read the database directly from such a pre-allocated memory area?

Re: [sqlite] Compressing the DBs?

2006-07-06 Thread Christian Smith
[EMAIL PROTECTED] uttered: Mikey C <[EMAIL PROTECTED]> wrote: Not sure what you mean there DRH, but I set compression on one of my database files on NTFS and file size shrunk from 1,289,216 bytes to 696,320 bytes. And of course the whole compression / decompression process is completely

Re: [sqlite] Compressing the DBs?

2006-07-06 Thread Christian Smith
Gussimulator uttered: I've been using SQLite for a very short period of time and so far Its doing a great job for my application (single user, quite a big amount of data though). Now, since theres a lot of repetitive data, I thought that compressing the database would be a good idea, since,

Re: [sqlite] Fwd: sqlite3_busy_timeout() on NetBSD

2006-07-07 Thread Christian Smith
[EMAIL PROTECTED] uttered: =?ISO-8859-1?Q?Tobias_Rundstr=F6m?= <[EMAIL PROTECTED]> wrote: Is there something wrong with sqlite3_bus_timeout on NetBSD? I've not had any problems with sqlite3_busy_timeout on Linux. And I do not have NetBSD handy for testing. Not sure what the problem might

Re: [sqlite] callback function parameters in UTF-16?

2006-07-10 Thread Christian Smith
Tzu-Chien Chiu uttered: OK. But what I don't understand is: is this (lack of sqlite3_exec16) by design? The sqlite3_exec function is a deprecated interface used by earlier SQLite releases. New applications should use, for performance reasons if nothing else,

[sqlite] Curious join issue

2006-07-10 Thread Christian Smith
Hello JOIN expoerts:) I have the following schema: CREATE TABLE instances ( instanceid integer primary key, type, instance); CREATE INDEX instances_type_instance ON instances(type,instance); CREATE TABLE instance_fields ( instanceid references instances(instanceid), field, subscript

Re: [sqlite] Curious join issue

2006-07-11 Thread Christian Smith
) ); DRH, Is this expected behaviour? I'd have thought the manifest typing would have seen to that, but it appears that join fields need to be the same type. Christian Christian Smith uttered: Hello JOIN expoerts:) I have the following schema: CREATE TABLE instances ( instanceid integer

Re: [sqlite] Curious join issue

2006-07-11 Thread Christian Smith
[EMAIL PROTECTED] uttered: Christian Smith <[EMAIL PROTECTED]> wrote: select FROM instances as i inner join instance_fields as count using(instanceid) inner join instance_fields as first using (instanceid) inner join instance_fields as last using (instanceid) inne

Re: [sqlite] Curious join issue

2006-07-11 Thread Christian Smith
[EMAIL PROTECTED] uttered: "Brandon, Nicholas (UK)" <[EMAIL PROTECTED]> wrote: I don't want to hijack this thread (not too much anyway) but this got me thinking about JOINs since I have a database that uses a similar concept (one table holds a number of key-value pairs for another). As I

Re: [sqlite] problems compiling with arm-linux-gcc

2006-07-12 Thread Christian Smith
Keiichi McGuire uttered: This is a bit confusing, especially since if I compile it using gcc it will compile w/o any problems. What would this "incompatibility" mean and what would a solution be to make it compatible and be found by the compiler? Chances are that the libsqlite.a you're

Re: [sqlite] SQL error: database disk image is malformed

2006-07-12 Thread Christian Smith
Bull219 uttered: Dear all, I am developping a freeware which uses SQLite. One of my beta testers informed me about an issue he had: with his DB, following the query which is sent to the DB, I have the error in the subject of this email. I did some testing, and when I succeeded in

Re: [sqlite] filter and sort in CREATE VIEW or CREATE TABLE ?

2006-07-13 Thread Christian Smith
Inline. Jens Miltner uttered: Hi all, I need to create a temporary table holding ID column values from a number of tables, so that I have a unique way to access the data for display purposes: say I have 2 related tables [snip schema] When displaying a filtered subset of the persons with

Re: [sqlite] using max value

2006-07-13 Thread Christian Smith
Keiichi McGuire uttered: I'm a bit stuck on this one problem I have this simple table that has two fields: id and value. What I want to do is to get the largest id (the last entry) and then add an arbitrary number to the value that's in the same entry as that one, and put the result in the

Re: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Christian Smith
John Newby uttered: Hi Martin, I'm not sure, I don't use VB that often, I just need to use it for my Uni project at the moment. With all due respect to your University, but VB sucks as a teaching language IMO. Doesn't your Uni have better development tools? Any professor that advocates VB

Re: [sqlite] using max value

2006-07-13 Thread Christian Smith
Jay Sprenkle uttered: On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote: You can't use aggregate functions in WHERE clauses. Also, you can't use a select as the value in an insert. You can insert from the results of an insert. uh...It seems to work: The OP was trying to use a

Re: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Christian Smith
the pragma twice, once to count the number of columns, allocate the array, then again to fill the array. It's not a heavyweight operation. Many thanks John On 13/07/06, Christian Smith <[EMAIL PROTECTED]> wrote: John Newby uttered: > Hi Martin, I'm not sure, I don't use VB that often, I

Re: [sqlite] How to port the SQLite

2006-07-14 Thread Christian Smith
Vivek R uttered: Hi , I am New bee to the group and SQLite. Can anyone explain me How to port the SQLite to DVD or Consumer products or any other Embedded Systems. Where I can look for it ? What and all things to be considered while porting. Which is the best version to port to consumer product

Re: [sqlite] This great!

2006-07-17 Thread Christian Smith
Cesar David Rodas Maldonado uttered: I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... Not unless each individual file is on a

Re: [sqlite] Order of columns within a CREATE TABLE statement

2006-07-20 Thread Christian Smith
w b uttered: Hi all, Just had a quick question with regards to the order of the columns within a create table statement I have a few tables that use the BLOB type for storing various lengths of binary data and I was wondering if its better (more efficient) to always declare columns of this

RE: [sqlite] SQLiteSpy vs. SQLite.dll speed comparison

2006-07-21 Thread Christian Smith
michael cuthbertson uttered: Brannon: Thank you for your thoughts. To be clear, the 'optimize for speed' setting in MY release is actually slower than MY debug version - I know nothing about Ralf's settings. That issue is separate from SQLiteSpy - I didn't mean to conflate them. And the issue

Re: [sqlite] How to port the SQLite

2006-07-21 Thread Christian Smith
is compatible with VxWorks. If I'm not mistaken, the standard version should be compatible with VxWorks. Your best bet is to compile it up and try it. Please guide me. Thanks and Regards, Vivek R On 7/14/06, Christian Smith <[EMAIL PROTECTED]> wrote: Vivek R uttered: > Hi , >

RE: [sqlite] Temp dir

2006-07-23 Thread Christian Smith
chtaylo3 uttered: Set the global variable sqlite3_temp_directory to any directory you want and it tries that directory first. Ok, fair enough. But why do you try and open the directory? Why can you just try and create the tmp file there and deal with it if it's not allowed? I'm asking

RE: [sqlite] Temp dir

2006-07-24 Thread Christian Smith
chtaylo3 uttered: Christian, Or you could just fix the permissions on your temp directories. If the files in */tmp are sensitive, they should be protected. The file name themselves should not be sensitive. I'm not aware of many installations using the permissions you use for temp

Re: [sqlite] temp_store=1 performance on Mac OS X vs. Windows

2006-07-26 Thread Christian Smith
[EMAIL PROTECTED] uttered: Jens Miltner <[EMAIL PROTECTED]> wrote: OTOH, our customers might also have antivirus software installed, so this still would not be a solution :( Does anybody have advice on how to make sqlite work smoothly with antivirus software [on Windows]? (Probably depends

Re: [sqlite] Please unsubscribe me from sqlite

2006-07-27 Thread Christian Smith
prabhu kumaravelu uttered: Please unsubscribe me from sqlite Try sending an email to this address: [EMAIL PROTECTED] And stop spamming the list. From: "Igor Tandetnik" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: "SQLite" Subject: [sqlite]

Re: [sqlite] insert default values

2006-07-28 Thread Christian Smith
Gerry Snyder uttered: Finally, get it right: sqlite> create table test(f integer primary key autoincrement, v int default 0); sqlite> insert into test (v) values (1); sqlite> insert into test (v) values (2); sqlite> insert into test (v) values (NULL); sqlite> select * from test; 1|1 2|2 3|

Re: [sqlite] Can I use internal variables in SQL scripts?

2006-07-28 Thread Christian Smith
Rob Richardson uttered: In SQL Server, I can write a stored procedure that looks something like this: [snip] Other features available in SQL Server stored procedures include while loops, temporary tables, and the FETCH command to retrieve data from a resultset one row at a time. I have

Re: [sqlite] WHERE with user function

2006-07-28 Thread Christian Smith
Stan uttered: Hi, I need user function for WHERE clause. But I don't know what type of parameters to use for such function: SELECT * FROM Table WHERE MYFUNC(ColumnName, IntValue). Above all - how to returm value to WHERE and what type? Is there any example (tutorial or explanation) in C or

Re: [sqlite] Reading a damaged database file?

2006-07-31 Thread Christian Smith
Olaf Beckman Lapr� uttered: Hi, Is it possible to read the undamaged parts of a damaged .db file? This way I can copy the undamaged parts to another database. Or support to repair the .db file in such a way that it becomes readable again and the undamaged parts can be read. You can try

Re: [sqlite] sum(a+b) vs sum(a) + sum(b)

2006-07-31 Thread Christian Smith
Mikey C uttered: Is there any performance or other gain in writing: select sum(column_a) + sum(column_b) vs select sum(column_a + column_b) The second should be faster, as I'd expect aggregate functions to be more expensive than expression additions. The second would have half the

Re: [sqlite] IO Access Time

2006-08-01 Thread Christian Smith
John Stanton uttered: In general you must expect Sqlite to use more of all resources compared to a flat file. After all Sqlite is a flat file with additional logic. Except updates and selective reads will be cheaper in general, as less IO is required due to additional logic. Storage will

Re: [sqlite] From Windows file format to MacOSX (unsuccessfull, still)

2006-08-04 Thread Christian Smith
Alexander Lamb uttered: Well, sorry, but I did exactly that: 1) When I do the PRAGMA command the file is created (I can see it appearing in the explorer) 2) After the create table, if I do PRAGMA legacy_file_format; I indeed receive "1" as an answer. However, I ".quit" then go back into

Re: [sqlite] About Triggers

2006-08-07 Thread Christian Smith
chetana bhargav uttered: Hi, I have few questions regarding triggers, * If we want to have trigger for some condition and if multiple applications create a trigger for the same condition providing different C callback functions (which I guess is possible through sqlite3_create_function),

Re: [sqlite] C precompiler to bytecode

2006-08-09 Thread Christian Smith
Daniel Önnerby uttered: Hi everyone! I'm just a bit curios if it would be possible to make like a C precompiler or a macro of some kind that compiles/interpret the SQL-statements to bytecode just like the sqlite_prepare does but does this when compiling/precompiling your application instead

Re: [sqlite] Building on SCO Open Server

2006-08-16 Thread Christian Smith
Clay Dowling uttered: Installing gcc is an excellent idea, but I would not be entirely surprised to learn that the actual failure is in sed. SCO and awk/sed do not have a happy history, with incompatible changes having been introduced at times. Nope, I reckon the SCO compiler just doesn't

Re: [sqlite] Re: database locked

2006-08-22 Thread Christian Smith
Laura Longo uttered: On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote: I've tried also executing the query "begine exclusive" before the "update", and "commit" to end the entire routine, and the query that now returns the exit code 5 (database locked) is "begin exclusive", I don't know if

Re: [sqlite] Sqlite 3.3.7 intel compiler warnings

2006-08-31 Thread Christian Smith
Jay Sprenkle uttered: hidden variables might very well not be a problem, if it was done that way on purpose. It should never be done on purpose. It is obfuscation pure and simple. There is never a good reason to do this, other than perhaps hiding a global variable (and even that is not a

Re: [sqlite] Re: met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

2006-09-11 Thread Christian Smith
Sarah uttered: plus, I'm using sqlite-source-3_3_5. I also find a wired phenomenon: When I trace into sqlite3Parser(pEngine, TK_SEMI, pParse->sLastToken, pParse); the next executed statement pointed by debugger does not match with the real one, It seems there are one or two lines space.

Re: Re: [sqlite] met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

2006-09-12 Thread Christian Smith
[EMAIL PROTECTED] uttered: I don't think NULL callback and error pointer will be the reason. Because I've seen this kind of usage in the list for several times. Anyway, I'll try later and report the result to the list. If it is a misaligned-pointer problem, what can I do? You say you are

Re: [sqlite] SQLite3 working with Visual C++.net 2003

2006-09-12 Thread Christian Smith
Abhilash Menon uttered: After a lot of reading and experimenting, I was able to get SQLite3 working with Visual C++.net 2003. Here is what I did ... Built the project and it worked without any issues. If you have a database ready you are ready to test and it works fine Wow! You poor soul!

Re: [sqlite] no TRUNCATE

2006-09-13 Thread Christian Smith
P Kishor uttered: looking at the SQL supported by SQLite, I see no mention of TRUNCATE. Not in the SQL clauses supported, nor in the clauses omitted. Is TRUNCATE a weird beast? I don't think it's standard SQL. At least not SQL92 that SQLite aims to implement. TRUNCATE is an optimised

Re: [sqlite] How to speed up the performance in LIMIT & OFFSET?

2006-09-19 Thread Christian Smith
PY uttered: Hi All, I have a problem about LIMIT & OFFSET profermance. Due to the limitation of memory, I could not get all of the query result at a time. In our soluction, we use the LIMIT and OFFSET to avoid the problem of memory issue. we observed the performance of LIMIT & OFFSET, it looks

Re: [sqlite] Optimistic concurrency control

2006-09-19 Thread Christian Smith
Mikey C uttered: What are peoples thoughts on implementing optimistic concurrency control in SQLite? Not an option. SQLite has a single writer database locking protocol which can't handle multiple writers, so the issue of concurrency control is moot. One way is modify the where

Re: [sqlite] how sqlite works?

2006-09-19 Thread Christian Smith
Cesar David Rodas Maldonado uttered: I meen, If SQLite has two index and very large Index (about 10.000.000 each one) how do i merge it, I mean (index1 = index2 for every one and limit it in thousand). Understand? I guess not. Are you trying to do an INNER JOIN merger on the two indexes?

Re: [sqlite] Optimistic concurrency control

2006-09-19 Thread Christian Smith
Mikey C uttered: Hi, Maybe I didn't make the question clear. I'm not talking about locking and multiple writers. I'm talking about optimistic concurrency control in a disconnected environment. Two processes (say a webserver). One reads some data and presents it to a user (open - read -

Re: [sqlite] SQLite Performance Issues

2006-10-23 Thread Christian Smith
James Mills uttered: Hi Richard, When I mean high-traffic I would imagine more than 1 hit/s. I do want to clear something up though (if you could): If a site using sqlite takes 700ms to load and there are two simultaneous (as simultaneous as one can get) hits to the site, say user A and user

Re: [sqlite] Trouble with ALTER TABLE/ADD

2006-10-25 Thread Christian Smith
Isaac Raway uttered: Thank, I will look at that (away from my dev machine for the day). One other related question, are there plans to expand the functionality of ALTER TABLE? I am working on a feature that could benefit greatly from REMOVE/RENAME COLUMN. As it stands, I am going to have to

Re: [sqlite] any data access and retrieval engine?

2006-10-25 Thread Christian Smith
Sarah uttered: Hi, John Stanton I really really appreciate your warm help. That's great if you can send me the codes of B tree and B+ tree. Many thanks in advance. My requirements for data access are as follows: -all the data are stored in non-volatile memory instead of volatile memory -the

Re: [sqlite] Query Execution speed.

2006-11-03 Thread Christian Smith
Manzoor Ilahi Tamimy uttered: I found that Version 2.8 was much Faster than 3.6 using ":memory:", 30 Seconds and 60 seconds in case of 2.8 and 3.6 respectively. can I use 2.8 in my project when i have a huge amount of data to handle. Version 2 used a Red/Black balanced tree in :memory:,

Re: [sqlite] serious performance problems with indexes

2006-11-03 Thread Christian Smith
Peter De Rijk uttered: --On Friday 27 October 2006 15:31, [EMAIL PROTECTED] wrote: When a table is indexed, INSERT performance is logorithmic in the number of rows in the table and linear in the number of indices. This is because entries have to be inserted into the index in sorted

Re: [sqlite] Q about new SQLite API

2006-11-08 Thread Christian Smith
[EMAIL PROTECTED] uttered: I'm working on a new API routine for SQLite and I have questions for the community. The working name of the new api is sqlite3_prepare_v2(). sqlite3_prepare_v2() works like sqlite3_prepare() in that it generates a prepared statement in an sqlite3_stmt structure. The

Re: [sqlite] indexes in memory

2006-11-09 Thread Christian Smith
chetana bhargav uttered: Hi, I have a question regrading indexes, When I open a connection, Will indexes be loaded into memory. If one of the tables in the DB, the connection for which I have opened, has an index. If, so is there any way to selectively load/unload that from memory.

  1   2   3   4   >