[sqlite] Javascript API for SQLite?

2012-09-14 Thread Jean-Denis Muys
Hello, I work on an application that uses an SQLite database as it's binary document format (with a custom extension). Now we want to develop a Web App variation of that application, that should be able to read and write those documents/databases. Since the Web App is written in Javascript, I

Re: [sqlite] how to write line feed \n\r when output a txt file

2012-05-15 Thread Jean-Denis MUYS
On 14 mai 2012, at 21:03, Kees Nuyt wrote: On Mon, 14 May 2012 05:41:08 +, YAN HONG YE yanhong...@mpsa.com wrote: […] By the way, common lineendings are platform dependent MS Windows: \r\n = 0x0D 0x0A = cr lf Unix/Linux: \n= 0x0A = lf Apple Mac: \r= 0x0D = cr This is

Re: [sqlite] How point numbers are they stored in sqlite?

2012-04-17 Thread Jean-Denis MUYS
On 17 avr. 2012, at 11:35, Richard Hipp wrote: On Tue, Apr 17, 2012 at 5:12 AM, Paxdo Presse pa...@mac.commailto:pa...@mac.com wrote: Hi, How point numbers are they stored in sqlite? In a field with REAL affinity: round(11.578767 / 2 , 4) is displayed 5.7894 in SQLite/Navicat :-), but

Re: [sqlite] select null values in python

2012-03-22 Thread Jean-Denis MUYS
On 22 mars 2012, at 16:41, Igor Tandetnik wrote: On 3/22/2012 11:32 AM, Fabio Spadaro wrote: If I want to run a query like select * from tablename where field1 = Null select * from tablename where field1 is null; NULL is never equal any value, not even another NULL. -- Igor Tandetnik

Re: [sqlite] select null values in python

2012-03-22 Thread Jean-Denis MUYS
On 22 mars 2012, at 17:26, Igor Tandetnik wrote: On 3/22/2012 12:18 PM, Jean-Denis MUYS wrote: On 22 mars 2012, at 16:41, Igor Tandetnik wrote: On 3/22/2012 11:32 AM, Fabio Spadaro wrote: If I want to run a query like select * from tablename where field1 = Null select * from tablename

Re: [sqlite] What do people think of SQLite Root?

2012-03-05 Thread Jean-Denis MUYS
On 5 mars 2012, at 14:50, Rob Richardson wrote: Our company typically uses SQLite Spy for managing SQLite databases. I keep hoping to find something better, because SQLite Spy does not offer the ability to edit a table inside a grid. The only way to update data is to use an SQL UPDATE

Re: [sqlite] Found it

2012-01-26 Thread Jean-Denis MUYS
On 25 janv. 2012, at 22:30, John Elrick wrote: I have to say this has been a fascinating learning experience. It has been enlightening reading the SQLite code and beginning to understand its inner workings. John ___ What a thriller! I was holding my breath. Did you think

Re: [sqlite] C# amalgamation hand holding requested

2012-01-23 Thread Jean-Denis MUYS
On 20 janv. 2012, at 18:08, Simon Slavin wrote: On 20 Jan 2012, at 3:42pm, Don V Nielsen wrote: Recent conversations by users has convinced me that I would be better off using the amalgamation file instead. However, I don't know what steps in VS to do to specify the source and header

Re: [sqlite] C# amalgamation hand holding requested

2012-01-23 Thread Jean-Denis MUYS
On 23 janv. 2012, at 11:18, Simon Slavin wrote: On 23 Jan 2012, at 8:59am, Jean-Denis MUYS wrote: I am a Mac developer, and I haven't even tried to look for such documentation on Xcode. This is because the steps to follow couldn't be more obvious. Here they are: Step 1: drag

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

2011-10-18 Thread Jean-Denis MUYS
On 18 oct. 2011, at 11:47, Frank Missel wrote: I see several advantages to having a forum: 1. Several subject forums as mentioned Mail can have as many subjects as desired 2. Better view of threads with several levels being immediately displayed My mail client threads far better than

