Re: [sqlite] Question about shared cache and read_uncommitted

[Dan Kennedy]

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 
counted. Resources are released as soon as the number of connections
to the shared cache drops to zero.

> 2. Can I use read_uncommitted isolation in the following case?
> 
> (Connection1 and Connection2 is established by the same thread
> and shared cache mode was enabled)
> 
> Connection1: Opened for :memory:
> ATTACH DATABASE 'mydb.db' as mydb;
> SELECT myname FROM mydb.mytable;
> 
> Connection2: Opened for mydb.db
> INSERT INTO mytable(myname) VALUES('myname');

I think so. But I'm not 100% sure I understand the question.

If Connection1 is in read_uncommitted mode, then the SELECT will
neither block nor be blocked by the INSERT statement executed
by Connection2.

That the first database file was ATTACHed instead of being opened
directly makes no difference.

Dan.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[John Stanton]

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 need to be a 
little logic to extend the size.  When I have used this method on Unix I 
have expanded the file exponentially by doubling the size at each 
expansion to minimize expansion cycles.


A bonus of using the mapped object is that i/o is a little faster 
because read and write calls and buffer shadowing are avoided.


Joe Wilson wrote:

--- [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.html

 "Basic support - open files locked with a shared lock or no lock are 
 copied and backed up after the main backup. Files with an exclusive 
 lock cannot be copied or backed up. Exclusively locked files are 
 typically SQL Server or Exchange data files."




 

No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Question about shared cache and read_uncommitted

[Brownie]

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
and shared cache mode was enabled)

Connection1: Opened for :memory:
ATTACH DATABASE 'mydb.db' as mydb;
SELECT myname FROM mydb.mytable;

Connection2: Opened for mydb.db
INSERT INTO mytable(myname) VALUES('myname');

Regards,

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Joe Wilson]

--- [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.html

 "Basic support - open files locked with a shared lock or no lock are 
 copied and backed up after the main backup. Files with an exclusive 
 lock cannot be copied or backed up. Exclusively locked files are 
 typically SQL Server or Exchange data files."



 

No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] .import escaping \n

[William F Pearson III]

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 could write a
nested "for" loop that iterates over the lines in the file then
iterates over the items in the line. I do this all the time at work to
post-process reports.

On 3/9/07, Dennis Cote <[EMAIL PROTECTED]> wrote:

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 insert
> statements
> for this?
>
> Thanks
>
I don't believe you can do this. SQLite's CSV format handling is quite
minimal and I don't believe it handles fields with embedded newline
characters (which are allowed in the CSV file format).

You may want to try some third party import tools (Jay Sprenkle has one)
or you could write your own code to import the file.

HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
William F Pearson III

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[Dennis Cote]

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


  

Jakub,

SQLite itself use the public C API to add the standard functions when it 
initializes, so there are some very good examples of writing custom 
functions in the sqlite source file func.c (see 
http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c=1.136 ).


You will need to write C functions that do similar things as the samples 
in func.c and add them to your instance of sqlite using the API at 
http://www.sqlite.org/capi3ref.html#sqlite3_create_function.


Then you can call your custom functions from your SQL statements.

I have also posted some samples of user defined functions on this list. 
You may want to search for them if you don't finfd the sqlite source 
clear enough.


HTH
Dennis Cote



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[Clark Christensen]

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, March 9, 2007 3:00:22 PM
Subject: 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
Jakub


Dne pátek 09 březen 2007 23:35 Dennis Cote napsal(a):
> 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, if match.
> > And this must be for low CPU consumption optimised, so i am not sure, if
> > separate sin table queries will be enough as fast as i need at needed
> > precission.
> >
> > The whole algorithm is proven on mssql by my colegue, but he is using the
> > native math functions.
>
> Jakub,
>
> I may not understand your problem completely, but it seems to me you can
> solve your problem without using any trigonometric functions.
>
> If you have a table of circles like this
>
> create table circle (
> id  integer primary key,
> cx  real,
> cy  real,
> r   real
> );
>
> You can find all the circles that contain a given point (px,py) using a
> simple query based in the distance between the point and the center of
> the circle.
>
> select id from circle
> where (px-cx)*(px-cx)+(py-cy)*(py-cy) < r*r;
>
> If you want to create a user defined distance function you could
> possibly speed up the calculation somewhat. You could then use a query
> like:
>
> select id from circle
> where distance(cx, cy, px, py) < r;
>
> where
>
> distance(cx, cy, px, py) = sqrt((px-cx)^2 + (py-cy)^2)
>
> HTH
> Dennis Cote
>
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] are nested joins possible ?

[Stef Mientki]

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

Re: [sqlite] sin and similar functions

[John Stanton]

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 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 some paragraph in docs.
Sometime it is enough to read it in other words.
(Something you consider as absolutely simple, may be difficult to understand, 
not technicaly, but as english text, or easy to overlook.


If you feel my questions  incommodious, please ignore it.

Thank You
Jakub Ladman




Dne pátek 09 březen 2007 22:57 John Stanton napsal(a):


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 for critical precission.

I will need to select coordinates which are laying in circle of known
center and radius.
Unfortunately at small time intervals and on a slow machine.

Thanks

Jakub

-
 To unsubscribe, send email to [EMAIL PROTECTED]
-



---
-- To unsubscribe, send email to [EMAIL PROTECTED]
---
--



-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[P Kishor]

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 functions -- it takes about 2 lines of code. If
you know C, the above mentioned documentation should point you in the
right direction.

In any case, Dennis Cote's suggestion is really fantastic. You don't
need the trig functions to solve your existing problem. Use those
suggestions and you will be well on your way.

On 3/9/07, Jakub Ladman <[EMAIL PROTECTED]> 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 functions.

Thank You
Jakub


Dne pátek 09 březen 2007 23:35 Dennis Cote napsal(a):
> 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, if match.
> > And this must be for low CPU consumption optimised, so i am not sure, if
> > separate sin table queries will be enough as fast as i need at needed
> > precission.
> >
> > The whole algorithm is proven on mssql by my colegue, but he is using the
> > native math functions.
>
> Jakub,
>
> I may not understand your problem completely, but it seems to me you can
> solve your problem without using any trigonometric functions.
>
> If you have a table of circles like this
>
> create table circle (
> id  integer primary key,
> cx  real,
> cy  real,
> r   real
> );
>
> You can find all the circles that contain a given point (px,py) using a
> simple query based in the distance between the point and the center of
> the circle.
>
> select id from circle
> where (px-cx)*(px-cx)+(py-cy)*(py-cy) < r*r;
>
> If you want to create a user defined distance function you could
> possibly speed up the calculation somewhat. You could then use a query
> like:
>
> select id from circle
> where distance(cx, cy, px, py) < r;
>
> where
>
> distance(cx, cy, px, py) = sqrt((px-cx)^2 + (py-cy)^2)
>
> HTH
> Dennis Cote
>
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=

Re: [sqlite] sin and similar functions

[Jakub Ladman]

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
Jakub


Dne pátek 09 březen 2007 23:35 Dennis Cote napsal(a):
> 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, if match.
> > And this must be for low CPU consumption optimised, so i am not sure, if
> > separate sin table queries will be enough as fast as i need at needed
> > precission.
> >
> > The whole algorithm is proven on mssql by my colegue, but he is using the
> > native math functions.
>
> Jakub,
>
> I may not understand your problem completely, but it seems to me you can
> solve your problem without using any trigonometric functions.
>
> If you have a table of circles like this
>
> create table circle (
> id  integer primary key,
> cx  real,
> cy  real,
> r   real
> );
>
> You can find all the circles that contain a given point (px,py) using a
> simple query based in the distance between the point and the center of
> the circle.
>
> select id from circle
> where (px-cx)*(px-cx)+(py-cy)*(py-cy) < r*r;
>
> If you want to create a user defined distance function you could
> possibly speed up the calculation somewhat. You could then use a query
> like:
>
> select id from circle
> where distance(cx, cy, px, py) < r;
>
> where
>
> distance(cx, cy, px, py) = sqrt((px-cx)^2 + (py-cy)^2)
>
> HTH
> Dennis Cote
>
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Samuel R. Neff]

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


---
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]
 
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 09, 2007 5:48 PM
To: SQLite
Subject: [sqlite] Re: are nested joins possible ?

SELECT *
  FROM Patient_Text
  INNER JOIN
  (
SELECT *
  FROM Patient
  INNER JOIN Opnamen
  ON Patient.PatNr = Opnamen.PatNr
  ) AS Patient
  ON Patient.PatNr = Patient_Text.PatNr

However, in this particular case you'll have a problem, since the result 
of subselect contains two columns named PatNr (one from Patient and one 
from Opnamen). So Patient.PatNr will be ambiguous. You could explicitly 
name columns in the subselect and give them aliases, then refer to them 
as SubselectAlias.ColumnAlias. But this way you won't be able to use * 
notation.

Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] are nested joins possible ?

[Samuel R. Neff]

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
three tables or using a where clause with IN instead of a nested select.

HTH,

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]
 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] are nested joins possible ?

[Dennis Cote]

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 way to get such a nested statement working ??

I'm looking for some construct that can used to generated code
from a visual design, through recursion of the links,
so it must be simple.

Stef,

The subselect produces an unnamed table as its result. If you want to 
refer to its columns you must drop the table name or add an alias to the 
subselect and use that name.


   SELECT *
FROM Patient_Text
INNER JOIN
(
   SELECT *
FROM Patient
INNER JOIN Opnamen
ON Patient.PatNr = Opnamen.PatNr
)
ON PatNr = Patient_Text.PatNr
   
   SELECT *

FROM Patient_Text
INNER JOIN
(
   SELECT *
FROM Patient
INNER JOIN Opnamen
ON Patient.PatNr = Opnamen.PatNr
) AS Pat
ON Pat.PatNr = Patient_Text.PatNr

It seems to me that  you should be able to do this without a subselect 
though.


   SELECT *
FROM Patient_Text
INNER JOIN Patient ON Patient.PatNr = Patient_Text.PatNr
INNER JOIN Opnamen ON Patient.PatNr = Opnamen.PatNr

The links in your visual tool are just joins between the tables, no need 
for the subselects.


HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[Jakub Ladman]

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 some paragraph in docs.
Sometime it is enough to read it in other words.
(Something you consider as absolutely simple, may be difficult to understand, 
not technicaly, but as english text, or easy to overlook.

If you feel my questions  incommodious, please ignore it.

Thank You
Jakub Ladman




Dne pátek 09 březen 2007 22:57 John Stanton napsal(a):
> 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 for critical precission.
> >
> > I will need to select coordinates which are laying in circle of known
> > center and radius.
> > Unfortunately at small time intervals and on a slow machine.
> >
> > Thanks
> >
> > Jakub
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> >
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: are nested joins possible ?

[Igor Tandetnik]

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 Patient.PatNr.


The whole subselect is treated as a single table, you can't address 
individual tables that went into it anymore. You can give the subselect 
an alias:


SELECT *
 FROM Patient_Text
 INNER JOIN
 (
SELECT *
 FROM Patient
 INNER JOIN Opnamen
 ON Patient.PatNr = Opnamen.PatNr
 ) AS Patient
 ON Patient.PatNr = Patient_Text.PatNr

However, in this particular case you'll have a problem, since the result 
of subselect contains two columns named PatNr (one from Patient and one 
from Opnamen). So Patient.PatNr will be ambiguous. You could explicitly 
name columns in the subselect and give them aliases, then refer to them 
as SubselectAlias.ColumnAlias. But this way you won't be able to use * 
notation.


And of course, this particular query can be rewritten as

SELECT *
 FROM Patient_Text  JOIN Patient ON Patient.PatNr = Patient_Text.PatNr
   JOIN Opnamen ON Patient.PatNr = Opnamen.PatNr;

It will also likely be much more efficient: all these nested subselects 
pretty much disable SQLite optimizer.


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] .import escaping \n

[Dennis Cote]

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

for this?

Thanks

I don't believe you can do this. SQLite's CSV format handling is quite 
minimal and I don't believe it handles fields with embedded newline 
characters (which are allowed in the CSV file format).


You may want to try some third party import tools (Jay Sprenkle has one) 
or you could write your own code to import the file.


HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[Dennis Cote]

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, if match.
And this must be for low CPU consumption optimised, so i am not sure, if 
separate sin table queries will be enough as fast as i need at needed 
precission.


