[sqlite] .import not working the same in sqlite3.3.3 (exe)

2006-02-05 Thread Randall
Hi, My posts here do not seem to start a new thread at the forum site;; oh well... I have found, btw, that i have to stick with version 3.2.8 for my csv import; I have not worked out if it is the getting of the header line first, or the .import which is at fault.? Has anyone else found a problem

[sqlite] New benchmark comparisons

2006-02-05 Thread Robert Simpson
I haven't completed all the tests I want to run, but it makes for an interesting read: http://sqlite.phxsoftware.com/forums/622/ShowPost.aspx I compared SQLite to Jet (Access), VistaDB and Firebird. I will probably add PostgreSQL to the list as well, but as far as I know they don't have an

Re: [sqlite] bulk processes with dll or obj versions?

2006-02-05 Thread Clay Dowling
Randall wrote: Hi, I have a DOS wrapper running sqlite3.exe at present. Do either the dll version or obj wrapper versions accept ".import" or ".output" or equivalent as a bulk process to and from csv, or only line by record? If so, what are the commands? [noting that "copy" is removed from

[sqlite] bulk processes with dll or obj versions?

2006-02-05 Thread Randall
Hi, I have a DOS wrapper running sqlite3.exe at present. Do either the dll version or obj wrapper versions accept ".import" or ".output" or equivalent as a bulk process to and from csv, or only line by record? If so, what are the commands? [noting that "copy" is removed from version 3 on?..]

Re: [sqlite] ANN: SQLiteSpy 1.5.1 released

2006-02-05 Thread Joe Wilson
That's great! Looking forward to it. --- Ralf Junker <[EMAIL PROTECTED]> wrote: > Hello Joe Wilson, > > I want to thank you and everybody else to share their thoughts on SQLiteSpy > and let you know > that I very much value your feedback. I initially wrote SQLiteSpy for my own > personal needs

Re: [sqlite] SQLite usage (a project management question)

2006-02-05 Thread Eugen Stoianovici
Sorry for that question...after two days with no sleep it seemd resonable. After six hours of sleep, i seem to think more clearly. John Stanton wrote: You don't have much text so you can easily take your choice, flat file or DBMS. The decision would be one based on how you intend to use the

Re: [sqlite] ANN: SQLiteSpy 1.5.1 released

2006-02-05 Thread Ralf Junker
Hello Joe Wilson, I want to thank you and everybody else to share their thoughts on SQLiteSpy and let you know that I very much value your feedback. I initially wrote SQLiteSpy for my own personal needs only, but it has since then certainly improved thanks to the responses I have received by

Re: [sqlite] Re: ANN: SQLiteSpy 1.5.1 released

2006-02-05 Thread Ralf Junker
Hello Nahor, there is no need for you to use SQLiteSpy 1.4 to create SQLite 3.2.x compatible database files. You can do so with the latest version of SQLiteSpy as well. Here's how to do so: 1. Create a new database as usual. 2. Execute the following two SQL statements: PRAGMA

Re: [sqlite] examples of syntax

2006-02-05 Thread Kurt Welgehausen
> examples of syntax ... than the "syntax" page from the home page Try Googling for 'sql tutorial'. Regards

[sqlite] float data gets truncated

2006-02-05 Thread jfak (sent by Nabble.com)
Hello, I am using sqlite with tclsqlite-2.8.15.so. I am finding that in some cases float values are getting truncated. For example 3.22 returns only 3. What is wrong ? Thanks -- View this message in context: http://www.nabble.com/float-data-gets-truncated-t1063314.html#a2766216 Sent from

Re: [sqlite] SQLite usage (a project management question)

2006-02-05 Thread John Stanton
You don't have much text so you can easily take your choice, flat file or DBMS. The decision would be one based on how you intend to use the text. Eugen Stoianovici wrote: I need some help...I'm writing an app which scans some pictures and then performs ocr on those pictures saving a text

Re: [sqlite] ANN: SQLiteSpy 1.5.1 released

2006-02-05 Thread albert drent
In general there are advantages and disadvantages about static linking of dll's. Major advantage is that if it works, you don't have to bother about dll's. But if you have more app's using the database then it might be a disadvantage. I like to use same version with all my apps and use a central

Re: [sqlite] ANN: SQLiteSpy 1.5.1 released

2006-02-05 Thread Vishal Kashyap
Hi , Can I download SQLiteSpy some other link. It seems my ISP has some issues connecting to the site. Much better if someone can e-mail me SQLiteSpy straight away. Thanks in advance. Regards, Vishal Kashyap http://vishal.net.in On 2/2/06, Ralf Junker <[EMAIL PROTECTED]> wrote: > Hello, > >