[sqlite] Questions- New App

direction and tell me if SQlite is useful for this, or what other programs or resources would be useful. I look forward to working further, and learning further from this. Thank you, Russell Duncan Florida International University Studying International Relations (813) 493 5764 Instagram

[sqlite] Limit to 5 records per Group / Top N results per group

All, Please help.I have been trying but can't find an answer. In SQLIte, I have 2 tables, one is for a list of Projects (about 50 projects) and the other is a list of key dates for each project. Each project has about 20 key dates. How can run a query that will only return the top/first 5

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Ok. So how does this get fixed? -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315 On Thu, Jan 10, 2013 at 8:49 PM, Joe Mistachkin <sql...@mistachkin.com>wrote: > > Michael Russell wrote: > > >

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Thanks Joe. A couple of follow-up items: 1) The break seems to have happened between 1.0.81.0 and 1.0.82.0. 2) Do Entity Framework team members read this list? -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

= scity); Console.WriteLine(c.CompanyName); } File.Delete(tmpDb); 6) Set "testlinq.2010" as StartUp Project 7) Build "testlinq.2010" 8) Copy SQLite.Interop.DLL to bin\2010\Debug\bin 9) Run "testlinq.2010" - get Exception at

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

I did do a check-out after you made the above suggestion to me. I did the fossil checkout / build, but I still have the same problem. -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315 On Wed, Jan 9, 2013 at 2:54 PM

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0inSystem.Data.SQLite

tOrDefault = testEntities.Users.FirstOrDefault(); if (firstOrDefault != null) { Assert.AreEqual("1234", firstOrDefault.Id, "ID mismatch"); } } but I still cannot delete the file after the using. --

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0 inSystem.Data.SQLite

One further follow-up. I tested all the other versions in between. The break happened between 1.0.81.0 and 1.0.82.0 -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315 On Wed, Jan 9, 2013 at 10:47 AM, Michael Russell

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0 inSystem.Data.SQLite

I have narrowed this down and to just the System.Data.SQLite.DLL. I have a test project in VS2010 with .NET 4.0. If I only change the System.Data.SQLite.DLL from 1.0.79.0 to 1.0.83.0 I get the failure that the file is open. I am not changing any other components or DLL's. -- Michael Russell

Re: [sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0 in System.Data.SQLite

(); Assert.IsTrue(users.Any()); } File.Delete(TmpDatabase); The File.Delete() fails with the same issue as above (System.IO.Exception: The process cannot access the file...because it is being used by another process.) Thanks for any help with this. -- Michael Russell MTI Film, LLC

[sqlite] Change in behavior between 1.0.79.0 and 1.0.83.0 in System.Data.SQLite

the "File.Delete()" to fail with: System.IO.IOException: The process cannot access the file 'c:\tmp\Test_SQLConnection.db' because it is being used by another process. I would appreciate any info on this change. Thanks very much. -- Michael Russell MTI Film, LLC michael.russ..

[sqlite] Possible typo when acquiring a "pending" lock.

://pastebin.com/phEUEAiY> too). Sorry for the trouble caused if the current state is correct. Kind regards, James Russell. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DISTINCT bug with 3.7.10

Fri, 02 Mar 2012 19:00:30, Roger Binns wrote: > On 02/03/12 15:20, Steven Russell wrote: >> I obviously don't expect the duplicate results here. If you create the >> table without the UNIQUE clause, then the results are as expected (1 >> and 2 both only show up once). >

[sqlite] DISTINCT bug with 3.7.10

and 2 both only show up once). As a point of reference, the sqlite3 shell tool that ships with the OS (3.6.12) does produce the correct results. -- Steven Russell sruss...@extensis.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] WAL on a separate filesystem?

On Jan 19, 2011, at 5:35 AM, Richard Hipp wrote: > On Wed, Jan 19, 2011 at 2:52 AM, Dustin Sallings > wrote: > >> >> Is it possible without violating any assumptions that would >> lead to >> reliability problems to have a DB's WAL exist on a separate >> filesystem?

Re: [sqlite] Using sqlite's WAL with a hash table store

