Re: [sqlite] sqlite3: .width counts bytes, not characters

> 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:

Re: [sqlite] sqlite3: .width counts bytes, not characters

On 3/9/20, Keith Medcalf wrote: >>I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24 >>3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for > > Have you tried version more recent than 4 years and 1 month old? > I think some of these issues may have been fixed in the las

Re: [sqlite] sqlite3: .width counts bytes, not characters

>I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24 >3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for Have you tried version more recent than 4 years and 1 month old? I think some of these issues may have been fixed in the last couple of years. -- The fact that

Re: [sqlite] sqlite3: .width counts bytes, not characters

softw...@quantentunnel.de, on Monday, March 9, 2020 04:02 PM, wrote... > > 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 > Unicod

[sqlite] sqlite3: .width counts bytes, not characters

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

[sqlite] sqlite3 shell .parameter command evaluating arguments when it shouldn't.

Consider: sqlite> .parameter init sqlite> .parameter set :date '2019-11-15' sqlite> .parameter list :date 1993 How do I make it treat the value argument as a string and not as a numeric expression that gets evaluated? ___ sqlite-users mailing list sqlit

[sqlite] sqlite3 doesn't build with -DSQLITE_ENABLE_DBPAGE_VTAB with bitbake

I need sqlite3 to be built with -DSQLITE_ENABLE_DBPAGE_VTAB so that I can use the ".recover" command. The ".dbinfo" command doesn't work either. I add -DSQLITE_ENABLE_DBPAGE_VTAB to the sqlite recipe CFLAGS in various ways but I never get sqlite3 built with the option. Example error: the ".dbinfo

Re: [sqlite] sqlite3 unable to open network db file in readwrite mode

On Wed, 3 Jul 2019 20:48:42 -0500, Lewis Balentine wrote: > *First, version numbers:* > My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface, > Kernel 4.15.0-52 Generic x86_64 > The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user > interface, Kernel 4.4

Re: [sqlite] sqlite3 unable to open network db file in readwrite mode

On 7/3/19, Lewis Balentine wrote: > When I open the file in DB Browser for SQLite I can browse the tables but I > can not change anything. > The error is: "attempt to write a readonly database" Is the directory that contains the database file writable? It needs to be in order to write to the dat

[sqlite] sqlite3 unable to open network db file in readwrite mode

*First, version numbers:* My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface, Kernel 4.15.0-52 Generic x86_64 The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user interface, Kernel 4.4.0-141 Generic x86_64 SQLite Version 3.22.0 DB Browser for SQLite Vers

Re: [sqlite] sqlite3 java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state

On Wed, 1 May 2019 at 19:30, Frank Kemmer wrote: > > https://github.com/xerial/sqlite-jdbc/blob/14839bae0ceedff805f9cda35f5e52db8c4eea88/src/main/java/org/sqlite/core/CoreResultSet.java#L86 > > Here we see, that colsMeta == null results in throwing the seen exception. > > But how can colsMeta be

Re: [sqlite] sqlite3 java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state

I looked into the JDBC driver source code and found the following two code lines mentioned in the stack trace. Sqlline is trying to get the tablename of the resultSet which results in the invocation of: https://github.com/xerial/sqlite-jdbc/blob/77ae7d2ddefe679fd0432eb0858bd8aab104b795/src/main/

Re: [sqlite] sqlite3 java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state

Simon Slavin schrieb am Sa. 27. Apr. 2019 um 14:28: > On 27 Apr 2019, at 10:47am, Frank Kemmer wrote: > > > I can connect to the database, create a table, select from the table, > insert into the table, but the first time I try to read after an insert I > get the following exception: > > >> Are

Re: [sqlite] sqlite3 java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state

On 27 Apr 2019, at 10:47am, Frank Kemmer wrote: > I can connect to the database, create a table, select from the table, insert > into the table, but the first time I try to read after an insert I get the > following exception: Are you checking the result codes from all these operations ? If y

[sqlite] sqlite3 java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state

I am using: - sqlline-1.7.0-jar-with-dependencies.jar - sqlite-jdbc-3.27.2.jar I can connect to the database, create a table, select from the table, insert into the table, but the first time I try to read after an insert I get the following exception: 0: jdbc:sqlite:/maxmin> SELECT * FROM

