Re: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

I'm using SQLite 3.08 for Windows, SQLite.Net. Sqlite3Explorer(developed by delphi) can also see this situation.

Re: [sqlite] Detecting if the db has changed

Look for timestamp of the db file. You can see if it is updated. If you want to see what process is writing to it. you can partially use process admin tools and figureout who is accessing the file. Richard already answered. There is no mystery about who else is writing to the db - it will be

Re: [sqlite] Detecting if the db has changed

In a version 3 database, bytes 24-27 form a big-endian integer which is incremented with each change. Is there any chance this can be exposed as a pragma like schema and user cookies? That way the checking code can play fair with any transactions/locking that is happening and not have to worry

Re: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

create table tb (ID varchar); Code example: IDataReader reader = command.ExecuteReader("select * from tb"); Console.WriteLine((string)reader["ID"]); While: IDataReader reader = command.ExecuteReader("select \"ID\" from tb"); Console.WriteLine((string)reader["\"ID\"]; // using reader["ID"]

Re: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

> select "ID" from tb" > > Doesn't this mean select the literal value "ID"? No, if ID is a valid column name in the context, "ID" will evaluate to a column reference; you must use single quotes to ensure evaluation as a literal -- BTW, this is correct behavior for std SQL. Regards

Re: [sqlite] Changing table and security

D. Richard Hipp wrote: wiseguy wrote: I've been used sqlite a bit since php5 beta version. Now I am making a website and at this point I must decide which database I should use. My wish is to use sqlite, but friends of mine say that I might have problem down the road if I need to add a column

Re: [sqlite] ODBC ADO

George Ionescu wrote: Hello Bert, have you tried using one of the ActiveX wrappers? I know it's not ODBC/ADO, but my wrapper (http://www.terrainformatica.com/sqlitedb) has at least an ADO-compatible interface, so that might help. I didn't want to write a full-blown ADO provider because this is

RE: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

Doesn't this mean select the literal value "ID"? ** - Sounds like a Wookie; acts like mad cow. - I'm not a professional; I just get paid to do this. - Rules for programming: 1. Get it working, right? 2. Get it working right. - Things

Re: [sqlite] Changing table and security

On Tue, 21 Dec 2004 14:48:33 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > wiseguy wrote: > > > > I've been used sqlite a bit since php5 beta version. Now I am making a > > website and at this point I must decide which database I should use. My wish > > is to use sqlite, but friends of mine

RE: [sqlite] Is the mailing list working

> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: 21 December 2004 19:23 > To: [EMAIL PROTECTED] > Subject: [sqlite] Is the mailing list working > > No messages in 3 days (*very* unusual!) I've reset the > server (qmail) twice. Still nothing. A bunch of

Re: [sqlite] Any way of using an implicit BTree ordering in SQLite?

On Sun, Dec 19, 2004 at 12:09:08PM +0100, Bertrand Mansion wrote: > For web applications (sqlite being now the default database for PHP5), > COUNT(*) > performance is more important than INSERTs and DELETEs performance. The > obvious That sounds VERY much like a matter of opinion. I strongly

Re: [sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

red forks wrote: A table: create table tb (ID varchar); When execute select * from tb, I can refer the column row["ID"], while using "select "ID" from tb", I must using row["\"ID\"']. Why Sqlite return column name as "ID"? I do not understand the question. -- D. Richard Hipp -- [EMAIL PROTECTED]

Re: [sqlite] Changing table and security

wiseguy wrote: I've been used sqlite a bit since php5 beta version. Now I am making a website and at this point I must decide which database I should use. My wish is to use sqlite, but friends of mine say that I might have problem down the road if I need to add a column on database or

Re: [sqlite] Using password with SQLite

Bronislav Klucka wrote: I want to use sqlite as database for project written in PHP, is there any way howto protect this database using password? I don't want users to be able to connect to this database directly. Your use of PHP implies that the project is web-based. If so, then just locate

Re: [sqlite] Detecting if the db has changed

Roger Binns wrote: Is there a simple way to tell if the database contents have changed in any way since I last looked. (I am particularly thinking of the case of another process having changed the content). In a version 3 database, bytes 24-27 form a big-endian integer which is incremented with

RE: [sqlite] Detecting if the db has changed

Look for timestamp of the db file. You can see if it is updated. If you want to see what process is writing to it. you can partially use process admin tools and figureout who is accessing the file. Srinivas' -Original Message- From: Roger Binns [mailto:[EMAIL PROTECTED] Sent: Sunday,

[sqlite] Is the mailing list working

No messages in 3 days (*very* unusual!) I've reset the server (qmail) twice. Still nothing. I'm wondering if something else is broken or if everybody is just off for the Christmas Holiday. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

[sqlite] What's the difference of "select * from tb" and "select "ID" from tb"?

A table: create table tb (ID varchar); When execute select * from tb, I can refer the column row["ID"], while using "select "ID" from tb", I must using row["\"ID\"']. Why Sqlite return column name as "ID"?

[sqlite] Changing table and security

Hi there! I intend to use sqlite on a website I am making, but I am a bit concerned about if I need to change the table down the road, since there is no alter table on sqlite. How hard is it to alter a table w/ about 100.000 entries thru a php script? I am a bit concerned on its execution

Re: [sqlite] SQLite 3.08 Deadlock in a Linux Multithreaded Multi-Process Application

D. Richard Hipp wrote: For additional information on the brokenness of POSIX advisory locks and of POSIX threads, and in particular how they are especially broken when used together, read the comments in the source file os_unix.c. After reading D. Richard Hipp's reply to this message I did a

Re: [sqlite] Row count in database

Oy! After doing some research and actually changing machines, I isolated the problem. Linux. well, no, not really, but the drivers for the SATA controller I have are so horrendously bad that they crap out under load. How they ever got considered "releasable" is another question entirely. Once

[sqlite] Changing table and security

Hi there! I've been used sqlite a bit since php5 beta version. Now I am making a website and at this point I must decide which database I should use. My wish is to use sqlite, but friends of mine say that I might have problem down the road if I need to add a column on database or something

Re: [sqlite] ODBC ADO

Hello Bert, have you tried using one of the ActiveX wrappers? I know it's not ODBC/ADO, but my wrapper (http://www.terrainformatica.com/sqlitedb) has at least an ADO-compatible interface, so that might help. I didn't want to write a full-blown ADO provider because this is the beauty of sqlite:

[sqlite] Using password with SQLite

Hi, I want to use sqlite as database for project written in PHP, is there any way howto protect this database using password? I don't want users to be able to connect to this database directly. Thanx Brona

[sqlite] Detecting if the db has changed

Is there a simple way to tell if the database contents have changed in any way since I last looked. (I am particularly thinking of the case of another process having changed the content). Roger