Follow up, eventually I got it working by using the following;
http://fabianpeter.de/cloud/owncloud-migrating-from-sqlite-to-mysql/
Pretty dirty, but it got the job done... took me 6 *hours* to discover
this fix, it's untested/alpha as hell and I didn't even write the
code.
Hopefully this helps
On 2015-02-12 14:00, Stephan Beal wrote:
On Thu, Feb 12, 2015 at 2:45 PM, jus...@postgresql.org wrote:
And yeah, I'm aware of fossil, but (to my thinking ;) that
shouldn't hold
back _this_ bit of software. ;)
FWIW, fossil was/is designed _specifically_ for sqlite's hosting
(that's
neither a
Tnx for email. I'm in a meeting. Reply later.
On 2/12/15, Cal Leeming c...@iops.io wrote:
Thanks for the quick reply, appreciated.
I've been having a problem where iterdump() is exporting in a format
which is unsuitable for MySQL, although it previously appeared to be
corruption (hence the
Thanks for the quick reply, appreciated.
I've been having a problem where iterdump() is exporting in a format
which is unsuitable for MySQL, although it previously appeared to be
corruption (hence the previous comment of seriousness), it does
actually appear to be documented incompatibility.
On 2015-02-12 13:40, Richard Hipp wrote:
On 2/12/15, Cal Leeming c...@iops.io wrote:
Also, I'd like to +1 having this project on some sort of social
collab
platform, be it github, bitbucket etc. It would make external
contributions much easier, as I nearly gave up trying to report this
issue
On Thu, Feb 12, 2015 at 2:45 PM, jus...@postgresql.org wrote:
And yeah, I'm aware of fossil, but (to my thinking ;) that shouldn't hold
back _this_ bit of software. ;)
FWIW, fossil was/is designed _specifically_ for sqlite's hosting (that's
neither a joke nor an exaggeration), so it's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/12/2015 05:15 AM, Cal Leeming wrote:
I've been having a problem where iterdump() is exporting in a
format which is unsuitable for MySQL,
iterdump is part of pysqlite, and has no code from the official SQLite
project. iterdump itself is just
On Mon, 02 Feb 2015 12:59:55 +0200
Török Edwin edwin+sqli...@etorok.net wrote:
Would it be possible to raise that limit, or output a better error
message that says why it failed to open the file?
Maybe. open(2) should return ENAMETOOLONG. It is possible, though
unlikely these days, that the
Hi,
I was testing long pathnames and ran into this failure:
$ sqlite3
2015-02-02 11:59 GMT+01:00 Török Edwin edwin+sqli...@etorok.net:
Would it be possible to raise that limit, or output a better error message
that says why it failed to open the file?
My suggestion would be to add something like this to sqliteLimit.h:
/*
** Maximum supported
Hi Navin,
Excuse me if some of the points below repeat things you already know.
1. Dr. Hipp's advice not to create redundant indexes was *not* intended to
give you very quick row counts -- Simon Slavin et al had already given
advice to speed up row counts -- and just now Stefen Keller even
Hi,
On Monday 26 January 2015 12:35 AM, Navin S Parakkal wrote:
On Saturday 24 January 2015 03:15 PM, Stefan Keller wrote:
I think it's time for a serious simple benchmark with sqlite and say
PostgreSQL.
PostgeSQL also had performance problems time ago but this has been
resolved.
Can you
Hi Navin
I've compared with PostgreSQL. It's twice as as fast as SQLite with
100 mio. records on my old laptop - but still too slow using count().
So, as Eduardo suggested, you have to solve this problem with a
separate table and triggers, like shown below.
Yours, S.
-- Create test table
On Saturday 24 January 2015 03:15 PM, Stefan Keller wrote:
I think it's time for a serious simple benchmark with sqlite and say PostgreSQL.
PostgeSQL also had performance problems time ago but this has been resolved.
Can you describe the hp_table1 schema (CREATE TABLE statement...) and
some
; d...@hwaci.com
Subject: Re: [sqlite] sqlite3 very slow even after creating without rowid
Hi,
I also did another experiment. I created this table and did a vaccum
and then the select count(*) in sqlite3 was around 2 mins.
When I create an index manually after the table is loaded (imported
from
On Tue, 20 Jan 2015 12:12:00 +
Parakkal, Navin S (Software Engineer) navin.parak...@hp.com wrote:
Hello,
I've few questions about sqlite3 , the database it creates.
Actually I'm finding lot of differences in performance.
My story:
I have this sqlite3 database called hp.db
[mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Parakkal, Navin S (Software Engineer)
Sent: Friday, 23 January, 2015 11:05
To: General Discussion of SQLite Database; d...@hwaci.com
Subject: Re: [sqlite] sqlite3 very slow even after creating without rowid
Hi,
I also did another experiment. I
Hi,
Relying on sequence will not work (and is a wrong hack) since the use
case includes deleting rows explicitly.
I think it's time for a serious simple benchmark with sqlite and say PostgreSQL.
PostgeSQL also had performance problems time ago but this has been resolved.
Can you describe the
Jim Wilcoxson wrote:
If you have a table where rows are inserted but never deleted, and you
have a rowid column, you can use this:
select seq from sqlite_sequence where name = 'tablename'
This works only for an AUTOINCREMENT column.
This will return instantly, without scanning any rows or
If you have a table where rows are inserted but never deleted, and you
have a rowid column, you can use this:
select seq from sqlite_sequence where name = 'tablename'
This will return instantly, without scanning any rows or indexes, and
is much faster than max(rowid) for huge tables.
If no rows
Repost: Since it didn't get into the archives or in the mailing list. Sorry
about that.
Quoted and replied to simon after [Repost End]
Hello,
[Repost Begin]
My Process.csv is around 27G. I've gzipped it and put at
ftp://navinps:sqlit...@h2.usa.hp.com as process.csv.gz
There is only 1 file
Hi,
I also did another experiment. I created this table and did a vaccum and then
the select count(*) in sqlite3 was around 2 mins.
When I create an index manually after the table is loaded (imported from
csv), select count(*) in sqlite3 was within 30 to 40 secs.
In the second case, to
Hello,
My Process.csv is around 27G. I've gzipped it and put at
ftp://navinps:sqlit...@h2.usa.hp.com as process.csv.gz
There is only 1 file there.
md5sum process.csv.gz
e77a322744a26d4c8a1ad4d61a84ee72 process.csv.gz
[root@centosnavin sqlite-autoconf-3080801]# cat sqlite3commands.txt
On 23 Jan 2015, at 3:16pm, Parakkal, Navin S (Software Engineer)
navin.parak...@hp.com wrote:
I also did another experiment. I created this table and did a vaccum and then
the select count(*) in sqlite3 was around 2 mins.
When I create an index manually after the table is loaded
On 1/20/15, Parakkal, Navin S (Software Engineer) navin.parak...@hp.com wrote:
Hello,
I've few questions about sqlite3 , the database it creates. Actually I'm
finding lot of differences in performance.
My story:
I have this sqlite3 database called hp.db which is like 100+ million
Hello,
I've few questions about sqlite3 , the database it creates. Actually I'm
finding lot of differences in performance.
My story:
I have this sqlite3 database called hp.db which is like 100+ million
records for table1. The size of hp.db on Linux x64 (CentOS 7) is like 16 GB.
On 20 Jan 2015, at 12:12pm, Parakkal, Navin S (Software Engineer)
navin.parak...@hp.com wrote:
When I do a select count(*) on hp_table1 it takes more than 5 mins which
is quite a huge time.
If this is a table for which rows are inserted but never deleted, then you will
find that
SELECT
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
I can supply a sample database to anyone interested in investigating.
--
F:\2013 YearTech\Yearbook Tools\Resourcesqlite3 -version
3.7.3
Not, at least, when your database contains string data with unusual
characters that Windows feels like it should translate for you...
Who can guarantee what characters are used in all their text strings,
much less guarantee what unnamed transformations windows is helpfully
doing to pipe data.
I'm skeptical of the notion that cmd.exe is diddling with your data en
route to the pipe. I can't think of a time Windows munged my data in
that particular way despite more years using that lousy tool than I
care to remember. Quotes and escapes, sure, don't get me started.
I would echo
But that doesn't explain the difference between redirecting to a file
and redirecting to a pipe.
using .output file works
using to direct stdout to a file works and produces the same file as .output
using .read file works
using file does not work.
using | to shortcut and doesn't work.
On 1/17/15, Dave Dyer ddyer-sql...@real-me.net wrote:
But that doesn't explain the difference between redirecting to a file
and redirecting to a pipe.
using .output file works
using to direct stdout to a file works and produces the same file as
.output
using .read file works
using file
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/17/2015 12:20 PM, Graham Holden wrote:
I would echo this: it's good at mangling the command-line, but
I've not been aware of it ever mangling data sent to a file/stream
(other than the binary/text mode conversions).
In text mode (the default
On Fri, 16 Jan 2015 14:31:40 -0800
Random Coder random.co...@gmail.com wrote:
If you're seeing the Error: The specified procedure could not be
found. error, and you're not specifying an entry point in the .load
command, then no doubt the sqlite3_load_extension symbol isn't
properly exported.
On Fri, 16 Jan 2015 16:24:21 -0700
Keith Medcalf kmedc...@dessus.com wrote:
1. The architecture of an executable file, x86 or x64.
dumpbin -- comes with the dev kit
I would have thought so, but I didn't find an option that reports it.
Importantly make sure you are exporting C names.
.once '| sqlite3 new.db'
.dump
.Once is not a command in the version of sqlite3 I use.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 1/17/15, Dave Dyer ddyer-sql...@real-me.net wrote:
OK. Dave, please try this patch at let us know if it works better for
you: https://www.sqlite.org/src/info/80541e8b94b7
It needs #include fcntl.h to compile in my sources.
With that, it seems to fix the problem.
The fcntl.h has been
On Jan 17, 2015 7:29 PM, Dave Dyer ddyer-sql...@real-me.net
Here in the real world, when everything is working, we ask why upgrade.
But it wasn't working correctly so the statement doesn't really answer the
question asked. :)
___
sqlite-users mailing
The fcntl.h has been in shell.c since 3.8.6. We are on 3.8.8. Why
not upgrade?
--
Here in the real world, when everything is working, we ask why upgrade.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 1/17/15, Roger Binns rog...@rogerbinns.com wrote:
The bug in the SQLite shell is that it tries to manage the encoding
itself, which is fine if the file is in binary mode. But with
stdin/out in text mode doing so will lead to extra data mangling. The
shell needs to change stdin/out to
OK. Dave, please try this patch at let us know if it works better for
you: https://www.sqlite.org/src/info/80541e8b94b7
It needs #include fcntl.h to compile in my sources.
With that, it seems to fix the problem.
___
sqlite-users mailing list
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
I can supply a sample database to anyone interested in investigating.
--
F:\2013 YearTech\Yearbook Tools\Resourcesqlite3 -version
3.7.3
On 1/16/15, Dave Dyer ddyer-sql...@real-me.net wrote:
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
I can supply a sample database to anyone interested in investigating.
Is the database
On 1/16/15, Dave Dyer ddyer-sql...@real-me.net wrote:
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
I can supply a sample database to anyone interested in investigating.
Rather than the
On 16 Jan 2015, at 6:38pm, Dave Dyer ddyer-sql...@real-me.net wrote:
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
Which version of Windows are you using ? You can type 'ver' at the
Rather than the full database, can you show us the full schema of this
database, including triggers?
It's a very simple database, no triggers or coalitions. The
problem is most likely a buffer overrun because of a very long
literal string field.
I've sent a minimal sample to drh
On 1/16/15, Dave Dyer ddyer-sql...@real-me.net wrote:
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
The pipe method works fine for me on Linux.
I'm guess this is a case of the windows
The pipe method works fine for me on Linux.
I'm guess this is a case of the windows command-line shell doing some
character translations in the pipe, rather than just shipping the
bytes through the pipe unaltered.
Ouch. That basically means the pipe method shouldn't ever be
used on windows.
The pipe method works fine for me on Linux.
I'm guess this is a case of the windows command-line shell doing some
character translations in the pipe, rather than just shipping the
bytes through the pipe unaltered.
Ouch. That basically means the pipe method shouldn't ever be
used on windows.
On 1/16/15, Dave Dyer ddyer-sql...@real-me.net wrote:
The pipe method works fine for me on Linux.
I'm guess this is a case of the windows command-line shell doing some
character translations in the pipe, rather than just shipping the
bytes through the pipe unaltered.
Ouch. That basically
I'm guess this is a case of the windows command-line shell doing some
character translations in the pipe, rather than just shipping the
bytes through the pipe unaltered.
Ouch. That basically means the pipe method shouldn't ever be
used on windows.
Not, at least, when your database contains
On 16 Jan 2015, at 9:01pm, Keith Medcalf kmedc...@dessus.com wrote:
Not, at least, when your database contains string data with unusual
characters that Windows feels like it should translate for you...
I think that pretty much limits one to the 7-bit ASCII character set ...
Why on earth
Not, at least, when your database contains string data with unusual
characters that Windows feels like it should translate for you...
Who can guarantee what characters are used in all their text strings,
much less guarantee what unnamed transformations windows is helpfully
doing to pipe data.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/16/2015 01:05 PM, Simon Slavin wrote:
Why on earth would an operating system programmer bother to put any
translation into piping
You have a system with a bunch of apps installed. You then upgrade to
a new version of the operating system and
On Fri, Jan 16, 2015 at 2:02 PM, Dave Dyer ddyer-sql...@real-me.net wrote:
the input side of the pipe. Perhaps there is some windows conditioning
that ought to be done by sqlite, on STDIN, to make it into a binary data
source ?
You should be able to do a freopen(NULL, rb, stdin); to change
Hello all,
I had the bright idea yesterday of trying to use an extension module in
Windows. I found myself a bit confused, and the messages and
documentation were not as helpful as they might have been. I suspect I
had a 32/64 bit mismatch in one case, and that sqlite3 wasn't compiled
with
On Friday, 16 January, 2015 14:05, Simon Slavin slav...@bigfraud.org said:
On 16 Jan 2015, at 9:01pm, Keith Medcalf kmedc...@dessus.com wrote:
Not, at least, when your database contains string data with unusual
characters that Windows feels like it should translate for you...
I think that
On Fri, Jan 16, 2015 at 2:21 PM, James K. Lowden
jklow...@schemamania.org wrote:
5. The 32-bit windows sqlite3 shell supports extensions?
Yes, it does. The version on sqlite.org is compiled with that support.
6. The above messages come from the OS, and result from LoadLibrary
failing?
On Fri, 16 Jan 2015 10:38:54 -0800
Dave Dyer ddyer-sql...@real-me.net wrote:
[$] sqlite3 po.sqlite .dump | sqlite3 po2.sqlite
Error: incomplete SQL: INSERT INTO imageblob VALUES(1,'G:\share
Perhaps try -echo, to display the incomplete SQL?
I'm skeptical of the notion that cmd.exe is
You have a system with a bunch of apps installed. You then upgrade to
a new version of the operating system and a whole bunch of the apps
break. Do you think people blame the apps or the operating system?
Do you think anyone takes the apps apart and blames them for using the
wrong apis despite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/16/2015 02:35 PM, James K. Lowden wrote:
I'm skeptical of the notion that cmd.exe is diddling with your data
en route to the pipe.
Almost certainly the reason is that stdout and stdin are in character
mode. It requires extra code to put them
On 16 Jan 2015, at 10:27pm, Keith Medcalf kmedc...@dessus.com wrote:
[snip] The long and the short of it is that the interprocess pipe in Windows
connects to cooked channels because it never occurred to anyone at Microsoft
that this was undesirable and irrational.
Thanks for this long
On Fri, Jan 16, 2015 at 3:48 PM, Keith Medcalf kmedc...@dessus.com wrote:
You have a system with a bunch of apps installed. You then upgrade to
a new version of the operating system and a whole bunch of the apps
break. Do you think people blame the apps or the operating system?
Do you
I had the bright idea yesterday of trying to use an extension module in
Windows. I found myself a bit confused, and the messages and
documentation were not as helpful as they might have been. I suspect I
had a 32/64 bit mismatch in one case, and that sqlite3 wasn't compiled
with
@sqlite.org
Sent: Sun, Dec 28, 2014 12:16 pm
Subject: Re: [sqlite] SQLite3 internal performance
Hi Edward,
On 25 December 2014 at 19:33, Edward Lau elau1...@aim.com wrote:
Hi Folks:
I have read in many posting that SQLite is fast. How fast is fast? So over
this holiday break I tried to take
Hi Edward,
On 25 December 2014 at 19:33, Edward Lau elau1...@aim.com wrote:
Hi Folks:
I have read in many posting that SQLite is fast. How fast is fast? So over
this holiday break I tried to take a reading on the VDBE performance to get a
general idea. I wrote a quick module to enable me
Hi Folks:
I have read in many posting that SQLite is fast. How fast is fast? So over
this holiday break I tried to take a reading on the VDBE performance to get a
general idea. I wrote a quick module to enable me to exercise the engine
simulating 32M rows without any IOs. For each
Hi Folks:
I have read in many posting that SQLite is fast. How fast is fast? So over
this holiday break I tried to take a reading on the VDBE performance to get a
general idea. I wrote a quick module to enable me to exercise the engine
simulating 32M rows without any IOs. For each
Re-posting due to message size too long.
Hi Folks:
I have read in many posting that SQLite is fast. How fast is fast? So over
this holiday break I tried to take a reading on the VDBE performance to get a
general idea. I wrote a quick module to enable me to exercise the engine
simulating
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/28/2014 08:18 PM, Ward Willats wrote:
I am using the amalgamation in a C++ library statically linked into
other people's applications.
Is there a way to namespace and/or macro and/or let C++ do its
name-mangling thing to all the
Hello.
I am using the amalgamation in a C++ library statically linked into other
people's applications.
Is there a way to namespace and/or macro and/or let C++ do its name-mangling
thing to all the identifiers (by running the CPP compiler and turning
__cplusplus off) so only my library
On Tue, Oct 28, 2014 at 11:18 PM, Ward Willats sqlite-us...@wardco.com
wrote:
Hello.
I am using the amalgamation in a C++ library statically linked into other
people's applications.
Is there a way to namespace and/or macro and/or let C++ do its
name-mangling thing to all the identifiers
On Oct 28, 2014, at 8:23 PM, Richard Hipp d...@sqlite.org wrote:
On Tue, Oct 28, 2014 at 11:18 PM, Ward Willats sqlite-us...@wardco.com
wrote:
Hello.
I am using the amalgamation in a C++ library statically linked into other
people's applications.
Is there a way to namespace and/or
Hi all,
I see my query hanging with this stack:
dybagme-where
#0 0x00332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0
#1 0x0041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at
sqlite3.c:27735
#2 0x0041b54c in unixSync (id=0x2315650, flags=2) at
On 19/09/14 17:40, Bokassa wrote:
Hi all,
I see my query hanging with this stack:
dybagme-where
#0 0x00332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0
#1 0x0041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at
sqlite3.c:27735
...
The program itself is
I'm doing my project by using sqlite with code block..
and it create connection properly with sqlite...
but while runing,I got the following message and do not know what I am to do
:
sqltext.exe(my database file name) has stopped working
A problem caused the progrm to stop working correctly.
On Sun, 27 Jul 2014 23:16:05 -0700 (PDT), suparna
suparna.dhin...@gmail.com wrote:
I'm doing my project by using sqlite with code block..
and it create connection properly with sqlite...
but while runing,I got the following message and do not know what I am to do
:
sqltext.exe(my database file
option D; use a single connection per thread.
Take advantage of __thread ... and each thread can see if(
!database_connection ) connect().
-or- make A thread that you queue all work to; but you'd still need a
seperate connection for each reader...
Open and close are a large hit to do per
What is the best practice to use sqlite3 handler in multithread
environment.[I am using on Linux]
· Open sqlite3 database file once use the same sqlite3 handler in
all the thread for any operation on sqlite3 database file.
or
· Open close all the time for each operation on
SQLite is a desktop application, not a network aware application. The file
locking mechanisms lie to SQLite which makes it an EXTREMELY HIGH CHANCE
that connectivity and any WRITE statements WILL cause data corruption.
This isn't the fault of SQLite but the network file system locking. AFAIK,
Hi there,
We use SQLite in our application to store the data, and some of our users
prefer to keep the files on a network drive. The application opens a connection
to sqlite database and keeps it open for a while, storing and retrieving the
data at user's request.
The issue that some clients
Denis Y. Zibarev wrote:
The problem goes down to winLock() implementation, particularly to
winLockFile() ...
I've made some experimental changes on the winLockHandle branch that should
address
this issue; however, I still need to add some tests to verify the new
behavior.
--
Joe Mistachkin
Hi,
Please correct me on below points for Sqlite3 on Linux platform.
1) Sqlite3 doesn’t have any concurrency issue when multiple process
reading one database file at same time. This doesn’t required any special
mode setting (Like WAL)
2) One process is reading other process tries
On 23 Apr 2014, at 10:29am, techi eth techi...@gmail.com wrote:
1) Sqlite3 doesn’t have any concurrency issue when multiple process
reading one database file at same time. This doesn’t required any special
mode setting (Like WAL)
Correct.
2) One process is reading other process
Many Thanks for quick reply.
Could you please suggest me other journal mode for second case.My target
filesytem dosen't support mmap WAL required mmap support.
Thanks
On Wed, Apr 23, 2014 at 3:05 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Apr 2014, at 10:29am, techi eth
On 23 Apr 2014, at 10:42am, techi eth techi...@gmail.com wrote:
Many Thanks for quick reply.
Could you please suggest me other journal mode for second case.My target
filesytem dosen't support mmap WAL required mmap support.
http://www.sqlite.org/pragma.html#pragma_journal_mode
It would
make install in the SQLite source tree (obtained via Fossil) does not
install the sqlite3 shell man page, sqlite3.1.
--
Andy Goth | andrew.m.goth/at/gmail/dot/com
___
sqlite-users mailing list
sqlite-users@sqlite.org
Jan,
Good catch: I was in the tea/ directory, building the DLL for use with
TEA on Cygwin at the outset of this thread. When I ran my test TCL
script with the 'load libsqlite3.8.4.dll SQLite3' line, the dll was
there, but sqlite3.exe wasn't.
So, I started looking over things to see why the
A few days ago, I successfully compiled the previous version of the
autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
sqlite3.exe file was produced on a Cygwin environment.
This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked,
ran 'make clean' and 'make', but no
On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian
keith1christ...@gmail.comwrote:
A few days ago, I successfully compiled the previous version of the
autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
sqlite3.exe file was produced on a Cygwin environment.
This morning, I downloaded
Richard,
Thanks for the reply. Your instructions produced a working
sqlite3.exe in the Cygwin environment, using
sqlite-amalgamation-3080401.zip.
The resulting file is quite large, almost 14 times the size of the
sqlite3 version 3.8.3 packages with Cygwin:
ls -l /usr/bin/sqlite3.exe
]
Gesendet: Dienstag, 11. März 2014 17:11
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] sqlite3.exe file not produced by
sqlite-autoconf-3080400.tar.gz on Cygwin
Richard,
Thanks for the reply. Your instructions produced a working sqlite3.exe in the
Cygwin environment, using
On 11 Mar 2014 at 16:11, Keith Christian keith1christ...@gmail.com wrote:
The resulting file is quite large, almost 14 times the size of the
sqlite3 version 3.8.3 packages with Cygwin:
ls -l /usr/bin/sqlite3.exe
-rwxr-xr-x 1 kchris Domain Users 60957 Feb 4 04:45 /usr/bin/sqlite3.exe
Hick, Tim,
Thanks, I thought it was something like that. Couldn't remember the
exact gcc switches as to whether the debug code may have been included
or not in Richard's command line, which was my first thought. But at
least with Richard's command line I have a working, up to date sqlite3
2014-03-11 17:45 GMT+01:00 Keith Christian keith1christ...@gmail.com:
Will have to troubleshoot the details of the makefile changes between
the autoconf version from 3.8.3 to 3.8.4, to see why on this Cygwin
environment a sqlite3.exe wasn't created. That will be awhile,
pretty busy at $WORK
An: General Discussion of SQLite Database
Betreff: [sqlite] SQlite3 Performnace
Hi,
Is there any way I can check SQlite3 Database read/write timing for
performance measurement.
What are the changes in performance if I have single SQlite3 Database file
(Contain 'N' table) or 'N' Database
Hi all,
I wrote a web application that uses a combination of webserver, php and
sqlite.
A page uses a connection to a DB to generate with a choice a select
box, all work good on pc.
I have installed all need on a embedded linux using
lighttpd-1.4.32+php-5.4.6-sqlite3-3.7.1.
The connection is
On 14 Feb 2014, at 8:54am, techi eth techi...@gmail.com wrote:
What are the changes in performance if I have single SQlite3 Database file
(Contain 'N' table) or 'N' Database file each contain single table.
I have database on single Disk.In that case i see it is better to create
separate
On 14 Feb 2014, at 11:08am, Alberto Gioia downloa...@tiscali.it wrote:
I wrote a web application that uses a combination of webserver, php and
sqlite.
A page uses a connection to a DB to generate with a choice a select box,
all work good on pc.
I have installed all need on a embedded
Hi,
Is there any way I can check SQlite3 Database read/write timing for
performance measurement.
What are the changes in performance if I have single SQlite3 Database file
(Contain 'N' table) or 'N' Database file each contain single table.
Regards,
Techi
1 - 100 of 964 matches
Mail list logo