Schuhmacher, Bernd wrote:
>
> I am trying to put up a little program using System.data.SQLite with C#
> under Visual Studio 2017. The Target Framework is dotnet core 2.0
> I imported the nuget Package (Project - manage nuget Package ...) into
> the Project.
> The compilation works fine. But if
Ok, hosed over by proguard once again. Needed to make sure the following
was in my proguard-project.txt file:
-keep class org.sqlite.** { *; }
Oh man! I must be getting old.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
On 19 Sep 2018, at 8:47pm, Roger Cuypers wrote:
> the database has a root file. The subfiles are all loaded via separate
> connections as far as I know.
Sorry, but this makes no sense. Each database file can have only one WAL file.
You say that the program is looking through lots of WAL
Hello,
the database has a root file. The subfiles are all loaded via separate
connections as far as I know.
Another idea of mine:
If I know the database will be only written to very rarely, can I prevent
sqlite from using the WAL files at all in the meantime?
> Am 19.09.2018 um 21:36 schrieb
I think it does at some point. I’m at home right now so I have to check this
again tomorrow when I have access to the source.
Should there be rbu calls if the application is only _reading_ fro the database
and not updating?
> Am 19.09.2018 um 21:48 schrieb Dan Kennedy :
>
> On 09/20/2018
On 09/20/2018 01:49 AM, Roger Cuypers wrote:
I'm trying to optimize a C++ application that uses sqlite 3 for database
access. As far as I know it uses journaling with WAL and has a lot of
files/tables (about 400). Profiling this application with Linux perf, I found
that it spends about 30% of
On 19 Sep 2018, at 7:49pm, Roger Cuypers wrote:
> As far as I know it uses journaling with WAL and has a lot of files/tables
> (about 400).
Excuse the low-end questions, but they might help save us a lot of silly
suggestions.
Does SQLite have lots of these open at one time ? If so, does it
I'm trying to optimize a C++ application that uses sqlite 3 for database
access. As far as I know it uses journaling with WAL and has a lot of
files/tables (about 400). Profiling this application with Linux perf, I found
that it spends about 30% of its time inside the rbuFindMaindb function of
Hi Dan and thanks again for your response.
So far, I have heard this from only a single user. Silly Google no
longer seems to produce ARM system images for the emulator so I cannot
test as my computers are all AMD. So I cannot say about that. Wish I
could. I have tried.
Here is the device
--
-- bug1:
select cast(cast(1.7976931348623157e+308 as text) as real); --
1.7976931348623157e+308 is internally formatted as
1.79769313486232e+308 which >then< is bigger than REAL.max_value so it is
parsed as 'Inf'
-- expected: 1.7976931348623157e+308
-- actual output: Inf
--
-- bug2:
select
On 2018-09-19 2:30 PM, Brad Spencer wrote:
Disclaimer: I haven't yet tried this with the pre-release version of
sqlite-3.25.1, but I wanted to report it before the 24 hours of that
release notice expired.
I grabbed https://www.sqlite.org/2018/sqlite-src-3250100.zip and tried
this and result
Disclaimer: I haven't yet tried this with the pre-release version of
sqlite-3.25.1, but I wanted to report it before the 24 hours of that
release notice expired.
In sqlite-3.25.0, the release notes say the following:
"Fix table rename feature so that it also updates references to the
renamed
Dan,
Please don't waste your time on this thread any more at this point. My
last post made me think enough (what a concept!) to look at the
classes.dex in my exported .apk and there is something not right. It is
way too small. So I think something in my build is messed up. That would
explain
Oops. Just sent this from the wrong email account. Sorry for any
duplication.
Hi Dan and thanks again for your response.
So far, I have heard this from only a single user. Silly Google no
longer seems to produce ARM system images for the emulator so I cannot
test as my computers are all AMD.
On 09/19/2018 03:54 AM, David White wrote:
On 09/19/2018 12:18 AM, David White wrote:
I am stuck trying to use the precompiled binaries + Android bindings on
Android 8. Does anyone know how to reach the maintainers for this stuff?
Posting here will work.
I have posted a ticket on the wiki
In tclsqlite.c, function DbMain()... somewhere between 3.19 and 3.23 there was
a re-write of the argument parsing code for the sqlite command, and following
code was removed and not completely replaced with a new equivalent:
if( objc<3 || (objc&1)!=1 ){
Tcl_WrongNumArgs(interp, 1, objv,
Hi
I am trying to put up a little program using System.data.SQLite with C# under
Visual Studio 2017. The Target Framework is dotnet core 2.0
I imported the nuget Package (Project - manage nuget Package ...) into the
Project.
The compilation works fine. But if running the compiled program I get
Hi,
The JSON1 docs at https://www.sqlite.org/json1.html have a minor typo:
Section 4.13. The json_each() and json_tree() table-valued functions
atom ANY, -- value for primitive types, null for array & object
> id INTEGER -- integer ID for this element
> parent INTEGER, -- integer ID for the
Hi List,
When investigating performance of one of our queries I found an interesting
situation that might be an opportunity for performance improvement.
Tested with Sqlite version 3.15.2 (November 2016).
Consider the following table and query
CREATE TABLE Node
(
Id INTEGER
19 matches
Mail list logo