The whole algorithm is proven on mssql by my colegue, but he is using the 
native math functions.


  

Jakub,

I may not understand your problem completely, but it seems to me you can 
solve your problem without using any trigonometric functions.


If you have a table of circles like this

   create table circle (
   id  integer primary key,
   cx  real,
   cy  real,
   r   real
   );

You can find all the circles that contain a given point (px,py) using a 
simple query based in the distance between the point and the center of 
the circle.


   select id from circle
   where (px-cx)*(px-cx)+(py-cy)*(py-cy) < r*r;

If you want to create a user defined distance function you could 
possibly speed up the calculation somewhat. You could then use a query like:


   select id from circle
   where distance(cx, cy, px, py) < r;

where

   distance(cx, cy, px, py) = sqrt((px-cx)^2 + (py-cy)^2) 


HTH
Dennis Cote
   


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] are nested joins possible ?

[Stef Mientki]

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 nested statement working ??

I'm looking for some construct that can used to generated code
from a visual design, through recursion of the links,
so it must be simple.

thanks,

--
cheers,
Stef Mientki
http://pic.flappie.nl


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Anderson, James H \(IT\)]

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 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 both output and input.

   At the sqlite3> prompt, type .h(elp) and see all the choices.

Rich

-- 
Richard B. Shepard, Ph.D.   |The Environmental
Permitting
Applied Ecosystem Services, Inc.|  Accelerator(TM)
 Voice: 503-667-4517  Fax:
503-667-8863


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


NOTICE: If received in error, please destroy and notify sender. Sender does not 
intend to waive confidentiality or privilege. Use of this email is prohibited 
when received in error.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Anderson, James H \(IT\)]

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" 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 the .output command to set the output file.

.mode csv
.headers on
.output mytable.csv
select * from mytable;
.output stdout

HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Rich Shepard]

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 both output and input.

  At the sqlite3> prompt, type .h(elp) and see all the choices.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.|  Accelerator(TM)
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Dennis Cote]

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 the .output command to set the output file.


   .mode csv
   .headers on
   .output mytable.csv
   select * from mytable;
   .output stdout

HTH
Dennis Cote

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Dennis Cote]

[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 accurate we should call you Dr. D. Richard Hipp Ph.D. 

I'm just curious, do you have a preference for a shorter version? 
Richard, DRH, Dr. Hipp, or perhaps Dr. D. or Dr. H? :-)


R. Dennis Cote





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[John Stanton]

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 for critical precission.


I will need to select coordinates which are laying in circle of known center 
and radius.

Unfortunately at small time intervals and on a slow machine.

Thanks

Jakub

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Scott Wilkinson]

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


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sin and similar functions

[Jakub Ladman]

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 function to expand standard set of functions as 
avg(), min(), sum() etc.

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, if match.
And this must be for low CPU consumption optimised, so i am not sure, if 
separate sin table queries will be enough as fast as i need at needed 
precission.

The whole algorithm is proven on mssql by my colegue, but he is using the 
native math functions.

Thanks

Jakub

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] .import escaping \n

[Jacky J]

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

Thanks

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

[Mitchell Vincent]

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 'varchar' with
> 'text'... I'm working on that now!

You could also write something to spelunk through the metadata and
alter things to fit.  Use 'pragma table_info(table)' to get info about
the table, then for each table you want to change, within a
transaction create a new table just like the old table with the
appropriate changes, use insert-from-select syntax to move the data to
the new table, delete the old table, rename the new table to the old
name, and commit the transaction.  This might not be much fun if your
database is very very large, though.


Hmmm.. That's not a bad idea. I could do that all in-code. I'm using
the ODBC driver to access the SQLite database but I guess that's no
big deal. I'd say the biggest database will be in the 30-50 meg range.
They're not huge (unless 30 meg is considered huge.. eek..)

Thanks!!

--
- Mitchell Vincent
- K Software - Innovative Software Solutions
- Visit our website and check out our great software!
- http://www.ksoftware.net

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Mitchell Vincent]

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.), you'll have to be a bit more creative.  "awk" may be your
friend.

Derrell


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


--
- Mitchell Vincent
- K Software - Innovative Software Solutions
- Visit our website and check out our great software!
- http://www.ksoftware.net

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Scott Hess]

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 could also write something to spelunk through the metadata and
alter things to fit.  Use 'pragma table_info(table)' to get info about
the table, then for each table you want to change, within a
transaction create a new table just like the old table with the
appropriate changes, use insert-from-select syntax to move the data to
the new table, delete the old table, rename the new table to the old
name, and commit the transaction.  This might not be much fun if your
database is very very large, though.

-scott

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Derrell . Lipman]

"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 SQLite works great - no problem at all. Until
> I tried to use it with ODBC. The SQLite ODBC driver works fine but
> assumes a 255 character limit. As soon as it returns a result longer
> than 255 it blows an error.
>
> I see in the SQLite ODBC driver's documentation that it does support >
> 255 varchar fields but I _assume_ have to specify that it's > 255 in
> the schema.
>
> 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 just "varchar" (or just use an SQLite
> 'type' of "text") ?

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.), you'll have to be a bit more creative.  "awk" may be your
friend.

Derrell

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Mitchell Vincent]

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 specifier.
>
> Specifying "varchar" in SQLite works great - no problem at all. Until
> I tried to use it with ODBC. The SQLite ODBC driver works fine but
> assumes a 255 character limit. As soon as it returns a result longer
> than 255 it blows an error.
>
> I see in the SQLite ODBC driver's documentation that it does support >
> 255 varchar fields but I _assume_ have to specify that it's > 255 in
> the schema.
>
> 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 just "varchar" (or just use an SQLite
> 'type' of "text") ?

Mitchell,

the artificial limitation of VARCHAR columns to 255 chars in the SQLite
ODBC drivers is yet another tribute to M$ACCE$$.
If you want a proper untruncated mapping to larger VARCHAR columns use
"text" or "memo" in your CREATE TABLE statement. These will be mapped
to SQL_LONGVARCHAR by the drivers.

Sorry for that inconvenience, but blame billg, not me ;-)

Regards,
Christian


Thanks Christian!

I never meant to blame you at all - I figured the assumed 255 char
limit was there for good reason! I should have created better schema
anyway.

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!

--
- Mitchell Vincent
- K Software - Innovative Software Solutions
- Visit our website and check out our great software!
- http://www.ksoftware.net

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Christian Werner]

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 - no problem at all. Until
> I tried to use it with ODBC. The SQLite ODBC driver works fine but
> assumes a 255 character limit. As soon as it returns a result longer
> than 255 it blows an error.
> 
> I see in the SQLite ODBC driver's documentation that it does support >
> 255 varchar fields but I _assume_ have to specify that it's > 255 in
> the schema.
> 
> 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 just "varchar" (or just use an SQLite
> 'type' of "text") ?

Mitchell,

the artificial limitation of VARCHAR columns to 255 chars in the SQLite
ODBC drivers is yet another tribute to M$ACCE$$.
If you want a proper untruncated mapping to larger VARCHAR columns use
"text" or "memo" in your CREATE TABLE statement. These will be mapped
to SQL_LONGVARCHAR by the drivers.

Sorry for that inconvenience, but blame billg, not me ;-)

Regards,
Christian

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] sin and similar functions

[Jakub Ladman]

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 radius.
Unfortunately at small time intervals and on a slow machine.

Thanks

Jakub

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Script Language

[Eugene Wee]

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

My $0.02.

Sam

 
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, March 
09, 2007 12:13 PM

To: sqlite-users@sqlite.org
Subject: 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 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 why you're not using one of these ?
Looks to me you're reinventing the wheel,
while with a lot less effort you could give a better wheel a nice color


;-)


cheers,
Stef



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[drh]

"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 just "varchar" (or just use an SQLite
> 'type' of "text") ?
> 

Do "sqlite OLD.DB .dump >temp.sql"  Bring up temp.sql in a
text editor.  Find the CREATE TABLE statements.  Modify the
column types to be whatever you want.  Save the file.  Then
do "sqlite3 NEW.DB 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Dave Dyer]

>
>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 
statitistically good way to paper over the problem.


>Is there something that the SQLite core can do better?

I'm not enough of a windows guru to know if there is a better
way to make sure the journal file behaves as a private resource
for sqlite.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Script Language

[John Stanton]

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

My $0.02.

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]
 
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 09, 2007 12:13 PM

To: sqlite-users@sqlite.org
Subject: 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 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 why you're not using one of these ?
Looks to me you're reinventing the wheel,
while with a lot less effort you could give a better wheel a nice color


;-)


cheers,
Stef




-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] SQLite 2 to SQLite 3 - Varchar sizes

[Mitchell Vincent]

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 use it with ODBC. The SQLite ODBC driver works fine but
assumes a 255 character limit. As soon as it returns a result longer
than 255 it blows an error.

I see in the SQLite ODBC driver's documentation that it does support >
255 varchar fields but I _assume_ have to specify that it's > 255 in
the schema.

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 just "varchar" (or just use an SQLite
'type' of "text") ?

--
- Mitchell Vincent
- K Software - Innovative Software Solutions
- Visit our website and check out our great software!
- http://www.ksoftware.net

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[drh]

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 solution, I've hacked my copy to retry failed file
> open/close/delete operations after a short delay.
> 

How does your hack improve upon [3200]?

   http://www.sqlite.org/cvstrac/chngview?cn=3200

Is there something that the SQLite core can do better?

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Anderson, James H \(IT\)]

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@sqlite.org
Subject: 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.

 -Clark

- Original Message 
From: "Anderson, James H (IT)" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, March 9, 2007 9:04:29 AM
Subject: [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





-
To unsubscribe, send email to [EMAIL PROTECTED]

-


NOTICE: If received in error, please destroy and notify sender. Sender does not 
intend to waive confidentiality or privilege. Use of this email is prohibited 
when received in error.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[A.J.Millan]

>.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, the
>inclusion of this material was and has been considered useful by
>everyone who reviewed the book, as it serves as an authoritative and
>succinct reference. Many technical books include a reference similar
>to this as a convenience to the reader.

>I devoted 100 pages on the subject of SQL. I tried to systematically
>and progressively describe SQL so that someone completely unfamiliar
>could read the chapter in order, and by the end of the chapter
>understand topics such as 3NF, left outer joins, and the intricacies
>of NULL.

>For an average programmer who needs to use SQLite, I hope this book
>can save a lot of time whether you are a unfamiliar to or experienced
>with SQL or the SQLite API. I wrote this book purely because I like
>SQLite, wanted to help get the word out, and someone presented me with
>the opportunity to write a book. Once I decided to write it, I went to
>great lengths to write a book that would be genuinely useful. Apress
>has put a lot of time and effort into making this a useful book as
>well.

>As I said in the book, and I think on this list, I am always open to
>suggestions and feedback. If you really feel the book has failed you
>in some way, or missed an important topic, I would like to know about
>it so I can try to make it better should it ever make it to a second
>edition. While I have many other things going on in life just like
>everybody else, it is important to me that the book serves its
>purpose, and I am more than happy to take whatever efforts required to
>do so.

>-- Mike

I wish remark that my message should be interpreted in its context; it is
and advise to somebody for what the acquisition of the book can suppose a
great economic effort.

In other circumstances the advice can be different.  Go ahead that, in my
case, I have never acquired a book  the one that cannot say that I have
learned something, or that it didn't contain something valuable that had not
found in any other one.

I also want to pick up your's offer to add some personal suggestion in this
respect (IMHO):

*  Eliminate the part devoted to the SQL generalities.  In my opinion, the
buyer of a book whose title is "The Definitive Guide to SQLite", doesn't
want an introduction to the SQL; for that there already exist good manuals,
even in the Web.  In the best case, a chapter dedicated the SQL
"peculiarities" of SQLite.

*  I'm not against cut and paste the SQL reference or the C-API from the
on-line manual  (it is really a convenience for the reader), but include an
example, that can be synthetic and not commented, in each epigraph. This
gives true utility.

*  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 :-))

*  More and more and more... code examples

Finally, if you wants a gift for the hearing, I will tell You that indeed, I
find some parts stupendous.  For example, the epigraph "The thing called
NULL", or the explanation of the supported data types (Storage Classes;
Manifest Typing, and Type Affinity).  All the chapter 5 "Design and
concepts"; chapter 6, "The Core C API"; chapter 7, "Extension C API", and,
of course, the chapter 9 "SQLite internals".  These last chapters should be
more cared and enlarged, because it is the core of the book.

Greetings.

A.J.Millán
ZATOR Systems.

P.D: excuse my English.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[RohitPatel9999]

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 file which is already attached with same unique
database-name will give that error.

Just my 2 cents.
Rohit


-- 
View this message in context: 
http://www.nabble.com/How-do-I-know-what-DBs-I-have-attached--tf3376318.html#a9399633
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Scott Hess]

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.

-scott


On 3/9/07, Scott Hess <[EMAIL PROTECTED]> wrote:

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

So, that's the third suggestion of .dump.  To recreate the database
from .dump, you simply execute the sql commands within - which is not
what .import does at all!

The inverse of .import would be select!  By this I mean that if you
have a table, you do something like:

   echo "SELECT * FROM TABLE;" | sqlite3 my.db > export.file

to later import that data, at the sqlite3 command-line you'll do
".import export.file TABLE"

-scott



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Scott Hess]

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


So, that's the third suggestion of .dump.  To recreate the database
from .dump, you simply execute the sql commands within - which is not
what .import does at all!

The inverse of .import would be select!  By this I mean that if you
have a table, you do something like:

  echo "SELECT * FROM TABLE;" | sqlite3 my.db > export.file

to later import that data, at the sqlite3 command-line you'll do
".import export.file TABLE"

-scott

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Anderson, James H \(IT\)]

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] 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. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


NOTICE: If received in error, please destroy and notify sender. Sender does not 
intend to waive confidentiality or privilege. Use of this email is prohibited 
when received in error.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Script Language

[Samuel R. Neff]

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.

My $0.02.

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]
 
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 09, 2007 12:13 PM
To: sqlite-users@sqlite.org
Subject: 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 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 why you're not using one of these ?
> Looks to me you're reinventing the wheel,
> while with a lot less effort you could give a better wheel a nice color
;-)
> 
> cheers,
> Stef


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Dave Dyer]

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
open/close/delete operations after a short delay.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[drh]

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

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Clark Christensen]

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

 -Clark

- Original Message 
From: "Anderson, James H (IT)" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, March 9, 2007 9:04:29 AM
Subject: [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




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Samuel R. Neff]

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]
 
-Original Message-
From: Tom Olson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 08, 2007 11:50 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] ISO8601 8-byte packed date type


I was pretty tires when I wrote the original post and realize that I should
have been more specific.  So here goes!

I have created an 8-byte packed data type that stores date, time and
timezone information.  It has an effective date range of:

-142399-01-01 00:00:00.000 (BCE) through +143027-10-14 08:59:00.991 (CE)

All dates in this range are accurate to 1/1000 of a second

I have helper routines for date arithmetic and converting to/from Julian
dates, UNIX dates and Delphi TDateTime.  There is also a parser for ISO8601
formatted strings for the following formats:

General dates - 2007-03-05 12:34:56.789
Day of Year dates - 2007-365
Week dates - 2007-W51-7

If anyone would find this useful/helpful please let me know.

Tom
tolson at whamware.com



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[RB Smissaert]

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



> -Original Message-
> From: RB Smissaert [mailto:[EMAIL PROTECTED]
> Sent: 09 March 2007 16:40
> To: sqlite-users@sqlite.org
> Subject: 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
> Subject: [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.
> Investigating this it appeared the reason this was happening 
> was that the
> journal file is open by another process and cannot be 
> deleted. SQLite cannot
> delete it and neither can I manually via explorer. After much 
> investiagtion
> with out IT department it looks like the reason this was open is that
> Microsoft Windows Desktop Search (a file indexer program) has 
> opened it. I
> am still unsure why it keeps it open and does not allow for 
> anyone other
> than an admin to delete it. A file may stay in this state for 
> hours before
> mysteriously disappearing of its own accord. If we configure 
> Windows Desktop
> Search to ignore the folder, we do not get (or at least we 
> have not yet got)
> this problem. 
> 
> Basically I would like to:-
> 1) Make this problem known to the community.
> 2) Ask if anyone has experienced anything like this?
> 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 has gone. Which is quite a severe problem...
> 
> Thanks
> 
> Mark
> 
> 
> DISCLAIMER:
> This information and any attachments contained in this email 
> message is
> intended only for the use of the individual or entity to which it is
> addressed and may contain information that is privileged, 
> confidential, and
> exempt from disclosure under applicable law.  If the reader 
> of this message
> is not the intended recipient, or the employee or agent 
> responsible for
> delivering the message to the intended recipient, you are 
> hereby notified
> that any dissemination, distribution, forwarding, or copying of this
> communication is strictly prohibited.  If you have received this
> communication in error, please notify the sender immediately by return
> email, and delete the original message immediately.
> 
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 
> 


DISCLAIMER:
This information and any attachments contained in this email message is
intended only for the use of the individual or entity to which it is
addressed and may contain information that is privileged, confidential, and
exempt from disclosure under applicable law.  If the reader of this message
is not the intended recipient, or the employee or agent responsible for
delivering the message to the intended recipient, you are hereby notified
that any dissemination, distribution, forwarding, or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify the sender immediately by return
email, and delete the original message immediately.


-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Leonardo Mateo]

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
then dump that table using .dump command.

Hope it helps.

Cheers.

--
Leonardo Mateo.
There's no place like ~

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Samuel R. Neff]

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 extensions affect
performance related to System Restore.  

http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows

HTH,

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]
 
-Original Message-
From: Allan, Mark [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 09, 2007 11:52 AM
To: sqlite-users@sqlite.org
Subject: 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 you.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Gunnar Roth]

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


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Igor Tandetnik]

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

[John Stanton]

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 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 why you're not using one of these ?
Looks to me you're reinventing the wheel,
while with a lot less effort you could give a better wheel a nice color ;-)

cheers,
Stef


KvK: 41055629



- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[drh]

"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 create another one to find out exactly that information for =
> you.
> 

Thanks.  Here's how you might go about creating a hot journal:

   *  Open the database file.
   *  Run the BEGIN command.
   *  Make some change to the database but do not COMMIT.
   *  call assert(0) or do something else to make your
  program crash without shutting down or closing the
  database connection.

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[P Kishor]

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. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Samuel R. Neff]

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 reissue the attach command each time I reuse an existing connection
instead of having to keep track.

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]
 