Re: [sqlite] SQLite3's vulnerability in 3.27.1 and 3.26

I was able to reproduce this behaviour using much shorter query (in sqlite.exe 3.27.1): SELECT + sum(0) OVER() ORDER BY + sum(0) OVER(); SELECT + avg(0) OVER() ORDER BY + avg(0) OVER(); SELECT 1 + avg(0) OVER() ORDER BY 1 + avg(0) OVER(); SELECT - - - - - avg(0) OVER() ORDE

[sqlite] SQLite3's vulnerability in 3.27.1 and 3.26

?SELECT(+++ last_insert_rowid()++sum(0)oVER())ORDER BY (+++ last_insert_rowid()++sum(0)oVER())ORDER BY 1,1,1,1,1,1? Best regards Longfei Fan from 360 Codesafe Team of Legendsec? ___ sqlite-users mailing

Re: [sqlite] Sqlite3: create a database from file using one line command-line script

f kostasvgt >Sent: Wednesday, 6 February, 2019 12:47 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Sqlite3: create a database from file using one line >command-line script > >Hi, I need to run a command to create a database and populate it from >a >.sql file at once

Re: [sqlite] Sqlite3: create a database from file using one line command-line script

sqlite3 myDatabase.db ".read myCommands.sql" On Wed, Feb 6, 2019 at 3:30 PM kostasvgt wrote: > Hi, I need to run a command to create a database and populate it from a > .sql file at once from command-line, not dot-commands. > Is there any way to do this in one line? > > Thanks. >

[sqlite] Sqlite3: create a database from file using one line command-line script

Hi, I need to run a command to create a database and populate it from a .sql file at once from command-line, not dot-commands. Is there any way to do this in one line? Thanks. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mail

Re: [sqlite] Sqlite3 Data Base write failure cases.

Hi Simon Slavin, Thank you for the reply. Yes I am using single thread and single connection. Can you tell me what happen if i try with multiple thread and single connection to write the data (Multiple thread trying to write into DB will it follow the serialization because of the FULLMUTEX and d

Re: [sqlite] Sqlite3 Data Base write failure cases.

On 17 Dec 2018, at 9:01am, Prajeesh Prakash wrote: > What are the possible failure cases of DB write in case of single connection. > Because in my application i needs to handle those cases. Can anyone help me > for the same. You state that you're using a single connection. I will assume your

[sqlite] Sqlite3 Data Base write failure cases.

Hi Team, What are the possible failure cases of DB write in case of single connection. Because in my application i needs to handle those cases. Can anyone help me for the same. Thank you ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] sqlite3 Asynchronous I/O

Dear, > Le 27 nov. 2018 à 10:24, Prajeesh Prakash a > écrit : > > I am using sqlite3 Asynchronous I/O on my application. So is there any way to > get the status of the DB update (After the write operation) from the > asyncWriterThread so that my application can do the proper error handling.

Re: [sqlite] sqlite3 Asynchronous I/O

Yes it is, On sqlite3async.c file i found asyncWriterThread but i didn't find any callback to let the application know the status of the DB update. How this thread writing the data to DB, I am little bit confused. > > On November 27, 2018 at 3:12 PM Shawn Wagner > wrote: > > By async

Re: [sqlite] sqlite3 Asynchronous I/O

Yes it is. > > On November 27, 2018 at 3:12 PM Shawn Wagner > wrote:es > > By asynchronous i/o, do you mean the vfs module described here: > https://www.sqlite.org/asyncvfs.html ? > > On Tue, Nov 27, 2018, 1:24 AM Prajeesh Prakash > > > > > > Hi Members,

Re: [sqlite] sqlite3 Asynchronous I/O

By asynchronous i/o, do you mean the vfs module described here: https://www.sqlite.org/asyncvfs.html ? On Tue, Nov 27, 2018, 1:24 AM Prajeesh Prakash Hi Members, > > I am using sqlite3 Asynchronous I/O on my application. So is there any way > to get the status of the DB update (After the write op

[sqlite] sqlite3 Asynchronous I/O

Hi Members, I am using sqlite3 Asynchronous I/O on my application. So is there any way to get the status of the DB update (After the write operation) from the asyncWriterThread so that my application can do the proper error handling. I am expecting a reply. Thank you Prajeesh P _

