Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

Another lurker here ... I have always preferred mailing lists and found forums to be too fat. That said, I like the fossil forum. It was referred to bring a "enginerish" style which is fine given the audience Kudos for its speed and light weight, No fluff just data. Jim &quo

Re: [sqlite] multithreaded app with in-memory database and transactions

I have often wondered what the performance difference is between /dev/shm and :memory: databases Jim "Jed" Dodgen j...@dodgen.us On Thu, Feb 13, 2020 at 4:48 PM Keith Medcalf wrote: > > On Thursday, 13 February, 2020 17:06, Jim Dodgen > wrote: > > >I have pla

Re: [sqlite] multithreaded app with in-memory database and transactions

I have placed databases on/in /dev/shm and shared them across both threads and processes. Jim "Jed" Dodgen j...@dodgen.us On Thu, Feb 13, 2020 at 2:38 PM Keith Medcalf wrote: > > Correct. "memory" databases can only be shared between connections in the >

[sqlite] Incorrect join result with duplicate WHERE clause constraint (again)

find https://www.sqlite.org/src/tktview?name=cf5ed20fc8, which was reported against 3.25 and seems to have fixed before any of the versions I tested - I'm not sure if this is just a reappearance of that bug, but it's at least very similar. Hope this is useful! Jim Bosch

Re: [sqlite] New word to replace "serverless"

I vote for ignoring the marketing types and stick with "serverless" Jim "Jed" Dodgen j...@dodgen.us On Wed, Jan 29, 2020 at 10:20 AM Thomas Kurz wrote: > I would not choose a new wording. "Serverless" is correct, and just > because others start using &qu

Re: [sqlite] Mixed ASC and DESC in single column

On 11/21/2019 8:08 AM, Hamish Allan wrote: > Thank you very much Clemens, but I've realised I've asked the wrong > question. > > Is it possible to achieve the same if the identifiers are not unique? > > So for instance: > > CREATE TABLE IF NOT EXISTS Data (identifier TEXT, info TEXT); > > INSERT

Re: [sqlite] Question about: Adding a record to a table with select failure

