Re: [sqlite] Question about shared cache and read_uncommitted

On Sat, 2007-03-10 at 14:11 +0900, Brownie wrote: > Hi, > > I have two questions about shared cache mode of SQLite. > > 1. When is shared cache of SQLite deallocated? > A last call of sqlite3_close()? Or end of thread procedure? The former. The shared cache (and shared schema) are reference cou

Re: [sqlite] journal - "Unable to open the database file"

A suggestion for the journal files would be to make them private anonymous mapped objects. That works on both Unix and Windows and any other POSIX compatible system. Then the journals would be impervious to outside interference. With Unix the mapped object has a fixed size so there would nee

[sqlite] Question about shared cache and read_uncommitted

Hi, I have two questions about shared cache mode of SQLite. 1. When is shared cache of SQLite deallocated? A last call of sqlite3_close()? Or end of thread procedure? 2. Can I use read_uncommitted isolation in the following case? (Connection1 and Connection2 is established by the same thread a

Re: [sqlite] journal - "Unable to open the database file"

--- [EMAIL PROTECTED] wrote: > Is there something that the SQLite core can do better? Perhaps exclusive locks on journal files would help avoid this problem. Or are the -journal and etilqs_* files supposed to be sharable by other sqlite processes? http://www.backupassist.com/BackupAssist/faq.ht

Re: [sqlite] Different ROWID and PRIMARY KEY values

Luca Moratto wrote: Thanks Gerry, but I can Create my table in memory from an attached db, I can Insert new rows and I can Select the new rows and all values are correct, except for my key field that is 0. My Insert statement is INSERT INTO myTable VALUES (?,?,?); I prepare this statement wi

Re: [sqlite] .import escaping \n

Python with SQLObject would make this simple, you won't even have to write SQL. Define your data model then split the cvs into a list (array). for line in file: line.split(',') Table(col1=line[0],col2=line[1],col3=line[2]) if you have a table with a large amount of columns you coul

Re: [sqlite] sin and similar functions

Jakub Ladman wrote: Thank you very much. Not only my english is poor, but my coordinated geometry too :-( But my software will make much more geometrical computations, so probably some in queries too. Please let You (or someone) direct me to the relevant part of documentation for defining new f

Re: [sqlite] sin and similar functions

A poster here, "Mikey C", wrote some math functions and posted them a month or so ago. You might have a look at http://www.mail-archive.com/sqlite-users@sqlite.org/msg21791.html -Clark - Original Message From: Jakub Ladman <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday,

Re: [sqlite] are nested joins possible ?

thanks guys, for the fast and different responses, I really appreciate that. ... now I need a couple hours to study all your ideas. -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL PR

Re: [sqlite] sin and similar functions

I could copy the example from the Sqlite documentation or you could just look it up in the API description. You write your function, in this case only a few lines of code, and bind it to Sqlite using the API. http://www.sqlite.org/capi3ref.html sqlite3_create_function Jakub Ladman wrote: But

Re: [sqlite] sin and similar functions

Jakub, The documentation for creating user-defined functions is at . See section 2.3. Unfortunately, I don't know the A,B of C, so I can't guide you in this. On the other hand, if you are using Perl, I can write you a step-by-step process for creating your own fu

Re: [sqlite] sin and similar functions

Thank you very much. Not only my english is poor, but my coordinated geometry too :-( But my software will make much more geometrical computations, so probably some in queries too. Please let You (or someone) direct me to the relevant part of documentation for defining new functions. Thank You J

RE: [sqlite] Re: are nested joins possible ?

Igor, I was able to run the query with just a sub-select alias and no column aliases. No error on the duplicated PatNr column from the inner select *. I agree that I would expect sqlite to produce some kind of ambiguous column name error or something but didn't get one. Best regards, Sam

RE: [sqlite] are nested joins possible ?

give the nested select an alias so you can reference it: SELECT * FROM Patient_Text INNER JOIN ( SELECT * FROM Patient INNER JOIN Opnamen ON Patient.PatNr = Opnamen.PatNr ) N ON N.PatNr = Patient_Text.PatNr But if this is your actual query then I would suggest either joining all

Re: [sqlite] are nested joins possible ?

Stef Mientki wrote: I thought this would work, SELECT * FROM Patient_Text INNER JOIN ( SELECT * FROM Patient INNER JOIN Opnamen ON Patient.PatNr = Opnamen.PatNr ) ON Patient.PatNr = Patient_Text.PatNr But I get an error on the second use of Patient.PatNr. Is there a

Re: [sqlite] sin and similar functions

But the question was "how" Probably i am asking time after time stupid questions only - It is because my english is not half good to orientate oneself easily in the documentation, so quick summary in someones answer makes more than hours of reading docs. Usualy i am asking if i understand not to

[sqlite] Re: are nested joins possible ?

Stef Mientki <[EMAIL PROTECTED]> wrote: I thought this would work, SELECT * FROM Patient_Text INNER JOIN ( SELECT * FROM Patient INNER JOIN Opnamen ON Patient.PatNr = Opnamen.PatNr ) ON Patient.PatNr = Patient_Text.PatNr But I get an error on the second use of Patie

Re: [sqlite] .import escaping \n

Jacky J wrote: How do you properly escape the endline character when using csv import? MySQL for example uses \n, but sqlite puts a linefeed directly into the export. However, each line is delimited by a linefeed, so sqlite will get confused when it tries to import. Do i have to resort to inse

Re: [sqlite] sin and similar functions

Jakub Ladman wrote: I will have table with sequence of coordinates (two dimensional space) and corresponding radiuses, so sequence of circles. And i need to use a sqlite query to detect if a actual coordinates (after their measurement) match some of the circle's square or not. And which circle,

[sqlite] are nested joins possible ?

I thought this would work, SELECT * FROM Patient_Text INNER JOIN ( SELECT * FROM Patient INNER JOIN Opnamen ON Patient.PatNr = Opnamen.PatNr ) ON Patient.PatNr = Patient_Text.PatNr But I get an error on the second use of Patient.PatNr. Is there a way to get such a ne

RE: [sqlite] Is there an inverse for .import?

Not an option for what I'm doing. -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:19 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? On Fri, 9 Mar 2007, Dennis Cote wrote: > You can get csv output from

RE: [sqlite] Is there an inverse for .import?

Yes, unlike .dump, that works. Thanks very much. jim -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:05 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? Anderson, James H (IT) wrote: > I need to "export"

Re: [sqlite] Is there an inverse for .import?

On Fri, 9 Mar 2007, Dennis Cote wrote: You can get csv output from sqlite using the .mode command to specify the output format and the .output command to set the output file. .mode csv .headers on .output mytable.csv select * from mytable; .output stdout Or, use the SQL format for

Re: [sqlite] stupid man's manual to sqlite?

* Say goodbye to the index subcontractor, and as an idea: Why not a mini-CD, or a downloadable file with the index? (editors: thought in that, but please, not patent it, the idea is mine :-)) As Samuel and James also feel that the index is poor, then it clearly needs some improvement. I will fo

Re: [sqlite] Is there an inverse for .import?

Anderson, James H (IT) wrote: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? jim You can get csv output from sqlite using the .mode command to specify the output format and

Re: [sqlite] journal - "Unable to open the database file"

[EMAIL PROTECTED] wrote: J. Edgar Hoover R. Buckminster Fuller F. Scott Fitzgerald T. Woodrow Wilson H. Ross Perot F. Lee Bailey C. Everett Koop L. Ron Hubbard G. Gordon Liddy S. Truett Cathy S. Epatha Merkerson and so forth... And I do have a Ph.D. from Duke University :-) So to be accurat

Re: [sqlite] sin and similar functions

Just add a sine function in the normal manner of adding a function. It is very simple. Jakub Ladman wrote: Hi Friends Is there a possibility to have sin cos an acos, functions in sqlite? How to write it in? I really need it and i have fear, that sinus values table will be so slow and so big

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

Mitchell Vincent wrote: Fantastic idea, but I'm afraid this will all be on Windows. I'll see about getting a sed-like program to distribute with my converter, though, thanks!! check out http://unxutils.sourceforge.net/ for a Win32 version of sed -- J. Scott Wilkinson

Re: [sqlite] sin and similar functions

I am sorry, it seems to be unreadable bacause of my very bad english. I try to correct it little bit. Hi Friends :-) Is there a possibility to have sin, cos anD acos, functions in sqlite? How to write it in? I have read (Mike Owens article at LinuxJournal), that it is possible to write new funct

