Hi All,
I'm using sqlite 3.2.0 - the native C/C++ interface. I'm seeing
something that I haven't seen before. I have 4 programs accessing the
same db file. The db file is on a slow Windows network share (NAS
device). The 4 programs are the only processes accessing the DB file
and all of them
On 21 Jun 2005, at 15:41, Darren Duncan wrote:
At 1:29 PM -0400 6/21/05, Matt Sergeant wrote:
1.09 is now on CPAN. Note that there's a weird bug when trying to
compile against the system sqlite on OS X Tiger due to some munging
Apple have done to the header files. Someone is supplying me with
At 1:29 PM -0400 6/21/05, Matt Sergeant wrote:
1.09 is now on CPAN. Note that there's a weird bug when trying to
compile against the system sqlite on OS X Tiger due to some munging
Apple have done to the header files. Someone is supplying me with a
work-around.
I noticed that upload before
On 20 Jun 2005, at 06:57, Randy J. Ray wrote:
I just sent a patch to the maintainer of the DBD::SQLite package, that
lets it
build against an installed version of the library. The current package
carries
a copy of the code with it, and builds it locally. With this patch,
you can
update your
From a quick check of the sources, I didn't see anyway to disable
locking for a database. Correct? Would it be useful to have a pragma
to simply turn off locking for a database?
--
Ted Unangst www.coverity.com Coverity, Inc.
On Sun, 2005-06-19 at 22:29 -0400, D. Richard Hipp wrote:
> Essentially the same talk will likely be repeated
> at other venues. I will keep you posted.
If you cannot make it to OSCON or AUUG, the next
opportunity to hear the SQLite Internals tutorial
will be at the 12th Annual Tcl/Tk Conference
On Tue, 2005-06-21 at 06:18 -0400, Ken & Deb Allen wrote:
> Will declaring the column as VARCHAR not achieve the same thing? Does
> SQLITE not translate VARCHAR to TEXT, rather than numeric?
>
VARCHAR, TEXT, and CLOB are all the same thing.
See http://www.sqlite.org/datatype3.html section 2.1
Hallo Daniel,
on Windows you can use WideCharToMultiByte and MultibyteToWideChar to
convert from and to UTF8. I would recommend to use utf8 in the DB
because it is a pretty good standard and being using in Mac OS X, Java,
Solaris/Linux, HTML, and others. Windows uses either 8 bit client
Will declaring the column as VARCHAR not achieve the same thing? Does
SQLITE not translate VARCHAR to TEXT, rather than numeric?
-ken
On 21-Jun-05, at 5:10 AM, D. Richard Hipp wrote:
On Tue, 2005-06-21 at 00:13 -0400, Tito Ciuro wrote:
Hello,
When I add text to the database, it's getting
On Tue, 2005-06-21 at 00:13 -0400, Tito Ciuro wrote:
> Hello,
>
> When I add text to the database, it's getting truncated because
> SQLite is converting it to a number. For example, I enter "9.0", but
> SQLite stores it as "9".
>
> Is there a way to force the value to be inserted as string?
Hello Puneet,
PK> Pre-process the log file, creating a hash with the unique field as the
PK> key. Then, loop over the hash and insert it in your db.
PK> If memory is a constraint, don't bother even creating a hash. Loop over
PK> the log file, create an array, sort the array, remove the
11 matches
Mail list logo