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,
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. 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
On Tue, Mar 11, 2014 at 6:59 PM, St. B. 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
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
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
On Mon, Mar 10, 2014 at 7:01 PM, Jono Poff 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
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 wrote:
>
>
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
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,
___
2014-03-11 17:45 GMT+01:00 Keith Christian :
> 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
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
>
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 11 Mar 2014 at 16:11, Keith Christian 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
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]
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
On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian
wrote:
> 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
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
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
On 11 Mar 2014, at 12:20pm, Dan Kennedy 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
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 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
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 11:06am, St. B. 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
On 11 Mar 2014, at 11:31am, Fabrice Triboix 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
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
On Tue, Mar 11, 2014 at 6:35 AM, 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
On Tue, Mar 11, 2014 at 11:13 AM, RSmith 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
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 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 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 03/11/2014 04:17 AM, St. B. wrote:
Hi,
On Mon, Mar 10, 2014 at 6:37 PM, Dan Kennedy 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
33 matches
Mail list logo