[sqlite] .import escaping \n

How do you properly escape the endline character when using csv import? MySQL for example uses \n, but sqlite puts a linefeed directly into the export. However, each line is delimited by a linefeed, so sqlite will get confused when it tries to import. Do i have to resort to insert statements for

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, Scott Hess <[EMAIL PROTECTED]> wrote: On 3/9/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > I'm looking into ways of changing the schema type name when I do my > SQLite2->SQLite3 conversion. Most likely I'll have to pipe the .dump > from the SQLite2 db through a program to replace '

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: If you don't have the word varchar anyplace else, e.g. in your data, you can simply do: sqlite OLD.DB .dump | sed 's/varchar/text/' | sqlite3 NEW.DB If the word varchar may exist elsewhere, or be in various cases (VARCHAR, Varchar, etc.

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: I'm looking into ways of changing the schema type name when I do my SQLite2->SQLite3 conversion. Most likely I'll have to pipe the .dump from the SQLite2 db through a program to replace 'varchar' with 'text'... I'm working on that now! You

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

"Mitchell Vincent" <[EMAIL PROTECTED]> writes: > I have an old SQLite 2.8 database that shared it's schema with > PostgreSQL. One of the nifty things about PostgreSQL (that admittedly > has me spoiled) is the ability to just say "varchar" without any > length specifier. > > Specifying "varchar" in

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, Christian Werner <[EMAIL PROTECTED]> wrote: Mitchell Vincent wrote: > > I have an old SQLite 2.8 database that shared it's schema with > PostgreSQL. One of the nifty things about PostgreSQL (that admittedly > has me spoiled) is the ability to just say "varchar" without any > length spe

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