Check out: http://jaksprats.wordpress.com/2010/09/28/introducing-redisql-the-lightning-fast-polyglot/ On Nov 3, 2010, at 10:51 AM, Jay A. Kreibich wrote: > On Wed, Nov 03, 2010 at 05:10:22PM +0300, Alexey Pechnikov scratched > on the wall: >> 2010/11/3 Jay A. Kreibich

Re: [sqlite] Confitional IF in triggers

Thanks Igor - that's very helpful. --- On Sun, 10/10/10, Igor Tandetnik <itandet...@mvps.org> wrote: From: Igor Tandetnik <itandet...@mvps.org> Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Sunday, 10 October, 2010, 2:46 AM Russ

Re: [sqlite] Confitional IF in triggers

detnik <itandet...@mvps.org> Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Saturday, 9 October, 2010, 12:21 AM Russell A <slurc...@yahoo.com.au> wrote: > This may be a really dumb question, but I've searched and can't find an > answ

[sqlite] Confitional IF in triggers

This may be a really dumb question, but I've searched and can't find an answer. Do SQLite triggers support any conditional expressions, like IF, or is there only the WHEN statement? If the latter, does that mean that multiple conditions must be in separate triggers? Any help appreciated.Stopgap.

[sqlite] Trigger Variables

I'm porting an Interbase DB to SQLIte and wondered if there is any way to store temporary values within a trigger? Any help appreciated.Slurcher. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Creating Histogram fast and efficiently :)

create table numbers (val integer); insert into numbers values (1); insert into numbers values (5); sqlite> select * from numbers order by val; 1 5 10 12 12 15 20 20 20 select case when val < 10 then 1 when val >=10 and val < 20 then 2 else 3 end as bin, count(1) as c

[sqlite] Patch to allow custom meta commands?

Richard, Would you accept a patch to allow user supplied 'dot' commands in the shell? For my own purposes I wanted to have '.load' define some meta commands as well as custom SQL functions. Would anyone else find this useful? Russ ___

Re: [sqlite] Specifing which index to use. Was: Performance/bug in multikey 'group by' in 3.6.2

as partitions (like above for the web site) is a great way to scale. The application will know if a table scan is better or not. Sqlite itself does not have the view. On Sep 26, 2008, at 1:23 PM, Nicolas Williams <[EMAIL PROTECTED]> wrote: > On Fri, Sep 26, 2008 at 12:54:36PM -0400

Re: [sqlite] Specifing which index to use. Was: Performance/bug in multikey 'group by' in 3.6.2

Perfect solution as long as there is a no index option along with index by. On Sep 26, 2008, at 12:54 PM, Russell Leighton <[EMAIL PROTECTED] > wrote: > I have another scenario where this is needed , the one in the subject. > I repeated this problem this AM. > > I

Re: [sqlite] Specifing which index to use. Was: Performance/bug in multikey 'group by' in 3.6.2

I have another scenario where this is needed , the one in the subject. I repeated this problem this AM. I need a 2 key index for some queries and also want to aggregate on these 2 columns. I need this index BUT I have many large sqlite dbs I iterate over and they won't fit in the filesystem

Re: [sqlite] Performance/bug in multikey 'group by' in 3.6.2

A reason I think such functionality would be ideal for sqlite is that it avoids the need for a fancy query plan optimizer. The user would have a way to direct the query plan if the simple and obvious plan is suboptimal. On Sep 21, 2008, at 11:36 AM, "D. Richard Hipp" <[EMAIL PROTECTED]>

Re: [sqlite] Performance/bug in multikey 'group by' in 3.6.2

