Re: [sqlite] FW: how best to determine # of rows in a table

Sorry, the count thing was actually Mark Halegua's question. -- Darren Duncan On 2014-08-27, 8:58 PM, Darren Duncan wrote: On 2014-08-27, 8:41 PM, Keith Medcalf wrote: this may seem like a small issue, but I'm not sure if the solutions I've found on the web will do what I want in a low memory

Re: [sqlite] FW: how best to determine # of rows in a table

On 2014-08-27, 8:41 PM, Keith Medcalf wrote: this may seem like a small issue, but I'm not sure if the solutions I've found on the web will do what I want in a low memory situation. I'd like to iterate through a table one row at a time. I can do that in pysqlite, but I don't see a method for

[sqlite] FW: how best to determine # of rows in a table

> this may seem like a small issue, but I'm not sure if the solutions I've > found on the web will do what I want in a low memory situation. I'd like to > iterate through a table one row at a time. I can do that in pysqlite, but I > don't see a method for determining I'm at the end of the file

Re: [sqlite] Window functions?

SQL Server 2008 does not have this behaviour. SELECT id, category_id, name, min(price) as minprice FROM( SELECT 1 id ,1 category_id ,'name1' name ,1 price -- Generate some data. ) AS cat_pictures GROUP BY category_id; produced: Msg 8120, Level 16, State 1, Line 3

Re: [sqlite] Window functions?

On Wednesday, 27 August, 2014 13:17, Petite Abeille said: >On Aug 26, 2014, at 2:09 AM, Keith Medcalf wrote: >> select id, category_id, name, min(price) as minprice >>from cat_pictures >> group by category_id; >> >> Done. And no need for any windowing functions ...

Re: [sqlite] how best to determine # of rows in a table

you execute .fetchone() on the cursor. It will return either a row tuple, or None if there are no more rows. >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Mark Halegua >Sent: Wednesday, 27 August, 2014 07:51 >To:

Re: [sqlite] Possible peculiarity in System.Data.Sqlite.Core (ADO.Net)

Sorry if my use of the word 'bug' touched a nerve. Thanks for the help. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, August 27, 2014 4:53 PM To: General Discussion of SQLite Database Subject:

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

On 28 Aug 2014, at 12:47am, Zachary Yates wrote: > That's not actually the issue. When I run the query using the SQLite console > or via another driver, (for example using 0xDBE + Xerial), the column names > are returned exactly as they are specified in the query. >

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

That's not actually the issue. When I run the query using the SQLite console or via another driver, (for example using 0xDBE + Xerial), the column names are returned exactly as they are specified in the query. The problem is that all of the column names return the same string: "Country",

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

On 27 Aug 2014, at 8:30pm, Zachary Yates wrote: > When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method > returns only the table name, in my case "Country". You do not provide your own names for the columns returned. Therefore SQLite is free

Re: [sqlite] The SQLite Download Files For Visual Studio 13 are not .visx files

Robert wrote: > > They are zip files with all of the manifest and dlls. > Yes, that is how the VSIX files are implemented internally. More information on this file format can be seen here: http://msdn.microsoft.com/en-us/library/ff363239.aspx > > I cannot see how add them to Visual

[sqlite] The SQLite Download Files For Visual Studio 13 are not .visx files

Yes, This to let you know that the download files Windows 8.1 and Windows Phone 8.1 are not .visx files. They are zip files with all of the manifest and dlls. I cannot see how add them to Visual Studio 2013. They are listed as: sqlite-wp81-winrt-3080600.vsix and

[sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Hello, >From what I can tell, this is the place to ask about a bug in the ADO.Net >driver for SQLite. If it's not, my apologies. I've run into an issue while using System.Data.Sqlite.Core v 1.0.93.0 to execute select queries like the following: SELECT "Country"."Id", "Country"."Code",

[sqlite] FTS full-text query vs. query by rowid

Hello, I would like to ask several questions regarding to SQLite FTS module and how it uses indexes. I have following queries: 1) A full-text query SELECT docId FROM ftsTableWHERE ftsTable MATCH 'a*' - gets a following query plan: SCAN TABLE ftsTable VIRTUAL TABLE INDEX 18: 2) A query by

Re: [sqlite] SQLite Database Browser v3.3.0 released

On Wed, Aug 27, 2014 at 6:18 PM, wrote: > > This is in process now: > > https://github.com/sqlitebrowser/sqlitebrowser/pull/83 > > Might need a few code extra code tweaks (unsure), but we'll get it > done and push out an updated release with the new name sometime > in

Re: [sqlite] SQLite Database Browser v3.3.0 released

On 2014-08-26 16:18, jus...@postgresql.org wrote: On 2014-08-25 17:04, Richard Hipp wrote: Thank you for creating this project.  I downloaded a copy.  It seems very nice. NOW, PLEASE CHANGE THE NAME!!! "SQLite" is a trademark.  You are welcomed and encouraged to use the code for SQLite, but

Re: [sqlite] Window functions?

Hi Eduardo: As Petite have mention, the following query selectid, category_id, name, min(price) as minprice from cat_pictures group by category_id; is missing the "id" and "name" columns in the GROUP BY clause ... per standard SQL standard requirement. If the above works, it is a

Re: [sqlite] Edinburgh Buses - SOLVED!!!

