Re: [sqlite] Is sqlite the right db for me?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve Davis wrote: | Does that change your opinion? Not in the slightest. You can run the web server and browser on the same machine as you have presumably already been doing. (Unless you have been using the word browser to mean something other

Re: [sqlite] Using a view is slower than using the query that comprises the view?

A view is basically just a SELECT on a subquery. These two queries are functionally equivalent: SELECT * from va; SELECT * from (SELECT a, b, 0 AS c FROM ta UNION SELECT a, b, 1 FROM tb); SELECTs on subqueries (or views) containing UNION or INTERSECT or EXCEPT can be slow.

RE: [sqlite] Is sqlite the right db for me?

Roger, I appreciate your response and am sorry for wasting your time a bit by not being more detailed... It is not a web-based app, rather browser based. Many brigades do not have net access at their stations, they might only have someone there once a fortnight, so it isn't viable. Also this

Re: [sqlite] Is sqlite the right db for me?

I would endorse Roger's comments. A web interface can give you everything you can get from a stand-alone application but also gives you flexibility. The greatest advantage of the web application is that you have no software loading onto PCs, a real nuisance. As long as the browser works

Re: [sqlite] building sqlite on windows in Unicode

Brodie Thiesfield <[EMAIL PROTECTED]> wrote: > Done. Is there anything else that is necessary to contribute code and > patches to sqlite? For ticket #2023, the first patch seems unlikely to work right since it changes the character encoding for LoadLibrary() but leaves it unchanged for

Re: [sqlite] Re: SQLITE_BUSY scenario

Igor, I thought having a statement in progress or not finalized resulted in SQLITE_LOCKED, not SQLITE_BUSY... but I have been searching for such a condition anyway. As to the second question below, the parameters bound each time are different, thus the reset. Igor Tandetnik wrote: Dixon

Re: [sqlite] SQLITE_BUSY scenario

No, I did not explicitly set it. John Stanton wrote: Do you set the inherit handles flag on your CreateProcess call? Dixon Hutchinson wrote: The basic problem is that I am getting SQLITE_BUSY on a call to sqlite3_exec where the SQL passed is simply "COMMIT;" Notes: 1. This in on a

Re: [sqlite] Is sqlite the right db for me?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve Davis wrote: | Some time ago I wrote a member and incident management application for | my volunteer bushfire brigade in PHP/mySQL. It works quite well but is | browser based which limits it a bit. Being browser based shouldn't be limiting

Re: [sqlite] SQLITE_BUSY scenario

Dixon Hutchinson wrote: The basic problem is that I am getting SQLITE_BUSY on a call to sqlite3_exec where the SQL passed is simply "COMMIT;" Notes: 1. This in on a WIN32 platform. 2. There is only one process (the main process) that makes any calls to sqlite3 for the DB in question.

[sqlite] Re: SQLITE_BUSY scenario

Dixon Hutchinson wrote: The basic problem is that I am getting SQLITE_BUSY on a call to sqlite3_exec where the SQL passed is simply "COMMIT;" Most likely, you still have a statement in progress that has not been reset or finalized. 3. Bind parameters to a previously prepared

RE: [sqlite] Is sqlite the right db for me?

Ahhh...thanks for that. All the best Steve Davis Steve Davis - too much time on his hands -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Sunday, 17 December 2006 9:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is sqlite the right db for me? On

[sqlite] Is sqlite the right db for me?

Hey folks I am starting an ambitious project that I fear I may regret :P Some time ago I wrote a member and incident management application for my volunteer bushfire brigade in PHP/mySQL. It works quite well but is browser based which limits it a bit. Other Brigades have eyed it enviously

Re: [sqlite] building sqlite on windows in Unicode

Done. Is there anything else that is necessary to contribute code and patches to sqlite? The bug database seems to lack feedback (many bugs seem to just lie stale, there is no way to create an account to login, etc). I can't find documentation on the website on contributions. Regards, Brodie

[sqlite] Using a view is slower than using the query that comprises the view?

Hi, In my database I find that the explain program for the view (114 statements) is much longer than direct query that comprises the view (89) and almost twice as long as doing the 2 separate queries that make up the union in the view (39 + 30 = 69). To explain more clearly what I mean, if I

[sqlite] SQLITE_BUSY scenario

The basic problem is that I am getting SQLITE_BUSY on a call to sqlite3_exec where the SQL passed is simply "COMMIT;" Notes: 1. This in on a WIN32 platform. 2. There is only one process (the main process) that makes any calls to sqlite3 for the DB in question. 3. The process is

Re: [sqlite] Is Column UNIQUE? How To

On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: Yeah, as I thought before. Well nevermind, I should parse the table schema then. Thanks You're welcome. -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command

Re: [sqlite] Is Column UNIQUE? How To

On 12/17/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: > I meant, I want retrieve the information of the column or schema as > much as possible, so I can build a new schema based on it. Then I need > to know if column is a UNIQUE or not

Re: [sqlite] Is Column UNIQUE? How To

On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: I meant, I want retrieve the information of the column or schema as much as possible, so I can build a new schema based on it. Then I need to know if column is a UNIQUE or not and so on. select * from sqlite_master; It tells you

Re: [sqlite] SQL extension

Maybe he wants to change the SQL keywords to Esperanto, or implement CONNECT BY. You never know. --- John Stanton <[EMAIL PROTECTED]> wrote: > The questioner might find that user functions will extend the capability > to do what he wants without implementing new SQL syntax. > > Joe Wilson

Re: [sqlite] Is Column UNIQUE? How To

Hi Jay, On 12/17/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: > Hi, > > Is any possible way to know if a column is UNIQUE without "PRAGMA > index_info('')"? Seems "PRAGMA table_info('')" > doesn't returns the unique flag of column. > >

Re: [sqlite] Is Column UNIQUE? How To

On 12/16/06, Firman Wandayandi <[EMAIL PROTECTED]> wrote: Hi, Is any possible way to know if a column is UNIQUE without "PRAGMA index_info('')"? Seems "PRAGMA table_info('')" doesn't returns the unique flag of column. Thanks for advice. this will show you the count of duplicated values for a

Re: [sqlite] SQL extension

The questioner might find that user functions will extend the capability to do what he wants without implementing new SQL syntax. Joe Wilson wrote: http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/parse.y=1.210 --- Dusan Gibarac <[EMAIL PROTECTED]> wrote: What are our options to extend or

Re: [sqlite] SQL extension

http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/parse.y=1.210 --- Dusan Gibarac <[EMAIL PROTECTED]> wrote: > What are our options to extend or change SQL syntax if needed? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam

[sqlite] Is Column UNIQUE? How To

Hi, Is any possible way to know if a column is UNIQUE without "PRAGMA index_info('')"? Seems "PRAGMA table_info('')" doesn't returns the unique flag of column. Thanks for advice. -- Firman Wandayandi

Re: [sqlite] sqlite internationalization

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rashmi Hiremath wrote: | someone have an SQLite internationalization samples | which I can take a look at ? | | Also can I save,search in internationalization fomat ? Your question doesn't make sense. SQLite does not have a user interface - - it is