Re: [sqlite] INSERT failing.

On Mon, Mar 22, 2010 at 11:59 PM, Ted Rolle wrote: > Here's the table definition: >  1  CREATE TABLE jokes ( >  2   source    TEXT, >  3   language  TEXT, >  4   question  TEXT, >  5   answer    TEXT >  6  ); > This works. > This doesn't: > INSERT INTO jokes > VALUES ("Radio

[sqlite] INSERT failing.

Here's the table definition: 1 CREATE TABLE jokes ( 2 sourceTEXT, 3 language TEXT, 4 question TEXT, 5 answerTEXT 6 ); This works. This doesn't: INSERT INTO jokes VALUES ("Radio Eriwan","de_DE","Frage an Radio Eriwan: An welchem Tag genau starb Josef Stalin?","Man

[sqlite] suggestion - make pragma case_sensitive_like queryable

The pragma case_sensitive_like is not queryable, unlike other pragmas. Is there any reason why it's not? If not, I would like to suggest to be made queryable, for consistency. Bogdan ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] column constraint diagram

Jay, thank you for the reply, this confirms what I suspected. Incidentally, SQLite also accepts a conflict clause here although it doesn't make sense: CREATE TABLE Test( TestId INTEGER NULL ON CONFLICT ABORT, TestName TEXT NULL); Bogdan ___

Re: [sqlite] column constraint diagram

On Mon, Mar 22, 2010 at 01:52:15PM -0500, Bogdan Ureche scratched on the wall: > SQLite seems to accept the following column declaration syntax without > errors: > > CREATE TABLE Test( > TestId INTEGER NULL, > TestName TEXT NULL); > > However, there is no branch in the column constraint >

Re: [sqlite] odd behavior for sqlite/mac

I collected a little more data on this problem by powering up an old PPC mac, which is using a hardwired network connection instead of airport. The behavior is the same - when there is contention for database access, the mac puts itself to sleep. I really don't see any scenario where this can be

Re: [sqlite] Why we don't have strpos function?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Israel Lins Albuquerque wrote: > I have to talk with someone to add this function on the sqlite? Or this will > be tested and added later? SQLite is a library used in your apps. You can use the SQLite API to add or change whatever functions you

[sqlite] column constraint diagram

SQLite seems to accept the following column declaration syntax without errors: CREATE TABLE Test( TestId INTEGER NULL, TestName TEXT NULL); However, there is no branch in the column constraint diagram describing this syntax. In the

Re: [sqlite] Available alternatives to syntax diagrams in documentation

On Mon, Mar 22, 2010 at 11:13:25PM +0530, Roger Binns scratched on the wall: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Jay A. Kreibich wrote: > > On Mon, Mar 22, 2010 at 05:57:18PM +0530, Roger Binns scratched on the wall: > > > >> If you are the developer type yourself then it is a

[sqlite] 1st Call For Papers, 17th Annual Tcl/Tk Conference 2010

17th Annual Tcl/Tk Conference (Tcl'2010) http://www.tcl.tk/community/tcl2010/ October 11 - 15, 2010 Hilton Suites/Conference Center Chicago/Oakbrook Terrace, Illinois, USA Important Dates: Abstracts and proposals due August 1, 2010 Notification to authors August 15, 2010 WIP and BOF

Re: [sqlite] Available alternatives to syntax diagrams in documentation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jay A. Kreibich wrote: > On Mon, Mar 22, 2010 at 05:57:18PM +0530, Roger Binns scratched on the wall: > >> If you are the developer type yourself then it is a simple matter of >> programming :-) > > As someone that's been spending a lot of time

Re: [sqlite] Why we don't have strpos function?

I have to talk with someone to add this function on the sqlite? Or this will be tested and added later? -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list

Re: [sqlite] SQLite on Windows with Mono

If you are doing .Net development on both linux and windows I would recommend using the System.Data.SQLite ADO dataprovider found here over http://sqlite.phxsoftware.com/ over the default dataprovider found in Mono. This library will not only work on the Mono platform but will also work in Visual

Re: [sqlite] Available alternatives to syntax diagrams in documentation

On Mon, Mar 22, 2010 at 05:57:18PM +0530, Roger Binns scratched on the wall: > If you are the developer type yourself then it is a simple matter of > programming :-) As someone that's been spending a lot of time with that script, excuse me while I run around the room laughing maniacally.

Re: [sqlite] Fwd: Sqlite User

Hello, Alexis, Regarding: > how many user at the same time ken use sqlite I'm afraid the answer is, "it can vary widely depending upon your application statistics, your programming, your CPU speed and ram, etc." I'm writing to you from the sqlite users mailing list. Perhaps you could write

Re: [sqlite] INTERSECT versus INNER JOIN with latitude, longitude queries

> > Would you care to repeat those two SELECTs, but after making indices on the > X and Y columns ? > Simon, Tim, forgot to mention, there were also two indexes in the test db, on X and on Y. Without them 1,8 seconds and 1/10 data flow would not be possible )) On Mon, Mar 22, 2010 at 2:52 PM,