Oracle has 'hints' which live in the comments emdedded in the select. Google 'oracle hint use index'. The 3rd hit down my result list has a nice overview.(I'd send the link but this stupid iPhone has no cut-n- paste). I think that hints are really ugly. Not sure about the other big dmbs.

[sqlite] Disabling index [was Re: Performance/bug in multikey 'group by' in 3.6.2

Alternatively: pragma planner_ignore_index=1 On Sep 20, 2008, at 11:37 AM, Russell Leighton <[EMAIL PROTECTED] > wrote: > It would be very nice to have a way to explicitly control index use. > > I'm going to test my theory this weekend but I think if the index

Re: [sqlite] Performance/bug in multikey 'group by' in 3.6.2

It would be very nice to have a way to explicitly control index use. I'm going to test my theory this weekend but I think if the index is not cached and the data large then the group by is faster without the index. If this is the case I have a real issue. I need the index for other queries

Re: [sqlite] SQLite version 3.6.2

Are there expected performance differences (better or worse) as a result of the code factoring? On Aug 30, 2008, at 8:01 PM, D. Richard Hipp wrote: > SQLite version 3.6.2 is now available on the SQLite website: > http://www.sqlite.org/download.html > > SQLite version 3.6.2 contains rewrites

Re: [sqlite] How to emulate generate_series function?

I think you are asking about 'table functions', which are functions that return a rowset and are used in place of a table to generate rows. See: http://www.postgresql.org/docs/7.3/static/xfunc-tablefunctions.html To my knowledge this is not supported in sqlite, except perhaps via virtual

Re: [sqlite] patch to allow integer rtree keys

On Jul 12, 2008, at 11:08 AM, Dan wrote: > > On Jul 12, 2008, at 2:42 AM, Steve Friedman wrote: > >> >> >> Filip Navara wrote: >>> how about actually attaching the patch? :) >>> >>> - Filip >>> >>> On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman >>> <[EMAIL PROTECTED]> wrote: I've just

Re: [sqlite] Writing double into a socket file

On Jun 9, 2008, at 8:52 PM, Igor Tandetnik wrote: > "Alex Katebi" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED] >> I am trying to implement remote procedure calls (RPC) for SQLite API >> to be used in my application. >> In particular sqlite3_column_double( ) returns a floating

[sqlite] Firefox 3 and the SQLite "bug"

Digg has an article where it is said that the new Firefox "locks" up under Linux due to SQLite: http://digg.com/linux_unix/ Firefox_3_has_system_killing_performance_problem_for_Linux Bug here: https://bugzilla.mozilla.org/show_bug.cgi?id=421482 Scanning the bug it seems to

Re: [sqlite] how can I find source of sqlite V 2.x

Yes, it works. Thank Dennis! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Wednesday, March 26, 2008 12:36 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] how can I find source of sqlite V 2.x Russell wrote: > &

[sqlite] how can I find source of sqlite V 2.x

Hi all, My project had to use Qt 3.3.8, which supports sqlite V2 only. How can I get the source of V2? BR Russell ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_ENABLE_LOCKING_STYLE status?

I'm trying to use the network filesystem support on Mac OS X that is, to my understanding, enabled by the SQLITE_ENABLE_LOCKING_STYLE flag. As also noted by someone else in the archives of this list, I'm finding that Sqlite 3.5.6 won't compile with the flag defined. I noticed that there

Re: [sqlite] Memory Usage

On Nov 17, 2007, at 4:56 PM, [EMAIL PROTECTED] wrote: If you compile with -DSQLITE_MEMORY_SIZE= then SQLite will *never* call malloc(). Instead, it uses a static array that is bytes in size for all of its memory needs. You can get by with as little as 100K or so of memory, though

Re: [sqlite] Proposed sqlite3_initialize() interface

On Oct 30, 2007, at 10:18 AM, [EMAIL PROTECTED] wrote: To accomodate this need, we are considering an incompatible API change to SQLite. We are thinking of requiring that an application invoke: int sqlite3_initialize(...); I am not sure about the systems that you are trying to

Re: [sqlite] FTS2 suggestion

Could fts3 (the next fts) have the option to override the default 'match' function with one passed in (similar to the tokenizer)? The reason I ask is then the fts table could be used as smart index when the tokenizer is something like bigram, trigram, etc. and the 'match' function computes

Re: [sqlite] Tomcat crashes with SQLite

If you did not compile sqlite as multi-threaded this is exactly what would happen. On Jun 22, 2007, at 9:06 PM, Frederic de la Goublaye wrote: Hi I just tried this driver: http://www.zentus.com/sqlitejdbc/ The result is ten times slower or even more. Maybe I am wrong using this new

