Re: [sqlite] SQLite.so dynamic library-linux

ble to test one of your targets too. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Udon Shaun Sent: Friday, March 18, 2011 11:47 PM To: Pavel Ivanov; SQLite Subject: Re: [sqlite] SQLite.so dynamic library-linux @Pa

[sqlite] Handle leak using IIS on windows 7?

? I'm using the Precompiled Binaries for 32-bit Windows (.NET Framework 4.0) from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki(32 bit mode enabled on iis), but I've tried the 64-bit version with the same result. Cheers, Doug

Re: [sqlite] Handle leak using IIS on windows 7?

view ends the file handle is automatically released). If you want to see it in action, create a new MVC project and add: DbLogger.Get(); To the home index page. Run it in debug mode and you'll see the issue. Cheers, Doug. code (in case the attachment fails): using System; using System.Collectio

Re: [sqlite] Handle leak using IIS on windows 7?

This was exactly the problem; I didn't realize the 'static' variables are persisted between page views in ASP.Net Adding an '_instance = null;' fixed the issue. Thanks muchly. Cheers, Doug. On Tue, Jul 19, 2011 at 11:58 AM, Joe Mistachkin <sql...@mistachkin.com>wrote: > > A

[sqlite] Many master journal files

2003. Thanks for any ideas. Doug - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Threads in 3.5.0

Threads can certainly complicate and cause some horribly complicated bugs to find, but if you're careful they're great for working on multiple things at once. The other alternative is a single thread that does many things. At that point you're basically writing co-operative multi-tasking code.

RE: [sqlite] Threads in 3.5.0

I'd like to retract my last statement. The _other_ alternative is obviously separate processes as is being discussed. I need to go get some rest ... > -Original Message- > From: Doug [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 04, 2007 2:08 PM > To: 'sqlite-user

RE: [sqlite] Performance problem for a simple select with range

I'm not an SQL guru by any means, so seeing this made a light go on. Does that mean it is a good idea in the general case to always add "limit 1" to a select that you know should only return 1 row? I'm assuming this works because the engine can short-cut out as soon as it finds that first

[sqlite] Master Journal files hanging around

QL (ie a constraint not being met) to I/O errors. Hopefully I'll get some log files that will give me more insight. Thanks for any input. Doug - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Shared cache and PRAGMA cache_size

I have a highly threaded application that writes to a number of database files. Each thread opens a database file, uses its own handle, and then closes that handle when finished. As the threads come and go, some will likely overlap with others using the same database, so it seems like the

RE: [sqlite] Suggests for improving the SQLite website

One thing I really like about the current home page is the listing of the past 4-5 versions, the date when they were released and what changed. It is so easy to see what has changed since the version that I happen to be on. That may not need to be on the front page necessarily (although I like

[sqlite] Trying to understand SQLITE3_BUSY

I have a database file that was created with version 3.4.1. It _may_ have been written to at some point with 3.5.3 - can't say for sure. At some point a transaction was started and the app was stopped (probably me in the debugger). I assume I was using 3.4.1 at the time it but it could

RE: [sqlite] Trying to understand SQLITE3_BUSY

gt; To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Trying to understand SQLITE3_BUSY > > "Doug" <[EMAIL PROTECTED]> wrote: > > I have a database file that was created with version 3.4.1. It _may_ have > > been written to at some point with 3.5.3 - can't sa

RE: [sqlite] Trying to understand SQLITE3_BUSY

:) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 19, 2007 12:49 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Trying to understand SQLITE3_BUSY > > "Doug" <[EMAIL PROTECTED]> wrote: > > Well, I'

[sqlite] SQLITE_CORRUPT error

he doesn't think occurred (it is Windows, and the server was rebooted at some point.) I suspect the answer is no, but is there any way to salvage any of the data? Thanks Doug

RE: [sqlite] Date arithmetic question

Perhaps some enterprising soul could write the datediff function and put it in the wiki for everyone to use. In fact a separate area just for user-written functions might be quite helpful. For what it's worth, I have one that truncates a time (stored in time_t format) down to the start of an

RE: [sqlite] Cache for SQLite

I don't know of a daemon, but based on someone else's post where they described keeping a pool of sqlite3* handles to the database, and always reusing the most recently used handle first (so that the SQLite page cache is most likely still valid) I saw a very big jump in performance. Perhaps