Mitchell Vincent wrote: > > I have an old SQLite 2.8 database that shared it's schema with > PostgreSQL. One of the nifty things about PostgreSQL (that admittedly > has me spoiled) is the ability to just say "varchar" without any > length specifier. > > Specifying "varchar" in SQLite works great

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

On 3/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > Now comes the fun part. I'm converting these databases (and there are > a LOT of them), I'm doing "sqlite OLD.DB .dump | sqlite3 NEW.DB" which > works flawlessly. Is there any way to change t

[sqlite] sin and similar functions

Hi Friends Is there a possibility to have sin cos an acos, functions in sqlite? How to write it in? I really need it and i have fear, that sinus values table will be so slow and so big for critical precission. I will need to select coordinates which are laying in circle of known center and radi

Re: [sqlite] journal - "Unable to open the database file"

[EMAIL PROTECTED] wrote, Gunnar Roth <[EMAIL PROTECTED]> wrote: > Dr Hipp, > Nice to see that i am not the only one you read drh as Dr. H. ;-) in fact his name is D. Richard Hipp. But i have never seen before the habit to abreviate the first surname. J. Edgar Hoover R. Buckminster Fuller

Re: [sqlite] Script Language

Hi, Well, another way to stand on the shoulders of giants is to use the work of those giants to build up your own. Regards, Eugene Wee John Stanton wrote: Both Knuth and Wirth use the approach of a language of their own design to teach algorithms (and more). Cesar, like Newton, will see far

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

"Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > Now comes the fun part. I'm converting these databases (and there are > a LOT of them), I'm doing "sqlite OLD.DB .dump | sqlite3 NEW.DB" which > works flawlessly. Is there any way to change the schema on the fly to > say "Varchar(1024)" instead of

[sqlite] Re: journal - "Unable to open the database file"

> >How does your hack improve upon [3200]? > > http://www.sqlite.org/cvstrac/chngview?cn=3200 That looks like essentially the same fix I use, and in fact (based on old correspondance with you 6/4/2006) I think you derived it from a file I supplied.I don't regard it as a real fix, just a s

Re: [sqlite] Script Language

Both Knuth and Wirth use the approach of a language of their own design to teach algorithms (and more). Cesar, like Newton, will see far by standing on the shoulders of giants. Samuel R. Neff wrote: The original post said the goal is to teach algorithms, not programming language design. So f

