Re: [sqlite] unsafe use of virtual table

Ah I see now. Thank you Keith! Tom Message: 14 Date: Tue, 04 Feb 2020 14:57:06 -0700 From: "Keith Medcalf" To: "SQLite mailing list" Subject: Re: [sqlite] unsafe use of virtual table Message-ID: <62147479ae781d49902e13c3c23a3...@mail.dessus.com> Content-Type: text/pla

[sqlite] unsafe use of virtual table

e point me to where I can find more info on unsafe use of virtual tables? Thanks Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unexplained table bloat

On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: > On Sunday, 12 January, 2020 09:03, Tom Browder > wrote: > >Am I missing something? I thought every column has to have a type? > > Close, but no banana. Every value has a type. A column may contain > multiple valu

Re: [sqlite] Unexplained table bloat

Am I missing something? I thought every column has to have a type? -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Release date of 3.30.1

at 2018-11-05 20:37, but still lists its release date as 2018-11-05. Thanks Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_USE_ALLOCA compile time option on FreeBSD

, and alloca() cannot determine such an error. Avoid alloca() with large unbounded allocations. FreeBSD 12.0-RELEASE-p9September 5, 2006 FreeBSD 12.0-RELEASE-p9 Not a big deal, just a little confusing for alloca() to be recommended yet discouraged by OS. Tom

Re: [sqlite] Things you shouldn't assume when you store names

On Mon, Nov 11, 2019 at 15:28 Tom Browder wrote: > See the entry point for the language at <https://raku.org>. > Oh, and there are Debian packages available, too. -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Things you shouldn't assume when you store names

r RDBMS systems. See the entry point for the language at <https://raku.org>. Best regards, -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error when renaming a table when an invalid view exists in the schema

Thanks Keith. LEGACY_ALTER_TABLE=ON lets me change the table name without error. But the docs say "New applications should leave this flag turned off." Is there any other way of checking if the schema is invalid besides attempting to change the name of a table? I went through the pragmas and co

[sqlite] Error when renaming a table when an invalid view exists in the schema

n 3.29 just in case something changed recently. Thanks Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] logically stored rows

actual table. Those were all helpful explanations, thanks guys, Tom > Hi, > > In this page in the docs: https://sqlite.org/queryplanner.html#searching > > it says: > "The rows are logically stored in order of increasing rowid" > > Would this imply that executin

[sqlite] logically stored rows

e" would return all the rows in ROWID order because that is how they are stored. Thanks Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Documentation correction

the integer primary key: CREATE TABLE t(rowid integer primary key); insert into t values(15); select rowid, oid from t; Results: 15|15 Thanks, Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why no persistent user settings in a database file?

On Wed, Apr 3, 2019 at 06:57 R Smith wrote: > Hi Tom, ... > About the CLI - It's a very useful piece of toolkit, but it's intent is ... > For more usability, there are a few good options in the World from CLI's > to GUI's. I see you already know SQLite studio, s

Re: [sqlite] Why no persistent user settings in a database file?

On Wed, Apr 3, 2019 at 05:52 Tom Browder wrote: > After coming back to SQLite from a long absence, I was surprised that > setting things like .mode and .headers in a database didn't stay that way > after exiting the file. > ... Okay, I agree with all the excellent arguments

Re: [sqlite] Why no persistent user settings in a database file?

On Wed, Apr 3, 2019 at 05:52 Tom Browder wrote: > After coming back to SQLite from a long absence, I was surprised that > setting things like .mode and .headers in a database didn't stay that way > after exiting the file. > > Then I remembered something about a resource file

[sqlite] Why no persistent user settings in a database file?

stent settings I wanted. However, would it not be more natural to keep those settings persistent inside the db file? Thanks, -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/s

[sqlite] Missing docs: sqliterc, lint

I have not been able to find any docs on the site about .sqliterc or lint. There is some information on sqliterc in the mailing list archives, and there is: sqlite3> .help lint But if one is not already aware of either one, how does one find out about them? Best regards, -

