Re: [sqlite] Java Database Access Code Generator

2009-01-08 Thread Thomas DILIGENT
Hello, In one hand, object persistence framework provide solutions starting from a description of your DB - object mapping. Unfortunately, these solutions are not easy to deploy. Does not seem to fit your need. In the other hand, if you just want java database access, you can have a look at

[sqlite] Efficient query of 2 related tables

2008-09-11 Thread Thomas DILIGENT
Hi, I have 2 tables: A: _ID autoinc primary key name text b integer foreign key to table B B: _ID autoinc primary key name text In sql: CREATE TABLE "A" ("_ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "name" TEXT, "b" INTEGER NOT NULL DEFAULT '0') CREATE TABLE "B" ("_ID"

Re: [sqlite] Re: Behavior of SELECT queries during transaction

2007-10-17 Thread Thomas DILIGENT
and how to chose the number of rows between begin and commit ? Thomas DILIGENT <[EMAIL PROTECTED]> wrote: Igor Tandetnik wrote: Thomas DILIGENT wrote: What about the performance issue ? What about it? You need to provide some context. Your questions, standing alone,

Re: [sqlite] Re: Behavior of SELECT queries during transaction

2007-10-17 Thread Thomas DILIGENT
Igor Tandetnik wrote: Thomas DILIGENT <[EMAIL PROTECTED]> wrote: What about the performance issue ? What about it? You need to provide some context. Your questions, standing alone, don't make much sense, no offence intended. What problem are you trying to solve, and what specif

[sqlite] Behavior of SELECT queries during transaction

2007-10-17 Thread Thomas DILIGENT
Hi all ! I would like to know what is the behavior of sqlite when performing a SELECT query during a transaction ? For example : CREATE TABLE thebeatles (_ID INTEGER PRIMARY KEY, name TEXT); BEGIN TRANSACTION; INSERT INTO thebeatles (name) VALUES ('john'); INSERT INTO thebeatles (name)