[sqlite] SQLite is amazing

I am once again experiencing one of those moments of awe at how incredible SQLite is. I was about to write some custom functions for some complex date manipulation but I find it's already there. The speed, robustness, professionalism in this product is fantastic. Thank you Dr. Richard Hipp!

[sqlite] Question about LIKE

me understand the finer points of LIKE? Thanks Doug - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] INSERT or REPLACE

SQL behave like SQLite). Thanks for any ideas. Doug - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000

in your app to see if something else is missing a DLL. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Couple of questions about WAL

ected. Also, is the reference counting per process or per connection? Thanks Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Query suggestion?

of: SELECT StatID, max(Date), max(Value) FROM StatData GROUP BY StatID That would give me the most recent Date, but not the Value that corresponds with that Date. None of the other aggregate functions seem appropriate either. Thanks for any ideas. Doug

Re: [sqlite] Query suggestion?

Thank you Igor. You've helped me before with what also turned out to be a similar select referencing the same table twice. I guess it's a concept that I don't fully get. If there is a name for this technique I'll go Google and study up on it. Doug > -Original Message- >

Re: [sqlite] Query suggestion?

Thenk you Gerry. After some studying I now understand that the inner SELECT is executed for each outer row -- so trimming the outer result set early seems like a very good optimization idea. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite

Re: [sqlite] Run Time Error #1 in VS2008

I use SQLite3 directly from a number of VS2008 projects and have never seen that issue. Can you find the line of code causing the problem? > I am working on a project in VS2008 and I am including the sqlite3 code > directly (compared to in the past using wrappers). The program is > working

Re: [sqlite] C++ Unresolved external errors from DLL

sqlite3_bind_blob sqlite3_bind_double sqlite3_bind_int sqlite3_bind_int64 sqlite3_bind_null sqlite3_bind_parameter_count sqlite3_exec sqlite3_open ... That's always worked for me. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@s

Re: [sqlite] Scaling of Cache

well thought out in SQLite so I'm wondering if anyone can comment on the why's. Thanks Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Pavel Ivanov > Sent: Monday, October 18, 2010 2:15 PM > To: Gen

Re: [sqlite] Just compiled SQLite in Visual Studio

++ rules. And you can mix .c and .cpp files in the same project. As for what the difference is? That's a big question. Objects exist in C++, and they don't in C. That's the tip of the iceberg. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

Re: [sqlite] assert crash in wal

the complexities of interprocess communication/synchronization which is much easier to handle with threads in the same process. But you are right about the costs -- the benefits of using threads incur a cost -- a cost of being very careful. Doug ___ sqlite-us

Re: [sqlite] Windows performance problems associated with malloc()

I wonder if HeapSetInformation (which can enable a low-fragmentation heap) would be helpful too. You can set it on the process and the CRT heaps. Note that it's not available in Win2K and earlier. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

Re: [sqlite] First(s) select are very slow

instead of the much slower disk. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Vander Clock Stephane Sent: Monday, December 20, 2010 8:43 AM To: General Discussion of SQLite Database Subject: [sqlite] First(s) select

Re: [sqlite] First(s) select are very slow

Adding to what Simon said, even the SQLite cache has to get filled initially as well. So those very first hits to the database are always the most expensive. Once commonly used pages (index pages?) are loaded, you're running closer to memory speed than disk speed. -Original Message-

Re: [sqlite] SQLite server

to the client. And if the response is large, will you page, or keep the transaction open on the server thus blocking all other clients? The devil is always in the details :) Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] Weird locking issue Windows XP64 3.5.5

. Changing the journal file rights solved it for me. If you deleted the journal file (if there was one) that might explain it in your case. Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Teg > Sent: Thursday, March 13, 2008 9:48 AM &

[sqlite] Shared cache benefit question

/sharedcache.html but I'm not confident enough in my understanding to know whether I'll run into more or less blocking. Thanks for any insight. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] String is changing after inserting into database

Are you using the 16 bit calls? Like: sqlite3_prepare16_v2 sqlite3_column_text16 sqlite3_open16 That's what I use and I'm able to store and retrieve every non-Latin character I've tried so far. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of

Re: [sqlite] in memory or hard disk reading?

