inserts per second.
Temporary table in ram 1500 inserts per second.
I have tried the one shared connection before i found the part in doc, that
not recommends it, but there was some problems with locking in one
configuration and segment violation in the second case.
Jakub Ladman
> Are
ent schema, but i
have no idea at this time, how to do it different way.
Jakub Ladman
>
> As you have already understood there's no way you can make 2
> connections to one in-memory database. Although you can use one
> connection from both thread so that threads will naturally bloc
ith pragma temp_store = MEMORY.
Do you have any clue?
Is it completely stupid way?
Thank You
Jakub Ladman
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ok The definitive Guide to
> >SQLite and with
> >every next page, my image of SQL on a chip w/o OS disappears in haze.
> >
> >Is i wrote before, i do not need it actually, i use sqlite in linux
> >environment.
> >
> >Thank you for let you make me a picture.
>
cture.
Jakub Ladman
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
I think there is no need to change endianess.
Sqlite is shadowing out this and similar low level aspects.
If you need to get data from database and use it in something what needs it in
other endianess, you may use something like this.
int change_endianess(unsigned char *data, int length)
{
Dne čtvrtek 22 březen 2007 13:16 [EMAIL PROTECTED] napsal(a):
> Jakub Ladman <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > I need to know how this works in detail:
> > I have sqlite3 database file stored on SD/MMC FLASH card and i would to
> > insert rows to so
buffer in ram and file is updated as late as multiple inserts
are done?
Do you understand me?
I do not know how to conceive this question in English exactly.
Best regards
Jakub Ladman
-
To unsubscribe, send email to
u think that is there a better method?
Thank You
Jakub Ladman
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Dne pondělí 12 březen 2007 18:04 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > Problem is, that this is pretty obscure system. Renesas SuperH SH4
> > CPU Heavily patched 2.4.18 kernel. (patches will be presented on
> > internet, but not at this time) Gentoo-emb
I think i do understand it now.
Thank you
Dne pondělí 12 březen 2007 16:08 Dennis Cote napsal(a):
> Jakub Ladman wrote:
> > Cause i am really blockheaded - is there somebody so good-hearted, who
> > could write simple step by step directions how to add one simple functio
Hi Friends
Cause i am really blockheaded - is there somebody so good-hearted, who could
write simple step by step directions how to add one simple function to
SQLite?
I have found so many inspirations and documentation seems to be very precise,
but i do not understand it at its width.
For exa
then
sqlite3> .load /home/jp/myLoadableLibs.so
Do someone knows which files from Mikey C's zip archive needs to be compiled
into loadable extension?
Where are the instructions on creating loadable extension?
Thank You
Jakub Ladman
Dne sobota 10 březen 2007 00:48 Clark Christense
Thank you very much.
I am new to this mailing list, so i missed it.
Jakub Ladman
Dne sobota 10 březen 2007 00:48 Clark Christensen napsal(a):
> A poster here, "Mikey C", wrote some math functions and posted them a month
> or so ago. You might have a look at
> http://www.mail
Jakub
Dne pátek 09 březen 2007 23:35 Dennis Cote napsal(a):
> Jakub Ladman wrote:
> > I will have table with sequence of coordinates (two dimensional space)
> > and corresponding radiuses, so sequence of circles. And i need to use a
> > sqlite query to detect if a actual coo
rstand not to some paragraph in docs.
Sometime it is enough to read it in other words.
(Something you consider as absolutely simple, may be difficult to understand,
not technicaly, but as english text, or easy to overlook.
If you feel my questions incommodious, please ignore it.
Thank You
Ja
I am sorry, it seems to be unreadable bacause of my very bad english.
I try to correct it little bit.
Hi Friends :-)
Is there a possibility to have sin, cos anD acos, functions in sqlite?
How to write it in? I have read (Mike Owens article at LinuxJournal), that it
is possible to write new funct
Hi Friends
Is there a possibility to have sin cos an acos, functions in sqlite?
How to write it in?
I really need it and i have fear, that sinus values table will be so slow and
so big for critical precission.
I will need to select coordinates which are laying in circle of known center
and radi
Dne čtvrtek 08 březen 2007 17:02 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > Now i have discovered, that this appears only if the database file is
> > stored on the nfs filesystem (posibly too slow, or something similar)
>
> There have been many threads on this list ab
appointed , it's a terrific book!
>
> -Original Message-
> From: Jakub Ladman [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 08, 2007 9:51 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] stupid man's manual to sqlite?
>
> Thank you i will try my possibil
Few days ago i have had problem with "SQL error: database is locked"
Now i have discovered, that this appears only if the database file is stored
on the nfs filesystem (posibly too slow, or something similar)
I will try to togle some nfs parameters as sync/async and so...
Jakub
team building
> products. Position is in the Washington D.C. metro area. If interested
> contact [EMAIL PROTECTED]
>
> -Original Message-
> From: Jakub Ladman [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 08, 2007 7:26 AM
> To: sqlite-users@sqlite.org
> Subject:
Now i have complete answer, every object file must be compiled with -fPIC
parameter, now it seems to be good.
Jakub
Dne čtvrtek 08 březen 2007 15:33 Jakub Ladman napsal(a):
> I have found that it may be problem with something called TEXTREL
> I do not know what is it, but:
>
> [EMA
/shsqlite $
How do I disable creation of DT_TEXTREL?
Thank You
Jakub
Dne čtvrtek 08 březen 2007 15:03 Jakub Ladman napsal(a):
> Hi there
>
> I have discovered problem while trying to run crosscompiled simple test
> program for my target embedded system.
>
>
>
> /mnt
Hi there
I have discovered problem while trying to run crosscompiled simple test
program for my target embedded system.
/mnt/nfs/home/jakub/shsqlite $ ./testsql test.db 'create table tbl1(one
varchar(10), two smallint)'
Can't modify /usr/lib/libsqlite3.so's text section. Use GCC option -fPIC
$./a.out test.db 'insert into tbl1 values('hello!',10)'
> $./a.out test.db 'select * from tbl1'
>
Thank you, very very very much.
Jakub
> Thanks,
> Pavan.
>
> On 3/8/07, Jakub Ladman <[EMAIL PROTECTED]> wrote:
> > Hi (much smarter) friend
Oh, wikipedia says " It also serves as an example for writing applications
that use the SQLite library."
Of course, why do i not get it myself?
Jakub
Dne čtvrtek 08 březen 2007 13:26 Jakub Ladman napsal(a):
> Hi (much smarter) friends.
> I need to start with sqlite (interface
goodbye', 20);
sqlite> select * from tbl1;
hello!|10
goodbye|20
sqlite>
but not this:
rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
What format of the command line argument should i write?
Thank you for any advice.
Jakub Ladman
--
Dne čtvrtek 01 březen 2007 13:11 Pavan napsal(a):
> Hi,
>
> Could anyone share their observations/comments on having used sqlite as DB
> for embedded linux environment.
I have just started.
Now i have sqlite compiled for embedded linux based on kernel 2.4.18 and
uclibc library on Renesas SuperH c
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, y
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 cros
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);
> > SQ
Dne úterý 27 únor 2007 16:44 anis chaaba napsal(a):
> there's another process using the data base or executing a transaction
No there's not. :-(
I have fear, that is some bug in croscompilation.
Jakub Ladman
>
> 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]>
Dear Friends
Please let me know 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>
(sqlite is launched by root
: database is locked
sqlite>
Thank you
Jakub Ladman
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Ok, now is it linked together, i will try, if it is functional.
Jakub Ladman
Dne pondělí 26 únor 2007 20:23 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > but after correction of this i get:
> >
> > libsqlite3.a -lpthread
> > libsqlite
ned reference to `dlclose'
collect2: ld returned 1 exit status
make: *** [sqlite3] Error 1
[EMAIL PROTECTED] ~/src/sqlite-3.3.13 $
Jakub Ladman
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Dne pondělí 26 únor 2007 12:25 Gunnar Roth napsal(a):
> Jakub Ladman schrieb:
> >> It's seems a bit strange to me that Makefile.linux-gcc includes tcl in
> >> the build by default, but it does. Maybe that should change...
> >>
> >> If you add "-DN
Dne neděle 25 únor 2007 19:25 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
>
> You want "make -f Makefile.linux-gcc"
Oh, of course, sorry.
And how to fix this?
[EMAIL PROTECTED] ~/src/sqlite-3.3.13 $ make -f Makefile.linux-gcc
sh4-pc-linux-uclibc-gcc -Os -DNDEBUG=1
ing to be hopeless.
Jakub Ladman
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Dne neděle 25 únor 2007 11:50 Martin Jenkins napsal(a):
> Jakub Ladman wrote:
> > Is there other mailing list, primarily targeted for developers of sqlite?
>
> SQLite's primary developer and at least one of the wrapper developers
> are active on this list, so here is as good
Dne neděle 25 únor 2007 11:36 Roger Binns napsal(a):
> Jakub Ladman wrote:
> > Is there other mailing list, primarily targeted for developers of sqlite?
>
> No.
>
> > I think my question about crosscompilation matches no person, which is
> > able to check sqlite
Is there other mailing list, primarily targeted for developers of sqlite?
I think my question about crosscompilation matches no person, which is able to
check sqlite's configure script for error in crosscompilation setup.
Thank you
Jakub Ladman
BTW. Sorry if i am impa
Dne sobota 24 únor 2007 18:33 Jakub Ladman napsal(a):
> Hi Friends
> Please help me
> I need crosscompile sqlite for my sh4 cpu based linux system, but configure
> script (any version of sqlite i have tryed, even the actual one from sqlite
> homepage) fails if crosscompilat
Hi Friends
Please help me
I need crosscompile sqlite for my sh4 cpu based linux system, but configure
script (any version of sqlite i have tryed, even the actual one from sqlite
homepage) fails if crosscompilation is selected.
Crosscompiler works good in other cases.
Thank you very much.
Jakub
46 matches
Mail list logo