[sqlite] SQLite 2 to SQLite 3 - Varchar sizes

I have an old SQLite 2.8 database that shared it's schema with PostgreSQL. One of the nifty things about PostgreSQL (that admittedly has me spoiled) is the ability to just say "varchar" without any length specifier. Specifying "varchar" in SQLite works great - no problem at all. Until I tried to

Re: [sqlite] journal - "Unable to open the database file"

Dave Dyer <[EMAIL PROTECTED]> wrote: > In general, it's known that daemon processes such as antivirus > and backup programs can unexpectedly have the journal file open, > and interfere with sqlite. If you're deploying sqlite to enduser's > machines, you can't change this. > > Absent a real solut

RE: [sqlite] Is there an inverse for .import?

I'm going to go with the approach indicated, below. Using .dump didn't work in the sense that .dump does indeed dumpt *only* in "insert into" format. Thanks, Clark. -Original Message- From: Clark Christensen [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 12:26 PM To: sqlite-users

Re: [sqlite] stupid man's manual to sqlite?

>.For the record, Apress had the index generated by a third party. I've >used the index myself recently, and frankly it worked for me -- I >found what I was looking for. >The SQL and C API references to which you refer --- taken from the >on-line documentation --- start on page 365. Furthermore, t

[sqlite] RE: How do I know what DBs I have attached?

Command Syntax => ATTACH [DATABASE] database-filename AS database-name If it is possible, keep database-name unique for perticular database-filename i.e. when issuing attach database command, everytime it should be same for perticular database-filename. So no need to track, just try to attach db

Re: [sqlite] Is there an inverse for .import?

Sorry, didn't read long enough. Fire up sqlite3 and type ".help". To "export" a table, you can do: .output /tmp/export select * from TABLE; .output stdout To import, you do: .import /tmp/export TABLE You can adjust the separator using .separator. The inverse of .dump would be .read.

Re: [sqlite] Is there an inverse for .import?

On 3/9/07, Gunnar Roth <[EMAIL PROTECTED]> wrote: Anderson, James H (IT) schrieb: > I need to "export" a table to a file in the same format as used by > .import, but I don't see any such cmd. Am I missing something, or does > such a cmd just not exist? Maybe its dumb but its called .dump ;-) S

RE: [sqlite] Is there an inverse for .import?

Thanks, I'll try that. I misunderstood the description of .dump to mean that it dumped in SQL insert format. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Friday, March 09, 2007 12:12 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] I

RE: [sqlite] Script Language

The original post said the goal is to teach algorithms, not programming language design. So for teaching algorithms I'd have to agree that using a custom language is not the best choice. For teaching how to write a programming language, then of course you want to learn how to create your own. M

[sqlite] RE: journal - "Unable to open the database file"

In general, it's known that daemon processes such as antivirus and backup programs can unexpectedly have the journal file open, and interfere with sqlite. If you're deploying sqlite to enduser's machines, you can't change this. Absent a real solution, I've hacked my copy to retry failed file op

Re: [sqlite] journal - "Unable to open the database file"

Gunnar Roth <[EMAIL PROTECTED]> wrote: > > > Dr Hipp, > > > > Nice to see that i am not the only one you read drh as Dr. H. ;-) in > fact his name is D. Richard Hipp. > But i have never seen before the habit to abreviate the first surname. > J. Edgar Hoover R. Buckminster Fuller F. Scott Fi

Re: [sqlite] Is there an inverse for .import?

>From the SQLite shell, you can send the output to a file using .output myfile.txt So .output myfile.txt select * from mytable; .output stdout will get you a pipe-delimited myfile.txt. You can change the delimiter using the .separator command, or you can use .mode to use a predefined format.

RE: [sqlite] ISO8601 8-byte packed date type

Personally I'd forgo a few millennia in exchange for more accuracy :-) Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -

RE: [sqlite] journal - "Unable to open the database file"

Doesn't have to be .db3, but there are certain extension to avoid as posted. RBS -Original Message- From: Allan, Mark [mailto:[EMAIL PROTECTED] Sent: 09 March 2007 16:52 To: sqlite-users@sqlite.org Subject: RE: [sqlite] journal - "Unable to open the database file" RB Smissaert, The da

