Re: [sqlite] how would you allow users to re-order rows arbitrarily?

Traditionally that is achieved by a doubly linked list. Each row contains a pointer to the next and previous row and a null for the end case. The linked list structure cannot fail regardless of the amount of shuffling or the size. Sean Payne wrote: Suppose gui-users wanted to drag and drop

Re: [sqlite] how would you allow users to re-order rows arbitrarily?

I do it by maintaining a column named 'SortOrder' You can update the field to have whatever content will get you the order you want at the moment and it's preserved the next time they start the application. On 1/6/07, Sean Payne <[EMAIL PROTECTED]> wrote: Suppose gui-users wanted to drag and

RE: [sqlite] Error during compilation of sqlite-3.3.8

Martin, I still get the error. Is it possible that my tclConfig.sh file is not well configured? Is there any parameter that I should look for? Thanks, Dori -Original Message- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 5:21 PM To:

RE: [sqlite] Error during compilation of sqlite-3.3.8

Thanks Dennis. I still get the error. Is it possible that my tclConfig.sh file is not well configured? Is there any parameter that I should look for? Thanks, Dori -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 5:18 PM To:

[sqlite] how would you allow users to re-order rows arbitrarily?

Suppose gui-users wanted to drag and drop rows in a table so that they could shuffle it anyway that they wanted so that the rows maintained that order the next time they accessed the table. Can this be done without updating alot of other rows? How is this normally handled? The ideas I

Re: [sqlite] sqlite performance, locking & threading

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gerry Snyder wrote: > The wiki is there and open to all. > > I look forward to reading your additions to it. To be fair, only some of the documentation is in the wiki. The remainder is generated. For example you can't edit any of the pages listed

Re: [sqlite] sqlite performance, locking & threading

Emerson Clarke wrote: Fix the out of date documentation The wiki is there and open to all. I look forward to reading your additions to it. Gerry - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] sqlite performance, locking & threading

For anyone who is interested i have created a standalone test case which demonstrates the threading behaviour that i had, or as close as i can get it. Feel free to use the code for whatever purposes you see fit. It will compile on linux and windows, and comes with 4 versions of the sqlite

Re: [sqlite] html output with added tag brackets

An example of Sqlite use is in one of our applications ehere we output from Sqlite in XML according to a predefined DTD (HTML is XML defined by a particular DTD). It is achieved by a layer of software which calls the Sqlite library API. The result is structured data which can be fed to

[sqlite] Re: Replace one string with another, in SELECT output

