Samuel R. Neff wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Friday, December 14, 2007 3:55 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] DeviceSQL
... is it not
directly comparable to DeviceSQL unless the external compiler handles
not only SQL
ld I create the column in DATETIME or the INTEGER to store the time.
DATETIME has the value of GMT time. So I store this value as INTEGER then I
need to convert datetime format but it will be use less space if I use the
INTEGER. Please give me an advice.
Thanks
Joanne
- Original Message ----
Fro
We did that with our products which used byte code. Byte code compiled
on earlier versions would run on later ones, but new code with the extra
opcodes would not run on old interpreters. It protected customers who
had lost their source code or were afraid to recompile after an upgrade
because
and
that such a product has the potential of being less memory hungry than
DeviceSQL simply by virtue of the higher information density of the VDBE
target code compared to native machine instructions.
Dennis Cote wrote:
John Stanton wrote:
DeviceSQL is not suitable for general purpose SQL
Testing only finds bugs, it does not guarantee accuracy. Careful design
however can establish accuracy, and to verify that methodology requires
examination of the source code.
James Steward wrote:
steveweick wrote:
Do you need to read the code to verify reliability as your next few
sentences
I unfortunately missed the Encirq webinar thanks to a project commitment
but have taken the time to download the Encirq demo and try to make good
the loss. It has some user examples in source code which give an idea
of how it functions, but the information on the product is sparse so it
was no
The type DATE is a declared type, not an actual type and has no effect u
nless your code specifically picks it out as a declared type.
To do what you want use a trigger on insert and update the date field
with datetime('now');
Joanne Pham wrote:
Hi All,
I create the table as :
create tab
[EMAIL PROTECTED] wrote:
Ion Silvestru <[EMAIL PROTECTED]> wrote:
SW: Richard, We have written to you directly before to ask you to stop the
FUD and incorrect statements, and you have chosen to continue. I suggest you
not waste everyone's time by circulating deliberately misleading
information.
Your application needs to handle the synchronization logic since there
is no DB server to do it for you. When you get a busy check you can
pause for a short time and relaunch the query.
Mark Riehl wrote:
I'm running SQLite 3.4.1 under Linux. I have a C++ application that
inserts records into
[EMAIL PROTECTED] wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
I received an email promoting a DeviceSQL web presentation. It
specifically targets Sqlite and promises 5X performance.
If you view their web presentation and/or try out Encirq's
products, I would be very interes
I received an email promoting a DeviceSQL web presentation. It
specifically targets Sqlite and promises 5X performance.
For those interested -
DeviceSQL vs. SQLite: Which Gets You the Most Efficient Embedded Database?
DATE: Thursday, December 13th, 2007
TIME: Noon PST
999
so the only solution till now seems to make a sub-query like: SELECT txt
FROM test WHERE txt=(SELECT max(CAST(txt AS REAL)) from test)
not sure how messy that might get in complex queries.
anyway for any suggestion I'm more than grateful
regards W.Braun
John Stanton wrote
Our approach to that problem was to write a library of ASCII decimal
arithmetic functions, store the data as underlying type TEXT but give
them a declared type of DECIMAL(n,m) and have added functions which
understand that declared type. With that addition Sqlite becomes useful
for accounting
P Kishor wrote:
On 12/7/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
P Kishor <[EMAIL PROTECTED]> wrote:
folks, I have never worked with BLOBs, but am now going to. Feel a
bit nervous.
Here is a question -- what if I have a rather large image and I want
only a certain part of it? Let me give
A faster disk will give you better performance. A 15,000 rpm disk will
give almost three times the performance of a 5,400 rpm one and retain
the ACID mode.
You could also queue your input and launch periodic Sqlite transactions
to empty the queue.
Mike Marshall wrote:
What platform are you
Ofir Neuman wrote:
Hi All,
I have some performance problem when adding ORDER BY to my query, hope you
can help me speed things up.
This is my table:
TABLE1
{
ID TEXT
ParentID TEXT
ModifiedDate INTEGER
}
ID is the PK of the table and i also have an index on ParentID.
Current number of re
Using the deprecated API get_table is very likely the problem.
Jonathan Hendler wrote:
Hi All,
I'm writing a C application which runs inside of FastCGI process.
The problem is that I am getting poor performance... roughly 1000
SELECTs in 20 seconds.
It's not an indexing issue (I promise). This
Sqlite uses an epoch based date like the Unix timestamp, but realised in
a 64 bit floating point number. It has a set of inbuilt functions to
process these timestamps. See date.c for full details.
Using the FP format of the date and time will work well in your application.
You can add date f
If you do not use TCL compile Sqlite without it. Use option
--without-tcl. Use configure --help to get an idea of compile options.
Sreedhar.a wrote:
Hi,
I am trying to compile the latest version of the sqlite 3.5.3 in vc++.
i got the following error.
Can anyone help me, what i am missing
will eventually synchronize the writers?
John Stanton-3 wrote:
Multiple writers merely have to be synchronized.
arbalest06 wrote:
so there is really no way that multiple processes can write into the
database?..but multiple processes can read at the same time right?..
Igor Tandetnik wrote
nal Message
From: John Stanton <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, November 28, 2007 12:04:34 PM
Subject: Re: [sqlite] SQLITE_BUSY retry
You could use a BEGIN IMMEDIATE to lock the DB before you launch the
transaction and loop on SQLITE_BUSY or use the pl
ables with
many millions of entries.
We have achieved speed improvements on the scale of orders of magnitude
by using such techniques on text and taking advantage of a high
performance search algorithm.
Spiros Ioannou wrote:
John Stanton wrote:
Sqlite does cater for text searching. Look a
You could use a BEGIN IMMEDIATE to lock the DB before you launch the
transaction and loop on SQLITE_BUSY or use the plain BEGIN which will
allow reads during the transaction and not lock the DB until you issue a
COMMIT (the END). Just loop on the BUSY on the END SQL statement until
the user wh
Trevor Talbot wrote:
On 11/27/07, Spiros Ioannou <[EMAIL PROTECTED]> wrote:
I had a 135MB, 1256132 lines, '@' separated text file containing
various words and text fields (like a dictionary).
Example record:
[EMAIL PROTECTED]@[EMAIL PROTECTED],[EMAIL PROTECTED] altana : μικρός ανθόκηπος
- εξώ
Multiple writers merely have to be synchronized.
arbalest06 wrote:
so there is really no way that multiple processes can write into the
database?..but multiple processes can read at the same time right?..
Igor Tandetnik wrote:
arbalest06 <[EMAIL PROTECTED]> wrote:
q#1: is it possible that mu
You will always get much faster searching using a flat file and a
grep-like search. For the search you quote you can do better than egrep
with an integrated search algorithm like Boyer-Moore.
This is no reflection on Sqlite, it is not intended to be a replacement
for grep.
Spiros Ioannou wr
It is pretty, runs well and is easy to use. Better than "decent".
P Kishor wrote:
To all those looking for a decent, cross-platform SQLite gui, check out
SQLite Manager Firefox add-on
https://addons.mozilla.org/en-US/firefox/addon/5817
I have just started experimenting with it, and it reall
but i really cant make it work..and i also cant find some C
sample source code using these apis..if it is possible, can someone post
some c code using these apis?..
thank you and more power!
God bless!..
John Stanton-3 wrote:
All you need to do is to test the returned status of your
Cache your open connections. Keep your list in most recently used order
and use the most recently used to maximize cache availability.
Sabyasachi Ruj wrote:
I have an application that uses SQLite extensively.
In a part of that application, I need to do the following steps:-
1. I need t
essentially contiguous.
Joe Wilson wrote:
--- John Stanton <[EMAIL PROTECTED]> wrote:
Malloc is a concept implemented in various ways, some more successful
than others but all of them hidden from the programmer. Free tries to
give back memory but as you can appreciate unless you use some g
James Dennett wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 12:14 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Memory Usage
Dynamic allocation is not the problem, it is malloc and free. there
is
a difference between
D. Richard Hipp wrote:
On Nov 19, 2007, at 12:36 PM, James Dennett wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 7:36 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Memory Usage
Not only applicable to real time systems
Dynamic memory allocation is not the problem, it it memory fragmentation
and checkerboarding produced by "free". Avoid the fragmentation and you
can run forever.
James Dennett wrote:
-Original Message-----
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19,
Dynamic allocation is not the problem, it is malloc and free. there is
a difference between being certain and being lucky.
James Dennett wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 7:36 AM
To: sqlite-users@sqlite.org
Subject
Not only applicable to real time systems. If you want a program to run
with stability over a long time the first step it to eliminate frees and
if malloc is used confine it to the intialization.
Jim Dodgen wrote:
One other note, just about all real-time systems limit the dynamic
allocation of
I use gcc for compiling Sqlite for both Windows and Linux and others.
On Windoze I use Dev-Cpp as and IDE over the top of Mingw. You might
look at the compiler options and ensure that you are just specifying
plain vanilla ANSI C.
A.J.Millan wrote:
John:
Thanks for your feedback, but the que
FredAt wrote:
Samuel R. Neff wrote:
You could maintain a queue in memory of all the data to be written, have
each page view queue up the new data and have a single db writer thread
that
dequeues items and writes to the db. That way you get the benefit of
writing directly to the db, but do no
I use static libraries and gcc. Just use --enable-static and you should
get the link library created.
A.J.Millan wrote:
Hi all:
Instead the supplied DLL, I would like to statically link the SQLite
library in a new project, and I wonder if someone has build a SQLite
static library xxx.a usin
I use Sqlite to log activity in our web server. We perform the logging
asynchronously by queueing the log data and having an async process
insert it into the database so that the web connection does not block
pending completion of the insertion.
FredAt wrote:
Hello All,
I have used SQLite o
The latest sqlite page renders nicely on a wide screen and loads in
860mS on my machine and transfers a total of 16KB. It looks clean,
terse, uncluttered and business-like and free of trivia. Just the
presentation I relish when searching for information. Direct and to the
point.
Several su
James Dennett wrote:
Dennis Cote wrote:
Dr Gerard Hammond wrote:
The first few words sound incorrect to me.
Shouldn't it be.
"SQLite is an in-process"
and even then I don't know what 'in-process' actually means.
I agree with this completely.
I can't say I have ever heard the term in-
Steven Fisher wrote:
On 14-Nov-2007, at 3:37 PM, John Stanton wrote:
I am looking at it on a wide screen and it does not render to the full
screen width. I would guess that making the toolbar an image would
stop the wrapping. The image would scale to 100%.
I used to think it was a good
wildebeest method gets the herd across faster than you could get your
fast running cats across the road. However the cats cannot handle the
wildebeest method and the wildebeest would be road kill if they tried
the cat approach.
Trevor Talbot wrote:
On 11/14/07, John Stanton <[EMAIL PROTEC
[EMAIL PROTECTED] wrote:
"Scott Hess" <[EMAIL PROTECTED]> wrote:
I probably am misunderstanding something. The box scales down to
narrower windows just fine, so why can't the box scale until it hits
the width of my browser, and _then_ start doing the vertical-wrapping
thing?
There is a CSS p
just fine, so why can't the box scale until it hits
the width of my browser, and _then_ start doing the vertical-wrapping
thing?
-scott
On Nov 14, 2007 10:59 AM, John Stanton <[EMAIL PROTECTED]> wrote:
There seems to be no simple solution to that problem of fonts not
scaling precise
Grzegorz Makarewicz wrote:
Michael Scharf wrote:
* Somebody please suggest a better tag line - something
better than "The World's Most Widely
Used SQL Database".
I really like this tag line! However, it would be great if
there would be a link with some information that supports/exp
Andreas Volz wrote:
Am Tue, 13 Nov 2007 15:15:49 -0600 schrieb John Stanton:
You might find the method used by Squid to manage its cache would be
worth emulating.
I don't know how squid works. Could you explain it in simple steps?
I haven't looked at the code, but it builds
ed to know the recommended
policy in that case. At present, since SQLite is a single file, there can be no
parallel I/O within a single DB - right?
John Stanton <[EMAIL PROTECTED]> wrote: Do you have parallel I/O or are you
using Windows or Unix?
Uma Krishnan wrote:
How about when you n
I would not agree with that. Parallelism is very much architectural if
it to be better than yet another layer of software loading down what is
a non-parallel architecture.
It will be some time before the technology filters down to the mass users.
Joe Wilson wrote:
--- John Stanton <[EM
There seems to be no simple solution to that problem of fonts not
scaling precisely other than to use images for the captions. If someone
has one, let us know.
Scott Hess wrote:
I notice that in Firefox on Linux with a maximized window on a
1600x1200 screen, the "Support" link in the navbar w
SQLite kernel?
Thanks in advance
- Uma
John Stanton <[EMAIL PROTECTED]> wrote: One of the ignored points about thread usage is just how expensive are
the synchronization mechanisms. It is a good idea to apply Occam's
Razor to your design and eliminate unnecessary features and hav
Threads simulated in software are a kludge to better utilize current
processor and operating system architectures. In time machines where
the parallelism is handled in hardware will be more widely available and
the threading will be transparent and highly efficient.
Joe Wilson wrote:
Threads
One of the ignored points about thread usage is just how expensive are
the synchronization mechanisms. It is a good idea to apply Occam's
Razor to your design and eliminate unnecessary features and have a
result which provides a better level of functionality and a structure
which is much simpl
I have only glanced at the problem so I may have missed something but my
approach to a large matrix would be to realise it is a flat file and
mmap it. Your program would then treat it as a memory resident
structure. The VM features of the OS would perform paging as necessary
to keep a working
All you need to do is to test the returned status of your sqlite3_step
calls and if you get an error launch an SQL statement "ROLLBACK" and
bail out of the transaction. If there are no errors you complete your
transaction with an SQL "COMMIT".
sqlite_prepare_v2 SQL statements
exec BEGI
.
Andreas Volz wrote:
Am Tue, 13 Nov 2007 07:18:19 -0600 schrieb John Stanton:
In a cache situation I would expect that keeping the binary data in
files would be preferable because you can use far more efficient
mechanisms for loading them into your cache and in particular in
transmitting them
;.
Is that type of thing you want to know? Sorry for any misunderstanding.
b
On Nov 13, 2007 9:26 AM, John Stanton <[EMAIL PROTECTED]> wrote:
How are you using transactions?
Benilton Carvalho wrote:
Hi Everyone,
I use R to create tools for analysis of microarrays
(http://www.biocond
How are you using transactions?
Benilton Carvalho wrote:
Hi Everyone,
I use R to create tools for analysis of microarrays
(http://www.bioconductor.org).
I'm in a situation where I need to handle 6 matrices with 1M rows and
about 2K columns, ie each matrix takes roughly 15GB RAM.
The procedure
In a cache situation I would expect that keeping the binary data in
files would be preferable because you can use far more efficient
mechanisms for loading them into your cache and in particular in
transmitting them downstream. Your DB only needs to store a pathname.
Just be wary of directory
Extend that to Chardonnay and Brie and you will be in business.
Fred Williams wrote:
Great idea! Why don't we give them little printable chits for free
chips and beer as well?!
Just the facts m'am. -- Jack Webb
-Original Message-----
From: John Stanton [mailto:[EMAIL PROTE
James Dennett wrote:
Joe Wilson wrote:
--- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
I hope this doesn't offend, but perhaps the best solution is to
outsource
the website to someone or a company that specializes in websites and
design
(with your stated simplicity goals in mind of course)
ing website (that works
in most browsers) is enough to reassure them that the code base is not
junk.
"Hey boss - we want to use SQLite."
"Sure what can you tell me about it?"
"If you just install firefox, I'll show you their website."
RW
Ron Wilson, Senior En
Joe Wilson wrote:
(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners
In Firefox 2.0.0.8, press "CTRL +" a couple of times to see the render
problem. If I press "CTRL -" it renders properly.
On larger screen resoltions, sometimes the default fonts are a bit bigger
than usu
[EMAIL PROTECTED] wrote:
bash <[EMAIL PROTECTED]> wrote:
On 09/11/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
This is indeed a sad commentary on the state of the
world wide web that it is now necessary to specify
a font on every web page Oh well.
What's about CSS? It should h
[EMAIL PROTECTED] wrote:
Joe Wilson <[EMAIL PROTECTED]> wrote:
The font change to
font-family: "Verdana" "sans-serif";
makes a huge difference - much more professional looking.
This is indeed a sad commentary on the state of the
world wide web that it is now necessary to specify
a font on
Did you run your test using ReadFile?
Brandon, Nicholas (UK) wrote:
I just tried (hadn't noticed that option before) to go from
2000 to 4000 and 8000, without noticing any difference. I
might try next week to raise the page size to 50k and see if
it makes a difference?
On the presumpt
[EMAIL PROTECTED] wrote:
Thanks, everybody, for the excellent feedback and suggestions
for revising the SQLite website. Please keep the comments
coming.
Regarding the basic "look" of the site, we were considering
using a style similar to the once found at ActiveState
http://www.activestate.
Renaud HUILLET wrote:
Thanks for your reply,
Indeed, the windows API is not the same at the Unix one (mmap), but I think I
have a wrapper somewhere that can handle both.
Anyone has been trying the mmap for SQLite ?
Renaud
Date: Thu, 8 Nov 2007 10:15:24 -0500
From: [EMAIL PROTECTED]
To: sql
Michael Scharf wrote:
[EMAIL PROTECTED] wrote:
"Trevor Talbot" <[EMAIL PROTECTED]> wrote:
Beyond that, I'm not aware of anything that would help.
All good advice. But you left off the obvious: Get a
faster disk drive. ;-)
...which does not really help unless you buy a very expensive
fla
Rich Shepard wrote:
On Thu, 8 Nov 2007, Stephan Beal wrote:
google code award implies that it's free (doesn't it?)
Only to people not used to open source. "Release early, release often."
Definitely not. Its simplicity is its main beauty.
Stephan,
Good comments from your point of v
A transaction state is dependent upon the lock state, and the lock is at
database level because the database is the resource being shared by user
initiated connections. Locks are held by individual connections and
those connections can be at process or thread level.
The Sqlite locks are proce
John Firebaugh wrote:
No. You are still required to synchronize access, so only one thread
uses the connection at any given time. If you don't, it will
likely lead to database corruption.
I belive you are mistaken.
This refers to low level synchronization, not the application level
synchro
This is good advice from Sam, but there is another question. Why do you
need a server and how do you intend to interface to it? Why does the
server need to support Sqlite?
Samuel R. Neff wrote:
uSQLiteServer provides it's own network protocol implementation and it's own
API so using is nothi
Sqlite3 is supported by PHP using PDO.
Valerio Bontempi wrote:
Hi Kees,
thanks for your solution, it is a very interesting solution.
But I need to rename a table using sql from php.
(this is also the reason for my need of sqlite and not sqlite3, not
supported yet by php)
Thanks a lot
Valerio
uding :)
Best regards
Daniel
John Stanton wrote:
Our business for many years was producing compilers and database
software to transport legacy software onto new platforms. We saw
literally thousands of custom application software implementations and
got to see the good, the bad and the ugly.
ture, like adding or
subtracting time intervals, those solutions can and should be implemented
in the server software, not the server database. In my solution, the
database is the repository of data, not logic.
Lee Crain
-Original Message-----
From: John Stanton [mai
Crain
___
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 12:18 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
That approach makes date processing clumsy. Distributing dates across
time zones and
Lee Crain wrote:
Several years ago when I worked for a Fortune 70 company, we had a server
whose source code and database were complicated by timestamps. I say
complicated because there were different timestamp datatypes used for
different fields (inherited from the data sources), the data could
To my mind "virtual" means something different. "Foreign" would be a
more intuitive name.
Samuel R. Neff wrote:
I like the term virtual 'cause that's exactly what they are.. a table that
does not really exist in the db and is provided by some other system. This
is not inconsistent with other
T&B wrote:
Hi John,
How can I convert dates from the format d/m/yy to SQL style YYY-MM- DD?
The data is from a bank, so I have no control over its production.
I couldn't find any suitable built in SQLite functions, which all
seem to operate in the other direction.
If you transform
T&B wrote:
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I have some imported data that includes a date column in the format d/
m/yy, where:
d = day as 1 or two digits
m = month as 1 or two digits
yy = year as two digits
eg:
2/11/07 = today
2/8/68 = 2nd
would do well not to use the deprecated
sqlite3_exec API call.
Bill Gatliff wrote:
John Stanton wrote:
Perhaps your application sjould post its signal after the COMMIT has
executed. A pause to give time for the COMMIT is a fragile approach.
It is indeed! And just for the record, it'
To make virtual tables compatible with shared cache would be a
convenience for us, and not in the least inconvenient.
D. Richard Hipp wrote:
The current virtual-table implementation does not work when you have
shared cache mode enabled. We would like to fix this so that that you can
(for exam
Bill Gatliff wrote:
Guys:
I'm a relatively-new SQLite user, but I'm luuuvin' it! :)
My application is a mobile platform with a GUI that wants to display
frequently-updated data in a database. The GUI is a separate process
from the one providing the data, and is one of several consumers of
[EMAIL PROTECTED] wrote:
Joe Wilson <[EMAIL PROTECTED]> wrote:
The only real way to prevent allocation fragmentation is to move
blocks of memory around -
Not true. You can prevent fragmentation, for example, by
not allocating objects beside each other that will be destroyed
at different times
I would endorse the use of an initialization functions as being clean
and efficient and one of the simplest and most logical of optimizations,
eliminating common expressions.
Since your typical application program has an initialization phase it is
trivial to add the new API function to legacy
As has been carefully explained by several people, it is reliable. You
just did not think through your application. You could make an
extension to Sqlite and implement an sqlite3_last_insert_or_ignore_id
function, but to blithely assume that you can use last_insert_id with
INSERT OR IGNORE is
#x27;t take too long. Any test I should do to check
if I have a HD problem? I used a software from DELL to search for
hardware problems and didn't find anything.
Thanks!
On 26 Oct 2007 at 12:01, John Stanton wrote:
Your experiment gives you the answer to your question. You are r
An obvious improvement is to use 15,000 RPM disks.
Fabio Durieux Lopes wrote:
No, it is definitely local.
Does anyone know if theres any kind of hardware/os spec that may
influence sqlite performance?
On 26 Oct 2007 at 16:53, Renaud HUILLET wrote:
My 2 cents:
Could it be that on
Your experiment gives you the answer to your question. You are running
the same software and therefore you are measuring the differences in the
disk and disk controller function between the two platforms. Sqlite's
ACID capability is very much dependent upon the disk hardware.
Fabio Durieux L
I am sure that you are correct, that Sqlite's sync mechanism is not
terribly complicated for you and for anyone else who understands the
principles, however it does confuse many users as you see from the
posts to this forum. Simple to use could become simpler to use.
Synchronizing transactio
You make a sound point. From my perspective the Sqlite synchronization
mechanisms are a flawed part of an otherwise elegantly simple design, as
reading this forum indicates. Synchronization problems are the major
item of confusion among users. A more robust and less intricate
interface would
A classic solution to that problem is not to perform updates but to
insert transactions, The concept of log file systems to give
concurrency is worth scrutiny.
Richard Klein wrote:
As I was thinking about the locking mechanism in SQLite 3,
it occurred to me that the following race condition c
A project for you. Pick up the documentation, transform it to PDF and
make it an Sqlite contribution on sqlite.org.
Olaf Beckman Lapré wrote:
Hi,
I second this request. I've been wondering for a long time why the
documentation isn't available off-line. How about making the
documentation ava
n (printIfInsert()) in
the trigger statement..
please help me on this..
thank you and God bless!.. c",)
John Stanton-3 wrote:
I that case you need to implenment a custom function and launch it from
a trigger.
d_maniger06 wrote:
im sorry but i havent get your point..im rather ne
Andrew Wiley wrote:
I've been using SQLite on several minor projects now (it makes File IO so
easy), and the one suggestion I would make would be to make the
documentation (api reference) downloadable.
It would be very handy for myself and probably many others to be able to
download the API refer
Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
I should be able to use your test suite
s/your/the/
Sqlite and its test suite are drh's work.
Hmm ... Somehow I got the impression that
printed out in the console saying that
my table in my database has been updated/inserted..
John Stanton-3 wrote:
d_maniger06 wrote:
good day!..
i would just like to ask if you can set a trigger to call on a
non-database
event (e.g. writing to a file) whenever an update/insert has been made
d_maniger06 wrote:
good day!..
i would just like to ask if you can set a trigger to call on a non-database
event (e.g. writing to a file) whenever an update/insert has been made to
the database..im using c programming language for this..if this is possible,
can u give me some links or direct exa
Download the source from www.sqlite.org. Untar it into a directory
sqlite and follow the instructions.
Joanne Pham wrote:
Hi All, I already had SQLite3 version 3.3.14 on my Linux box and I want to replace this version with the new version SQLite3 3.5.1and I don't know what are the steps to a
301 - 400 of 1329 matches
Mail list logo