Re: [sqlite] Proposed removal of (mis-)feature

Yes, please remove #3. Now is a particularly good time for it seeing as the 3.6 line is quite new. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] about sqlite database

Thanks i will Kees Nuyt wrote: > > On Wed, 6 Aug 2008 23:57:51 -0700 (PDT), you wrote: > >> >>In sqlite whether can we rotate content in database . >>That means i want to restirct my database to some size,if it exceeds that >>size it has to replace first entry. >>Can anybody help.Thanks in

Re: [sqlite] Possible Error in 3.6.0?

Skip step 6 above. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible Error in 3.6.0?

Shane wrote: > This was previously reported, and couldn't be reproduced. > > http://www.sqlite.org/cvstrac/tktview?tn=3262 > > Any help in recreating it would be appreciated. > > -Shane I did the following: 1. Installed vanilla Ubuntu 7.10 + software development 2. Downloaded,

Re: [sqlite] Proposed removal of (mis-)feature

D. Richard Hipp wrote: > 3. Double-quoted names fall back to being string literals if > there is no matching table or column name. > > So I'm giving some thought to removing feature (3) above and > disallowing double-quoted string literals. My concern is, though, > that this might

Re: [sqlite] Proposed removal of (mis-)feature

He is my vote. I like the fact that conventions #1 and #2 make things compatible with other databases. Does #3, by chance, do the same with another database not mentioned (eg. Oracle). If it does not have any compatibility with any other database, ONLY then I say that one should drop #3 quoting

Re: [sqlite] Proposed removal of (mis-)feature

+1 for removal of quote munging. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 sqlite>select level from sqlGuruOMeter where name="Ron Wilson"; 2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Thursday,

[sqlite] Problem building on Solaris

I'm trying to build the amalgamation on Solaris, and it's failing: > make cd . && /bin/bash /home/martella/sqlite3/sqlite-amalgamation-3.6.1/missing --run aclocal-1.9 /usr/local/share/aclocal/winsz.m4:5: warning: underquoted definition of AM_HEADER_TIOCGWINSZ_NEEDS_SYS_IOCTL run info

Re: [sqlite] Proposed removal of (mis-)feature

+1 in favor of removing non-standard quoting mechanism #3. - Original Message From: D. Richard Hipp <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Thursday, August 7, 2008 10:26:07 AM Subject: [sqlite] Proposed removal of (mis-)feature

Re: [sqlite] SPAM: Proposed removal of (mis-)feature

Ditto. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Simpson Sent: Thursday, August 07, 2008 1:44 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] SPAM: Proposed removal of (mis-)feature I have never really liked #3 and agree

Re: [sqlite] Proposed removal of (mis-)feature

Henceforth and forward: Let the standards violator suffer his just rewards!" :-) Dr., your just trying to supply the worlds greatest database, not take a bunch of slovenly coders to raise... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of D. Richard Hipp

Re: [sqlite] Proposed removal of (mis-)feature

On Thu, Aug 7, 2008 at 2:13 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > > On Thu, 7 Aug 2008 13:26:07 -0400, drh wrote: > > [snip] > >>So I'm giving some thought to removing feature (3) above and >>disallowing double-quoted string literals. My concern is, though, >>that this might break many

Re: [sqlite] Proposed removal of (mis-)feature

+3 on removal of #3 Noah --- On Thu, 8/7/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote: From: D. Richard Hipp <[EMAIL PROTECTED]> Subject: [sqlite] Proposed removal of (mis-)feature To: "General Discussion of SQLite Database" Date: Thursday, August 7, 2008, 12:26 PM

Re: [sqlite] about sqlite database

