Re: [sqlite] ANN: SQLite 3.6.16.C#

[Yves Goergen]

On 01.08.2009 16:19 CE(S)T, Noah Hart wrote:
> This is not a driver, dll, or wrapper.  This is a port of the underlying
> SQLite software.

Hm, yes, but isn't the other C# SQLite assembly also the entire DB
engine? I mean, there's no client/server driver; if you can access
SQLite files, you already have the entire engine in your hands. And the
other one doesn't need any additional files, it's just one .NET
assembly. And a huge one. So I cannot imagine that it's just some
bindings to a native DLL.

-- 
Yves Goergen "LonelyPixel" 
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

[carlos . tasada]

Hi Dan,

Sorry, my fault. I'm testing in a 32bits Ubuntu 8.10 system running  
kernel 2.6.28-15-generic.

Thanks.

Quoting Dan Kennedy :

> On Aug 30, 2009, at 12:23 AM, carlos.tas...@farmerswife.com wrote:
>
>> Hi Dan,
>>
>> Yes I can confirm it. As more info here is the size of the so
>>
>> 407348 2009-08-29 19:03 tclsqlite-3.6.17.so
>
>
> Are you using 64-bit linux?
>
> Dan.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

[Dan Kennedy]

On Aug 30, 2009, at 12:23 AM, carlos.tas...@farmerswife.com wrote:

> Hi Dan,
>
> Yes I can confirm it. As more info here is the size of the so
>
> 407348 2009-08-29 19:03 tclsqlite-3.6.17.so


Are you using 64-bit linux?

Dan.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

[carlos . tasada]

Hi Gerry,

That's the first thing I tested. I downloaded this file:  
http://sqlite.org/tclsqlite-3.6.17.so.gz

Does anyone else have the same problem? I'm using ActiveTcl 8.5.4.

Thanks.

Quoting Gerry Snyder :

> Carlos Tasada wrote:
>> Hi guys,
>>
>> I'm trying to use sqlite 3.6.17 from a Tcl script in Linux, but as soon
>> as I do "load libsqlite3.so" I get an error: "undefined symbol:
>> Tcl_CreateObjCommand"
>>
>> Testing the script in Windows works fine.
>>
>> Anyone knows how to solve it?
>>
>> Thanks.
>>
> Looks like you are using the library without the Tcl bindings.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

[Gerry Snyder]

Carlos Tasada wrote:
> Hi guys,
>
> I'm trying to use sqlite 3.6.17 from a Tcl script in Linux, but as soon
> as I do "load libsqlite3.so" I get an error: "undefined symbol:
> Tcl_CreateObjCommand"
>
> Testing the script in Windows works fine.
>
> Anyone knows how to solve it?
>
> Thanks.
>   
Looks like you are using the library without the Tcl bindings.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] AIX performance

[John Stanton]

What machine runs AIX and what machine runs Linux and what FS are you 
using on Linux?

Ken wrote:
> Im looking for some ideas as to why the performance for a select statement 
> takes roughly 5 times longer on AIX as on a linux system.
>
> The disk drive on the aix platform is a 10k scsi vs the 7200 rpm drive on 
> linux.
>
> AIX:
> sqlite> .timer on
> sqlite> .output ken.out
> sqlite> .read kdo.sql
> CPU Time: user 26.321955 sys 6.498729
> sqlite> 
>
> Linux:
> sqlite> .timer on
> sqlite> .output ken.out
> sqlite> .read kdo.sql
> CPU Time: user 4.648290 sys 0.888056
> sqlite> 
>
> Thanks,
> Ken
>
> Adding pragma temp_store=2 does seem to help, it does reduce the sys time 
> from 6 to .5
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Undefined Symbol: Tcl_CreateObjCommand

[Carlos Tasada]

Hi guys,

I'm trying to use sqlite 3.6.17 from a Tcl script in Linux, but as soon
as I do "load libsqlite3.so" I get an error: "undefined symbol:
Tcl_CreateObjCommand"

Testing the script in Windows works fine.

Anyone knows how to solve it?

Thanks.

-- 
Carlos Tasada
Software Developer

Farmers WIFE S.L

Tel+34 971 730 777
Fax+34 971 730 729

www.farmerswife.com

This e-mail and any attached files may contain confidential and/or
privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify
the sender immediately and destroy
this e-mail. Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] about journal file

[Tito Ciuro]

On 29/08/2009, at 06:25, Zhanjun You wrote:

> I finally understand do not need to deal with journal file.
> But I do not know what circumstances led to the journal file, this  
> time to
> read the database file will fail.What may cause such a thing happen?

Google is your friend: typing 'sqlite journal' shows the following  
link as the first match:

http://www.sqlite.org/lockingv3.html

-- Tito

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] about journal file

[Zhanjun You]

> > Zhanjun You wrote:
> >> I can not find how to implement the method to deal with journal
> >> files
> >
> > What do you mean by "deal" here? What exactly are you trying to do
> > with
> > them, that you cannot achieve simply by beginning and then
> > committing a
> > transaction?
> >
> > Igor Tandetnik
> >
> > My app meet power fail,so sqlite generate a journal file, like
> > mydb.db.journal, then my app con not connect sqlite datebase, I want
> > to know
> > how to do?
>
> Why not? What happens when your app tries to open the database
> after the system is rebooted?
>
> SQLite is supposed to detect the journal file and automatically
> roll it back when you open the database. Your program doesn't have
> to do anything special to deal with the journal file.
>
> The document you posted a link to in an earlier mail describing
> the journal file format is a design document, intended for people
> working on the SQLite core (or compatible systems). If you are
> programming an application that uses SQLite, you should not need
> to worry about any of these details.
>
> Dan.

I finally understand do not need to deal with journal file.
But I do not know what circumstances led to the journal file, this time to
read the database file will fail.What may cause such a thing happen?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users