Not sure this helps, a way to a conditionally insert based on if record already exists, is a select with literals left outer joined to the maybe record and use a where test value is null. Something like this pseudo SQL insert into T (valueA, valueB') (select 'ValueA', 'ValueB' left outer join T

Re: [sqlite] How to use CASE statement to SUM() some numbers

Maybe something like: CREATE VIEW "Sum of Expenses Between two Dates" AS SELECT Date, sum( CASE WHEN Date BETWEEN date('now', '-1 months') AND date('2019-11-04', '-1 days') THEN Expense ELSE 0 END) as 'Sum of Expenses:' FROM Expenses; On 11/15/2019 12:22 PM, David

Re: [sqlite] Count error?

Using a sub-select should work select (select count(n) from t0) as "t0_count", (select count(n) from t1) as "t1_count", (select count(n) from t2) as "t2_count" ; On 11/1/2019 9:07 AM, Jose Isaias Cabrera wrote: > Jose Isaias Cabrera, on Friday, November 1, 2019 11:51 AM, wrote... >> >>

Re: [sqlite] Last record

In your application you can create a wrapping iterator that pre-reads the next value instead or directly accessing the low level step function. Then you can ask if it is the last. On 10/15/2019 9:44 AM, Simon Slavin wrote: > On 15 Oct 2019, at 5:38pm, Philippe RIO <51...@protonmail.ch> wrote: >

Re: [sqlite] Opposite of SQLite

IMS/DB Jim "Jed" Dodgen j...@dodgen.us On Thu, Oct 10, 2019 at 3:03 PM test user wrote: > CAHeavy > > Chaotic Answer Heavy > > On Thu, 10 Oct 2019 at 20:42, Simon Slavin wrote: > > > On 10 Oct 2019, at 7:55pm, Ned Fleming wrote: > > >

Re: [sqlite] Newbie Issues with COLLATE

need to do something to close it... Jim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Newbie Issues with COLLATE

te COLLATE subject, including creation of custom collations and loading them into the SQLite command-line executable if possible? The documentation seems really thin in this area! TIA for any suggestions anyone can provide. Jim ___ sqlite-users mailing

Re: [sqlite] Problem with SELECT by rowid after INSERT

On Apr 12, 2019, at 3:27 PM, Keith Medcalf wrote: > > >> To be a little more specific, the problem happens when I try to do >> sqlite3_bind_int() on the prepared statement using the new rowid. It >> doesn't use the rowid it uses NULL. >> >> The prepared statement is "SELECT * FROM sessiond

Re: [sqlite] Problem with SELECT by rowid after INSERT

That was it. There was another SELECT going on that had not been finalized. Thank you Richard, Simon, and Graham for you help on this. > On Apr 12, 2019, at 2:36 PM, Richard Hipp wrote: > > On 4/12/19, Jim Dossey wrote: >> I'm doing the INSERT first, without a BEGIN ... COM

Re: [sqlite] Problem with SELECT by rowid after INSERT

to call any other functions after that to make the new row visible to other connections? > On Apr 12, 2019, at 2:15 PM, Richard Hipp wrote: > > On 4/12/19, Jim Dossey wrote: >> >> The problem is when I do an INSERT and then try to SELECT that record by >> rowid i

Re: [sqlite] Problem with SELECT by rowid after INSERT

stent and some not, and for the non existent rowid's sqlite3_bind_int() always inserts a NULL. > On Apr 12, 2019, at 1:38 PM, Simon Slavin wrote: > > On 12 Apr 2019, at 6:32pm, Jim Dossey wrote: > >> It's just when I use 2 different connections that the second connection doe

Re: [sqlite] Problem with SELECT by rowid after INSERT

the CLI on the database file and did a SELECT there and I know that the record exists and the rowid that I'm searching for does exist. But sqlite3_bind_int() inserts a NULL instead of the rowid. > On Apr 12, 2019, at 1:26 PM, Simon Slavin wrote: > > On 12 Apr 2019, at 6:23pm, Jim Doss

Re: [sqlite] Problem with SELECT by rowid after INSERT

ote: > > On 12 Apr 2019, at 4:40pm, Jim Dossey wrote: > >> Which is obtained by calling sqlite3_expanded_sql(). > > Was that a copy-paste error or do you actually want > > <https://sqlite.org/c3ref/last_insert_rowid.html> >

[sqlite] Problem with SELECT by rowid after INSERT

I have a table define like this: CREATE TABLE "sessiond" ( "journal" VARCHAR(4) DEFAULT '' NOT NULL, "session" VARCHAR(16) DEFAULT '' NOT NULL, "pid" INTEGER DEFAULT 0 NOT NULL, rowid INTEGER PRIMARY KEY ); In my application I open 2 connections to this table, one for reading and one for

[sqlite] Error in docs

I think I found an error in the documentation here: https://www.sqlite.org/datatype3.html#column_affinity_for_views_and_subqueries It defines the table and view: CREATE TABLE t1(a INT, b TEXT, c REAL); CREATE VIEW

Re: [sqlite] Database Encryption (System.Data.SQLite)

From looking at the System.Data.SQLite source (someone please correct me if I am wrong) It would use whatever cipher was provided to it via the native library that it was deployed with. It's designed with sqlite encryption extension in mind but I suppose in theory it would work with any

Re: [sqlite] Apparent power fail data loss in embedded use - SQLite newbie

What is the journal mode? On 3/12/2019 10:30 AM, Ted Goldblatt wrote: On Tue, Mar 12, 2019 at 11:45 AM James K. Lowden wrote: On Tue, 12 Mar 2019 10:36:37 -0400 ted.goldbl...@gmail.com wrote: The problem is basically that as part of a test, the customer wants to power fail the device, and

Re: [sqlite] sqlite3AtoF giving incorrect results

Basically a variant of the final idea you had is what we went with. Thanks for the suggestions! Jim Borden Privacy Policy<http://www.couchbase.com/privacy-policy> Marketing Preferences<http://info.couchbase.com/unsubscribe-or-manage-pr

Re: [sqlite] sqlite3AtoF giving incorrect results

out how to trigger it that way, I just put in a call to strtod alongside the call to sqlite3AtoF inside of codeReal and compared the results. Jim Borden On 2019/02/28 8:50, "drhsql...@gmail.com on behalf of Richard Hipp" wrote: On 2/27/19, Jim Borden wrote: > >

[sqlite] sqlite3AtoF giving incorrect results

results in a false infinity. Would this be considered a bug, or is precision not guaranteed to the same level as strtod because of other factors? Jim Borden Senior Software Engineer e: jim.bor...@couchbase.com t: @borrrden Privacy Policy<http://www.couchbase.com/privacy-policy> M

Re: [sqlite] SEE Temp Files

I see. That complicates things a bit. What happens to SQLite temp files when they are "done being used" (if such a concept exists). Are they deleted or simply left there for the OS to clean up? Jim Borden On 2019/01/29 8:35, "sqlite-users on behalf of Richard

[sqlite] SEE Temp Files

hand on the version of our product that uses SEE. Thanks, Jim Borden Privacy Policy<http://www.couchbase.com/privacy-policy> Marketing Preferences<http://info.couchbase.com/unsubscribe-or-manage-preferences> ___ sqlite-users mailing list

Re: [sqlite] Regarding CoC

I think Donald Knuth would approve. On Mon, Oct 22, 2018 at 8:01 PM D Burgess wrote: > > The CoC is fine. Don't change it. > +1 > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] [EXTERNAL] Common index for multiple databases

be handled at the application level above the SQL core (which only handles "ACID consistency"). HTH Jim Callahan Callahan Data Science LLC Orlando, FL On Fri, Aug 3, 2018 at 5:41 AM, Hick Gunter wrote: > This is what I think you are asking: > > - You have a "m

Re: [sqlite] This is driving me nuts

2:2 or 1:3). Jim Callahan Orlando, FL On Mon, May 28, 2018 at 5:35 AM, Rowan Worth <row...@dug.com> wrote: > On 28 May 2018 at 17:29, x <tam118...@hotmail.com> wrote: > > > I’ve just discovered the thread in the original app decreases the > > available memor

