It does not, but you can attach triggers to a view to achieve the same
effect.
> -Ursprüngliche Nachricht-
> Von: Robert Smith [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 9. Dezember 2007 08:31
> An: sqlite-users@sqlite.org
> Betreff: [sqlite] Does SQLite support modifying date
On Nov 27, 2007, at 10:27 PM, Michael Ruck wrote:
Are all CREATE ... statements transactional or is only CREATE TABLE
transactional?
All of the CREATE and DROP statements work properly within
transactions. If the containing transaction is rolled back, the CREATE
or DROP is rolled back along
Are all CREATE ... statements transactional or is only CREATE TABLE
transactional?
Mike
> -Ursprüngliche Nachricht-
> Von: Dan [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 27. November 2007 15:59
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] Transactional DDL
>
>
> On Nov
I know that a natural join exists, but it is not automatic as
it seems to be in MySQL.
> -Ursprüngliche Nachricht-
> Von: Dennis Cote [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 20. November 2007 18:32
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] Re: Performance tuning, and
Nachricht-
Von: Odekirk, Shawn [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 29. Oktober 2007 14:04
An: sqlite-users@sqlite.org
Betreff: RE: AW: AW: [sqlite] INSERT OR IGNORE and
sqlite3_last_insert_rowid()
The sqlite3_last_insert_rowid function is completely, 100% reliable in
your
ve
> known beforehand that it is not reliable if used with ON CONFLICT clauses.
>
> Mike
>
> -Ursprüngliche Nachricht-
> Von: Odekirk, Shawn [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 29. Oktober 2007 14:04
> An: sqlite-users@sqlite.org
> Betreff: RE: AW: AW: [sqlite]
This does look like a solution indeed. I'll try this one later.
Thank you!
Mike
-Ursprüngliche Nachricht-
Von: Simon Davies [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 29. Oktober 2007 16:40
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] INSERT OR IGNORE and
PM
To: sqlite-users@sqlite.org
Subject: AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()
I'd suggest putting this into the documentation of
sqlite3_last_insert_rowid(), that
the call is not reliable in scenarios such as this one.
-Ursprüngliche Nachricht-
Von: D
On 10/28/07, Michael Ruck <[EMAIL PROTECTED]> wrote:
> I'd suggest putting this into the documentation of
> sqlite3_last_insert_rowid(), that
> the call is not reliable in scenarios such as this one.
It might be appropriate to just stress it only works for successful
INSERTs. I'd just assumed
Betreff: Re: AW: AW: [sqlite] INSERT OR IGNORE and
sqlite3_last_insert_rowid()
On Oct 28, 2007, at 10:59 AM, Michael Ruck wrote:
> Yes, I am well aware of this possibility as I've written in my
> initial mail.
> It just doesn't fit with the
> description of sqlite3_last_insert_r
Good point.
Thanks.
-Ursprüngliche Nachricht-
Von: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 28. Oktober 2007 17:48
An: sqlite-users@sqlite.org
Betreff: Re: AW: AW: [sqlite] INSERT OR IGNORE and
sqlite3_last_insert_rowid()
On Oct 28, 2007, at 10:59 AM, Michael Ruck
On Oct 28, 2007, at 10:59 AM, Michael Ruck wrote:
Yes, I am well aware of this possibility as I've written in my
initial mail.
It just doesn't fit with the
description of sqlite3_last_insert_rowid() in my understanding. I
think this
is a bug - either in the documentation
or in the
]
Gesendet: Sonntag, 28. Oktober 2007 15:36
An: sqlite-users@sqlite.org
Betreff: Re: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()
[Default] On Sun, 28 Oct 2007 10:00:52 +0100, "Michael Ruck"
<[EMAIL PROTECTED]> wrote:
>Hi,
>
>I did specify UNIQUE for cate
[Default] On Sun, 28 Oct 2007 10:00:52 +0100, "Michael Ruck"
<[EMAIL PROTECTED]> wrote:
>Hi,
>
>I did specify UNIQUE for category. The id is also kept, so everything is
>working
>*except* that I don't get the id of the record ignored from
>sqlite3_last_insert_rowid().
>
>Mike
You could simply
Hi,
I did specify UNIQUE for category. The id is also kept, so everything is
working
*except* that I don't get the id of the record ignored from
sqlite3_last_insert_rowid().
Mike
-Ursprüngliche Nachricht-
Von: Kees Nuyt [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 27. Oktober 2007
If you're running under constraints so low, you should take care choosing
the right
tools for the job. Apparently sqlite isn't the right tool for this job.
Mike
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 5. Oktober 2007 00:19
An:
Using run length encoding on your keys is an ingenious approach.
Another idea would be to reverse the keys so the significant chars are
first. Splitting keys to produce the effect used in prefix b-trees cold
also be an option.
Michael Ruck wrote:
As has been suggested numerous times, you
That's not what I meant. I meant the following:
Take the key in the format
'kkk
k490' and split it into
two(66 characters each) /three (44 characters each) colums of equal
You can also add a custom method like "StringReverse(stringtToRevers)" and
reverse the keys on your insert and select-statements.
Sylko Zschiedrich
-Ursprüngliche Nachricht-
Von: Ken [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 3. Juli 2007 16:24
An: sqlite-users@sqlite.org; [EMAIL
Ditto.
my test case proved conclusively that the concatenated KEY string in the first
example is very poor. In general columns should not contain concatenated data.
The test results show timings with a 4k page_size and default cache size. The
end result was a 1.2 to 1.1 second access
As has been suggested numerous times, you should split the key. The keys
you've shown are very long and only differ in the last characters. You
should try yourself to split the key (maybe in two or three columns) and
order the key according to the change frequency. This way sqlite doesn't
have to
Don't use sqlite_get_table. Use sqlite3_prepare(_v2), sqlite3_step and
sqlite3_finalize/sqlite3_reset.
Mike
-Ursprüngliche Nachricht-
Von: RaghavendraK 70574 [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 25. Juni 2007 13:48
An: sqlite-users@sqlite.org
Betreff: [sqlite] In Mem Query
Just forgot to mention:
Referencing in previous open/attached databases should also be possible with
foreign key constraints, when they will be enforced...
Marc
On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote:
>> Is it possible to do this:
>>
>>Open DB1
>>
>>Attatch DB2
>>
Just call sqlite3_exec with the proper ATTACH as you would on the command
line. (Of course you could also do a prepare/step/finalize, but for ATTACH
sqlite3_exec is enough.)
Example:
sqlite3 *db = NULL;
/* ... */
sqlite3_exec(db, "ATTACH DATABASE 'filename' AS dbname",
> The problem is my application is used by thousand of customers.
> I cannot ask them to tweak their antivirus.
Why don't you encrypt the message content before storing?
Christian
-
To unsubscribe, send email to [EMAIL
the files I was sent seemed to clear that up. Now I think it is
strictly c++ builder giving me aggravation for whatever reason.
Thanks
- Jon
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 29, 2007 12:50 PM
To: sqlite-users@sqlite.org
Subject: Re: AW
If that is his only problem all he has to do is some basic definitions
for his compiler specifyng the Sqlite3 API components he is using.
Michael Ruck wrote:
If I understand him correctly, he's having issues including the original
sqlite3.h in his own sources too... He tried to build sqlite
If I understand him correctly, he's having issues including the original
sqlite3.h in his own sources too... He tried to build sqlite again to solve
that problem, but it remains there too.
I would recommed patching up sqlite3.h to conform to BC++ requirements -
changing those structs to something
Thank you! It work's fine..
Sylko
-Ursprüngliche Nachricht-
Von: Stephen Oberholtzer [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 23. April 2007 15:42
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] INSTEAD OF Trigger Question
On 4/23/07, Sylko Zschiedrich <[EMAIL PROTECTED]> wrote:
>
Thanks for your response. Do you have a recommendation for a simpler data
store, which supports only simple queries (like, equals, not equals on
attributes) and transactions?
Thanks,
Mike
-Ursprüngliche Nachricht-
Von: A. Pagaltzis [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. April
> the database residing on removable media. When the system returns,
the
> "pointer" to the media is not guaranteed to work again. In other
words,
The file handle remains perfectly valid when the media has not been
removed or changed. Besides, I've observed that sometimes the media is
not
Hello Joel!
We were faced with similar problems in the field, too. Those were more
general ones with PCMCIA/CF/SD cards.
The reason was that the mobile devices (different device types with
Windows CE 4.1 and 5.0) doesn't handle the access to removable media
gracefully when the device is going to
Unfortunately DEBUG builds change timing entirely on windows platforms. I
would suggest creating a release build with symbols.
Mike
-Ursprüngliche Nachricht-
Von: Joel Cochran [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. April 2007 20:59
An: sqlite-users@sqlite.org
Betreff: Re:
Unless things have changed recently, the following should still be valid for
Windows Mobile/Windows CE devices: Usually these devices do not power off,
but
stay in a standby state where the memory is always powered. Check if that's
the
case with your system and move as much as possible into RAM
If something passes all tests but fails later then it is very likely
failing where testing was not performed, such as the hardware under
other conditions.
Michael Ruck wrote:
Hi,
Is this the only device seeing this error or are *all* devices seeing this
error? Have you checked the CF card?
Hi,
Is this the only device seeing this error or are *all* devices seeing this
error? Have you checked the CF card? May be its just the card, which is
corrupt and you're hitting these bugs at points, where the file system is
hitting a bad sector.
Is this running in a transaction?
Mike
Guessing from his call stack he's doing a select. ExecuteReader executes a
statement, which must return a resultset (aka select.)
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 13. April 2007 17:57
An: [EMAIL PROTECTED]
Betreff: Re: [sqlite]
You can only open one connection in exclusive mode - even in one process.
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 10. April 2007 20:14
An: sqlite-users@sqlite.org
Betreff: [sqlite] Exclusive Access
A quick question in case someone has
n Stanton [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 6. April 2007 20:49
> An: sqlite-users@sqlite.org
> Betreff: Re: AW: AW: [sqlite] Function Language
>
> By using making the connection from browser to server an RPC model I
have
> mapped the interface to the datab
TED]> wrote:
Sure.
Michael Ruck wrote:
> If you come up with something, please share it.
>
> Mike
>
> -Ursprüngliche Nachricht-
> Von: John Stanton [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 6. April 2007 20:49
> An: sqlite-users@sqlite.org
> Betreff: Re: A
That Sybase and MS SQL match on their behavior is no surprise considering
their common heritage ;) I suppose MS (and sybase for that matter) hasn't
done anything on the transaction support since they've split their code
bases.
-Ursprüngliche Nachricht-
Von: Griggs, Donald [mailto:[EMAIL
Yes, but this violates ACID principles. As Igor pointed out this does not
resemble a full implementation of transactions, as nested transactions can
be commited and rolled back independently of the outer parent transaction.
Mike
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
How about managing fts_table using triggers attached to the master table?
That should take care of synchronization issues IMHO.
Mike
-Ursprüngliche Nachricht-
Von: Paul Quinn [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 7. April 2007 09:08
An: sqlite-users@sqlite.org
Betreff: [sqlite]
If you come up with something, please share it.
Mike
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 6. April 2007 20:49
An: sqlite-users@sqlite.org
Betreff: Re: AW: AW: [sqlite] Function Language
By using making the connection from browser
Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 6. April 2007 18:22
An: sqlite-users@sqlite.org
Betreff: Re: AW: [sqlite] Function Language
Thankyou for the thoughtful comments. It strikes me that a JS object and an
Sqlite row map nicely. When I was writing the part of my application server
Thankyou for the thoughtful comments. It strikes me that a JS object
and an Sqlite row map nicely. When I was writing the part of my
application server which encapsulates Sqlite rows in JSON I was struck
by how simple the interface was, particularly compared to XML which
involves a little
I am all for it and am very interested in your project as I'm working on
something similar. I've been using JS to create dynamic HTML pages in
combination with SQLite using a JSON wrapper from this list. The only issue
I see here is the treatment of JS objects - there's again the OO and
relation
Actually UTF-8 is the better choice compared to UTF-16. I would start
turning on UTF-8 as the character set on your web server and ensure that it
is also specified as the document character set in all generated HTML pages.
This gives browsers a hint about the text encoding to use to render pages.
I built something like that where each word was translated into a token
and a key built from the token and the position of the word and used to
build a tree. The tree access was fast and could probably be adapted to
produce strict ranking by position. The complexity of the method is the
need
Unfortunately, the fts module of sqlite does not support "fuzzy text search =
google search".
What you first need is a similarity measure between strings, e.g. the
Edit-distance.
Based on such a similarity measure, you could build up an appropriate index
structure,
e.g. a Relational M-tree
> randomness as you need. But I do not know how to do this on
> win32 and wince. The current implementation seeds the random
As Michael already suggested, you should use the CryptoAPI
(CryptAquireContext, CryptGenRandom). This API is supported by all 32
bit desktop versions and by Windows CE
I'm not sure if this helps, but QueryPerformanceCounter could be
a source of semirandom 64-bit integers. It returns the processors
running time in nanoseconds. I'm not aware of anything, which returns
really random values.
On Windows itself you could use the CryptAcquireContext, CryptGenRandom
Yes, I second this opinion. However I believe sqlite is ACID, just not when
shared cache mode is enabled...
Mike
-Ursprüngliche Nachricht-
Von: Ken [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 14. Januar 2007 17:00
An: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Betreff: Re: [sqlite] Of
An OLE object is persisted into a stream of bytes. You can store OLE objects
into SQLite as a BLOB, but you need to make your own (specialized)
implementation of one of the IPersistXXX interfaces (most likely
IPersistStream), which stores the object into an SQLite column/reads a
serialized object
> not to spark a debate
Although the majority of this thread is as clear as mud, it is still
interesting, even for simple VBA programmers like me that have no chance
(maybe via a VB6 ActiveX exe) to use multi-threading.
RBS
> Emerson, one posts to a forum like this to get help and other ideas,
Can we please stop this thread?
John Stanton wrote:
Emerson, one posts to a forum like this to get help and other ideas, not
to spark a debate. Many talented people gave you some of their time to
help you solve your problem and one in particular gave you a well
conceived and executed piece
Emerson, one posts to a forum like this to get help and other ideas, not
to spark a debate. Many talented people gave you some of their time to
help you solve your problem and one in particular gave you a well
conceived and executed piece of software free of charge. Appreciate
their charity.
John,
Um, alright then...
But i think your preaching to the converted, simplifying things is
what i always try to do. And not just when theres a problem
If you followed the thread fully you would realise that there was
never a problem with my design, though that didnt stop many people
Work on turning "reasonable" into "adequate" or "good" and it will help
you get an intuitive feel for the design of programs such as yours.
Then your programs will be simple, fast and robust, as Einstein
counselled - "Make it as simple a possible, but no simpler".
I also suggest that you take
John,
I have a reasonable understanding of the PC architecture, and more
appropriately the architecture which the operating system presents to
software. The PC may be a serial device, but a modern operating
system with its multitasking shcheduler attempts to emulate a non
serial environment.
If Emeroson intuitively understood the essential architecture of the PC
he is using he would not be having difficulty with his concept of how to
use it. It is essentially a serial device, multi-tasking device and
parallelism in the forms of threading and multi processing is a
sophistication
Hi Emerson,
I just hope you don't reinvent the wheel ;) I haven't yet had the need to
index things the way you describe it. May be I should take that as one of my
next pet projects to get a handle on this type of task.
The problem as I see it is basically, that any way you design this: If the
Emerson,
Now I understand your current implementation. You seemingly only partially
split up the work in your code. I'd schedule the database operation and not
wait on the outcome, but start on the next task. When the database finishes
and has retrieved its result, schedule some work package on
Hi Emerson,
Another remark: On Windows using Events synchronization objects involves
additional kernel context switches and thus slows you down more than
necessary. I'd suggest using a queue, which makes use of the InterlockedXXX
operations (I've implemented a number of those, including priority
Richard,
I believe his problem is this:
"Each query is allowed to complete before the other one starts, but each
thread may have multiple statements or result sets open."
The open resultsets/multiple started statements are causing him headaches.
Mike
-Ursprüngliche Nachricht-
Von:
I want to contribute my 0.02€ to this discussion. Basically I believe your
(Emerson) design is flawed. I've been working for years with multithreaded and
even multi-core systems. From my experience a design using threads for specific
tasks is *always* performing better, than having multiple
Hello Eduardo,
thank you for the hints given. Please can you tell me how to disable
journaling? In our project it is not important to have the database
persistent. We create the database, work with it, and destroy it within one
batch run. So we dont have to save it to disk ;-).
thank you so
> -Ursprüngliche Nachricht-
> Von: Eduardo Morras [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 1. Dezember 2006 19:44
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] for what reason :memory: is much slower than
> /dev/shm/dummy.db
>
>
> At 09:34 01/12/2006, you wrote:
> >Hi
> -Ursprüngliche Nachricht-
> Von: John Stanton [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 1. Dezember 2006 19:59
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] for what reason :memory: is much slower than
> /dev/shm/dummy.db
>
>
> Eduardo Morras wrote:
> > At 09:34
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 1. Dezember 2006 18:06
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] for what reason :memory: is much slower than
> /dev/shm/dummy.db
>
>
> John Stanton <[EMAIL PROTECTED]> wrote:
I would actually remove the default or use the process name instead.
Just my $0.02.
Mike
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 1. November 2006 01:28
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] SQLite and McAfee Anti-Virus
Why
uniqId is the same as rowid,
so you will get the same execution plans for ...where rowid=x and ... where
uniqId=x.
- Ursprüngliche Mail
Von: chetana bhargav <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Mittwoch, den 11. Oktober 2006, 09:19:28 Uhr
Betreff: [sqlite] PK and
Hi,
we have used sqlite3 with the Finisar.SQLite.NET wrapper in our applications
too. And there were same unreproduceable problems.
After switching to the Mono.Data.SqliteClient.dll wrapper all problem
disappears.
Try to use the Mono wapper, Finisar is buggy. :-(
Sylko
-Ursprüngliche
Trevor Talbot wrote:
Michael is referring to a direct map from disk pages to memory pages
(OS notion of pages, not sqlite's), using something like mmap() on
unix or MapViewOfFile() on Windows. This way memory is directly
backed by the file it refers to, instead of copying the data to
entirely
Michael is referring to a direct map from disk pages to memory pages
(OS notion of pages, not sqlite's), using something like mmap() on
unix or MapViewOfFile() on Windows. This way memory is directly
backed by the file it refers to, instead of copying the data to
entirely new pages (possibly
On Thu, 28 Sep 2006 15:45:54 +0200, you wrote:
Hi Michael
>-Ursprüngliche Nachricht-
>Von: Jay Sprenkle [mailto:[EMAIL PROTECTED]
>Gesendet: Donnerstag, 28. September 2006 15:37
>An: sqlite-users@sqlite.org
>Betreff: Re: [sqlite] Memory mapped db
>That's not really the same. I would
-Ursprüngliche Nachricht-
Von: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 28. September 2006 15:37
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Memory mapped db
>use the database named:memory:
>for a ram database. In a lot of cases it will be cached by
>the
-Ursprüngliche Nachricht-
Von: Martin Pfeifle [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 26. September 2006 13:35
An: sqlite-users@sqlite.org
Betreff: AW: AW: [sqlite] Performance question
>Hi Michael,
>could you please (re)post the exact create inex statements +primary k
I can't answer the question regarding SQLite for you, but Windows does start
auxiliary threads in some APIs.
-Ursprüngliche Nachricht-
Von: Dixon [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 27. September 2006 16:36
An: sqlite-users@sqlite.org
Betreff: [sqlite] auxiliary threads in
t; <sqlite-users@sqlite.org>
Gesendet: Dienstag, den 26. September 2006, 09:34:00 Uhr
Betreff: AW: [sqlite] Performance question
-Ursprüngliche Nachricht-
Von: Dennis Cote [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 22. September 2006 17:07
An: sqlite-users@sqlite.org
Betreff: Re
-Ursprüngliche Nachricht-
Von: Dennis Cote [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 22. September 2006 17:07
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Performance question
Michael Wohlwend wrote:
> But If I do "select data from pictures where (x between high_x and
>
Nevermind the issue. I've found my problem: I bound my string using character
length instead of byte length for UTF-16.
Problem solved.
Mike
>Hi,
>
>Yes I showed an example query. The query I used for sqlite3_prepare
>is the following:
>
>SELECT * FROM Objects WHERE ObjectID = ?
>
>If I'd put
Hi,
Yes I showed an example query. The query I used for sqlite3_prepare
is the following:
SELECT * FROM Objects WHERE ObjectID = ?
If I'd put quotes around the question mark, binding would have failed.
Interestingly I've even had some queries fail in the SQLite shell
yesterday. Others worked.
-Ursprüngliche Nachricht-
Von: Gerald Dachs [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 22. September 2006 11:28
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Performance question
>My sql knowledge may be a little bit rusty and I have really no idea how
sqlite is doing "between"
Hi everybody,
I am in the same situation, wondering if two or more processes can access
the database if one of them is in shared-cache mode, e.g. one process act as
in test_server.c serving multiple clients, another process reads/writes the
database through the ODBC driver of C. Werner.
Thanks
hi,
i got the same error when I ported sqlite to an operating system using a
proprietary file system.
The reason was that our file system did not support sparse files. i.e.
the fstat-command returned the wrong file-size.
Maybe you should independently of SQLite try to
* create a file,
* write
>From your description I would consider this a one-tier architecture.
Ussually the tiers are defined as follows:
- Presentation
GUI, all user interaction.
- Business Logic
Logic, which can not be expressed by constraints in the database.
Interaction with other (software) systems and some more
Brannon wrote:
It was just a warning.
Instructions for MSVC added to the README.
> Thanks for the info. Points 2, 4 and 5 are covered by the
> Makefile (DB.h is generated with javah), but I'll patch the
> project for the variable declarations and the cast. Though I
> have a feeling the cast is unncessesary, did VC throw an
> error or warning for that?
It was just a
Brannon King wrote:
To compile the binary with VC71, I had to
1. move a dozen variable declarations to the top of the function
2. download the DB.h file separately from the build tree
3. change the jstrlen to end with "return (int)(s - str) - suppChars"
4. change my sqlite3 lib build to #define
to #define SQLITE_ENABLE_COLUMN_METADATA
5. reference the sqlite3 lib in a dll project containing the DB.c/h
> -Original Message-
> From: David Crawshaw [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 31, 2006 2:03 AM
> To: Martin Pfeifle; sqlite-users@sqlite.org
> Subject: Re: AW: AW: [sqlite] N
Martin Pfeifle wrote:
could you please shortly outline the differences between your jdbc driver
and the one developed by Christian Werner?
I haven't looked too closely at the other driver, but from what I have
seen, it is designed to work with the old callback exec() functions,
so it supports
Sonntag, den 30. Juli 2006, 23:37:17 Uhr
Betreff: Re: AW: [sqlite] New JDBC driver for SQLite
Martin Pfeifle <[EMAIL PROTECTED]> wrote:
> Does the jdbc driver also provide the direct reading and writing of BLOBs?
Yes, through PreparedStatement.setBytes() and ResultSet.getBytes(). I
have
Martin Pfeifle <[EMAIL PROTECTED]> wrote:
Does the jdbc driver also provide the direct reading and writing of BLOBs?
Yes, through PreparedStatement.setBytes() and ResultSet.getBytes(). I
haven't added support yet for the java.sql.Blob type, because I am
funadmentally opposed to the idea of SQL
Does the jdbc driver also provide the direct reading and writing of BLOBs?
Best Matin
- Ursprüngliche Mail
Von: David Crawshaw <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Sonntag, den 30. Juli 2006, 14:56:18 Uhr
Betreff: [sqlite] New JDBC driver for SQLite
Hello all,
You can add Orb (www.orb.com) to the list.
Mike
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 14. Juli 2006 17:04
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Major projects using SQLite
If you're using VB.NET 2002, then look at the following classes:
System.Collections.ArrayList
System.Collections.SortedList
System.Collections.Hashtable
These are all dynamic container classes.
Mike
-Ursprüngliche Nachricht-
Von: John Newby [mailto:[EMAIL PROTECTED]
Gesendet:
If you're using VB6 your choices are VBs native Collection or the
Scripting.Dictionary class mentioned by Craig. Look them up in VBs online
help, there are examples on using them. I'd suggest get more familiar with
VB and its Container classes...
Mike
-Ursprüngliche Nachricht-
Von: John
VB always had dynamic containers. Starting with Arrays things such as ReDim
helped. Later Collection(s) (actually a Dictionary/Hashtable) were
introduced. In VB.NET you of course have all containers, which the .NET
framework supplies. In fact there are classes for Lists (ArrayList,
LinkedList and
Use a queue for the database operations in this case. You won't suffer from
lock or busy errors, if all access is serialized. Queues can scale very well
if done right.
Mike
-Ursprüngliche Nachricht-
Von: Gussimulator [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. Juli 2006 20:55
An:
1 - 100 of 171 matches
Mail list logo