> I think the enhancement is here:
> https://sqlite.org/src/timeline?c=ed0842c156ab1a78
>
> That would correspond to version 3.20.0.
>
> --
> D. Richard Hipp
Thank you. The upcoming Ubuntu LTS release (20.04) includes sqlite version
3.31.1, so the issue should disappear soon also for me.
@Keith:
Hi
I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24
3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for formatted
output. '.width' does not behave as I expected when non-ASCII Unicode
characters are printed. It seems that .width counts bytes and not characters.
S
Dear Igor, Andy, Keith
Thank you for your patience to explain. Now very clear to me why it is not
worth for the second process to honor the sqlite_busy handler, and instead
returns immediately. In retrospect re-reading with your explanations in mind, I
also understand the official documentation
Hi
A busy_timout is honored by write commands outside of transactions and by
single write commands inside transactions, but not if preceded by a read
command. I did not find this behaviour in the documentation, thus it might be a
bug.
To reproduce (in a linux terminal):
sqlite3 ~/test.db "C
> Dear colleagues
>
> I detected an unexpected behaviour in sqlite3 (CLI) that I consider a bug as
> it seems not documented.
>
> When using an init file (even if an empty file), sqlite3 outputs an extra
> empty line to stdout. This messes up parsing of the sqlite3 output, as this
> line is
Dear colleagues
I detected an unexpected behaviour in sqlite3 (CLI) that I consider a bug as it
seems not documented.
When using an init file (even if an empty file), sqlite3 outputs an extra empty
line to stdout. This messes up parsing of the sqlite3 output, as this line is
not present in the
(Ibtech-Software Infrastructure) wrote:
> CREATE TABLE InstanceReferences (InstanceAddress INTEGER, RefByAddress
> INTEGER) CREATE TABLE Instances (TypeId INTEGER, Address INTEGER)
> CREATE TABLE Types (Id INTEGER, Name TEXT, MethodTable INTEGER, Count
> INT, TotalSize INTEGER)
>
> Wha
Hello there,
I am trying to find a memory leak with MemoScope.
It is using sqllite.
Memoscope has some issue to find the problem so I am actually querying the data.
CREATE TABLE InstanceReferences (InstanceAddress INTEGER, RefByAddress INTEGER)
CREATE TABLE Instances (TypeId INTEGER, Address INTE
Hi,
> I also did another experiment. I created this table and did a vaccum and then
> the select count(*) in sqlite3 was around 2 mins.
>
> When I create an index manually after the table is loaded (imported from
> csv), select count(*) in sqlite3 was within 30 to 40 secs.
>In the second case
Hello,
My Process.csv is around 27G. I've gzipped it and put at
ftp://navinps:sqlit...@h2.usa.hp.com as process.csv.gz
There is only 1 file there.
md5sum process.csv.gz
e77a322744a26d4c8a1ad4d61a84ee72 process.csv.gz
[root@centosnavin sqlite-autoconf-3080801]# cat sqlite3commands.txt
CREATE
Repost: Since it didn't get into the archives or in the mailing list. Sorry
about that.
Quoted and replied to simon after [Repost End]
Hello,
[Repost Begin]
My Process.csv is around 27G. I've gzipped it and put at
ftp://navinps:sqlit...@h2.usa.hp.com as process.csv.gz
There is only 1 file
Hello,
I've few questions about sqlite3 , the database it creates. Actually I'm
finding lot of differences in performance.
My story:
I have this sqlite3 database called hp.db which is like 100+ million
records for table1. The size of hp.db on Linux x64 (CentOS 7) is like 16 GB.
Wh
Joe,
Bingo !!! You are a legend ! This fixes the issue.
After a careful code review, we found that sqlite3_shutdown() was being
called in between. Then naturally, that is why when we reached to a stage
where the big query in question is executed, because the temp store setting
was not in effect,
Hi Joe,
Answers below.
Is the directory obtained via the
Windows::Storage::ApplicationData::Current->LocalFolder->Path property?
> Yes
What SQLite warning/error log entries are you seeing when you set the
temporary directory to the LocalState directory?
> Nothing. sqlite returns success w
Joe,
Yes to both questions (we are checking the result and it is returning
SQLITE_OK, and we are passing a UTF-16 string).
MB
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Friday, 28 March 2014 11:54 AM
database)
onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1
On 27 Mar 2014, at 4:00am, Muharrem Bilgin (Bright Software)
wrote:
> The blob issue mentioned is happening with another table in another
> application. The reason it was mentioned because we have the feeling
Joe,
Tried using the suggested " int sqlite3_win32_set_directory(DWORD type,
LPCWSTR zValue);" before opening any database connection. sqlite still
reports " sqlite3_temp_directory variable should be set for WinRT".
We are trying to set the Windows RT's sandbox local directory of the
application
when querying large (!) result sets using 3.8.4.1
On Wed, Mar 26, 2014 at 8:13 PM, Muharrem Bilgin (Bright Software) <
mbil...@brightsoft.com.au> wrote:
>
> FROM PRD_DETAILS
>
>
As a work-around, please try changing this line of your query to read:
FROM PRD_DETAILS INDEXED BY sqlit
Discussion of SQLite Database
Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database)
onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1
On Wed, Mar 26, 2014 at 10:26 PM, Richard Hipp wrote:
>
>
>
> On Wed, Mar 26, 2014 at 10:21 PM, Muharrem Bilgin (Bri
)
onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1
On Wed, Mar 26, 2014 at 9:47 PM, Muharrem Bilgin (Bright Software) <
mbil...@brightsoft.com.au> wrote:
> Hi Joe,
>
> The following are the log entries, which confirm your suspicion (the
> log entry format : time,
Hi Joe,
The following are the log entries, which confirm your suspicion (the log
entry format : time, error description, error code).
As suggested, we are already setting the temp store directory as soon as a
database connection is opened (after sqlite3_open16). Now, the question is
when to use
Hi Joe,
Thank you for your input. We are not using the SQLite wrapper. The sqlite
source code is compiled into a Windows Store/Phone DLL and used in our
application.
I have tried your suggestion anyway, but no result.
MB.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto
Hello,
We are trying to query a table with 7011 records (simply first calling
sqlite3_prepare16_v2 and then sqlite3_step, nothing complicated that is). It
appears sqlite3_step returns SQLITE_ERROR if result sets contain records
more than a certain size. The very 3.8.4.1 version on Windows deskt
Hi.
I'm using this wonderful library with no problem till today. I've this simple
query
SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA,
COM_STRADARIO.NOME_VIA FROMCOM_STRADARIO inner join INT_CONDOMINI on
COM_STRADARIO.ID_STRADARIO = INT_CONDOMINI.ID_STRADARIO ORDER
time (naturally).
So it seems it must be something about their particular machine
environment, but what? I'm sure that nobody is running out of disk space
these days. Any ideas on where to look or what to suggest to them that
they can do?
--
Doug Gordon
*GHCS Software*
http://ww
With Roger's help I have gotten to the bottom of this issue, and I
wanted to post the resolution to the list in case anyone else bumps
into it.
There is a bug in PHP versions prior to PHP 5.3 that makes it
impossible to reliably create/store BLOB columns. My code ends up
creating TEXT data when ru
NED MESSAGE-
> Hash: SHA1
>
> On 10/27/2010 11:48 AM, Art Age Software wrote:
>> New to this list and hoping someone can help. I have a sqlite3
>> database that contains a couple of tables that have binary data in
>> BLOB columns.
>
> Note that there is column aff
Hi All,
New to this list and hoping someone can help. I have a sqlite3
database that contains a couple of tables that have binary data in
BLOB columns. I know the data is in there and stored correctly because
the application accessing the database can retrieve the column data
just fine.
The probl
ep 24, 2010 at 4:16 PM, GHCS Software wrote:
> > ?I'm just started with generating a table using FTS3 and understand
> > most of the query formats, but am stuck on one minor point of syntax. My
> > FTS3 query will make reference to a specific table, e.g.:
> >
> >
to specify it if the string
to be searched for has a space in it. I've tried several varieties of
quotes without any success, e.g.:
MATCH '"given:john q"'
MATCH 'given:"john q"'
and so on. Is there a way to get this to work?
--
Doug Gordon
Thanks. That took care of it. I'm revamping a Windows app that I wrote 6
or 7 years ago and that was the last time I used Visual C++ for much of
anything. I just wasn't sure about mixing C and C++ code in a single build.
Doug Gordon
*GHCS Software*
<http://www.ghcssoftware.co
pp" and put the include of
at the top? Or what??
--
Doug Gordon
*GHCS Software*
http://www.ghcssoftware.com
g...@ghcssoftware.com <mailto:g...@ghcssoftware.com>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
Does anyone run sqlite3 in an OnTime real time operating system?
Massimo Dazzan
www.schnell.it
Le informazioni trasmesse sono destinate esclusivamente alla persona o alla
societa' in indirizzo e sono da intendersi confidenziali e riservate. Ogni
trasmissione, inoltro, diffusione o a
t; far more than reading it using the SQLite library. More time-
> consuming, though.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
M
only.
--
With kindly regards,
Marcus Haßmann
--
Hassmann-Software
In der Pottaschdell 31
66333 Völklingen
ICQ: 192 982 963
Tel.: 06898 / 49 32 30
Mobil: 0176 / 400 53 54 5
Email: i...@hassmann-software.de
Web: http://www.hassmann-software.de
XING: http://www.xing.com/profile/Marcus_Has
Hello,
Will "pragma integrity_check" also check attached databases?
Best regards
Baard Riiber
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I have an application that needs to open a database in the users's personal
folder. I noticed that in some circunstances the sqlite3_open fail as the
filename is in UTF16 format. I don't know that in advance so I could open
the db with sqlite3_open16.
The question is:
Is it safe to always us
37 matches
Mail list logo