[sqlite] FW: Help with Porting Problem

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

Re: [sqlite] suggestion

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

Re: [sqlite] suggestion

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

[sqlite] suggestion

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

[ 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

Re: [sqlite] PySqlite 0.5 on Windows 2000 SP4

[ 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

[sqlite] Will Version 3 allow new index features?

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-

[sqlite] [Annoucement] SQLite.NET

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

[sqlite] Backing up data by date

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

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

[sqlite] Timeframe for 3.0 ?

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

RE: [sqlite] A proposal for SQLite version 3.0

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