-Original Message-
From: jose isaias cabrera [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 09, 2007 10:28 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] How do I know what DBs I have attached?


Greetings!

... how do I know if I have a db attached already? ...

josé 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[John Stanton]

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 didnt work out (it said it couldn't open the makefile...) so I tried the config but I dont know which tool handles this, so I was back to square one...


So I began questioning myself... 
Would it even be possible to compile this package under windows with LCC?


I want to perform a static compilation, so I can statically link the library on 
my application. However I'd still be happy if I could compile as a dynamic lib.

Now that I'm at it, I would like to suggest for the windows build, that the 
required .exp or .lib be added on the package as well, since this allows for 
easier linking on applications - at least under my environment (I'm sure others 
would like this as well - However, being able to compile the source by myself 
would take care of this issue).

Thanks.

A simple way is to compile it under gcc then use LCC.

After you have compiled with gcc you may discover that to use LCC does 
not make a lot of sense since my experience with both compilers is that 
lcc is very well implemented but lacks the level of optimization 
available with gcc.  A static library created with gcc will work with 
your lcc programs if you are using lcc for your applications to take 
advantage of some of its clever extensions to regular C.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Gunnar Roth]

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 database, especially the 
/extension/


For example, if you give all your databases the extension .sdb (SQLite 
Database, nice name hey? I thought so when I choose it anyway...) you 
discover that the SDB extension is already associated with APPFIX PACKAGES.


Now, here is the cute part, APPFIX is an executable/package that Windows 
XP recognizes, and it will, (emphasis mine) *ADD THE DATABASE TO THE 
SYSTEM RESTORE FUNCTIONALITY*


This means, stay with me here, every time you write ANYTHING to the 
database, the Windows XP system thinks a bloody executable has changed 
and copies your ENTIRE 800 meg database to the system restore directory


I recommend something like DB or DAT.

The entire list of system restore-monitored filename extensions can be 
found at: 
¤http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sr/sr/monitored_file_extensions.asp; 





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.

Regards,
Gunnar



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Is there an inverse for .import?

[Anderson, James H \(IT\)]

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?

[Samuel R. Neff]

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
SQLite and figured even the 20 pages the TOC says are devoted to SQLite
internals are helpful it'd be worthwhile.

We've been pleasantly surprised and everything I've read so far has been
very helpful.  The entire book does focus on SQLite and talks consistently
about internals and how things work and optimization specific to SQLite.
Even the database section which talks about SQL was helpful as was the C API
reference even though we're not using the C API.

I do have to agree about the index though--the three times I tried to look
something up in the index I couldn't find what I was looking for.  I
wouldn't base a buying decision on the index though.

Best regards,

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]
 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Allan, Mark]

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



> -Original Message-
> From: RB Smissaert [mailto:[EMAIL PROTECTED]
> Sent: 09 March 2007 16:40
> To: sqlite-users@sqlite.org
> Subject: 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
> Subject: [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.
> Investigating this it appeared the reason this was happening 
> was that the
> journal file is open by another process and cannot be 
> deleted. SQLite cannot
> delete it and neither can I manually via explorer. After much 
> investiagtion
> with out IT department it looks like the reason this was open is that
> Microsoft Windows Desktop Search (a file indexer program) has 
> opened it. I
> am still unsure why it keeps it open and does not allow for 
> anyone other
> than an admin to delete it. A file may stay in this state for 
> hours before
> mysteriously disappearing of its own accord. If we configure 
> Windows Desktop
> Search to ignore the folder, we do not get (or at least we 
> have not yet got)
> this problem. 
> 
> Basically I would like to:-
> 1) Make this problem known to the community.
> 2) Ask if anyone has experienced anything like this?
> 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 has gone. Which is quite a severe problem...
> 
> Thanks
> 
> Mark
> 
> 
> DISCLAIMER:
> This information and any attachments contained in this email 
> message is
> intended only for the use of the individual or entity to which it is
> addressed and may contain information that is privileged, 
> confidential, and
> exempt from disclosure under applicable law.  If the reader 
> of this message
> is not the intended recipient, or the employee or agent 
> responsible for
> delivering the message to the intended recipient, you are 
> hereby notified
> that any dissemination, distribution, forwarding, or copying of this
> communication is strictly prohibited.  If you have received this
> communication in error, please notify the sender immediately by return
> email, and delete the original message immediately.
> 
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 
> 


DISCLAIMER:
This information and any attachments contained in this email message is 
intended only for the use of the individual or entity to which it is addressed 
and may contain information that is privileged, confidential, and exempt from 
disclosure under applicable law.  If the reader of this message is not the 
intended recipient, or the employee or agent responsible for delivering the 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution, forwarding, or copying of this communication is 
strictly prohibited.  If you have received this communication in error, please 
notify the sender immediately by return email, and delete the original message 
immediately.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Emerson Clarke]

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 to worry about how to download something from a
web server, write to a file, compress a log file, tell the time,
process xml, create threads, access a database, sort something in a
collection etc...

Reason is a one stop C++ software development library. I like to think
of it as what the C++ language has been missing all these years.

Emerson

On 3/9/07, Linker M Lin <[EMAIL PROTECTED]> wrote:

It's something like ACE Framework？

--
Linker M Lin
[EMAIL PROTECTED]



-
To unsubscribe, send email to [EMAIL PROTECTED]
-












___
Mp3疯狂搜-新歌热歌高速下
http://music.yahoo.com.cn/?source=mail_mailbox_footer

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

[RB Smissaert]

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
Subject: [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.
Investigating this it appeared the reason this was happening was that the
journal file is open by another process and cannot be deleted. SQLite cannot
delete it and neither can I manually via explorer. After much investiagtion
with out IT department it looks like the reason this was open is that
Microsoft Windows Desktop Search (a file indexer program) has opened it. I
am still unsure why it keeps it open and does not allow for anyone other
than an admin to delete it. A file may stay in this state for hours before
mysteriously disappearing of its own accord. If we configure Windows Desktop
Search to ignore the folder, we do not get (or at least we have not yet got)
this problem. 

Basically I would like to:-
1) Make this problem known to the community.
2) Ask if anyone has experienced anything like this?
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 has gone. Which is quite a severe problem...

Thanks

Mark


