OK, will try that.
sqlite3_release_memory doesn't have the DB connection as an argument, but
found
sqlite3_db_release_memory and that has that as an argument and that may
work better.
RBS
On Thu, Jan 7, 2016 at 6:05 AM, Scott Hess wrote:
> On Wed, Jan 6, 2016 at 3:03 PM, Bart Smissaert
>
In that case - oops. I definitely was experimenting with the db-centric
version. It looks to me like the lowest-level mechanism is similar between
the two, but sqlite3_db_release_memory() isn't optionally compiled.
-scott
On Thu, Jan 7, 2016 at 12:32 AM, Bart Smissaert
wrote:
> OK, will try
> Mensaje original
> De: Eduardo Morras
> Para: sqlite-users at mailinglists.sqlite.org
> Fecha: Mon, 4 Jan 2016 23:27:35 +0100
> Asunto: Re: [sqlite] SQLite remote access over WAN
>
>On Mon, 04 Jan 2016 22:52:56 +0100
>ajm at zator.com wrote:
>
>> Hi list:
>>
>> I've built a
> So you should
see results if you start a transaction, do a few update statements, commit
the transaction, the call sqlite3_release_memory(db).
I tried this with a large table, first with no transaction then with a
transaction
and tried the sqlite3_release_memory directly after the
These are the compile flags of my sqlite3.dll:
compile_option
DEBUG
ENABLE_COLUMN_METADATA
ENABLE_MEMORY_MANAGEMENT
MEMDEBUG
OMIT_LOOKASIDE
THREADSAFE=0
And these are the set pragma's:
PRAGMA cache_size 32768
PRAGMA default_cache_size 32768
I have run the Quick Check. The results are below. This database is written
to once a minute. One minute it was working and the next it was not. What
would cause it to suddenly have errors? This is what I don't understand.
check_callback argc 1 argv <*** in database main ***
On tree page
Hi list,
sorry for the late reply, Christmas holidays :-)
> Am 21.12.2015 um 09:15 schrieb Jan Nijtmans :
>
> 2015-12-19 21:57 GMT+01:00 Jeremy Boy :
>> I would like to use the optional LIMIT and ORDER BY clause for DELETE
>> statements in SQLite. I can verify that SQLite was built with
>>
On 1/7/16, Andrew Stewart wrote:
> I have run the Quick Check. The results are below. This database is
> written to once a minute. One minute it was working and the next it was
> not. What would cause it to suddenly have errors? This is what I don't
> understand.
>
> check_callback argc 1
On 1/7/16, Jeremy Boy wrote:
> How can I verify where SQLite was built
> from?
(1) Get the canonical sources from
https://www.sqlite.org/download.html or https://www.sqlite.org/src
(2) CFLAGS=-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT ./configure
(3) make sqlite3.c
--
D. Richard Hipp
drh at
On 7 Jan 2016, at 3:09pm, Andrew Stewart wrote:
> I have run the Quick Check. The results are below. This database is written
> to once a minute. One minute it was working and the next it was not. What
> would cause it to suddenly have errors?
Hardware fault. Loss of power. Another
I'm trying to get some consistency in the contents of a field in a
table. To do so involves multiple updates using REPLACE.
Is it acceptable to make multiple calls to replace involving the same
field in a single update operation, like so:
UPDATE audio SET
composer = REPLACE( composer, " / ",
On 7 Jan 2016, at 4:49pm, audio muze wrote:
> Is it acceptable to make multiple calls to replace involving the same
> field in a single update operation, like so:
>
> UPDATE audio SET
>composer = REPLACE( composer, " / ", "\\" ),
>composer = REPLACE( composer, " , ", "\\" ),
>
Has anybody had a large file (78gb) on a compressed folder on Windows? I
believe that this is where the problem is coming from and want to find out if
anybody else has any experience with this. I am looking at this file being
1.6TB and was hoping to be able to compress to save some space.
Hello,
I recently looked into FTS 5.
The documentation is clear and I was able to get it running with a small
test database quickly. And the response times are awesome :-)
My question:
At least as I understand it at this point, FTS can only do prefix queries.
If my database contains
I've never used FTS, just throwing an off-the-wall idea out: instead of
tokenising partial words, could you tokenise/store the reverse of each word
(possibly in a separate place if that can be done):
enihsnoom
enihs
enihsnus
Then search for "enihs" as well as "shine". If you can't separate the
On 2016-01-07 19:31, Mario M. Westphal wrote:
> I hence wonder if this problem has been tackled already and if there is a
> "standard" solution.
If I understand you correctly, it seems that you are looking for a
compound splitting or decompounding algorithm. Unfortunately there is
not a
One such algorithm would be a (generalized) Ukkonnen suffix tree
(https://en.m.wikipedia.org/wiki/Ukkonen%27s_algorithm).
It allows you to search efficiently for substrings.
It would be possible to do some match weigthing based on match distance within
words. But a general solution for a
Hmm. I see that sqlite3PcacheReleaseMemory() is a no-op
if sqlite3GlobalConfig.nPage is non-zero, and that happens
when SQLITE_DEFAULT_PCACHE_INITSZ is not zero. If I compile with
-DSQLITE_DEFAULT_PCACHE_INITSZ=0 , then I see the expected pages freed.
AFAICT, it doesn't matter if you make use of
Thanks for that. Will look into this. Looks you might be onto something
there.
RBS
On Thu, Jan 7, 2016 at 11:04 PM, Scott Hess wrote:
> Hmm. I see that sqlite3PcacheReleaseMemory() is a no-op
> if sqlite3GlobalConfig.nPage is non-zero, and that happens
> when SQLITE_DEFAULT_PCACHE_INITSZ is
On Sun, 20 Dec 2015 19:12:39 +0100
Big Stone wrote:
> Best whishes for 2016!
If it's not too late to join the party...
1. create table T (t primary key);
update T set t = t+1;
for consecutive values of t.
2. Specific constraint references in error messages.
3. Correct
At the command line interface (CLI) in SQLite
(and most SQL implementations) is an interpreted
set at a time language with implicit loops.
Efficient low level languages (such as C) process data
a record at a time and the existing API is appropriate
for them.
Object Oriented Interactive Languages
On Jan 7, 2016, at 5:22 PM, Jim Callahan
wrote:
>
> I believe R has remarkably good interface packages for SQLite
That?s the appropriate level: the high-level language's DB access layer should
map the low-level C record-at-a-time API to an appropriate language-level
abstraction.
R almost
On 2016-01-07 4:55 PM, Warren Young wrote:
> 2. There is no ?preview? mechanism. That is, you can?t bind some parameters
> to a prepared query string and then get the resulting SQL because SQLite
> substitutes the values into the query at a layer below the SQL parser. This
> means that if you
I personally wish the reverse. I wish that these interpreted language
engines would incorporate the SQLite code directly into their own existence
to avoid having to write wrappers to begin with, except for those wrappers
where their method name is "DatabaseOpen" and I prefer "OpenDatabase".
On Jan 7, 2016, at 6:04 PM, Darren Duncan wrote:
>
> On 2016-01-07 4:55 PM, Warren Young wrote:
>> 2. There is no ?preview? mechanism.
>
> The current method of binding is correct. All we really need is that the
> debug logging layer include both the SQL of the prepared statement AND a list
Perhaps we misunderstand each other here.
I interpreted your request as if current systems' error outputs at execute time
were printing out the problematic SQL statement with placeholder names as
originally prepared, and you wanted the error outputs to have the placeholders
substituted with
Stephen,
What you are arguing for (no shared libraries) is bad old days where one had to
recompile their programming language to add support for a DBMS, rather than the
DBMS support being a separately installable library that one could choose to
install or not or upgrade semi-independently or
27 matches
Mail list logo