[sqlite] splitting a line to produce several lines?

2011-09-12 Thread Jean-Denis MUYS
I am migrating data from a database which has a table that describes items by kinds. Instances of those kinds are stored in one column of this table, listing each instance's id, with all ids separated by a slash /. Of course, this is a very poor design. The target system has a proper table for

Re: [sqlite] splitting a line to produce several lines?

2011-09-12 Thread Jean-Denis MUYS
Analytics Directorate From: sqlite-users-boun...@sqlite.orgmailto:sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.orgmailto:sqlite-users-boun...@sqlite.org] on behalf of Jean-Denis MUYS [jdm...@kleegroup.commailto:jdm...@kleegroup.com] Sent: Monday, September 12, 2011 3:28 AM

Re: [sqlite] lol: sqlite3 db smaller than the sum of its contents...

2011-06-23 Thread Jean-Denis Muys
On 23 juin 2011, at 16:22, Mr. Puneet Kishor wrote: On Jun 23, 2011, at 10:18 AM, Stephan Beal sgb...@googlemail.com wrote: Hi, all! Today i saw a curious thing: i store 440kb of wiki files in an sqlite3 db and the db file is only 400kb. HTF can that possibly be? After poking

Re: [sqlite] Garbled data after binding

2011-06-20 Thread Jean-Denis Muys
On 20 juin 2011, at 08:42, CodeBoy DVM wrote: NSEnumerator *enumerator = [ward objectEnumerator]; id element; while(element = [enumerator nextObject]) { You might want to modernize that code a bit (though this is likely not your problem here): for

Re: [sqlite] SQLite in Xcode

2011-05-26 Thread Jean-Denis Muys
On 26 mai 2011, at 16:49, john darnell wrote: Hello everyone. I am still trying to get SQLite to work on my Mac. I want to make sure I am doing what I should be doing. Here are the steps I have taken: 1.) I downloaded and uncompressed sqlite-autoconf-3070602.tar.gz from the

Re: [sqlite] SQLite in Xcode

2011-05-26 Thread Jean-Denis Muys
On 26 mai 2011, at 17:23, john darnell wrote: On 26 mai 2011, at 16:49, john darnell wrote: Since then I have tried using the sqlite.dylib file that comes with OSX but in doing so, some important SQLite functions (such as the prepare function) were not found during the link process. This

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

2011-05-25 Thread Jean-Denis Muys
On 25 mai 2011, at 10:40, Jan Hudec wrote: Since integer primary key is faster than primary key (object_id, side) and since the rows are mostly handled independenty (and have many other things refer to them), I construct a primary key with: object_id | (side 63) [...] Regards, Jan

Re: [sqlite] OSX building in xcode leading to crashing lib.

2011-05-20 Thread Jean-Denis Muys
On 19 mai 2011, at 17:32, Chris Dillman wrote: On 5/19/11 10:26 AM, Richard Hipp d...@sqlite.org wrote: On Wed, May 18, 2011 at 6:52 PM, Chris Dillman chris.dill...@zenimaxonline.com wrote: Im having a lot of trouble getting a working build up and running. You are building from

Re: [sqlite] How to test or create sqlite database on iPad.

2011-05-19 Thread Jean-Denis Muys
of thoroughness, self.levelsOfThoroughness); } return self; } In there you can see: - how to open a database - how to close a database - how to execute a SQL statement - how to check for error Which should be a good start. Jean-Denis Muys ___ sqlite

Re: [sqlite] How to install and configure SQLite on ipad.

2011-05-18 Thread Jean-Denis Muys
On 17 mai 2011, at 19:16, irfan khan wrote: Thanks a lot for your replay. But we are developing new application for ipad for some buisseness need and need to configure sqllite database for the same. I am MS SQL database administrator and my developer team asked me to configure sqlite for ipad.

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Jean-Denis Muys
On 16 mai 2011, at 17:01, Tito Ciuro wrote: Hello, I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on iOS is not compiled with R*Tree and FTS3. Compiling a static library of SQLite's amalgamated version weighs at about 4.3 MB, which represents almost 25% of

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