T wrote: Can I, within SQLite output (eg a SELECT statement) replace all occurrences of string 1 with string 2? For instance, if in the Description column output I want to change any occurrence of "string1" to "string2", can it be done? I imagine something like: SELECT Replace(Description,

Re: [sqlite] Replace one string with another, in SELECT output

On 1/6/07, T <[EMAIL PROTECTED]> wrote: Hi All, Can I, within SQLite output (eg a SELECT statement) replace all occurrences of string 1 with string 2? Not easily. This is typically done after you get the results or by writing a custom user function. -- -- The PixAddixImage Collector suite:

RE: [sqlite] sqlite performance, locking & threading

Sounds like a H-- of a plan to me! I'll call Larry Ellison and warn him to put the 12 meter yacht up for sale, he's about to get steam rolled! :-) Fred > -Original Message- > From: Bill King [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 06, 2007 1:15 AM > To:

Re: [sqlite] html output with added tag brackets

Thanks Puneet and John for your input on the virtues of using tools other than the sqlite3 command line tool (and it's .mode html output). OK, I won't use the .mode html output for HTML creation. There's a question aside from that issue that I'll repost for clarity. Thanks, Tom

Re: [sqlite] What's the collective term for table, view, trigger etc?

T <[EMAIL PROTECTED]> writes: > Is there a standard (or even non-standard) term that refers to the tables, > triggers, views, indexes (any others?) in a database? The collective term for all of the definitions taken together is the "schema" of the database. Derrell

RE: [sqlite] What's the collective term for table, view, trigger etc?

> Is there a standard (or even non-standard) term that refers to the > tables, triggers, views, indexes (any others?) in a database? I have seen the term relations being used for this. RBS -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: 06 January 2007 15:06 To:

Re: [sqlite] html output with added tag brackets

Tom, As John mentioned below, you need to distinguish between sqlite, the db library, and sqlite3(.exe)?, the shell program commonly used to access the data held in sqlite format via the sqlite db library. Unfortunately, the names are similar, and that can be a source of confusion. Your problem

Re: [sqlite] What's the collective term for table, view, trigger etc?

> Is there a standard (or even non-standard) term that refers to the > tables, triggers, views, indexes (any others?) in a database? Thingamajiggies. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around

Re: [sqlite] When to release version 3.3.10?

--- [EMAIL PROTECTED] wrote: > In some since, all changes to SQLite are released immediately. Anybody > can download the latest changes from CVS or look at the timeline > (http://www.sqlite.org/cvstrac/timeline) see the changes and download > patches. So source code is released continuously.

Re: [sqlite] html output with added tag brackets

The sqlite3 program is just an application program using the sqlite lbrary. If you have your own version of it is will be compatible with all Sqlite V3 databases. What changes with an Sqlite release is the library that you link into your application. T wrote: Hi John, But, then I need an

Re: [sqlite] What's the collective term for table, view, trigger etc?

entities On 1/6/07, T <[EMAIL PROTECTED]> wrote: Hi All, Is there a standard (or even non-standard) term that refers to the tables, triggers, views, indexes (any others?) in a database? Their definitions all reside in the sqlite_master table, as returned by: sqlite> SELECT name, type FROM

Re: [sqlite] html output with added tag brackets

Hi John, But, then I need an alternate way to convert a few characters (at least & and <) in the fields in my output into the correct html codes. How can I do this? Why not just make a simple change to sqlite3.exe? You have the source. Um, where do I start? Because I want to work with

[sqlite] Re: .mode html output character conversion

* T <[EMAIL PROTECTED]> [2007-01-06 13:05]: > When using SQLite's HTML output mode it converts some > characters to HTML code, such as: > > & -> > < -> > > But doesn't for other characters, such as: > > > -> > " -> > ' -> > © -> (copyright symbol) > all other non-ascii characters > >

Re: [sqlite] When to release version 3.3.10?

[EMAIL PROTECTED] wrote: Dennis Cote <[EMAIL PROTECTED]> wrote: The knowledge that the new version will be released on a certain date will comfort most users enough to simply wait (which might also delay the discovery of more bugs). Exactly. So in order for these bugs to ever be found,

[sqlite] What's the collective term for table, view, trigger etc?

Hi All, Is there a standard (or even non-standard) term that refers to the tables, triggers, views, indexes (any others?) in a database? Their definitions all reside in the sqlite_master table, as returned by: sqlite> SELECT name, type FROM sqlite_master; which yields a list like: Staff

Re: [sqlite] When to release version 3.3.10?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > So "release" in > the SQLite and open-source world means something very different than > "release" for commercial software. In the commerical world, the changes > are unavailable until released. For SQLite, a release

Re: [sqlite] html output with added tag brackets

Why not just make a simple change to sqlite3.exe? You have the source. T wrote: Hi all, Following up my earlier question, since no replies: I want to use SQLite's html output option to deliver query results as a series of HTML rows. But I also want to insert extra HTML tags in the

Re: [sqlite] sqlite performance, locking & threading

Bill King wrote: Roger Binns wrote: Im sorry for being so harsh, and i know im not winning any friends here, So far noone has agreed with you :-) This would be incorrect. The correct statement is "so far no one has vocally agreed with you". If people didn't agree, this whole once

Re: [sqlite] When to release version 3.3.10?

Dennis Cote <[EMAIL PROTECTED]> wrote: > The knowledge that the new version will be released on a certain date > will comfort most users enough to simply wait (which might also delay > the discovery of more bugs). Exactly. So in order for these bugs to ever be found, there has to be an official

Re: [sqlite] .mode html output character conversion

T <[EMAIL PROTECTED]> wrote: > Hi all, > > When using SQLite's HTML output mode: > > ..mode html > > it converts some characters to HTML code, such as: > > & -> > < -> > > But doesn't for other characters, such as: > > > -> > " -> > ' -> > © -> (copyright symbol) > all other

Re: [sqlite] SQLite 3.3.9 changes

T <[EMAIL PROTECTED]> wrote: > On: > > http://www.sqlite.org/changes.html > > it lists, among others: > > > Allow constraint names on the DEFAULT clause in a table definition > > What does this mean? > See http://www.sqlite.org/cvstrac/tktview?tn=2109 -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Re: Error in SQLite's CSV output

Hi All, Back in October I posted: It seems that the csv output from SQLite has a major problem/error. Within CSV format, a quote should be returned as a double quote, within quotes. For example, if I have a field containing: I said "Hi there" then the CSV representation should be: "I

[sqlite] Re: When to release version 3.3.10?

* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2007-01-05 13:15]: > The question is: should I rush out 3.3.10 to cover this > important bug fix, wait a week to see if any other bugs > surface, or do the usual 1-2 month release schedule and > let people effected by this bug apply the patch above. I

[sqlite] Re: What about Foreign Key support (when?)

* Marc Ruff <[EMAIL PROTECTED]> [2007-01-05 17:35]: > So next feature to expect is Foreign Key constraints!? Great! > > When? Any plans yet? You can use triggers to enforce FKs until they are natively enforced: