Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-28 Thread Martin Jenkins

Jakub Ladman wrote:

But there is not tcl library at the time and when I tried to build sqlite 
without -DNO_TCL it failed.


I think you will have fewer problems building Tcl than you did building 
SQLite because the automake code will be more up to date. You'v ebuilt 
SQLite so you're an expert now. ;)


I can test it on the sh4 cpu for the community, of course, if you think it 
will be usefull.


I'd certainly try it if I was in your position. Getting Tcl built might 
take you half a day or a day, but if you do that and and can test SQLite 
then you'll get the benefit of years of testing in half an hour. If you 
test the library and it passes, you can draw a line at the interface and 
build on a solid foundation. If you don't test and you get odd bugs a 
month down the line you'll never know if it's a porting problem or a bug 
in your code or...


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Jakub Ladman
Dne úterý 27 únor 2007 20:47 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > Problem is, that i do not know tcl. I know only that it exist.
> > Jakub
>
> That's OK, it's just another target (make test) in the Makefile. You
> don't need to know any Tcl, you just have to install the source code and
> know where you've installed it.
>
> make test builds a program (called testfixture) which drives the sqlite
> library you've just built from tiny Tcl programs. Dr Hipp has written
> lots of these programs over the years. You might have to tweak the tool
> chain but as you've already built the library you should be OK. The test
> suite has over 20,000 tests in it, so it's well worth getting it going
> on a port to a new platform.
>
> Martin

But there is not tcl library at the time and when I tried to build sqlite 
without -DNO_TCL it failed.
I can test it on the sh4 cpu for the community, of course, if you think it 
will be usefull.

Jakub
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Martin Jenkins

Jakub Ladman wrote:

Problem is, that i do not know tcl. I know only that it exist.
Jakub


That's OK, it's just another target (make test) in the Makefile. You 
don't need to know any Tcl, you just have to install the source code and 
know where you've installed it.


make test builds a program (called testfixture) which drives the sqlite 
library you've just built from tiny Tcl programs. Dr Hipp has written 
lots of these programs over the years. You might have to tweak the tool 
chain but as you've already built the library you should be OK. The test 
suite has over 20,000 tests in it, so it's well worth getting it going 
on a port to a new platform.


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread drh
Jakub Ladman <[EMAIL PROTECTED]> wrote:
> Hi everybody
> Which files do i need at target (small embedded linux system)?
> 

I think the easiest way to build on a (possibly strange)
target embedded system is to do this on your development
platform:

   make target_source

That make target creates a directory called "tsrc" and fills
it will all the preprocessed source files and headers you will
need to build the actual library.  From these preprocessed
files, you might want to remove tclsqlite.c (if you do not want
the TCL interface) or fts* if you don't care about full-text
search or shell.c if you don't want the shell command.  Once
you've removed these extra files, build the shared library
for you target system like this:

   cross-cc -o libsqlite3-cross.so -shared *.c

If you are really ambitious, you might want to add a few
-DSQLITE_... argments to the command-line above to turn off
unwanted features or turn on optional features or whatever.
--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Jakub Ladman
My target is sh4-pc-linux-uclibc

And now i have .so too.

sh4-pc-linux-uclibc-gcc -shared *.o -o sqlite3.so

