Interesting, I'll give that a try, thanks. Good to know I'm not going crazy...
my worry with this kind of thing is always that my memory management is not
bulletproof and is having a knock-on effect somewhere.
Thanks
Ray
-Original Message-
From: sqlite-users-boun...@
mpile the sqlite3.c module WITHOUT optimizations, the crash
goes away, but this is obviously FAR from ideal.
Has anyone else experienced this? Is there anything I can do to narrow down
the problem, or is there anyone I could report this to?
Thanks
Ray
This e
Simon:
Thank you - let me run all this to ground.
Ray
On Sep 10, 2011, at 12:40 PM, Simon Slavin wrote:
>
> On 10 Sep 2011, at 8:28pm, Ray wrote:
>
>> I am using the Sqlite3 API.
>>
>> Why is so much free disc required?
>
> The error you reported means &
My mistake - sorry!
On Sep 10, 2011, at 12:30 PM, Richard Hipp wrote:
> On Sat, Sep 10, 2011 at 3:28 PM, Ray wrote:
>
>> I am using the Sqlite3 API.
>>
>
> If you are using the sqlite3 API, then why is the warning message about the
> sqlite2 API? Is that a bug
I am using the Sqlite3 API.
Why is so much free disc required?
I will the real answers from my hosting service
Sent from my iPad
On Sep 10, 2011, at 12:09 PM, Simon Slavin wrote:
>
> On 10 Sep 2011, at 7:47pm, Ray Irvine wrote:
>
>> [09-Sep-2011 09:10:20] PHP Warnin
Sample message:
[09-Sep-2011 09:10:20] PHP Warning: sqlite_exec() [function.sqlite-exec]: database is full in
/home/xx/00build/include/t02enterreg.inc on line 738
On Sep 10, 2011, at 11:43 AM, Luuk wrote:
> On 10-09-2011 19:45, Ray wrote:
>>
>> I am using sqlite on an a
I am using sqlite on an application that run on a hosting service. After some
18 months, I have started to see a few database is full warnings from my PHP
application. I will receive a warning but all appears well with the database.
The application uses four databases and the warning has o
round FTS3?
Using sqlite 3.7.4 on Fedora 14.
Thanks,
Ray
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks. You remind me those NULs :)
On Feb 8, 12:12 am, "Igor Tandetnik" wrote:
> Ray wrote:
> > What's the actual type of blob in the callback of sqlite3_exec? Is it
> > string or remains binary?
>
> Bytes are reported as-is, with an added zero termin
Hi guys,
What's the actual type of blob in the callback of sqlite3_exec? Is it
string or remains binary? Since when I query the database to get all
rows and columns the blob values are not same as what I get from other
SQLite tools.
___
sqlite-users mail
Hi All,
Does anyone know if ICU supports tokenization of Japanese text?
Thanks
Ray
This e-mail message, including any attachments, is for the sole use of the
person to whom it has been sent, and may contain information that is
confidential or legally protected. If you are not the intended
disposition of my e-mail?
Thank you
Begin forwarded message:
> From: Ray Irvine
> Date: March 1, 2010 8:52:27 AM PST
> To: sqlite-users@sqlite.org
> Subject: Fwd: Maybe just a Question
>
>> I did not get an e-mail response and the status check URL has expired.
>> Thank
column (say B), the first column (A) is set to the current
> value of the second (B).
>
> THis is all being run on an IMAC using MACOS X version 10.6.2. I have not
> run these test on another a system.
>
> Is there something that I am missing?
>
> Thank you for your assist
. I have not run
these test on another a system.
Is there something that I am missing?
Thank you for your assistance.
Best Regards,
Ray
Ray Irvine
Crew's Nest - #1383
c34irvine1...@comcast.net
http://www.flickr.com/photos/crews_nest/
___
sq
Hello.
My name is Ray Gold with Berliner, Corcoran & Rowe, LLP in Washington, DC.
I am writing to ask if the core SQLite library (not the proprietary
SQLite Extensions) has any encryption/decryption capabilities.
Thanks very much for your help!
On Sep 3, 2007, at 1:56 PM, Marco Antonio Abreu wrote:
Hi Ray,
Look at version 3.4.0 (2007 june 18), third item.
- Added explicit upper bounds on the sizes and quantities of things
SQLite can process. *This change might cause compatibility
problems* for
applications that use SQLite in the
.
Should it just be assumed that any version change breaks all binary
compatibility with earlier versions? Is this done deliberately? Or is
there somewhere else that issues relating to binary compatibility of
data files between versions is documented?
thanx - ray
I have been unable to get this package to compile under Linux. Do you use it
in Linux, or Windows?
--
Randy J. Ray / [EMAIL PROTECTED]
Campbell, CA
as numerical for the sake of sorting?
Randy
--
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Randy J. RayCampbell, CAhttp://www.rjray.org [EMAIL PROTECTED]
Silicon Valley Scale Modelers: http://www.svsm.org
s,
> Vishal Kashyap.
> http://www.vishal.net.in
>
--
Ray Mosley
t being maintained.
Randy
--
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Randy J. RayCampbell, CAhttp://www.rjray.org [EMAIL PROTECTED]
Silicon Valley Scale Modelers: http://www.svsm.org
qlite.org/cvstrac/wiki?p=ConsoleForTclTk
>
> That program gives you a GUI. But the GUI just has a command-line
> prompt into which you type SQL statements. It is no more capable
> than the command-line shell.
>
>
>
--
Ray Mosley
>>Java libraries linked with C (via JNI) generally have to run with the exact
>>same version of Java they were built with.
>
> Uh-oh, Sun advertises something else.
Hmm... I may have been confused in the matter by having had (unrelated)
problems. I would go with what Sun advertises.
Randy
--
[E
> Uh, why isn't your first choice simply, "Use SQLite from Java"?
> Surely calling C libraries is something the Java folks have worked out
> how to do many years ago? Or what am I missing here? What is the
> attraction of "pure Java"?
Java libraries linked with C (via JNI) generally have to run
se, and grows the db file by bigger
> >>>chunk(e.g. grow by 20% or so in size each time)?
> >>
> >>
> >>
> >>Why not do a vacuum every 10th time (or something similar) you exit the
> >>program?
> >>
> >>---
> >>The Castles of Dereth Calendar: a tour of the art and architecture of
> >>Asheron's Call
> >>http://www.lulu.com/content/77264
> >>
> >>
> >
> >
> >
>
>
> --
> Ben Clewett
> +44(0)1923 46
> Project Manager
> Road Tech Computer Systems Ltd
> http://www.roadrunner.uk.com
>
>
--
Ray Mosley
website and searching Google groups
> to try to find a migration guide for going from sqlite 2 to sqlite 3.
> Can anyone point me to such a guide?
>
> Thanks.
>
> Richard
>
>
--
Ray Mosley
s a SQLITE_LOCKED then you need
> to
> sleep for some random amount of time and retry -- with hopefully an
> eventual
> timeout mechanism in place.
>
> Robert
>
>
>
--
Ray Mosley
, is for the sole use of the intended recipient(s)
> and may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy all
> copies of the original message.
>
--
Ray Mosley
; keep trying to obtain a lock? You can set the wait time to a short value
> and just repeat until the user cancels or it works.
>
--
Ray Mosley
> Opinions are not necessarily those of Misys Healthcare Systems nor its
> board
> of directors.
>
--
Ray Mosley
I started using 2.8 because I still have Tcl 8.3; If I convert to Tcl 8.4 to
go to SQlite 3, how do I convert databases?
--
Ray Mosley
Steve,
I works very similar to ADO. Except no Data Control
Ray
Steve O'Hara <[EMAIL PROTECTED]> wrote:
How does a C++ wrapper help someone using VB6?
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of RAY BORROR
Sent: 29 July 20
I am using SQLite Plus sucessfully
Ray Borror
Gregory Letellier <[EMAIL PROTECTED]> wrote:
all the wrapper ar for 2.8 and i wan't use the 3.0
anyone known 3.0 wrapper ?
Steve O'Hara a écrit :
>Don't want to dampen your enthusiasm for this route but. why do you
>
timeout value, or
only one?
Thanks.
--
Ray Mosley
t; >foreach ...
> > >append tran_string "\n"
> > >append tran_string "END TRANSACTION\nCOMMIT TRANSACTION"
> > >DB eval "$tran_string"
> > Ray,
> > Someone may pipe in to correct me, but this is my understanding..
> > BEGIN TRAN
t;END TRANSACTION\nCOMMIT TRANSACTION"
DB eval "$tran_string"
Thanks for the help.
--
Ray Mosley
---
> Stephen D. Miller
> Software & Networking Solutions Consultant
> ThinkGear, Inc.
> (888) 5-THINKGEAR / www.thinkgear.com <http://www.thinkgear.com>
>
>
>
--
Ray Mosley
I just heard back from my contact, and they do not video the tutorials.
Generally, the tutorial teachers don't want this anyway, as they sell the same
tutorial to other companies (and a cheap DVD would undermine that). I suppose
that, in theory, Dr. Hipp could arrange to have his own person there r
stay in sync.
Not sure about the maintainer's schedule, but I imagine we'll see a release in
the next few days.
Randy
--
""""""""""""""""""""""""""""
27;ll ask a friend at ORA and
see what he says.
Randy
--
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Randy J. RayCampbell, CAhttp://www.rjray.org [EMAIL PROTECTED]
Silicon Valley Scale Modelers: http://www.svsm.org
Users,
I am wanting to connect to a SQLite DB with CRW.
Has anyone had any experience doing this?
I was thinking of using the SQLite ODBC Driver.
Any help would be appreciated
Ray Borror
, disclosure or distribution of this message
> is strictly forbidden. If you have received this transmission in error,
> please notify the sender immediately and delete it.
> __
>
--
Ray Mosley
following error:
VisData
The following Error occurred
OBDC-call failed
Number 3146
If I create a new DB in SQLite, I am able to export one table without a problem.
It doesn't seem to matter which table it is.
Please review and advise of any possible solutions.
Thanks,
Ray Borror
Jay wrote:
> SQLite version 3.1.2
> Enter ".help" for instructions
> sqlite> select datetime('now');
> 2005-03-26 00:44:37
> sqlite> .quit
> zenobia # date
> Fri Mar 25 18:44:48 CST 2005
> zenobia #
>
> Is this because I don't have the timezone set?
The time you are getting from SQLite is in GMT.
Christian Smith wrote:
For non-text data, SQLite 3.x has more efficient storage, as binary data
is stored in binary format and not text format. I've heard figures such as
25% savings on disk space bandied about, but YMMV. The storage is not
binary compatible with SQLite 2.8.x files, and SQLite 3 ca
--
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Randy J. RayCampbell, CAhttp://www.rjray.org [EMAIL PROTECTED]
Silicon Valley Scale Modelers: http://www.svsm.org
(now I just have to work out a release/migration strategy - since a raw
CPAN install will break people's apps).
I would suggest renaming it to DBD::SQLite3, since the underlying library
itself looks to be embedding "3" into most (if not all) API hooks anyway.
Are there any plans to have the opti
There's also a cool TIFF logo contributed by Apple at
http://www.sqlite.org/cvstrac/getfile/art/SQLiteLogo3.tiff
After bouncing around for a while, I get:
302 Moved Temporarily
Randy
--
[EMAIL PROTECTED] http://www.rjray.org http://www.svsm.org
Always code as if the guy
[EMAIL PROTECTED] wrote:
Anyway, I looked through sqlite.org but couldn't find how to properly open
an sqlite database in read-only mode. If any knows how to do so
(preferably in TCL binding), please let me know.
According to the docs on the C/C++ bindings, the "mode" argument to open() does
this
H. Wade Minter wrote:
In DBD::SQLite, what's the proper way to get the number of rows
returned by a query? for example:
$query = "SELECT * FROM foo WHERE bar LIKE '%baz%'";
$sth = $dbh->prepare($query);
$sth->execute;
$numrows = $sth->rows; # DOES NOT WORK, ALWAYS RETURNS -1
From the DBI manpage:
No, this won't work (not even with the correction, which is still not correct
code).
To export a database, you need more than just the contents. You need the
structure (schema), indices, constraints, etc. All of this can be created using
the DBD::SQLite driver, but you have to have the informat
51 matches
Mail list logo