Re: [sqlite] suggestion

2004-04-20 Thread Mateusz Łoskot
On 4/20/2004 11:49 PM, Eli Wheaton wrote:

I'm new to sqlite but as far as I can tell it does not support ALTER TABLE
command. I could find that useful in future versions.
That's right.
ALTER TABLE would be very helpful.
Are there any reasons it is not implemented yet ?
Greets

--

Mateusz Łoskot
mateusz at loskot dot net
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


[sqlite] suggestion

2004-04-20 Thread Eli Wheaton
I'm new to sqlite but as far as I can tell it does not support ALTER TABLE
command. I could find that useful in future versions.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [sqlite] PySqlite 0.5 on Windows 2000 SP4

2004-04-20 Thread Michal Pasternak
[ andr3a ] [Tue, Apr 20, 2004 at 07:51:54PM +0200]:
> SQLite create file and remember all operations during a single session , if
> I try to reopen file or reconnect to db used, it 'll be empty.
> Does anyone know why ? Version is 0.5.0 of PySqlite and the test is this:

... ah, and by the way, PySQLite has it's own discussion list, don't forget
it!

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [sqlite] PySqlite 0.5 on Windows 2000 SP4

2004-04-20 Thread Michal Pasternak
[ andr3a ] [Tue, Apr 20, 2004 at 07:51:54PM +0200]:
> SQLite create file and remember all operations during a single session , if
> I try to reopen file or reconnect to db used, it 'll be empty.
> Does anyone know why ? Version is 0.5.0 of PySqlite and the test is this:

This is normal Python DB API functionality, which involves transactions.

Either open the database in autocommit mode (and then you can use
begin/commit on your own), or do a better thing - execute cx.commit() when
you want to close the transaction (thus save the data).

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sqlite] Will Version 3 allow new index features?

2004-04-20 Thread Derrell . Lipman
For future planning, might any of the new features in the upcoming Version 3
allow indexes to be used to speed up a query which uses "LIKE"?

Thanks,

Derrell

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sqlite] [Annoucement] SQLite.NET

2004-04-20 Thread Richard Heyes
Version 2.0 of (my) SQLite.NET wrapper for .NET (surprisingly) is available.
This time it's 100% C# along with full source code and VS2003 solution (with
mini test app). Comes with a script attached to the post build event to
handle the MSIL hacking necessary for the sqlite_exec callback method to be
correctly called using Cdecl convention. Also, it's now licensed under GPL.

Cheers.
-- 
Richard Heyes
http://www.phpguru.org/static/SQLite.NET.html


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sqlite] Backing up data by date

2004-04-20 Thread Lloyd thomas
Which is the best way to backup rows which meet a certain date criteria? 
ie WHERE data is <= '2003-11-20'. 
Would I need to select and save the data to a temporary table and then DUMP the temp 
table.


[sqlite] PySqlite 0.5 on Windows 2000 SP4

2004-04-20 Thread [ andr3a ]
SQLite create file and remember all operations during a single session , if
I try to reopen file or reconnect to db used, it 'll be empty.
Does anyone know why ? Version is 0.5.0 of PySqlite and the test is this:

import sqlite
cx = sqlite.connect("myDb")
cu = cx.cursor()
cu.execute( "create table myTry( id INTEGER, myText VARCHAR(255) )" )
cu.execute( "insert into myTry values( 1, 'try 1' )" )
cu.execute( "insert into myTry values( 2, 'try 2' )" )

cu.execute( "SELECT sql FROM sqlite_master WHERE type='table'" )
print cu.fetchone()
# ('create table myTry( id INTEGER, myText VARCHAR(255) )',)

cu.execute( "SELECT * from myTry" )
print cu.fetchone()
# (1, 'try 1')
print cu.fetchone()
# (2, 'try 2')



... then I try to reconnect ... with another file to the same database file
...

import sqlite
cx = sqlite.connect("myDb")
cu = cx.cursor()
cu.execute( "SELECT sql FROM sqlite_master WHERE type='table'" )
print cu.fetchone()
# None


The strange thing is tht it seems works fine before I used cx.close() for
another test ...



[sqlite] Timeframe for 3.0 ?

2004-04-20 Thread VTenneti




Hi,

We're considering the use of SQLite in the next version of our Doc1
product. SQLite does seem the ideal embedded database for us to use.
However, there seem to a couple of thorny issues, and can someone please
throw some light on they could possibly be resolved:

1. Our product is Unicode (in fact we recently ported the code over from
DBCS). I see from the ongoing discussions that supporting Unicode is
something that is planned for SQLite 3.0. So what is the timeframe for 3.0
? How easy / difficult may it turn out to be to change the code ourselves ?
We may need to start the work very soon.

2. Our product allows users to write logic by dragging and dropping visual
elements on the front end - and as part of that, we have our own datatypes
(for example Integer, Fixed Point Number (proprietary format), String,
Date, Time). So the fact that SQLite is typeless may turn out to be an
advatage - but we would need to 'override', for example, arithmetic and
comparison functions to use our own code. How easy or difficult may that
turn out to be ?

I probably should mention that our runtime engine (virtual machine) runs on
a multitude of platforms from  Windows to several flavours of Unix to MVS.

Thanks a lot,

Vijay


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]