Re: [sqlite] Web hosting and perl DBD::SQLite?

Any VPSes you suggest? *Jim Dodgen* On Fri, May 11, 2018 at 2:14 PM, Warren Young <war...@etr-usa.com> wrote: > On May 11, 2018, at 2:53 PM, Jim Dodgen <j...@dodgen.us> wrote: > > > > A little off topic, but my hosting company went a way. And after two

[sqlite] Web hosting and perl DBD::SQLite?

A little off topic, but my hosting company went a way. And after two tries I need to find a hosting company who is not scared of SQLite, specifically have installed or will let me install DBD::Sqlite? *Jim Dodgen* ___ sqlite-users mailing list sqlite

Re: [sqlite] 3.24 draft - upsert

Per Keith Medcalf's comment on the ancient master file merge, I found this inscription concerning batch processing in the elephant's graveyard: https://www.ibm.com/support/knowledgecenter/zosbasics/com.ibm.zos.zconcepts/zconc_batchscen2.htm Jim Callahan On Wed, May 9, 2018 at 10:06 AM, Keith

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

_ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- *Jim Dodgen* ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] How to get the entry from sqlite db without primary key or rowid order?

and append (">" and ">>"). Jim Callahan Callahan Data Science LLC Orlando, FL <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=icon> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email_

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

be that the space after the number, plus certain locales would reproduce the issue. Jim Callahan Callahan Data Science LLC Orlando, FL On Tue, Jan 23, 2018 at 10:22 AM, Ralf Junker <ralfjun...@gmx.de> wrote: > On 23.01.2018 15:31, Richard Hipp wrote: > > I'm still unable to reprod

Re: [sqlite] Can this be done with SQLite

Wouldn't the mod operator do this? Do an update and set key = 1 + (5 + key)%5 On 1/22/2018 12:38 PM, David Raymond wrote: Unless I'm reading you wrong then just do the normal begin transaction; update playYouTubeVideo set speed = ( select speed from playYouTubeVideo where key = '2')

[sqlite] WAL mode with readers and writers

Thanks to feedback from Simon Slavin, I now understand how data_version works and have it working in my code.  But in my testing, I tried another situation to see what would happen with locking in WAL mode.  I have a process that does the following pseudo-code with a table:

[sqlite] "PRAGMA data_version" documentation wrong

I think the documentation for "PRAGMA data_version" at https://www.sqlite.org/pragma.html is incorrect.  I've been testing this pragma and I've found that it only returns '1' for a standard database or '2' if the database is in WAL mode.  The documentation makes it sound like this value

Re: [sqlite] Missing data on SELECT

You are inserting rows with ProjID but not the primary key "id" which is rowid and automatically created. I think it is not a good practice to use rowid's like you are doing. If you had inserted the id it would be a different story. *Jim Dodgen* On Thu, Nov 2, 2017 at 5:26

