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
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
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,
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
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
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
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.
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
8 matches
Mail list logo