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:

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 f

[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] Question about floating point

the bullet and store everything as integers, in which case I will use the same approach for the other databases as well. Simon Slavin says ‘Currency amounts should be stored as integers’. Does this apply to sqlite3 specifically, or is that your recommendation for all databases? T

Re: [sqlite] Question about floating point

On Dec 15, 2018, at 08.58, Jay Kreibich wrote: > > > On Dec 15, 2018, at 12:49 AM, Frank Millman wrote: > > > > I know that floating point is not precise and not suitable for financial > > uses. Even so, I am curious about the following - > > [...] > >

[sqlite] Question about floating point

;select sum(amount_cust) from ar_trans where cust_row_id = 4 >>> and tran_date between '2015-05-01' and '2015-05-31'") >>> cur.fetchone() (211496.252,) With the same version of sqlite3 and the same select statement, why does python return a different result from sqlite3

Re: [sqlite] __gnu_strerror_r undefined when building for android api-24, no issue with api-22

L.S. Op vrijdag 13 april 2018 12:18:52 CEST schreef Frank van Vugt: > Probably the unified headers in NDK are to blame as well, but: > * when using ndk r16b to build sqlite for api-24 then the resulting library > has __gnu_strerror_r unresolved Oh, one addition: the toolchain used has b

[sqlite] __gnu_strerror_r undefined when building for android api-24, no issue with api-22

parts in sqlite.c can be found by looking for strerror_r Obviously it'd be nice to be able to build and use sqlite in serialized mode for Android api-24 and up 'just like that' ;) -- Best, Frank. ___ sqlite-users mailing list sqlite-users@mailing

Re: [sqlite] Database is locked

On 2/28/18 3:18 PM, Frank Millman wrote: > > On 2/28/18 2:53 PM, Richard Damon wrote: > > > > > On 2/28/18 6:59 AM, Frank Millman wrote: > > > Hi all > > > > > > I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message > >

Re: [sqlite] Database is locked

On 2/28/18 2:53 PM, Richard Damon wrote: > > On 2/28/18 6:59 AM, Frank Millman wrote: > > Hi all > > > > I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message > > ‘database is locked’ which, from reading the docs, I think is coming from > >

[sqlite] Database is locked

, then the connection which did *not* hold the lock fails with ‘database is locked’, and the connection which *did* hold the lock completes normally. Is there any way to get the behaviour that I am looking for? Thanks Frank Millman ___ sqlite-users mailing

Re: [sqlite] Running query in command window is slow

Richard Hipp wrote: On 9/22/17, Frank Millman <fr...@chagford.com> wrote: > > I see that Python is using Sqlite3 3.14.2. > > What version of the command-line shell are you using? It would be a problem > if the command-line shell is a later version and yet is running slower

Re: [sqlite] Running query in command window is slow

Clemens Ladisch wrote: > > > Frank Millman wrote: > > I have a fairly complex query. If I execute it using Python, it takes > > 1 second. If I copy and paste it into the Sqlite3 command window, it > > takes 10 minutes. > > Probably different SQLite versions. &g

[sqlite] Running query in command window is slow

, it seems odd. Can anyone suggest a reason for this? Thanks Frank Millman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Selecting data from WITH clause is very slow

rs_table.id AND > i_current.invoice_date > date_2 AND > i_current.invoice_date <= date_1 > > I should also mention for completeness the need for: > > GROUP BY > acc_no, > acc_name > > ORDER BY > ..

Re: [sqlite] Selecting data from WITH clause is very slow

Clemens Ladisch wrote: > Frank Millman wrote: > > I changed it to use a WITH clause to make one scan of the invoice table and > > store the results. > The WITH clause itself does not store anything; it's syntactic sugar [...] To > force the ageing results to be stored,

[sqlite] Selecting data from WITH clause is very slow

but 3.5 seconds seems a long time to extract the data from 60 rows. Is there any way to speed this up? Frank Millman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with CASE in WHERE clause

