Do you know that VS2012 has known optimizer bugs?
Pavel
On Apr 6, 2013 5:01 AM, "ibrahim" wrote:
> On 05.04.2013 17:01, Dan Kennedy wrote:
>
>> On 04/05/2013 09:08 PM, Rob Collie wrote:
>>
>>> Yeap, I'm on Visual Studio 2012. I've created a console app:
>>>
>>>
>>> sqlite3 *oDatabase;
>>> in
On Fri, Mar 29, 2013 at 12:17 PM, Jeff Archer
wrote:
> 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 processi
On Wed, Mar 13, 2013 at 11:48 AM, David King wrote:
>> BTW, in case you don't do that yet your best performance will be if
>> you prepare your UPDATE and INSERT statements only once and then do
>> bind + step + reset in that 100k times loop.
>
>
> In principle I agree, but since the temporary-tabl
On Tue, Mar 12, 2013 at 11:03 PM, David King wrote:
>> > At first I was just doing something like this pseducode:
>> > update_counter(k1, k2, count=count+1, expires=now+count*1day)
>> > if rows_updated != 1: insert_counter(k1, k2, count=1, expires=now+1day)
>>
>> Assuming these 2 statements consti
>> First of all in the statement above you don't gain benefit from
>> uniqueness and replace about 10k rows twice.
>
> Are you sure? The SELECT in the INSERT OR UPDATE selects "FROM
> trans_counters_v AS c", the grouped temporary view. So it should only see any
> given key pair once before it sta
On Tue, Mar 12, 2013 at 8:29 PM, David King wrote:
> I'm trying to find an efficient way to store simple incrementing integers but
> I'm having trouble finding an efficient way to do it
>
> My database looks like:
>
> CREATE TABLE counters
> k1, k2,
> count, -- how many we've seen
> expires
On Sun, Mar 3, 2013 at 11:48 AM, Tom Matrix wrote:
> Hello,
>
> I’ve encountered a problem, which is hardly reproducable on arbitrary
> databases, therefore I attached one.
> The problem is that inner join omits the result on large datasets. But
> again, ’large’ does not necessarly refer simply th
On Thu, Feb 28, 2013 at 10:50 PM, Gert Van Assche wrote:
> All, I don't know if this is possible.
>
> A segment in table "Files" contains a record "Content" with a fields like
> this "XXX "
> Needs to become "XXX 123 456 78 90"
>
> Based on a "Translation" ta
On Tue, Feb 26, 2013 at 2:29 PM, Igor Tandetnik wrote:
> On 2/26/2013 5:13 PM, anydacdev anydacdev wrote:
>>
>> I am struggling with SQLite's support for Oracle's DUAL table.
>>
>> The updated statement, now including Oracle's DUAL looks like.
>>
>> MERGE INTO x TGT
>> USING (SELECT 'A_NAME' as na
> Example, If I insert 10 records and loop a query I receive
> 10, 10, 10, 10, results
> But, if I change one of the records during the loop I get
> 10, 10, update record, 9, 10,
This sounds gibberish. Could you please post your database schema and
exact queries you issue in the exact or
That's SQL standard -- query with aggregate functions always return at
least one row.
Pavel
On Fri, Feb 22, 2013 at 12:06 PM, Pierre Chatelier
wrote:
> Hello,
>
> [tested under 3.6.12 and 3.7.15.2]
>
> I have a question regarding the use of aggregate functions.
>
> Let's imagine the following d
On Tue, Feb 19, 2013 at 1:39 AM, mikkelzuuu wrote:
> Hey guys, I'm getting this error (see title)
> I'm using C# by the way.
>
> string StrQuery = @"INSERT INTO Test VALUES (" +
> dataGridView1.Rows[i].Cells["Column1"].Value + ", " +
> dataGridView1.Rows[i].Cells["Column2"].Value + ", " +
> dataGr
> Anyone out there know how to correct this undesirable behaviour?
>
> PS. This only happens over NFS - local DB files behave as expected and fill
> the OS page cache.
Don't write your database to NFS. I'd guess that your problem is that
NFS driver for some reason thinks that the file was changed
> Don't know if the index is updated after each row delete or after the whole
> delete transaction is commited. For the first you can try:
>
> time sqlite3 trip.db "PRAGMA automatic_index= FALSE; delete from trip where
> key<=1400;PRAGMA automatic_index= TRUE; reindex trip"
PRAGMA automatic_inde
On Fri, Feb 1, 2013 at 6:42 AM, message adams wrote:
> Greetings;
>
> I've recently started using sqlite within Python, to help unit-test my
> applications.
>
> My applications actually run against sybase, but I'd love to use a
> connection to an in-memory sqlite to carry out my testing.
> As part
Sun, Jan 27, 2013 at 5:20 PM, Shuki Sasson wrote:
> Pick up any book about UFS and read about the journal...
>
> Shuki
>
> On Sun, Jan 27, 2013 at 7:56 PM, Pavel Ivanov wrote:
>
>> > So in any file system that supports journaling fwrite is blocked until
>> all
>
t; makes a lot of sense as data blocks are not protected by the journal,
> however with more robust File System that have full journal for metadata as
> well as data it makes all the sense in the world to run with
> synchronization = OFF and gain the additional performance benefits.
>
>
On Sat, Jan 26, 2013 at 6:50 PM, Shuki Sasson wrote:
>
> Hi all, I read the documentation about the synchronization pragma.
> It got to do with how often xSync method is called.
> With synchronization = FULL xSync is called after each and every change to
> the DataBase file as far as I understand.
On Wed, Jan 9, 2013 at 6:06 AM, wrote:
>
> >
> > Mensaje original
> > De: Clemens Ladisch
> > Para: sqlite-users@sqlite.org
> > Fecha: Wed, 09 Jan 2013 14:25:31 +0100
> > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version
> andlater
> >
> >
> >
> >a...@zator.com
You may be hitting the memory fragmentation issue. Try to run your
application with different memory managers (Hoard is my favorite -
http://www.hoard.org/) and see if the memory consumption is the same.
Also if you close all connections to your database (and other SQLite
databases too) does amoun
On Wed, Dec 26, 2012 at 9:55 PM, Daniel Colascione wrote:
> On 12/26/12 9:54 PM, Pavel Ivanov wrote:
>> I believe you can get this functionality now by compiling SQLite code
>> using cygwin compiler, not a Win32 one (and not downloading dll
>> library from sqlite.org web
I believe you can get this functionality now by compiling SQLite code
using cygwin compiler, not a Win32 one (and not downloading dll
library from sqlite.org website).
Pavel
On Wed, Dec 26, 2012 at 9:19 PM, Daniel Colascione wrote:
> Creating temporary tables fails in Cygwin SQLite:
>
> sqlite>
#x27;t return any row affected value. Well it makes sense somehow.. It
> cannot know how many view's visible rows were affected. It lowers the
> coolnes of views and instead of trigs.
>
> Thanx
>
> On Mon, Dec 24, 2012 at 12:15 AM, Pavel Ivanov wrote:
>
>> Do you
Do you execute all updates as one call to sqlite_exec? Or as separate
calls to sqlite_exec or sqlite_prepare/sqlite_step? If separate then
do you check return value from the calls? And do you execute
BEGIN/COMMIT somewhere?
Pavel
On Sun, Dec 23, 2012 at 2:37 PM, Alem Biscan wrote:
> Hello,
>
> I
> I have found that when using SQLite under Windows if you execute an update
> statement and then a select statement, the database is locked until the
> select statement is finished. How can I stop this from happening?
Note that you don't have to execute UPDATE before the SELECT to
reproduce that
> # http://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/
> Unlike traditional tables, the ROWID of an FTS table is stable through
> a vacuum (VACUUM in Appendix C), so it can be reliably referenced
> through a foreign key.
I'm not sure who wrote that but this page
http://ww
I'd say generally speaking your way of storing data has no significant
downsides. There's just one "but": if each row in your table stores pretty
significant amount of data (blobs, long text fields or just lots of
different fields) you'd better not make your ItemID INTEGER PRIMARY KEY.
Because SQLi
This problem was fixed here http://www.sqlite.org/src/info/5526e0aa3c.
It will appear in the next version of SQLite.
Pavel
On Mon, Oct 29, 2012 at 5:41 AM, NSRT Mail account.
wrote:
> In the example, I just realized something that makes matters worse.
>
> sqlite> SELECT "id" AS "id", "name" AS "
ich I don't have a
> response: MySQL handles fragmentation better, and by extension would give
> us better performance on the same hardware. I'd like to know more about
> it, which is why I've asked. Thanks!
>
> -david
>
> [1] http://permalink.gmane.org/gmane.com
es. I'm just *also*
> interested in this very specific issue.
>
> -david
>
> On Sun, Oct 28, 2012 at 12:38 PM, Pavel Ivanov wrote:
>
>> > That said, I'd still welcome any quick summary of the differences between
>> > sqlite and mysql when it comes to
> That said, I'd still welcome any quick summary of the differences between
> sqlite and mysql when it comes to fragmentation.
This is far from main differences between sqlite and mysql that you
should consider if you want to choose between them unless of course
your question is just about an acad
I guess this can stand as one more argument for not using SQLite over
NFS. Another argument could be found here:
http://www.sqlite.org/lockingv3.html#how_to_corrupt.
Pavel
On Wed, Oct 24, 2012 at 2:01 PM, Efim Dyadkin wrote:
> I was probably not quite specific. So I would like to rephrase the p
SQLite expects all paths to be in UTF-8 (non-standard for Win but the
same for all platforms). Is your path in UTF-8 or in some other system
encoding?
Pavel
On Tue, Oct 23, 2012 at 6:28 AM, Václav Jirovský
wrote:
> Hello,
>
> I tried to use SQLite 3.7.14.1 with sqlite-net 1.0.5 (both official fr
On Sat, Oct 20, 2012 at 10:41 PM, Igor Korot wrote:
> Hi, ALL,
> According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY
> support is disabled by default.
> In order to enable it I need to compile SQLITE with 2 defines undefined.
Which also undefined by default. Any SQLITE_OMIT_* defi
>> Var Alice := Db.SelectRecord('SELECT * FROM client WHERE client_name = ?', [
>> 'alice' ]);
>>
>> 1. If I drop record for "alice" from db and then access column data in
>> prepared stmt will it work OK?
>
> If the select statement wasn't reset or finalized, you won't be able to
> delete a re
On Thu, Oct 18, 2012 at 6:32 AM, Daniel Polski wrote:
>> The SELECT statement, including the _prepare() stage and all the _step()s
>> until you've reached the last row, and then the _finalize(), is all one
>> process. They're all part of the statement and you can assume that the
>> database is st
The problem is you are starting read-only transaction by executing
SELECT and then try to convert this transaction into writing one by
executing BEGIN IMMEDIATE. If in such situation SQLITE_BUSY is
returned you have to finish the transaction and start it again. In
your code solution is easy: finali
On Sun, Oct 14, 2012 at 12:07 PM, Ryan Johnson
wrote:
> On 14/10/2012 2:26 PM, Pavel Ivanov wrote:
>>>
>>> What kind of interpreter does the query executor uses? How important is
>>> the
>>> interpreter's speed, to SQLite's speed ?
>>
>
> What kind of interpreter does the query executor uses? How important is the
> interpreter's speed, to SQLite's speed ?
SQLite doesn't have interpreter, it has parser. I guess this makes the
rest of your email inapplicable.
Pavel
On Sun, Oct 14, 2012 at 4:38 AM, Elefterios Stamatogiannakis
w
Well, an article on write barriers published in May 2007 can't
contradict the statement that barriers don't exist these days. :)
Pavel
On Fri, Oct 12, 2012 at 5:38 AM, Black, Michael (IS)
wrote:
> There isn't Somebody sure wasted their time on this article then...
> http://www.linux-magazin
On Thu, Oct 11, 2012 at 7:09 AM, Hamish Symington
wrote:
>> Note that I was mistaken earlier when I said that "X=Y" and "Y=X" should
>> result in the same answer. If X and Y have different default collating
>> sequences, then X=Y does not mean the same thing as Y=X and so the answers
>> can be di
See http://www.sqlite.org/src/wiki?name=Bug+Reports .
Pavel
On Mon, Oct 1, 2012 at 3:10 AM, Álvaro García wrote:
> I Have a problem with Entity framework and SQLite and I would like to open a
> ticket to expose my problem, but I don't see the way to open the ticket.
>
> could someone help me?
>
On Wed, Sep 26, 2012 at 5:55 AM, Simon Slavin wrote:
>
> On 26 Sep 2012, at 5:42am, Dan Kennedy wrote:
>
>> So when SQLite requires a temporary
>> file, it normally creates and opens a file with a randomized name
>> in /tmp then calls unlink() on it immediately - before it starts
>> using the fil
On Wed, Sep 19, 2012 at 7:10 PM, Mohd Radzi Ibrahim wrote:
> On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik wrote:
>
>> On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote:
>>
>>> Too bad SQLite doesn't yet support SQL Window Functions.
>>>
>>> Are there any SQLite Extension Libraries that su
On Fri, Sep 14, 2012 at 8:57 AM, Igor Tandetnik wrote:
> On 9/14/2012 10:36 AM, Pavel Ivanov wrote:
>>
>> On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik
>> wrote:
>>>
>>> Wait a minute. If "statement-level read consistency" only applies to two
&g
On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik wrote:
> Pavel Ivanov wrote:
>> There's another way how it could make sense - if you read that excerpt
>> in context. ;-) The "statement-level read consistency" definition
>> cited by Petite is the transact
On Thu, Sep 13, 2012 at 9:29 PM, Igor Tandetnik wrote:
> Pavel Ivanov wrote:
>> On Thu, Sep 13, 2012 at 3:36 PM, Igor Tandetnik wrote:
>>> On 9/13/2012 4:39 PM, Petite Abeille wrote:
>>>>
>>>>
>>>> On Sep 13, 2012, at 10:24 PM, Igor Tandetn
On Thu, Sep 13, 2012 at 3:36 PM, Igor Tandetnik wrote:
> On 9/13/2012 4:39 PM, Petite Abeille wrote:
>>
>>
>> On Sep 13, 2012, at 10:24 PM, Igor Tandetnik wrote:
>>
In other words, a select should only ever see what existed at the
beginning of the query, and that is that.
>>>
>>>
>>> Ag
Note: attachments are stripped out of this list. So if you want for
anybody else to see your zip file you need to put it on some website
and post link here.
About the problem you have: I wonder how are you sure that there
should be 50 rows in the database and not 49? If you are resetting the
OS be
If pBuf points to an invalid memory it's possible that you use already
closed connection or already finalized statement. Or maybe your
application corrupts SQLite's memory. Try to run your program under a
memory debugger.
Pavel
On Sat, Sep 8, 2012 at 10:11 AM, David Levinson wrote:
> All,
>
> I
> However, bus errors are often the result of something in your own code, or of
> not checking the result codes returned by all your previous SQLite3 calls.
Simon,
You are confusing bus errors with segmentation faults. They are
different things and bus errors inside SQLite can never be caused by
Maybe you have 32-bit SQLite.Interop.dll and don't have 64-bit
SQLite.Interop.dll?
Pavel
On Tue, Sep 4, 2012 at 2:49 PM, Joe Mistachkin wrote:
>
>>
>> After few tries, I've finally downloaded the 64 bits zip (
>> sqlite-netFx40-static-binary-bundle-x64-2010-1.0.81.0.zip) and deployed
>> the 2 S
There's a documentation bug on the Release Notes page:
"Enhancements to PRAGMA integrity_check and PRAGMA quick_check so that
they can optionally check just a single attached database >install< of
all attached databases."
Should be "instead" instead of "install".
Pavel
On Tue, Sep 4, 2012 at
> thanks a lot,
> but about the second question,I write java code,and find if the connection
> exceeds 17990,then will throws exception
This probably happened because your OS restricts number of open file
descriptors or something like that.
Pavel
On Sat, Sep 1, 2012 at 7:52 PM, wrote:
> than
If all your inserts are in one transaction then pragma synchronous =
OFF won't affect your transaction speed too much. To understand
whether this pragma works or not you should measure how long it takes
to execute COMMIT (just this one statement). With synchronous = OFF
COMMIT will be executed much
This is a documented change. See http://www.sqlite.org/releaselog/3_7_11.html:
"Pending statements no longer block ROLLBACK. Instead, the pending
statement will return SQLITE_ABORT upon next access after the
ROLLBACK."
There was even some explanation of reasons for that somewhere on the list.
P
> When I implement the same mechanism for saving the
> memory database back to disk, the size of disk file is 4x of the original
> disk file size.
What is "original disk file size" here? Is it an empty database,
database with some data, database with exactly the same data you are
restoring? If the
You can try to use authorizer
(http://www.sqlite.org/c3ref/set_authorizer.html) although it seems to
me SQLite won't inform you about access to table2 in the first query.
Pavel
On Mon, Aug 20, 2012 at 2:18 AM, Bishwa Shrestha
wrote:
> Hi,
>
> I am creating an sqlite3 interface to an existing da
> "There are four levels to the shared-cache locking model: transaction
> level locking, table level locking, cache level locking, and schema
> level locking. They are described in the following three sub-sections."
This would be a bad way of documenting this because "cache level
locking" works
Another idea for you:
> In our test, on the other hand, each thread queries its own set of
> rows from the table. So, based on your explanation, here each thread
> should end up with its own set of pages (more or less). However, even
> in this case, I still observe a near sequential performance.
> In each case the same thing happens, the messages briefly display, then
> disappear
I think your sms-controlling app has synced the whole sms database
with some server. When you start your phone it shows you local data
but then it sees that server has latest data (maybe using modification
date o
As you don't have stmt defined anywhere this is apparently not the
actual program you run. Seeing the full source code would be more
helpful. If the whole source is too big try to reduce it to small
program reproducing the problem. It's possible that while attempting
to reduce program source you'll
Keith,
No SQL format can guarantee anything. And changing SQL format won't change
its execution plan - SQL optimizer will decide that for you. And I don't
know where did you take your information from but I can guarantee you that
with your query SQLite will execute strftime many times and OP's pro
> I'm trying to convince myself that the subquery in latest_aliases only
> executes once, and also that alias_info only runs latest_aliases once.
> However, I'm not doing very well at convincing myself. Can someone confirm
> this is true, or suggest a nice solution to get the current time functi
On Sat, Jul 21, 2012 at 7:35 PM, AJ ONeal wrote:
>>
>> Read the documentation carefully:
>> http://www.sqlite.org/fts3.html#matchinfo. Right the first paragraph:
>>
>> The matchinfo function returns a blob value. If it is used within a
>> query that does not use the full-text index (a "query by ro
On Sat, Jul 21, 2012 at 4:06 PM, AJ ONeal wrote:
>>
>> > Now I see a number which matches my expectations:
>> > SELECT hex(matchinfo(t1)) FROM t1 WHERE t1 MATCH 'default transaction
>> > "these semantics"';
>> >
>> >
>> 0300020001000300020001000100010002
On Sat, Jul 21, 2012 at 3:36 AM, AJ ONeal wrote:
> I naively tried
>
> wget
> https://raw.github.com/gist/3154964/d570955d45580c095c99de6eb0c378395d4b076d/sqlite3-fts4-rank.c
> gcc -c sqlite3-fts4-rank.c -o sqlite3-fts4-rank.o
>
> sqlite3
> .load sqlite3-fts4-rank.o
>
> But that didn't work.
>
> C
On Thu, Jul 19, 2012 at 2:07 PM, Rick Maddy wrote:
> Didn't mean to imply that failing to check the return value resulted in
> memory corruption. I was wondering if it was possible that one of the many
> calls to sqlite3_bind_* in my code may actually be causing some memory
> corruption. I can
There's no easy method of detecting memory corruption from inside your
own application, especially the memory that your application don't
control. You can use memory debuggers for that purpose. If you were on
Linux I would recommend to use valgrind. But I don't know if there are
any similar tools o
> For quite some time now I've been getting reports of crashes in my iOS app.
> Specifically these are caused by crashes in sqlite3_prepare_v2 and
> sqlite_step. The associated code works fine most of the time. So I'm looking
> for thoughts on how to find and fix the problem since there seems to
On Wed, Jul 11, 2012 at 2:00 PM, deltagam...@gmx.net
wrote:
> If mydetails contains a value, and I delete this value with "SQLite Database
> Browser"
> it seems not to be a "real NULL", has someone an explanation for this
> behaviour ?
It depends on your meaning of word "delete". But maybe when y
> // here maybe NULL is returned ?
> mydetails = (char*)sqlite3_column_text(stmt, 0 );
Check sqlite3_column_type() before calling sqlite3_column_text(). If
it returns SQLITE_NULL then you have NULL.
Pavel
On Wed, Jul 11, 2012 at 1:40 PM, deltagam...@gmx.net
wrote:
> Hello,
>
> how to p
.
> Might it be? Should I be casting them to the correct type first?
>
> Sam
>
> On Thu, Jul 5, 2012 at 11:24 PM, Pavel Ivanov wrote:
>
>> The insert statement below should insert one row into table
>> PP_VIEWER_SETTINGS. Does it do that? Is it what you called "d
> sqlite> SELECT test_base.id, SUM(test_join.value) FROM test_base LEFT
> JOIN test_join ON test_join.base_id = test_base.id GROUP BY
> test_base.id HAVING SUM(test_join.value)='0';
> sqlite>
>
> The last statement generates no results. There is no mention of a
> special case for HAVING so I would
On Thu, Jul 5, 2012 at 10:54 AM, Jonathan Haws
wrote:
> I am fairly new to database development and I am working on an embedded
> system where we are utilizing SQLite to manage some files and other
> information that is being shared between processes. What I am doing is I
> have the SQLite ama
The insert statement below should insert one row into table
PP_VIEWER_SETTINGS. Does it do that? Is it what you called "does not
work"? To insert several rows you need to write a huge join of
dblookup to itself, so your insert statement should look like this:
insert into PP_VIEWER_SETTINGS (...)
s
wrote:
> It returns 3.6.23.1
>
> ________
> From: Pavel Ivanov
> To: T Ü
> Cc: General Discussion of SQLite Database
> Sent: Thursday, July 5, 2012 3:40 PM
>
> Subject: Re: [sqlite] Multiple connections to in-memory database
>
> On Thu, Jul
On Thu, Jul 5, 2012 at 8:37 AM, T Ü wrote:
> By trying I found out that SQLiteConnection("Data
> Source=:memory:;cache=shared"); worked.
> In a single aspx.page at cs code, first I open an in-memory database
> connection
> SQLiteConnection conn = new SQLiteConnection ( "Data
> Source=:memo
On Thu, Jul 5, 2012 at 7:46 AM, T Ü wrote:
> I have an asp.net application.
> I open a sqlite in-memory connection with SQLiteConnection conn = new
> SQLiteConnection ( "Data Source=:memory:" ); command.
> I read that by using cache=shared parameter, I can make that in-memory
> database reachabl
On Tue, Jul 3, 2012 at 10:55 AM, Jay A. Kreibich wrote:
> On Tue, Jul 03, 2012 at 02:43:29PM +0200, Paul van Helden scratched on the
> wall:
>
>> > The statement "UPDATE table SET column=NULL" updates every row in the
>> > table. The fact that some rows may already have a NULL in that
>> >
On Tue, Jul 3, 2012 at 9:21 AM, Paul van Helden wrote:
>> So rather than holding your breath for Oracle to change I'd recommend you
>> do it the portable way.
>>
> I'm not waiting for anything. My last question was simple: which is
> better? Since MySQL does it the "correct way" perhaps we can jus
On Mon, Jul 2, 2012 at 4:02 PM, deltagam...@gmx.net wrote:
> Hello,
>
> I couldnt find in the documentation what the max size of TEXT field/column
> is.
http://www.sqlite.org/limits.html#max_length
By default it's 10^9 bytes and cannot be more than 2^31 - 1.
Pavel
_
On Fri, Jun 29, 2012 at 4:55 PM, Jeff Archer wrote:
>>Kevin Benson kevin.m.benson at gmail.com Fri Jun 29 16:32:55 EDT 2012
>>
>>The mention of SQLITE_SCHEMA error and sqlite3VdbeExec() sounds like maybe
>>you're fighting an expired statement???
>
> Not likely. I do Prepare, Bind, Step, Finalize
I think SQLITE_SCHEMA can happen even if you run things like CREATE
TABLE or ALTER TABLE on the same connection. Also ATTACH DATABASE and
DETACH DATABASE should invalidate all statements prepared before that.
Pavel
On Thu, Jun 28, 2012 at 9:58 AM, Marc L. Allen
wrote:
> Oh.. you're positing a s
On Thu, Jun 28, 2012 at 9:54 AM, Hector Guilarte wrote:
> I don't think it would.
>
> Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db",
> config.toProperties());
>
> is telling to open a connection to the file "sample.db" which is located in
> the same folder as the applicatio
On Tue, Jun 26, 2012 at 8:48 PM, Stephen Chrzanowski
wrote:
> All;
>
> When you compile the amalgamation with your source code, doesn't the
> compiler reject/not include/remove/doesn't consider the code that could
> have been generated from the actual final build? In other words, if you
> just ha
On Tue, Jun 26, 2012 at 3:02 PM, Igor Tandetnik wrote:
> On 6/26/2012 1:19 PM, Peter Haworth wrote:
>>
>> I still have the issue that, in order to be selected, the rows in the
>> groups containing two entries must have a different value in a specific
>> column.
>
>
> I'm not quite sure I understa
http://www.lcsql.com>
>
>
>
> On Sat, Jun 23, 2012 at 9:00 AM, wrote:
>
>> Message: 5
>> Date: Fri, 22 Jun 2012 19:17:39 -0400
>> From: Pavel Ivanov
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] Selecting from a GROUP Sele
automatically create it for you after sqlite3_open().
Pavel
On Tue, Jun 26, 2012 at 12:27 PM, deltagam...@gmx.net
wrote:
> Am 26.06.2012 18:00, schrieb Pavel Ivanov:
>
>> On Tue, Jun 26, 2012 at 11:50 AM, deltagam...@gmx.net
>> wrote:
>>>
>>> Am 26.06.2012 1
On Tue, Jun 26, 2012 at 11:50 AM, deltagam...@gmx.net
wrote:
> Am 26.06.2012 17:08, schrieb Pavel Ivanov:
>
>> You are leaking stmt statement (re-preparing without finaliznig) and
>> your call to sqlite3_close returns SQLITE_ERROR because of that, but
>> you don'
You are leaking stmt statement (re-preparing without finaliznig) and
your call to sqlite3_close returns SQLITE_ERROR because of that, but
you don't even check that so you are leaking database connections as
well.
Pavel
On Tue, Jun 26, 2012 at 11:01 AM, deltagam...@gmx.net
wrote:
> Am 26.06.2012
On Mon, Jun 25, 2012 at 10:05 PM, Bo Peng wrote:
>> Are these multiple tables in a single database (file), or multiple databases
>> (files)? Multiple connections or a single connection?
>
> Right now there are multiple read-only processes to read the same
> file. If I go with any RAM-based solut
On Mon, Jun 25, 2012 at 4:15 PM, deltagam...@gmx.net
wrote:
> Hello,
>
> Im using MSVS 2010 for an c++ GUI project.
> After including sqlite3.h and sqlite3.c from the amalgamation-3071200
> and with the Project Properties--> C/C++ --> Precompiled Headers -->
> Precompiled Header --> Use (/Yu)
> I
On Sat, Jun 23, 2012 at 10:36 PM, Dennis Volodomanov wrote:
> On 24/06/2012 12:29 PM, Pavel Ivanov wrote:
>>
>> AFAIK, checkpoints are application-specific, but SQLite prohibits
>> second writer until first one committed its transaction and released
>> database lock. S
On Sat, Jun 23, 2012 at 10:18 PM, Dennis Volodomanov wrote:
> It does raise an interesting question though - how is this handled in SQLite
> internally? When there are two writers, both writing to the same DB (WAL
> mode) and one of them crashes before reaching a checkpoint, will the second
> writ
On Sat, Jun 23, 2012 at 9:21 PM, Dennis Volodomanov wrote:
> On 22/06/2012 9:48 AM, Dennis Volodomanov wrote:
>>
>> I'll see if the new compilation options still make this happen, but it
>> takes a couple of hours for each test due to data volume and I'd need to run
>> a few tests (unless it occur
ou(Pavel) for the prompt response.
>
> Sqlite does auto commit for every 25k insertions. Do I need to change the
> number from 25k to x ( for ex: 100)?
>
> On Thu, Jun 21, 2012 at 7:54 AM, Pavel Ivanov wrote:
>
>> On Wed, Jun 20, 2012 at 11:33 PM, Durga D wrote:
>> &g
On Sat, Jun 23, 2012 at 2:28 PM, Simon Slavin wrote:
> On 23 Jun 2012, at 7:14pm, "Peter M. Friedrich"
> wrote:
>
>> do you think it's possible to create a different backend? I want to
>> develop a relational database system which uses tables in FITS-files
>> (for details about this format see
>
I guess you need something like
SELECT * from TableA
WHERE z in (
SELECT z FROM TableA GROUP BY z HAVING count(*)=2
);
Pavel
On Fri, Jun 22, 2012 at 6:43 PM, Peter Haworth wrote:
> I have a situation where I need to select entries based on the count of the
> number of entries in a GROUP = 2,
Ask this on Android-related mailing list.
And if you include your populated database into application package
before installation and don't see any data after installation check
that you open your database with an absolute path otherwise you could
be opening some other database file, not the one y
1 - 100 of 1186 matches
Mail list logo