Travor, absolutely correct. my apology for misleading everyone.
Trevor Talbot wrote:
You're confused about the locking; see http://sqlite.org/lockingv3.html
On 8/26/07, John Stanton <[EMAIL PROTECTED]> wrote:
How about the case of:
BEGINsets reserved lock on thread on
Igor Tandetnik wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
More correctly:
BEGIN Thread one
BEGIN Thread two
INSERT Thread one sets reserved lock
INSERT Thread two, fails to set reserved lock
SELECT Thread two, set share
If you use the Sqlite floating point number format (function julianday
will do the conversion) you can use functions to compare days and dates.
Andre du Plessis wrote:
I have a UTC date stored in text column in this format:
2007-08-27 08:58:16.601000
I want to do some selects for all
ext successfully, not sure how it's able to do that, but
impressive,
Is there anyway to round off the datestamp to the beginning of the day,
or maybe do you know if there is a list of built-in date functions
somewhere?
Thanks.
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Markus Hoenicka wrote:
Quoting Uma Krishnan <[EMAIL PROTECTED]>:
Hello Markus,
How is libdbi different from, say odbc?
I've never used ODBC, but from what I read I'd say the main differences
are the footprint and the scope. libdbi is language-specific (C),
lightweight, and allows you to
Show us your program.
RaghavendraK 70574 wrote:
Thx. I have modifed it to ?, but
Sqlite fails to get records for the below query. When debug it retuns
SQLITE_DONE. Pls help.
select * from 'tbl.7' where ? like column1 || '%' order by column1 desc limit 1;
Data is as below:
Version: 3.4.0
Re-c
You could experiment with making your 128 bit entity a BLOB. The
alternative would be to represent it it in ASCII. Changing its radix
would probably be the significant overhead, not the Sqlite storage.
Prakash Reddy Bande wrote:
Hi,
I am designing a database where-in my column data is UUID.
What is a "best match" anyway? A fuzzy search? The LIKE operator gives
an exact match to a substring.
Simon Davies wrote:
ragha,
you want something to give you a 'best match'. The 'like' operator in
the way you are using it does not do that, but it IS working as it
should.
I am not sure how
Why do you have a unique primary key as an integer to hold your other
unique integer? Why not just use the unique integer as a primary key?
If you want to have a limit on the maximum unique ID you can store your
next to allocate and next to replace keys in another table.
B V, Phanisekhar wro
nishit sharma wrote:
i have given some text in a database file as
America|england| and many more.
now i want to replace some text with new text how
this is possible. Also my database has around 15 rows now
which will be incremented.
so, plz anyone tell me how to replace a text in a row and
how
I just need the answer for my original question.
Regards,
Phanisekhar
Maybe you "need" an answer, but others do not "need" to give it to you.
If you want others to do your thinking and reading for you, don't
demand, ask politely.
.
Thanks
John Stanton wrote:
That is an interesting way to store money. We developed a fixed point
arithmetic library of arbitrary precision using the algorithms described
by Knuth in his semi-numerical algorithms volume and using standard
DECIMAL(n,m) definition. Rounding is precise using an
nishit sharma wrote:
hi all,
i have made a sampe which is opening a database file but i m
unable to compile that source code and getting error that
undefined reference to sqlite3_open().
i m compiling as
gcc test.c
can anybody tell that these is the command to compile
sqlite3 application or we h
nd other things
to my database without using these argc and argv.
waiting for the reply
regards
Nishit
On 8/31/07, John Stanton <[EMAIL PROTECTED]> wrote:
nishit sharma wrote:
hi all,
i have made a sampe which is opening a database file but i m
unable to compile that source code and gett
Use SQL. You could use a script like Perl or TCL.
RaghavendraK 70574 wrote:
Hi,
If i have 2 sqlite files is there a way to merge
the files without corruption? assuming the schema
of both the files are same.
I don't want to use sql statements rather want to do
using file api's.
Similar to di
Sharing cache is a great feature and thankyou for shedding the sweat
necessary to implement it. I do have a suggestion for V3.5. How about
changing the name to Sqnotsolite?
D. Richard Hipp wrote:
On Sep 2, 2007, at 11:40 AM, Joe Wilson wrote:
In sqlite 3.5 they've changed the design to s
Use sqlite3_step to read each row in sequence.
Babu, Lokesh wrote:
Dear all,
After doing some SELECT operation on a TABLE, say we get 100 result
items out of 1000 records, Is there any way where I can iterate
through this result set. i.e., Get N items out of 100, say get
previous 10, get next 1
These are regular floating point numbers, and behave accordingly.
Serena Lien wrote:
I have read some of the postings/faq about the difficulties with the round
function, when certain numbers do not have a finite representation in
binary, which SQLite uses. eg 9.95 is actually 9.9499...etc so tha
John Machin wrote:
On 5/09/2007 6:18 AM, John Stanton wrote:
These are regular floating point numbers, and behave accordingly.
Utter nonsense. round(98926650.5, 1) -> 98926650.501 is a BUG.
Precisely, As I said, regular floating point.
98926650.5 is representable EXACTLY
John Machin wrote:
On 5/09/2007 10:13 AM, John Stanton wrote:
John Machin wrote:
On 5/09/2007 6:18 AM, John Stanton wrote:
These are regular floating point numbers, and behave accordingly.
Utter nonsense. round(98926650.5, 1) -> 98926650.501 is a BUG.
Precisely, As I s
Look up the Sqlite API. The sqlite3_column_text call does what you want.
sqlite3_open
sqlite3_prepare
loop
sqlite3_step
if SQLITE_ROW sqlite_column_text;
if SQLITE_DONE sqlite3_finalize; exit
repeat
sqlite3_close
Add your own error tests.
Severin Müller wrote:
Look in the Sqlite source for examples. Your function gets the
arguments you specify in the SQL and then your program does whatever you
like with them and returns a result. It could for example perform a
regular expression compare etc.
You register the function with Sqlite when you open a co
Zbigniew Baniewski wrote:
An interesting method is "progress":
"The progress callback can be used to display the status of a lengthy query
or to process GUI events during a lengthy query."
But I'm not quite sure presently, how it could look like in practice? To make
a "progress bar" I've g
[EMAIL PROTECTED] wrote:
"Paul Harris" <[EMAIL PROTECTED]> wrote:
A thought along the same lines, can sqlite create a unique index that
is hash-based? this would provide the UNIQUE support, but it wouldn't
provide a sorted index.
That should resolve the massive-insert-too-slow problem, and
a
Gary G Allen wrote:
Hello Everyone in SQLite land.
I am totally new to the sites and sounds here.
I have a issue. I hope you can help me with.
I downloaded source code from:
http://www.sqlite.org/download.html
sqlite-3_4_2.zip
(179.14 KB)
Ran the makefile and everything worked fine.
I ha
100% CPU is optimal. The less than 100% numbers indicate that the
performance is limited by waits on disk access. When all the data is in
memory disk access would cease and no longer be a bottleneck.
RaghavendraK 70574 wrote:
Why is the CPU shot up by 100% (relative)when the full db is in me
nadiap wrote:
Hello,
i am a newbie and i would like to ask if it is possible to use sqlite in
order to simulate a wireless network where each node will have each own
database. I mean, can i attach each node to a database? What shall i do? I
am sorry if my question seems naive, but i am just lear
Sqlite is your friend. It will automatically create the DB if it does
not exist.
Gary G Allen wrote:
Thanks for the help thus far. The nice people on the list have provided
me with solutions to my issues I have run into so far.
We are considering using SQLite for a backend db on our device. I
The underlying issue with thread misbehaviour is that POSIX file locks
are process specific, not thread specific requiring some tormented logic
. You only need the POSIX locks if you have multiple access to the same
database and are writing to the database.
If you have a multi-threaded applic
I think that his project is to use simulation software to build a model
of a network in software using a simulation package like NS2. It models
the network by implementing algorithms, not by setting up hardware.
Vitali Lovich wrote:
I think you need to clarify your needs a bit, cause it seems
correctly controlling access to this connection with our own mutexes.
Is that right?
Thanks,
Mark
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 19, 2007 6:54 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Moving database connections across
First make sure that you store the date in Julian format by using the
julianday function. Then you should be able to get the day of the week
by take modulo 7 of the julian date. You can use the strftime function
to do that -
**strftime( FORMAT, TIMESTRING, MOD, MOD, ...)
**
** Return a s
You might do better to structure your program like this:
get a file of data records
prepare SQL statement using sqlite3_prepare
execute SQL BEGIN
loop
read a data record
until EOF
bind data to SQL statement using sqlite3_bind functions
execute SQL using sqlite3_st
You can read and write to the database concurrently provided that your
program can handle SQLITE_BUSY events.
Sreedhar.a wrote:
Hi Everyone,
I am implementing server database using sqlite.
I will be having the multiple clients browsing the database.
At the same time the database can also b
LLeave the connectionj open.
Runnerpizza Net wrote:
Hello,
I am pretty new to SQLite and I have to clear these question before
I begin to move and port a big program from using a "bigger" database to my
favourite SQLite:
When the program run, there are continuesly queries, inserts and updates
Finishing the COMMIT releases the file locks.
Rich Rattanni wrote:
I hope it isnt too wierd to reply to your own posts I just wanted
to follow up with I found the following post: "[SQLITE] thread
concurrency, inserts using transactions, bug?" The problem is multiple
begins causing deadlock,
The BEGIN IMMEDIATE only locks the source database so that its contents
will not change while the copy is in progress. The fact that the other
databases are read-only means that they do not need to be locked against
changes, but they do need have some form of synchronization so that
existing re
Those commands are specific to the sqlite3 command line tool program.
Run sqlite3 from a command line to get them.
José Antonio Gonçalves Motta wrote:
I'm accessing SQLite through a JDBC driver in a java program, but I
get an error everytime I use SQLite line command (like ".output"). Is
it be
An index which does not hold keys is not an index. If you don't want to
allocate space for indexing then you put up with slow performance and
use row searches.
[EMAIL PROTECTED] wrote:
I created an index on a TEXT column as I want to be able to
I noticed a large increase in the file size.
L
How do you know that when your process forks that you are looking at the
child, not the parent?
Sabyasachi Ruj wrote:
Hi,
I am writing an application which will continue to execute as a 'daemon' in
Linux.
The application is multi threaded.
And once the daemon is created, it will create few thr
When using multiple threads you must use synchronization. Apart from
the usual thread safety issues you need to sync access to Sqlite. You
can use the Sqlite BUSY feature for that or use thread primitives.
Jiri Hajek wrote:
Hello, I was glad to read in http://sqlite.org/34to35.html document
PARENT PROCESS).
Thanks for your repply.
On 10/4/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
Just read this today, after doing some other research. Does this help
any?
http://www.sqlite.org/faq.html#q6
It says, in a nutshell, don't use a database across forks.
On 10/3/07, J
Try using the correct delimiter for SQL literals, ', not ".
Marco Bambini wrote:
I need to create a trigger that BEFORE a row is deleted from a table,
the sql used to create that row (or a way to recreate it) should be
saved to another backup table.
For example:
CREATE TRIGGER trigger_delet
[EMAIL PROTECTED] wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
When using multiple threads you must use synchronization. Apart from
the usual thread safety issues you need to sync access to Sqlite. You
can use the Sqlite BUSY feature for that or use thread primitives.
Beginnin
?
On 10/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
When multi-processor machines are used thread usage may indeed implement
parallel processing when used appropriately and have tangible benefits.
True enough, in general. But wit
can have parallel
access, but they are heavy, not lite.
[EMAIL PROTECTED] wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
When multi-processor machines are used thread usage may indeed implement
parallel processing when used appropriately and have tangible benefits.
True enough, in g
an index in memory?
Clive
John Stanton <[EMAIL PROTECTED]> on 03/10/2007 17:36:58
Please respond to sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
cc:(bcc: clive/Emultek)
Subject: Re: [sqlite] Index size in file
An index which does not hold keys is not an index. If you
Trevor Talbot wrote:
On 10/4/07, John Stanton <[EMAIL PROTECTED]> wrote:
A B-Tree index holds keys in sorted sequence. They are in random
sequence in the database. That requires holding the keys in the B-Tree
nodes.
Actually, it doesn't strictly require that; it could store re
Kees Nuyt wrote:
On Wed, 3 Oct 2007 15:39:06 +0200, you wrote:
I created an index on a TEXT column as I want to be able to
I noticed a large increase in the file size.
Looking at the binary of the file, I see that the index has a copy of all the
data being indexed.
1. Is this necassary?
2. I
A brute force method would be to store the rowid of the owner row in
each of the detail rows.
chetana bhargav wrote:
Is this a garbage collection situation, where you want a row in B to go away when all referring rows in A are deleted?
Yes exactly this is what I wanted :)
Sorry for the conf
Lee Crain wrote:
Igor,
I have a question.
Why is it "highly recommended" to use the function call sequence you
iterate in preference to the sqlite3_exe call, since it is implemented
using that sequence?
Lee Crain
The callback method did not turn out to be such a good idea in practice
and w
Does anyone know how to do a database dump from the C API? I'm linking
to sqlite3.o (the amalgamated file) and was hoping to open a database
and dump the contents to an sql file.
I know this can be done from the shell, but as of yet, I can't get the
shell running on AIX.
What version of AIX
[EMAIL PROTECTED] wrote:
Hello,
I got an error when I try to read some data outside the while{}, inside
the while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with values "one", "two",
"three".
#include
#include
int main(void)
{
sqlite3 *db;
sqlite3_stmt *pSta
Ken wrote:
Is there a way for SQLITE to automatically load user defined functions at database instantiation or upon database connection?
Can it test for a .so/.dll and perform a call to load user functions? If the .dll does not exist maybe issue a warning?
Just a thought as a way to al
varunkumar wrote:
i am using sqlite3 database in our project
in my project one daemon process running , in this daemon process i am
opening the data base and inserts the data
in to sqlite3database using sqlite3_exec() API . for every one
minute i am opening the database and inserts th
d be a really nice feature and could be used to promote user contributions for library development for sqlite.
For example math function library, or string function library, even the VFS i/o routines could be loaded in this manner.
Ken
John Stanton <[EMAIL PROTECTED]> wrote: Ken
There is a good case to have an Sqlite API call to take a snapshot of a
database. It would integrate with the locking logic and secure an
exclusive lock before taking the snapshot. That is a safer and handier
approach than extracting a file descriptor and perhaps creating mayhem.
Cyrus Durgi
Brian Rowlands (Greymouth High School) wrote:
Hi
I'm absolutely new to sqlite which I'm using with a perl project. I did
a test script:
use strict;
use DBI;
my $dbfile = 'H:\trythis.s3db';
my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","",{RaiseError =>
1});
my $sql = "SELECT name FROM
[EMAIL PROTECTED] wrote:
John Stanton a écrit :
[EMAIL PROTECTED] wrote:
Hello,
I got an error when I try to read some data outside the while{},
inside the while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with values "one",
&q
[EMAIL PROTECTED] wrote:
Igor Tandetnik a écrit :
[EMAIL PROTECTED] wrote:
while(sqlite3_step(pStat) != SQLITE_DONE)
{
switch (sqlite3_step(pStat)) {
You call sqlite3_step twice on every iteration, which means you are
only looking at every other row. That's probably not what you w
nventing the wheel...
So is it fair to say that the sqlite3_file API methods are not useful
for
this purpose? The docs are a bit sparse regarding their intended
purposes.
On 10/10/07, John Stanton <[EMAIL PROTECTED]> wrote:
There is a good case to have an Sqlite API call to take a sn
John Stanton wrote:
[EMAIL PROTECTED] wrote:
John Stanton a écrit :
[EMAIL PROTECTED] wrote:
Hello,
I got an error when I try to read some data outside the while{},
inside the while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with val
Andy,
Thank you for your note. It is very useful.
Andy Spencer wrote:
On Tue, 9 Oct 2007, Joe Wilson wrote:
--- Cyrus Durgin <[EMAIL PROTECTED]> wrote:
i'm wondering if there's a "standard" way to get an open file handle from an
sqlite3 pointer using the C API. anyone know?
No such fun
If you are going to use BEGIN IMMEDIATE why not just enclose the
transaction in some form of lock like a mutex?
Scott Hess wrote:
We've just had a bit of discussion on the Google Gears team about some
cases where failure of an UPDATE/DELETE/INSERT while within a
transaction is unexpected. Well
Yes, provided you synchronize on the busy checks.
varunkumar wrote:
so two different processes cannot access the database at a time
John Stanton-3 wrote:
You need to handle the SQLITE_BUSY condition in your program.
varunkumar wrote:
is it possible more than one process can access the
You need to handle the SQLITE_BUSY condition in your program.
varunkumar wrote:
is it possible more than one process can access the sqlite3 database at a
time?
I am using sqlite3 database , I have the situation like follows in my
project.
In my project one process(daemon) doing as follows
The RESERVED lock increases concurrency by preventing other processes
from gaining an EXCLUSIVE lock while still permitting reads. A PENDING
lock prevents read (SHARED) locks being acquired preparatory to setting
an EXCLUSIVE lock.
The thread or process which holds a RESERVED lock is eventual
You could achieve your result by defining a semaphore. A custom
function in A would signal the semaphore and activate a thread in B when
the DB changed. The thread in B would be waiting on the semaphore Both
Unix and Windows implement semaphores in a similar manner.
A slightly higher level
If you use a semaphore it is independent of the processes currently
running and has nothing to do with a Sqlite connection. Your custom
function is called, signals the semaphore and exits. When the semaphore
is signalled the process waiting on it is activated.
In your example myfunc performs
trigger, but from the app A, it
might work, but that does not solve my problem. App A is a black box to me,
and I cannot change it. That is why I need to have app B that will detect
that the change of the database occurred.
John Stanton-3 wrote:
If you use a semaphore it is independent of the
Have you raised indices on the keys you use in your queries?
varunkumar wrote:
i have 40 columns table in my database. now my database size is 23MB .
untill now my database has 78752 rows(records). when i am query database it
is taking 10 seconds of time . my database performance is degradi
Moreover, is it typical to have an implementation like VDBE in other databases
as well?
This is a common approach and has been used for a very long time. For
example we used it in products produced during the 1980s because
producing a virtual machine and a compiler for its application-specif
Babu, Lokesh wrote:
sorry I forgot to mention the sqlite version that I'm using, its SQLite
3.3.8.
Below is the sample code that I tried,
static char *database_name = ":memory:";
static sqlite3* db_handle;
#define PRINT_TIME \
{ \
unsigned long millisec = clock(); \
printf("millisecond
Think about it. A transaction does not affect SELECts, it only defers
the processing of the journal until there is a COMMIT.
According to your version of Sqlite you may get some benefit from
SELECTs within a transaction by retaining the cache.
Ken wrote:
Thomas, if i understand you correctl
think not)
Thanks
Uma
John Stanton <[EMAIL PROTECTED]> wrote: >Moreover, is it typical to have an
implementation like VDBE in other databases as well?
This is a common approach and has been used for a very long time. For
example we used it in products produced during the 1980
The prepare creates a virtual machine which can be rused. A useful way
to implement Sqlite is to use prepare to compile all the SQL in the
initialization phase of the program and then to execute the virutal
machines using step.
By compiling a SQL in advance you can ensure that the program wil
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
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
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
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
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
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
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
Igor Tandetnik wrote:
> "Rosemary Alles" wrote
> in message news:af79a266-b697-4924-b304-2b1feccba...@ipac.caltech.edu
>
>> Run on a single processor, the following query is quite fast:
>>
>> When concurrency is introduced (simply running the query on several
>> processors against the same data
Sqlite is an ACID database - it ensures that data is written to disk, so
a database in memory still shares a single disk resource.
Jim Wilcoxson wrote:
> I'm not sure what you are considering a massive slowdown, but let's
> assume that the entire database fits into memory and disk I/O isn't
> the
Write a simple program..
As I recall our programs which do this use the Expat parser and obey a protocol
where the XML DTD represents the database tables and columns so that SQL can be
generated directly from the XML. It makes for a handy way to transport a
database, or a part of a database in
The confusion is in the names. When you "PREPARE" a statement you
actually compile the SQL. Compiling a program each time you run it is a
waste of resources, and so is compiling the SQL each time you use it.
Prepare your statements once and use them many times, binding data to
the compiled co
just copy the new inserted row to the data structure
> that already binded outside of the loop. In this case we don't need to bind
> the columns in the loop. Why this way didn't work for SQLite3 database.
> Thanks,
> JP
>
>
>
>
>
Sqlite does not have a TIME type.. It is interpreting your time as an
integer or floating point number or maybe text, depending upon its format.
Hughman wrote:
> Hi,
>
> I create a table with a field of datatype Time, and when I insert a
> formatting string like 'HHMMSS' into it , the first numb
You should be able to implement a classic circular buffer in SQL and
make it a VIEW for easy access. ROWIDs can be the buffer pointers and a
second table can store the current values.
Allen Fowler wrote:
> Hello,
>
> I have several CGI and cron scripts and that I would like coordinate via a
>
What makes you think that transaction control is not part of SQL-92?
If a database engine does not support transaction control it is not a
full implementation. Transaction control is at the very heart of
effective data management.
Shane Harrelson wrote:
> Additionally, it's important to note
Igor Tandetnik wrote:
> John Stanton wrote:
>
>> Shane Harrelson wrote:
>>
>>> Additionally, it's important to note that the LIMIT/OFFSET clause is
>>> not standard SQL
>>>
>> What makes you think that transaction control i
ed word, but that's it.
>
> http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
>
>
>
>
> On Wed, May 20, 2009 at 2:47 PM, John Stanton wrote:
>
>
>> What makes you think that transaction control is not part of SQL-92?
>>
>> If a dat
P Kishor wrote:
> On Sat, May 23, 2009 at 6:34 AM, Rosemary Alles
> wrote:
>
>> Thanks Simon. I have been leaning that way too - considering switching.
>>
>> -rosemary.
>>
>> On May 22, 2009, at 5:55 PM, Simon Slavin wrote:
>>
>>
>>> On 23 May 2009, at 12:10am, Rosemary Alles wrote:
>>>
>
Looks like feature bloat. If you need such features for a particular
application just add the code to your application or create a modified
version of Sqlite for just that application.
It makes no sense to burden all users with overhead for a feature
required by only a handful of applications.
An Sqlite database is just a file. Delete the file when you start
your program and when you open the database Sqlite will create a fresh
dne, a very low overhead process..
.
souvik.da...@wipro.com wrote:
> Hello,
>
> Please let me know if we have an API in SQLite3 which allows me to
> retai
gt;
> Thanks and Regards,
> Souvik
> -Original Message-
> From: sqlite-users-boun...@sqlite.org on behalf of John Stanton
> Sent: Sat 5/30/2009 5:30 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Deleting database content : SQLite3 API
>
Try studying basic database theory and technology to get a better
understanding of the problem. You will then understand the reason for
absolute transactional integrity and why Sqlite must use fsync or
similar and expects fsync to be a complete implementation which ensures
that each transactio
Simon Slavin wrote:
> On 31 May 2009, at 11:56pm, John Stanton wrote:
>
>
>> Try studying basic database theory and technology to get a better
>> understanding of the problem.
>>
>
> I have a pretty good understanding, I think. Plus 25 years experience.
&g
You might consider using a composite key "1963 CAN ABB" when you design
your data structure.
Igor Tandetnik wrote:
> Vincent Arel
> wrote:
>
>> I'm very, very new to SQLite, and would appreciate any help I can get.
>>
>> I have 3 long vectors that look like this:
>> {"ALB","CAN", "DZA",...}
301 - 400 of 1329 matches
Mail list logo