"Andrew Piskorski" <[EMAIL PROTECTED]> wrote:
On Mon, Dec 27, 2004 at 08:51:11PM -0800, Roger Binns wrote:
Why do you need SQLite if you want everything in memory? All you gain is
an SQL Parser to operate on the data structures instead of just doing it
directly yourself.
All? You gain the
On Mon, Dec 27, 2004 at 08:51:11PM -0800, Roger Binns wrote:
> Why do you need SQLite if you want everything in memory? All you gain is
> an SQL Parser to operate on the data structures instead of just doing it
> directly yourself.
All? You gain the relational model, which in some cases could
I know that I can check for the existance of the database file - but I
was hoping to avoid that particular hoop.
That isn't necessarily as easy as you think. Unless you took great
care to ensure that all characters in the pathname are ascii then it
could be quite difficult to know exactly what
What are some of the limitations of using memory tables (operations, counts,
etc)? Looking at Linux 32bit intel implementation (RH) and want to do some
larger tables all in memory. How large you ask ... as large as I can fit in
the typical 2gig workspace.
Why do you need SQLite if you want
What are some of the limitations of using memory tables (operations, counts,
etc)? Looking at Linux 32bit intel implementation (RH) and want to do some
larger tables all in memory. How large you ask ... as large as I can fit in
the typical 2gig workspace.
Also does/can SQLite support 64 Bit O/S
Does sqlite have any mechanism to determine if sqlite3_open has
created a new database, rather than opening an existing database?
The sqlite3_open returns SQLITE_OK for both creation and opening, and
obviously doesn't supply any helpful error messages on success ;>
I know that I can check for the
Hello,
Is there anyone subscribed to this mailinglist that has pam_sqlite running ?
I am trying to setup a system authenticating against a sqlite db.
Thanks,
Taco Scargo
Jay wrote:
>
> I was just doing the design for a project and wondered if sqlite3 was
> reentrant. Can I use the open database connection and execute an sql
> statement from within the callback of another statement?
>
Yes, you can invoke SQL from within the callback of another SQL
statement. But
D.W. wrote:
Thanks for your reply.
I have just checked the version. It's 2.8.15.
There's no active transaction.
Do you have another idea?
How do you verify that nothing happens?
Ulrik
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
Thanks for your reply.
I have just checked the version. It's 2.8.15.
There's no active transaction.
Do you have another idea?
> I hope you're using something later than 2.8.0, because VACUUM was only
> (re)implemented in 2.8.1. From the docs:
>
> http://www.sqlite.org/lang.html#vacuum
>
>
Hi D.W.,
D.W. wrote:
I use sqlite 2.8.x in combination with PHP.
I want to clean up my database and remove empty spaces.
I used this command: $ok=sqlite_query($sqlite,"VACUUM tablename");
But it doesnt't work. An error message didn't come either.
Does anybody know what is wrong?
Daniel
I hope
I use sqlite 2.8.x in combination with PHP.
I want to clean up my database and remove empty spaces.
I used this command: $ok=sqlite_query($sqlite,"VACUUM tablename");
But it doesnt't work. An error message didn't come either.
Does anybody know what is wrong?
Daniel
Kurt Welgehausen wrote:
It may not be as inefficient as you think, if your host
language is C. [snipped]
Also, if you have a performance problem, you can try
putting indices on test.checksum and buckets.checksum
I think I should have clarified -- it is inefficient from developers
point of view
to
Hey Kurt,
Have you tried this yet? I was just doing the design for a project
and wondered if sqlite3 was reentrant. Can I use the open database
connection and execute an sql statement from within the callback
of another statement?
--- Kurt Welgehausen <[EMAIL PROTECTED]> wrote:
> >> for
>> for every testcs in (select checksum from test) do
>> update test set id =
>> (select bucketid from buckets
>> where buckets.checksum = testcs)
>> where test.checksum = testcs
> ... this is not very efficient way of updating multiple rows.
It may
As I start the compilation the scrept ./autogen.sh work fine
and the make will stuck and did not able to run lemon.
Just use the preprocessed source (the zip file). Although it is
primarily aimed at Windows, it actually works perfectly on all
platforms. This is how I compile SQLite, making an
Return Receipt
Your [sqlite] loading Sqlite on Encore's Simputer
document
:
Hi All,
I was trying to complile the Sqlite 3.0.8 from the source provided by
http://www.sqlite.org/
for Encore Simputer http://www.ncoretech.com/simputer/index.html
As I start the compilation the scrept ./autogen.sh work fine
and the make will stuck and did not able to run lemon.
-
The
Suppose I have following schema:
t1.db:
create table t1 (id integer, foo text);
t2.db:
create table t2 (id integer, foo text);
And I want that if I load t1 and attach t2, then deleting a row from t1
would cause delete on row of t2 with same id. I try to do something like
this:
CREATE TRIGGER
Hello All,
first I want to say, thanks for this great fine database. I am new but I
love it. That is the first database that I find, where I don't need any
drivers or services, thats so great I use it as an offline database on cd
for holding informations about multiple Installer Packages. The
20 matches
Mail list logo