Re: [sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Florian v. Savigny wrote: > I was completely aware it is not intended as > the standard way for programs to access an SQLite database, Yes, this isn't documented as such but DRH does mention it now and then. However if you look at the SQLite web site

[sqlite] how to build TCL testing environment

Hello,Everyone I just have a project based on SQLite.For some reasons, I have to change SQLite source code to cater for our requirement . There are a lot of TCL Testing cases in the SQLite. So I want to configure the testing environment in the Windows Operation System to test by TCL scri

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

Very well said. Harold Wood & Meyuni Gani -Original Message- From: Jay A. Kreibich Sent: Sunday, June 14, 2009 8:44 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ? On Sat, Jun 13, 2009 at 11:42:21PM +0100,

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

On Sat, Jun 13, 2009 at 11:42:21PM +0100, Simon Slavin scratched on the wall: > Do any of you have experience with doing this ? Are there some > conclusive points which will make me decide immediately that I should > do it one way or the other ? I accept reasoned argument, URLs, > anecdote

[sqlite] Error message from RAISE just plain text ?

I'm getting my information about RAISE from and an example from To my surprise, error-message is not defined in which should prob

Re: [sqlite] SQlite3 - SQL injection using ruby

dave lilley wrote: > I am using sqlite3 with ruby and hope I'm not out of place here in ask for > some help on how to stop or reduce injection threats via sql statements made > by a user be it accidental or deliberate. > > I want to build a select query from user entered data and then return rows >

Re: [sqlite] How can I create an automatically generated primary key id column.

On 14 Jun 2009, at 6:52pm, Tim Bradshaw wrote: > Well, it can if you are willing to be a bit devious. Something like > this works: > > create table frobs ( > id integer primary key, > frob varchar); > > create temporary table frobs_import ( > frob varchar); > > .import data frobs_import > > i

Re: [sqlite] How can I create an automatically generated primary key id column.

在 2009-06-14日的 18:33 +0100，Simon Slavin写道： > On 14 Jun 2009, at 4:43pm, Kermit Mei wrote: > > > But I want to insert values from a file underlinux, > > and I don't want write any code for it. > > Okay, that kind of information is important enough to appear in your / > first/ post. > > > I hope

Re: [sqlite] How can I create an automatically generated primary key id column.

On 14 Jun 2009, at 18:33, Simon Slavin wrote: >> I hope sqlite3 > .import FILE >> can do it > > It can't. Well, it can if you are willing to be a bit devious. Something like this works: create table frobs ( id integer primary key, frob varchar); create temporary table frobs_import ( fr

Re: [sqlite] How can I create an automatically generated primary key id column.

On 14 Jun 2009, at 4:43pm, Kermit Mei wrote: > But I want to insert values from a file underlinux, > and I don't want write any code for it. Okay, that kind of information is important enough to appear in your / first/ post. > I hope sqlite3 > .import FILE > can do it It can't. However, if y

Re: [sqlite] How can I create an automatically generated primary key id column.

在 2009-06-14日的 14:50 +0100，Simon Slavin写道： > On 14 Jun 2009, at 2:23pm, Kermit Mei wrote: > > > I want to create a new table, its primary key is an int 'id' column, > > but > > I don't want to insert the data by hand, I hope the system can > > generate > > it by adding id. > > > > For example,

Re: [sqlite] Shortest time interval? [Was: Re: repeating events?]

Allen Fowler wrote: > > > >> You could be storing event duration, not stop time. Or perhaps store >> both. >> >> > > Here is what I have so far: > > sqlite> create table events (id INTEGER PRIMARY KEY AUTOINCREMENT, name, > kind, start, end); > > # Now add some events for "tomorrow" > s

Re: [sqlite] SPHiveDB: A server for sqlite database.

"Olaf Schmidt" schrieb im Newsbeitrag news:h131eu$m0...@ger.gmane.org... > Loop 1000 times > With LoopCounter Modulo 7 (case-switch) > ... > ... > Ending up with 11 new records in the DB Ok - make the loop-counter 7000 to reach the result of 11 new records. Sorry. Olaf

Re: [sqlite] SPHiveDB: A server for sqlite database.

"stephen liu" schrieb im Newsbeitrag news:e5a33d590906140609h4f3f35fah9083be3560f5d...@mail.gmail.com... http://code.google.com/p/sphivedb/ > SPHiveDB is a server for sqlite database. It use JSON-RPC over > HTTP to expose a network interface to use SQLite database. > It supports combining multip

Re: [sqlite] How can I create an automatically generated primary key id column.

On 14 Jun 2009, at 2:23pm, Kermit Mei wrote: > I want to create a new table, its primary key is an int 'id' column, > but > I don't want to insert the data by hand, I hope the system can > generate > it by adding id. > > For example, > mytable(id, name, age) > > When I insert name and age, th

Re: [sqlite] How can I create an automatically generated primary key idcolumn.

Kermit Mei wrote: > I want to create a new table, its primary key is an int 'id' column, > but I don't want to insert the data by hand, I hope the system can > generate it by adding id. http://sqlite.org/autoinc.html Igor Tandetnik ___ sqlite-users

[sqlite] How can I create an automatically generated primary key id column.

Hello, community! I want to create a new table, its primary key is an int 'id' column, but I don't want to insert the data by hand, I hope the system can generate it by adding id. For example, mytable(id, name, age) When I insert name and age, the id is generated automatically. And another que

[sqlite] SPHiveDB: A server for sqlite database.

http://code.google.com/p/sphivedb/ SPHiveDB is a server for sqlite database. It use JSON-RPC over HTTP to expose a network interface to use SQLite database. It supports combining multiple SQLite databases into one file. It also supports the use of multiple files ( through Tokyo Cabinet ). It is de

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

On 14 Jun 2009, at 12:09pm, Kees Nuyt wrote: > [useful stuff] Many thanks for this, which was useful throughout. I'm still interested in anything other people have to say. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.o

[sqlite] SQLITE_IOERR_READ errors

Hello. I'm seeing SQLITE_IOERR_READ errors in an application that reads from a SQLite .db file in one or more threads.? The 3.6.14.2 SQLite Amalgamation was compiled with SQLITE_THREADSAFE=1 defined.? Each thread has its own sqlite3* that is openned with sqlite3_open_v2 using these flags:? S

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

On Sat, 13 Jun 2009 23:42:21 +0100, Simon Slavin wrote: >I'm writing an application which involves lots of relations between >tables. Seen from a high level, my application will have to enforce >lots of rules to ensure database integrity. Before I used SQLite I >would have enforced all th