Hello,
The merge statement is really missing in sqlite...
Is there any plan to integrate this SQL 2003 syntax in sqlite?
Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi, ALL,
Consider this:
std::string query = ;
if( ( result = sqlite3_prepare_v2( handle, query, -1 stmt, 0 ) ) != SQLITE_OK )
{
// Should there be call to sqlite3_finalize. I.e. can I safely assume
that since it failed all memory is not being allocated
}
Thank you.
On 12 Nov 2013, at 8:45am, Sylvain Pointeau sylvain.point...@gmail.com wrote:
The merge statement is really missing in sqlite...
SQLite does have this form of the INSERT statement:
INSERT (OR REPLACE/IGNORE) INTO table1 SELECT * FROM table2
Do you have specific requirements for the UPDATE
Igor Korot wrote:
if( ( result = sqlite3_prepare_v2( handle, query, -1 stmt, 0 ) ) !=
SQLITE_OK )
// Should there be call to sqlite3_finalize. I.e. can I safely assume that
since it failed all memory is not being allocated
http://www.sqlite.org/c3ref/prepare.html says:
| *ppStmt is left
On Tue, Nov 12, 2013 at 10:43 AM, Clemens Ladisch clem...@ladisch.dewrote:
Igor Korot wrote:
if( ( result = sqlite3_prepare_v2( handle, query, -1 stmt, 0 ) ) !=
SQLITE_OK )
// Should there be call to sqlite3_finalize. I.e. can I safely assume
that since it failed all memory is not being
Despite of the following comment in mem1.c:
http://www.sqlite.org/src/artifact/437c7c4af9?ln=54-56
on Windows the _msize() function is not used at all,
neither on MSVC neither on MinGW.
The problem is that at the end of the @ifdef'ery, when
HAVE_MALLOC_USABLE_SIZE is not defined,
On 11/12/2013 5:11 AM, Stephan Beal wrote:
A related point which bit me once: if the input SQL is empty, the statement
will be NULL as well but 0 will be returned.
More generally, if the input contains nothing but (possibly empty)
sequence of comments.
--
Igor Tandetnik
Thanks for the replies. I'd like to address some of your comments so far.
--
Stephan Beal:
If the app is sandboxed, how does the user possibly
get a chance to move the files?
A sandboxed Mac OS X program can gain access to regular user-selected documents
(files or directories). And of
On Tue, 12 Nov 2013 15:10:16 +1100, SongbookDB
shaun_thom...@songbookdb.com wrote:
I've notices if I make a mistake, the prompt turns to ..., and then
legitimate commands no longer work. Is there a way to get back to the
normal prompt?
The .h command tells you what you can do there.
--
On Tue, 12 Nov 2013 15:00:36 +1100, SongbookDB
shaun_thom...@songbookdb.com wrote:
Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt.
I can load and search the db now.
So to drop the index 'index1' for the table 'table1', do I just type DROP
INDEX IF EXISTS 'index1'; ? Doing
Hi,
I took your advice and now I am setting only once the journal_mode=WAL,
also locking_mode=EXCLUSIVE and temp_store=MEMORY. But still it doesn't
work, and I get DB locks immediately. I enabled SQLite traces, and I also
added some supplementary traces when the WAL is set. Even if the
Thanks Kees - I managed to get it working.
On Tue, Nov 12, 2013 at 11:49 PM, Kees Nuyt k.n...@zonnet.nl wrote:
On Tue, 12 Nov 2013 15:00:36 +1100, SongbookDB
shaun_thom...@songbookdb.com wrote:
Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt.
I can load and search
Hello SQLite users,
I was wondering, if closing the database connection after each transaction is a
good idea.
Possibly I've missed the thread concerning this topic. If this is true, please
supply me with this link.
Otherwise, can anybody give a reliable advice to do it in this or that way. I
If the database files are being handled as a document, what I would suggest
then is to use SQLites Backup API, and work off of the backup API.
http://www.sqlite.org/backup.html
This means that the user is going to be free to do whatever they want with
the file in their documents directory. When
On Tue, Nov 12, 2013 at 8:06 AM, Stelling Carsten
carsten.stell...@goerlitz.com wrote:
Hello SQLite users,
I was wondering, if closing the database connection after each transaction
is a good idea.
No, it is usually a bad idea. There are non-trivial costs associated with
reopening the
On Mon, Nov 11, 2013 at 12:33 PM, Sandu Buraga sandu.bur...@gmail.comwrote:
Hi,
I took your advice and now I am setting only once the journal_mode=WAL,
also locking_mode=EXCLUSIVE and temp_store=MEMORY. But still it doesn't
work, and I get DB locks immediately. I enabled SQLite traces, and I
On Tue, Nov 12, 2013 at 8:12 AM, Richard Hipp d...@sqlite.org wrote:
On Mon, Nov 11, 2013 at 12:33 PM, Sandu Buraga sandu.bur...@gmail.comwrote:
Hi,
I took your advice and now I am setting only once the journal_mode=WAL,
also locking_mode=EXCLUSIVE and temp_store=MEMORY. But still it
On 12 Nov 2013, at 12:24pm, L. Wood lwoo...@live.com wrote:
Besides which, you can write it yourself externally to SQLite:
use FSEvent on the folder your database is in checking for
kFSEventStreamEventFlagItemRemoved, and act accordingly.
No need to put that facility inside SQLite.
The
Hi,
We are using sqlite dll(64-bit) in our windows application and
carrying the same dll with the application setup. Our application support
different OS versions. We downloaded the precompiled binary from the link, (
On 12 Nov 2013 at 13:49, Simon Slavin slav...@bigfraud.org wrote:
Doesn't matter because OS X is, at heart, Unix. Unix is a bit weird in that
it allows you to move and delete a file which is open.
I wouldn't describe this as weird, it should be SOP for an OS, IMO. It's (one)
of the things
Dear Richard,
Thank you for your fast response and clarification on this topic.
Regards,
Carsten
-Ursprüngliche Nachricht-
Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
Im Auftrag von Richard Hipp
Gesendet: Dienstag, 12. November 2013 14:08
An: General
On 12 Nov 2013, at 2:25pm, Tim Streater t...@clothears.org.uk wrote:
On 12 Nov 2013 at 13:49, Simon Slavin slav...@bigfraud.org wrote:
Doesn't matter because OS X is, at heart, Unix. Unix is a bit weird in that
it allows you to move and delete a file which is open.
I wouldn't describe
**kind of off topic**
@Tim I'm no where near in thinking that it should be SOP.
I'm somewhat appreciative of not being allowed to change the file
containers visual representation a file while something has its fingers on
it. Just as I tell my kids, if you make the mess, you clean it up. Don't
Hello all,
I am writing an extension library that contains some extensions, i.e.
custom functions and collations. Some of these objects use some private
data members in order to perform their calculations.
This extension library will be used by an embedded server that must handle
many database
On 12 Nov 2013 at 16:14, Stephen Chrzanowski pontia...@gmail.com wrote:
**kind of off topic**
@Tim I'm no where near in thinking that it should be SOP.
I'm somewhat appreciative of not being allowed to change the file
containers visual representation a file while something has its fingers
* For each transaction, i.e. between _prepare_v2() and _finalize(), does SQLite
on Mac OS X only use the POSIX open(), read(), write(), lseek() etc. functions
to read/write into the -journal file? Or does it use some other functions?
* For each transaction, i.e. between _prepare_v2() and
On Tue, Nov 12, 2013 at 12:25 PM, L. Wood lwoo...@live.com wrote:
* For each transaction, i.e. between _prepare_v2() and _finalize(), does
SQLite on Mac OS X only use the POSIX open(), read(), write(), lseek() etc.
functions to read/write into the -journal file? Or does it use some other
On 12 Nov 2013, at 5:36pm, Richard Hipp d...@sqlite.org wrote:
It opens and
closes the rollback journal file once per transaction.
Which does /not/ mean once per _prepare() ... _finalize().
Simon.
___
sqlite-users mailing list
On Tue, Nov 12, 2013 at 11:58 AM, Constantine Yannakopoulos
alfasud...@gmail.com wrote:
I need to know whether SQLite synchronizes its
invocations to the callbacks of these objects or whether I have to take
care of protecting the data members these callbacks are using from
concurrent access
One possibility has to be that your one problem user is on 32-bit Windows. Are
you sure that's not the case?
Did you try using the sxstrace tool? Here's good documentation for how to do so
--
http://www.fundootech.com/2013/01/how-to-use-sxstraceexe.html
J. Merrill
-Original Message-
On Tue, Nov 12, 2013 at 7:38 PM, Richard Hipp d...@sqlite.org wrote:
SQLite serializes callbacks to extension objects originating from a
single
database connection. But if you have multiple database connections running
in separate threads, then the same callback might be invoked
On Tue, Nov 12, 2013 at 8:24 PM, Richard Hipp d...@sqlite.org wrote:
On Tue, Nov 12, 2013 at 1:18 PM, Constantine Yannakopoulos
alfasud...@gmail.com wrote:
If I understand correctly what you say, each sqlite3* connection instance
serializes its calls to its extension callbacks so each
On Tue, Nov 12, 2013 at 1:18 PM, Constantine Yannakopoulos
alfasud...@gmail.com wrote:
If I understand correctly what you say, each sqlite3* connection instance
serializes its calls to its extension callbacks so each instance of the
extension objects does not need to perform any additional
OK, so it's not required.
Thank you.
On Tue, Nov 12, 2013 at 3:33 AM, Igor Tandetnik i...@tandetnik.org wrote:
On 11/12/2013 5:11 AM, Stephan Beal wrote:
A related point which bit me once: if the input SQL is empty, the
statement
will be NULL as well but 0 will be returned.
More
On Nov 12, 2013, at 9:49 AM, Simon Slavin slav...@bigfraud.org wrote:
The merge statement is really missing in sqlite…
Yes, very much so.
SQLite does have this form of the INSERT statement:
http://www.sqlite.org/lang_conflict.html
Sadly, none of these ‘on conflit’ options are of any use
Hi, ALL,
sqlite EXPLAIN QUERY PLAN SELECT DISTINCT playersinleague.playerid, leaguescore
hitter.scoreid, leaguescorehitter.value, leaguescorepitcher.scoreid, leaguescore
pitcher.value FROM playersinleague, leaguescorehitter, leaguescorepitcher WHERE
playersinleague.id = 1 AND
On 12 Nov 2013, at 9:41pm, Igor Korot ikoro...@gmail.com wrote:
I don't see what is wrong. It should be using foreign key constraints
on the last two searches, but it looks like it does not.
Did you actually create the indexes which would be useful for those
constraints, or did you just
Greetings and salutations.
I am trying to speed up our queries and normalize our DB and I am reading,
http://www.sqlite.org/eqp.html
But, I am missing a lot. Where do I read about the results and how to make
changes to the DB to speed up/enhance the DB response? Thanks.
josé
On 12 Nov 2013, at 10:47pm, jose isaias cabrera cabr...@wrc.xerox.com wrote:
I am trying to speed up our queries and normalize our DB and I am reading,
http://www.sqlite.org/eqp.html
But, I am missing a lot. Where do I read about the results and how to make
changes to the DB to speed
On Tue, 12 Nov 2013 17:47:05 -0500, jose isaias cabrera wrote:
I am trying to speed up our queries and normalize our DB and I am
reading,
http://www.sqlite.org/eqp.html
But, I am missing a lot. Where do I read about the results and how to
make changes to the DB to speed up/enhance the
Hi, Simon,
On Tue, Nov 12, 2013 at 2:18 PM, Simon Slavin slav...@bigfraud.org wrote:
On 12 Nov 2013, at 9:41pm, Igor Korot ikoro...@gmail.com wrote:
I don't see what is wrong. It should be using foreign key constraints
on the last two searches, but it looks like it does not.
Did you
On Wed, Nov 13, 2013 at 12:20:42AM +, Walter Hurry scratched on the wall:
On Tue, 12 Nov 2013 17:47:05 -0500, jose isaias cabrera wrote:
I am trying to speed up our queries and normalize our DB and I am
reading,
http://www.sqlite.org/eqp.html
But, I am missing a lot. Where do
Hi,
It is strange because it seems that the WAL journal mode was enabled:
Trace 1: before setting WAL mode
=
Filename: /mnt/share/testApp/myDB.db
State: WRITER_CACHEMOD errCode=0
Lock: EXCLUSIVE
Locking mode: locking_mode=exclusive
Journal mode:
Hello,
I am having problem with an error that is appearing whenever I startup my
computer. This happened when I downloaded the latest update of iTunes.
The issue is as follows:
The procedure entry point sqlite3-wal-checkpoint could not be located in the
dynamic library SQLite3.dll.
On Tue, Nov 12, 2013 at 1:22 PM, Norma Richey normagen1...@att.net wrote:
Hello,
I am having problem with an error that is appearing whenever I startup my
computer. This happened when I downloaded the latest update of iTunes.
The issue is as follows:
The procedure entry point
Hi,
perhaps, this can help:
1) download zip with latest SQLite DLL from http://sqlite.org/download.html;
2) unzip it to c:\temp;
3) copy c:\temp\sqlite3.dll to Windows\System32 folder;
4) if there is already sqlite3.dll in Windows\System32 and it's locked,
overwrite it with InUse.exe
46 matches
Mail list logo