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] 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] SQLite on flash (was: [PATCH 00/16] f2fs: introduce flash-friendly file system)

2012-10-12 Thread Christian Smith
On Wed, Oct 10, 2012 at 08:47:02AM -0400, Richard Hipp wrote: > [snip] > > We would also love to have guidance on alternative techniques for obtaining > memory shared across multiple processes that does not involve mmap() of > temporary files. shmget/shmat - Part of the SysV IPC primitives and

Re: [sqlite] Windows I/O (was: Initial read speed greater than subsequent)

2012-08-01 Thread Christian Smith
On Sat, Jul 14, 2012 at 03:17:07PM +0100, Simon Slavin wrote: > > On 14 Jul 2012, at 3:12pm, Udi Karni wrote: > > > I know > > nothing about writing DB engines - so I don't know whether adding a 2nd > > parallel process adds 10K or 10M to the code base. > > You've reached the

Re: [sqlite] Queries on SQLite

2012-06-15 Thread Christian Smith
On Thu, Jun 14, 2012 at 06:27:17AM -0400, Richard Hipp wrote: > On Thu, Jun 14, 2012 at 2:41 AM, vallur raghava reddy < > vallur.raghavare...@gmail.com> wrote: > > > > 2. Does SQLite create a any threads? If YES, how many will be created? > > > > SQLite does not create threads. > Except

Re: [sqlite] Triggers in Sqlite using C

2012-06-15 Thread Christian Smith
On Fri, Jun 15, 2012 at 11:59:33AM +0530, Bageesh.M.Bose wrote: > Can anyone tell "How to use Triggers in Sqlite using C" > Triggers in SQLite can only contain SQL DML statements. But, you can interface with C by defining functions, then calling those functions using SQL SELECT command. For

Re: [sqlite] integrity constraint that is equivalent to the following trigger:

2012-06-13 Thread Christian Smith
On Sun, Jun 10, 2012 at 02:35:20PM +0200, Wolfgang Meiners wrote: > Hello, > > i have written a sqlite3-db for a small books library. Within this db > there is a table: > sqlite> .schema ausleihen > CREATE TABLE ausleihen ( > aid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > pid

Re: [sqlite] sqlite Commit C API

2012-05-18 Thread Christian Smith
On Thu, May 17, 2012 at 04:47:29PM +0100, Simon Slavin wrote: > > On 17 May 2012, at 4:34pm, Rajesh Kumar wrote: > > > No am not using any PRAGMAs. I just cross compiled sqlite source to > > ARM architecture. Can't I forcefully do commit on my transaction > > If you

Re: [sqlite] INSERT OR REPLACE

2012-03-12 Thread Christian Smith
On Fri, Mar 09, 2012 at 09:49:22AM +1100, BareFeetWare wrote: > I suggest only using "insert or replace" if you genuinely want to delete and > replace with a new row. This is generally not hat you want if there are any > foreign keys. > > Only use "insert or ignore" if you are inserting exactly

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] 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 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 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] 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] Potential problem with ON CONFLICT REPLACE?

2011-03-02 Thread Christian Smith
Inline... On Mon, Feb 28, 2011 at 04:37:13PM -0700, Carl Baldwin wrote: > Hello, > > I've used sqlite for a number of years now. I ran in to something over the > week-end like nothing I've experienced before. An application linked > against 3.6.18 corrupted one of my databases. The

Re: [sqlite] Bus error on sqlite3_close on Sun Sparc w/SQLite 3.7.4

2011-01-31 Thread Christian Smith
On Wed, Jan 26, 2011 at 02:31:05PM -0500, Joe Mokos wrote: > I've written an application that uses SQLite 3.7.4. The application runs > fine on WinXP, AIX, HPUX and Linux. When I try to run on Solaris 5.8 SPARC > I get a bus error when I call sqlite3_close. I get the following stack > trace: >

Re: [sqlite] assert crash in wal

