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
I've been meaning to ask...
What's the $dbh->func("busy_timeout") value intended to do? I see it seems to
default to 30 seconds. Does DBD-SQLite wait or retry a statement for 30
seconds if it encounters SQLITE_BUSY? Any light you can shed on this?
Thanks!
-Clark
- Original Message
Hi Dennis, thanks for this.
John.
On 05/05/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi, how do you get a list of all the table names within SQLite?
>
> Many thanks.
>
> John.
>
John,
From the sqlite shell use the .tables command.
From SQL code use:
select name from
On 5/5/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
- You never have to worry whether a newer sqlite3.dll will work with an
older wrapper, or a newer wrapper will work with an older sqlite3.dll. For
example, checkin 3040 and several other sqlite checkins which changed the
behavior of API
- Original Message -
From: "Nemanja Corlija" <[EMAIL PROTECTED]>
I'd be happy to see that list if its not a problem.
- Only one DLL to redistribute instead of two.
- Better side-by-side support. If multiple apps are using SQLite, there's
never any danger of them misbehaving
> In any case we seem to be settling to a long term
> sustained rate of
> about 40 flushes per second for WinXP. Since SQLite
> is getting only 10
> inserts per second, it seems to me that SQLite must
> be doing about 4
> flushes per insert. Does that seem right to you
> Richard?
For what
Hi, how do you get a list of all the table names within SQLite?
Many thanks.
John.
Hello,
I do not have Visual Studio or other compilers to
build Sqlite3 from the source code on my pc.
Is there a Windows binary version of Sqlite3 with the
"testfixture" build anywhere?
Thanks!
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
On 5/5/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
There's a lot more pros that cons to this
approach, I'd be happy to enumerate them if you like.
I'd be happy to see that list if its not a problem.
Thanks
--
Nemanja Corlija <[EMAIL PROTECTED]>
I have to use the University version at the moment as I'm creating my
University project and we have to demonstrate it at the University.
Thanks for letting me know, I would never have considered the version
differences.
John.
On 05/05/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
-
- Original Message -
From: "John Newby" <[EMAIL PROTECTED]>
Hi Robert, thanks for the advice. I'm using either the 2002 or 2003
version
(not sure what the University registers to) My supervisor recommended I
use
the finisar one instead of yours because of the .net framework, the
FWIW I've created a very high traffic web site (over 2000 tps) that
uses SQLite at its core (also uses MS SQL Server, but don't blame me
for that). So high traffic isn't a problem with a good design.
On 5-May-06, at 11:30 AM, Clark Christensen wrote:
I have dynamic apps running on my
Hi Robert, thanks for the advice. I'm using either the 2002 or 2003 version
(not sure what the University registers to) My supervisor recommended I use
the finisar one instead of yours because of the .net framework, the version
on the universoty is 1 and i think yours is based on version 2
- Original Message -
From: "John Newby" <[EMAIL PROTECTED]>
No sure with the one Robert recommended but the one I used has but it was a
different size and not as upto date as the one that I got from the SQLite
site so I just replaced it with the newer version but I presume it would
work
- Original Message -
From: "Paul Hunnisett" <[EMAIL PROTECTED]>
Excellent - thanks for the recommendation. I'm assuming the wrapper dll
doesn't contain the sqllite dll embedded in it?
The Finisar http://adodotnetsqlite.sourceforge.net wrapper is a separate dll
for ADO.NET 1.1 that
No sure with the one Robert recommended but the one I used has but it was a
different size and not as upto date as the one that I got from the SQLite
site so I just replaced it with the newer version but I presume it would
work with the older version also.
John.
On 05/05/06, Paul Hunnisett
Excellent - thanks for the recommendation. I'm assuming the wrapper dll
doesn't contain the sqllite dll embedded in it?
John Newby wrote:
I was having this problem also but I just copied the dll file into the
directory, and it worked fine with the ado.net wrapper at
- Original Message -
From: "John Newby" <[EMAIL PROTECTED]>
I was having this problem also but I just copied the dll file into the
directory, and it worked fine with the ado.net wrapper at
http://adodotnetsqlite.sourceforge.net/
John
On 04/05/06, Jay Sprenkle <[EMAIL PROTECTED]>
I was having this problem also but I just copied the dll file into the
directory, and it worked fine with the ado.net wrapper at
http://adodotnetsqlite.sourceforge.net/
John
On 04/05/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> I'm trying to add sqlite3.dll ot my application in VS 2005. I
>
Hi All,
I am using sqlite database for one of my website and using java driver
for accessing sqlite.
I was wondering is there any limit on number of open
connection(concurrent read only connections) to database.
What will be imnpact on performace if I increase number of open
connection?
SQLite itself supports reading SQL and SQLite stmt/commands from a file, so the
equivalent to the piped SQL would be
sqlite3 foo.db ".read bar.sql"
-Clark
- Original Message
From: Josef Hlawatschek (JT) <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, May 5, 2006
I have dynamic apps running on my company's website using Perl and SQLite.
There's a very good wrapper for using SQLite with the Perl DBI. Check out
http://search.cpan.org/~msergeant/DBD-SQLite-1.12
It works well for a low-volume app on a public site. I'm working on a new app
(also all
Hi,
I have found the possibility of using
CREATE TABLE some_new_table
INSERT INTO some_new_table SELECT * FROM
some_old_table_with_same_layout;
to be extremely useful to recreate databases.
Since ROWID is a hidden field of every table: will sqlite copy over
the identical
Rajan, Vivek K said:
> Thanks for answers.
>
> Sorry, I was not clear in my previous email. I do know the structure of
> the for the XML - I was wondering if there was a direct upload
> capability, once I know the structure of the XML.
I think that the problem is a little too generic for an
Vivek,
I build web based tools for the telecom industry, mostly using Perl.
I would ask if you are building a CGI or mod_perl web site? CGI will be
easier to start with, mod_perl will take you farther; but that has nothing
to do with SQLite. Have a look at http://perl.apache.org
There was a
On 5/5/06, Anders Persson <[EMAIL PROTECTED]> wrote:
I have written a wrapper around
iRes = sqlite3_get_table(db,sql);
But only SELECT works not INSERT or UPDATE
any ide.. missing somting
get table only works with select. Insert and update don't return a result set.
On 5/5/06, Felix Schwarz <[EMAIL PROTECTED]> wrote:
The average blob data in my tables is 3859 bytes in size. The
benchmarks were run with 6394 entries each and do necessarily include
application times for working on / creating the data including
additional I/O. But still, it does ilustrate that
Anders Persson <[EMAIL PROTECTED]> writes:
> I have written a wrapper around
>iRes = sqlite3_get_table(db,sql);
>
> But only SELECT works not INSERT or UPDATE
>
> any ide.. missing somting
The database file or the directory in which it is contained is read-only?
Obviously the database
Am 26.01.2006 um 02:54 schrieb [EMAIL PROTECTED]:
deminix <[EMAIL PROTECTED]> wrote:
I was curious if a single page of the database was limited to at
most one
record, aka can records be packed into a single page?
Multiple small records can fit on one page. Or a large record
can span
I have written a wrapper around
iRes = sqlite3_get_table(db,sql);
But only SELECT works not INSERT or UPDATE
any ide.. missing somting
// Anders
"Pat Wibbeler" <[EMAIL PROTECTED]> wrote:
> Is there a means for explicitly escalating an existing transaction from
> RESERVED to EXCLUSIVE (either through issuing sql statements or the C
> API)?
>
No there isn't. If you need to prevent other processes from
reading the database (presumably to
Josef Hlawatschek (JT) wrote:
Hi,
I want to use SQLITE3.EXE to run automated reports in Windows. I use
an init file to load parameters and a SQL script file. All goes well
until the SQL script has been executed, then the SQLITE3.EXE command
prompt appears. The command prompt only closes once
Hi,
I want to use SQLITE3.EXE to run automated reports in Windows. I use
an init file to load parameters and a SQL script file. All goes well
until the SQL script has been executed, then the SQLITE3.EXE command
prompt appears. The command prompt only closes once you manually type
in ".exit" or
Hi Vivek,
* Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 07:35]:
> Has someone done something like that and would share their
> experience on this topic.
have a look at Catalyst: http://www.catalystframework.org/
(Installation can be a pain; if you have problems, don’t miss
CatInABox:
34 matches
Mail list logo