Dne úterý 27 únor 2007 16:39 Jakub Ladman napsal(a):
> Dne úterý 27 únor 2007 16:31 anis chaaba napsal(a):
> > you need the libsqlite.so.0... or the libsqlite3.so crosscompiled
> >
> :-( there is no .so file :-(
>
> Jakub
>
> > if you need the commande line copy sqlite3 or sqlite to your target
> >
> > 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>:
> > > Hi everybody
> > > Which files do i need at target (small embedded linux system)?
> > >
> > > after make i have these files
> > >
> > > alter.ohash.o opcodes.o  pragma.o   utf.o
> > > analyze.o  insert.o   os.o   prepare.o  util.o
> > > attach.o   keywordhash.h  os_os2.o   printf.o   vacuum.o
> > > auth.o legacy.o   os_unix.o  random.o   vdbe.o
> > > btree.olemon  os_win.o   select.o   vdbeapi.o
> > > build.olempar.c   pager.osqlite3vdbeaux.o
> > > callback.o libsqlite3.a   parse.csqlite3.h  vdbefifo.o
> > > complete.o loadext.o  parse.htable.ovdbemem.o
> > > date.o main.o parse.h.temp   tclsqlite.ovtab.o
> > > delete.o   mkkeywordhash  parse.otokenize.o where.o
> > > expr.o opcodes.c  parse.out  trigger.o
> > > func.o opcodes.h  parse.yupdate.o
> > > /mnt/nfs/home/jakub/shsqlite $
> > >
> > >
> > > Which files are necessary for running, and which for linking to my own
> > > C programs?
> > >
> > > And what should i do with this?
> > >
> > > SQLite version 3.3.13
> > > Enter ".help" for instructions
> > > sqlite> create table tbl1(one varchar(10), two smallint);
> > > SQL error: database is locked
> > > sqlite>
> > >
> > >
> > > Thank you
> > > Jakub Ladman
> > >
> > >
> > >
> > >
> > > ---
> > >--  To unsubscribe, send email to
> > > [EMAIL PROTECTED]
> > >
> > > ---
> > >-- 
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Jakub Ladman
Dne úterý 27 únor 2007 16:46 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > And what should i do with this?
> >
> > SQLite version 3.3.13
> > Enter ".help" for instructions
> > sqlite> create table tbl1(one varchar(10), two smallint);
> > SQL error: database is locked
> > sqlite>
>
> What was the command line? Can you get Tcl running on your machine? As
> you've effectively made a effectively new port it would be a good idea
> to try and get the tests working - they should pinpoint any areas which
> aren't working. A list of failing tests should make it easier to track
> the problem down than a "database locked" from the shell.

Problem is, that i do not know tcl. I know only that it exist.
Jakub


>
> Martin
>
> ---
>-- To unsubscribe, send email to [EMAIL PROTECTED]
> ---
>--

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread anis chaaba

you must change the configure file to use the tool chain to cross compile
your lib.
you must do modifications like gcc becomes gcc-arm-linux for example.
but what kind of target do you have?
do you have a tool chain

2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>:


Dne úterý 27 únor 2007 16:31 anis chaaba napsal(a):
> you need the libsqlite.so.0... or the libsqlite3.so crosscompiled
:-( there is no .so file :-(

Jakub
> if you need the commande line copy sqlite3 or sqlite to your target
>
> 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>:
> > Hi everybody
> > Which files do i need at target (small embedded linux system)?
> >
> > after make i have these files
> >
> > alter.ohash.o opcodes.o  pragma.o   utf.o
> > analyze.o  insert.o   os.o   prepare.o  util.o
> > attach.o   keywordhash.h  os_os2.o   printf.o   vacuum.o
> > auth.o legacy.o   os_unix.o  random.o   vdbe.o
> > btree.olemon  os_win.o   select.o   vdbeapi.o
> > build.olempar.c   pager.osqlite3vdbeaux.o
> > callback.o libsqlite3.a   parse.csqlite3.h  vdbefifo.o
> > complete.o loadext.o  parse.htable.ovdbemem.o
> > date.o main.o parse.h.temp   tclsqlite.ovtab.o
> > delete.o   mkkeywordhash  parse.otokenize.o where.o
> > expr.o opcodes.c  parse.out  trigger.o
> > func.o opcodes.h  parse.yupdate.o
> > /mnt/nfs/home/jakub/shsqlite $
> >
> >
> > Which files are necessary for running, and which for linking to my own
C
> > programs?
> >
> > And what should i do with this?
> >
> > SQLite version 3.3.13
> > Enter ".help" for instructions
> > sqlite> create table tbl1(one varchar(10), two smallint);
> > SQL error: database is locked
> > sqlite>
> >
> >
> > Thank you
> > Jakub Ladman
> >
> >
> >
> >
> >
-
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> >
-
> >


-
To unsubscribe, send email to [EMAIL PROTECTED]

-




Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Martin Jenkins

Jakub Ladman wrote:

And what should i do with this?

SQLite version 3.3.13
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
SQL error: database is locked
sqlite>


What was the command line? Can you get Tcl running on your machine? As 
you've effectively made a effectively new port it would be a good idea 
to try and get the tests working - they should pinpoint any areas which 
aren't working. A list of failing tests should make it easier to track 
the problem down than a "database locked" from the shell.


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Jakub Ladman
Dne úterý 27 únor 2007 16:31 anis chaaba napsal(a):
> you need the libsqlite.so.0... or the libsqlite3.so crosscompiled
:-( there is no .so file :-(

Jakub
> if you need the commande line copy sqlite3 or sqlite to your target
>
> 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>:
> > Hi everybody
> > Which files do i need at target (small embedded linux system)?
> >
> > after make i have these files
> >
> > alter.ohash.o opcodes.o  pragma.o   utf.o
> > analyze.o  insert.o   os.o   prepare.o  util.o
> > attach.o   keywordhash.h  os_os2.o   printf.o   vacuum.o
> > auth.o legacy.o   os_unix.o  random.o   vdbe.o
> > btree.olemon  os_win.o   select.o   vdbeapi.o
> > build.olempar.c   pager.osqlite3vdbeaux.o
> > callback.o libsqlite3.a   parse.csqlite3.h  vdbefifo.o
> > complete.o loadext.o  parse.htable.ovdbemem.o
> > date.o main.o parse.h.temp   tclsqlite.ovtab.o
> > delete.o   mkkeywordhash  parse.otokenize.o where.o
> > expr.o opcodes.c  parse.out  trigger.o
> > func.o opcodes.h  parse.yupdate.o
> > /mnt/nfs/home/jakub/shsqlite $
> >
> >
> > Which files are necessary for running, and which for linking to my own C
> > programs?
> >
> > And what should i do with this?
> >
> > SQLite version 3.3.13
> > Enter ".help" for instructions
> > sqlite> create table tbl1(one varchar(10), two smallint);
> > SQL error: database is locked
> > sqlite>
> >
> >
> > Thank you
> > Jakub Ladman
> >
> >
> >
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > -
> >

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread anis chaaba

you need the libsqlite.so.0... or the libsqlite3.so crosscompiled
if you need the commande line copy sqlite3 or sqlite to your target

2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>:


Hi everybody
Which files do i need at target (small embedded linux system)?

after make i have these files

alter.ohash.o opcodes.o  pragma.o   utf.o
analyze.o  insert.o   os.o   prepare.o  util.o
attach.o   keywordhash.h  os_os2.o   printf.o   vacuum.o
auth.o legacy.o   os_unix.o  random.o   vdbe.o
btree.olemon  os_win.o   select.o   vdbeapi.o
build.olempar.c   pager.osqlite3vdbeaux.o
callback.o libsqlite3.a   parse.csqlite3.h  vdbefifo.o
complete.o loadext.o  parse.htable.ovdbemem.o
date.o main.o parse.h.temp   tclsqlite.ovtab.o
delete.o   mkkeywordhash  parse.otokenize.o where.o
expr.o opcodes.c  parse.out  trigger.o
func.o opcodes.h  parse.yupdate.o
/mnt/nfs/home/jakub/shsqlite $


Which files are necessary for running, and which for linking to my own C
programs?

And what should i do with this?

SQLite version 3.3.13
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
SQL error: database is locked
sqlite>


Thank you
Jakub Ladman




-
To unsubscribe, send email to [EMAIL PROTECTED]

-




[sqlite] Crosscompiled sqlite was: developer mailing list

2007-02-27 Thread Jakub Ladman
Hi everybody
Which files do i need at target (small embedded linux system)?

after make i have these files

alter.ohash.o opcodes.o  pragma.o   utf.o
analyze.o  insert.o   os.o   prepare.o  util.o
attach.o   keywordhash.h  os_os2.o   printf.o   vacuum.o
auth.o legacy.o   os_unix.o  random.o   vdbe.o
btree.olemon  os_win.o   select.o   vdbeapi.o
build.olempar.c   pager.osqlite3vdbeaux.o
callback.o libsqlite3.a   parse.csqlite3.h  vdbefifo.o
complete.o loadext.o  parse.htable.ovdbemem.o
date.o main.o parse.h.temp   tclsqlite.ovtab.o
delete.o   mkkeywordhash  parse.otokenize.o where.o
expr.o opcodes.c  parse.out  trigger.o
func.o opcodes.h  parse.yupdate.o
/mnt/nfs/home/jakub/shsqlite $


Which files are necessary for running, and which for linking to my own C 
programs?

And what should i do with this?

SQLite version 3.3.13
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
SQL error: database is locked
sqlite>


Thank you
Jakub Ladman



-
To unsubscribe, send email to [EMAIL PROTECTED]
-