Re: [sqlite] to get 2 records after a special records. But wrong count, the count is 5

On Mon, Mar 22, 2010 at 12:51 AM, liubin liu <7101...@sina.com> wrote: > > Thanks, I've gotten the point, :) > > and the next question is that how to know the true count after a special > record while getting a special number records. > > It is not clear at all what you are asking. I am assuming

[sqlite] Porting Sqlite to MQX OS: Question 3

Hello I am still working away at this porting exercise, I have a couple of general questions please that I would value some comments on. The absence of a file locking mechanism in MQX means the best I can do is a "dot lock" type locking strategy. I have implemented this now, but what is

Re: [sqlite] INTERSECT versus INNER JOIN with latitude, longitude queries

Another addendum: apologies -- I hope my discussion was clear enough despite the disconnect between my head and my fingers; I just noticed that I had typed "INNER JOIN" (yikes) rather than "INNER LOOP", by which I mean fetching the rowids using an index (on LATITUDE say) and then having to

Re: [sqlite] to get 2 records after a special records. But wrong count, the count is 5

liubin liu wrote: > and the next question is that how to know the true count after a special > record while getting a special number records. I'm not sure I quite understand what you are trying to do. See if this is close: SELECT max(COUNT(*), 2) FROM t1 WHERE id>=3; Though it's not clear why

Re: [sqlite] INTERSECT versus INNER JOIN with latitude, longitude queries

On 3/22/2010 7:32 AM, Tim Romano wrote: > On 3/22/2010 2:15 AM, Max Vlasov wrote: > >>> Assuming a table where Latitude column and Longitude column each have >>> their own index: >>> >>> perform select #1 which returns the rowids of rows whose latitude meets >>> criteria >>> INTERSECT >>>

Re: [sqlite] INTERSECT versus INNER JOIN with latitude, longitude queries

On 3/22/2010 2:15 AM, Max Vlasov wrote: >> Assuming a table where Latitude column and Longitude column each have >> their own index: >> >> perform select #1 which returns the rowids of rows whose latitude meets >> criteria >> INTERSECT >> perform select #2 which returns the rowids of rows whose

[sqlite] SQLite on Windows with Mono

Hi all, I normally develop my application on Ubuntu 9.10 and things goes very smoothly, but I develop with mono with the "cross platform philosophy" on my mind so I tried to partially port my application under windows. I had very hard time to find all necessary libraries and add-ins for mono

Re: [sqlite] INTERSECT versus INNER JOIN with latitude, longitude queries

On 22 Mar 2010, at 6:15am, Max Vlasov wrote: > Ok, just test. > > Created a base with a table > > CREATE TABLE [TestTable] ([Id] INTEGER PRIMARY KEY AUTOINCREMENT, > [X] INTEGER,[Y] INTEGER) > > Filled with 1,000,000 records: > > INSERT INTO TestTable > (X, Y) > VALUES > ((random() % 5)

[sqlite] stale nfs file handle err in my database

hi , im using armlinx 2.6 kernel. sqlite 3.6.19. im getting the STALE NFS FILE HANDLE error. The following is my scenareo A Bulk insert is happening on the database. suddenly system powered off during the bulk insert. when im booting again , i got the STALE NFS FILE HANDLE error . when i do ls

Re: [sqlite] INTERSECT versus INNER JOIN with latitude, longitude queries

> > Assuming a table where Latitude column and Longitude column each have > their own index: > > perform select #1 which returns the rowids of rows whose latitude meets > criteria > INTERSECT > perform select #2 which returns the rowids of rows whose longitude meets > criteria > > Ok, just test.