Davide Berti wrote:
I am getting this error and have viewed the archives but am still at a loss.
Can I load a script file that creates a view tables:
sqlite3 test.db < myscript
then from a c program sd_open("test.db", db_handle);
It keeps giving me the library routine error. My program is
JP wrote:
John Stanton wrote:
I endorse Jay's approach. In our web page software using Sqlite
everything is TEXT except for dates in Sqlite format. We use declared
types to indicate classes of text, such as decimal numbers and dates.
There are no radix conversion involved in data
[EMAIL PROTECTED] wrote:
Hi (...at the first time... ;-)
My App (up to 1500 Users, up to 15 Million Records in
some tables in a SQL-Server-DB) offers as a specially
feature Data-Export. The Export-Functionally is one of
the most-used feature by Users. Exports are controlled
and done by a
The current API is complete regarding types. It returns both the
declared type and the type actually stored. There is nothing else.
Note that the actual storage type can vary between rows according to the
data format, which is why the actual type is returned row by row.
JS
sqlite wrote:
I endorse Jay's approach. In our web page software using Sqlite
everything is TEXT except for dates in Sqlite format. We use declared
types to indicate classes of text, such as decimal numbers and dates.
There are no radix conversion involved in data manipulation (apart from
dates), and we
As you postulated, Sqlite's approach is indeed more rational.
As for what you are doing, the way I did a similar thing for
compatibility was to make a function which looks at the declared type
and the actual type and makes the appropriate conversion if necessary to
match the destination
Fred Williams wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 7:37 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How can I get the type of a column?
[EMAIL PROTECTED] wrote:
sqlite <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
sqlite <[EMAIL PROTECTED]> wrote:
Eric Scouten wrote:
SQLite derives that by parsing the string that you've already found.
I found the method in section 2.1 of this page:
http://www.sqlite.org/datatype3.html
> I think it does store that in some internal fashion,
The type can vary according to the data. The "declared type" is what
you declare it to be and the type returned when you get a row is the
type which Sqlite decided it should be based on its format.
You can make the declared type anything you want it to be, for example
"WIDGET" and when you
We do this in a very general way by running a comms program (actually a
CGI process) which transforms the structure of the DB into XML and sends
it to the client. The client knows the DTD so that it can parse it and
write to its database, which does not have to be Sqlite.
A simpler way would
Bruno
---Message original---
De : John Stanton
Date : 05/09/06 00:43:51
A : sqlite-users@sqlite.org
Sujet : Re: [sqlite] Réf. : Re: [sqlite] How to get the lastest version of
SQLITE with PHP ???
Why don't you use the standard PHP DB abstraction layer which provides
is at the proper place. strlen() verifies this.
Is the string supposed to be something else than a C string?
What is really odd is that it works perfectly with the installed
3.1.3. With the same string.
Thanks,
Matt
On May 8, 2006, at 7:27 PM, John Stanton wrote:
It looks very much
It looks very much as if your SQL statement is being truncated when you
pass it to sqlite3_prepare. Are all your character arrays adequately sized?
JS
Matthew Veenstra wrote:
Hello,
First of Kudos for a such a great program. SQLite is easy to use,
fast, and portable.
Now to my question.
Why don't you use the standard PHP DB abstraction layer which provides a
common interface to all DBMS's and incorporates the current version of
Sqlite, Sqlite3? As I see it the Sqlite2 you are using is in PHP for
historical reasons to support legacy code.
JS
Night Media LTD wrote:
Due to
You can get the source code from sqlite.org. What more do you need if
you are going to come up with a new version of Sqlite?
You might look to caching compiled (prepared) SQL statements and using
sqlite3_step as a very powerful method of not just reducing SQL parsing
time but making it a
You can download Mingw and an IDE like Dev-Cpp and you will have the
ability to compile Sqlite3 on your PC, along with supporting software
and applications.
JS
Unit 5 wrote:
Hello,
I do not have Visual Studio or other compilers to
build Sqlite3 from the source code on my pc.
Is there a
We feed XML into an SQLITE database, but the XML DTD maps the database
in structure and names. To get general XML data and load it into any
database requires a program of some description to translate names and
structures.
JS
A. Pagaltzis wrote:
* Rajan, Vivek K <[EMAIL PROTECTED]>
Sqlite3_complete does no syntax checking other than to see if the SQL
statement is terminated with a semi-colon. It is used to split multiple
SQL statements in the same string, not verify syntax.
Why not use the Sqlite SQL syntax checker by running sqlite3_prepare on
your statement?
You
If you have a wide table and want to optimize performance you would do
better to increase the page size.
JS
Jay Sprenkle wrote:
On 5/2/06, Felix Schwarz <[EMAIL PROTECTED]> wrote:
Hi,
Morning!
"Put small and frequently used columns early in the table to minimize
the need to follow the
You cannot go wrong by using Mingw. The package with the Dev-Cpp IDE
works well and compiles Sqlite without problems.
JS
Aaron Jones wrote:
Windows XP, don't know what compiler to use.
I am creating a GUI to SQLite, so need my interface to connect to SQLite,
and wanted to know what it
To compile just read the instructions with thye source distribution.
Sqlite doesn't connect, it is a library which you link into your
application.
JS
Aaron Jones wrote:
Hi, I have to questions I would like some help on please
1. How do you compile SQLite from the source code
and
2. How
The index is a B-Tree, not hashed. The order of the segments of the key
makes a big difference to queries, as pointed out earlier. It doesn't
make any significant difference to the time it takes to create of
maintain the index.
JS
Taka wrote:
Ah, maybe I wasn't quite clear enough.
What I
Unit 5 wrote:
Hello,
I have just started playing with Sqlite. I was able
to download the latest binary and start using it right
away from a tclshell. It seems that the primary api
is db eval command.
In the documentation and the FAQ's, I did not see this
so I thought I would ask here for
Jim C. Nasby wrote:
On Sun, Apr 23, 2006 at 07:30:21AM +1000, John Stanton wrote:
I have actually done that and it works well for a particular class of
applications, ones with a relatively small number of simultaneous users.
For large numbers we switch to PostgreSQL The basic architecture
I have actually done that and it works well for a particular class of
applications, ones with a relatively small number of simultaneous users.
For large numbers we switch to PostgreSQL The basic architecture of
Sqlite, and why it is "Lite", is that it uses a single file and file
locks for
This is an interesting development for embedded system developers who
use Sqlite.
http://www.embedded.com/showArticle.jhtml?articleID=183700818
http://www.embedded.com/showArticle.jhtml?articleID=185302940
Quote -
The week before ESC Silicon Valley, the number of you who clicked on
Part 1 in
Christian Smith wrote:
At the risk of this turning into another argument between us...
On Thu, 20 Apr 2006, John Stanton wrote:
Q How do programs get to be slow and bloated?
A One small inefficiency at a time.
It is just as inefficient to send dynamically created content through a
series
Christian Smith wrote:
On Wed, 19 Apr 2006, John Stanton wrote:
Chris, Thanks for the very pertinent comments on segment linking.
I am not sending an Sqlite database. It is the output from my program,
principally assembled HTML/PDF/PostScript and similar.
I want to avoid buffer shadowing
Nuno Lucas wrote:
On 4/18/06, Christian Smith <[EMAIL PROTECTED]> wrote:
The OS has to track each MMAP segment, which is usually a linear linked
list sorted by virtual address. As most processes don't have that many
segments mapped (10's of segments would be considered a lot) the O(n)
linear
hit such
limits and their impact.
It has always been my experience that if you get the underlying
mechanisms used by your application to be optimal, then you have no
scaling problems and no walls to hit in the future.
JS
Christian Smith wrote:
On Sun, 16 Apr 2006, John Stanton wrote:
I
, April 16, 2006, 10:00:57 AM, you wrote:
JS> John Stanton wrote:
>> I wonder if members can help me with some advice. I have a program >>
which is a multi-threaded application server with Sqlite embedded which >>
runs on Unix and Windows. For an i/o buffer per t
John Stanton wrote:
> I wonder if members can help me with some advice. I have a program
> which is a multi-threaded application server with Sqlite embedded which
> runs on Unix and Windows. For an i/o buffer per thread I have the idea
> of using a mmap'd file so that it can be
I wonder if members can help me with some advice. I have a program
which is a multi-threaded application server with Sqlite embedded which
runs on Unix and Windows. For an i/o buffer per thread I have the idea
of using a mmap'd file so that it can be transferred using
sendfile/TransmitFile
[EMAIL PROTECTED] wrote:
These days they teach the Philosophy of Science, and students get to
understand why Mathematicians are awarded Arts not Science degrees.
Although it seems highly pedantic it is actually very important that
programmers have an insight into what they are really doing if
[EMAIL PROTECTED] wrote:
- Original Message -
From: "John Stanton" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, April 15, 2006 12:09 AM
Subject: Re: [sqlite] Re: Structured or Object-Oriented
[EMAIL PROTECTED] wrote:
- Original Mes
Dan Baker wrote:
I been reading this list for several days, but just started using it today.
I'm using it as an embedded database (on Windows), and want to be able to
create the initial database from within my app -- meaning, I don't want to
ship a database file.
What is the recommended
Aaron Jones wrote:
Well John, I'm crap at both Maths and Programming so you're probably
right!!! lol
Aaron.
On 14/04/06, John Stanton <[EMAIL PROTECTED]> wrote:
Robert Simpson wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
You should desig
[EMAIL PROTECTED] wrote:
- Original Message -
From: "John Stanton" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, April 14, 2006 1:32 AM
Subject: Re: [sqlite] Re: Structured or Object-Oriented
I was always impressed with Dijkstra's contenti
Robert Simpson wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
You should design your interface using whatever design method
you are most comfortable with. Or (better) just design your
interface using creativity and good sense and don't worry so
much
A wise computer scientist once told me "In Computer Science every
problem can be solved by yet another level of indirection". Your
problem is no exception.
JS
Cameron Tofer wrote:
The rowid of the table's record in the sqlite_master table would be
great, but really any unique integer that I
Aaron, your question indicates that you need to read a bit more deeply
in general CS theory as a prelude to your project. Sqlite is basically
a simplified implementation of basic SQL, and is a just library of
functions, not an entity. With it you can build to your chosen model.
Think of
Pam Greene wrote:
I use sqlite3_create_function() to attach C++ functions to SQLite
triggers. For example, I create the SQL function INSERT_HANDLER(),
bound to the C++ function InsertTriggerHandler(). Then I create a
trigger:
CREATE TRIGGER trig AFTER INSERT ON TableName
FOR EACH ROW
Provided your new database has the features you are using it is simple.
For example we use Sqlite and PostgreSQL and transferring between them
is simple. Even the application program API is similar so a conditional
compile in the programs takes care of that and links appropriately.
JS
Dennis Cote wrote:
Floppe wrote:
Will Leshner wrote:
On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
When using sqlite-3.3.4 with windows I get the following strange
behaviour.
create table Muppet (Kermit float);
insert into Muppet values (100);
select * from
Sqlite works very well for web applications unless they are large and
very busy. It is easy to manage and backup and performs well.
For a larger scale operation PostgreSQL would be a better choice than
MySql. If you design your application with care you could switch from
Sqlite to
listen connection UDP. The server could index
(INSERT) and search within the database (SELECT).
The problem is when i do so much connection at the same time for do index
and search at the same time.
Know is it clear? sorry for my english :D
Thanxs
On 4/3/06, John Stanton <[EMAIL PROTEC
Steve Bergman wrote:
Is it possible to dump an SQLite table in a format something like this?
INSERT INTO employee (last_name, first_name, mi, username, id,
extension, home_phone, cell_phone, status, email_primary,
email_secondary) VALUES ('Jones', 'John', NULL, 'jjones', 6, '108/14',
Try to explain what you are doing. How do you access SQLITE? What
language? What SQL are you using. How many concurrent users do you
have? Are you getting a LOCK error because of multiple users?
Cesar David Rodas Maldonado wrote:
please i need some help
On 4/3/06, Cesar David Rodas
Olaf Beckman Lapré wrote:
Hi,
I would like to compile the SQLite 3 sources directly into my app. Since I'm
using Visual C++ 6 how can I configure the sources to allow me to compile them?
Can I use MSYS and run /configure and then just copy the 'configured' sources
to my Visual C++ app and
Dennis Jenkins wrote:
Essien Essien wrote:
hiya,
I have a code snippet that looks like:
typedef int (*SQLITE3_CLOSE)(sqlite3*);
typedef const char* (*SQLITE3_ERRMSG)(sqlite3*);
typedef int (*SQLITE3_OPEN)(const char*, sqlite3**);
typedef int (*SQLITE3_EXEC) (sqlite3*, const char*,
terryyan wrote:
HI,EVERYBODY!
I AM WRITING CGI WIHT C ,AND I WANT TO INSER A CHARACTER ARRAY INTO SQLITE
IN SENTENCE LIKE:
RC=SQLITE_EXEC(DB,"INSERT INTO MYTABLE VALUES('ARRAY_HERE')");
HOW CAN I DO ?
THANKS IN ADVANCE!
OS: LINUX
CGI: C
DATABASE: SQLITE
THE CHARACTERS IN THE
Tito,
Several people have bothered to spend the time and effort to give you
some well considered help. That is what forums like this are for,
professional guidance and development. Thank them.
Tito Ciuro wrote:
MGC,
I have no idea why you're so angry. Anyway, there are so many things I
Tito Ciuro wrote:
On 26/03/2006, at 10:51, MGC wrote:
Your design is fundamentaly wrong.
I don't know what your intended use
is for this data, but I am logging identical fstat file info along
with an
MD5 sums.
Well... if you don't know what is the intended use for the data, how
can you
Christian Smith wrote:
On Tue, 21 Mar 2006, Miha Vrhovnik wrote:
The database already knows exactly where to look for each
table when all the tables are in the same file. All it
has to do is "lseek()" to the appropriate spot. How does
moving tables into separate files help this or make it
of using this technique for large data volumes, but in
smaller scale applications it certainly delivers good performance.
Christian Smith wrote:
On Wed, 22 Mar 2006, John Stanton wrote:
Our approach to byte order independence was fairly simple, and worked
well with a mmap'd index
JP wrote:
Jay Sprenkle wrote:
Is there a way I can scroll thru a particular index? For example:
1. Scroll forward/backward on a given set of records
2. Start at position X
3. Start at a record that matches a criteria
SQL is optimized to manipulate a set of records. It's much faster to
.
Avoiding buffer shadowing seemed to be one big win, and the other was
letting the OS VM management take control.
JS
Nathan Kurz wrote:
On Wed, Mar 22, 2006 at 10:41:23AM +1100, John Stanton wrote:
The mmap'd index was about three times faster than when it
used a LRU paged cache.
I
If you want to use a lightweight DB like Sqlite and you are setting up
your own daemon and server situation then you can place the DB
synchronization function in the daemon around the Sqlite so that its
action is single streamed. In a similar situation we have installations
which manage many
Roger Gullhaug wrote:
Hi,
I'm writing an application that writes to SQLite at least once per
second. Is it wise to close the connection between each SQL call or is
it better to leave the connection open while the program is running?
This is a server application that will run for days and
杰 张 wrote:
> Hi,all
> I created a DATETIME field in a table. So how do it automatically INSERT
> INTO datetime data to the DATETIME field? Thank you so much!
>
>
> zhangjie
>
>
> -
> 雅虎1G免费邮箱百分百防垃圾信
If you have a DATETIME field as an
Tito Ciuro wrote:
Hello,
I'm trying to store a string and I get the following error:
unrecognized token: \"!\"\"
This happens with SQLite 3.2.7
Any ideas?
Thanks,
-- Tito
What is the string?
You have discovered sqLITE. For the features you need, go to an
sqlHEAVY such as Oracle, DB2 or PostgreSQL.
mohsen ahmadian wrote:
hello All
the sqlite cant lock db for security data base if i have a DB and must be
close from Other program and cant Open this DB ,this DBMS not protect DB by
Doug Nebeker wrote:
It sounds to me that he isn't saying it is leaking--it simply isn't
releasing memory after a SELECT statement finishes (is finalized). This
might be by design. I would expect the data to be released if the
database connection is closed, but not necessarily after each
Jay Sprenkle wrote:
On 3/16/06, Daniel Franke <[EMAIL PROTECTED]> wrote:
The original idea was to get rid of thousands of files to store their data
in one single container. Those (ASCII) files add up to approx 5GB ...
If so, are you trying to use a blender to stir the ocean?
You might
You might look to recoding your application to not use get_table, a
memory hog. Instead use step in a loop.
Jay Sprenkle wrote:
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC
2003).
ret =
Dennis Brakhane wrote:
On 3/9/06, John Stanton <[EMAIL PROTECTED]> wrote:
If two processes want to submit a
transaction, one must basically wait until the other finishes.
The problem with this is that the other process cannot finish. (See my
previous post)
Maybe I should file a bug
What you envisage was realized by the Pick database system from the
1970s. It had a "dictionary" to each table, and virtual fields could be
defined in the dictionary as expressions.
With SQL you might find that VIEWs and user defined functions might
adapt to your application.
JS
Eugen
For the person having difficulty with locking and busy with Sqlite it is
important to recognize the LITE in the name. A single file is used to
hold the entire database and each user process has that file open which
means that the locking is restricted to file locks, which essentially
lock the
Try an EXCLUSIVE TRANSACTION.
Dennis Brakhane wrote:
(In case it matters, im running SQLite 3.2.8)
Hi. I have a problem with multiple processes that use transactions on
the same database:
Suppose I have two processes that access the same database
Now, both do a "begin transaction", which
for SQLITE_BUSY.
So, for instance, I will implement the loop option. I will see later when I
will figure out how to manage SQLITE_LOCKED error.
Thanks
Ludovic
On 3/7/06, John Stanton <[EMAIL PROTECTED]> wrote:
It depends upon your application. What are you trying to do?
We use the server approach, with a simple daemon on the remote machine
which delivers its result in XML in accordance with the schema. It
works well.
Marian Olteanu wrote:
I would say that the best way to access a sqlite database mounted from a
remote file server, concurrently with other
is better than the other. :)
Thanks,
Ludovic
On 3/5/06, John Stanton <[EMAIL PROTECTED]> wrote:
I have a several of suggestions for that busy logic.
1. Perform a "yield()" or Win sleep(0) to give up the current
timeslice and thus have a busy wait with as little system impact
I have a several of suggestions for that busy logic.
1. Perform a "yield()" or Win sleep(0) to give up the current
timeslice and thus have a busy wait with as little system impact
as possible but fastest turnaround. An upper limit of 100 probes
before failing as deadlocked seems to
times,
as opposed the 'statistical' peaks in the sqlite-less
case.
Unless someone comes up with a similar timing description,
I herewith declare this 'dilemma' solved.
Thank you all for your help and sorry for the alarm.
Kind regards
Ulrich
On Wednesday 22 February 2006 23:41, John Stanton
Ulrich, try designing an experiment which removes SQLITE and measures
the performance of the other software layers. That might resolve your
dilemma.
JS
Ulrich Schöbel wrote:
Hi Richard,
thanks for trying to reproduce my 'problem'.
I'm using Linux 2.6.12 (Ubuntu Breezy Badger, a debian
Take the -g out of the compiler directives in the makefile to prevent
debug code being generated. You might do well to add -O2 for
optimization. Your library will be much smaller.
JS
jam_lraep wrote:
Hi sqlite-users-help,
I have compiled SQLITE with MINGW and the resultant library
en neither of these is the case.
Surely you can see that even a different constant error message in this
context would be preferable? SQLITE_WRITE_FAILED or something?
As I say, I'm just altering the standard error text at the moment,
because it is misleading.
Steve
-Original Message-----
The first message informs all users of the problem. The one you propose
might satisfy a technonerd, but confuse the more casual user. There is
however a case for writing such a detailed message to syslog or similar
system log.
Dave Dyer wrote:
It is a reasonable assumption to make that the
Since the file access has already worked by this stage the "plethora" is
far smaller than you may have appreciated. It is a reasonable
assumption to make that the only thing which can have changed since the
last write is the disk becoming full. A disk cable falling off, head
crash or
this to SQLite mail-list.
Fanda
On Tue, 07 Feb 2006 22:35:09 +0100, John Stanton <[EMAIL PROTECTED]>
wrote:
Jim C. Nasby wrote:
On Mon, Feb 06, 2006 at 05:30:39PM +0100, Laurent Goussard wrote:
Hi there,
I use SQLite on my website for 2 years now. I do like SQLite a lot and
wi
Jim C. Nasby wrote:
On Mon, Feb 06, 2006 at 05:30:39PM +0100, Laurent Goussard wrote:
Hi there,
I use SQLite on my website for 2 years now. I do like SQLite a lot and
will use it for a lot of new web projects but, because I got more and
more traffic, I consider to move this one to MySQL in
You don't have much text so you can easily take your choice, flat file
or DBMS. The decision would be one based on how you intend to use the text.
Eugen Stoianovici wrote:
I need some help...I'm writing an app which scans some pictures and then
performs ocr on those pictures saving a text
For a tool to be thoughtfully designed to remove DLL HELL is a great
strength, not a weakness. Tools should be robust and reliable and work
when all else is failing, and Sqlitespy is in that genre.
Steve O'Hara wrote:
Hi Ralf,
SqliteSpy is a nice tool but this is a weakness, not a strength
I use a program which converts a simple SQL result into XML. It is just
a C program calling Sqlite. You are welcome to a copy if it would help you.
JS
pavan savoy wrote:
-- Forwarded message --
From: pavan savoy <[EMAIL PROTECTED]>
Date: Jan 31, 2006 7:17 PM
Subject: Does
Your problem is probably in linking. Try compiling without debug ( no
-g). That worked for me on AIX 4.2.
Bauer, Christoph wrote:
Hi,
SQLite 3.2.8 and 3.3.2 does'nt compile on an AIX machine. I suspect libtool
to call the linker with wrong arguments.
/libtool --mode=link cc -g
Fred makes a good point. A well conceived software solution is a good
investment and a slipshod, makeshift solution not an investment but an
ongoing liability. We have some software which was carefully thought
through initially and has been in constant national use for close to
twenty years
Marten makes good points. I would go further and suggest that you look
at creating your own API and DB primitives for your application. Often
you will find that trying to shoehorn general purpose tools into tightly
specific applications is as much effort as rigorously defining the
problem
Imagine how different the IT world would be if Microsoft had hired
computer scientists instead of lawyers. We can but dream.
[EMAIL PROTECTED] wrote:
"Robert Simpson" <[EMAIL PROTECTED]> wrote:
Not quite so straightforward in Windows:
Seems like nothing ever is. (sigh) My life would
Alexander,
I like your general concept. Some years ago I implemented a somewhat
similar strategy in a product of ours which was SQLite-like in that it
linked into each application process and managed B-Trees. By
identifying read-only transactions and handling them in a simple manner
Since you are using a time your could try using a trigger which deleted
the row with the oldest (lowest) time. You would need to have an index
on the timestamp. I guess something like timestamp > 0 LIMIT 1 might work.
Sean Machin wrote:
Hi All,
I'm considering using SQLLite for an embedded
Will Leshner wrote:
On Dec 20, 2005, at 7:46 AM, John Stanton wrote:
I haven't looked closely at the problem, so these are just first
ideas extending CM's approach. Basically there should be no reason
to perform any analysis of the SQL since that has already been done
I haven't looked closely at the problem, so these are just first ideas
extending CM's approach. Basically there should be no reason to perform
any analysis of the SQL since that has already been done and the
metalanguage generated. My approach would be to prepare the SQL
statement and then
It looks as if you need to download the GNU make and compile it for
Irix. Try installing it as "gmake" and then execute gmake instead of make.
JS
Prettina Louis wrote:
hello sir,
I am trying to install Sqlite-3.2.7 in Irix 6.5 version OS.
As mentioned in the README file, I gave the
Thanks again,
--
BP
<< www.planet-hood.com >> Welcome to our world <<
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005 1:07 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Threads and locking
Have you thought
Have you thought of using a lock to synchronise access to the databaseso
that only one thread at a time could change the database although both
could read simultaneously?
JS
Barry Paul wrote:
Hi, I am having some unexpected locking issues with SQLite.
I have a desktop application that uses
surprise...
since a solution to this issue is fairly simple, and the applicable audience is large, why not provide one?
the fact that MSSQL will not be able to do the same is not an argument that has stopped drh before, has it.
________
From: John Stanton [mailto:[EMAIL PR
Dennis Cote wrote:
John Stanton wrote:
Brad wrote:
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be
stored in
the database and they should be compared.
If the class you're using has .Value property
Brad wrote:
I am looking for a simple way of using date and time values with
sqlite3. I have some Ctime classes (VC++.net) which have to be stored in
the database and they should be compared.
If the class you're using has .Value property, or a way to easily
transform the date from one format
an answer to the questions you thought you asked, but
IMHO it does provide
"other information 'I' feel would help YOU on YOUR journey"
Marc
John Stanton wrote:
john.newby wrote:
Hi, I am doing my final year project/dissertation on "Creating a GUI to
SQLite"
I am after hel
You have pointers to the compiled SQL statements. You should be able to
track when the destination of those pointers changes. I haven't had the
need to do it, but it is where I would go if careful examination of the
code did not reveal the error.
JS
Eric Scouten wrote:
If it were easy to
1101 - 1200 of 1253 matches
Mail list logo