DISCLAIMER:
This information and any attachments contained in this email message is
intended only for the use of the individual or entity to which it is
addressed and may contain information that is privileged, confidential, and
exempt from disclosure under applicable law.  If the reader of this message
is not the intended recipient, or the employee or agent responsible for
delivering the message to the intended recipient, you are hereby notified
that any dissemination, distribution, forwarding, or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify the sender immediately by return
email, and delete the original message immediately.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[drh]

"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 has 
> gone. Which is quite a severe problem...
> 

While Windows Desktop Search has the journal file open, is the
journal file read only?  Is it possible to change the content
of the file or even truncate the file to zero length as long as
the file is not deleted?

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Gussimulator]

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\output.obj" "path-to\main.c"
   It produces 0 errors and 27 warnings.. I believe I can move on from 
here, despite warnings.


2) In LCCLNK I'm using the following:

   /dll "path-to\output.obj" "path-to\sqlite3.def"
   I'm getting a ton of "Specified export XX is not defined"
   ...And later on a "Missing exports. Aborting" message.


Why is this happening?, did I compiled it wrong or the exports file I've got 
is not the correct one? (from dll package - sqlite3 website).


Perhaps compiling just main.c is not how it should be done? if so, what 
should I do in order to properly compile all the sources? - This time I'm 
using the "pre-processed" version of the sources for windows, since I gave 
up on the other package...



Thanks again.




- Original Message - 
From: "Gussimulator" <[EMAIL PROTECTED]>

To: 
Sent: Friday, March 09, 2007 12:59 PM
Subject: [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 it couldn't open the makefile...) so I tried 
the config but I dont know which tool handles this, so I was back to square 
one...


So I began questioning myself...
Would it even be possible to compile this package under windows with LCC?

I want to perform a static compilation, so I can statically link the library 
on my application. However I'd still be happy if I could compile as a 
dynamic lib.


Now that I'm at it, I would like to suggest for the windows build, that the 
required .exp or .lib be added on the package as well, since this allows for 
easier linking on applications - at least under my environment (I'm sure 
others would like this as well - However, being able to compile the source 
by myself would take care of this issue).


Thanks. 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Allan, Mark]

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. Investigating 
this it appeared the reason this was happening was that the journal file is 
open by another process and cannot be deleted. SQLite cannot delete it and 
neither can I manually via explorer. After much investiagtion with out IT 
department it looks like the reason this was open is that Microsoft Windows 
Desktop Search (a file indexer program) has opened it. I am still unsure why it 
keeps it open and does not allow for anyone other than an admin to delete it. A 
file may stay in this state for hours before mysteriously disappearing of its 
own accord. If we configure Windows Desktop Search to ignore the folder, we do 
not get (or at least we have not yet got) this problem. 

Basically I would like to:-
1) Make this problem known to the community.
2) Ask if anyone has experienced anything like this?
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 has gone. Which is quite a severe problem...

Thanks

Mark


DISCLAIMER:
This information and any attachments contained in this email message is 
intended only for the use of the individual or entity to which it is addressed 
and may contain information that is privileged, confidential, and exempt from 
disclosure under applicable law.  If the reader of this message is not the 
intended recipient, or the employee or agent responsible for delivering the 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution, forwarding, or copying of this communication is 
strictly prohibited.  If you have received this communication in error, please 
notify the sender immediately by return email, and delete the original message 
immediately.

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

[Jakub Ladman]

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
> broken, but few reports of it actually happening. Could you post a few
> details about the OS versions and file systems in your environment for
> future reference?
>
> > I will try to togle some nfs parameters as sync/async and so...
>
> Judging by earlier threads this may not help. :( The basic problem is
> that some NFS implementations have faulty locking, so tweaking might
> just mask the problem until later.
>
> Martin

Problem is, that this is pretty obscure system.
Renesas SuperH SH4 CPU
Heavily patched 2.4.18 kernel. (patches will be presented on internet, but not 
at this time)
Gentoo-embedded linux, based on uclibc 0.9.28 and busybox .
Main storage is SD flash card.

I must confess, that i do not know, how to check the nfs version. (it is 
binary distributed kernel and i have not the actual .config of it)
Dmesg shows it not.

Jakub Ladman

>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Igor Tandetnik]

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 that when two processes open the same DB 
file, and one process attaches another DB file, the other process can 
somehow query SQLite and find out that this happened. This is not the 
case.


So, if you want to know if _you_ have attached a DB, just keep track of 
ATTACH DATABASE commands you have issued on your connection. If you want 
to know if someone else attached a DB to one you also happen to have 
open, SQLite can't help you there.



Also, can different clients ATTACH to the same DB and REPLACE unique
RECORDS without any problem?


Well, only one connection can modify a particular database file at the 
same time. It doesn't matter if you open the file directly, or attach it 
to an existing connection. If two processes attempt the modifying 
operation at the same time, one of them will proceed and the other will 
be locked out.


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Script Language

[Stef Mientki]

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 why you're not using one of these ?
Looks to me you're reinventing the wheel,
while with a lot less effort you could give a better wheel a nice color ;-)

cheers,
Stef


KvK: 41055629



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Anderson, James H \(IT\)]

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
Subject: Re: [sqlite] stupid man's manual to sqlite?

> More of a half is about SQL generalities, an a quarter a copy-paste of
the
> on-line manual without more comment.  At the end, the horrific index
i've
> ever seen.

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, the
inclusion of this material was and has been considered useful by
everyone who reviewed the book, as it serves as an authoritative and
succinct reference. Many technical books include a reference similar
to this as a convenience to the reader.

I devoted 100 pages on the subject of SQL. I tried to systematically
and progressively describe SQL so that someone completely unfamiliar
could read the chapter in order, and by the end of the chapter
understand topics such as 3NF, left outer joins, and the intricacies
of NULL.

For an average programmer who needs to use SQLite, I hope this book
can save a lot of time whether you are a unfamiliar to or experienced
with SQL or the SQLite API. I wrote this book purely because I like
SQLite, wanted to help get the word out, and someone presented me with
the opportunity to write a book. Once I decided to write it, I went to
great lengths to write a book that would be genuinely useful. Apress
has put a lot of time and effort into making this a useful book as
well.

