I've just added some extra diagnostics to the debug build of the native
interop assembly (SQLite.Interop.dll), could you update your local
sources, compile everything in the debug build configuration, and then
try to reproduce the problem?
--
Joe Mistachkin
Hello,
The context:
- Web application
- Billing application
- Sqlite with WAL mode
- The database is shared among many clients.
Images are handled in the app: photo of products, photos of customers, etc.
Each client can have thousands.
Advise you manage images as blob in the database? or have
Joe,
Have done as you said and reproduced the issue. Have sent you direct the
relevant pdbs and kdmp from the latest crash.
From: sql...@mistachkin.com
To: sqlite-users@sqlite.org
Date: Mon, 8 Oct 2012 02:24:08 -0700
Subject: Re: [sqlite] Seemingly random Access Violation errors
Paxdo Presse wrote:
The context:
- Web application
- Billing application
- Sqlite with WAL mode
- The database is shared among many clients.
Images are handled in the app: photo of products, photos of customers, etc.
Each client can have thousands.
Advise you manage images as blob in the
Thank you Clemens!
Indeed, I thought as a second database for images. This may be a good solution.
But there are two flaws:
- With WAL mode, transactions involving multiple databases are no longer
atomic, whole.
- The transaction will take more time (the database will be occupied longer)
Matthew Dumbleton wrote:
Have attached the latest .kdmp and pdbs since you last email/source
changes. Hopefully the dump makes more sense to you than it does to
me. Builds were debug builds as requested.
There were no attachments to your message that I saw. Also, were you
able to
Paxdo Presse wrote:
Indeed, I thought as a second database for images. This may be a good
solution. But there are two flaws:
- With WAL mode, transactions involving multiple databases are no longer
atomic, whole.
But files are not atomic at all. Do you actually need this for images?
-
On 8 Oct 2012, at 11:25am, Paxdo Presse pa...@mac.com wrote:
Hello,
The context:
- Web application
- Billing application
- Sqlite with WAL mode
- The database is shared among many clients.
Images are handled in the app: photo of products, photos of customers, etc.
Each client can
Sorry about that. Sent you the attachments properly a while ago and have also
just sent you a .txt file with the last output from the debugger before the
access violation crash thanks to your new version.
From: sql...@mistachkin.com
To: sqlite-users@sqlite.org
Date: Mon, 8 Oct 2012
Matthew Dumbleton wrote:
Sorry about that. Sent you the attachments properly a while ago and have
also just sent you a .txt file with the last output from the debugger
before the access violation crash thanks to your new version.
The start of the trouble seems to be here:
Data Abort:
Hello,
I have a feature request.
In SQLite when strings are concatenated (with ||) and one of them is null,
the result will be null.
This is not a required behaviour (not intuitive) and most users tend to add
*ifnull(X, '')* to get proper results.
This slows down the whole operation, when we
Marcel Wesołowski wrote:
In SQLite when strings are concatenated (with ||) and one of them is null,
the result will be null.
This is not a required behaviour
It *is* required by all SQL standards.
(not intuitive)
It's intuitive for everybody with experience with SQL.
That is how _all_
When trying to port my application from Code::Blocks(windows version) to
Visual Studio 10, I am getting some error, similar to the one below:
1my_sqlite3.obj : error LNK2019: unresolved external symbol
_sqlite3_prepare_v2 referenced in function public: bool __thiscall
mySQLite3::notExist(class
On Mon, Oct 08, 2012 at 03:44:01PM +0200, Clemens Ladisch scratched on the wall:
Marcel Weso?owski wrote:
Why there's no such functionality in SQLite?
Because it's not called SQLFat.
More to the point, it would be pretty trivial to write your own
extension that includes a concat()
Arbol One wrote:
error LNK2019: unresolved external symbol _sqlite3_prepare_v2
It appears you forgot to include sqlite3.c in your application.
Regards,
Clemens
This e-mail is for the sole use of the intended recipient and may contain
confidential or privileged information. Unauthorized use
On 7 Oct 2012, at 10:32am, Marcel Wesołowski malloth.marce...@gmail.com wrote:
In SQLite when strings are concatenated (with ||) and one of them is null,
the result will be null.
This is not a required behaviour (not intuitive)
Actually, it is required behaviour, and I find it intuitive
So does this mean therefore SQLite will not currently work on a compact
framework device? (Or at least not on mine.)
There's nothing else installed or running apart from the test app I sent you
using SQLite and the OS itself. That dll is protected inside the windows
directory on the
Matthew Dumbleton wrote:
So does this mean therefore SQLite will not currently work on a
compact framework device? (Or at least not on mine.)
It's worked on every device that I've used in the past.
That dll is protected inside the windows directory on the device so I
cannot even try
On 8 Oct 2012, at 3:54pm, Matthew Dumbleton msd...@hotmail.com wrote:
So does this mean therefore SQLite will not currently work on a compact
framework device? (Or at least not on mine.)
SQLite is distributed as C source code. It's the .c and .h files you find when
you download the
On Mon, Oct 8, 2012 at 10:54 AM, Matthew Dumbleton msd...@hotmail.comwrote:
So does this mean therefore SQLite will not currently work on a compact
framework device? (Or at least not on mine.)
There's nothing else installed or running apart from the test app I sent
you using SQLite and the OS
Joe,
It's worked on every device that I've used in the past.
I hope you see the funny side when I say, this doesn't fill me with a great
amount of confidence as according to your previous messages you don't have a
device to test on, only emulators. :)
I have no idea what the
Yes. Motorola ES400. Do have any advice/experience with these? (Apart from
'don't use them' :) )
From: kevin.m.ben...@gmail.com
Date: Mon, 8 Oct 2012 11:55:57 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Seemingly random Access violation errors (resent)
On Mon, Oct 8, 2012
Simon,
Apologies if it seems like I'm picking on SQLite. As previously stated I am
just disappointed that I don't seem to be able to use it in a simple c# app.
I'm sure it works great on other platforms/devices etc. just wanted to get in
on the act. No insult to c, c++ developers and/or
Images are handled in the app: photo of products, photos of customers, etc.
Each client can have thousands.
Advise you manage images as blob in the database? or have only the URL of
images in the database (so the image files on the hard disk)?
The first solution seems simpler, more
Can you check the difference in stack size between the emulator and the real
device?
The emulator could well have a larger default stack size and you're getting
stack overflow on the real device.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions
On Mon, Oct 8, 2012 at 11:57 AM, Matthew Dumbleton msd...@hotmail.comwrote:
Joe,
It's worked on every device that I've used in the past.
I hope you see the funny side when I say, this doesn't fill me with a
great amount of confidence as according to your previous messages you don't
have a
Thanks Kevin.
I will see if I can find some sort of registry hack or something to disable
this and see if it makes any difference.
From: kevin.m.ben...@gmail.com
Date: Mon, 8 Oct 2012 12:14:58 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Seemingly random Access violation errors
On Mon, Oct 8, 2012 at 12:32 PM, Matthew Dumbleton msd...@hotmail.comwrote:
Thanks Kevin.
I will see if I can find some sort of registry hack or something to
disable this and see if it makes any difference.
Actually, you might investigate how to access the RTLog Manager to examine
the
Good point. Also worth a look.
From: kevin.m.ben...@gmail.com
Date: Mon, 8 Oct 2012 12:42:09 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Seemingly random Access violation errors (resent)
On Mon, Oct 8, 2012 at 12:32 PM, Matthew Dumbleton msd...@hotmail.comwrote:
Thanks
yap, that's what it was, thanks!
... work out your salvation with fear and trembling
Eat Kosher
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch
Sent: Monday, October 08, 2012 10:43 AM
To:
On Oct 8, 2012, at 3:44 PM, Clemens Ladisch clem...@ladisch.de wrote:
Because it's not called SQLFat.
It's called SQLite because it's self-contained and embeddable, not because it
sports subpar features.
___
sqlite-users mailing list
Hello,
I know that SQLite doesn't support ALTER TABLE DROP COLUMN, unlike
probably every other SQL database system. But every time I come across
this, I feel the pain of having to write huge amounts of code to
automatically remove single columns in a table. When doing that in code,
it's usually
On Mon, Oct 8, 2012 at 3:57 PM, Yves Goergen nospam.l...@unclassified.dewrote:
Why does SQLite still not support dropping columns
through SQL after all these years?
The only ALTER TABLE functions that SQLite supports are those that can be
accomplished without having to rewrite the entire
On 23.09.2012 12:37 CE(S)T, Baruch Burstein wrote:
Has anyone ever actually taken advantage of this feature? In what case?
No. And I guess I wouldn't need it. If I need that in other systems, I
simply use the most generic type, varchar/text or blob. This way, at
least it's obvious that text can
On Oct 8, 2012, at 10:12 PM, Richard Hipp d...@sqlite.org wrote:
ALTER TABLE DROP COLUMN requires writing every row of the table.
Could be a 'logical delete' instead. In other words, a dictionary operation
instead of a data one.
Petite Abeille wrote:
On Oct 8, 2012, at 10:12 PM, Richard Hipp d...@sqlite.org wrote:
ALTER TABLE DROP COLUMN requires writing every row of the table.
Could be a 'logical delete' instead. In other words, a dictionary operation
instead of a data one.
On Oct 8, 2012, at 3:36 PM, Darren Duncan dar...@darrenduncan.net wrote:
Petite Abeille wrote:
On Oct 8, 2012, at 10:12 PM, Richard Hipp d...@sqlite.org wrote:
ALTER TABLE DROP COLUMN requires writing every row of the table.
Could be a 'logical delete' instead. In other words, a dictionary
On Oct 8, 2012, at 10:12 PM, Richard Hipp d...@sqlite.org wrote:
the only ALTER TABLE functions supported are those that can be
done in O(1) time.
Out of curiosity, does 'add column not null default' modify the data or just
the table definition?
For example:
create table foo( x, y );
On 08.10.2012 22:12 CE(S)T, Richard Hipp wrote:
ALTER TABLE DROP COLUMN requires writing every row of the table.
Actually, I wouldn't care what the engine needs to do to get the job
done. If it's documented that a certain command requires more time, it
would be perfectly fine. SELECT queries
On 08.10.2012 22:12 CE(S)T, Richard Hipp wrote:
The only ALTER TABLE functions that SQLite supports are those that can be
accomplished without having to rewrite the entire table.
Oh, and what about the VACUUM command? That certainly needs to recreate
just about everything, and yet it's here.
On Oct 8, 2012, at 10:36 PM, Darren Duncan dar...@darrenduncan.net wrote:
Petite Abeille wrote:
On Oct 8, 2012, at 10:12 PM, Richard Hipp d...@sqlite.org wrote:
ALTER TABLE DROP COLUMN requires writing every row of the table.
Could be a 'logical delete' instead. In other words, a dictionary
Some freeware SQLite tools, such as SQLiteStudio, allow you to drop
columns (they do it by copying the table, but it's transparent to
you). If you don't need to drop the column programmatically, as part
of a bigger automated process, it works and you don't have to code
anything.
gs
I have an interesting (read: frustrating) situation in which I have two
.NET (C#) solutions which share some common projects. One of this
encapsulates our data access layer, and that is using System.Data.SQLite
version 1.0.82.0.
They are all running .NET 4.5, C# 2012, Debug, AnyCPU mode, and the
On Oct 8, 2012, at 10:47 PM, gregorinator gregorina...@gmail.com wrote:
(they do it by copying the table, but it's transparent to
you).
How do they deal with constraints? triggers? indexes? others?
If this was as straightforward as a 'create table bar as select a, b, c from
foo; drop
Jay Kreibich wrote:
On Oct 8, 2012, at 3:36 PM, Darren Duncan dar...@darrenduncan.net wrote:
Of course, if that is done, then in order to have predictable performance we'd also want
to add some other statement one can invoke when they want to reclaim disk space later,
which actually goes and
You can do it, but you need to parse the existing table schema.
1. Get the existing schema for the table, along with associated triggers and
indexes: select group_concat(SQL, x'0A' || ';' || x'0A') from SQLite_Master
where tbl_name = 'My Table'.
2. Edit the create table schema to remove the
Robert Calco wrote:
They are all running .NET 4.5, C# 2012, Debug, AnyCPU mode, and the unit
tests look identically configured, both on the hard drive and logically in
their respective solution trees. I used NuGet to install SQLite in both
solutions, so they each have their own copy in their
Igor Tandetnik itandet...@mvps.org reply:
YAN HONG YE yanhong...@mpsa.com wrote:
mysql sql cmd is:
select tb2.bb,tb2.cc,(max(tb1.mdate)-min(tb1.mdate)) as mmd,(mmd.
max(tb1.mdate).cc-mmd. min(tb1.mdate).cc) as mmc from tb1,tb2
where tb2.bb in (select bb from tb1 where bb group by bb
On 10/8/12, Petite Abeille petite.abei...@gmail.com wrote:
How do they deal with constraints? triggers? indexes? others?
If this was as straightforward as a 'create table bar as select a, b, c from
foo; drop table foo; alter table bar rename to foo;', we would most likely
not having this
YAN HONG YE yanhong...@mpsa.com wrote:
I have a 2 table:
1. tb1:
aa bb cc mdate
1 d1 2.5 2012-08-07
2 d2 3.3 2012-08-07
3 d1 6.4 2012-08-09
2. tb2:
aa bb cc
1. d1 5.3
2. d2 7.6
mysql sql cmd is:
select tb2.bb,tb2.cc,(max(tb1.mdate)-min(tb1.mdate)) as mmd,(mmd.
50 matches
Mail list logo