My solution was as follows (this limits to specific size on disk): Every time I insert stuff I do the following: ReadSizeOfDBFile If ( size > MAXDBSIZE ){ If ( freeDBPages < 10 ){ RemoveSomeRecords } } Jardar -Original Message- From: [EMAIL

Re: [sqlite] Proposed removal of (mis-)feature

On Thu, 7 Aug 2008 13:26:07 -0400, drh wrote: [snip] >So I'm giving some thought to removing feature (3) above and >disallowing double-quoted string literals. My concern is, though, >that this might break many existing applications. > >What opinion do you, gentle users, have of this

Re: [sqlite] Proposed removal of (mis-)feature

Remove it. Better now than never. Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von D. > Richard Hipp > Gesendet: Donnerstag, 7. August 2008 19:26 > An: General Discussion of SQLite Database > Betreff: [sqlite] Proposed removal of

Re: [sqlite] Proposed removal of (mis-)feature

On Thu, Aug 07, 2008 at 01:26:07PM -0400, D. Richard Hipp wrote: > 3. Double-quoted names fall back to being string literals if > there is no matching table or column name. > [..] > So I'm giving some thought to removing feature (3) above and > disallowing double-quoted string literals.

Re: [sqlite] about sqlite database

On Wed, 6 Aug 2008 23:57:51 -0700 (PDT), you wrote: > >In sqlite whether can we rotate content in database . >That means i want to restirct my database to some size,if it exceeds that >size it has to replace first entry. >Can anybody help.Thanks in advance I had a similar requirement some time

Re: [sqlite] Proposed removal of (mis-)feature

On Thu, Aug 7, 2008 at 1:26 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > String literals in SQL are suppose to be enclosed in single-quotes - > Pascal-style. Double-quotes are used around table and/or column names > in cases where the name would otherwise be a keyword or when the name >

Re: [sqlite] Proposed removal of (mis-)feature

+2 on removal of #3. --- On Thu, 8/7/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote: From: D. Richard Hipp <[EMAIL PROTECTED]> Subject: [sqlite] Proposed removal of (mis-)feature To: "General Discussion of SQLite Database" Date: Thursday, August 7, 2008, 12:26 PM String

Re: [sqlite] Proposed removal of (mis-)feature

I'm +1 on this change. While I have not run into it as a feature or mis-feature, I would concur that it is ambiguous and problematic. A simple clear syntax benefits everyone. BTW, Thanks for all you effort to produce this wonder software. Best regards, -Steve W D. Richard Hipp wrote: >

Re: [sqlite] SPAM: Proposed removal of (mis-)feature

I have never really liked #3 and agree wholeheartedly with its demise. Removing it in a subsequent release will force all those people using them for string literals to fix their code -- which isn't a bad idea at all! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: [sqlite] Loading a existing database 100% into memory

What I am wanting to work out is how much memory SQLite uses if we have the entire database in RAM only, the reason I'd like to find this out is that there is some concern here about SQLite paging to disc at inopportune moments (we're on an embedded system with a lot of other random disc access

Re: [sqlite] Possible Error in 3.6.0?

This was previously reported, and couldn't be reproduced. http://www.sqlite.org/cvstrac/tktview?tn=3262 Any help in recreating it would be appreciated. -Shane On 8/6/08, Peter Holmes <[EMAIL PROTECTED]> wrote: > > FWIW, on a Dell Inspiron 530 running Ubuntu 7.10 with Tcl8.4 installed, > >

Re: [sqlite] Realtime Backup of Database

Just in case anybody else is interessted. I created triggers for my database that look like: SELECT CASE WHEN (SELECT redundance('') !=0) THEN RAISE (ABORT, 'backup on redudant database was not successfull') END; My custom function redundance then executes the statements on the

Re: [sqlite] Clone SQLite databases

I think I have DONE :) I miss one more PRAGMA to copy, the schema_version, which creates the conflict with Firefox, and results a corrupt database. Now everythings work fine. I have only one question: how can I query all the PRAGMAS? I am useing an SQLite library in Delphi, I think that I should

Re: [sqlite] about sqlite database

"janard" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In sqlite whether can we rotate content in database . > That means i want to restirct my database to some size,if it exceeds > that size it has to replace first entry. > Can anybody help.Thanks in advance If you are asking

Re: [sqlite] Loading a existing database 100% into memory

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brown, Daniel > Sent: Thursday, August 07, 2008 12:27 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Loading a existing database 100% into memory > > Good afternoon list, > > I

[sqlite] about sqlite database

In sqlite whether can we rotate content in database . That means i want to restirct my database to some size,if it exceeds that size it has to replace first entry. Can anybody help.Thanks in advance -- View this message in context: