[sqlite] Trying to use in-memory database

Long time SQLite user but I don't think I have ever tried to do an in-memory database before. Just upgraded to 3.8.3.1 but I am not having any other failures with existing code so I don't think that is any part of the problem. I am trying to open the database with sqlite3_open16() using a filename

[sqlite] How to delete all indexes

to accomplish this without resorting to explicit query of the sqlite_master table? Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819-4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m

Re: [sqlite] How to delete all indexes

On Wed, Mar 16, 2011 at 5:59 PM, Simon Slavin wrote: > You should almost never be creating indexes on the fly.  Bear in mind that if > SQLite finds a search that would be better with an index, it creates it > itself and it is far better at working out the best index than

Re: [sqlite] Lack of "decimal" support

>From: Patrick Earl >Subject: Re: [sqlite] Lack of "decimal" support > >If SQLite can't decide on a base-10 format itself, perhaps the answer >lies in enhancing the API to allow for custom type storage and >operators. >   So, like a virtual type interface.  This would be a

[sqlite] Help with error codes

step() because I have now also noticed sqlite3_extended_errcode()? Is 3338 an extended error code?Do I need to use sqlite3_open_v2 to get the extended error code?  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sq

Re: [sqlite] Help with error codes

appreciate if anyone has any ideas. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help with error codes

ttributesExW() if the error is not ERROR_FILE_NOT_FOUND and this appears to eliminate the crash. Could someone please advise on how good or bad of an idea this change is? How well is SQLite tested on Windows 7 64 bit? Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com &

[sqlite] Building sqlite for windows in a proper way

uilds run most code significantly slower than the release builds. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] What happens if you insert more than your RAM

>> Good day, >> >> What happens if you insert more than your RAM size into an in memory >> database? >> (I'm particularly interested in the Windows context). >> Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615

[sqlite] What happens if you insert more than your RAM

>Tue Apr 19 18:35:27 GMT 2011 Danny dragonslayer2k at yahoo.com > >Depends on access type.  If accessing sequentially, paging would be minimal, >that is, you would process the "segment" that fits into memory, then page >in another "segment" and process that, etc., etc. Even so it would now be

[sqlite] SQLite3 memory leaks in my c++ dll application

tor into reporting false positives in the leaked memory. Your said that your are using GetProcAddress() to make calls which makes me think you *may* be getting to these false positives.  Basically, I believe it comes down to allocating memory in one dll and deallocating in another. Jeff Archer N

[sqlite] Compile Error

e3FinishTrigger referenced in function yy_reduce 1>..\..\Bin\x64\Debug\SqlUtils.dll : fatal error LNK1120: 8 unresolved externals  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-use

Re: [sqlite] Compiler Error

rigger  (pParse, yymsp[-1].minor.yy203, ); Should be enclosed in...   #ifdef SQLITE_OMIT_TRIGGER sqlite3FinishTrigger(pParse, yymsp[-1].minor.yy203, ); #endif  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqli

[sqlite] General questions from a newbe

I'm new to SQLite but have some experience with MS SQL Server.  I am looking for a quick confirmation from expert that my planed use of SQLite is reasonable and maybe point out if there are any gotchas.  I've done some prototyping and tried most of this out but it is based on how I've done

[sqlite] Query help

15, 30  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] A question about transactions

I am using SQLite from C++ and I have implemented a class to manager nested transactions using savepoints.  I have currently implemented as a stack of transactions such that the first Begin uses BEGIN IMMEDIATE, while subsequent levels use SAVEPOINT T where is a sequentially increasing

Re: [sqlite] Question about SQLite features.

ly) for a lot less competent and complete support. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about SQLite features.

e better design and more maintainable over the life of the project.  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about SQLite features.

ness rules but nothing enforces good design on my C++ code either. What it does is allow the business rules to be packaged as a complete unit with the data and I claim that would be better design and more maintainable over the life of the project.  Jeff Archer Nanotronics I

[sqlite] Help with query