As I said in the book, and I think on this list, I am always open to
suggestions and feedback. If you really feel the book has failed you
in some way, or missed an important topic, I would like to know about
it so I can try to make it better should it ever make it to a second
edition. While I have many other things going on in life just like
everybody else, it is important to me that the book serves its
purpose, and I am more than happy to take whatever efforts required to
do so.

-- Mike

On 3/8/07, A.J.Millan <[EMAIL PROTECTED]> wrote:
>
>
> > Thank you i will try my possibilities buying from amazon, while i am
based
> in
> > the Czech republic.
> > Unfortunately it is little bit expensive for me, to buy it without
looking
> > into it before.
> > Jakub
>
> I would recommend not to waste your's money in that book.
>
> More of a half is about SQL generalities, an a quarter a copy-paste of
the
> on-line manual without more comment.  At the end, the horrific index
i've
> ever seen.
>
> A.J.Millan
> ZATOR Systems.
>
>
>
>

-
> To unsubscribe, send email to [EMAIL PROTECTED]
>

-
>
>


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


NOTICE: If received in error, please destroy and notify sender. Sender does not 
intend to waive confidentiality or privilege. Use of this email is prohibited 
when received in error.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Nuno Lucas]

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 transaction that failed because of a power failure or similar? Do
you have a journal file lying around?

Maybe try to run the sqlite analyser program on the database.

Without more info, I don't think anyone can help you more (like how
many tables, an average on the number of rows, etc).


Regards,
~Nuno Lucas

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Gussimulator]

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 it couldn't open the makefile...) so I tried the config 
but I dont know which tool handles this, so I was back to square one...

So I began questioning myself... 
Would it even be possible to compile this package under windows with LCC?

I want to perform a static compilation, so I can statically link the library on 
my application. However I'd still be happy if I could compile as a dynamic lib.

Now that I'm at it, I would like to suggest for the windows build, that the 
required .exp or .lib be added on the package as well, since this allows for 
easier linking on applications - at least under my environment (I'm sure others 
would like this as well - However, being able to compile the source by myself 
would take care of this issue).

Thanks.

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

[jose isaias cabrera]

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, since I have 6 
clients, more soon, I want to make sure that I plan this right.  What I 
would like to know is, how do I know if I have a db attached already?


I know how to attach it with an uniqueDBID and since each client will update 
their own unique ID, I know there won't be any collision for them.  I am 
also reading about UNLOCKED, SHARED, RESERVED, PENDING and EXCLUSIVE.  Which 
I know I will have to start playing with, because while a write is being 
handle, someone may ask to read that RECORD that is being written and I want 
to make sure that it is read after the write has completed.


Also, can different clients ATTACH to the same DB and REPLACE unique RECORDS 
without any problem?


Any ideas?

thanks,

josé 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Script Language

[Cesar Rodas]

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 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote:


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 my University (National University of Asuncion -
>> Paraguay).
>> >
>> > The language have syntax as PHP and Python
>> >
>> > I am planning to create a SQLite support in the core, for teach SQL
>> too.
>> >
>> > Is any one instresting to help in this project?
>> >
>> > Thanks to all.
>> >
>> > PD: The language doesn't have a name jet, and will be Public Domain.
>> >
>> >
>>

>> >
>> > No virus found in this incoming message.
>> > Checked by AVG Free Edition.
>> > Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date:
>> 8/03/2007 10:58
>> >
>> Hello Cesar,
>>
>> I am interested in the inner working of LEMON, so I am ready to help (I
>> know tcl and Lua, but I never have devlopped an interpretor).
>>
>> Best regards
>>
>> --
>> Noël Frankinet
>> Gistek Software SA
>> http://www.gistek.net
>>
>>
>>
>>
-
>>
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>
>>
-
>>
>>
>>
>
>
> 
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date:
8/03/2007 10:58
>
Just tell me what you expect from me.
Do you have a description of the language ( a grammar ?), is it object
based, object orientated or just procedural.
Do you want to implement it in pure C or a mixture of C and C++. Is SQL
a part of the language ?

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net



-
To unsubscribe, send email to [EMAIL PROTECTED]

-





--
Cesar Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]

Re: [sqlite] Script Language

[Noel Frankinet]

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 my University (National University of Asuncion - 
Paraguay).

>
> The language have syntax as PHP and Python
>
> I am planning to create a SQLite support in the core, for teach SQL 
too.

>
> Is any one instresting to help in this project?
>
> Thanks to all.
>
> PD: The language doesn't have a name jet, and will be Public Domain.
>
> 


>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date:
8/03/2007 10:58
>
Hello Cesar,

I am interested in the inner working of LEMON, so I am ready to help (I
know tcl and Lua, but I never have devlopped an interpretor).

Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net



- 


To unsubscribe, send email to [EMAIL PROTECTED]

- 









No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58
  

Just tell me what you expect from me.
Do you have a description of the language ( a grammar ?), is it object 
based, object orientated or just procedural.
Do you want to implement it in pure C or a mixture of C and C++. Is SQL 
a part of the language ?


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Script Language

[Cesar Rodas]

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 University of Asuncion - Paraguay).
>
> The language have syntax as PHP and Python
>
> I am planning to create a SQLite support in the core, for teach SQL too.
>
> Is any one instresting to help in this project?
>
> Thanks to all.
>
> PD: The language doesn't have a name jet, and will be Public Domain.
>
> 
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date:
8/03/2007 10:58
>
Hello Cesar,

I am interested in the inner working of LEMON, so I am ready to help (I
know tcl and Lua, but I never have devlopped an interpretor).

Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net



-
To unsubscribe, send email to [EMAIL PROTECTED]

-





--
Cesar Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]

Re: [sqlite] Script Language

[Noel Frankinet]

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 planning to create a SQLite support in the core, for teach SQL too.

Is any one instresting to help in this project?

Thanks to all.

PD: The language doesn't have a name jet, and will be Public Domain.



No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58
  

Hello Cesar,

I am interested in the inner working of LEMON, so I am ready to help (I 
know tcl and Lua, but I never have devlopped an interpretor).


Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Script Language

[Cesar Rodas]

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 support in the core, for teach SQL too.

Is any one instresting to help in this project?

Thanks to all.

PD: The language doesn't have a name jet, and will be Public Domain.

--
Cesar Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]

[sqlite] Sqlite3_open() Hangs...

[ravi.karatagi]

 

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 are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email.
 
www.wipro.com