ting true and false is merely cosmetic. > So if I understand correctly, it makes sense to use ‘1’/’0’ to *set* the boolean value in a cross-database manner, but there are a variety of ways to test for it. Frank ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Problem with CASE in WHERE clause

inv’, 100, 1)] 4) SELECT * FROM TEST WHERE CASE WHEN tran_type = ‘inv’ THEN posted END = ‘1’; [] In 3) and 4), the WHEN clause evaluates to true, so I expected it to treat 1 and ‘1’ identically, the same way as it does in 1) and 2). Not important, just curious. Frank P.S. Here is the rea

Re: [sqlite] Problem with CASE in WHERE clause

From: Simon Slavin Sent: Sunday, December 04, 2016 10:26 AM To: SQLite mailing list Subject: Re: [sqlite] Problem with CASE in WHERE clause > On 4 Dec 2016, at 6:55am, Frank Millman <fr...@chagford.com> wrote: > > > If a column contains a ‘1’, I would expect sqlite3 t

Re: [sqlite] Problem with CASE in WHERE clause

ug, then I am happy to wait for a fix. If it is just the way sqlite3 works, a bit of an explanation would help, as that could assist me in finding a workaround. Frank ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists

[sqlite] Problem with CASE in WHERE clause

and cross-database, and PostgreSQL does not accept an integer for a BOOL column. I am using version 3.14.2 on Windows 10. Any suggestions? Thanks Frank Millman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

[sqlite] Problem with accumulating decimal values

From: Frank Millman Sent: Friday, December 11, 2015 4:21 PM To: sqlite-users at mailinglists.sqlite.org Subject: [sqlite] Problem with accumulating decimal values > Hi all > > I am having a problem accumulating decimal values. > > I am actually using Python, but

[sqlite] Problem with accumulating decimal values

; SELECT bal FROM fmtemp; 5925.599 sqlite> UPDATE fmtemp SET balance = balance + 123.45; sqlite> SELECT bal FROM fmtemp; 6049.049 Can anyone explain what is going on, and is there a way to avoid it? Thanks Frank Millman

[sqlite] .NET Linux problem with Microsoft.Data.Sqlite.dll and sqlite3_prepare_v2

Richard Hipp or Igor Tadetnik, Here is the C# code for Microsoft.Data.Sqlite.dll, designed for .NET users on Ubuntu Linux and Windows, I am using the latest version of libsqlite3.so compiled as follows; gcc -shared -g -o libsqlite3.so -fPIC sqlite3.c I was able to get

[sqlite] C# Microsoft.data.sqlite SqliteCommand::ExecuteReader encounters a doubly freed pointer after 935 invocations

We encountered a doubly freed "C" pointer after calling sqlite3_exec in my custom version of the Microsoft.Data.Sqlite C# method SqliteCommand::ExecuteAnReader which does not call the parent C# class method DbCommand::ExecuteReader which does not use a C# NativeMethod. The C# NativeMethod

[sqlite] Compiling error on Cygwin on Windows 8.1: 3.8.7.4 and 3.8.8

': ../sqlite-autoconf-3080800/sqlite3.c:22493: undefined reference to `_beginthreadex' collect2: error: ld returned 1 exit status Best Regards Frank Ho ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Problem with recursive CTE

- Original Message - From: "Alek Paunov" <a...@declera.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, August 25, 2014 4:04 PM Subject: Re: [sqlite] Problem with recursive CTE On 25.08.2014 15:42, Frank

Re: [sqlite] Problem with recursive CTE

- Original Message - From: "Frank Millman" <fr...@chagford.com> To: <sqlite-users@sqlite.org> Sent: Monday, August 25, 2014 2:32 PM Subject: Re: [sqlite] Problem with recursive CTE Could it be a version problem? I am using the version bundled with P

Re: [sqlite] Problem with recursive CTE

