[sqlite] Javascript API for SQLite?

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

On 14 mai 2012, at 21:03, Kees Nuyt wrote: > On Mon, 14 May 2012 05:41:08 +, YAN HONG YE > 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 >

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

On 17 avr. 2012, at 11:35, Richard Hipp wrote: On Tue, Apr 17, 2012 at 5:12 AM, Paxdo Presse > 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 :-),

Re: [sqlite] select null values in python

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 &q

Re: [sqlite] select null values in python

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

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

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

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

Re: [sqlite] C# amalgamation hand holding requested

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. H

Re: [sqlite] C# amalgamation hand holding requested

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

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

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

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

Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org<mailto:sqlite-users-boun...@sqlite.org> [sqlite-users-boun...@sqlite.org<mailto:sqlite-users-boun...@sqlite.org>] on behalf of Jean-Denis MUYS [jdm...@kleegroup.com<mailto:jd

[sqlite] splitting a line to produce several lines?

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

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

On 23 juin 2011, at 16:22, Mr. Puneet Kishor wrote: > > > > On Jun 23, 2011, at 10:18 AM, Stephan Beal 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

Re: [sqlite] Garbled data after binding

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

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] SQLite in Xcode

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 >

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

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) [...] >

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

On 19 mai 2011, at 17:32, Chris Dillman wrote: > > > On 5/19/11 10:26 AM, "Richard Hipp" 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. >>> >>

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

nt, 0); NSLog(@"This file has %d levels 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 __

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

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

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 >

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

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. I

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

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] Advice to choose an index for quad tree?

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?

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

case you get the former without the latter. Also, similar to the Valgrind idea, I strongly suggest that you run your project under LLVM static analyzer if you haven't already. It's rather smart and it may uncover a bug. Again, the Clang 2.0 version is better than the old one. F

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

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 > . Indeed. I assumed the programmer had included the standard headers. On my system, any

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

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] Propose minor incompatible API change

On 11 janv. 2011, at 13:15, Richard Hipp wrote: > On Tue, Jan 11, 2011 at 6:59 AM, Jean-Christophe Deschamps > wrote: > >> >> My rationale is that either it's technically or economically feasible >> for the offending applications' developpers to change their code to use >> the

Re: [sqlite] Propose minor incompatible API change

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 >

Re: [sqlite] Storing AVCHD files

On 6/9/10 14:37 , "Simon Slavin" 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

Re: [sqlite] Storing AVCHD files

On 6/9/10 13:55 , "Navaneeth Sen B" 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

Re: [sqlite] Storing AVCHD files

On 6/9/10 13:26 , "Pavel Ivanov" 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

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

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] What languages can include SQLite statically?

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] SQLite template files

On 4/6/10 18:50 , "BareFeet" 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

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

On 4/1/10 4:12 , "Neville Franks" wrote: > Thursday, April 1, 2010, 12:16:13 PM, you wrote: > > JJD> On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski > JJD> wrote: There were many problems with that approach: >>> ... (3) Each

Re: [sqlite] Preserving column size

On 3/29/10 23:10 , "Tim Romano" 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

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

On 2/24/10 19:19 , "D. Richard Hipp" 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

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

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: >> >>> Rog

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

On 2/24/10 9:36 , "Simon Davies" wrote: > On 23 February 2010 17:44, newlog wrote: >> OK, >> >> I really don't understand >> > > Rogue semicolon on line > >>  if( sqlite3_close( db ) != SQLITE_OK ); > > Regards, > Simon I have

Re: [sqlite] overwritten iphone contacts

On 1/30/10 19:21 , "Roger Binns" 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

Re: [sqlite] SQL question

On 12/15/09 13:16 , "Florian Schricker" 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

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

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 feat

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

On 12/13/09 16:34 , "Jay A. Kreibich" 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

Re: [sqlite] Running out of space

On 11/25/09 10:50 , "Simon Slavin" 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,

Re: [sqlite] Data converting