2011-05-06 Thread Jean-Denis Muys
On 4 mai 2011, at 23:22, Rolf Marsh wrote: Prior to getting this error, I opened the d/b and inserted one (1) very small record... Where do I start looking? I am using FMDB, ZBarSDK (used to read barcodes), but I can't imagine that's using all of my memory... and I have the d/b set to be a

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

2011-05-06 Thread Jean-Denis Muys
On 6 mai 2011, at 15:09, Rolf Marsh wrote: I figured this out... it was a pilot-error on my part...but I do have an additional question (see below). On 5/5/11 9:45 AM, Jean-Denis Muys wrote: On 4 mai 2011, at 23:22, Rolf Marsh wrote: a 32GB iPhone doesn't have 32GB of RAM. It has 32GB

Re: [sqlite] Advice to choose an index for quad tree?

2011-05-04 Thread Jean-Denis Muys
I found the R-Tree idea fascinating. Conceptually, this is exactly what I need. But indeed, my case is very simple: my dataset is not sparse, my tiles never overlap (for a given zoom factor), the number of tiles is still rather small, they are all rectangular and the same size (modulo edge

[sqlite] Advice to choose an index for quad tree?

2011-05-03 Thread Jean-Denis Muys
Hi, My application displays very large images at different zoom factors. I have tiled my images into individual tiles of a much smaller size. Each image has hundreds of tiles. The tiles will be used to interactively display the image and the speed of the zooming and panning is very important.

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

2011-03-02 Thread Jean-Denis Muys
. It's rather smart and it may uncover a bug. Again, the Clang 2.0 version is better than the old one. Finally, if you can reduce the issue to a small project, I'm ready to test it here and report what I can find. Regards, Jean-Denis Muys ___ sqlite

Re: [sqlite] Compiler warnings in R-Tree code under Visual StudioExpress

2011-02-18 Thread Jean-Denis Muys
On 18 févr. 2011, at 15:12, Philip Graham Willoughby wrote: Adding casts to get rid of warnings is usually the wrong answer in my experience. Certainly you should never cast the return value of a function call because that hides the problems you get when it's implicitly returning int

Re: [sqlite] Compiler warnings in R-Tree code under Visual StudioExpress

2011-02-18 Thread Jean-Denis Muys
On 18 févr. 2011, at 16:51, Philip Graham Willoughby wrote: malloc returns a 64 bit pointer of type void * No, from the caller's point of view it returns an int if you haven't included stdlib.h. Indeed. I assumed the programmer had included the standard headers. On my system, any

Re: [sqlite] Propose minor incompatible API change

2011-01-11 Thread Jean-Denis Muys
On 11 janv. 2011, at 01:54, Richard Hipp wrote: So the question to you, gentle reader, is should we make this change, and break backwards compatibility, albeit in a very obscure way, or should we be hard-nosed and force hundreds or perhaps thousands of smartphone application developers fix

Re: [sqlite] Propose minor incompatible API change

2011-01-11 Thread Jean-Denis Muys
On 11 janv. 2011, at 13:15, Richard Hipp wrote: On Tue, Jan 11, 2011 at 6:59 AM, Jean-Christophe Deschamps j...@q-e-d.orgwrote: My rationale is that either it's technically or economically feasible for the offending applications' developpers to change their code to use the library

Re: [sqlite] Storing AVCHD files

2010-06-09 Thread Jean-Denis Muys
On 6/9/10 13:26 , Pavel Ivanov paiva...@gmail.com wrote: So i assume i will have to split my AVCHD file into small files. Ok.. i am fine with that, but how will i maintain the folder structure of these split files.? If maximum supported blob size is 1Gb and you want to store a bigger data

Re: [sqlite] Storing AVCHD files

2010-06-09 Thread Jean-Denis Muys
On 6/9/10 13:55 , Navaneeth Sen B navanee...@tataelxsi.co.in wrote: Thanks Simon. Hi Jean, I dint understand the below given statement. Could you please explain this to me? possibility for the user to tamper with the files behind your application's back (though if you are using SQLite,

Re: [sqlite] Storing AVCHD files

2010-06-09 Thread Jean-Denis Muys
On 6/9/10 14:37 , Simon Slavin slav...@bigfraud.org wrote: On 9 Jun 2010, at 12:18pm, Navaneeth Sen B wrote: I would like to know how i can store an AVCHD file(It has a folder structure) having size greater than 4GB. It is unlikely that whatever filesystem you're using will allow any

Re: [sqlite] What languages can include SQLite statically?

2010-05-21 Thread Jean-Denis Muys
Well the answer is: any language with an external interface to the C ABI can link to the SQLite compiled C object code (on my planet they don't have .OBJ nor .LIB extensions. Perhaps we are not on the same planet) to yield an executable (I guess that's what you mean by 'EXE'). That include any

Re: [sqlite] Fw: What languages can include SQLite statically?

2010-05-21 Thread Jean-Denis Muys
I use Xcode, which is a front end to either clang or gcc. But I usually don't compile SQLite myself as it's a standard part of the OS. I link my code, written in Objective-C, compiled with either compiler, with the OS-provided libraries. The result is a native application. No muss no fuss.

Re: [sqlite] SQLite template files

2010-04-07 Thread Jean-Denis Muys
On 4/6/10 18:50 , BareFeet list@tandb.com.au wrote: I understand that in many cases, the SQLite database developed are intrinsically tied to and designed for the application framework in which they reside. However, even those SQLite database files can be opened and manipulated by a SQLite

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-04-01 Thread Jean-Denis Muys
On 4/1/10 4:12 , Neville Franks sql...@surfulater.com wrote: Thursday, April 1, 2010, 12:16:13 PM, you wrote: JJD On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski JJD bardzotajneko...@interia.pl wrote: There were many problems with that approach: ... (3) Each table and index is in a

Re: [sqlite] Preserving column size

2010-03-30 Thread Jean-Denis Muys
On 3/29/10 23:10 , Tim Romano tim.rom...@yahoo.com wrote: On 3/29/2010 4:19 PM, Kevin M. wrote: I have a C/C++ application in which I want to store data from a struct into a table (using SQLite 3.6.23) and later retrieve data from the table and store it back in the struct. But, I need a

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-25 Thread Jean-Denis Muys
On 2/24/10 19:12 , Mike Shal mar...@gmail.com wrote: On 2/24/10, Jean-Denis Muys jdm...@kleegroup.com wrote: On 2/24/10 9:36 , Simon Davies simon.james.dav...@googlemail.com wrote: Rogue semicolon on line if( sqlite3_close( db ) != SQLITE_OK ); Regards, Simon I have been

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-25 Thread Jean-Denis Muys
On 2/24/10 19:19 , D. Richard Hipp d...@hwaci.com wrote: On Feb 24, 2010, at 1:12 PM, Mike Shal wrote: This compiler is llvm. Check it out at http://llvm.org You can test for this mistake on the demo page at http://llvm.org/ demo FWIW, there are currently two places in SQLite

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-24 Thread Jean-Denis Muys
On 2/24/10 9:36 , Simon Davies simon.james.dav...@googlemail.com wrote: On 23 February 2010 17:44, newlog newlog2...@yahoo.fr wrote: OK, I really don't understand Rogue semicolon on line  if( sqlite3_close( db ) != SQLITE_OK ); Regards, Simon I have been bitten by such

Re: [sqlite] overwritten iphone contacts

2010-02-01 Thread Jean-Denis Muys
On 1/30/10 19:21 , Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ishak kalkavan wrote: file I could see phone numbers and contact names but in a very complex way. I couldnt find any way to match those data. The file format is documented at

Re: [sqlite] SQL question

2009-12-15 Thread Jean-Denis Muys
On 12/15/09 13:16 , Florian Schricker fschric...@gmail.com wrote: Please excuse me for being so blunt: You have no idea what I'm supposed to do here nor do you have any idea for whatever historic reason the database or table is designed as is here nor (and finally) do you have no idea about

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

2009-12-14 Thread Jean-Denis Muys
On 12/13/09 16:34 , Jay A. Kreibich j...@kreibi.ch wrote: On Sun, Dec 13, 2009 at 01:47:43PM +0300, Alexey Pechnikov scratched on the wall: On Sunday 13 December 2009 02:09:48 Roger Binns wrote: The libsqlite is locale-independent but sqlite3 shell linked with readline and it's

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

2009-12-14 Thread Jean-Denis Muys
On 12/14/09 16:56 , Jay A. Kreibich j...@kreibi.ch wrote: On Mon, Dec 14, 2009 at 10:41:04AM +0100, Jean-Denis Muys scratched on the wall: So Jay, what you are saying is that SQLite doesn't have to provide bug-free features when those features are optional? [snip] So, yes, I'm saying

Re: [sqlite] Running out of space

2009-11-25 Thread Jean-Denis Muys
On 11/25/09 10:50 , Simon Slavin slav...@bigfraud.org wrote: The message is that if you are short of space it is already too late for any software to cope with the problem. I disagree. It all depends on where you set the threshold for short of space. To give you a trivial example, if I set

Re: [sqlite] Data converting

2009-11-24 Thread Jean-Denis Muys
On 11/24/09 14:08 , Igor Tandetnik itandet...@mvps.org wrote: Renato Oliveira wrote: Hello, I'm new to SQLite, and need a query to convert a number of int format to format date and date format to format int. In PostGres the query is as follows: SELECT 14652:: bit (16)) 9): int + 1980)

Re: [sqlite] another Feature Request: char from codepoint?

2009-11-19 Thread Jean-Denis Muys
On 11/19/09 14:55 , Tim Romano tim.rom...@yahoo.com wrote: The app was written in .NET against MS-Access; my Macintosh colleagues couldn't use it. They outnumbered the Windows users. But I didn't own a Mac and had never programmed on a Mac. But now Adobe Flex/AIR with SQLite is available,

Re: [sqlite] is ticket 4037 not a bug?

2009-11-17 Thread Jean-Denis Muys
On 11/17/09 6:10 , Bogdan Ureche bogdan...@gmail.com wrote: 1. Is this a bug or not? If not, any reason why not? 2. Are other databases supporting this syntax? 3. Is this an invalid syntax according to the SQL standard? 4. Is there a workaround? I would appreciate any help. Bogdan

Re: [sqlite] Output in currency format

2009-11-13 Thread Jean-Denis Muys
On 11/13/09 6:31 , Dan Bishop danbisho...@gmail.com wrote: Microsoft Excel has a similar problem. I ran into it back when I was working in a credit union and tried to import a CSV file containing credit card numbers. Wouldn't have noticed except that credit card numbers are 16 digits long

Re: [sqlite] Some clarification needed about Unicode

2009-10-29 Thread Jean-Denis Muys
On 10/29/09 10:51 , John Crenshaw johncrens...@priacta.com wrote: 2. UTF-8 is NOT the same as ASCII for values greater than 127. ASCII only uses 7 bits values, so no larger representation can be the same as ASCII for values greater than 127. This may be seen as nit picking, but when

Re: [sqlite] Some clarification needed about Unicode

2009-10-29 Thread Jean-Denis Muys
On 10/29/09 12:55 , A.J.Millan a...@zator.com wrote: Now, do you know about some library to conver to and from UTF-8 or UTF-16 to UCS-2? [4-1b] convert with WideCharToMultiByte(CP_UTF8) On 10/29/09 12:51 , Igor Tandetnik itandet...@mvps.org wrote: You can use WideCharToMultiByte(CP_UTF8)

Re: [sqlite] New open source data synchronization tool

2009-10-09 Thread Jean-Denis Muys
On 10/9/09 10:54 , Cjkalbente jkalbe...@yahoo.com wrote: If you need an ETL open source program, best thing is to check Talend Open Studio. It is a practical and easily learnable program for ETL, data migration and synchronization. The bug reporting, the community and the forum are active.

Re: [sqlite] Synchronising multiple copies of a database

2009-10-08 Thread Jean-Denis Muys
On 10/7/09 21:35 , Adam DeVita adev...@verifeye.com wrote: One can also get a mess if Mr. Red and Mr Black both get new customers, and enter them and they both get the same ID because the auto-generated int happens to be the same. Both copies get updated with the other guy's data, they then

Re: [sqlite] [Retrieved]Re: DB Corruption

2009-10-07 Thread Jean-Denis Muys
On 10/6/09 15:47 , Simon Slavin slav...@hearsay.demon.co.uk wrote: On 5 Oct 2009, at 2:59pm, Reusche, Andrew wrote: There are very many problems associated with synchronising two copies of the same database. I'm serious: entire books are written about just this one subject. I am

Re: [sqlite] Synchronising multiple copies of a database

2009-10-07 Thread Jean-Denis Muys
On 10/7/09 11:50 , Simon Slavin slav...@hearsay.demon.co.uk wrote: On 7 Oct 2009, at 10:13am, Jean-Denis Muys wrote: [setup description] I'd appreciate some feedback here or pointers to litterature. Try really really hard just to have all sites access your MySQL database remotely

[sqlite] Passing all columns as arguments to a function?

2009-09-10 Thread Jean-Denis Muys
Hi, Is it possible to pass all columns of a table as arguments to a function in a implicit way? I tried this but it did not work: Create table studentMarks (French, English, Maths, Physics); Insert into studentMarks values (12, 9, 15, 14); Insert into studentMarks values (14, 13, 12, 8); Select

Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-09 Thread Jean-Denis Muys
On 9/8/09 22:24 , various people wrote: Unfortunately, the 3 main families of small computer operating systems have 3 different definitions of what a text file is... DOS/Windows (PC): lines are terminated with CR+LF Unix: lines are terminated with LF Macintosh: lines are terminated with

Re: [sqlite] having problem in creating new database in MAC OS

2009-08-21 Thread Jean-Denis Muys
On 8/21/09 14:18 , shakeeb khan khanshak...@msn.com wrote: tell me what is a proper way of creating database in sqllite Here is a sample terminal session on my Mac (possibly very poorly reformatted by my mail client): jdmbook:~ klee$ sqlite3 mydb.db SQLite version 3.6.12 Enter .help for

Re: [sqlite] Bad CPU type in executable?

2009-08-08 Thread Jean-Denis Muys
On Aug 7, 2009, at 1:26 PM, Hamish Allan wrote: On Wed, Aug 5, 2009 at 8:20 PM, Jean-Denis Muysjdmuys...@free.fr wrote: No I don't (even though I don't speak English natively). If you google top posting evil you will realize that evil has been associated with top posting for longer