Re: [sqlite] (no subject)

Thanks I needed a Laugh, try clicking on one of the links at the bottom of your emails and unsubscribe. *Jim Dodgen* On Fri, Oct 6, 2017 at 7:41 PM, cindy estepp <cindyestep...@gmail.com> wrote: > stop emailing me i do not

Re: [sqlite] Binding an order by

What you may be able to do is to use a case statement(s) which uses a bound variable to either a column or dummy E.g order by case orderControlValue = 1 then column1 else "" end, ... On 10/5/2017 11:51 AM, Igor Tandetnik wrote: On 10/5/2017 2:45 PM, Stephen Chrzanowski wrote: Given the

Re: [sqlite] SQLite list spam from raypoker79

For what it is worth, those messages reached my inbox twice on two different threads at least. Jim Borden Software Engineer jim.bor...@couchbase.com On 2017/09/13 9:02, "sqlite-users on behalf of Simon Slavin" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of slav...

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

social.msdn.microsoft.com/Forums/en-US/7f38ee7b-15e2-4e2c-8389-1266f496e4b2/regular-expression-to-get-date-format-from-string?forum=csharplanguage ​Jim Callahan On Tue, Apr 11, 2017 at 10:00 PM, Ron Barnes <rbar...@njdevils.net> wrote: > Hi Jim, > > I could alter the program th

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

counts; so you may need Julian dates after all. Jim Callahan Orlando, FL On Tue, Apr 11, 2017 at 7:24 PM, Ron Barnes <rbar...@njdevils.net> wrote: > Hello all, > > To everyone who helped me before - thank you very much! > > I'm coding in Visual Basic .NET (Visual Studio 201

Re: [sqlite] SQLite does not support ARM platform?

Oh, you are talking about WinCE? I don’t think you should be thinking in terms of “ARM vs non-ARM” but rather “X platform vs Y platform.” As others have noted, sqlite obviously runs on ARM and the issue is not with sqlite but with the way you are trying to compile it or the platform you are

Re: [sqlite] SQLite does not support ARM platform?

That error has nothing to do with SQLite, really. SQLite is deployed on ARM platforms and ships as a system library on iOS. It sounds like you are running into this -> https://stackoverflow.com/questions/11151474/can-arm-desktop-programs-be-built-using-visual-studio-2012 Keep in mind that

[sqlite] shell .schema command doesn't display attached table schemas

Example: [jim@mb ~]$ sqlite3 dummy -- Loading resources from /Users/jim/.sqliterc SQLite version 3.15.1 2016-11-04 12:08:49 with the Encryption Extension Copyright 2016 Hipp, Wyrick & Company, Inc. Enter ".help" for usage hints. sqlite> create table t1(text); sqlite> ^D [ji

Re: [sqlite] extension to run bash

com/en-us/commandline/wsl/about Thus, at some point, Linux, OS/X and Windows will all support Bash scripts. For now, there are non-native emulators MinGW/MSys and Cygwin to provide Bash on Windows. MinGW/MSys http://www.mingw.org/wiki/msys Cygwin http://www.mingw.org/node/21 Jim Callahan Orlando, FL

Re: [sqlite] extension to run bash

http://sqlite.1065341.n5.nabble.com/How-accept-sqlite3-commands-from-stdin-td38710.html Jim Callahan Orlando, FL On Wed, Jan 11, 2017 at 4:23 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Dear SQLites, > > I am using exclusively sqlite3 shell for all the pr

Re: [sqlite] Advice on using dates and hours for bin counts, time-zone agnostic

ository/tz-link.html Some best practices https://www.w3.org/TR/timezone/ But, as Einstein said, it's all relative. Jim Callahan Orlando, FL On Tue, Jan 10, 2017 at 10:01 AM, Jeffrey Mattox <j...@mac.com> wrote: > My application will be counting events and saving the totals fo

Re: [sqlite] Connecting DataBases files into one

SAME FIELDS you can merge tables using the procedure described in this StackOverflow answer. Pay attention, however, the difference between UNION and UNION ALL http://stackoverflow.com/questions/30292367/sqlite-append-two-tables-from-two-databases-that-have-the-exact-same-schema Jim Callahan Orlando, FL

Re: [sqlite] problem with sqlite 4

an additional license." http://www.sqliteexpert.com/support.html I am not affiliated with Coral Creek Software and the only information I could find out about the company as opposed to the product (in less than 2 minutes of Google searching) is: https://www.bizapedia.com/fl/coral-creek-software.html Jim

[sqlite] problem with sqlite 4

rching) is: https://www.bizapedia.com/fl/coral-creek-software.html Jim Callahan Orlando, FL ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