Re: [sqlite] Can I get help with db design for SQLite use?

On Wed, Apr 3, 2019 at 02:50 Shawn Wagner wrote: > Yay Perl! My favorite language. DBD::SQLite is definitely one of the > better, fuller featured sqlite bindings out there. Though Tom is using > perl6, not perl5. I have no idea how its version compares. ... Glad to hear, Shawn, and t

Re: [sqlite] Can I get help with db design for SQLite use?

On Wed, Apr 3, 2019 at 02:08 Rob Willett wrote: > Tom, > > We use the Perl DB::SQLite module. It works very well and I cannot > recall a single issue with it in the last four years. There's not as > much support for Perl on this mailing list as it's not as popular, b

Re: [sqlite] Can I get help with db design for SQLite use?

On Tue, Apr 2, 2019 at 18:21 Tom Browder wrote: > On Tue, Apr 2, 2019 at 17:30 am...@juno.com wrote: > >> You might want to import everything into SQLite Studio > > It's SQLite Studio, and i used it a bit many years ago, but it has had a recent update so I will give it a

Re: [sqlite] Can I get help with db design for SQLite use?

roup how you made out. May it work for you. Peace! Alex Thanks for the idea, Alex. I'm doing all programmatically at the moment (using a Perl 6 module: DB::SQLite), but using one of those tools you mentioned would help in design for sure! -Tom ___

Re: [sqlite] Can I get help with db design for SQLite use?

On Tue, Apr 2, 2019 at 10:40 AM Don V Nielsen wrote: > > > Do be aware that almost all of us are just users like you. > > And be aware these guys are freakin brilliant. No lie. I don't doubt it at all, but thanks for the warning, Don! -Tom __

Re: [sqlite] Can I get help with db design for SQLite use?

On Tue, Apr 2, 2019 at 10:26 Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > I need help with a db design to be modeled for use with SQLite. The design > > uses foreign keys and I am just now using the foreign pragmas and other > > parts of SQLite t

[sqlite] Can I get help with db design for SQLite use?

I need help with a db design to be modeled for use with SQLite. The design uses foreign keys and I am just now using the foreign pragmas and other parts of SQLite to help me make it all work together. Is this list appropriate for presenting my design and requesting advice? Best regards, -Tom

Re: [sqlite] WITHOUT ROWID tables with a ROWID

Ah I see now. Sorry I should have read the docs more carefully -- it is working according to spec in all cases. Great answers. Thanks guys! Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] WITHOUT ROWID tables with a ROWID

Ah I see now. Sorry I should have read the docs more carefully -- it is working according to spec in all cases. Great answers. Thanks guys! Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

[sqlite] WITHOUT ROWID tables with a ROWID

familiar with SQLite create a table with a column named "rowid" that is not an integer (in table t4 below). Are tables t3, t4, and t5 below working as designed? Thanks and I really enjoy using SQLite and reading this mailing list. Tom SQLite version 3.27.1 2019-02-08 13:17:39 Enter &

Re: [sqlite] Cannot delete a Database file?

__ From: sqlite-users on behalf of Richard Hipp Sent: Wednesday, 28 June 2017 7:55 PM To: SQLite mailing list Subject: Re: [sqlite] Cannot delete a Database file? On 6/28/17, Domonic Tom wrote: > > Would anyone know how to go about making sure that the database file is not > busy and can

[sqlite] Cannot delete a Database file?

After calling sqlite3_close(handle) I try then to use the 'remove' method in C++ to delete my .db file. For some reason it just won't delete. It's hard to show you the whole project because it's large. I believe this has something to do with sqlite3_close only de-allocating the connection to

[sqlite] Bug Report: https://www.sqlite.org/chronology.html out of date

In lieu of an official support RSS feed, https://www.sqlite.org/chronology.html is used to detect new versions of SQLite and how out of date the current one embedded in a product is. It worked for the past several months, but now this page is out of date. =) -tom