Someone correct me if I'm wrong, but ... > Could this improvement be different changing operating system? Certainly. You're benefitting from an OS that does file caching. If you switch to an OS with no file caching you'll lose the benefit. > When Is it convenient to use SQLite page-cache

Re: [sqlite] in memory or hard disk reading?

, but I'm not aware of any rules of thumb. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of L B > Sent: Friday, April 18, 2008 9:11 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] in memory or hard disk reading

Re: [sqlite] Equivalent of mysql_real_escape_string() ?

Besides substituting ' with '' (double single-quotes) you might also want to consider trimming trailing spaces. I ended up inserting strings like 'Doug' and 'Doug ' in a unique-indexed column. SQLite let me do it and all was well. One day I exported that data to MS SQL and it complained about

Re: [sqlite] Query help?

suppose creating a combined index of EventTime, ProcessID and FileName might help because the underlying record wouldn't need to be looked up. Any thoughts on that idea? Thanks Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Igor

Re: [sqlite] SQLite 3.6.0 coming soon...

And Section 2.0 has: "Partually or fully disable" > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Shawn Wilsher > Sent: Saturday, July 12, 2008 4:49 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite 3.6.0 coming soon...

Re: [sqlite] 64bit Version

Isn't 2008 the same as Vista? In that case, are you sure you have administrative rights? I'm betting user account control is limiting them at the moment. Run cmd.exe as an administrator (right click on a shortcut and choose Run As Administrator) and then see if it works. If you don't see the

Re: [sqlite] SQLite vs. quad-cores

ptimizer" patch to correct this: http://www.amd.com/us-en/Processors/TechnicalResources/0,,30_182_871_13118,0 0.html This is backwards from your situation, but it at least demonstrates issues in a related area, so perhaps there's something there. Doug > -Original Message- &

[sqlite] Intermittent SQLITE_CANTOPEN on Windows

can't figure out what has changed on my system such that this would be happening now. Thanks in advance for any ideas. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic insert questions...

it bold? Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of D. Richard Hipp > Sent: Wednesday, October 15, 2008 3:16 PM > To: [EMAIL PROTECTED]; General Discussion of SQLite Database > Subject: Re: [sqlite] basi

[sqlite] Malformed database image

too random an error to worry about, no problem. I need to get on the 3.6 series anyway. Doug Call stack (not for sqlite3, but from my app): sqlite3.dll!sqlite3GetVarint(const unsigned char * p=0x052c4227, unsigned __int64 * v=0x043b13f8) Line 14895 + 0x3 bytes sqlite3.dll!sqlite3BtreePa

Re: [sqlite] CURRENT_DATE Behavior

of pain as I switched everything to UTC -- life has been good since then. Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of jonwood > Sent: Monday, October 20, 2008 9:03 PM > To: sqlite-users@sqlite.org > Su

Re: [sqlite] setting the timezone on windows xp

Hi Jay -- I used to have a problem like this a few years back. I don't remember all the hows and whys, but my apps call the following at start up and the problems are gone: _tsetlocale(LC_ALL, _T("")); _tzset(); HTH Doug > -Original Message- > From: [EMAIL PROTECTED

Re: [sqlite] DateTime Objects

>it just seems very inefficient to store a date as a string in a database. I agree. But why would you store it as a string?? I personally store my times as ints (__time64_t, or time_t). When I read it back my app formats it however I want. Simple :) Doug > -Original Message-

Re: [sqlite] SQLite Transaction Rate and speed...

, with the caveat that some items were 'processed' but in volatile memory longer than they might have been otherwise. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of VF > Sent: Sunday, March 08, 2009 3:48 AM

Re: [sqlite] SQLite version 3.6.14

serialized by the database-level locks, but writes to other databases continue to work. But using the async feature would serialize all reads and writes to all databases, is that correct? Thanks Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-

Re: [sqlite] corrupt database recovery

search. Good luck either way. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Gene Allen > Sent: Wednesday, May 27, 2009 4:52 PM > To: mgr...@medcom-online.de; 'General Discussion of SQLite Database

Re: [sqlite] sqlite3_exec unresponsive for insert, delete and update

I don't know anything about xcode, but I've been burned by bugs like this in the past. It was always my fault: console was connected to one DB, and my app was connected to another. Make REALLY sure you're using the database file that you think you are. Doug > -Original Message- >

