Re: [sqlite] Converting ver 2 to ver 3

2006-04-15 Thread Jens Miltner
Am 15.4.06 um 02:36 schrieb Paul Nash: I have taken the plunge and am converting from ver 2.8.16 to ver 3. I used the .DUMP method but found a problem. My char/text fields containg numbers were output as pure numbers without the quotes, so that on input to ver 3 they were stored as

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-15 Thread koneill
These days they teach the Philosophy of Science, and students get to understand why Mathematicians are awarded Arts not Science degrees. Although it seems highly pedantic it is actually very important that programmers have an insight into what they are really doing if they are to advance

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-15 Thread Aaron Jones
wow. an overload of information for a saturday morning. lol. I do indeed intend to further my maths and programming knowledge but at the moment I need to focus solely on the completion of my product and dissertation for which I only have little over 2 weeks (possibly 5 but this would eat into

Re: [sqlite] Structured or Object-Oriented?

2006-04-15 Thread Aaron Jones
Hi Kevin, my Supervisor isn't really a programmer so he may not even know this, his roots are OO design. Yes I will be using C# (if i have time to learn it, I have heard it is like Java which I already know, if not I was going to do it in VB.Net which I also know, and I found a program that

RE: [sqlite] Structured or Object-Oriented?

2006-04-15 Thread Robert Simpson
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, April 15, 2006 6:11 AM To: sqlite-users@sqlite.org; Aaron Jones Subject: Re: [sqlite] Structured or Object-Oriented? I have not done SQLite work in C#, Java or VB: I used Delphi with some sqlite

[sqlite] what is faster?

2006-04-15 Thread Cesar David Rodas Maldonado
Hello I have a software that uses four tables. that's ok.. but i wanna know if is faster if i use for every table a database ( a file) or if is the same thing in velocity if a put all the tables in one file, couse every table uses a lot of data. thanks

Re: [sqlite] Structured or Object-Oriented?

2006-04-15 Thread koneill
If you're using Visual C# Express 2005 (or any 2005 product) then you may as well go for broke and learn the ADO.NET 2.0 framework. I wrote/maintain a fairly decent SQLite ADO.NET 2.0 Provider at http://sqlite.phxsoftware.com and make myself available on the forums quite a bit. Robert I

Re: [sqlite] Structured or Object-Oriented?

2006-04-15 Thread Bert Verhees
[EMAIL PROTECTED] schreef: If you're using Visual C# Express 2005 (or any 2005 product) then you may as well go for broke and learn the ADO.NET 2.0 framework. I wrote/maintain a fairly decent SQLite ADO.NET 2.0 Provider at http://sqlite.phxsoftware.com and make myself available on the

RE: [sqlite] Structured or Object-Oriented?

2006-04-15 Thread Robert Simpson
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] I think Aaron is working in Mono: how would that work out on Linux for connecting to SQLite through DotNet (I presume that ADO.Net is Windows only!); I was suggesting that he convert VB code to C# in

[sqlite] Is it safe to read or write a table while being indexed?

2006-04-15 Thread Tito Ciuro
Hello, I was wondering whether it is safe to read or write a table while being indexed. Here's a scenario: for batch imports, it's sometimes better to DROP the indexes, do the INSERTs and then recreate the relevant indexes. Indexing may take a little bit of time, so I was wondering if:

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-15 Thread John Stanton
[EMAIL PROTECTED] wrote: These days they teach the Philosophy of Science, and students get to understand why Mathematicians are awarded Arts not Science degrees. Although it seems highly pedantic it is actually very important that programmers have an insight into what they are really doing if

[sqlite] MMAP

2006-04-15 Thread John Stanton
I wonder if members can help me with some advice. I have a program which is a multi-threaded application server with Sqlite embedded which runs on Unix and Windows. For an i/o buffer per thread I have the idea of using a mmap'd file so that it can be transferred using sendfile/TransmitFile

[sqlite] Selecting a random row from a table

2006-04-15 Thread Thomas Chust
Hello, I have a table of strings and integer primary keys from which I would like to retrieve a string at random. The best solution I could think of was to first do a SELECT count(id) FROM strings; and then a SELECT string FROM strings LIMIT 1 OFFSET ?; where the parameter is set to an

Re: [sqlite] MMAP

2006-04-15 Thread Cory Nelson
First off: SQLite is not made to be scalable. If you are concerned about performance, use something else. The only performance issue you need to worry about with memory mapping is running out of address space. BTW- I don't know about sendfile but TransmitFile does not need memory mapping. On

Re: [sqlite] Re: what is faster?

2006-04-15 Thread Jim Dodgen
The idea of putting a table per database is a little odd, I expect that is why you did not get an instant answer. typically database table are interrelated and therefore need to be joined to provide useful information. Given that there are some good reasons why you might want to keep some

Re: [sqlite] Re: what is faster?

2006-04-15 Thread Nathan Kurz
On Sun, Apr 16, 2006 at 02:23:45AM -0300, Cesar David Rodas Maldonado wrote: On 4/15/06, Cesar David Rodas Maldonado [EMAIL PROTECTED] wrote: Hello I have a software that uses four tables. that's ok.. but i wanna know if is faster if i use for every table a database ( a file) or if