Re: [sqlite] SQLite3 with C

Hi Ricardo, On 15 August 2018 at 06:26, Ricardo Lima wrote: > I built a straightforward program in C. It's just a STACK structure (first > in, last out) that takes input from the user and stores it into the stack. > After I close the program, all the data vanishes since I don't have a > databa

Re: [sqlite] SQLite3 with C

On 15 Aug 2018, at 6:26am, Ricardo Lima wrote: > I don't get any compilation errors and the SQLite source files/header files > are implemented correctly into the code. I know this because I'm using SQLite > Studio ( SQLite GUI) and I see all the attributes from the wallet DB, but > they are al

[sqlite] SQLite3 with C

I built a straightforward program in C. It's just a STACK structure (first in, last out) that takes input from the user and stores it into the stack. After I close the program, all the data vanishes since I don't have a database implemented into the program. Even so, the program runs fine. It al

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

Some ideas: Sqlite may return that the database is locked immediately if it detects a deadlock situation. Something like: a different connection holds a reserved lock (waiting for read connections to close so it can promote to exclusive), and the current connection tries to promote from a read

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

On 3 Jul 2018, at 8:08pm, Phani Rahul Sivalenka wrote: > As per our observation, the initial write operations on the sqlite db file > throw "db is locked" error. After a certain time (around an hour) write > operations start working and we are able to do all the operations as > required. [...]

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

As per our observation, the initial write operations on the sqlite db file throw "db is locked" error. After a certain time (around an hour) write operations start working and we are able to do all the operations as required. On Mon, Jun 25, 2018 at 7:37 PM Phani Rahul Sivalenka wrote: > > SQLit

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

> SQLiteConnectionStringBuilder connBuilder = new > SQLiteConnectionStringBuilder(); We are setting these configs via the connection string in xml. This is same as the above. The following is the connection string that we are using: “data source=/var/www/html/ChargerDatabase.db;DateTimeKind=Ut

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

On 21 Jun 2018, at 10:01pm, Phani Rahul Sivalenka wrote: > When we do a read operation and write/update operation on the SQLite DB, > the write operation gets timed out saying the “db is locked”. [...] > - Busy Timeout : 30sec > - Default Timeout : 30sec I'm going to assume you're doing s

[sqlite] [SQLite3] [Mono] [Linux] "db is locked"

Hello, We have an ASP.NET Web application running with Mono on Linux. Uses System.Data.SQLite library with an interop generated with a specific set configuration to interact with the SQLite file. When we do a read operation and write/update operation on the SQLite DB, the write operation gets tim

Re: [sqlite] SQLite3 fossil repository not working ?

On Tue 08 May 2018 9:32 AM, Domingo Alvarez Duarte wrote: > Hello ! > > Today I tried to update my sqlite3 repository but somehow it seems not > working properly, I execute "fossil update" as usually and it contacts the > server and exchange info with it but it only see till this commit > http://

Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

On Tue, May 8, 2018 at 2:11 PM, Richard Hipp wrote: > On 5/8/18, Francis Kus wrote: > > I am able to open my database file if the path contains no accents. > However, > > if I change even one letter to an accented letter (e.g. replace 'e' with > > 'é'), the database does not open and I get the e

Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

On 5/8/18, Francis Kus wrote: > I am able to open my database file if the path contains no accents. However, > if I change even one letter to an accented letter (e.g. replace 'e' with > 'é'), the database does not open and I get the error message "unable to open > database file". The argument to

[sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

Hi, I am experiencing the following issue using SQLite 3.22.0: I am able to open my database file if the path contains no accents. However, if I change even one letter to an accented letter (e.g. replace 'e' with 'é'), the database does not open and I get the error message "unable to open dat

Re: [sqlite] SQLite3 fossil repository problem solved

On 5/8/18, Domingo Alvarez Duarte wrote: > > Still it seems that there is more than one fossil server and they seem > to lag from the main one. > There are three. They sync with each other hourly, via cron job. -- D. Richard Hipp d...@sqlite.org ___

[sqlite] SQLite3 fossil repository problem solved

Hello ! I just retried again and now it got updated to the same content I can see on the web. Still it seems that there is more than one fossil server and they seem to lag from the main one. Cheers ! ___ sqlite-users mailing list sqlite-users@m

[sqlite] SQLite3 fossil repository not working ?

Hello ! Today I tried to update my sqlite3 repository but somehow it seems not working properly, I execute "fossil update" as usually and it contacts the server and exchange info with it but it only see till this commit http://www.sqlite.org/src/info/c381f0ea57002a264fd958b28e . There is mor

[sqlite] sqlite3 not support write and read at the same time?

HI every one i use sqlite3 3.22.0 verison on embeded arm9 system when i insert a lot of data like this begin_transaction sqlite3_prepare_v2(); for(i = 0;i<2040;i++) { sqlite3_bind_text(); sqlite3_bind_blob(); sqlite3_step(); sqlite3_reset(); sqlite3_clear_bindings(); } sqlite3_finalize(s

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

nd are not >> zero-terminated. >> >> --- >> The fact that there's a Highway to Hell but only a Stairway to Heaven >> says a lot about anticipated traffic volume. >> >> >> >-Original Message- >> >From: sqlite-users

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

olume. > > > >-----Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of J Decker > >Sent: Thursday, 19 April, 2018 16:41 > >To: SQLite mailing list > >Subject: Re: [sqlite] SQLite3 - Search on te

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

nticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of J Decker >Sent: Thursday, 19 April, 2018 16:41 >To: SQLite mailing list >Subject: Re: [sqlite] SQLite3 - Search on text field with \0 bi

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

On Thu, Apr 19, 2018 at 3:37 PM, J Decker wrote: > > > On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf > wrote: > >> >> Actually, nothing in the C or C++ world will "go past" the NULL byte >> since the very definition of a C string is a "bunch-o-bytes that are >> non-zero followed by one that is"

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf wrote: > > Actually, nothing in the C or C++ world will "go past" the NULL byte since > the very definition of a C string is a "bunch-o-bytes that are non-zero > followed by one that is". > > that doesnt' mean you can use a custom token structure tha

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

re's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of J Decker >Sent: Thursday, 19 April, 2018 14:09 >To: SQLite mail

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

ite-users-boun...@mailinglists.sqlite.org] > On Behalf Of MARCHAND Loïc > Sent: Thursday, April 19, 2018 8:27 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] SQLite3 - Search on text field with \0 binary data > > I index a file in a SQLite DB. > I create m

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

te.org] On Behalf Of MARCHAND Loïc Sent: Thursday, April 19, 2018 8:27 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] SQLite3 - Search on text field with \0 binary data I index a file in a SQLite DB. I create my table with this: CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRI

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

On 19 Apr 2018, at 1:27pm, MARCHAND Loïc wrote: > CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRIMARY KEY (RecordID)) > > I read a file, and for each line I add a row on the table. Each line can have > binary data at end. It's not a problem for many chars, but \0 char make a > problem. > I

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

are you testing this in the sqlite3 shell or in your own program? You should have no issue getting thisdata, sqlite3_column_text followed by sqlite3_column_bytes (the byte count is set when the data is fetched in some format). without modification, you can either excape \0 with'||char(0)||'

[sqlite] SQLite3 - Search on text field with \0 binary data

I index a file in a SQLite DB. I create my table with this: CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRIMARY KEY (RecordID)) I read a file, and for each line I add a row on the table. Each line can have binary data at end. It's not a problem for many chars, but \0 char make a problem. If

Re: [sqlite] SQLITE3 FTS5 prefix query get mismatch result

On 03/20/2018 02:31 PM, zheng xiaojin wrote: (I am not sure whether you have seen my message, so resend again) Hi, When I use FTS5, I have met that, there are some cases which will get mis-match results with prefix search. Like "select * from tbl_fts where tbl_fts match 'lucy*';"，which I want t

[sqlite] SQLITE3 FTS5 prefix query get mismatch result

(I am not sure whether you have seen my message, so resend again) Hi, When I use FTS5, I have met that, there are some cases which will get mis-match results with prefix search. Like "select * from tbl_fts where tbl_fts match 'lucy*';"，which I want to get records like "lucya","lucyabc" etc, and

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