2010-12-16 Thread Christian Smith
On Thu, Dec 16, 2010 at 09:41:27AM +0200, Yoni Londner wrote: > > > The underlying error here is that you are attempting to use threads in the > > first place. You should never do that. Threads are evil and should be > > avoided wherever possible. Use separate processes for concurrency.

Re: [sqlite] WAL index in memory - multiple connections

2010-12-15 Thread Christian Smith
On Mon, Dec 13, 2010 at 12:29:20PM +0200, Yoni Londner wrote: > Hi, > > In general I think that SQLite should have a in memory VFS, which is OS > independent. A laudable goal, where mmap is not available. > > I am going to implement proc_exclusive now, and would love to get any >

Re: [sqlite] Lemon behavior

2010-12-15 Thread Christian Smith
On Tue, Dec 07, 2010 at 08:09:53PM +0100, Begelman, Jamie wrote: > I'm using Lemon for a non-sqlite related project and it is exiting with an > assertion failure that I would like to understand. I have extracted the > following small set of productions from a larger grammar. The "list" >

Re: [sqlite] WAL index in memory - multiple connections

2010-12-10 Thread Christian Smith
On Fri, Dec 10, 2010 at 09:49:46AM -0500, Pavel Ivanov wrote: > > Given that the WAL index is mmap'ed, you're unlikely to see improvement > > in performance by storing it in heap memory. Reads/writes will go at > > main memory speeds once mapped into your address space, and under memory > >

Re: [sqlite] WAL index in memory - multiple connections

2010-12-10 Thread Christian Smith
On Thu, Dec 09, 2010 at 12:17:34PM +0200, Yoni Londner wrote: > > > The alternative is to create your own VFS that stores the WAL index in > > heap memory. > I guess I have to do it, but I think this should be available in sqlite, > since it is a common case to use sqlite from single process

Re: [sqlite] Oracle joins the SQLite Consortium

2010-06-21 Thread Christian Smith
On Mon, Jun 21, 2010 at 04:47:12AM -0700, Igor Sereda wrote: > > Wow, that's interesting news. Berkeley DB is still GPL/commercial, I guess? I > hope SQLite will keep on going under public domain, including its B-tree > level. > > Also, here's an interesting statement in the BDB/SQLite

Re: [sqlite] very large SQLite tables

2009-07-18 Thread Christian Smith
On Wed, Jun 24, 2009 at 02:21:09PM -0500, Matthew O'Keefe wrote: > > > We are using SQLite for indexing a huge number (i.e., 100 million to 1 > billion) of key pairs > that are represented by an 88-byte key. We are using a single table with a > very large number of rows (one for each data

Re: [sqlite] Slow Transaction Speed?

2009-06-08 Thread Christian Smith
On Wed, May 27, 2009 at 08:05:00AM -0400, pyt...@bdurham.com wrote: > Dr. Hipp, > > > Your OS and filesystem configuration have a big impact too. I've notice, > > for example, that transactions are really slow on RieserFS on Linux > > compared to Ext3. > > In your experience, which Linux file

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Christian Smith
On Fri, May 08, 2009 at 05:32:45PM +0700, Dan wrote: > > On May 8, 2009, at 5:21 PM, Christian Smith wrote: > > > On Wed, May 06, 2009 at 10:36:50PM -0400, D. Richard Hipp wrote: > >> > >> A new optional extension is included that implements an > >>

Re: [sqlite] SQLite version 3.6.14

2009-05-08 Thread Christian Smith
On Wed, May 06, 2009 at 10:36:50PM -0400, D. Richard Hipp wrote: > > A new optional extension is included that implements an asynchronous I/ > O backend for SQLite on either windows or unix. The asynchronous I/O > backend processes all writes using a background thread. This gives > the

Re: [sqlite] Storage of blobs: to encode or not to encode?

2009-04-14 Thread Christian Smith
On Mon, Apr 13, 2009 at 11:14:17AM -0700, Julian Bui wrote: > Hi all, > > I have a question about encoding blob bytes before inserting a record into > SQLite. > > CONTEXT: > I have a base java (I'm using JDBC) class that has a many children. Each > child may store a different data type (such as

Re: [sqlite] SQLite JDBC driver performance

2009-01-27 Thread Christian Smith
On Wed, Jan 21, 2009 at 03:48:50PM -0800, Jim Dodgen wrote: > are you running the pure version of the sqlite driver? >From the profile output below, I'd say the pure Java version was being used. My guess is that the Java version is slower due to the fact that the Java version is based on

Re: [sqlite] Compressed dump SQLite3 database

2009-01-19 Thread Christian Smith
On Mon, Jan 19, 2009 at 06:22:33PM +0100, vlema...@ausy.org wrote: > Hello, > > We need to produce copies of our databases for archive. > It is a requirement that the size of those copies being as small as > possible, without having to perform an external compression. > vacuum doesn't seem to

Re: [sqlite] Database file size

2008-12-03 Thread Christian Smith
On Thu, Nov 27, 2008 at 08:12:02AM +, Simon Bulman wrote: > Morning, > > Table 1 > > BIGINT (index), VARCHAR(30), VARCHAR(10) > > > > Table 2 > > BIGINT (index), FLOAT For the second table, the index will contain the BIGINT value and the table rowid, which is almost as big as the

Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-24 Thread Christian Smith
On Fri, May 23, 2008 at 12:55:47PM -0600, Peter K. Stys wrote: > On Fri, May 23, 2008 at 4:31 AM, Christian Smith < > [EMAIL PROTECTED]> wrote: > > > On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote: > > > Hi Folks: > > > I'm new to this list

Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-23 Thread Christian Smith
On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote: > Hi Folks: > I'm new to this list and just came across a major issue so I thought I'd > post here: I'm using SQLite (from REALbasic which uses the SQLite DB engine > for SQL support) to store image files, and while R/W to local files

Re: [sqlite] Major memory leak

2008-03-23 Thread Christian Smith
On Fri, Mar 21, 2008 at 10:41:10AM -0400, Rob Richardson wrote: > My SQLite library is built from the single translation unit > sqlite.c/sqlite.h. That file contains the version number 3.3.17. > > I do not have valgrind, but circumstantial evidence that this is a > SQLite problem is strong.

Re: [sqlite] Where is the database file created?

2008-03-22 Thread Christian Smith
On Sat, Mar 22, 2008 at 06:44:45PM +0900, Fred Janon wrote: > Hi, > > I read the documentation, features and faq and could not find anything that > specifies where (which directory) the database file is stored. I launched > sqlite3.exe on windows without a database name, using the '.databases' >

Re: [sqlite] Performance

2008-03-06 Thread Christian Smith
On Wed, Mar 05, 2008 at 09:02:17PM -0500, James Kimble wrote: > > > One thing I can highly recommend on embedded systems, especially flash > > based ones, is turn pragma synchronous to off. Having sqlite write every > > record modification to the flash, is a stunningly expensive process, > > even

Re: [sqlite] Performance.....

2008-03-05 Thread Christian Smith
On Wed, Mar 05, 2008 at 10:21:58AM -0500, [EMAIL PROTECTED] wrote: > > > I'm in the process of architecting the software for an embedded Linux system > that functions as a remote and local user interface to a control system. > There > will be a lot of analog (fast) data arriving via SPI bus and

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] 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] 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] 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] 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] [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-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-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] 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] 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-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] 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] 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-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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] Strange performance behavior

2007-03-19 Thread Christian Smith
Hubertus uttered: Dear list, sorry to just come up with another performance question. I build a yet small database with one table. It has about 650.000 rows, 75 columns and has at the moment about 650 Mb. It runs on a Intel Pentium M with 2 GHz. The Laptop runs Suse 10.2 and does basicly