Re: [sqlite] Building sqlite

You may need SQLITE_THREADSAFE depending on how you're using the library > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Robert Dailey > Sent: Monday, June 29, 2009 1:51 PM > To: General Discussion of SQLite Database >

[sqlite] Heirarchical queries question

INTEGER, Path TEXT, ParentDirID INTEGER ); and some data that represents this table structure: / /users /users/doug /users/brett /users/brett/work /users/brett/research /users/brett/research/SQL INSERT INTO Directory (DirID, Path, ParentDirID) VALUES (1, '/', 0); INSERT

Re: [sqlite] Heirarchical queries question

Wow Pavel, that's a cool approach. I understand the issue about having % in the path (which is a problem I need to work around), but what is special about '_' ? Thanks Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@s

Re: [sqlite] .lib file?

haven't kept my sqlite3.def file up to date, but it's fairly recent if you want to use it. Since we can't post files to the newsgroup, I'll append it here. Doug EXPORTS sqlite3_aggregate_context sqlite3_aggregate_count sqlite3_auto_extension sqlite3_bind_blob sqlite3_bind_double sqlite3_bind_int

Re: [sqlite] (no subject)

have any issues with storing and retrieving local strings. If you don't use the wide-char (16) APIs, you would need to explicitly convert your strings to UTF-8 (which is not the same as ASCII) before handing to SQLite. Doug > -Original Message- > From: sqlite-users-boun...@sqli

[sqlite] Speeding up a (simple?) GROUP BY query

); Is there any slick way to make the GROUP BY faster, since I don't really need to group by all that data? Since there is an index on StatData.StatID, I would assume the GROUP BY would work by just hitting the index, but I've been wrong before. Thanks for any ideas from the group. Doug

Re: [sqlite] one liner for insert or update ?

Wouldn't "INSERT OR REPLACE" do that for you? (which by the way, has to be one of the coolest features in SQLite of all!) http://www.sqlite.org/lang_insert.html Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sq

Re: [sqlite] Fwd: sqlite3_prepare_v2

Try renaming the windows\system32\sqlite3.dll to sqlite3.lld (or anything else so you can easily find it and restore). Then see which app has problems launching (if any). Sqlite3.dll probably shouldn't be there anyway. Once you know what app needs that DLL, you can copy it into the

[sqlite] PRAGMA scope

after calling sqlite3_open each time). Temp_store and synchronous don't make any mention of files or connections. Can/should it be assumed that they are global to the SQLite library? Thanks Doug ___ sqlite-users mailing list sqlite-users

[sqlite] Limiting memory usage

I'm trying to figure out how to limit SQLite's memory usage while still giving it as much memory as I can. The app has about 50-60 separate database handles to 50-60 separate database files. Each handle is only used by a single thread at a time, and most are always accessed by the thread that

Re: [sqlite] Limiting memory usage

Yes, correct. I just showed it to indicate that all databases that are ever created use this page_size of 4KB. > > PRAGMA page_size=4096 > > This PRAGMA governs characteristics of a database you have not yet > created: it's pages on disk, not pages in memory. The page_size is a >

Re: [sqlite] Limiting memory usage

e soft limit? Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite for threads

transaction with: BEGIN IMMEDIATE; any time the database will be written to (ie an insert, update, delete, etc). That, along with looping on sqlite3_prepare_v2 and sqlite3_step any time you get SQLITE_BUSY, virtually solved the issue for me. HTH Doug _

Re: [sqlite] ANN: O'Reilly book "Using SQLite" available for pre-order

can be valuable. Good luck with the book Jay. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite-users Digest, Vol 138, Issue 4

l in the database for text fields that is/is not in play here? Doug > -Original Message- > From: sqlite-users > On Behalf Of sqlite-users-requ...@mailinglists.sqlite.org > Sent: Tuesday, June 04, 2019 5:00 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: sqlite-users Digest, V

Re: [sqlite] sqlite-users Digest, Vol 138, Issue 4

A|57616C747A|5|5|Waltz|1|American Smooth Notice that nullif() failed to find the field and the literal equal. That is consistent with the failure. Doug > -Original Message- > From: sqlite-users > On Behalf Of sqlite-users-requ...@mailinglists.sqlite.org > Sen