Dan Kennedy wrote: > To: SQLite mailing list , I didn't get your mail because I am not subscribed and was not CCed. > In frame 0 of thread 1, what do the following gdb commands say? > >print *pCache >print *pPage I can't provide that easily because of package upgrades. However, I got

[sqlite] sqlite3 3220000 does not build with -DSQLITE_OMIT_AUTHORIZATION

Hi all, last sqlite 322 does not build with -DSQLITE_OMIT_AUTHORIZATION because shell.c in sqlite3_expert_new use it. I suggest the next patch to solve the problem. Regards diff --git a/shell.c b/shell.c --- a/shell.c +++ b/shell.c @@ -7702,7 +7702,9 @@ sqlite3expert *sqlite3_expert_new(

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

On 12/23/2017 08:41 AM, Paul Wise wrote: On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote: Nevertheless, we will investigate from the SQLite side, just in case. If you need any information from the core dump, please let me know which gdb commands to run. I still have one available from th

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote: > Nevertheless, we will investigate from the SQLite side, > just in case. If you need any information from the core dump, please let me know which gdb commands to run. I still have one available from the latest crash and have marked it immuta

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote: > There are no known issues like this with any recent version of SQLite. > Usually these kinds of things end up being heap corruption in the > application. Nevertheless, we will investigate from the SQLite side, > just in case. I see, thanks

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

On 12/22/17, Paul Wise wrote: > Hi all, > > I got a couple of random crashes GNOME's tracker-store daemon that > appear to be related to sqlite3. I use 3.21.0-1 from Debian buster. > > Is this a bug in sqlite3 or is it caused by data corruption? > There are no known issues like this with any rece

[sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

Hi all, I got a couple of random crashes GNOME's tracker-store daemon that appear to be related to sqlite3. I use 3.21.0-1 from Debian buster. https://bugzilla.gnome.org/show_bug.cgi?id=791243 The short backtraces are available here: https://bugzilla.gnome.org/page.cgi?id=traceparser/trace.html

Re: [sqlite] SQLite3 on WinCE platform

>From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On >Behalf Of Simon Slavin >Sent: Monday, December 11, 2017 12:50 PM >To: SQLite mailing list >Subject: Re: [sqlite] SQLite3 on WinCE platform > >On 11 Dec 2017, at 8:59am, Ertan Küçükoğlu wrote: &g

Re: [sqlite] SQLite3 on WinCE platform

On 11 Dec 2017, at 8:59am, Ertan Küçükoğlu wrote: > Error I am getting when application runs is: EInOutError: Can not load > SQLite client library "sqlite3ce.dll". Check your installation. Given this page "EInOutError is ra

[sqlite] SQLite3 on WinCE platform

Hello, I am using SQLite3 on handheld barcode scanners. Development platform of my choice is Lazarus (free pascal). These handheld devices run WinCE operating system. I have found a sqlite3ce.dll which I have downloaded from Lazarus forums. That DLL is version 3.9.2.0 compiled for WinCE 5+ (armv4

Re: [sqlite] SQLite3 on Windows

On Sat, Oct 14, 2017 at 10:47 PM, Phoenix wrote: > Dominique wrote: > Not to sound too snarky, but both questions can easily be answered > through experimentation. > You can also use http://www.dependencywalker.com/ to inspect DLL and > EXE dependencies. --DD > > It's a bit difficult to d

Re: [sqlite] SQLite3 on Windows

Sorry I have not responded to the raised questions on this post but I have not received any Digests since the 8th (Volume 118 Issue 8). Dominique wrote: Not to sound too snarky, but both questions can easily be answered through experimentation. You can also use http://www.dependencywalke

Re: [sqlite] SQLite3 on Windows

err.. that should be Embarcadero 10.1 Berlin... ugh.. PROOFREAD!!! On Tue, Oct 10, 2017 at 4:20 PM, Stephen Chrzanowski wrote: > > Based purely on my experience with Delphi (From Borland Version 5 to > Emarcadero 10.5 Berlin); > ___ sqlite-users mailin

Re: [sqlite] SQLite3 on Windows

1> Standalone 2.a> If you're referring to the DLL from an application you're building, it must be either the Path, or, in the "Directory" your shortcut points to, which is either something custom, or, the EXEs current directory. Its already been mentioned where that DLL should be placed. 2.b> If y

Re: [sqlite] SQLite3 on Windows

ously you need to be careful where you put them of use the default > System directories. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message- > >From: sqlite

Re: [sqlite] SQLite3 on Windows

riginal Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Warren Young >Sent: Tuesday, 10 October, 2017 08:57 >To: SQLite mailing list >Subject: Re: [sqlite] SQLite3 on Windows > >On Oct 10, 2017, at 3:49 AM, Phoenix >wrote: >> >&g

Re: [sqlite] SQLite3 on Windows

On Oct 10, 2017, at 3:49 AM, Phoenix wrote: > > 2) Does the .dll need to be in a specific folder or is it okay if the > folder is listed in my PATH? https://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx ___ sqlite-users maili

Re: [sqlite] SQLite3 on Windows

On Tue, Oct 10, 2017 at 11:49 AM, Phoenix wrote: > I've downloaded the dll-win32 version of SQLite3 and have a couple of > questions. > > 1) Does sqlite3.exe require the .dll file or is it stand-alone? > > 2) Does the .dll need to be in a specific folder or is it okay if the > folder is listed in

[sqlite] SQLite3 on Windows

I've downloaded the dll-win32 version of SQLite3 and have a couple of questions. 1) Does sqlite3.exe require the .dll file or is it stand-alone? 2) Does the .dll need to be in a specific folder or is it okay if the folder is listed in my PATH? ___ sqlit

Re: [sqlite] Sqlite3 Multi-process handling with continuous begin and commit in one thread cause error for other thread sqlite3_exec.

On 10/4/17, Hegde, Deepakakumar (D.) wrote: > > > 1) Open the Database in the two process > > 2) Both the link are added the busy handler and busy handler function is > retries for 1 times with 10ms second of delay. > > 3) In one thread there is a continuous record insertion with begin and > c