database files as "not a database" as far as I know. Furthermore the file format itself is compatible with future versions, but certain features are not if I am not mistaken. You can compare bytes 96-100 with the SQLITE_VERSION_NUMBER of the tool you are using to achieve the effect you w

Re: [sqlite] Anybody know why mono SQLite uses SqliteConnection but Windows uses SQLiteConnection?

Thanks for the suggestion, Bill. Will this run on a Linux system? The zip file has Install.exe and Test.exe inside it. Jim On 18-Nov-2016 7:44 AM, Drago, William @ CSG - NARDA-MITEQ wrote: Do any of you know why the two different versions of SQLite have different case in the method names

[sqlite] Anybody know why mono SQLite uses SqliteConnection but Windows uses SQLiteConnection?

Thanks, Jim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database malformed after 6000 Inserts?

I had a problem similar to this before. What is the threading model for access to the database and how is the native library compiled and configured? Jim Borden (Sent from a mobile device) > On 4 Oct 2016, at 19:12, Werner Kleiner <sqlitetes...@gmail.com> wrote: > > Hello, >

Re: [sqlite] Regarding the effects of the COMMIT keyword

quickly after the GET when in reality it was another starting and the previous one finishing. Jim Borden Software Engineer jim.bor...@couchbase.com On 2016/09/29 18:09, "sqlite-users on behalf of Clemens Ladisch" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of clem.

Re: [sqlite] Regarding the effects of the COMMIT keyword

compiled together (the listener, the storage API, the app, etc), and written all in C# with interop calls to C. Thanks for your input. The clarification about COMMIT was enough for me to focus my attention elsewhere and has been helpful. Jim Borden Software Engineer jim.bor...@couchbase.com

Re: [sqlite] Regarding the effects of the COMMIT keyword

to other connections from that point forward? Jim Borden Software Engineer jim.bor...@couchbase.com On 2016/09/29 16:52, "sqlite-users on behalf of Simon Slavin" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of slav...@bigfraud.org> wrote: On 29 Sep 2016, at 8:

Re: [sqlite] Regarding the effects of the COMMIT keyword

executes a few SELECT statements) returns 404. To me it seemed obvious that it was seeing an old state, but the question was why is it seeing an old state? PRAGMA synchronous is 2 (NORMAL, I believe?) Jim Borden Software Engineer jim.bor...@couchbase.com <http://www.couchbase.com/conn

[sqlite] Regarding the effects of the COMMIT keyword

. Really I’d just like to know if I’m barking up the wrong tree here trying to explain why this odd behavior occurs. Jim Borden Software Engineer jim.bor...@couchbase.com ___ sqlite-users mailing list sqlite-users@mailinglists.sq

Re: [sqlite] database problem with later Android Studio emulator

s/15326455/what-is-the-default-database-location-of-an-android-app-for-an-unrooted-device September 9, 2013 http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android <http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android&g

Re: [sqlite] 64-bit SQLite3.exe

er science textbooks give elegant examples using recursion, but then say the solution is not scale-able and give a less elegant solution using iterative techniques. Jim Callahan Data Scientist Orlando, FL On Tue, Aug 9, 2016 at 10:31 AM, Rousselot, Richard A < richard.a.rousse...@centurylink.com> w

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

TE TABLE) If "Step 1 Simple Load" does not complete; then may want to load a fixed number of rows into separate tables (per Darren Duncan) and then combine using an APPEND or a UNION query (doing so before steps 2 and 3). HTH Jim Callahan Data Scientist Orlando, FL On Wed, A

Re: [sqlite] File is encrypted or is not a database problem

, but gone upon later inspection on the command line). Jim Borden Software Engineer jim.bor...@couchbase.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] retrieve by name or index

hi,all There is a table include id,string1,string2 and so on. So I want to get the value of string1 from a record, there are two methods: 1. get by the name of the string2 2. get by the index of the string2, the index is 2 which one is faster?

Re: [sqlite] Sudden error 26 / 11

