On 03/11/2014 04:17 AM, St. B. wrote:
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
Hi Dan,
Thanks for this answer, I will update the SDS to the latest version to see
how it goes, and if we get more explicit.
I still have a question. Since I have many threads (between 100 and 200)
that do reading on the table that has the R Tree, and 1 thread that will
write to another table
On 2014/03/11 11:58, St. B. wrote:
I still have a question. Since I have many threads (between 100 and 200)
that do reading on the table that has the R Tree, and 1 thread that will
write to another table once every five minutes, is it normal that I get
database is locked error on a regular
Hi,
I found a problem in sqlite.
In essence, here is what my code does:
1 - It opens a database file
2 - If it doesn't find certain tables, it assumes this is a new one and
creates the necessary tables and add a few entries in one of them (let's
call it mytable)
3 - It queries mytable by
On Tue, Mar 11, 2014 at 11:13 AM, RSmith rsm...@rsweb.co.za wrote:
On 2014/03/11 11:58, St. B. wrote:
I still have a question. Since I have many threads (between 100 and 200)
that do reading on the table that has the R Tree, and 1 thread that will
write to another table once every five
On Tue, Mar 11, 2014 at 6:35 AM, ftrib...@falcon-one.com wrote:
Hi,
I found a problem in sqlite.
In essence, here is what my code does:
1 - It opens a database file
2 - If it doesn't find certain tables, it assumes this is a new one and
creates the necessary tables and add a few entries
Hi Richard,
The problem is actually elsewhere. I changed the filesystem and it works fine.
So the problem is not with sqlite but with our special filesystem.
Sorry for having raised the alarm too quickly!
Best regards,
Fabrice
-Original Message-
From: Richard Hipp d...@sqlite.org
On 11 Mar 2014, at 11:31am, Fabrice Triboix ftrib...@falcon-one.com wrote:
The problem is actually elsewhere. I changed the filesystem and it works
fine.
So the problem is not with sqlite but with our special filesystem.
Make sure your code tests the results returned by all API calls to
On 11 Mar 2014, at 11:06am, St. B. sbart...@gmail.com wrote:
There is one writing thread (every 5 minutes). The one writing thread
writes in the same database, but it is on a different table.
Have you set a timeout for all your database handles (or just the one handle if
they're all using
Dear SQLite Team:
Hi, glad you had designed SQLite what a great open source software.
Now I have a non-technical issues. The syntax diagrams for SQLite on your
SQLite website is so beautiful, and i want to draw one for myself but I do not
know what software you use to draw it. Can
Hi,
I have an application that uses sqlite3.
Investigating a problem with the app stalling occasionally I found that
(every hour or two) an fdsync() system call from sqlite3_step() was
taking over 3 seconds to return.
On closer investigation, the file descriptor in these calls point to the
On 11 Mar 2014, at 2:51am, yulea...@163.com wrote:
Hi, glad you had designed SQLite what a great open source software.
Now I have a non-technical issues. The syntax diagrams for SQLite on your
SQLite website is so beautiful, and i want to draw one for myself but I do
not know what
On 03/11/2014 07:01 AM, Jono Poff wrote:
Hi,
I have an application that uses sqlite3.
Investigating a problem with the app stalling occasionally I found
that (every hour or two) an fdsync() system call from sqlite3_step()
was taking over 3 seconds to return.
On closer investigation, the
On 11 Mar 2014, at 12:20pm, Dan Kennedy danielk1...@gmail.com wrote:
Or PRAGMA locking_mode=EXCLUSIVE; PRAGMA journal_mode=PERSIST;,
if there will only ever be a single connection to the database.
Or you could build with SQLITE_DISABLE_DIRSYNC, which omits all
syncs on directories. Of
A few days ago, I successfully compiled the previous version of the
autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
sqlite3.exe file was produced on a Cygwin environment.
This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked,
ran 'make clean' and 'make', but no
Hi Joe,
Thanks for your reply. After making that change (and also adding the
SQLite3.SetDirectory method definition itself since that too was inside an
#if) the app crashes because WP8 doesn't support the TemporaryFolder
property.
'Windows.Storage.ApplicationData.Current.TemporaryFolder' threw
On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian
keith1christ...@gmail.comwrote:
A few days ago, I successfully compiled the previous version of the
autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
sqlite3.exe file was produced on a Cygwin environment.
This morning, I downloaded
Richard,
Thanks for the reply. Your instructions produced a working
sqlite3.exe in the Cygwin environment, using
sqlite-amalgamation-3080401.zip.
The resulting file is quite large, almost 14 times the size of the
sqlite3 version 3.8.3 packages with Cygwin:
ls -l /usr/bin/sqlite3.exe
That is because you are statically linking the SQLite shell and the SQLite
library into a single executable file instead of having the shell (sqlite3.exe)
and the library (sqlite3.dll?) in separate files.
-Ursprüngliche Nachricht-
Von: Keith Christian [mailto:keith1christ...@gmail.com]
On 11 Mar 2014 at 16:11, Keith Christian keith1christ...@gmail.com wrote:
The resulting file is quite large, almost 14 times the size of the
sqlite3 version 3.8.3 packages with Cygwin:
ls -l /usr/bin/sqlite3.exe
-rwxr-xr-x 1 kchris Domain Users 60957 Feb 4 04:45 /usr/bin/sqlite3.exe
Hick, Tim,
Thanks, I thought it was something like that. Couldn't remember the
exact gcc switches as to whether the debug code may have been included
or not in Richard's command line, which was my first thought. But at
least with Richard's command line I have a working, up to date sqlite3
On Mar 11, 2014, at 3:51 AM, yulea...@163.com wrote:
Now I have a non-technical issues. The syntax diagrams for SQLite on your
SQLite website is so beautiful, and i want to draw one for myself but I do
not know what software you use to draw it. Can you tell me? and, is it the
software
2014-03-11 17:45 GMT+01:00 Keith Christian keith1christ...@gmail.com:
Will have to troubleshoot the details of the makefile changes between
the autoconf version from 3.8.3 to 3.8.4, to see why on this Cygwin
environment a sqlite3.exe wasn't created. That will be awhile,
pretty busy at $WORK
Hello,
Thanks to Keith's help I succeeded to set up a comparison a native sqrt()
versus a python mysqrt() function .
The speed-up in a best case non-realistic scenario is only 40%.
create_function() looks very performant.
Regards,
___
sqlite-users
Andrew Arnott wrote:
I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got
too intense for my limited C++ knowledge.
If the Windows Phone 8 wrapper for SQLite does not properly set the
temporary
directory, queries that requires a temporary file (e.g. VACUUM) may fail.
HI,
So I updated to V1.0.91 of SDS, but now I get the following error at each
query run against the database :
SQLite error (1): no such table: sqlite_stat1
What should I do to get the table properly created?
On Tue, Mar 11, 2014 at 12:50 PM, Simon Slavin slav...@bigfraud.org wrote:
On 11
On Mon, Mar 10, 2014 at 7:01 PM, Jono Poff jonathan.p...@taitradio.com wrote:
I'm using Solaris 10 with zfs and I may be able to disable write caching on
the entire disk, but would prefer not to! Any ideas appreciated.
The way ZFS works, if you don't have a ZIL (ZFS Intent Log) device
then all
On Tue, Mar 11, 2014 at 6:59 PM, St. B. sbart...@gmail.com wrote:
HI,
So I updated to V1.0.91 of SDS, but now I get the following error at each
query run against the database :
SQLite error (1): no such table: sqlite_stat1
What is the text of the query you are running?
What should I do
Hello
A friend needs to move from Excel to a database. The school won't
pay for the full version of MS Office that includes Access, so
recommended that she use LibreOffice Base instead.
I just checked it out, and it seems to only be a front-end to the
HSQLDB database which is written in
On 11 Mar 2014, at 10:59pm, St. B. sbart...@gmail.com wrote:
So I updated to V1.0.91 of SDS, but now I get the following error at each
query run against the database :
SQLite error (1): no such table: sqlite_stat1
What should I do to get the table properly created?
Open the database and
Hi Joe,
Thanks for the workaround. It works!
Is there a place where a bug should be filed to track this?
--
Andrew Arnott
I [may] not agree with what you have to say, but I'll defend to the death
your right to say it. - S. G. Tallentyre
On Tue, Mar 11, 2014 at 3:30 PM, Joe Mistachkin
I have turned off using PRAGMA wal_autocheckpoint = 0. There is a background
thread which would call sqlite3_wal_checkpoint at some interval of time to
ensue that WAL size does not grow big.
I dont see any error returned by API sqlite3_wal_checkpoint. Also I dont see
WAL size being reduced
SQLite Expert has a free version that can be used. Certain UI features are
missing, but, it does allow for excel like table editing. Its also MUCH
cheaper than anything Microsoft has put out, even with their dealer
discounts and oem sales with proper hardware purchases.
On Tue, Mar 11, 2014 at
33 matches
Mail list logo