I'm using SQLite 3.08 for Windows, SQLite.Net.
Sqlite3Explorer(developed by delphi) can also see this situation.
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
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
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"]
> 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
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
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
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
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
> -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
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
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]
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
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
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
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,
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
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"?
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
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
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
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
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:
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
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
25 matches
Mail list logo