of unique Y offsets in a pattern like so: SELECT COUNT(Offset_Y) FROM (SELECT DISTINCT Offset_Y FROM Tiles WHERE PatternID = 1); Is it possible to have a single query that will generate a row for each PattenID, COUNT(Offset_Y) combination? i.e. 1 | 29 2 | 37 3 | 45 Thanks, Jeff Archer Nanotronics

Re: [sqlite] Help with query

tterns.Origin_X, Patterns.Origin_Y, COUNT(DISTINCT Offset_X) AS Width, COUNT(DISTINCT Offset_Y) AS Height, Patterns.Description FROM Tiles INNER JOIN Patterns ON Tiles.PatternID = Patterns.PatternID  GROUP BY Tiles.PatternID; Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330&g

[sqlite] How to make this calculation in VIEW

It works if I substitute a constant for the nTilesX and nTilesY so I think I do not know how to correctly reference these. Thank you. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] How to make this calculation in VIEW

Thank you, Simon and Owen. I have tried and both solutions work equally well.  I have actually used C code to make the calculation as I pull out the data. But to help further my understanding of SQL/SQLite, can anyone comment on potential performance differences of the 2 SQL solutions. CREATE

Re: [sqlite] Just compiled SQLite in Visual Studio

>From: john darnell >Date: Mon, 29 Nov 2010 17:10:04 -0600 > >I just added it to a Visual Studio 8 project, turned off the use of >precompiled >headers (the project is a C++ project) and compiled the SQLite.c >file without >any errors.  Is it really that easy, or am

Re: [sqlite] Troubleshooting...

>> My only guess is that basic_string::c_str() doesn't really provide a pointer >> to >>a null-terminated c-style string, >but a facsimile of one that SQLite doesn't >>like. > >c_str() provides pointer to the data that string has with additional >null byte added at the end. That's it. Whether

Re: [sqlite] SQLite server

Just my two cents... A SQLite Server would be userful.  I have considered creating this myself.  I have thought that it would need to be kept zero config and it should be provided in amalgamation form to keep simple to embed in applications.  Wouldn't need incredible throughput as it is a 

Re: [sqlite] SQLite server

From: Simon Slavin Date: Tue, 21 Dec 2010 14:19:25 + >This was my first thought when I considered implementing an SQLite-over-IP >protocol: that there was no user model and therefore no need for passwords.  >Mounting a >database on the server would mean that anyone who

[sqlite] sqlite3 command line utility

and I have tried it with appending the digits 1 to 6 and making 6 calls to bind with same result. My app is 64 bit and SQLite Expert is 32 bit. Any thought or suggestion will be appreciated as I am not sure how to proceed.  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <

Re: [sqlite] sqlite3 command line utility

tiveID, MicroscopeID, TurretPos, Name, >Description, Magnification, NA, WD) VALUES( 2, (select MicroscopeID from >Store), >1, '10X' , 'CFI LU > >Plan Fluor BD 10X' ,  10.0, 0.30, 15.0); Thank you.  This is very convenient.  And seems so obvious now that I have seen it.  Not sure

[sqlite] Question about having 2 db connections on same thread

, when I do first call to step to execute begin transaction and it never returns.  Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m

Re: [sqlite] Question about having 2 db connections on same

>Date: Sun, 13 Feb 2011 22:14:29 -0500 >From: Pavel Ivanov > >> I do a transaction on connection 1 using BEGIN IMMEDIATE, some rows updated, >> COMMIT. >> Then, when I attempt same sequence on connection 2, when I do first call to >>step >> to execute begin transaction and it

[sqlite] Help with join

Here is my existing schema.  I would like to change this and remove the "NumDefects" from the [Analysis] table. To do this I need to update the [vwAnalysis] view to determine the number of defects from the [Defects] table by the AnalysisID. I can't seem to get the right select for the new

Re: [sqlite] Compiler warnings in R-Tree code under Visual

e". I really agree with this. I compile all production code wth highest warning level possible and make it always compile warning free. Why would you NOT want the compiler to point out potential issues. This lets the developer basically make an approval by inserting a cast or whatever. Jef

Re: [sqlite] Compiler warnings in R-Tree code under Visual Studio Express

gt;get different results with the warnings? > >Marian Cascaval All version of Visual Studio up to and including 2010 have issues with source files longer than 64K lines. The editing works OK but the debugger cannot locate code lines and it confuses Intellisense. Jeff

Re: [sqlite] Help with join

alyzerID] >ORDER BY [Analysis].[Timestamp]; Thank you, Jim. This is very handy technique for me know as I am still a SQL beginner. -- Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list

[sqlite] Query help

, Images.Y + Defects.Y as DefectY from Defects join Images on Defects.ImageID = Images.ImageID I believe that the data is all stored such that the first stored defect for each ImageID will have the lowest X,Y values. At least for now this assumption is probably good enough. Jeff

Re: [sqlite] Query help

>From: Igor Tandetnik [mailto:itandet...@mvps.org] >Sent: Tuesday, March 01, 2011 5:47 PM > >On 3/1/2011 5:01 PM, Jeff Archer wrote: >> And this select which I would like to modify to only return lowest X,Y >> value for each ImageID. > >What does "lowest"

[sqlite] The database disk image is malformed

in the C API that might be used to implement this functionality. Could someone please point me to some information on how I might make my product be able to recover from this situation. SQLite3 version 3.7.13 Windows 7 x64 Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>81

[sqlite] ranking in a view

There was recently a post where someone was trying to update the ranking of records in a table and someone else presented a clever view which did the ranking and thus required no table update. I wanted to try and understand how this view worked but when I have looked back to find it, I can't.

[sqlite] SQLite4 questions

Will SQLite4 be capable of reading a SQLite3 database to facilitate upgrade? (I'm guessing 'no') I assume SQLite4 will be distributed in a familiar amalgamation format. Will it be feasible to include the amalgamation of both SQLite3 and SQLite4 into the same application to create an upgrade

[sqlite] Journal mode

Documentation doesn't make this clear. Does PRAGMA journal_mode = OFF; affect a single connection or will it affect all connections in my process? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Question about behavior when journal_mode = off

If all connections (1 per thread) of all processes (multiple simultaneous) issue command "PRAGMA journal_mode = off", is access to a common database file located on the local machine still synchronized correctly between the random accesses (reads and writes) occurring across all?

[sqlite] Performance with journal_mode = off

transactions (default atomic commit) it takes 17.7 seconds. When I set journal_mode = off, same operation takes 5.5 seconds. If I do all 5764 inserts within a single transaction only 2.5 seconds. Jeff Archer Vice President of Software Engineering Nanotronics Imaging jsarc...@nanotronicsimaging.com <

Re: [sqlite] Performance with journal_mode = off

On Wed, Mar 27, 2013 at 5:46 PM, David King wrote: > > > I am populating a database with 5764 records using the exact same data set > > each time into a newly created file. > > When I use no explicit transactions (default atomic commit) it takes 17.7 > > seconds. > > When I

Re: [sqlite] Performance with journal_mode = off

On Wed, Mar 27, 2013 at 6:35 PM, Simon Slavin wrote: > > Reasonable figures. With 5764 writes to the disk in separates transactions > you have quite a lot of reading of data plus 5764 attempts to update the > database file. The updates have to be done in the right order,

Re: [sqlite] Performance with journal_mode = off

On Thu, Mar 28, 2013 at 8:35 AM, Niall O'Reilly <niall.orei...@ucd.ie> wrote: > > On 28 Mar 2013, at 12:09, Jeff Archer wrote: > >> But my most basic question remains. Why is single transaction faster >> than PRAGMA journal_mode = off? >> >> Seems to me

Re: [sqlite] Performance with journal_mode = off

On Thu, Mar 28, 2013 at 8:24 AM, ibrahim <ibrahim.a...@googlemail.com> wrote: > On 28.03.2013 13:09, Jeff Archer wrote: >> >> On Wed, Mar 27, 2013 at 6:35 PM, Simon Slavin <slav...@bigfraud.org> >> wrote: >>> >>> Reasonable figures. With 5764 w

Re: [sqlite] Performance with journal_mode = off

>From: "James K. Lowden" >To: sqlite-users@sqlite.org > > Your experiment is telling you different: transaction control costs more than I/O. But shouldn't transactions be disabled when journal_mode = off? Maybe that is a faulty assumption. If so, what is the point of

[sqlite] How to achieve fastest possible write performance for a strange and limited case

I have previously made an apparently bad assumption about this so now I would like to go back to the beginning of the problem and ask the most basic question first without any preconceived ideas. This use case is from an image processing application. I have a large amount of intermediate data

Re: [sqlite] Performance with journal_mode = off

>Date: Thu, 28 Mar 2013 14:13:51 +0100 >From: ibrahim > >... You should compare > >a) Journal mode=on w/wo single transaction >b) Journal mode=off w/wo single transaction So, this means I can use transaction when I have journal_mode = off? I did not understand that

Re: [sqlite] Performance with journal_mode = off

>On Fri, Mar 29, 2013 at 4:05 PM, Simon Slavin wrote: > >No. The two things have nothing to do with one-another. Transactions are >about grouping changes together >so that either they all happen or none happen. Journalling is about surviving >through crashes and

Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

On Fri, Mar 29, 2013 at 4:46 PM, Richard Hipp wrote: > On Fri, Mar 29, 2013 at 4:41 PM, Michael Black wrote: > >> I think many people would tell you not to store your images in your >> database. >> Just store a filepath to them. >> That will speed things up

Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

Thanks for everyone's help and thoughts on this issue. My findings on Windows 7 Pro 64 using a PCI based SSD is that for my smallish image the BLOBs were faster than individual files. Basically, in line with a table that someone posted earlier in this thread. After many experiments, with many

Re: [sqlite] Support SQLite in México

tten far less. I have been using SQLite3 in my product since 2009. Highly recommended. Jeff Archer Vice President of Software Engineering Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] Path Length Limit on Windows

>Date: Wed, 28 Aug 2013 14:21:24 -0400 >From: Richard Hipp > >The latest check-in on trunk adds a new windows VFS module called >"win32-longpath" which accepts the full-length 32KB pathnames. Add the >string "win32-longpath" as the 4th argument to sqlite3_open_v2() (on >windows

[sqlite] Something strange

. Windows 7 64bit. Visual Studio 2010. Real HDD not SSD. The file is on local machine but is opened using a network path. i.e. \\MACHINENAME\Data\Calibration.db Thank you in advance for your time on this matter. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com

[sqlite] Not sure how to interrupt this

0: [INSERT INTO [Scans](ScanID, Timestamp, EndTime, Result) VALUES(NULL, @Timestamp, @Timestamp, @Result);] database schema has changed SQLITE_VERSION"3.7.13" - amalgamation Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com ___

[sqlite] Not sure how to interrupt this

>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >My guess is that a) you have prepared your statement with sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... Statement was prepared with sqlite3_prepare16_v2() Database file was created only moments earlier. Jeff

[sqlite] Not sure how to interrupt this

a wrapper function, Execute(), that does the Prepare, Bind, Step, Reset, Finalize sequence. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/

[sqlite] Not sure how to interrupt this

rror message through the SQLITE_CONFIG_LOG callback is inconsistent with the success indicated by SQLITE_DONE. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

[sqlite] Not sure how to interrupt this

>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >My guess is that a) you have prepared your statement with sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... Statement was prepared with sqlite3_prepare16_v2() Database file was created only moments earlier. Jeff

[sqlite] Error indicated through SQLITE_CONFIG_LOG callback but sqlite3_step() does not fail

was created only moments before. My biggest question is: Why after this error being indicate through the SQLITE_CONFIG_LOG callback would the sqlite3_step() succeeded? Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 __

[sqlite] Error indicated through SQLITE_CONFIG_LOG callback but sqlite3_step() does not fail

>Pavel Ivanov paivanof at gmail.com Fri Jun 29 17:06:42 EDT 2012 > >Because SQLite successfully re-prepared this statement behind the >scenes and thus was able to successfully finish sqlite3_step() >function. What could cause it to "re-prepare" the statement? Is this something I need to find and

[sqlite] Error indicated through SQLITE_CONFIG_LOG callback but sqlite3_step() does not fail

>Simon Slavin slavins at bigfraud.org Fri Jun 29 17:16:36 EDT 2012 > >Do you do the _prepare() first, then make a change to the database schema ? For instance > >Start of app >Prepare the INSERT statement >CREATE TABLE >Bind the INSERT statement >Step the INSERT statement No. Create Table Then

[sqlite] SQLITE_CONFIG_LOG callback indicating SQLITE_SCHEMA (17) error

as it was created by the first process and I was assuming that the "IF NOT EXISTS" would be preventing it from actually doing anything but now I am believing that executing this statement even when the table exists is causing SQLite to think the schema has changed. Does this seem plausi

[sqlite] Is it possible to get the amalgation as individual files

I assume that the amalgation exists as single files before it is combined into one file. Is is possible to get these individual files so that I can build a debug version because Visual Studio debugger does not handle well the 138244 line amalgation file? Jeff Archer Nanotronics Imaging jsarc

Re: [sqlite] Is it possible to get the amalgation as individual files

build from the canonical sources." trips me up. I was hoping there is a way to get the individual files after they have been formulated by the unix-like development tools but before they are combined into the amalgamation file. Jeff Archer Nanotronics Imaging jsarc...@nanotro

Re: [sqlite] Is it possible to get the amalgation as individual files

On Fri, Sep 21, 2012 at 4:01 PM, Nico Williams wrote: > >Install Cygwin, use that to make the amalgamation (after you've made > >whatever changes to the canonical sources), then build the amalgation > >in native Windows. Please excuse my ignorance. OK. I have Cygwin.

Re: [sqlite] Problem with savepoints

On Wed, Jul 6, 2016 at 10:46 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 07/06/2016 09:09 PM, Jeff Archer wrote: > >> Hi All, >> I am a long time SQLite user but have generally used it from C++ in the >> past. In this project however, I am attempting to

[sqlite] Problem with savepoints

Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided by Android 4.2.2 (3.7.11). Basically, what I have is SQLite compiled

[sqlite] Crash on Android

Hi All, Any thoughts on this will be greatly appreciated. I am having an issue only on a specific tablet when it is running Android 4.2.2. When Android is upgraded to 4.4.2 problems appears to be gone. I still want to understand root cause to know if problem is really gone. My environment is a

[sqlite] Order of fields for insert

Just a quick question. I am actually deciding if I need to do some performance testing of this but thought I might gain some quick insight. My specific insert and table are below but really I am looking for a general answer to the question not just this specific case. Are there any performance

Re: [sqlite] Order of fields for insert

Sorry, that was just mistake in reducing the code for the email, please ignore. What do you mean "what matters is order of columns in table"? or was that just referring to the typo? Jeff Archer jeffarch...@gmail.com <jarch...@yahoo.com> On Thu, Oct 6, 2016 at 9:52 AM, Cleme

[sqlite] How to get these ordered correctly

Hi and thanks in advance for your help. I have a table of words and counts and I am trying to make a query which sorts in descending order of count but with each group of words that have the same count sorted alphabetically. MY table: CREATE TABLE words (id INTEGER PRIMARY KEY AUTOINCREMENT ,cnt

[sqlite] Problem building amalgamation

SQLite 3.13.0 I have just grabbed the sqlite3.c and sqlite3.h from another (working) project and dropped then into a new project and I am seeing compile errors. New project is a C++ project in Eclipse. using GCC 5.4.0 from cygwin64. Just trying to make a simple command line app. I'm sure I'm