Re: [sqlite] Problems loading extensions on Windows 10

As indicated by "Random Coder", the problem was that I was missing the required dependencies. Thank you. On Tue, Mar 5, 2019 at 8:03 PM Thomas Kurz wrote: > Are both of the same architecture, either 32bit or 64bit? > > - Original Message - > From: Ky

[sqlite] Problems loading extensions on Windows 10

I am having problems loading sqlite3 extensions on Windows 10. I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and copied them to C:\Windows\System32. When I run SELECT load_extension('mod_spatialite') sqlite returns "Error: the specified module could not be found" I

[sqlite] Equiv stmts, different explain plans

On another DB I came across 2 stmts, that I think are equivalent, but generated different explain plans. I request a second opinion - are these 2 stmts equivalent? If so, why do they generate different explain plans even on sqlite? TIA -- create table t1(c,d); create table t2(c,d); explain

[sqlite] Question about hidden columns

Hello All, I am relatively new to sqlite and I have a question about using input parameters to constrain hidden columns in a query, described in section 2.1.2 here: https://www.sqlite.org/vtab.html#table_valued_functions The

Re: [sqlite] Fossil Feature Request

> sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users I think what you want is already supported: https://www.sqlite.org/src/artifact/810fbfebe12359f1?ln=155 -- Kyle __

Re: [sqlite] SQLite3Close returns SQLITE_BUSY after executing PRAGMAs

On 05/01/2017 23:14, Simon Slavin wrote: On 5 Jan 2017, at 11:11pm, Kyle <kmccord0...@gmail.com> wrote: Under version 3.16.1, SQLite3Close is returning SQLITE_BUSY when I open a database, execute some PRAGMAS, (run some stmts) then attempt the close. This did not occur under version

[sqlite] SQLite3Close returns SQLITE_BUSY after executing PRAGMAs

Dear all, Under version 3.16.1, SQLite3Close is returning SQLITE_BUSY when I open a database, execute some PRAGMAS, (run some stmts) then attempt the close. This did not occur under version 3.15.2, nor does it occur under the new version if I omit the PRAGMAs. Furthermore the PRAGMAs now seem

[sqlite] Why are there no Authenticode signatures on prebuilt DLLs or tools?

for local persistence of infection because they prevent the implementation of Windows Software Restriction Policies that prevent all unsigned code from running. Thanks for your time! -Kyle H

[sqlite] News typos

I just noticed that the version links for the last two releases at: http://sqlite.org/news.html seem to be cut/paste errors, 3.8.7.3 and 3.8.7.4 both have links to the 3.8.7.2 release. -- Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] fts5

On Thu, Sep 11, 2014 at 9:58 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 09/11/2014 02:51 AM, Kyle Shannon wrote: >> >> I was browsing the source on the fossil repository, and I noticed that >> there were files for fts5 in the trunk. I've been playing with fts3

[sqlite] fts5

I was browsing the source on the fossil repository, and I noticed that there were files for fts5 in the trunk. I've been playing with fts3/4 and I'm curious about what new features/changes are incorporated into fts5. Can anyone clarify that for me? Thanks. -- Kyle