Re: [sqlite] Sqlite3 Multi-process handling with continuous begin and commit in one thread cause error for other thread sqlite3_exec.

October 5, 2017 8:00:31 AM To: SQLite mailing list Subject: Re: [sqlite] Sqlite3 Multi-process handling with continuous begin and commit in one thread cause error for other thread sqlite3_exec. On 5 Oct 2017, at 3:17am, Hegde, Deepakakumar (D.) wrote: > 2) Both the link are added the busy han

Re: [sqlite] Sqlite3 Multi-process handling with continuous begin and commit in one thread cause error for other thread sqlite3_exec.

On 5 Oct 2017, at 3:17am, Hegde, Deepakakumar (D.) wrote: > 2) Both the link are added the busy handler and busy handler function is > retries for 1 times with 10ms second of delay. > sqlite3_busy_handler(psRaceSqlite->sSqliteInfo.pSqlHandle, > dbm_sqlite_busy_handler,psRaceSql

Re: [sqlite] Sqlite3 Multi-process handling with continuous begin and commit in one thread cause error for other thread sqlite3_exec.

On 10/4/2017 10:17 PM, Hegde, Deepakakumar (D.) wrote: There is a problem we are facing with the multiple DB process write operation. Following the procedure: 1) Open the Database in the two process as: sqlite3_open_v2 (pcDbName, &psRaceSqlite->sSqliteInfo.pSqlHandle, (SQLITE_OPEN_R

[sqlite] Sqlite3 Multi-process handling with continuous begin and commit in one thread cause error for other thread sqlite3_exec.

Hi All, There is a problem we are facing with the multiple DB process write operation. Following the procedure: 1) Open the Database in the two process as: sqlite3_open_v2 (pcDbName, &psRaceSqlite->sSqliteInfo.pSqlHandle, (SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_FUL

Re: [sqlite] sqlite3 interactive shell failed assertions and segmentation faults

Thanks for the report. Thanks to Simon for verifying that these are all associated with the command-line shell only and not with the SQLite core. Note to Ryan: Please make sure your fuzzer is running inside a sandbox, in case the fuzzer discovers pernicious dot-commands like ".sy rm -rf ~" On

Re: [sqlite] sqlite3 interactive shell failed assertions and segmentation faults

On 24 Jun 2017, at 2:29am, Ryan Whitworth wrote: > GDB backtrace details and input files can be found here: > https://github.com/rwhitworth/sqlite-fuzz/tree/master/2017-06-23-sqlite3. For those interested, all the faults found seem to concern dot commands. Here is an example command which wa

[sqlite] sqlite3 interactive shell failed assertions and segmentation faults

Hello all, I was using American Fuzzy Lop (afl-fuzz) to fuzz test stdin to the sqlite3 interactive shell. AFL found a few inputs that cause segmentation faults (mostly due to failed assertions, I think?). Is this sort of thing worth investigating further or a non-issue? GDB backtrace details an

Re: [sqlite] SQLite3.Step fast forward / skipping rows

Like this it works. OK, building the temporary table takes some seconds with a table of 10 mio records, but the queries are really fast then, 10 to 30 ms!! Thanks so much guys for helping me with this :) Tom Am 24.05.2017 um 18:42 schrieb Keith Medcalf: On Wednesday, 24 May, 2017 07:21

Re: [sqlite] SQLite3.Step fast forward / skipping rows

On Wednesday, 24 May, 2017 07:21 > > there is no system in existence that will do > I was working a lot with Valentina-DB and they have a cursor class: > > var cursor=database.SqlSelect( "SELECT... WHERE... ORDER..."); > > then you can just get any the ListView wants, forward and backwards, ve

Re: [sqlite] SQLite3.Step fast forward / skipping rows

n all the columns that you can sort by. Andy Ling -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping row

Re: [sqlite] SQLite3.Step fast forward / skipping rows

On 5/24/17, Thomas Flemming wrote: > Hi Ron, > > > there is no system in existence that will do > I was working a lot with Valentina-DB and they have a cursor class: > > var cursor=database.SqlSelect( "SELECT... WHERE... ORDER..."); > > then you can just get any the ListView wants, forward and b

Re: [sqlite] SQLite3.Step fast forward / skipping rows

Behalf Of Thomas Flemming Sent: Wed 24 May 2017 14:21 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Hi Ron, > there is no system in existence that will do I was working a lot with Valentina-DB and they have a cursor class: var cursor

Re: [sqlite] SQLite3.Step fast forward / skipping rows

ort by. Andy Ling -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to

Re: [sqlite] SQLite3.Step fast forward / skipping rows

lf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then the use case of fast scrolling down in a listbox would be going directly to page

Re: [sqlite] SQLite3.Step fast forward / skipping rows

I might be wrong, but to me this sounds like an application coding problem to do with your listview. You will need to code in such a way that the listview doesn't get updated when it doesn' t have to. Does the data come directly from the DB or is there an intermediate eg an array? RBS On Wed, Ma

Re: [sqlite] SQLite3.Step fast forward / skipping rows

:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then the use case of fast scrolling down

Re: [sqlite] SQLite3.Step fast forward / skipping rows

age of results. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Thomas Flemming Gesendet: Mittwoch, 24. Mai 2017 10:09 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] SQLite3.Step fast forward / skipping rows Hi

Re: [sqlite] SQLite3.Step fast forward / skipping rows

Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory,

Re: [sqlite] SQLite3.Step fast forward / skipping rows

y, 2017 02:09 To:sqlite-users@mailinglists.sqlite.org Subject: [sqlite] SQLite3.Step fast forward / skipping rows Hi SQLite Users, I have a SELECT query, which returns some 10 records and is displayed in a scrollable ListView. When the user scrolls down the list, each new row is loaded with SQLite3.Step().

Re: [sqlite] SQLite3.Step fast forward / skipping rows

ey for the list? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Thomas Flemming > Sent: Wednesday, 24 May, 2017 02:09 > To: sqlite-users@mailinglists

[sqlite] SQLite3.Step fast forward / skipping rows

Hi SQLite Users, I have a SELECT query, which returns some 10 records and is displayed in a scrollable ListView. When the user scrolls down the list, each new row is loaded with SQLite3.Step(). The problem is, when the user scrolls fast with the scroll-slider, lots of rows are skipped,

[sqlite] Sqlite3 CLI enhancement request

While checking something else I came across this. SQLite version 3.16.0 2016-11-04 19:09:39 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> PRAGMA foreign_keys = ON; sqlite> PRAGMA foreign_keys; 1 sqlite>

  1   2   3   4   5   6   7   8   9   10   >