Re: [sqlite] Bad CPU type in executable?

2009-08-07 Thread Jean-Denis Muys
On Aug 5, 2009, at 8:32 PM, Hamish Allan wrote: On Wed, Aug 5, 2009 at 5:50 PM, Jean-Denis Muysjdm...@kleegroup.com wrote: You're top-posting, it's evil, the thread is becoming messy. You need to look up the word evil sometime. No I don't (even though I don't speak English natively). If

Re: [sqlite] Bad CPU type in executable?

2009-08-05 Thread Jean-Denis Muys
On 8/5/09 17:48 , Jimmy Verner jver...@vernerlegal.com wrote: A developer built an iPhone app for me. I am exploring using it as a template for another app. The data file is called libsqlite3.0.dylib. When I try to open the file, I receive this message:

Re: [sqlite] Bad CPU type in executable?

2009-08-05 Thread Jean-Denis Muys
www.vernerlegal.com On Aug 5, 2009, at 11:22 AM, Jean-Denis Muys wrote: On 8/5/09 17:48 , Jimmy Verner jver...@vernerlegal.com wrote: A developer built an iPhone app for me. I am exploring using it as a template for another app. The data file is called libsqlite3.0.dylib. When I try to open

Re: [sqlite] What is a Relation?

2009-07-27 Thread Jean-Denis Muys
On 7/27/09 16:33 , CityDev nab...@recitel.net wrote: it's not easy to track the origin of the term in mathematics. For what it's worth (ie probably not much), my formal mathematics training in set theory taught me that a relation from a set A to a set B is a subset R of the cartesian

