Re: [sqlite] Possible in one SQL statement?

2011-03-05 Thread Simon Slavin
On 5 Mar 2011, at 8:40pm, Kai Peters wrote: > Is it possible to obtain select result set containing the table names of all > user tables in a > database Take a look at the results of SELECT * FROM sqlite_master and work out your own way of listing the tables. > along with their record

[sqlite] Possible in one SQL statement?

2011-03-05 Thread Kai Peters
Is it possible to obtain select result set containing the table names of all user tables in a database along with their record counts? TIA, Kai ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Using indexed fields in a table.

2011-03-05 Thread Eric Smith
On Sat, Mar 5, 2011 at 8:14 AM, BareFeetWare wrote: > On 05/03/2011, at 1:59 AM, "J Trahair" > wrote: > > > I understand about Primary keys and Unique keys attributed to their own > field. Is there a need to have other fields indexed,

Re: [sqlite] Adjusting strategy for ROWIDs

2011-03-05 Thread Simon Slavin
On 5 Mar 2011, at 11:21am, Enrico Thierbach wrote: > using a different field would break associations between tables. For example: > > Assume we have tables a and b, and a join table as_to_bs. The a and b table > both have a uniqueKey column, as you suggest, that will be set by a trigger. > If

Re: [sqlite] Using indexed fields in a table.

2011-03-05 Thread BareFeetWare
On 05/03/2011, at 1:59 AM, "J Trahair" wrote: > I understand about Primary keys and Unique keys attributed to their own > field. Is there a need to have other fields indexed, for faster searching? > Eg. a table containing your favourite music. Say you have 9

Re: [sqlite] Adjusting strategy for ROWIDs

2011-03-05 Thread Black, Michael (IS)
I wasn't aware SQLite's PRNG was not like most others. Good to know. I guess one could insert their own random() function if you need repeatability (which is actually a major point of most random number generators). I don't see the seeding exposed in SQLite so you can restart from a given

Re: [sqlite] Adjusting strategy for ROWIDs

2011-03-05 Thread Enrico Thierbach
Hi list, I should have omitted the word "random" from the original post :) What was answered (but not specifically asked) is - sqlite has a pretty good PRNG. - yes, there is the birthday paradoxon. BTW, the calculation I wrote down in the other post regarding the birthday paradox was wrong.

Re: [sqlite] Adjusting strategy for ROWIDs

2011-03-05 Thread Enrico Thierbach
On 05.03.2011, at 02:21, Simon Slavin wrote: > > On 5 Mar 2011, at 1:18am, Enrico Thierbach wrote: > >> I do have a working solution for synching my databases (with randomly >> generated ROWIDs). The problem I face >> is that I cannot get the rowid of a newly created record to pass thru back