[sqlite] MSDOS

2004-02-06 Thread Chang Yong Ngan
can sqlite be used under MSDOS? thanks __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For ad

[sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread D. Richard Hipp
If you use a modern version of SQLite (version 2.6.0 through 2.8.11) to open an older database file (version 2.1.0 through 2.5.6) the library will automatically rebuild all the indices in the database in order to correct a design flaw in the older database files. I am proposing to drop support for

[sqlite] Re: OK to drop support for legacy file formats?

2004-02-06 Thread D. Richard Hipp
D. Richard Hipp wrote: I am proposing to drop support for this auto-update feature. Beginning with 2.8.12, if you attempt to open a database file built using version 2.5.6 or earlier, the open attempt will fail (with an appropriate error message). You will have to update the database file manually

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Cesare D'Amico
Alle 15:05, venerdì 6 febbraio 2004, D. Richard Hipp ha scritto: > I am proposing to drop support for this auto-update feature. What about dropping this feature as part of sqlite and make it available as an external utility? (if one doesn't exist yet...) (I'm not using any old-style db, though,

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread eno
> Would this proposed change cause anyone unreasonable hardship? I think it is a dangerous feature anyway, cause it can break older versions of some app if someone is using a newer version against an old database, resulting in a DB which can be opened any longer by the old app. Therefore, I wont m

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread chips42
Hi, I have not been an active contributer and I am only using it in an embedded project - not all that serious about time lines, however I have been bumping into conflicts about formats. I would definitely not miss it. It may add stability to the remainder and allow some additional growth. R

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Brass Tilde
> If you use a modern version of SQLite (version 2.6.0 through 2.8.11) > > I am proposing to drop support for this auto-update feature. > Beginning with 2.8.12, if you attempt to open a database file If the opinion of someone who's just started using the product, and has no intention of using the

[sqlite] Temporary indexes

2004-02-06 Thread Bertrand Mansion
Hi, Could someone please explain me how temporary indexes work ? I have tried the query "CREATE TEMP INDEX tmpidx ON table(field)" without success. Same thing if the table is also temporary itself. Same thing with TEMPORARY UNIQUE indexes and same thing when I use TEMP instead of TEMPORARY. The

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Yves Glodt
On Friday 06 February 2004 15:05, D. Richard Hipp wrote: > If you use a modern version of SQLite (version 2.6.0 through 2.8.11) > to open an older database file (version 2.1.0 through 2.5.6) the > library will automatically rebuild all the indices in the database > in order to correct a design flaw

RE: [sqlite] Re: OK to drop support for legacy file formats?

2004-02-06 Thread Clark, Chris
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 6:13 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] Re: OK to drop support for legacy file formats? > > > D. Richard Hipp wrote: > > > > I am proposing to drop support for this auto

Re: [sqlite] MSDOS

2004-02-06 Thread Hans-Juergen Taenzer
[EMAIL PROTECTED] (Chang Yong Ngan) wrote: > can sqlite be used under MSDOS? > thanks You can compile SQLite with DJGPP to an 32bit DOS programm. To run it, there must be support for LFN (long file names) by the OS like Win32 or OS/2. Gruss Hans-Jürgen --

Re: [sqlite] md5sum()

2004-02-06 Thread Richard Heyes
> On Feb 4, 2004, at 3:48 PM, D. Richard Hipp wrote: > > SQLite seeks to avoid unnecessary feature creep. It also seeks > > to be small and compact. Adding new built-in functions, especially > > obscure functions such as md5/md5sum, does not seem compatible with > > those goals. For SQLite users

Re: [sqlite] Re: OK to drop support for legacy file formats?

2004-02-06 Thread bnason
What if instead of refusing to open the database at all, it opened the database read-only. Would opening older databases read-only mitigate any hardships that refusing to open older databases might cause? My 2 cents, that sounds like the most user friendly approach, that way if a user has an old

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Greg Obleshchuk
Hello, Why not remove the feature but create a seperate utility project that converts any version of SQLITE DB to the latest version. In this way SQLite can be just what it is small and fast. There would be a tool from the orginal source which you would know would work and simple to use. The cur

RE: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Allan Edwards
Now there is experience talking. I agree with this view point. -Original Message- From: Greg Obleshchuk [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 4:18 PM To: D. Richard Hipp; [EMAIL PROTECTED] Subject: Re: [sqlite] OK to drop support for legacy file formats? Hello, Why

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Rene
> Why not remove the feature but create a seperate utility project that > converts any version of SQLITE DB to the latest version. i think it's better to let it in. why save a few bytes for removing such important functionality. by the way, same for md5, you should add support. imho there is no r

RE: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Ondrej Krsko
How old is 2.5.6 version? I agree with Greg. -Original Message- From: Greg Obleshchuk [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 11:18 PM To: D. Richard Hipp; [EMAIL PROTECTED] Subject: Re: [sqlite] OK to drop support for legacy file formats? Hello, Why not remove the fea

Re: [sqlite] MSDOS

2004-02-06 Thread Chang Yong Ngan
thanks, does anyone have eperience to share? /cy --- Hans-Juergen Taenzer <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Chang Yong Ngan) wrote: > > > can sqlite be used under MSDOS? > > thanks > > You can compile SQLite with DJGPP to an 32bit DOS > programm. To run it, > there must be suppo

Re: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Darren Duncan
On Fri, 6 Feb 2004, D. Richard Hipp wrote: > Would this proposed change cause anyone unreasonable hardship? Given that I don't have any investment (code or data) in older SQLite versions, it will be no problem for me at all if you remove the auto-conversion feature. Moreover, I support the imme

Re: [sqlite] VIEW produces strange result

2004-02-06 Thread JC
Chris Smith wrote: [snip] now create a view to see how many book 1 are sold: --^^^ CREATE VIEW v_sell AS SELECT book,sum(num) AS num --^^ FROM sell GROUP BY book; [snip] Possibly we said 'sum' when we really meant 'count'? R, C different. as in tab