Re: [sqlite] SQL Syntax

2009-07-09 Thread Jean-Denis Muys
doesn't start in january, nor ends in december. Unless of course if I am totally wrong, which happens often enough. Jean-Denis Muys ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-07 Thread Jean-Denis Muys
On 7/7/09 8:47 , Nicolas Williams nicolas.willi...@sun.com wrote: On Tue, Jul 07, 2009 at 12:17:36AM +0100, Simon Slavin wrote: [...] This is way off-topic now, but, to be fair, RFC1855 is not a standard, it is an Informational status RFC -- it provides information. It possibly is never

Re: [sqlite] getting offending constraint

2009-07-02 Thread Jean-Denis Muys
Wow, I have been on the internet since 1986, and I had never realized that this could be a problem. I am often guilty of the same, for lazyness reasons, as this is a convenient way to avoid having to reenter the to, cc, and bcc fields. I went back to James' original message, which my mail client

Re: [sqlite] sqlite programmed in C++

2009-06-04 Thread Jean-Denis Muys
This is funny how language trends get interesting and sometimes a bit emotional too. We all have an opinion on them, and here is mine :-) The basic idea going around in this thread is a very conservative C is best because 1) it's universally portable, and/or 2) it's very close to the machine (ie

Re: [sqlite] error in documentation of SELECT?

2009-05-19 Thread Jean-Denis Muys
On 5/19/09 1:57 PM, Igor Tandetnik itandet...@mvps.org wrote: John Machin sjmac...@lexicon.net wrote in message news:4a129cb4.2090...@lexicon.net It's handy for checking how things work e.g. sqlite select (-1) % 7; -1 sqlite -- it's not a real modulo operator :-( What do you feel is

Re: [sqlite] error in documentation of SELECT?

2009-05-19 Thread Jean-Denis Muys
My memory failed me on a detail if I want to be rigorous. In the definition of q and r, r is a natural number, but q is a relative number, not a natural. On 5/19/09 2:06 PM, Jean-Denis Muys jdm...@kleegroup.com wrote: On 5/19/09 1:57 PM, Igor Tandetnik itandet...@mvps.org wrote: John Machin

Re: [sqlite] error in documentation of SELECT?

2009-05-19 Thread Jean-Denis Muys
. Igor Tandetnik Jean-Denis Muys ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] error in documentation of SELECT?

2009-05-19 Thread Jean-Denis Muys
On 5/19/09 2:44 PM, Igor Tandetnik itandet...@mvps.org wrote: Wikipedia gives a definition different from yours, for what it's worth: http://en.wikipedia.org/wiki/Remainder#The_case_of_general_integers Also to support my version, the same article says a bit later: Usually, in number

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Jean-Denis Muys
On 5/18/09 9:19 AM, Robert Villanoa robertvilla...@yahoo.com wrote: Hi everyone, I am new to sqlite3. My OS is Ubuntu 8.04 and it has sqlite3 3.4.2. Now I want to upgrade it to the latest version, 3.6.14, but I don't know how to do that. Here are the steps I have done (after reading

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Jean-Denis Muys
On 5/18/09 10:33 AM, Robert Villanoa robertvilla...@yahoo.com wrote: Thank you for your answer, Jean-Denis. When I type 'which sqlite3', I get the following location: /usr/local/bin/sqlite3 And the value of my PATH variable is:

[sqlite] Syntax for column names?

2009-04-28 Thread Jean-Denis Muys
Hello, My create table statement (program-generated from a text file) below yields a syntax error. I went to SQL syntax diagrams, and as far as I could see, the table-name box is not detailed in its own diagram. I suspect SQLite doesn't like column names with two periods. It this it? Here is

Re: [sqlite] which tool do they use to generate the SQL Syntax diagrams?

2009-04-20 Thread Jean-Denis Muys
On 4/20/09 2:35 PM, J. King jk...@jkingweb.ca wrote: On Mon, 20 Apr 2009 06:53:37 -0400, D. Richard Hipp d...@hwaci.com wrote: http://wiki.tcl.tk/21708 It's a shame: I far preferred the BNF: more compact, not to mention you could copy and paste as well as search the text of the syntax

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Jean-Denis Muys
On 4/3/09 5:20 AM, Dave Brown key8...@gmail.com wrote: Our software often runs into problems when run on USB keys. Specifically, calls to sqlite to read/write to the database hang infinitely, or return SQLITE_BUSY after even 10 seconds of waiting. The problem seems to be that the database

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/19/09 11:29 PM, erfon haubenstock m...@erfon.com wrote: Hi again. Thanks for trying to help me by the way : D I tried relauching terminal and even restarting my computer, but to no avail. I'm not totally sure I understand when you say: One common pitfall here is that you must

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/20/09 10:41 AM, erfon haubenstock m...@erfon.com wrote: Hey Jean-Denis! I think you may not have seen my most recent post : D I used the link you sent me (i think it was yours) that explained that the local .bash_login could be overriding my .profile. I copied the contents of

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/19/09 11:35 PM, P Kishor punk.k...@gmail.com wrote: why make things so difficult for yourself? download the amalgamation source code and untar/unzip it somwhere. type ./configure followed by make sudo make install this will put your sqlite libraries under /usr/local/ type

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 11:07 AM, erfon haubenstock m...@erfon.com wrote: Hello Jean-Denis! I did it manually in terminal. I'm not familiar with macports or finks. Here's the exact code i used: $ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx $ cd sqlite-3.6.11 $ ./configure

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 10:28 AM, erfon haubenstock m...@erfon.com wrote: This is really strange. I'm using a mac with leopard which comes with version 3.4.0 installed. I've installed 3.6.11, and it installs successfully as far as I can tell, but then when I check the version with sqlite3 --version in

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 12:20 PM, erfon haubenstock m...@erfon.com wrote: EEESH, i installed macports and when i try to port install i get an error that says the error port: command not found maybe this has something to do with it? my

[sqlite] In-memory databases from Perl

2009-03-16 Thread Jean-Denis Muys
Hello, I am quite a newbie but I already spent a significant amount of time on Google, to no avail. I have a very small Perl program which exercises the basic SQLite3 features, and it works very well. I connect from Perl to SQLite3 through DBI, because it's a no brainer. I don't know whether

Re: [sqlite] In-memory databases from Perl

2009-03-16 Thread Jean-Denis Muys
On 3/16/09 3:03 PM, Jean-Denis Muys jdm...@kleegroup.com wrote: Now I want to use an in-memory database, so I replaced my original connect statement with the one suggested at http://www.sqlite.org/cvstrac/wiki?p=PerlNotes : my $dbh = DBI-Connect(dbi:SQLite:dbname=:memory

Re: [sqlite] In-memory databases from Perl

2009-03-16 Thread Jean-Denis Muys
On 3/16/09 3:10 PM, P Kishor punk.k...@gmail.com wrote: On Mon, Mar 16, 2009 at 9:03 AM, Jean-Denis Muys jdm...@kleegroup.com wrote: Now I want to use an in-memory database, so I replaced my original connect statement with the one suggested at http://www.sqlite.org/cvstrac/wiki?p=PerlNotes

Re: [sqlite] In-memory databases from Perl

2009-03-16 Thread Jean-Denis Muys
On 3/16/09 3:24 PM, P Kishor punk.k...@gmail.com wrote: Jean-Denis, do consider correcting the wiki so others after you are not similarly misled. Done. ___ sqlite-users mailing list sqlite-users@sqlite.org