Re: [sqlite] Is there an inverse for .import?

On 3/9/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? You should set the output to that file by using .output command and th

RE: [sqlite] journal - "Unable to open the database file"

Extensions monitored by Windows Desktop Search are stored in the registry: HKEY_CURRENT_USER\Software\Microsoft\RSSearch\ContentIndexCommon\Filters\Ext ension http://addins.msn.com/devguide.aspx I don't know what the default extension list is. Also, the wiki has information about how and what

Re: [sqlite] Is there an inverse for .import?

Anderson, James H (IT) schrieb: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? Maybe its dumb but its called .dump ;-) regards, gunnar -

[sqlite] Re: Is there an inverse for .import?

Anderson, James H (IT) wrote: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. .dump Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] --

Re: [sqlite] Script Language

It is not reinventing the wheel to develop the knowledge and skill to design an effective language then to implement it effectively. This is an admirable project which will leave its young developer "loaded for bear". Stef Mientki wrote: Cesar Rodas wrote: I am planning to develop a interp

Re: [sqlite] journal - "Unable to open the database file"

"Allan, Mark" <[EMAIL PROTECTED]> wrote: > RB Smissaert, > The database file is named .vdb. Is .vdb ok or wrong? Does it = > have to be .db3? Or is there just certian extensions I need to avoid? > > Dr Hipp, > Currently all journals have been deleted by admin, so I am currently = > trying to creat

Re: [sqlite] Is there an inverse for .import?

On 3/9/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? .dump -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. fo

RE: [sqlite] How do I know what DBs I have attached?

pragma database_list; will list all db's including attached (i.e., main, temp, plus attached). Remember attached db's are per-connection only. Personally I'd like to see an "attach if not attached" command 'cause the way I work with connections and attached db's it would have been much easier to

Re: [sqlite] Compiling the linux package on windows using LCC ?

Gussimulator wrote: Hi, I would like to compile the tar version of the sources using LCC under Windows. Since I'm not a *nix guy, I don't know where to start, because my little linux knowledge played against me. Heres the problem, I tried using the makefile with make.exe from LCC but that didn

Re: [sqlite] journal - "Unable to open the database file"

Allan, Mark schrieb: RB Smissaert, The database file is named .vdb. Is .vdb ok or wrong? Does it have to be .db3? Or is there just certian extensions I need to avoid? I quote from http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows "Be *VERY, VERY* careful what you name your dat

[sqlite] Is there an inverse for .import?

I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? jim

RE: [sqlite] stupid man's manual to sqlite?

I originally wasn't going to buy the book because according to the TOC it look like it was generally about SQL and the C API and not too much that would be helpful for us being knowledgeable in SQL in general and not using the C API. We did buy it 'cause we're basically betting our new product on

RE: [sqlite] journal - "Unable to open the database file"

RB Smissaert, The database file is named .vdb. Is .vdb ok or wrong? Does it have to be .db3? Or is there just certian extensions I need to avoid? Dr Hipp, Currently all journals have been deleted by admin, so I am currently trying to create another one to find out exactly that information for y

Re: [sqlite] 回复： [sqlite] C++ Framework

No, nothing like ACE. More like .Net or Java. ACE is a little heavier and more narrowly focused on middleware and messaging. It has none of the breadth, consistency, or generic usefulness that Reason does. Reason is all about letting you write platform agnostic code in C++ without ever having

RE: [sqlite] journal - "Unable to open the database file"

If I remember well this is a problem if you have the extension .db for the database file and I think if you change that to something like .db3 then it won't happen. RBS -Original Message- From: Allan, Mark [mailto:[EMAIL PROTECTED] Sent: 09 March 2007 16:23 To: sqlite-users@sqlite.org Su

Re: [sqlite] journal - "Unable to open the database file"

"Allan, Mark" <[EMAIL PROTECTED]> wrote: > 3) Ask if anyone can offer any advise us as to what we can do > to get around the problem of a journal file being locked and > SQLite cannot delete it? Because at the moment if this situation > occurs no one can write to that Db until the journal file h

Re: [sqlite] Compiling the linux package on windows using LCC ?