the database corrupted approximately 19 times in 147 runs). Jim Borden Software Engineer jim.bor...@couchbase.com On 6/30/16, 9:38 PM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Jim Borden" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of jim.bor...@couchba

Re: [sqlite] Sudden error 26 / 11

on the special thread but being executed on others. I read something that indicated that SQLite is never safe to be used from two threads at once, but it was labeled as outdated and seems to be contradicted by the newer information. I am only using one process in the program. Jim Borden Software

Re: [sqlite] Sudden error 26 / 11

if anything comes to mind. Jim Borden Software Engineer jim.bor...@couchbase.com On 6/24/16, 4:25 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Richard Hipp" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of d...@sqlite.org> wrote: >On Thu, Jun 23, 2016 at

[sqlite] Sudden error 26 / 11

advice. --Jim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sql

hi all a table as follow: id score 210 3 20 5 10 3 20 2 30 2 30 how could I select the table as follow and the count can tell me: the id 2 hava 3,the id 3 have 2 the id 5 have

[sqlite] Incremental backup/sync facility?

Doesn't this eliminate the use of prepared statements? On 5/6/2016 11:10 AM, Jeffrey Mattox wrote: > As an aside, this is how Apple syncs Core Data to iCloud (and then to > multiple iOS devices) if the backing store uses SQLite (the default). When a > small amount of data changes (which is

[sqlite] sqlite fixed data loading extension

ft has purchased Revolution Analytics and is now supporting a version of R. https://mran.revolutionanalytics.com/open/ Jim Callahan Orlando, FL On Fri, Mar 25, 2016 at 7:49 AM, Don V Nielsen wrote: > I have a need for something that can parse and load into sqlite tables > fixed length

[sqlite] Article about pointer abuse in SQLite

nitialized variables are allowed and memory is not automatically set to zero the program will have non-deterministic run-time behavior because of the random clutter in memory. Jim Callahan <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_t

[sqlite] jude a record is exist or not

mber of records >found. This may be faster only if id has a primary key or unique constraint or >is the first field of a declared index. > >-Urspr?ngliche Nachricht- >Von: sqlite-users-bounces at mailinglists.sqlite.org >[mailto:sqlite-users-bounces at mailinglists.sqli

[sqlite] jude a record is exist or not

first field of a declared index. > >-Urspr?ngliche Nachricht- >Von: sqlite-users-bounces at mailinglists.sqlite.org >[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Jim >Wang >Gesendet: Donnerstag, 10. M?rz 2016 09:01 >An: sqlite-users at maili

[sqlite] jude a record is exist or not

hi,all As usual, we judge a record is exist or not in a data base is :select id from table_name. Except the above method, Is there any method which could judge a record is exist or not much faster than the above method. I am looking forward to hearing from you. Jim Wang.

[sqlite] Changing the default page_size in 3.12.0

ck?). For example, if one encountered an old file, would it be enough to rebuild the indices? ? Or is it simply a matter of closing the file? (close the file with the old version and open the file with the new?). I haven't read the source code so I don't know what assertions, checks or assumptions SQLi

[sqlite] Changing the default page_size in 3.12.0

ratio). With a 2:1 ratio, in terms of seek time, one gets the second page for free. Would 8096 bytes (8K) be too much for a multi-tasking embedded device (such as a smart phone?). Are there any benchmarks? Jim On Fri, Mar 4, 2016 at 10:48 AM, Richard Hipp wrote: > The tip of tr

[sqlite] Database is locked (wal) - purely from read-only connections/queries

Are you using any SQL VIEWs? "You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite." http://sqlite.org/lang_createview.html Jim On Mon, Feb 29, 2016 at 10:31 PM, Vince Scafaria wrote: > Richard, I can confirm that having a writable connection open first, prio

[sqlite] Page_size

hi,all Could different page_size do impact on the speed of retrieving record? Is page_size 8192 faster than page_size 1024 or page_szie 4096? or The pagesize has nothing to do with the retrieving speed. Best reagard! Jim Wang.

[sqlite] Encrypt the SQL query

ks). "Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won?t usually need your flowcharts; they?ll be obvious." Fredrick Brooks, Mythical Man-Machine Month, page p. 102-3 https://en.wikiquote.org/wiki/Fred_Brooks Jim Call

[sqlite] How to modify page_size

