Re: [sqlite] Import feature requests

Simon Slavin wrote: > On 14 Dec 2009, at 5:13am, Walter Dnes wrote: > > >> The following might be options (compile time, config file, set manually; >> I don't care), but they should be available... >> > > It might be worth writing a separate sqlite3 import facility which just reads > a

Re: [sqlite] Import feature requests

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > It might be worth writing a separate sqlite3 import facility which just reads > a .csv into a table. I betcha did not know there are at least 4 different implementations of CSV as a virtual table (2 in the wiki, one in the

Re: [sqlite] Import feature requests

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Walter Dnes wrote: > 1) import with strict typing. If I create a table with 3 numeric (real. > integer, whatever) fields, then a CSV file containing... > >2.345, 42, 27.7 > > should import as 3 numbers, not as 3 character strings What makes

Re: [sqlite] Import feature requests

On 14 Dec 2009, at 5:13am, Walter Dnes wrote: > The following might be options (compile time, config file, set manually; > I don't care), but they should be available... It might be worth writing a separate sqlite3 import facility which just reads a .csv into a table. It could have some

[sqlite] Import feature requests

The following might be options (compile time, config file, set manually; I don't care), but they should be available... 1) import with strict typing. If I create a table with 3 numeric (real. integer, whatever) fields, then a CSV file containing... 2.345, 42, 27.7 should import as 3

Re: [sqlite] SQLite version 3.6.21

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Walter Dnes wrote: > Possibly a stupid question from a relative newbie; shouldn't that be... > > sqlite3 :memory: 'create table test(fieldname integer)' integer is not a reserved word so it is perfectly valid as a column name, but I suspect the text

Re: [sqlite] SQLite version 3.6.21

On 14 Dec 2009, at 4:38am, Walter Dnes wrote: > On Tue, Dec 08, 2009 at 02:41:23AM +0100, Andreas Schwab wrote > >> It's still crashing due to undefined behaviour. >> >> $ ./sqlite3 :memory: 'create table test(integer)' >> Segmentation fault > > Possibly a stupid question from a relative

Re: [sqlite] SQLite version 3.6.21

On Tue, Dec 08, 2009 at 02:41:23AM +0100, Andreas Schwab wrote > It's still crashing due to undefined behaviour. > > $ ./sqlite3 :memory: 'create table test(integer)' > Segmentation fault Possibly a stupid question from a relative newbie; shouldn't that be... sqlite3 :memory: 'create table

Re: [sqlite] Using Parameters with views

I thought of that, and the answer is NO. actually, since my post, I did a little investigation : it is not the view that is the problem, it is the parameter when used on a column that contains the COUNT function. Weird, it seems like a genuine bug. if you replace WHERE CNT LIKE :PARAM in my

Re: [sqlite] Using Parameters with views

Do bind parameters work for you if you replace the view with a subselect? Does this work for you? select * from ( select t1.*, (select count(*) from song_artist t2 where t1.artist_id=t2.artist_id) as CNT from artists ) where CNT=:PARAM -- Darren Duncan Cariotoglou Mike wrote: > I

[sqlite] Using Parameters with views

I don't know if this has come up before, is so please point me to the right direction :) I believe that using parameterized queries with views does not work as expected. consider this (more or less self-explanatory) schema: create table artists(artist_id) create table songs(song_id) create

Re: [sqlite] Unique index on REAL values and equality check

Hello! On Monday 14 December 2009 01:35:46 Samuel Adam wrote: > > It'is not the answer to my question. Why the unique index > > can understand when REAL values are equal? > > Because the unique index is ... not converting binary to decimal. So a index compare stored binary values... Thanks.

Re: [sqlite] Unique index on REAL values and equality check

On Sun, 13 Dec 2009 17:02:05 -0500, Alexey Pechnikov wrote: > Hello! > > On Monday 14 December 2009 00:24:42 Samuel Adam wrote: >> Smells like a decimal/binary rounding error. > > It'is not the answer to my question. Why the unique _index_ > can understand when REAL

Re: [sqlite] SQLite with HTA(vbscript) Date Format Problem

"Çaðlar Orhan" schrieb im Newsbeitrag news:677fef480912130642u5ed971b2r2c9cbec17771e...@mail.gmail.com... > I am using SQLite for my little HTA application with > vbscript. > Everything is ok but in my sql query date format gets > wrong records. SQLite uses YY-MM-DD Normally

Re: [sqlite] Unique index on REAL values and equality check

Hello! On Monday 14 December 2009 01:14:25 Doug Currie wrote: > The problem is that floating point values (in SQLite shell) do not have > write-read idempotency Please read my message again. The index work correct but why? Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] Unique index on REAL values and equality check

On Dec 13, 2009, at 3:16 PM, Alexey Pechnikov wrote: > As we can see, the unique index can check equlity of REAL values > but the "=" operator can not. it's fantastic I think :-) The problem is not the "=" operator... sqlite> create table test (save_date REAL unique); sqlite> insert into test

Re: [sqlite] Unique index on REAL values and equality check

Hello! On Monday 14 December 2009 00:24:42 Samuel Adam wrote: > Smells like a decimal/binary rounding error. It'is not the answer to my question. Why the unique _index_ can understand when REAL values are equal? Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] Unique index on REAL values and equality check

On Sun, 13 Dec 2009 15:16:08 -0500, Alexey Pechnikov wrote: > Hello! > > I have some frustration about > > create table test ( > save_date REAL unique > ); > insert into test values (julianday('now')); > select * from test; > 2455179.34204073 > insert into test

Re: [sqlite] Sqlite and php

Frank, I think you might get things done faster if you take a step back from your own application and try to get a simpler PHP application working. You need to learn how the PDO system works and also what it takes to get Apache to store data on your computer. Test it command by command: make

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 7:15pm, FrankLane wrote: > Well, I have such a file that I created, because with out it, I would get an > error that reads: > > SQLSTATE[HY000] [14] unable to open database file > > So I created a junk.sqlite file and I got > > SQLSTATE[HY000] [10] disk I/O error > > so

[sqlite] Unique index on REAL values and equality check

Hello! I have some frustration about create table test ( save_date REAL unique ); insert into test values (julianday('now')); select * from test; 2455179.34204073 insert into test select * from test; Error: constraint failed select count(*) from test where save_date=2455179.34204073; 0

Re: [sqlite] Sqlite and php

Hmmm Well, I have such a file that I created, because with out it, I would get an error that reads: SQLSTATE[HY000] [14] unable to open database file So I created a junk.sqlite file and I got SQLSTATE[HY000] [10] disk I/O error so I changed permissions using chmod 777 junk.sqlite and

[sqlite] sqlite files and locking on Lustre filesystems.

My computing environment at work is bringing a new cluster online, in addition to some local storage there will be shared access to SAN style storage using the Lustre filesystem. My reading about Lustre tells me that it supports POSIX semantics, including flock and lockf (although they must be

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 5:45pm, FrankLane wrote: > Hi Simon - I don't know how to access the database created by my php program, The database is whatever file you specified when you created the database: try { $dbHandle = new PDO('sqlite:'."/Users/me/junk.sqlite"); } So your database file is the

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: > The locale of CSV file may be defined in virtualtable arguments like to > create virtual table test using VirtualText > ('/srv/projects/work/billing/export/ats.csv','utf8','','.',',',','); > > But _default_ may be system

Re: [sqlite] Sqlite and php

Hi Simon - I don't know how to access the database created by my php program, but I did put an echo after the definition of the command used by exec: $i = 0; while ($i <= 5) { $valuesSeparatedByCommas = preg_replace('/\t/', ',', $data2[$i]); $sqlcmd = 'INSERT INTO tab

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

On Sun, Dec 13, 2009 at 01:47:43PM +0300, Alexey Pechnikov scratched on the wall: > Hello! > > On Sunday 13 December 2009 02:09:48 Roger Binns wrote: > > Alexey Pechnikov wrote: > > > This is standart for all i18n applications. > > > > The SQLite shell is not an i18n application, and this is

[sqlite] SQLite with HTA(vbscript) Date Format Problem

I am using SQLite for my little HTA application with vbscript. Everything is ok but in my sql query date format gets wrong records. SQLite uses YY-MM-DD i am querying with DD-MM-YY what should i do? Thanks Caglar ___ sqlite-users mailing list

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 10:18am, FrankLane wrote: > After the loop that inserts the data > into the databease, I would like to be sure that your INSERT commands work correctly. Once you have executed the code that puts data in the database, please open the same database in the command-line tool

Re: [sqlite] Problems with loosing data

On 13 Dec 2009, at 11:04am, Marek Staniewski wrote: > We are using some application, which uses sqlite over the network. > Sometimes I observed that last entered data into application is lost. What programming language are you calling the SQLite function library from ? What operating system is

[sqlite] Problems with loosing data

We are using some application, which uses sqlite over the network. Sometimes I observed that last entered data into application is lost. I have impression that it can be done due to the fact that one of a workstation is using offline files. Assume that a workstation on which offline files are

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

Hello! On Sunday 13 December 2009 02:09:48 Roger Binns wrote: > Alexey Pechnikov wrote: > > This is standart for all i18n applications. > > The SQLite shell is not an i18n application, and this is deliberate. It is > a developer tool. That is why for example it always uses a dot for a >

Re: [sqlite] Sqlite and php

Hi - The $valuesSeparatedByCommas worked fine, but I am still having problems executing a command on the database - After the loop that inserts the data into the databease, I'm using the following code to try to execute an sqlite commmand: $sth = $dbHandle->prepare("select * from tab where