I'd like to update on my current status regarding the subject. After 3 and a half headaches, I managed to output an obj and link it with the definitions file. However: (using pseudo-paths for the sake of readability) 1) In LCC I'm using the following switches: /ansic /o "path-for\outp

[sqlite] journal - "Unable to open the database file"

I have been using SQLite as a replacement for MS Access for use in a PC application. It works well but we have been experiencing the following problem when the database file is located on a network drive. We are getting "Unable to open the database file" when trying to start a new transaction. I

Re: [sqlite] notice: embedded system and locked database

Dne čtvrtek 08 březen 2007 17:02 Martin Jenkins napsal(a): > Jakub Ladman wrote: > > Now i have discovered, that this appears only if the database file is > > stored on the nfs filesystem (posibly too slow, or something similar) > > There have been many threads on this list about NFS locking being

[sqlite] Re: How do I know what DBs I have attached?

jose isaias cabrera <[EMAIL PROTECTED]> wrote: What I would like to know is, how do I know if I have a db attached already? Realize that a set of attached DBs is a property of a connection (a sqlite3* handle), not some kind of persistent state of the database. You seem to be under impression

Re: [sqlite] Script Language

Cesar Rodas wrote: I am planning to develop a interpreted language with LEMON && FLEX. The main goal is to provide a easy way to script commons actions, and to teach algorithm in my University (National University of Asuncion - Paraguay). The language have syntax as PHP and Python I wonder w

RE: [sqlite] stupid man's manual to sqlite?

FWIW, excepting the index which is truly terrible, this is one of the better technical books I've encountered. It has certainly been invaluable for me. jim -Original Message- From: Mike Owens [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:16 PM To: sqlite-users@sqlite.org Sub

Re: [sqlite] Sqlite3_open() Hangs...

On 3/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: The system is hanging at the call to sqlite3_open(). It is not returning any Failures. Just Hangs... Please through some light on the same Assuming it's not an OS or hardware problem, can it be undoing a very long transac

[sqlite] Compiling the linux package on windows using LCC ?

Hi, I would like to compile the tar version of the sources using LCC under Windows. Since I'm not a *nix guy, I don't know where to start, because my little linux knowledge played against me. Heres the problem, I tried using the makefile with make.exe from LCC but that didnt work out (it said

[sqlite] How do I know what DBs I have attached?

Greetings! Yesterday you guys taught me how to attach a DB and INSERT or REPLACE records using the REPLACE command, which is soo much faster than for each RECORD. Anyway, this update is client driven, so anyone of them could hit the UpdateDB button at any time and, well, you know. So, s

Re: [sqlite] Script Language

Will be written in C. I don't know too much of C++. Will be like python. Will have Class, Functions, and lineal execution. And I just want people to be there when i need to do test, and/or people to suggest the grammar, syntax. I mean more the "Language Design". And why not helping with code On

Re: [sqlite] Script Language

Cesar Rodas a écrit : Your help will be welcome. On 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote: Cesar Rodas a écrit : > I am planning to develop a interpreted language with LEMON && FLEX. > The main > goal is to provide a easy way to script commons actions, and to teach > algorithm in

Re: [sqlite] Script Language

Your help will be welcome. On 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote: Cesar Rodas a écrit : > I am planning to develop a interpreted language with LEMON && FLEX. > The main > goal is to provide a easy way to script commons actions, and to teach > algorithm in my University (National

Re: [sqlite] Script Language

Cesar Rodas a écrit : I am planning to develop a interpreted language with LEMON && FLEX. The main goal is to provide a easy way to script commons actions, and to teach algorithm in my University (National University of Asuncion - Paraguay). The language have syntax as PHP and Python I am plan

[sqlite] Script Language

I am planning to develop a interpreted language with LEMON && FLEX. The main goal is to provide a easy way to script commons actions, and to teach algorithm in my University (National University of Asuncion - Paraguay). The language have syntax as PHP and Python I am planning to create a SQLite

[sqlite] Sqlite3_open() Hangs...

Hi All, The system is hanging at the call to sqlite3_open(). It is not returning any Failures. Just Hangs... Please through some light on the same Thanks, Regards, Ravi K The information contained in this electronic message and any attachments to this message ar