Hi!
>SQLite is very storage efficient in the common case. In a typical table,
SQLite will use
>about 4 or 5 bytes of disk space for every 3 bytes of actual data stored.
Put another
>way, about 60% to 75% of an SQLite database file is the actual data being
stored
>and the other 40% to 25% is overh
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
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
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.
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
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-
[ 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 AP
[ 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, PyS
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]
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
m
Mateusz Łoskot wrote:
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 ?
Gr
Hi, I am porting sqlite to vxworks. I use the shell to issue some
simple SQL commands. I can create a table and then I can issue insert
SQL statements, but when I try to display the data I inserted (by using
select) I always get the first record and only the first record I
inserted. I can creat
12 matches
Mail list logo