Muhammad wrote:
| ... two identical sqlite databases from structure side. I want to make a
synchronization for the data ...
| Is there any library can do that OR I've to do it by myself?
With an Apple you can do it within SQLite itself.
http://www.sqlite.org/pragma.html#pragma_fullfsync
To do
Many CTE queries are just some mini-algorithms with iteration and only
last row is required. I just wondered whether it's easy to do this
without order by ... of the outer query (also mentioned in my reply
about CTE sqrt). There's a solution, but the good news is that
probably one rarely needs
Hi,
I come across memory leak with sqlite3 online backup api (Leak detected by
valgrind tool). I have used reference code from below link for test.
(Online backup for running database)
http://www.sqlite.org/backup.html
Please find below memory leak snapshot for reference.
==6084== 78,688 (880
Have any of you kind folks a recent 3.8.3 (or newer) 64-bit DLL for SQLite3
perhaps?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am confused about the difference of handling table and view selects by
sqlite.. I have the following view query:
SELECT
TLP.name, TLP.jar_file, TLP.log_file, ...
FROM
tasks_list_page TLP
and a table query:
SELECT
TSK.name, TSK.jar_file, TSK.log_file, ...
FROM
task TSK
When I
On Mon, Mar 10, 2014 at 11:53 AM, Dariusz Wawer dariusz.wa...@cc.com.plwrote:
When I obtain the column name through sqlite3_column_name() I get
different results for query on view (ALIAS.COLUMN) than for query on table
(COLUMN). The alias is included in column name for view query but not in
Hi,
I posted this question last year, but did not get any feed back. Is this
something that can be handled on the ML, or should I ask in another place?
Regards,
-- Forwarded message --
From: St. B. sbart...@gmail.com
Date: Sun, Jan 6, 2013 at 11:45 PM
Subject: Exception when
W dniu 2014-03-10 12:27, Stephan Beal pisze:
On Mon, Mar 10, 2014 at 11:53 AM, Dariusz Wawer dariusz.wa...@cc.com.plwrote:
When I obtain the column name through sqlite3_column_name() I get
different results for query on view (ALIAS.COLUMN) than for query on table
(COLUMN). The alias is
On Mon, Mar 10, 2014 at 12:52 PM, Dariusz Wawer dariusz.wa...@cc.com.plwrote:
yes, that is what is written in the documentation at
https://www.sqlite.org/c3ref/column_name.html and it is what I have read
first when trying to find an answer. It provides a solution, but it does
not answer the
On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote:
Howdy,
I've two identical sqlite databases from structure side. I want to
make a synchronization for the data but I need to keep some tables
away from the synchronization process.
Is there any library can do that OR I've to do it
On 10 Mar 2014, at 11:57am, Stephan Beal sgb...@googlemail.com wrote:
The remaining questions:
- How are view selects handled differently than table selects?
- If so, then what is the reasoning behind it?
This is not explained, but it's quite possibly that way so that the
implementation
On Mon, Mar 10, 2014 at 1:58 PM, Muhammad Bashir Al-Noimi
mbno...@gmail.com wrote:
On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote:
I've two identical sqlite databases from structure side. I want to make a
synchronization for the data but I need to keep some tables away from the
On 10 Mar 2014, at 12:58pm, Muhammad Bashir Al-Noimi mbno...@gmail.com wrote:
May I get some help from you guys?
If you're asking how to synchronise two SQL databases which may have had
different commands executed on them, then you should know that this is an
unsolved problem which involves
On 09 Mar 2014 at 22:48, Igor Tandetnik i...@tandetnik.org wrote:
On 3/9/2014 6:37 PM, Tim Streater wrote:
Dammit, I looked up and down for 'strlen' and passed over 'length'! I had
been thinking about:
update mytable set path='/path/from/' || substr(path, length('/path/to/')
+ 1)
Are the databases designed to allow you to perform such an operation easily?
On the databases I do it with, I have designed in enough extra data in the
db and logic in my code to handle sorting out what to do (which record to
use) if both databases have different data with the same primary key.
On 10 Mar 2014, at 12:58pm, Adam Devita adev...@verifeye.com wrote:
Are the databases designed to allow you to perform such an operation easily?
On the databases I do it with, I have designed in enough extra data in the
db and logic in my code to handle sorting out what to do (which record
Any hint will help me to identify root cause of leak.
Thanks
On Mon, Mar 10, 2014 at 2:58 PM, techi eth techi...@gmail.com wrote:
Hi,
I come across memory leak with sqlite3 online backup api (Leak detected by
valgrind tool). I have used reference code from below link for test.
(Online
On Mon, Mar 10, 2014 at 10:06 AM, techi eth techi...@gmail.com wrote:
Any hint will help me to identify root cause of leak.
Statically link against SQLite. Compile with -g. Use the
--leak-check=full option to valgrind.
--
D. Richard Hipp
d...@sqlite.org
Compiling on Windows 32bit VS2010
Line 73595
static const int iLn = __LINE__+4;
give an error: error C2099: initializer is not a constant
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, Mar 10, 2014 at 1:06 PM, Michele Pradella
michele.prade...@selea.com wrote:
Compiling on Windows 32bit VS2010
Line 73595
static const int iLn = __LINE__+4;
give an error: error C2099: initializer is not a constant
This is a case of VS2010 not conforming to the C89 standard.
On 03/10/2014 06:49 PM, St. B. wrote:
Hi,
I posted this question last year, but did not get any feed back. Is this
something that can be handled on the ML, or should I ask in another place?
Regards,
-- Forwarded message --
From: St. B. sbart...@gmail.com
Date: Sun, Jan 6, 2013
Hello Keith,
Thanks for the .timer on tip.
I only succeed to get a Error: not such function : sqrt from default
Sqlite.exe
How did you get that native sqrt working ?
regards,
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi,
On Mon, Mar 10, 2014 at 6:37 PM, Dan Kennedy danielk1...@gmail.com wrote:
On 03/10/2014 06:49 PM, St. B. wrote:
Hi,
I posted this question last year, but did not get any feed back. Is this
something that can be handled on the ML, or should I ask in another place?
Regards,
Hi,
I am using WAL to read/write into a database from a single process with
several threads. For performance reasons, along with the HDD database file,
I am attaching an in memory db for storing temporary information. Each
thread has it own handle. My question is: once attached the in memory db
On Mon, Mar 10, 2014 at 6:25 PM, Sandu Buraga sandu.bur...@gmail.comwrote:
Hi,
I am using WAL to read/write into a database from a single process with
several threads. For performance reasons, along with the HDD database file,
I am attaching an in memory db for storing temporary information.
I built-in an extension which defines all the standard math functions as SQL
functions.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of big stone
Sent: Monday, 10 March, 2014 13:22
To: sqlite-users@sqlite.org
Subject: Re:
When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
VACUUM statement quit working. Any idea why?
I'd be quite happy to 'rollback' to 3.8.1, but I can't find a way to
download prior versions of the SDK.
Thanks.
--
Andrew Arnott
I [may] not agree with what you have to say,
On 11 Mar 2014, at 12:56am, Andrew Arnott andrewarn...@gmail.com wrote:
When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
VACUUM statement quit working. Any idea why?
What does it do instead of work ?
Simon.
___
sqlite-users
If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on https://system.data.sqlite.org/;)
prior to
this coming Friday, March 14th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing list
In case you didn't find one by now, here's 3.8.3.1:
http://www.sqliteexpert.com/library/
On Mon, Mar 10, 2014 at 4:43 AM, RSmith rsm...@rsweb.co.za wrote:
Have any of you kind folks a recent 3.8.3 (or newer) 64-bit DLL for
SQLite3 perhaps?
It raises an error, which the sqlite.cs file that everyone uses turns into
an exception.
On Mar 10, 2014 6:01 PM, Simon Slavin slav...@bigfraud.org wrote:
On 11 Mar 2014, at 12:56am, Andrew Arnott andrewarn...@gmail.com wrote:
When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to
I expect I could build a miniature repro if that would be useful to anyone.
On Mar 10, 2014 8:05 PM, Andrew Arnott andrewarn...@gmail.com wrote:
It raises an error, which the sqlite.cs file that everyone uses turns into
an exception.
On Mar 10, 2014 6:01 PM, Simon Slavin slav...@bigfraud.org
I've created a trivial repro project, which you can download here:
http://1drv.ms/N2D4gP
The exception raised when I send VACUUM as a sql statement is:
SQLite.SQLiteException occurred
_HResult=-2146233088
_message=SQL logic error or missing database
HResult=-2146233088
Message=SQL logic
Andrew Arnott wrote:
The exception raised when I send VACUUM as a sql statement is:
SQLite.SQLiteException occurred
_HResult=-2146233088
_message=SQL logic error or missing database
HResult=-2146233088
Message=SQL logic error or missing database
Source=Dart.WinPhone8Lib
34 matches
Mail list logo