work. Since you do not mention what version you are using, one assumes it is prior to this fix? Thanks, Keith. I think you are spot on. See my reply to Richard. I will upgrade and try again. Frank ___ sqlite-users mailing list sqlite-users@sqlite.or

Re: [sqlite] Problem with recursive CTE

From: "Frank Millman" <fr...@chagford.com>Thanks for the reply, Richard. WITH RECURSIVE temp(x) AS ( SELECT 1 UNION ALL SELECT x+1 FROM temp WHERE x<5 ) SELECT x FROM temp UNION SELECT x+5 FROM temp; And did indeed get integers 1 through 10 as an answer. I get the s

Re: [sqlite] Problem with recursive CTE

From: "Frank Millman" <fr...@chagford.com> WITH RECURSIVE temp AS ( [initial-select UNION ALL recursive-select] ) SELECT * FROM temp UNION * FROM temp Sorry, I meant SELECT * FROM temp UNION SELECT * FROM temp Frank ___ sqli

[sqlite] Problem with recursive CTE

of sqlite3, or is there any workaround? Thanks Frank Millman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] commit fails when journal_mode = memory

rary with the next defines: THREADSAFE=2 SQLITE_ENABLE_FTS4 SQLITE_ENABLE_FTS3_PARENTHESIS SQLITE_ENABLE_RTREE SQLITE_ENABLE_COLUMN_METADATA SQLITE_ENABLE_STAT3 SQLITE_CORE The application is built with the same defines, except SQLITE_CORE which is then ommitted. Frank De prins [cid:image002.jpg@01CE45B7.

[sqlite] Speeding up the UPSERT by using ISNULL instead of COALESCE in the subselect

Good morning, Could anyone tell me if I should replace COALESCE with ISNULL in the subselect in order the improve the speed of the following UPSERT: INSERT OR REPLACE INTO FREQMARY(Value, NumericValue, DateTimeValue, Count, Length) VALUES ('Braintree Road',NULL,NULL, COALESCE((SELECT Count+1 FROM

Re: [sqlite] [FINAL EDIT] What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE? Thank you

Good evening Michael Black and Igor Tandetnik and sqlite-users group[FINAL EDIT], May I ask what is the reason for SQLITE UPSERT performance improvement with UNIQUE ON CONFLICT IGNORE? In *Test #1*, we have a CREATE TABLE FREQMARY( VALUE CHAR(40),NUMERICVALUE FLOAT, DATETIMEVALUE CHAR(40), COUNT

[sqlite] [LAST EDIT] What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE?

Good afternoon, What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE? In *Test #1*, we have a CREATE TABLE FREQMARY( VALUE CHAR(40),NUMERICVALUE FLOAT, DATETIMEVALUE CHAR(40), COUNT INT, LENGTH INT) and a CREATE UNIQUE INDEX IX_MARY ON FREQMARY(VALUE). In

Re: [sqlite] [EDIT] What is the reason for the SQLITE performance increate with CREATE TABLE UNIQUE CONFLICT IGNORE

Michael Black and Igor Tandetnik, Thank you for your reply. We wiil get back you to tomorrow with the confirmation of your answers, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [EDIT]What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE?

Good morning, What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE? In *Test #1*, we have a CREATE TABLE FREQMARY( VALUE CHAR(40),NUMERICVALUE FLOAT, DATETIMEVALUE CHAR(40), COUNT INT, LENGTH INT) and a CREATE UNIQUE INDEX IX_MARY ON FREQMARY(VALUE). In

[sqlite] What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE?

Good morning, What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON CONFLICT IGNORE? In *Test #1*, we have a CREATE TABLE TESTMARY( VALUE CHAR(40),NUMERICVALUE FLOAT, DATETIMEVALUE CHAR(40), COUNT INT, LENGTH INT) and a CREATE UNIQUE INDEX IX_MARY ON TESTMARY(VALUE). In

Re: [sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

the suspicious data point may be discarded, i.e., a reading may be rejected if the probability of obtaining the particular deviation from the mean is less than 1/(2*n*). On Tue, Feb 19, 2013 at 11:05 AM, Frank Chang <frankchan...@gmail.com>wrote: >joe.fis...@tanguaylab.com, Michael

Re: [sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

joe.fis...@tanguaylab.com, Michael Black, Marc. L Allen and Simon Slavin, Thank you for your help in helping me to convince our company's software architect that it is possible to calculate the streakedness of numeric data. ___ sqlite-users mailing

[sqlite] Would it be possible to use SQLIte to calculate Chauvents Criterion as a proxy for data streakedness?

Good morning, Would it be possible to use SQLIte to calculate Chauvents Criterion as a proxy for data streakedness? Thank you. http://math.stackexchange.com/questions/198105/chauvenets-criterion-all-my-data-points-are-outliers?rq=1 ___ sqlite-users

[sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

Would anyone know how to use SQLITE to calculate the streakedness of data? The definition of streakedness is how many deviations away from the mean(i.e running average a numerical data streak is Thank you for your help. A variable R can be used to indicate how many deviations away from the mean a

[sqlite] Which C++ data structures might one use to cache a sqlite query result?

Could anyone suggest which C++ data structure to use to cache a sqlite query result? Thank you for your help ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT?

te-users@sqlite.org> Subject: Re: [sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT? Message-ID: <20121212161534.gb68...@dfjk.org> Content-Type: text/plain; charset=us-ascii On Wed, Dec 12, 2012 at 06:26:54AM -0800, Frank Chang scratched on the wall: >

[sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT?

Hello, In the latest version of SQLite, is there any subtle distinction between UNIQUE and DISTINCT? If there exists a subtle distinction between UNQUE and DISTINCT in Sqlite, what is the appropriate Insert or replace syntax, CREATE INDEX usage, and the SELECT statements? Thank you.

[sqlite] How to differentiate between sqlite database empty char* strings and DBNULL char* string?

Good afternoon, Is it possible to differentiate between sqlite database empty char* strings and DBNULL char* strings? If so, what is the est way to do that? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] 18. Re: Sqlite, Is it possible to calculate the length of the longest increasing subsequence using an UDF

Elefterios Stamatogiannakis, Following the project gurus's example sequence of -- 1,2,3,4,3,5,6,7,8,10 -- the numeric sorted ascending subsequence is found to be 1,2,3,4,5,6,7,8,10 using an automatic variable containing the most recent monotically increasing sequence member value and traversing

[sqlite] 5. Re: Sqlite, Is it possible to calculate the length of the longest increasing subsequence using an UDF

Igor Tandetnik, >>> So what is the purpose of this whole exercise Following the project gurus's example sequence of -- 1,2,3,4,3,5,6,7,8,10 -- the numeric sorted ascending subsequence is found to be 1,2,3,4,5,6,7,8,10 using an automatic variable containing the most recent monotically increasing

[sqlite] Sqlite, Is it possible to calculate the length of the longest increasing subsequence using an UDF?

With the latest version of Sqlite, Is it possible to calculate the length of the longest increasing subsequence, also referred to as sortation percent, using a sqlite UDF, user defined function? Thank you. ___ sqlite-users mailing list

[sqlite] Bug? Shell (sqlite3.exe) exits after ".read"-ing a file that contains two errors

:23 on 64-bit windows 7. My copy of sqlite3.exe came from sqlite-shell-win32-x86-3071200.zip that I downloaded on 5/18/12. Best regards. K. Frank P.S. Here are some more test files that illustrate the issue: -- one error, sqlite3 doesn't exit select count(*) from no_table_a;

[sqlite] Is it possible to accurately retrieve UTF-8 String stored in SQLite 3.7.11 databases using sqlite3_column_text?

Good morning, Is it possible to accurately retrieve UTF-8 String stored in SQLite 3.7.11 databases using sqlite3_column_text? If not, what sqlite3 C/C++ api should we use? Thank you. ___ sqlite-users

[sqlite] Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database?

Good Morning, Is it possible to determine the length of UNICODE(UTF-8 or UTF-16) strings stored in SQLite 3.7.11 database? I just tried using the IBM open-source ICU function int32_t u_strlen(const UCHAR* str) but it gives me erroneous? Evidently the u_strlen function for a UTF-8 NULL

Re: [sqlite] Is it possible to insert UTF-8 strings in SQLITE3.EXE?

Richard Hipp, Simon Slavin, Luuk, and Keith Metcalf Thank you for your replies to our question. Here is another way I found out how insert UTF-8 strings in SQLITE3.EXE. F:\sqlite3_6_16>sqlite3.exe mdName.dat SQLite version 3.6.16 Enter ".help" for instructions Enter SQL statements

[sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

Good Afternoon, Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE? If so, could you please show us a brief example. Best Regards Frank. ___ sqlite-users

[sqlite] Potential Solution to -- Is it possible to preclude the latest sqlite 3.7.11 Windows warning message

'AreFileApisANSI' is not static, identity not guaranteed. Please advise me if this change is okay for Windows sqlite3.c applications. Thank you. > e:\users\frank\dqt_memorymap\sqlite\sqlite3.c(32329) : warning C4232: > nonstandard extension used : 'pCurrent' : address of dll

[sqlite] Is it possible to preclude the latest sqlite 3.7.11 Windows warning message?

Simon Davies, We tried your suggestion, /Ze on Visual Studio 2008, buy we are still encountering Microsoft Visual 2008 warning, Thank you for your help. e:\users\frank\dqt_memorymap\sqlite\sqlite3.c(32329) : warning C4232: nonstandard extension used : 'pCurrent' : address of dllimport

[sqlite] Is it possible to preclude the latest sqlite 3.7.11 Windows warning message?

below. Is it possible to preclude and understand the meaning of this warning message? Thank you. e:\users\frank\dqt_memorymap\sqlite\sqlite3.c(32329) : warning C4232: nonstandard extension used : 'pCurrent' : address of dllimport 'AreFileApisANSI' is not static, identity not guaranteed

Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db ?

Message: 19 >Date: Wed, 11 Apr 2012 08:31:49 -0400 >From: Gabor Grothendieck >To: General Discussion of SQLite Database >Subject: Re: [sqlite] Is it possible to use substrings of Windows DOS >batch fiile parameters in sqlite3.exe -line db ?

Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db ?

Re: [sqlite] Is it possible to use substrings of Windows DOS batch > fiile parameters in sqlite3.exe -line db ? > Date: Wed, 11 Apr 2012 11:09:44 -0400 > > On Tuesday, April 10, 2012 07:14:59 PM Frank Chang wrote: > > Good evening, We are trying to generate automated SQLITE SQL scripts ba

[sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db ?

Good evening, We are trying to generate automated SQLITE SQL scripts based on the names of SQLite tables derived by substring manipulation of Windows DOS batch file and/or Windows environment variables. For example: /* mary.bat */ FOR /f %%a IN ('dir /b *.zip') DO CALL sub %%a /*

Re: [sqlite] Possible Solution to Sqlite3BTreeMovetoUnpacked SQLite SELECT Statement Workaround paradox

Dan Kennedy, I discovered yesterday that one can use sqlite prepared SQLITE statements to reduce the CPU and memory utilization of parsing SELECT statements used to substitute for Sqlite3BTreeMovetoUnpacked and sqlite3_blob_reopen. Thank you From: frank_chan...@hotmail.com To:

Re: [sqlite] Sqlite3BTreeMovetoUnpacked SQLite SELECT Statement Profiler Output

From: frank_chan...@hotmail.com To: sqlite-users@sqlite.org Subject: RE: Sqlite3BTreeMovetoUnpacked SQLite SELECT Statement Workaround is I/O Bound and uses all the Physical Memory Date: Wed, 29 Feb 2012 11:59:56 -0500 Daniel Kennedy, I tried your SQLite SELECT Statement

Re: [sqlite] Sqlite3BTreeMovetoUnpacked SQLite SELECT Statement Workaround is I/O Bound and uses all the Physical Memory

Daniel Kennedy, I tried your SQLite SELECT Statement workaround(the profiler output is attached) but the profiler is full of sqlite functions and the application runs slower because it is I/O bound and uses almost all the physical memory. I was thinking maybe we could write only one SQLITE

[sqlite] Is it possible to reduce the number of times sqlite3BTreeMoveToUnpacked is called with an SQLITE C++ application?

Good morning, We have a SQLITE C++ application which tries to find the intersection between the blobs in separate sqlite database tables(which we call subgraphs) ,containing record numbers. When we profile the code below we find that the top profiler user is sqlite3BTreeMoveToUnpacked. I have

[sqlite] Faster Alternative to sqlite3_blob_open

sqlite3_blob_reopen.ppt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Faster Alternative to sqlite3_blob_open

RetVal=new unsigned long[(Size+1)*sizeof(unsigned long)]; sqlite3_blob_read(SubGraph_->hBlob,RetVal,Size*sizeof(unsigned long),0); RetVal[Size]=0; if (Size_!=0) *Size_=Size; return RetVal; } Frank has a file to share with you on SkyDrive. To vie

[sqlite] Faster alternative to sqlite3_blob_open

Good morning,We have been using sqlite3_blob_open in the function below.When I profile the application using Very Sleepy I notice that sqlite3_blob_open is one of he biggest consumers of CPU time. Is it possible to find a faster alternative to sqlite3_blob_open? Thank you unsigned long

Re: [sqlite] WAL mode is reliable?

ng by other processes and I no longer have the hassle of waiting for OS copies to be done for every load, so having had only positive results and no adverse effects I can really recommend the write ahead logging. Best regards, Frank ___ sqlite-users

Re: [sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

supply some more details about what takes place inside the transaction against the main database and what you are trying to do with the other databases, if the above explanation doesn't solve your issue. /Frank > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:

Re: [sqlite] EXT :Re: Concurrent readonly access to a large database.

nfortunately not the case because each tables have a different set of IDs, > despite of 70% to 90% overlapping keys. I even do not know in advance all > available IDs. Okay, so each table will have to be handled by itself. Best regards, Frank ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EXT :Re: Concurrent readonly access to a large database.

rove more efficient this way. You could even consider having less tables so that the threads can work for longer without having to switch to the next table. /Frank Missel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Limit COUNT

dicted this is slightly slower at around 60 milliseconds. So selecting null is always better in sub queries when only the count or existence of records are needed and not actual values from any of the columns. /Frank Missel ___ sqlite-users mai

Re: [sqlite] Changing the data type of an existing table

declared data types. Rather than have some databases which need special handling with views I prefer to handle the situation once and for all in existing and future databases and not have to worry about having special views for some tables in some databases at certain sites. /Frank > -Origi

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

, forum, etc. That would belong with the organisation, company, persons that take care of that now. By having this thread with people replies and opinions it can then give an idea of the pro and cons as well as an idea of how would be for and against it. Best regards, Frank > -Original Mess

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi Mark, Well, perhaps you are right. But I am not going to take on that. I am a user of SQLite and can perhaps help with some posts and suggestions now and then. So I am just going to throw in the idea and state the pros vs. cons as I see them . Best regards, Frank > -Original Mess

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

e would fall in the same category: A technical expertise forum covering a specific product, application, programming language, etc. With a members only access and very dedicated users. /Frank Missel ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

ups. Who am I tell someone what to prefer. I just find, however, it is a bit religious like choice of OS or gadgets. I can see that e-mail lists can work and in the past could have a lot of advantages. Nowadays, I find not as many good reasons to prefer them over a proper forum which have som

Re: [sqlite] How about a proper forum rather than an e-mail list

. Many seem quite happy with the list. /Frank ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How about a proper forum rather than an e-mail list

ot of spam in the e-mail-list, so either it also monitored by someone or the fact that it can only be accessed by members makes for a well behaved list which would be the same for the forum. /Frank ___ sqlite-users mailing list sqlite-users@sqlite.org ht

[sqlite] How about a proper forum rather than an e-mail list

. There is a quite widespread, free Forum software that could be used: http://www.simplemachines.org/ http://en.wikipedia.org/wiki/Simple_Machines_Forum They support MySQL, SQLite and PostgreSQL as the underlying database. Well, just a thought. /Frank Missel

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

many people use it. Nah, for it to have any success it would have to be an official forum endorsed and supported by the SQLite team. /Frank Missel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

for e-mail-addresses to be exposed /Frank Missel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] FW: How about a proper forum rather than an e-mail list

. There is a quite widespread, free Forum software that could be used: http://www.simplemachines.org/ http://en.wikipedia.org/wiki/Simple_Machines_Forum They support MySQL, SQLite and PostgreSQL as the underlying database. Well, just a thought. /Frank Missel

Re: [sqlite] Limit COUNT

ull" which will not fetch anything. fromtable limit 5000 ) You could do that and also just select e.g. 50 actual rows and display these to the user. /Frank ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Limit COUNT

om the actual data carrying table. The user could then get the first 100 records, and continue with batches of 100 as needed. If these options does not seem to fit, I think that you have to explain a bit more about how your solution is, what you expect and how you access the

Re: [sqlite] Limit COUNT

with the count? /Frank > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Fabian > Sent: 16 October 2011 19:09 > To: General Discussion of SQLite Database > Subject: [sqlite] Limit COUNT > > How can yo

Re: [sqlite] Changing the data type of an existing table

done. First the declared data type could be changed as I have described. After that an update statement could set the = CAST( as INTEGER). But you are right that indexes in this case would have to be rebuilt with the REINDEX statement. However, that might still be better than having to recreate the

Re: [sqlite] Changing the data type of an existing table

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Frank Missel > Sent: 16 October 2011 15:37 > > With this open philosophy of the SQLite database I thought that perhaps > there really isn't

[sqlite] Changing the data type of an existing table

should not break anything between the schema and the stored data. But I am not sure if it is even possible. If not, I will move my many Gigabytes of data around, but I thought, it would be worth just checking first. /Frank Missel ___ sqlite-users

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

y external code calling the Excel COM objects. Thanks a lot, this is very helpful. Best regards, Frank > -Original Message- > From: Alek Paunov [mailto:a...@declera.com] > Sent: 15 October 2011 00:13 > To: General Discussion of SQLite Database > Cc: Frank Missel > Subj

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

might have the perfect solution for just using the SQLite database as a proper OLE DB data source which seems to be the way to do it nowadays or using the generic ODBC driver as the data source without having the create an individual DSN. /Frank ___ sqlite-us

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

SN for each individual database and use the ODBC driver. Its a bit messy programmatically as you have to access the Registry but it can be done. /Frank ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

times be millions of rows, i.e. many more than can be contained in a worksheet. But when referencing the data source directly as a proper data source the number of rows are not limited to the maximum number of allowed rows in a worksheet. /Frank ___ sq

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

base as a data source programmatically through the Excel COM object model (in order to e.g. create a Pivottable), I would be very eager to hear about it :-). /Frank ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/ma

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

? And if so, how do you specify the wrapper as a data source? /Frank > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Bart Smissaert > Sent: 14 October 2011 02:21 > To: General Discussion of SQLite Databas

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

Bart, thanks for the offer, but we found the cause of the problems in the data type naming of the columns. Have you found a way to avoid having to define DSN's for each individual database? /Frank > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

ch individual database that you want to access -- I haven't found any way to work around that. If one chooses just the "SQLite3 Datasource" as data source there is an error message to the effect that the data source contains no visible tables. For other data sources a par

[sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

entioned problems with decimal fields? /Frank Missel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   >