[sqlite] FTS2 Experiences?

Could folks that have used fts2 in production apps/systems relate their experiences to the group? I would very much be interested in how folks are using it, how well it performs with large data and general impressions. Thanks in advance. Russ

[sqlite] Index in seperate db file, low impact change?

Given you can attach multiple database files in sqlite, perhaps it could be extended such that: * When you name an index, you optionally prepend the database name which can be in another currently attached db * You attached to multiple db files that have cross references as:

Re: [sqlite] BEGIN and Backup [was [sqlite] Problems with multiple threads?]

Thx! [EMAIL PROTECTED] wrote: Russell Leighton <[EMAIL PROTECTED]> wrote: So, this was very enlightening...I have a simple backup function that I now question is correct. It does: - execute "begin" // lock from writes -copy db file to new file byte by byte -

Re: [sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

I was afraid of that...it would be cool if someone created a sqlite server which handled the networking and serialization...I would take a crack at it myself but right now I don't have time. Dan Kennedy wrote: I had a musing while reading:

[sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

I had a musing while reading: http://news.com.com/2100-7344_3-6063599.html?part=rss=6063599=news where it reminded me of one of MySQL's features: MySQL's database is built so that it can use a range of different storage mechanisms, tuned for different purposes, such as

Re: [sqlite] C Code in a trigger supported in 3.3.x?

Solved. Bug in my code. Sorry for the alarm. Russell Leighton wrote: Update. I actually have 2 nearly identical triggers as described below. One works, the other produces "shifted" output...it appears that the sqlite3_column_xxx() functions are returning the wrong data when

Re: [sqlite] C Code in a trigger supported in 3.3.x?

produces proper data. Digging into it further... Russell Leighton wrote: This worked in 3.2.8 but not in 3.3.1/2 I delcare a function using sqlite3_create_function()...this takes 1 arg , an integer and calls the usual code to execute a 'select[ based on the integer as a key and does

[sqlite] C Code in a trigger supported in 3.3.x?

This worked in 3.2.8 but not in 3.3.1/2 I delcare a function using sqlite3_create_function()...this takes 1 arg , an integer and calls the usual code to execute a 'select[ based on the integer as a key and does some work based on the result. I declare a temp trigger to call the above

Re: [sqlite] Same error is flagged in 3.2.8 for sqlite3GenerateConstraintChecks() [was [sqlite] Known issue in 3.2.7 in vaccum?

Thx. I'll re-test with 3.3.1. That said, isn't 3.2.8 supposed to be the stable release? [EMAIL PROTECTED] wrote: Russell Leighton <[EMAIL PROTECTED]> wrote: Recompiled using 3.2.8 of sqlite, same issue is flagged by valgrind. 3.2.8 is a single-line change to

[sqlite] 3.2.8 'make test' fails tests under linux

' under: FedoraCore4 , gcc4.1 Gentoo 2.6.14-gentoo-r5, gcc 3.3.5 On gentoo I also get these date failures (which I don't see under FedoraCore4): date-6.1 date-6.4 date-6.5 date-6.8 date-6.13 date-6.16 Russell Leighton wrote: Recompiled using 3.2.8 of sqlite, same issue is flagged

[sqlite] Same error is flagged in 3.2.8 for sqlite3GenerateConstraintChecks() [was Re: [sqlite] Known issue in 3.2.7 in vaccum?

Recompiled using 3.2.8 of sqlite, same issue is flagged by valgrind. Russell Leighton wrote: Also, this happens under any constrained insert...from the stack trace below you would that that would be true. This is confirmed during another test scenario doing an insert statement

[sqlite] Known issue in 3.2.7 in vaccum?

During valgrind ( www.valgrind.org ) testing under linux I was executing "vaccum" and got: ==17449== Conditional jump or move depends on uninitialised value(s) ==17449==at 0x1CF2200C: sqlite3GenerateConstraintChecks (insert.c:980) ==17449==by 0x1CF233F6: sqlite3Insert (insert.c:629)