Re: [sqlite] Question about speed of CASE WHEN

2007-03-18 Thread Christian Smith
RB Smissaert uttered: Looking at the fastest way to convert a field in a table and wonder if in general an update with a CASE WHEN construction or an update with a join to a lookup table is faster. My guess is that the CASE WHEN form will be faster for small number of possibilities. It

Re: [sqlite] SQLite db lock problem

2007-02-20 Thread Christian Smith
Allan, Mark uttered: Hi, A little while back I submitted a query as to whether SQLite would be a good alternative to using MS Access as an internal database for a PC application. I received many repiles for which I was grateful. Mostly people thought that SQLite was a far more superior

Re: [sqlite] Backing up a SQlite database

2007-02-09 Thread Christian Smith
Rich Shepard uttered: On Fri, 9 Feb 2007, Mikey C wrote: This might be a dumb question, but is taking a backup of a live database simply a matter of copying the file to a backup device/drive? Yes. It's a regular file to your OS. As a matter of fact, you can copy the file to another name

Re: [sqlite] Shared Lock Transactions

2007-01-23 Thread Christian Smith
Jay Sprenkle uttered: On 1/21/07, Andrew Teirney <[EMAIL PROTECTED]> wrote: > > > What is a 'shared' lock? You can't share a lock, only one process > > can own it at a time. > > > > As per this document > > http://www.sqlite.org/lockingv3.html > > SHARED The database may be read but not

RE: [sqlite] Is there a way to turn off -journal files?

2007-01-16 Thread Christian Smith
Dave Gierok uttered: Yes, that's exactly what we do: use the in-memory db until it comes time to save, and then we open a file db, attach, and copy it to disk. At that time, the journal files are created. If there is a nice way to serialize an in-memory db to disk without having to

Re: [sqlite] Pager modification question

2007-01-12 Thread Christian Smith
Ken uttered: Would it be possible to implement a Page level locking system using sqlite? Deadlock detection/recovery and/or prevention is much more complex for page level locking. As there is no shared data between SQLite clients other than the database file itself, tracking locks in other

Re: [sqlite] delayed (batch) transactions

2006-12-24 Thread Christian Smith
[EMAIL PROTECTED] uttered: It takes at least two complete rotations of the disk platter to do an atomic and durable commit. On a 7200 RPM disk, that means 60 transactions per second is your speed of light. Your question boils down to this: Can you speed up transactions by dropping the

Re: [sqlite] SQLiteJDBC is now 100% Pure Java

2006-12-14 Thread Christian Smith
David Crawshaw uttered: For several months now I have been providing a Java JDBC driver for SQLite 3. Now I am happy to announce with v030, the completion of a 100% Pure Java version. http://www.zentus.com/sqlitejdbc This is accomplished with the support of the great NestedVM project. The

Re: [sqlite] building sqlite on windows in Unicode

2006-12-14 Thread Christian Smith
Check the requirements in: http://www.sqlite.org/copyright.html for patches and other submissions to SQLite. This could be what is holding up inclusion of the patch. Christian Brodie Thiesfield uttered: Hi, Building sqlite on windows in Unicode mode broke with the addition of the loadable

Re: [sqlite] Re: creating own pragmas

2006-12-07 Thread Christian Smith
Dennis Cote uttered: Igor Tandetnik schrieb: G�nter Greschenz <[EMAIL PROTECTED]> wrote: i'm using "sqlite3_create_function()" to create own functions in my database. this is a really nice possibility to extend the database with powerful functions. but i did not find a way to create own

Re: [sqlite] a question about muticonnection

2006-12-07 Thread Christian Smith
Mario Frasca uttered: Christian Smith wrote: You can use the rowid to track the row version, and a unique constraint on your key to track conflicts. When updating a record, read the row, including the rowid. Update any columns. When writing the row out, delete the existing rowid

Re: [sqlite] a question about muticonnection

