Hello,
I came across the article below and thought this might interest
at least some people on this list.
Regards,
Arjen
--
Title:
Semantic errors in SQL queries: A quite complete list
Authors:
Brass, S; Goldberg, C
Source:
JOURNAL OF SYSTEMS AND SOFT
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> Let's assume that for a given OS that fcntl() file locks
> work perfectly well on any thread. Would it then be safe
> from an SQLite perspective to finalize statements that were
> prepared in one thread in a different thread? (where the sqlite
> connect
Let's assume that for a given OS that fcntl() file locks
work perfectly well on any thread. Would it then be safe
from an SQLite perspective to finalize statements that were
prepared in one thread in a different thread? (where the sqlite
connection would only be used on one thread at a time).
--
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> I need help in generating a unique integer for the table's primary key. I am
> more familiar with MS Access that has a data type called "Autonum" that
> generates the integer. Do I need to find the last record to know what the
> next number should
http://www.sqlite.org/faq.html. No. 1.
|-+>
| | "[EMAIL PROTECTED]|
| | "
>--|
|
[EMAIL PROTECTED] wrote:
I need help in generating a unique integer for the table's primary
key.
See http://sqlite.org/lang_createtable.html, particularly the part about
ROWID, PRIMARY KEY and AUTOINCREMENT
Igor Tandetnik
Hi,
I need help in generating a unique integer for the table's primary key. I am
more familiar with MS Access that has a data type called "Autonum" that
generates the integer. Do I need to find the last record to know what the next
number should be?
Thanks in advance,
Bill
Joe,
Thanks for the info...
Unfortunately, we don't have the option of moving back to v3.2.1. However,
I'm curious as well to see the difference in performance, so when (if?) I
get my current performance issues under control, I'll run the test and
post the results.
Steve
Joe Wilson wrote:
If
Thank you for the help Andrew and D. Richard Hipp. But how would I do
this (page 24 & 25 of the slides) using the C/C++ interface?
{
sqlite3* pFileDB;
sqlite3* pMemoryDB;
sqlite3_open(fileName, &pFileDB);
sqlite3_open(":memory:", &pMemoryDB);
//***
In a multi-threaded approach all threads are c-operative since they
belong to the same process, and therefore synchronization is possible in
multiple fashions. Synchronization of multiple processes is only
possible if they co-operate, such as using file locks or semaphores.
Synchronization ove
I would be tempted to create triggers to maintain a "dirty table" list
and use that to drive the copy. If you were to organize your copies in
transactions with COMMITs you would be protected from hardware failures.
If you find a way to do it without a performance hit expect a Nobel Prize
[EMA
Mark Drago <[EMAIL PROTECTED]> wrote:
>
> The query I'm running is the following:
> select count(host), host from log group by host;
>
> The results include the first time the query is run (when the file is
> not cached) and then the times of a few runs after that (when the file
> is cached).
>
Hello,
I'm writing a web cache and I want to use SQLite to store the log of all
of the accesses made through the web cache. The idea is to install this
web cache in large institutions (1000-5000 workstations). The log
database can grow in size very quickly and can reach in to the gigabytes
after
I am using tcl8.4.6 and have upgraded my sqlite from sqlite-2.8-13 to
sqlite-3.3.5. I originally tried to update my tcl8.4.6 to tcl8.4.11 and
could not get my application to run. I can get my application to come
up with tcl8.4.6 and the sqlite-3.3.5 with some problems. After
changing application
On Mon, 5 Jun 2006, Cesar David Rodas Maldonado wrote:
> I am developing something for that.
>
> where can i send you my script? (is done in C)
I think more people will be interested in it. So if it is not too big send
it to the list, otherwise put in on a website :) (or mail me privately)
Ste
I am developing something for that.
where can i send you my script? (is done in C)
On 6/5/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
On Mon, 5 Jun 2006, Cesar David Rodas Maldonado wrote:
> i am interesting to do something for sqlite, and i was thinking to try
to do
> a multi threading f
On Mon, 5 Jun 2006, Cesar David Rodas Maldonado wrote:
> i am interesting to do something for sqlite, and i was thinking to try to do
> a multi threading for read and write at the same time, like MySQL, or i
> would like to do something for fulltext search.
>
> Please people answer me giving me id
hello
i am interesting to do something for sqlite, and i was thinking to try to do
a multi threading for read and write at the same time, like MySQL, or i
would like to do something for fulltext search.
Please people answer me giving me ideas!!!
Andrew Piskorski <[EMAIL PROTECTED]> wrote:
> On Mon, Jun 05, 2006 at 12:05:52PM -0700, Dave Gierok wrote:
>
> > Is there a way to load a Sqlite file based DB and then specify we want
> > that to go into memory? Or is there a more efficient way to create our
> > memory DB?
>
> You could use atta
"Dave Gierok" <[EMAIL PROTECTED]> wrote:
> I am developing a game on Xbox360 using Sqlite for a lot of our data
> manipulation.
That's good to know. I'll be shortly adding a Microsoft logo
to the image of companies and projects using SQLite at
http://www.sqlite.org/google-talk-slides/logos4.g
On Mon, Jun 05, 2006 at 12:05:52PM -0700, Dave Gierok wrote:
> Is there a way to load a Sqlite file based DB and then specify we want
> that to go into memory? Or is there a more efficient way to create our
> memory DB?
You could use attach to copy from an on-disk SQLite database:
http://www.
Doug Nebeker wrote:
> The problem with that solution is that it assumes all database access
> happens from within a single process. As far as I understand it, SQLite
> allows database access from multiple processes (and even from remote
> processes I assume) and thus the locking has to happen outs
I am developing a game on Xbox360 using Sqlite for a lot of our data
manipulation. We use the ':memory:' functionality to create our DB in
RAM, because we need our DB manipulations to be very fast - we can't
afford for our queries to cause seeks/loads on the DVD.
This works very well for us
[EMAIL PROTECTED] wrote:
Dave Dyer <[EMAIL PROTECTED]> wrote:
The real problem is that sqlite assumes it "owns" the temporary
transaction file that it created, and can do anything it wants with it;
for example read, rename, or delete it.
I think this is a very reasonable assumption.
Any othe
A. Pagaltzis wrote:
* Roger Binns <[EMAIL PROTECTED]> [2006-06-05 00:05]:
I don't know if anyone has tracked how well Spotlight (Mac) or
Beagle (Linux) work with SQLite files.
They cause no problems. The semantics of the filesystem API on
*nix systems differ from those of Windows; in short, a
What is the best/most efficient way to perform comparisons or joins on data
where case sensivitiy is not important?
e.g join two tables where the primary and foreign key values have different
case?
Best to use Like or upper() or Lower() or some other way of ignoring case?
Thanks,
Mike
--
View
The problem with that solution is that it assumes all database access
happens from within a single process. As far as I understand it, SQLite
allows database access from multiple processes (and even from remote
processes I assume) and thus the locking has to happen outside of the
process. In proc
This is an implementation question but I am pretty sure it applies to many
people out there.
I am using a memory database which I want to "flash" periodically. I have
logically broken down the database into three pieces which have 3 degrees
of importance (critical, high and low). I have written
Anish Enos Mathew <[EMAIL PROTECTED]>
wrote:
I want to do a vacuum on my table. Can any one tell me
whether the below statement is the valid syntax for the vacuum
command.
sqlite3_exec (db, "vacuum (data_table)", NULL, NULL, NULL);
The syntax is
VACUUM;
-- or
VACUUM table
Halim Issa <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have been trying to get an application that utilizes SQLite to run on our
> system, but according to the application developers it fails because SQLite
> is incompatible with NFS and thus cannot work on NFS-mounted volumes.
> Attempts at locating
Your problem is with NFS. Maybe you can get a fix or upgrade for your
particular NFS installation so that file locking works reliably.
Halim Issa wrote:
Hi,
I have been trying to get an application that utilizes SQLite to run on our
system, but according to the application developers it fail
Halim Issa wrote:
Hi,
I have been trying to get an application that utilizes SQLite to run on our
system, but according to the application developers it fails because SQLite
is incompatible with NFS and thus cannot work on NFS-mounted volumes.
Attempts at locating this bug in the SQLite databa
How to cross-compile sqlite for ARM9?
I have read some articles about that,
but it doesn't work.
May someone send the image to me,
or send the modified package to me.
I really appreciate it.
My address: [EMAIL PROTECTED]
[EMAIL PROTECTED] schreef:
See http://www.sqlite.org/cvstrac/chngview?cn=3200 for the fix.
In the changes i don't see calls to 'GetLastError()' as MS suggests..
Error logging might help tracing the error. Maybe a sqlite error log is
a usefull feature request..
Another hint from the Dele
> The code compiles and runs for me. I am running the regression
> test suite as I type this and there are no problems so far. However,
> let me restate that I do not have the ability to test the behavior
> of SQLite in the presence of virus scanners and Tortoise SVN, so
> I am looking for people
Hi all,
I want to do a vacuum on my table. Can any one tell me
whether the below statement is the valid syntax for the vacuum command.
How can we make sure that the command is really executing or not. Will
there be any time difference if we do the vacuum for a table? I tried
inserting
* Roger Binns <[EMAIL PROTECTED]> [2006-06-05 00:05]:
I don't know if anyone has tracked how well Spotlight (Mac) or
Beagle (Linux) work with SQLite files.
They cause no problems. The semantics of the filesystem API on
*nix systems differ from those of Windows; in short, a file and
its name are
system, but according to the application developers it fails because SQLite
is incompatible with NFS and thus cannot work on NFS-mounted volumes.
The bug is in the NFS implementations out there. They do not perform
locking completely and correctly. This cannot be fixed in SQLite - it
has to be
38 matches
Mail list logo
