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
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
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
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
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
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
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
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
>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
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@
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
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
>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
>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
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
>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
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
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
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,
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
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
<
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?
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
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
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.
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
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.
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
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
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
>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
>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
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
__
>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
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
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/
>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
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
___
.
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
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
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
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
>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
>> 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
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
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
&
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
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
>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
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
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
>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"
, 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
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
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
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
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
>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
, 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
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
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
<
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
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
>> 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
>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
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
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@
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
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
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
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
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
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
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
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
75 matches
Mail list logo