[sqlite] select * where abc like "xxx" works, ...where abc='xxx' fails

he table and the queries to a single column for this message. The actual table has 22 columns. Why does the "=" query fail and the "like" query work? Regards, Doug ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: [EXTERNAL] Re: Should SQLite distinguish between +0.0 and -0.0 on output?

an application might implement the functionality. --Doug ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] what's wrong with this trigger

What works, please? I saw no answer. Doug > -Original Message- > From: sqlite-users > On Behalf Of Rael Bauer > Sent: Monday, September 09, 2019 7:01 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] what's wrong with this trigger >

Re: [sqlite] Fastest way to SELECT on a set of keys?

I blows me away that you are able to produce such things as this at the drop of a hat! Thanks for your insights and ingenuity and completeness! Doug > -Original Message- > From: sqlite-users > On Behalf Of Keith Medcalf > Sent: Friday, September 13, 2019 1:30 PM > To:

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

t; >IfNull(c, 2),​ > >'y',​ > >IfNull(e, 4),​ > >'2019-20-12'​ > > FROM t​ > > WHERE a = 'p006';​ I think that you will never insert the first record with a query like this, since the select returns 0 records of there are none

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

WRT Jose's original context, and just for my enlightment, what happens with the following: insert into t (a, b, c, d, e, idate) SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p999'; where p999 does not define a record? Is a new record inserted with values of a,b,c, and e null? >

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

exist as that name. The "names" article is totally wrong when it says that each assumption is wrong. Each of those assumptions is correct, and I can find at least one system which makes each one correct. Within each system, the assumption works, and is valid. My two cen

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

; Doesn't the where clause that cannot be satisfied in both cases guarantee that no rows will be selected, when there are no records in the database? Doug > -Original Message- > From: sqlite-users > On Behalf Of Jose Isaias Cabrera > Sent: Monday, November 18, 2019 12:11 PM >

Re: [sqlite] Result set column names

For column "xxx" what will the full column name be? "foo.xxx"? Doug > -Original Message- > From: sqlite-users > On Behalf Of Simon Slavin > Sent: Tuesday, December 10, 2019 10:37 AM > To: SQLite mailing list > Subject: Re: [sqlite] Result set colum

Re: [sqlite] Result set column names

xx) VALUES(25) SELECT xxx FROM foo ---|- xxx 25 Doug > -Original Message- > From: sqlite-users > On Behalf Of Adrian Ho > Sent: Tuesday, December 10, 2019 8:04 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] Result set column names > &g

Re: [sqlite] Last record

How about something like this that costs more to run: Given a table T with columns A, B, C,.. BEGIN TRANSACTION SELECT Count(*) AS Count [filter spec]; SELECT A,B,C,... [filter spec]; ROLLBACK or COMMIT Doug > -Original Message- > From: sqlite-users > On Behalf Of Simon Slav

Re: [sqlite] https://www.sqlite.org/draft/gencol.html Typo

The draft says "Nor may a generated column depend on the ROWID." If my table uses ROWID by default: CREATE TABLE foo (id INTEGER PRIMARY KEY, a INTEGER, b AS (id+a)); where id is ROWID by default, is the generated column disallowed because it has an implied dependency on RO

Re: [sqlite] https://www.sqlite.org/draft/gencol.html Typo

te mailing list > Subject: Re: [sqlite] https://www.sqlite.org/draft/gencol.html > Typo > > > On Tuesday, 29 October, 2019 12:25, Doug > wondered: > > >The draft says "Nor may a generated column depend on the ROWID." > > >If my table uses ROWID by default:

Re: [sqlite] Can SQLite do this in a single query?

Please explain one phrase in the select: total(1) over (partition by city_txt, mode_txt) Is "total" a function and does "1" refer to city_txt? I can't wrap my head around what's going on with this phrase. Doug > -Original Message- > From: sqlite-users &g

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

d. However, the domain of "a" is 'p001', 'p002',... It is not a date which would be returned by Max(idate). I know you are trying to use side effects, but I don't understand ??? Doug > -Original Message- > From: sqlite-users > On Behalf Of Jose Isaias Cabrera > Sent: Mo

Re: [sqlite] Date time input