hi,all How could I modify the page_size of the Data base? I use the following method, but could not change the page_size. nRet = sqlite3_exec(m_pDB, "PRAGMA page_size=8192;", 0,0,); Why? best regards. Jim Wang.

[sqlite] Performance comparison between SQLite and SQL Server?

benchmark available on this page, but now that you understand the use cases, this particular benchmark is not that useful in addition to being out of date and unfair. https://www.sqlite.org/speed.html Jim Callahan Data Scientist https://www.linkedin.com/in/jamesbcallahan Orlando, FL On Mon, Feb 15

[sqlite] Efficient relational SELECT

entries start out as NA. As rooms are booked NAs are replaced with IDs from booking-transaction table. Jim <https://www.avast.com/sig-email> This email has been sent from a virus-free computer protected by Avast. www.avast.com <https://www.avast.com/sig-email> <#DDB4FAA8-2DD7-40BB-A1

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

a problem with the JDBC/ODBC specs, the implementations or is the entire technical approach beyond redemption? Jim Callahan Orlando, FL <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> This email has been sent from a vir

[sqlite] Best way to store only date

> the century? I prefer the oldfashoned yymmdd. > The advantage of the four-digit year is that it can be used for sorting > over a wide range. Let's not create a Y2100 problem; right after fixing Y2K! ;)

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

h attribution from Zentus) https://github.com/crawshaw/sqlitejdbc I am hopeful this new JDBC based interface will provide as satisfactory high level channel between SQLite3 and Python. Jim Callahan On Thu, Jan 7, 2016 at 7:55 PM, Warren Young wrote: > On Jan 7, 2016, at 5:22 PM, Jim Callahan &

[sqlite] Parsing the contents of a field

Might be doable with a recursive CTE On 1/13/2016 1:22 AM, Bart Smissaert wrote: > It probably can be done with just SQLite's built-in text functions such as > instr and substr, > although with 20 to 30 items it may get a bit messy and complex. > > RBS > > On Wed, Jan 13, 2016 at 5:42 AM, audio

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

ice. Just a wishlist idea. No rush for me because I am happy in R and will probably be moving from SQLite to client server SQL database before I move from R to Python, Julia or Java. Jim Callahan Orlando, FL <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_co

[sqlite] about attach database

You cannot attach to this list. If you can just paste into the body of the email or provide a link to the information *Jim Dodgen* On Tue, Dec 15, 2015 at 9:33 PM, ??? <2004wqg2008 at 163.com> wrote: > > After testing the Sqlite3_open and ATTACH DATABASE, >

[sqlite] Exporting

Copying the file to another computer would likely work; except if the application encrypted the data. Jim On Sun, Dec 6, 2015 at 5:22 PM, Simon Slavin wrote: > If you cannot run any program apart from the ones already installed then > your only option is to copy the database file to a

[sqlite] Random performance issues with SQLite

I am not a user of Norton but I expect it has the same features as others. In Windows Defender you can specify files to exclude and that may help. *Jim Dodgen* On Mon, Nov 9, 2015 at 8:44 AM, Richard Hipp wrote: > On 11/9/15, Brice Andr? wrote: > > OK, but if this

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

ype = 1//SHARED_LOCK lastErrno = 6//ERROR_INVALID_HANDLE Thoughts? On 11/3/2015 6:12 PM, Jim Morris wrote: > I have a connection used by the main (UI) thread and recently added a > background thread, with own connection(no shared cache) to upload > changes to server on Windows Mo

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

No. The app works, however when I scroll the list there are may requests to get records from the DB and it seems to interact with the background thread to produce this error. On 11/3/2015 7:02 PM, Joe Mistachkin wrote: > Jim Morris wrote: >> Is there a graceful wo

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

I have a connection used by the main (UI) thread and recently added a background thread, with own connection(no shared cache) to upload changes to server on Windows Mobile 6.0/6.5 devices and upgraded to SQLite 3.9.2. The background thread is getting an error 10, extended error 3850 as a

[sqlite] Moving from Sqlite 3.5.9 to 3.9.1

First, I was able to drop in the 3.9.2 sqlite.c and sqlite.h files, build and run the app without compiler, linker or other apparent errors. Great job by dev team! Our Windows Mobile 6.x app has been using SQLite 3.5.9, threading mode=1. I added a background thread, with its own connection

  1   2   3   4   5   6   7   >