Re: [sqlite] Index storage space

Thanks Clemens. From: Clemens Ladisch Sent: 20 May 2017 09:11 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Index storage space xTom Byars wrote: > I’m aware that a column value of 1 will use less bytes in a

Re: [sqlite] Can the Explain explain what is going on here?

Thanks Simon. I solved the issue by making sqlite3 *dbhandle = NULL then testing it for a null value afterwards. It works fine. From: sqlite-users on behalf of Simon Slavin Sent: Wednesday, 4 January 2017 9:47 AM To: SQLite mailing list Subject: Re: [sqli

[sqlite] Testing Sqlite3* DB_handle?

Is there a way to test whether the DB_handle used when opening a database is good? I need to find some way of testing it to make sure it represents the live connection to a database? Is that possible? Thanks ___ sqlite-users mailing list sqlite-use

[sqlite] Get Table names from Database in C++?

Would anyone know how to get the table names from a specific database in C++ or just using the C API for sqlite? I have tried the below but I get nothing. Thought I might be able to move the list of names into a table but it doesn't seem to want to work. Clearly I can't do this using sql.. A

[sqlite] Typographical error in sqlite.org/howtocorrupt.html

to hold content added *but* subsequent inserts. Change 'added *but* subsequent inserts.' to 'added *by* subsequent inserts.' Peace, Tom Eubank --- Explanation, only if needed: * It seems most likely that this paragraph intends to mean: "pages in the fr

[sqlite] Searching this mailing lsit

6. With Mail-Archive.com having no data for > 2013, it returns results only from 2016. > > Tom > > > On May 20, 2016, at 9:19 PM, Kasajian, Kenneth > wrote: > > > > When I attempt to search the archives of this mailing list for the word: LSM_CONFIG_AUT

[sqlite] Searching this mailing lsit

chive.com having no data for 2013, it returns results only from 2016. > > Tom > >> On May 20, 2016, at 9:19 PM, Kasajian, Kenneth > schneider-electric.com> wrote: >> >> When I attempt to search the archives of this mailing list for the word: >> LSM

[sqlite] COLLATE NU800_NOCASE as a loadable extension?

that has a flawed collation so named. I would like to try it, too. Tom

[sqlite] Database connection from within Visual Studio 2010

I'm trying to add the capability to do development of applications that connect to an SQLite database using Visual Studio 2010 Premium. I've downloaded and run sqlite-netFx40-setup-x64-2010-1.0.94.0.exe. I selected a custom install and made sure that all options were selected. I believe that all th

Re: [sqlite] WHERE expression with operators from text functions?

execute it. Tom > On Oct 16, 2014, at 12:55 PM, Tom Holden wrote: > > I think you are right. The FTS MATCH looks like it should function the way > I want. > > Thanks, Richard! I will now learn how to use FTS... > > Tom > >> On Thu, Oct 16, 2014 at 12:20 PM

Re: [sqlite] WHERE expression with operators from text functions?

I think you are right. The FTS MATCH looks like it should function the way I want. Thanks, Richard! I will now learn how to use FTS... Tom On Thu, Oct 16, 2014 at 12:20 PM, Richard Hipp wrote: > On Thu, Oct 16, 2014 at 12:03 PM, Tom Holden wrote: > > > Coming up with a subject wa

[sqlite] WHERE expression with operators from text functions?

7;+', '%'''||' AND [Value] LIKE '||'''%')||'%''' produces [Value] LIKE '%string1%' AND [Value] LIKE '%string2%' AND [Value] LIKE '%string3%' but WHERE (above SELECT...) evaluates to FALSE I ne

[sqlite] Whats the SQLite Encryption Algo?

I noticed that in C# I can set a password using SetPassword. Does this encrypt the entire database? If so, What algorithm precisely does it use? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/

Re: [sqlite] How to determine player's leaderboard rank efficiently?

Alessandro - THANK YOU! I've implemented this and item 2 is now averaging 0.02 ms. You made my weekend. Really appreciate your help as well as the input of the other folks. Tom -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-determine-player-s-leaderboard

[sqlite] How to determine player's leaderboard rank efficiently?

ers, but I need something that would take just minutes. Would appreciate any ideas. Thanks Tom -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-determine-player-s-leaderboard-rank-efficiently-tp77445.html Sent from the SQLite mailing list archive at Na

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

No operations return BUSY or LOCKED, and I don't use any mutexes. Anyway I wanted to share these results and see if you had any comments. Cheers Tom -- View this message in context: http://sqlite.1065341.n5.nabble.com/Does-SQLite-lock-the-entire-DB-for-writes-or-lock-by-table-tp76921

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

> On Fri, Jul 25, 2014 at 4:46 AM, Tom <[hidden email] > <http://user/SendEmail.jtp?type=node&node=76965&i=0>> wrote: > > > I probably should have read the bit about concurrency on > > http://www.sqlite.org/whentouse.html huh :-) > > Although in my de

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

I probably should have read the bit about concurrency on http://www.sqlite.org/whentouse.html huh :-) Although in my defense, my need for write concurrency is new. I do wonder if 2 DB's will work well. On Fri, Jul 25, 2014 at 1:58 PM, Tom Spencer-Smith wrote: > > This seems like a r

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

Maybe I should consider MySQL before considering NoSQL. On Fri, Jul 25, 2014 at 10:49 AM, Tom Spencer-Smith wrote: > > Thanks guys, I have already tried WAL and it does speed things up, but I > still need the daily processing to be done asynchronously. The computations > are complex, invo

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

DB for the leaderboard results, since a separate table won't work 5. Switch to NoSQL 6. Look at the feasibility of holding results in memory and incrementally injecting them into the player table 7. Some other ideas? Cheers Tom On Fri, Jul 25, 2014 at 7:13 AM, Simon Slavin-3 [via SQLite]

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

OK that's what I figured. My application presently does all the DB operations on the main thread. But once a day I need it do the player leaderboards, which could be 500K players or so, hence several minutes. I can't have the main thread blocking for any significant length of time - a second or s

[sqlite] Does SQLite lock the entire DB for writes, or lock by table?

ng to table B. But I get the impression the entire DB is locked - is that correct? My code will be simpler if I don't ever have to deal with SQLITE_BUSY. Cheers Tom -- View this message in context: http://sqlite.1065341.n5.nabble.com/Does-SQLite-lock-the-entire-DB-for-writes-or-lock-by-tab

[sqlite] Async I/O not working for me on v 3.8.5

Test code follows. The update query takes 3 seconds with or without the async code. Any ideas? void Async_Thread() { sqlite3async_run(); } //- void CDatabase::Init(void) { int rc = 0;

Re: [sqlite] False Error 'no such collation sequence'

> > Bogdan Ureche > author of SQLite Expert Me bad. I found the option to turn on extension support in the menu. And thanks to Jean-Christophe Deschamps, I now have a variant of the unifuzz.dll extension which does what I want not only in your SQLite Expert Personal but also in th

Re: [sqlite] False Error 'no such collation sequence'

Richard Hipp drh at sqlite.org Fri Jun 21 00:15:56 EDT 2013 wrote: Can you not compile your custom collation sequences into a loadable extension (a DLL or shared library), then load that extension into your SQLite shell? http://www.sqlite.org/loadext.html - Tom replies: With Ralf&#

Re: [sqlite] False Error 'no such collation sequence'

Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote: On 19.06.2013 17:18, Tom Holden wrote: I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. You must be mistaken. As the author of SQLiteSpy, I can clearly say that there is

Re: [sqlite] False Error 'no such collation sequence'

optimiser. Thanks for your attention. Tom ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] False Error 'no such collation sequence'

throw the error. From my perspective, this is a bug that limits the tools available to work with a proprietary database to fewer than there used to be – the command line shell being one rendered incapable. Tom ___ sqlite-users mailing list sqlite-users

Re: [sqlite] inner vs. outer join inconsistency

> I would agree that no warning is needed for for columns that don't state > any affinity, or for a non-affinity FK that refers to some PK with > affinity. > > I tend to agree with OP that an explicitly text foreign key referring to > an explicitly int primary key is probably worth a warning (p

Re: [sqlite] inner vs. outer join inconsistency

Richard Hipp writes: > > On Sun, Mar 3, 2013 at 2:48 PM, Tom Matrix wrote: > > > > > The following query reports 18900080 rows (after some computation time): > > > > Is this the correct answer for the query be

Re: [sqlite] inner vs. outer join inconsistency

Richard Hipp writes: > > On Sun, Mar 3, 2013 at 2:48 PM, Tom Matrix wrote: > > > > > I’ve encountered a problem, which is hardly reproducable on arbitrary > > databases, therefore I attached one. > > > > A simple, reproducible test case for (what we

Re: [sqlite] inner vs. outer join inconsistency

> Can you send the database directly to me at drh@... please? It's already sent, and is also available in this shared folder: https://docs.google.com/folder/d/0B7kiuyPBHpjqYm8wZmdNcGI3c1E/edit?usp=sharing ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] inner vs. outer join inconsistency

> First of all attachments are stripped out from this list, so nobody > saw your database. Sorry for that. Now I created a shared folder so everyone has access and can take a look at it: https://docs.google.com/folder/d/0B7kiuyPBHpjqYm8wZmdNcGI3c1E/edit?usp=sharing It contains the database and th

Re: [sqlite] inner vs. outer join inconsistency

> Could it be some of the features that SQLite doesn't support? > > http://www.sqlite.org/omitted.html > > /Patrik No, I think this problem is independent from those thing. Only basic SQL features are used. ___ sqlite-users mailing list sqlite-users@s

[sqlite] inner vs. outer join inconsistency

Hello, I’ve encountered a problem, which is hardly reproducable on arbitrary databases, therefore I attached one. The problem is that inner join omits the result on large datasets. But again, ’large’ does not necessarly refer simply the amount of data; I couldn’t reproduce it on different (arbitra

Re: [sqlite] Simple SQLite-based spreadsheet?

Why not use LibreOffice or OpenOffice with the odbc driver for SQLite? I do it with Excel a lot and just confirmed you can access it with these open source tools, too. On Fri, Dec 7, 2012 at 10:15 AM, Rob Richardson wrote: > There's several GUI-based SQLite tools available now. Maestro was alre

Re: [sqlite] SQLite3.dll for Win 64

On Fri, Jul 22, 2011 at 06:23, Everton Vieira wrote: > Please Help. I need an SQLite3.dll for Win 64? This link has Windows 64-bit binary installation packages--may find it in one of them: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki HTH Best regards, -Tom Tho

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Mon, Jul 11, 2011 at 01:18, H. Phil Duby wrote: > On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote: > >> On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder >> wrote: >> >> > sqlite db files and making sure that directory is writable by my web >> > serv

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Thu, Jun 30, 2011 at 15:02, Stephan Beal wrote: > On Thu, Jun 30, 2011 at 9:52 PM, Tom Browder wrote: > >> But I think the journal file is the problem...as I understand it, it >> has to be on disk, doesn't it? The answer seems to be yes. I have solved my problem

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Thu, Jun 30, 2011 at 14:44, Stephan Beal wrote: > On Thu, Jun 30, 2011 at 9:06 PM, Tom Browder wrote: ... >> Thanks, Richard (and Simon), I think I can solve my web access problem >> by giving the db file its own directory. ... > You can also try disabling the temp files

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Thu, Jun 30, 2011 at 13:42, Richard Hipp wrote: > On Thu, Jun 30, 2011 at 2:30 PM, Tom Browder wrote: ... >>  From my limited testing on my web server [temporary files] are >> written in the same directory as the db file, but I would like them to >> be written to

[sqlite] Can a sys admin control temporary file location without changing the source code?

TMPDIR variables but haven't seen that work. Is there any good solution without code changing for a sys admin? Thanks and best regards, -Tom Thomas M. Browder, Jr. Niceville, Florida USA ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] Query with UNION on large table

eeper than I'm comfortable with now but that's what I surmise from QUERY PLAN...). My observations are on two datasets of 100,000 records - one that has but one mirrored pairings in {0-65535}, the other with almost 45,000 mirrored pairings (45 distinct) i

Re: [sqlite] Query with UNION on large table

Is the Hard Drive thrashing? Could be that most everything is being done in swap files. Given the size of the table, a lot more RAM would help. Tom ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Query with UNION on large table

This is even faster, on a tiny table: SELECT n1, n2 FROM table1 INTERSECT SELECT n2, n1 FROM table1 WHERE n2 1 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Latest ADO.NET driver does not install properly?

ected. Has anyone else had the same problem? During the installation I chose to install the drive into GAC and generate the native version (or whatever it is called)... I'm running with Windows 7 and Visual Studio 2010.

Re: [sqlite] Automating the build of a sqlite database

Perhaps by adding .quit to your schema.sql Tom -Original Message- From: Maurice Marinus Sent: Friday, April 22, 2011 11:18 AM To: sqlite-users@sqlite.org Subject: [sqlite] Automating the build of a sqlite database So how would I get the batch file to run and terminate the sqlite

Re: [sqlite] Request for help with SQLite Query to return missingDate/Time Ranges

Could you not do this: Select A.time + 1 minute, B.time - 1 minute from log as A, log as B where A.RowID=B.RowID+1 and B.time-A.time > 1 minute Tom -Original Message- From: Andrew Lindsay Sent: Wednesday, April 20, 2011 7:34 PM To: sqlite-users@sqlite.org Subject: [sqlite] Request

[sqlite] SQLite Introspection

I'm working with the Tcl interface to SQLite and am trying to do introspection on the schema. I've figured out how to do databases, tables, views, table columns, indexes, foreign keys, and the pragma settings but I'm having trouble with triggers and analyze. The documentation for the analyze comman

Re: [sqlite] no such table error.

Yes, that's it! Thanks. On Mon, Jun 14, 2010 at 3:56 PM, P Kishor wrote: > On Mon, Jun 14, 2010 at 5:53 PM, Tom Lynn wrote: > > I'm fairly new to sqlite and generally use databases with single tables > for > > use with my PERL scripts. I've encounte

[sqlite] no such table error.

uption? INSERT INTO trunks ( store, trk_date, grp_num, grp_size, grp_type, grp_dir, meas_hour, usage, seizures, inc_seizures, grp_overflow, queue_size, queued, que_overflow, que_abandoned, out_service, percent_atb, out_block ) VALUES ( 001, '6/04/2010', 12, 24, 'tie', 'two&

Re: [sqlite] page_size

ah - good to know. that is what i was looking for. thanks tom On Apr 25, 2010, at 10:21 PM, Dan Kennedy wrote: > The page formats use 16-bit unsigned integers to store various offsets > (in bytes) to cells and free-blocks within a page. So it definitely > won't work with gre

Re: [sqlite] page_size

e_size greater than the recommended (required?) max of 32k. thanks tom On Apr 21, 2010, at 1:39 PM, D. Richard Hipp wrote: > > On Apr 21, 2010, at 4:37 PM, Pavel Ivanov wrote: > >> I don't know anything about internal support of pages bigger than 32k. >> But I wa

[sqlite] page_size

i've read in the docs that SQLITE_MAX_PAGE_SIZE can't be > 32k (below). is this limitation still valid? we have an embedded FS that is _very_ slow and performs best w/ a write page size of 256k. will bad things happen if i configure SQLite w/ 256k pages? thanks tom Maximum

Re: [sqlite] Case-sensitivity, performance and LIKE

- Original Message - From: "Jay A. Kreibich" To: "General Discussion of SQLite Database" Sent: Tuesday, March 30, 2010 9:26 PM Subject: Re: [sqlite] Case-sensitivity, performance and LIKE > On Tue, Mar 30, 2010 at 08:41:09PM -0400, Tom Holden s

Re: [sqlite] Case-sensitivity, performance and LIKE

LATE NOCASE > > then all sorting and SELECT queries on it will ignore case. > You don't even have to change the defined collation as you can impose the NOCASE collation in the SELECT statement as: SELECT * from Customers WHERE LastName = 'Shaw' COLLATE NOCASE AND FirstName

[sqlite] Pagesize and performance

longer required, i.e. could possibly compile w/ larger max pagesize (and thus larger pagesize) 4. larger pagesize will cause more data to be read from file system to do a read (i.e. an entire page must be read) thanks tom

Re: [sqlite] Prohibitive indexing time with large tables

> His original question was about the todo list found at the wiki. > Not sure if any of the core developer will answer, but I would > be interested as well... I too have been long interested in when this might be addressed, since we see similar performance drop-offs with large numbers of rows.

Re: [sqlite] Passing Value from one query to another

a "subquery" in the second, like this: >> >> SELECT monitordata_hourly.deviceaddress, >> Round(Sum(monitordata_hourly.ch1kwh),3) AS SumOfch1kwh, >> Round(Sum(monitordata_hourly.ch1kwh),3)*(select kwhcost1 from >> applications) AS SumOfch1kwh_cost >> FROM m

Re: [sqlite] update on Ticket 3437

ery be better composed as: SELECT * from races, times WHERE RACEID = ID and Races.Name = 'totley moor' AND Date LIKE "2009%"; Tom - Original Message - From: To: Sent: Saturday, January 23, 2010 7:59 PM Subject: [sqlite] update on Ticket 3437 > Hi, > I submitte

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

and a crash by 3.6.21. Tom - Original Message - From: "Pavel Ivanov" To: "General Discussion of SQLite Database" Sent: Thursday, January 21, 2010 9:36 AM Subject: Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline > I am unable to reproduce this problem.

[sqlite] Speed regression after 3.6.17

replace my sqlite3.dll from 3.6.22 with one from 3.6.17. I confirmed the improvement in speed. The query involves the UNION ALL of 5 SELECTs of 4 tables with INNER JOINS plus a self-JOIN on 2 of the SELECTs and an ORDER BY on 1 field. Regards, Tom

Re: [sqlite] begin transaction

from shared to reserved and thus fail immediately? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tom Broadbent Sent: Monday, November 23, 2009 12:36 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] begin

Re: [sqlite] begin transaction

is a bug but i've tried to be very explicit about finalizing/resetting statements. thanks tom -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday, November 23, 2009 11:34 AM To: General Discussion

Re: [sqlite] begin transaction

read operation. so possibly i've (inadvertently) hit the 'shared lock upgrade to reserved lock' immediate fail. thoughts? thanks tom -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday

[sqlite] begin transaction

would expect that proc B would wait 10 sec trying to begin transaction rather than fail immediately. is this expected? thanks tom __ This email has been scanned by the MessageLabs Email Security System. For more information please

Re: [sqlite] shared cache mode and 'LOCKED'

eads can all write at the same time, if they write to different tables. But, if two threads write try to the same table at the same time, one of them will return SQLITE_LOCKED. John -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Beh

Re: [sqlite] shared cache mode and 'LOCKED'

ication, because otherwise contention is too great. John -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tom Broadbent Sent: Wednesday, October 28, 2009 3:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] sha

Re: [sqlite] shared cache mode and 'LOCKED'

and here is the link to the thread where i received the below advice: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2009-October/016404.html -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tom Broadbent Sent

  1   2   3   >