How about performing your backup inside an exlclusive transaction?
Marcus Grimm wrote:
> Hello all,
>
> is there a way to query if the database file is currently locked ?
>
> Background:
> My application may run for weeks (hopefully) and uses EXCLUSIVE
> transactions in some threads. On a daily
Roger Binns wrote:
>> John Stanton has correctly pointed out that there is a programming model
>> here an application effectively does the cacheing itself by precompiling
>
> statements at startup.
>
> That is not caching and it would be unaffected by any caching sc
You make a argument for Bloatware. It is not oersuasive.
JS
Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> John Stanton wrote:
>
>>Perhaps this featrure could be reserved for "Sqlheavy", a replacement
>>for Oracle.
>
>
>
Dan wrote:
> On Nov 8, 2008, at 3:25 AM, Roger Binns wrote:
>
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>Douglas E. Fajardo wrote:
>>
>>> ( To the 'powers that be'... I wonder if some form of 'cache' for
>>>prepared statements might be built in to the 'sqlite3_prepare*'
>>>func
Igor Tandetnik wrote:
> I'm not sure I understand the question. What precisely do you mean by
> "serialized queue"?
>
> Igor Tandetnik
>
Is it a repeated tautology?
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:
> you mean you do the synchronization by your selve rather
> than let it do sqlite internally ?
>
> Marcus
>
> John Stanton wrote:
>
>>We have been using such a server embadding Sqlite for some time with
>>success. We actually use pthreads exclusive and read
We have been using such a server embadding Sqlite for some time with
success. We actually use pthreads exclusive and read only mutexes for
synchronization since all Sqlite access is threaded in the one process.
JS
Marcus Grimm wrote:
> Hi all,
>
> a few weeks ago I discovered sqlite3 and found
First, wrap your inserts into a BEGIN...COMMIT transaction. Expect the
machine with the fastest disk rotation to perform the inserts fastest.
Darko Filipovic wrote:
> Hello,
>
> I'm having following situation:
> Table:
> CREATE TABLE TEST_TABLE (
> COL1 INTEGER(20) NOT NULL,
> COL2 INTEGER
Sqlite does not have those types, it establishes type according to data,
influenced by the affinity (numeric, string...).
The declared type can be anything chosen by the application. The
affinity is established by the declared type. Read the Sqlite
documentation to get an understanding of the ph
Since you just use one table you have no compelling reason to use a DB
and could use a simple index file. I would expect your update of
300,000 records in that case to only take a few seconds. The footprint
would also be far less. Something like D-ISAM would do the job.
Note that you would f
It does not look like you are using transactions.
Marian Aldenhoevel wrote:
> Hi,
>
> I have tried converting a program from a homebrew "database" to sqlite3
> for easier maintenance and hopefully better performance. While the
> former is easily achieved, the performance is not making me happy.
You canot have constant time inserts into a B-Tree because of the
inherent nature of the algorithm. Berkeley DB has either B-Tree or
hashed indices. The unordered hashed indices are possibly what you
measured. Note that B-Trees have the additional property that they
maintain an order and thu
On a large table it will be much faster to use an index than to force a
row scan as your initial query did.
L B wrote:
> I have obtained a great performance improvement now
> just adding an index in the 2 columns
>
> dtfrom and idcatalogue,
>
> removing the 2 single indexes on the column dtfro
Look up the implications of Sqlite's ACID feature and the use of
transactions. COMMITs are tied to disk rotation speed. On our Sqlite
databases where we look for performance we use 15,000 rpm disks and are
diligent in wrapping INSERTs, UPDATEs and DELETEs in transactions and
get very good res
jonwood wrote:
>
> cmartin-2 wrote:
>
>>I suspect it is quite common, e.g., web apps built on SQLServer backends
>>are quite likely to use UTC. At any rate, it is definitely a design
>>decision, if one expects that local times will always work in all
>>scenarios, but all means use local times.
Christophe Leske wrote:
> John Stanton schrieb:
>
>>The sqlite3.exe program is set up as a utility and maintenance tool, not
>>a production environment and is designed to that end. If you want
>>maximum performance it is not the way to go; instead embed the Sql
The sqlite3.exe program is set up as a utility and maintenance tool, not
a production environment and is designed to that end. If you want
maximum performance it is not the way to go; instead embed the Sqlite
calls inside your application and optimize access. If you are
performing ad-hoc DB t
SQL uses single quotes to delimit string literals.
Aladdin Lampé wrote:
> Hi!
> Is it possible to include a \" (double quote) inside a string-literal?
> I wanted to use a string-literal like "this is \"not working\"" but sqlite's
> SQL parser doesn't seem to accept this.
> Is it the intended beha
Prepare your statements only once and then use bind. Do not use
sqlite3_exec. Do not open and close the DB for each read, instead open
once and let the cache work. Avoid row scans by defining indices. Use
the new index selection functionality to force the use of the best
index. Place large
Use the correct SQL delimiter for a literal - single quotes, e.g.
'google.com'.
Hari wrote:
> Hi as i am new to sqlite.
> I have problem when i am using sqlite3_exec() function with select
> as i am using sqlite3_open() to opening database
> then creating table and inserting some information usi
Looks like you do not have readline linked into sqlite3.
Mark Easton wrote:
> Hi everyone,
>
> Since I have installed the new version of sqlite3, I have found that when I
> am in command line (sqlite3) I can no longer use up arrow to search through
> my command history.
>
> An up arrow just pro
Sqlite works well as the DBMS core of a WWW server. It is not a
competitor for Oracle. DB2 or PostGreSQL but can support a large number
of users and has the advantage of being embedded. It is not a good idea
to use it for a large number of concurrent long queries. Sqlite works
best with shor
I don't see you compiling the SQL statement with a prepare or testing
for errors.
RickLaird wrote:
> I am trying to execute a select with a like clause. I am having
> trouble passing in the string to match in the bind call.
>
> You might notice I am writing this in cocoa. I hope the logic c
n't be very surprised if it turned out to be that the very large
> source file is overwhelming IBM's optimizer. So far the non-optimized
> compiles of sqlite3 are working fine.
>
> -----Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Monday, Se
We use gcc.
Ribeiro, Glauber wrote:
> This issue continues with version 3.6.2
>
> g
>
> -Original Message-
> From: Ribeiro, Glauber
> Sent: Friday, September 19, 2008 11:55 AM
> To: General Discussion of SQLite Database
> Subject: [sqlite] Core dumps on AIX with optimization
>
> Just
To me this is a very rational approach. It is simple and unambiguous to
understand and use and simple to implement compared to the alternative
schemes. That fits nicely with the "lite" approach.
Ad the directive to the SQL and measure the result and the effect is
immediately obvious. Hard to
jason weaver wrote:
> "jason weaver" <[EMAIL PROTECTED]> wrote:
> news:[EMAIL PROTECTED]
>>> However, due to database locking issues, I need to do a bunch of
>>> inserts in one transaction or batch. Thus, I store them in a simple
>>> queue. Therefore, the julianday('now') won't work because all o
We use Sqlite on AIX and discovered that when compiling with gcc we have
to remove the debug -g from the makefiles No optimization issues. We
always link statically.
Ribeiro, Glauber wrote:
> Just wondering, are there other AIX Sqlite users out there, and what
> have you done in order to get a
I would get rid of your separate columns for day, month and year and use
the Sqlite date format and use an index on it.
chris wrote:
> I'm at a loss and need some guidance. My queries are taking way longer than
> I can use but I'm not sure what steps to take next.
>
> I'm using SQLite 3.6.2 on
My advice was not to have the tail wag the dog. Choose you language as
appropriate for the application. Sqlite fits everywhere. For example
if it is an embedded system use C. If it it something else a script
system like Perl of whatever would be appropriate.
If you want an ideally integrate
You get ROW if there is a row available, DONE if there are no rows, or
all the rows have been extracted. Your program needs to test for both
states.
Lothar Behrens wrote:
> Hi,
>
> I am struggling with the following situation:
>
> I have a table where two rows are inserted. I create a new pre
Sqlite maintains its data in a disk file. It only reads and writes to
that file sufficient bytes to maintain changes to the database or to
satisfy the query. It uses memory to cache data while it processes it
and will write changed parts of that data back to the disk file.
Fundamentally Sqlit
The Sqlite manifest typing integrates nicely with scripting languages
which use similar strategies. Where such integration is not required
and there is a well defined application such as an embedded system,
particularly with a slower processor, a static typing model would be
advantageous in ma
When I modified Sqlite to block type conversions my memory of it is that
the changes were quite simple and easy to implement. You could log
the change events with a handful of patches to Sqlite. It would be an
interesting exercise to analyze the impact of the conversions.
On an aside I disc
I made some changes to Sqlite to stop the automatic type conversions.
The performance improvement was not significant. My reason was not to
avoid the performance overhead but to prevent the use of floating point
where it would raise precision problems.
My suggestion would be not to worry about
Open the Sqlite DB file for exclusive access. If it fails another user
has it open.
Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Thursday 21 August 2008 22:45:33 Doug Porter написал(а):
>
>>Our software uses SQLite to save our data and we want to warn a user
>>who opens a file that is a
I implemented a decimal type in Sqlite. It uses fixed point and correct
rounding rules. To my mind it is an essential component if one is using
Sqlite for commerical purposes and must have accurate financial information.
jonwood wrote:
>
> Brad Stiles-2 wrote:
>
>>That's a very real possibil
Chris Brown wrote:
>>The "fossil" configuration management system (used to control the
>>documentation of SQLite - see http://www.fossil-scm.org/ for details
>>and http://www.sqlite.org/docsrc/timeline for an example) calls
>>system() after sqlite3_open() in multiple places and it works just
>>fine
I can access your home page but time out on the links.
Petr Vanek wrote:
> hello all sqlite users,
>
> I'm glad I can announce new stable version of Sqliteman - the GUI for
> developers and admins:
> http://sqliteman.com/
>
> Sqliteman introduction:
> http://sqliteman.com/index.php/page/2.html
>
I wrote an Sqlite module which links into Spidermonkey and connects to
Sqlite using the Sqlite API.
Stephen Woodbridge wrote:
> John Stanton wrote:
>
>>Adding Javascript to Sqlite as a stored procedure language was a fairly
>>simple operation. Try it if you need
involved.
We use it to store business and other rules in the DB.
Shawn Wilsher wrote:
> On Tue, Jul 29, 2008 at 11:39 AM, John Stanton <[EMAIL PROTECTED]> wrote:
>
>>Adding Javascript to Sqlite as a stored procedure language was a fairly
>>simple operation. Try it if yo
Adding Javascript to Sqlite as a stored procedure language was a fairly
simple operation. Try it if you need stored procedures.
BareFeet wrote:
> Hi John,
>
>
>>I would like to know if SQLite supports stored procedures.
>
>
> Technically, no it doesn't.
>
> For what purpose do you want to s
Try making your date a REAL and using the Sqlite date and time
functions. You will use extra space for the rowid, the key of the row
and for the b-tree index.
You would expect the indexed rows to be about double the raw text data
since the numbers are 64 bit FP.
Corey Nelson wrote:
> I'm deve
On earlier versions of AIX Sqlite has no issues. This problem might not
be inherent to AIX V5.3.
D. Richard Hipp wrote:
> On Jul 14, 2008, at 1:31 PM, Ken wrote:
>
>> sqlite 3.5.9 and AIX 5.3
>>
>> Upon commit of a main DB with an attached DB sqlite returns (1290)
>> 0x50A SQLITE_IOERR_DIR
I believe Sqlite implemens Soundex as standard. Thet might work for you.
Alberto Simões wrote:
> Hello
>
> Although I am quite certain that the answer is that SQLite does not
> provide any mechanism to help me on this, it doesn't hurt to ask. Who
> know if anybody have any suggestion.
>
> Basic
I haven't looked closely at this problem but a cursory glance suggests
that Sqlite is not using an ASC indesx if there is a DESC ORDER By clause.
Try doing the selection ASC and then sorting the output DESC as a
seperate action.
Alexey Pechnikov wrote:
> Really, there is problem with multi-colu
There is no Sqlite server. It is embedded.
winstonma wrote:
> I tried to export the the SQL command exported from DBDesigner4 is not going
> to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
> can connect to SQLite server.
>
> I tried to download the source code from SQL
Igor Tandetnik wrote:
> c.panel <[EMAIL PROTECTED]> wrote:
>
>>no possibilities for indexing on an expression : is it a
>>particularity of SQL or SQLite ?
>
>
> Personally, I never saw any DBMS that supported anything like this. I
> can't prove that none such exists, of course.
>
> Igor Tandet
An index has to be built from actual data. You would need to evaluate
the expression and make the result a column in a table.
c.panel wrote:
> Oh yes! "set" is the solution.
> I know that I have missed something...
> thanks a lot.
>
> no possibilities for indexing on an expression : is it a par
The lesson is very clear from the evidence. With SQL NULL is ambiguous
and subject to intepretation so good design requires that you completely
avoid it. Then you sidestep intractable implementation interptrations.
A project management technique dating back further than I can remember
was to
Igor Tandetnik wrote:
> John Stanton <[EMAIL PROTECTED]> wrote:
>
>>Without looking up my code I recollect being able to pick up the
>>connection pointer from the context and to continue accessing the DB.
>
>
> But that's not what the OP is asking. He w
Without looking up my code I recollect being able to pick up the
connection pointer from the context and to continue accessing the DB.
Igor Tandetnik wrote:
> [EMAIL PROTECTED] wrote:
>
>>Given a user-defined function of Foo(), and a query such as
>>
>>select * from sometable where foo()
>>
>>Is
>
> Any thoughts?
>
> Andrea
>
> -Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of John Stanton
> Sent: Friday, June 20, 2008 12:08 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Performance on H
You are measuring the speed of the respective machines. Benchmark each
one to get relative performance.
Andrea Connell wrote:
>
> Sorry somehow I sent that before I was quite finished. I'm just
> wondering if there is anything else I should try. About 30,000 rows are
> found in the end, and it
A limited SQL parser is fairly simple. You could write the program and
launch it from a scripting language as a filter program with input and
output piped.
Dennis Cote wrote:
> BareFeet wrote:
>
>>So, before I get too far into it, I figured others of you out there
>>must already have some re
Alexey Pechnikov wrote:
> В сообщении от Wednesday 18 June 2008 23:40:05 John Stanton написал(а):
>> Alexey Pechnikov wrote:
>>> В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а):
>>>> The magic potion is the ability to embed Sqlite in the app
Alexey Pechnikov wrote:
> В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а):
>> The magic potion is the ability to embed Sqlite in the application
>> server and avoid IPCs and multiple processes.
>
> Why not multiple processes? And what about threads?
be active only when a
> usable message peace was received.
>
> One might say that a misbehaving client could still slow down the server. A
> server should respond with a notification before dropping this client for
> sending runt messages.
>
> What is your design like?
>
&g
What did you change? What was causing the lag?
Alex Katebi wrote:
> slowness is fixed. Can't tell the difference between client/server speed
> from library.
>
> On Sat, Jun 14, 2008 at 8:32 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
>
>
>>Hi All,
>>
>> Looks like there is some interest. I wi
You are expecting a miracle to ask for help without being allowed to
report the problem.
Sqlite3_exec just encapsulates prepare and step. If your code runs
slower you have a logic error somewhere.
Jong-young Park wrote:
> Deal all,
>
> I have used some SQLite application with sprintf and sqli
uad CPU. For security I could
> either use SSH Port Forwarding or use a MD5 implementation in my
> client/server code.
>
> Thanks,
> -Alex
>
>
>
> On Tue, Jun 10, 2008 at 11:25 PM, John Stanton <[EMAIL PROTECTED]> wrote:
>
>> Alex,
>>
>> Than
We make a JSON object of the selected rows and send it to a client in
one network access to minimize network traffic. Suitable for clients
with Javascript. Packaging of the object can suit the client. Limits
are set to avoid choking the client.
Alex Katebi wrote:
> Dennis,
>
> After your
that is
> highly scalable are using this model. non-blocking seems to be more
> complicated at first glance but it actually makes the server design much
> simpler. I am planning to release my code as open source when it is more
> complete.
>
> Thanks,
> -Alex
>
> O
We use an application server I wrote which handles HTTP, serves file and
has embedded Sqlite for the RPCs. The RPC can deliver its result either
in XML for widely distributed applications or as JSON if it is
responding to a WWW browser in AJAX mode.
We keep a local library of SQL RPCs so that
s I need to do it as 8 byte buffer. Convert the endianess to the network
> then back to host for 8 byte integer.
> I think XML is great for command validation and CLI auto typing, help etc.
> Besides parsing issue, XML can not handle binary data directly.
>
>
> On Tue, Jun 10, 2
Can you explain how you are trying to write to the socket and how you
are receiving?
If you use write or send you just supply a pointer to the value and a
length to write, viz - written = write(sokfd, (char *)fptr, 8); where
fptr is a pointer to your floating point number.
We use Sqlite embedd
Use this sequence:
sqlite3_open
sqlite3_prepare_v2//Compiles SQL statement
loop
sqlite3_bind... //Binds variables
sqlite3_step//Executes statement
sqlite3_reset //Readies compiled statement for binding to vars
until finished
sqlite3_finalize
Alexey Pechnikov wrote:
> В сообщении от Monday 09 June 2008 17:52:24 Dennis Cote написал(а):
>
>>If you
>>consider dates to be equal when the two dates are the same to within one
>>second, then you could use that value as your maximum difference. Since
>>a julian day number has units of days, you
Sqlite3_exec just encapsulates sqlite3_prepare. You very likely have
something wrong with your code if yor version works slower.
toms wrote:
> Hi all
> I tried to use the sqlite3_prepare to increase my performances during
> requests for both writing / reading.
> The strange thing is that when u
The brute force and ignorance method of test for floating point equality
is to test for a difference less than a specified limit. The difference
is just a little bit larger than the expected aproximation error.
My sugestion with dates is to spend a little time extending the embedded
sqlite dat
Dennis Cote wrote:
> John Stanton wrote:
>> But for practical arithmetic probability or possibility is not close
>> enough. It must be certainty.
>
> There is a possibility that your code could be asked to compare two
> equal floating point numbers. To be correct,
Dennis Cote wrote:
> John Stanton wrote:
>> The point about using floating point is that there is no equal, only
>> less or greater, because it is an approximation. If you want to use
>> equality you must use some form of integer or fixed ppint numbers.
>>
>
>
Steve Kallenborn wrote:
> D. Richard Hipp wrote:
>> On Jun 4, 2008, at 7:13 AM, Derrell Lipman wrote:
>>
>>> On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp <[EMAIL PROTECTED]>
>>> wrote:
>>>
Let me strongly reiterate that you look into using the new R-Tree
virtual table available for
Look at the built in Sqlite date and time functions.
the_chill wrote:
> Hello, how do I save a information + Date in a SQlite DB? I want later to
> enter a date and get the Information. Like information from
> 07.08.05-03.04.06 or so. I tryed SQlite browser but found no way. I need to
> share the
Mark Stewart wrote:
>
> John Stanton-3 wrote:
>
>>I wonder why you do not just use a file in the first place. Sqlite
>>caches data in memory so a file based database and memory based perform
>>much the same.
>>
>
>
> For this app, I didn't wan
I wonder why you do not just use a file in the first place. Sqlite
caches data in memory so a file based database and memory based perform
much the same.
Mark Stewart wrote:
>
>
> Jay A. Kreibich-2 wrote:
>
>> Of course, I assume Mark wants to do this via code. That will
>> require poking
Use integers if you want to assign a specific scale and precision.
Because floating point numbers are an approximation you can enforce a
certain precision by calculating differences. You cannot use equality
with FP but you can decide that equality is when (A - B) < |N| where N
is the precision
Darko Miletic wrote:
> Rajesh Nair wrote:
>> Hi
>>
>> Is there any future plan to develop sqlite in C++.
>>
>
> Why would anybody want to do that?
Sabotage?
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/ma
Sqlite is a nicely structured C program which will always be better than
C++. Nice, clean easy to read and well documented C fits in everywhere.
Dennis Cote wrote:
> Rajesh Nair wrote:
>> Is there any program to develop sqlite in C++.
>
> See http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Maybe last_rowid is what you are after.
Skip Evans wrote:
> Hey all,
>
> I'm new to SQLite and having a heck of a time
> finding the equivalent to MySQL's
>
> mysql_insert_id().
>
> I'm using SQLite with PDO in PHP5.
___
sqlite-users mailing list
s
A timestamp is a REAL.
Joanne Pham wrote:
> Hi All,
> As mentioned in the document of SQLite the list below is all the datatype of
> SQLite.
> How about Timestamp fromat? Can we havethe column's datatype as Timestamp .
> Thanks,
> JP
> * NULL. The value is a NULL value.
> * INTEGER.
By using BEGIN IMMEDIATE you lose any chance of concurrency.
Samuel Neff wrote:
> We're running into a lot of very slow queries and db locks when running with
> multiple processes accessing the same database. As a test we created a
> small application that has only two threads and a small single
You shouldn't need to link. You could just compile it into your
application.
Derek Lee-Wo wrote:
>> If you do not use configure you have less control over compile options. You
>> need to think about whether yiou need to compile it thread safe or not.
>
> The app is single threaded so I don't n
really
> recommended that I get the configure/make working correctly?
>
>
>
>
>
>
> On Tue, May 13, 2008 at 11:05 AM, John Stanton <[EMAIL PROTECTED]> wrote:
> > What verion of AIX are you using? What compiler? gcc or xlC?
> > JS
> &g
What verion of AIX are you using? What compiler? gcc or xlC?
JS
Derek Lee-Wo wrote:
> Is there a precompiled version of sqlite3 available for AIX? I did a
> Google search, but can't find anything.
>
> I would build it myself, but I'm having a really hard time as the
> configure script wouldn't
We implement a distributed synchronized Sqlite database by queueing
changes. In our case it is designed to permit internet operation to
continue during network failures or congestion.
Virgilio Alexandre Fornazin wrote:
> The best you can do actually with SQLite is a 'mirror-replicating' mode
>
random 500 records.
>
>
> On Thu, May 8, 2008 at 9:17 AM, John Stanton <[EMAIL PROTECTED]> wrote:
>
>> Dennis Cote wrote:
>>> Barbara Weinberg wrote:
>>>> I was wondering whether anyone had tried sorting records in random
>> order
>>>
Dennis Cote wrote:
> Barbara Weinberg wrote:
>> I was wondering whether anyone had tried sorting records in random order
>> using sqlite3. I tried sorting by random() and randomblob() but it was very
>> slow and chewed up lots of resources. Any suggestions?
>
> Can you provide any more details abo
Sorting in random order is a definite contradiction in terms. What are
you actually trying to do?
Barbara Weinberg wrote:
> Hi
> I was wondering whether anyone had tried sorting records in random order
> using sqlite3. I tried sorting by random() and randomblob() but it was very
> slow and chewe
They are all type INTEGER, essentially a 64 bit signed integer.
Joanne Pham wrote:
> Hi ,
>> "Can you direct us where you find out that "SQLITE3 has bigint and int"
>> as datatypes?"
>
> Not on any website but one of another project in my company using sqlite and
> they created one of the using
You define a callback in your CREATE statement. Why? Where is it?
[EMAIL PROTECTED] wrote:
> I'm a beginning sqlite user (v3.5.8 for Linux). I use a c++ program to
> open a connection to my database with no issues, but when trying to
> exec any sql statements after that, i get SQLITE_BUSY (i
gt; -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of John Stanton
> Sent: Saturday, May 03, 2008 9:19 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] property/config file for SQLite
>
> Not only is it a feature, it
Not only is it a feature, it is a blessing. One of the most endearing
features of Sqlite is that one file encapsulates everything. The
simplicity is no accident but rather the reward of plenty of design
discipline.
I can attest from experience to the improvement in software reliability
achie
Just open the file.
palmer ristevski wrote:
> I am new to this type of Forum.Here is my question : My development platform
> is VB6. I am using "SQLitePlus COM-DLL" from ez-tools.com.They have code to
> access and query an existing ".db" file, but I wish to know how to make a
> function call to
Run a trial, but I am sure that fgrep will be faster.
Scott Baker wrote:
> I'm curious about the speed trade off between a full table scan and just a
> flat file search... Say I have a database with 2 records in it. If I do
> a query like:
>
> SELECT foo FROM table WHERE bar LIKE '%glaven%'
rary.
>
> But right now I am confused, because my processes do not blocks on
> sqlite3_exec. They immediately report BUSY_TIMEOUT, without awaiting
> for time set by sqlite3_busy_timeout.
>
>
> On Thu, Apr 24, 2008 at 4:29 PM, John Stanton <[EMAIL PROTECTED]> wrote:
concurrency
on reads.
To my mind syncing on a mutex is better and simpler than polling the
resource using SQLITE_BUSY.
Alexander Batyrshin wrote:
> So, you advice me, to implement synchronization inside my process by my self?
>
> On Thu, Apr 24, 2008 at 3:40 PM, John Stanton <[EMAIL PROTE
You have a single shared resource, Sqlite, and you have to synchronize
access. You can use the internal locking in Sqlite and use polling or
wait on a mutex or semaphore.
Alexander Batyrshin wrote:
> Hello All,
>
> I am observing situation, that my concurrency process does not have
> access t
My guees is that you have encountered a limitation in the Ruby wrapper.
Can you write the BLOB in chunks using your interface?
João Macaíba wrote:
> Hi.
>
> I intend to use sqlite3 to store files.
>
> I've tested inserting an 7.6MB file in a blob column but it returns a
> SQLite3::TooBigExce
In your second case you have the wrong pathname for your database file
and Sqlite is creating an empty one at whatever path you actually specified.
Yang WenYuan wrote:
> Hi,
>
> There is a very strange problem when I play with the sqlite-ce database.
>
> I put the database file and my applicati
101 - 200 of 1329 matches
Mail list logo