2006-12-07 Thread Christian Smith
hongdong uttered: I just have a base question: assume user A and user B now both connection to a same database and both of them want to update a same record,but only one is allowed in this condition: A begin to browse the data in a client application,and load rowid into GUI and keep it in

Re: [sqlite] database permanently locked

2006-12-02 Thread Christian Smith
Max Barry uttered: My database is permanently locked, and I've spent two fruitless days trying to unlock it. You haven't said what sort of box this is. I guess a generic Unix. If Linux, you'll probably have fuser installed. Run fuser against the database file, and it'll tell you the PID

RE: [sqlite] C++ SQLite

2006-11-29 Thread Christian Smith
RB Smissaert uttered: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. Why not just use ODBC? http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc http://www.ch-werner.de/sqliteodbc/ That way, you're not even tied to SQLite. RBS

Re: [sqlite] Saving tables

2006-11-29 Thread Christian Smith
John Stanton uttered: If you use an extension greater than 3 chars you violate rules for some existing file systems and reduce portability. You can also make it difficult to parse the extension when it is used to type the file. An extension of arbitray length should be just as easy to

Re: [sqlite] Sqlite books

2006-11-16 Thread Christian Smith
:38 AM, Christian Smith wrote: John Gunnarsson uttered: Hi, I'm about to buy a book about Sqlite. I'm coding in C++ so I'm looking for the best book to suite my needs. In my local bookstore I have: The Definitive Guide to SQLite, APress http://www.apress.com/book/bookDisplay.html?bID=10130

RE: [sqlite] SQLITE readonly Performance on a CD DB

2006-11-16 Thread Christian Smith
Vis Naicker uttered: [EMAIL PROTECTED] uttered: the blob database... within 1.5sec or less from the CD. ... LED on the CD rom blinking only occasionally, not constantly like when I copy a file. [If the LED only lights when data is being transferred, then what you're seeing is the

Re: [sqlite] Sqlite books

2006-11-15 Thread Christian Smith
John Gunnarsson uttered: Hi, I'm about to buy a book about Sqlite. I'm coding in C++ so I'm looking for the best book to suite my needs. In my local bookstore I have: The Definitive Guide to SQLite, APress http://www.apress.com/book/bookDisplay.html?bID=10130 and SQLite, Sams

Re: [sqlite] SQLITE readonly Performance on a CD DB

2006-11-15 Thread Christian Smith
[EMAIL PROTECTED] uttered: I have 300K records in my database and the blob text file (invoices) in a separate database. I query the database over a network or USB stick and the performance is good. However when I moved my database to CD media, the performance dropped drastically. It takes 2

Re: [sqlite] SQL tree and deepness level

2006-11-14 Thread Christian Smith
Robert Zajda uttered: Hello I have a table CREATE TABLE acategories { id integer not null primary key category string parent_category integer references acategories.id ) query: SELECT a.id AS 'id', a.category AS 'Category', b.category AS 'Parent category' FROM acategories AS a

Re: [sqlite] so many warnings on vc6 with warning level 4

2006-11-13 Thread Christian Smith
Gunnar Roth uttered: Hello, i want to use sqlite3 in a sub-project at work. when compiling with warning level 4 with vc6 ( internal philosophy ) , i get over 480 warnings. With warning level 3 there are still 119 left. This leads to problems to convince the project lead of the quality of

RE: [sqlite] Insert statement taking too long

2006-11-09 Thread Christian Smith
Unit 5 uttered: --- Robert Simpson <[EMAIL PROTECTED]> wrote: You need to create an index on the columns you're joining. Otherwise I believe 100,000,000 rows (10k x 10k) in table 2 will be scanned while SQLite looks for matches against the 10,000 rows in table 1. While that makes sense, I

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.

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] 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] 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] 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] 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] 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] 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] 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: 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 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] 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] 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: 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] 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: [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

  1   2   3   4   >