On 11/24/09 14:08 , "Igor Tandetnik" 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))>>

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

On 11/19/09 14:55 , "Tim Romano" 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

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

On 11/17/09 6:10 , "Bogdan Ureche" 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. > >

Re: [sqlite] Output in currency format

On 11/13/09 6:31 , "Dan Bishop" 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

Re: [sqlite] Some clarification needed about Unicode

On 10/29/09 12:55 , "A.J.Millan" 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" wrote: > You > can use

Re: [sqlite] Some clarification needed about Unicode

On 10/29/09 10:51 , "John Crenshaw" 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] New open source data synchronization tool

On 10/9/09 10:54 , "Cjkalbente" 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

Re: [sqlite] Synchronising multiple copies of a database

On 10/7/09 21:35 , "Adam DeVita" 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, >

Re: [sqlite] Synchronising multiple copies of a database

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

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

On 10/6/09 15:47 , "Simon Slavin" 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

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

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

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

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

On 8/21/09 14:18 , "shakeeb khan" 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"

Re: [sqlite] "Bad CPU type in executable"?

On Aug 7, 2009, at 1:26 PM, Hamish Allan wrote: > On Wed, Aug 5, 2009 at 8:20 PM, Jean-Denis Muys<jdmuys...@free.fr> > wrote: > >> No I don't (even though I don't speak English natively). If you >> google >> "top posting evil" you will realize t

Re: [sqlite] "Bad CPU type in executable"?

On Aug 5, 2009, at 8:32 PM, Hamish Allan wrote: > On Wed, Aug 5, 2009 at 5:50 PM, Jean-Denis > Muys<jdm...@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

Re: [sqlite] "Bad CPU type in executable"?

hey interact with dylib files? > > Thx. again. > > Jimmy Verner > 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: >> >&g

Re: [sqlite] "Bad CPU type in executable"?

On 8/5/09 17:48 , "Jimmy Verner" 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] What is a Relation?

On 7/27/09 16:33 , "CityDev" 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

Re: [sqlite] SQL Syntax

hen this query will think 1988 is a full year. Ditto if the data ends early in december. So it seems to me that it works for you by luck, because your data set doesn't start in january, nor ends in december. Unless of course if I am totally wrong, which happens often enough. Jean-Denis Muys

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

On 7/7/09 8:47 , "Nicolas Williams" 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

Re: [sqlite] getting offending constraint

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

Re: [sqlite] sqlite programmed in C++

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?

On 5/19/09 2:44 PM, "Igor Tandetnik" 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

Re: [sqlite] error in documentation of SELECT?

t of the time made the opposite choice than mathematicians. I can live with that too. > > 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?

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"

Re: [sqlite] error in documentation of SELECT?

On 5/19/09 1:57 PM, "Igor Tandetnik" wrote: > "John Machin" 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 :-( >

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

On 5/18/09 10:33 AM, "Robert Villanoa" 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: >

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

On 5/18/09 9:19 AM, "Robert Villanoa" 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

[sqlite] Syntax for column names?

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?

On 4/20/09 2:35 PM, "J. King" wrote: > On Mon, 20 Apr 2009 06:53:37 -0400, D. Richard Hipp 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

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

On 4/3/09 5:20 AM, "Dave Brown" 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

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

On 3/20/09 10:41 AM, "erfon haubenstock" 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

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

On 3/19/09 11:35 PM, "P Kishor" 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

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

On 3/19/09 11:29 PM, "erfon haubenstock" 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

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

On 3/19/09 12:20 PM, "erfon haubenstock" 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 >

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

On 3/19/09 11:07 AM, "erfon haubenstock" 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 > $

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

On 3/19/09 10:28 AM, "erfon haubenstock" 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

Re: [sqlite] In-memory databases from Perl

On 3/16/09 3:24 PM, "P Kishor" 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

Re: [sqlite] In-memory databases from Perl

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

Re: [sqlite] In-memory databases from Perl

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->

[sqlite] In-memory databases from Perl

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