I like SQLoaded! Doug > -Original Message- > From: sqlite-users > On Behalf Of Jose Isaias Cabrera > Sent: Tuesday, October 08, 2019 12:15 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] Date time input > > > James K. Lowden, on Tuesda

Re: [sqlite] Check constrain execution timing change? (Now a bug)

match the column type. So, if you are generating text SQL statements: Is the code inadvertently putting quotes (') around in integer value or is the user entering a string and your code is taking that input and slapping it into a SQL INSERT statement? Please expl

Re: [sqlite] Check constrain execution timing change? (Now a bug)

> On Tue, Feb 4, 2020 at 5:38 PM Doug wrote: > > > You're twisting my point here. I obviously want the reverse, > > > I want the database types to "drive" the binding done. 1-to-1. > > > Because even if binding a different type would work, via > SQLi

[sqlite] FW: Questions about your "Performance Matters" talk re SQLite

are run on lots of different machines (all over the world?), it would provide an excellent view of what changes in SQLite made a difference in performance. Doug From: Curtsinger, Charlie Sent: Thursday, January 02, 2020 10:55 AM To: dougf@comcast.net Cc: Emery D Berger Subject: Re

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Thanks, Jens. I got it. The benchmark sounds like it isn't a real benchmark, but a made-up scenario to exercise the Coz code. I've let go now. Doug > -Original Message- > From: sqlite-users > On Behalf Of Jens Alfke > Sent: Friday, January 03, 2020 10:58 PM > To: SQLi

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

> -Original Message- > From: sqlite-users > On Behalf Of J Decker > Sent: Saturday, January 04, 2020 4:11 AM > > Could wish there was a way to > pause execution without giving up execution context... What about? for (i=1000; i--; i>0); ___

Re: [sqlite] Causal profiling

> -Original Message- > From: sqlite-users > On Behalf Of Jens Alfke > Sent: Thursday, December 26, 2019 3:11 PM > To: SQLite mailing list > Subject: Re: [sqlite] Causal profiling > > > > > On Dec 25, 2019, at 2:53 PM, Doug wrote: > > > > I

Re: [sqlite] Causal profiling

at the talk again re performance measurements), what did you use to measure the results? Best, Doug > -Original Message- > From: sqlite-users > On Behalf Of Richard Hipp > Sent: Wednesday, December 25, 2019 3:18 PM > To: SQLite mailing list > Subject: Re: [sqlite

Re: [sqlite] Causal profiling

; presumably, we already have test cases that test the same code using different compiler options. What about that? Best, Doug > -Original Message- > From: sqlite-users > On Behalf Of Jens Alfke > Sent: Friday, December 27, 2019 2:22 PM > To: SQLite mailing list > Su

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

(a, abs(0), abs(1), abs(2)) FROM t1; Just curious... Doug > -Original Message- > From: sqlite-users > On Behalf Of Richard Hipp > Sent: Thursday, March 12, 2020 7:41 AM > To: SQLite mailing list > Subject: Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short- > circui

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

Richard, what does the explain look like with your code change, please. Doug > -Original Message- > From: sqlite-users > On Behalf Of Richard Hipp > Sent: Thursday, March 12, 2020 3:09 AM > To: SQLite mailing list > Subject: Re: [sqlite] [EXTERNAL] Re: COALESC

Re: [sqlite] decoding a bitmask

> > The query is on a visits table from a google chrome history database. The > query seems to work OK if a single bit is set, but fails (a blank string is > returned) when multiple bits are set. Any ideas why? > It's because none of the WHEN 0x... cases, except 0xC0..., have multiple bits set.

Re: [sqlite] Best Practice: Storing Dates

Whatever format you choose to store it in, I highly recommend storing the UTC time. It might be a little more work, but: 1. your program can display the correct local time, even if the database/app/user is in/changes to another timezone 2. you won't have to deal with seeing two 1:30am on the

[sqlite] ordinary CTE containing sum()

In response to this SO question: http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table I tried to formulate a query without temp tables using an ordinary CTE, but received an error "misuse of aggregate: sum()". This works: sqlite> with tt (S_id,

Re: [sqlite] ordinary CTE containing sum()

> > > In response to this SO question: > > > > > http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table > > > > I tried to formulate a query without temp tables using an ordinary > > CTE, but received an error "misuse of aggregate: sum()". > tonypdmtr

  1   2   3   4   >