Re: [sqlite] size_t printf standard (was: SQLite4 (don't scream))

On June 28, 2012 09:46:06 PDT, Stephan Beal wrote: - There are no standard printf()/scanf() specifiers for it, which means those funcs cannot be used with size_t or ifdefs or casts are needed to handle them portably. Perhaps you should actually check the standard before making such a

Re: [sqlite] Testing the ODBC link

at: http://www.ch-werner.de/sqliteodbc/html/sqlite3odbc_8c-source.html Then look at the source starting around line 10643. Finally if you want to get an SQLite3 table list via ODBC, you can always do something like: SELECT name FROM sqlite_master WHERE type = 'table'; Kyle P.S. As Si

[sqlite] Query Planner Bug With Simple Reproduction on 3.7.11

other lists them out yet the first query results in use of the indices whereas the second does not. -- Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3 .dump file does not recreate database

The "Error: near line 10: column val is not unique" output is unexpected when loading the created .dump file. This session demonstrates the issue: $ /tmp/sqlite3 SQLite version 3.7.11 2012-03-20 11:35:50 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> SELECT

Re: [sqlite] auto-incrementing integer in composite primary key (SQLite3 Solution)

aint and then add a separate CREATE INDEX for the id column so that the SELECT MAX(id) expression remains efficient in the context of a large number of rows. --Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Using multiple versions of sqlite on the same system

to use the two different versions of Sqlite on the same system on the same database? Thanks, Kyle Jordan Senior Software Engineer L.B. Foster Company - Salient Systems 4393-K Tuller Rd Dublin, OH 43017-5008 phone: (614) 792-5800 EX 4637 fax: (614) 792-5888 email: kjor...@salientsystems.com

Re: [sqlite] Commit method not available

Thanks! - Original Message - From: "Joe Mistachkin" <sql...@mistachkin.com> To: "'General Discussion of SQLite Database'" <sqlite-users@sqlite.org> Sent: Sunday, February 12, 2012 1:40 PM Subject: Re: [sqlite] Commit method not available Kyle Ca

[sqlite] Commit method not available

I'm using the drivers from sqlite-netFx40-setup-bundle-x86-2010-1.0.79.0.exe in VS2010, .NET 4. Connection.BeginTransaction is available as a method, but Connection.Commit is not, nor is Connection.Rollback. What am I missing? ___ sqlite-users

Re: [sqlite] Xcode warning on 3.7.10

eeBSD includes clang by default starting with version 9.0). Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Disk I/O Error

On November 1, 2011 08:48:25 PDT, Richard Hipp wrote: On Tue, Nov 1, 2011 at 10:40 AM, Korey Calmettes wrote: When we are able to reproduce the problem again, I will run these checks. It's fairly random however consistent. I will e-mail the results to you later

Re: [sqlite] Big FLOAT bug

precision decimal text and back unchanged (if you believe the implied bit should not be counted, that's 22.2%). -- Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite shell text wrapping?

);TomVALUES( Please someone help whats the best way to get all this info in a .sqlite database by copy past. Also if there is a good tutorial out there could i please get the link.  Thank you Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] VACUUM can actually increase the DB file?

444920832 newdb.sq3 Admittedly that's only about 0.4% growth in size, but I too was under the impression that vacuum did not grow the database size. Subsequent vacuum commands do not seem to grow the database any further. Kyle ___ sqlite-use

Re: [sqlite] [csv extension] feedback

sv MIME type: http://tools.ietf.org/html/rfc4180 Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_DEFAULT_FOREIGN_KEYS support please

if support for enabling foreign keys by default could make it into the official distribution. Then you could just add -DSQLITE_DEFAULT_FOREIGN_KEYS=1 to the compiler options to have foreign keys always enabled by default. Anyone else interested in having support for this compiler option? Kyle

[sqlite] How to detect SQLITE_ENABLE_FTS3_PARENTHESIS support?

mmended way to check for SQLITE_ENABLE_FTS3_PARENTHESIS support? Thanks, Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Non-exclusive reserved lock?

Hi, I'm currently looking into SQLite for a website written in PHP. While I don't have any scaling issues yet, I've been looking into how to optimize SQLite performance, especially with regard to transactions. In essence what I'm looking for is a way to defer database writes in a process

Re: [sqlite] Tiger: Error: file is encrypted or is not a database

On Jun 6, 2005, at 10:36 AM, Helmut Tschemernjak wrote: Hello, I try to look into the sqlite database in Mac OS X Tiger at: /.Spotlight-V100/ I cannot dump any data or schema and the file magic is not containing sqlite. The data is not encrypted. It looks like the file is incompatible

[sqlite] A questionable bit of code

ked in the 3.2.1 source and this bit of code is the same. -Kyle