Thanks Petite for reminding me of the appropriate etiquette for using the service and thank you also for providing bonus reading materials for my perusal. Both thoughts are highly appreciated. Be well. ___

Re: [sqlite] Window functions?

On Aug 27, 2014, at 10:57 PM, Eduardo Morras wrote: > Sorry, don't understand why others will throw an exception in the group by, > perhaps I'm misunderstanding the group by, but that should work on others > engines. Because not all expressions are accounted for, i.e.:

Re: [sqlite] Window functions?

On Wed, 27 Aug 2014 21:17:05 +0200 Petite Abeille wrote: > > On Aug 26, 2014, at 2:09 AM, Keith Medcalf > wrote: > > > select id, category_id, name, min(price) as minprice > >from cat_pictures > > group by category_id; > > > > Done. And no

Re: [sqlite] how best to determine # of rows in a table

On 27/08/14 06:51, Mark Halegua wrote: > I can do that in pysqlite, but I don't see > a method for determining I'm at the end of the file The best way of thinking about how SQLite works internally is that it does the least amount of work to get you the next row of results. That also happens to

Re: [sqlite] Window functions?

On Aug 26, 2014, at 2:09 AM, Keith Medcalf wrote: > select id, category_id, name, min(price) as minprice >from cat_pictures > group by category_id; > > Done. And no need for any windowing functions … This peculiar behavior is very unique to SQLite. Most reasonable

Re: [sqlite] Edinburgh Buses - SOLVED!!!

On Aug 27, 2014, at 7:19 PM, Errol Emden wrote: > … Couple of minor list minutia: - When starting a new topic, create a new message, instead of replying to your previous one and merely changing its subject line. This will make it easier to keep track of new messages for

Re: [sqlite] Edinburgh Buses - SOLVED!!!

Igor, I can't thank you enough for getting my head 'out of the box'. Your insightful remarks and assistance are highly appreciated. I made the following (underlined) changes to your script to include the transfer stops (Xfer.name): SELECT distinct StartOfR1.num, StartOfR1.company, Xfer.name

Re: [sqlite] Integrity check

On 27 Aug 2014, at 4:21pm, Jan Slodicka wrote: > - There is one potentionally risky operation that our app performs: The data > exchange with a remote WebService. This can take long (10+ min). Users often > switch to email reading or similar activity, the app then runs on the >

Re: [sqlite] Curiosity question for an apparent change in Sqlite/timeline pattern

Thank you Richard for this informative answer, I was quite impressed by the recent "in ()" improvement, so it probably created a reality distortion field on my perception. Regards, ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

So you are using a host file system. You should be able to make the open work by using rc = sqlite3_open("host:D:/WindRiver/SqliteOne.db",); You have to use a path and file name that works in the vxWorks domain. It shouldn’t be necessary to use �CDSQLITE_ENABLE_LOCKING_STYLE=1. In fact it has

Re: [sqlite] Integrity check

On Wed, Aug 27, 2014 at 11:21 AM, Jan Slodicka wrote: > A while ago I reported > < > http://sqlite.1065341.n5.nabble.com/What-can-be-deduced-from-integrity-check-td70451.html > > > about DB corruption issues that we occasionally receive from our users. > They > always have the

[sqlite] Integrity check

A while ago I reported about DB corruption issues that we occasionally receive from our users. They always have the same pattern: - A few rowid's missing from a few indexes, and - A few "wrong # of

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Firstly: I fixed the disk I/O error by adding -DSQLITE_ENABLE_LOCKING_STYLE=1 to the build macro. Secondly: rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",); I change it to the following cd("host:D:/WindRiver"); rc = sqlite3_open("SqliteOne.db",); can fix the problem : unable to open

Re: [sqlite] Database is locked !

I found the problem : In fact I forgot well one "close" call. Sorry Fabrice -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Fabrice MAUPIN Envoyé : mercredi 27 août 2014 15:27 À : 'General Discussion of SQLite Database' Cc 

Re: [sqlite] how best to determine # of rows in a table

What about canonical SELECT COUNT(*) FROM table; ? 27 August 2014, 16:51:23, Author "Mark Halegua" > this may seem like a small issue, but I'm not sure if the solutions I've > found > on the web will do what I want in a low memory situation.I'd like to iterate

[sqlite] how best to determine # of rows in a table

this may seem like a small issue, but I'm not sure if the solutions I've found on the web will do what I want in a low memory situation.I'd like to iterate through a table one row at a time. I can do that in pysqlite, but I don't see a method for determining I'm at the end of the file Can

Re: [sqlite] Database is locked !

For information, you will find the "SQLiteJdbc" class used. I verified (normally) after each statement there is a db.close(). Fabrice -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de J Decker Envoyé : mercredi 27 août 2014

Re: [sqlite] Database is locked !

Sounds like you have statements laying around that weren't properly destroyed... you say executed correctly, but then also released correctly? On Wed, Aug 27, 2014 at 6:14 AM, Fabrice MAUPIN wrote: > Hi all, > > > > I try to execute an "INSERT" query and I obtain this message

[sqlite] Database is locked !

Hi all, I try to execute an "INSERT" query and I obtain this message : "Database is locked". I verified all the previous connections which were opened were closed and all the previous statements were correctly executed (UPDATE, INSERT, .). The volume of data to be handled is very low.

[sqlite] How to use java connect encrypted sqlite database file?

Hi All， How to use java connect encrypted sqlite database file? Thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users