Re: [sqlite] How to install SQLite on a shared linux hosting
On Friday 17 October 2008 16:39:32 [EMAIL PROTECTED] wrote: > > only compiled and linked into an application. There is no server. > > Martin, thank you for the answer. > I do not really understand "compiled", "linked into an application" > and "there is no server". Use Google. There are lots of explanations out there. You should know these if you are installing software on servers. > They are far too technical terms. In simpe terms: Sqlite does not run by itself, it needs to be incorporated into another piece of software. You said you are using PHP. It usually includes sqlite. If not, ask your hosting provider. Graeme > > But, judging from your short answer, I believe that there is no way to > use it to store/retrieve data for my site. > Am I right? > > Luigi > ___ > 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] Can SQLite take advantage of multiple CPU's and/ormultiple cores?
On Friday 19 September 2008 09:50:53 Igor Tandetnik wrote: > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > Can SQLite take advantage of multiple CPU's and/or multiple > > cores? > > Not automatically: SQLite API functions run on whatever thread you call > them on. Of course, you can create multiple threads and open multiple > SQLite connections - preferably to different DB files, to maximize > concurrency. Looking at the docs and the wiki it looks to me that there are no problems with multiple processes using the same DB, but one needs to be a bit more careful with threads (and you have to be sure it is compiled with threads enabled). Also, are there any disadvantages to compiling threadsafe? I imagine there is some impact on performance. Anything else? Graeme -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] best language match for SQLite?
The Tcl interface is, as others have mentioned, the original one and suported by the sqlite developers. it is: 1) very easy to use 2) up to date 3) more complete than alternatives 4) flexible and given Richard Hipp's comment on the amount of Tcl code used to test sqlite, that looks very unlikely to change. Tcl is also developing very nicely. I have used recently after a long time and a lot of what I wished the language had is either in the current Tcl 8.5 (math operators and functions importable as commands, a syntax addition to pass a list as a set of separate arguments to a command...) or planned for 8.6 (the chan pipe command, for better inter-process communication for example). Graeme Pietersz http://pietersz.co.uk/ http://moneyterms.co.uk/ On Tuesday 16 September 2008 21:20:40 Patrick wrote: > I am a beginner to intermediate Python Programmer. I can use SQLite with > it just fine but it is my understanding that relational database and > object oriented programming our not the perfect marriage. > > I was just wondering if anyone had an opinion on the most ideal language > to use with SQLite? > > I love Python but I LOVE SQLite, I would learn another language just to > use it better-Patrick > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with Sqlite
As the previous rely said, this is not a sqlite problem. I am not sure what it is because Firefox by itself does not seem to allow direct editing of the sqlite databases it uses (are you using some extension?). I suggest you ask on the Ubuntu forums. Also, look for the issue in the Wubi launchpad bug tracker. If you are using a FF extension see what support the author of that offers. Incidentally, Wubi has some limitations compared to a proper (i.e. on its own partition) Linux install and is probably better for trying out Ubuntu rather than permanent use. Graeme On Wednesday 20 August 2008 10:01:51 Jeffrey Needle wrote: > I'm using the install of Firefox that comes with the Wubi install of > Linux. I like sqlite, but have a little problem. Perhaps someone can > help. > > When I add a new record to a database, an entry screen comes up with my > fields and the ability to enter the new record. But the information I > type into the input field seems placed in the field a bit too low -- > about half of each letter is cut off at the bottom and I can't really > read what I'm typing. > > Is there a way to fix this? Has anyone else had this experience? > > Thanks. -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
On Friday 01 August 2008 17:37:51 Alexey Pechnikov wrote: > > And how about SQLite+ICU compilation? Is it work for you? > > In configure.in > > TCC += -DSQLITE_ENABLE_ICU=1 `icu-config --ldflags` > LIBOBJ += icu.lo > > icu.lo: $(TOP)/ext/icu/icu.c $(HDR) > $(LTCOMPILE) -c $(TOP)/ext/icu/icu.c > > and in file mksqlite3c.tcl add icu.c in "foreach file" circle before main.c > Thanks Alexey, it worked fine. I would never have thought to change mksqlite3c.tcl, so thanks especially for that. I can see why ICU is left out of the downlodable binaries: the vmsize is much bigger with it. It is OK for my puposes, but I can see why many people would not want it. Graeme ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
On Friday 01 August 2008 19:59:16 Alexey Pechnikov wrote: > Hello! > > > And how about SQLite+ICU compilation? Is it work for you? Not yet, but I will try to solve the problems myself before asking for more help. > > > > In configure.in > > I'm sorry, in Makefile.in, of cource I was about to ask > I think that debian mantainer of libicu using some patches for it. May be > I'll find solution in patches for debian package. So it is an ICU problem? Have to go now, will let you know how things go with compiling. Graeme -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Error on loading ICU extension
On Friday 01 August 2008 13:21:08 Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Friday 01 August 2008 11:41:54 Mihai Limbasan написал(а):
> > What does
> >
> > ldd /path/to/your/compiled/libSqliteIcu.so
> >
> > report?
>
> On linux debian for workable libSqliteIcu.so:
>
> $ ldd libSqliteIcu.so
> linux-gate.so.1 => (0xe000)
> libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7f4b000)
> libicui18n.so.38 => /usr/lib/libicui18n.so.38 (0xb7df8000)
> libicuuc.so.38 => /usr/lib/libicuuc.so.38 (0xb7cd1000)
> libicudata.so.38 => /usr/lib/libicudata.so.38 (0xb71fa000)
> libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb70ac000)
> /lib/ld-linux.so.2 (0x8000)
> libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb6fc1000)
> libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb6fb6000)
>
Mine, (not working!) on Mandriva 2008.1 is:
linux-gate.so.1 => (0xe000)
libm.so.6 => /lib/i686/libm.so.6 (0xb7fb8000)
libicui18n.so.38 => /usr/lib/libicui18n.so.38 (0xb7e6)
libicuuc.so.38 => /usr/lib/libicuuc.so.38 (0xb7d2b000)
libicudata.so.38 => /usr/lib/libicudata.so.38 (0xb7254000)
libc.so.6 => /lib/i686/libc.so.6 (0xb710f000)
/lib/ld-linux.so.2 (0x8000)
libpthread.so.0 => /lib/i686/libpthread.so.0 (0xb70f8000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb700a000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb6ffe000)
Graeme
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] More on ICU extension (windows)
On Friday 01 August 2008 16:45:54 Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а):
> > Try this
> > http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll
--snip--
> sqlite> SELECT load_extension('libSqliteIcu.dll');
> SQL error: error during initialization:
> sqlite> .load 'libSqliteIcu.dll'
> sqlite>
--snip--
>
> from utf8.h from icu package. I replace U_EXPORT to U_EXPORT2 and now
> libSqliteIcu.dll is compiled but it's not correct way.
>
looks like a smimilar problem. It also looks to me like debugging this would
be difficult
Graeme
--
Graeme Pietersz
http://moneyterms.co.uk/
http://pietersz.co.uk/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Error on loading ICU extension
On Friday 01 August 2008 13:21:08 Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Friday 01 August 2008 11:41:54 Mihai Limbasan написал(а):
> > What does
> >
> > ldd /path/to/your/compiled/libSqliteIcu.so
> >
> > report?
>
> On linux debian for workable libSqliteIcu.so:
>
> $ ldd libSqliteIcu.so
> linux-gate.so.1 => (0xe000)
> libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7f4b000)
> libicui18n.so.38 => /usr/lib/libicui18n.so.38 (0xb7df8000)
> libicuuc.so.38 => /usr/lib/libicuuc.so.38 (0xb7cd1000)
> libicudata.so.38 => /usr/lib/libicudata.so.38 (0xb71fa000)
> libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb70ac000)
> /lib/ld-linux.so.2 (0x8000)
> libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb6fc1000)
> libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb6fb6000)
>
Mine, (not working!) on Mandriva 2008.1 is:
linux-gate.so.1 => (0xe000)
libm.so.6 => /lib/i686/libm.so.6 (0xb7fb8000)
libicui18n.so.38 => /usr/lib/libicui18n.so.38 (0xb7e6)
libicuuc.so.38 => /usr/lib/libicuuc.so.38 (0xb7d2b000)
libicudata.so.38 => /usr/lib/libicudata.so.38 (0xb7254000)
libc.so.6 => /lib/i686/libc.so.6 (0xb710f000)
/lib/ld-linux.so.2 (0x8000)
libpthread.so.0 => /lib/i686/libpthread.so.0 (0xb70f8000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb700a000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb6ffe000)
Graeme
--
Graeme Pietersz
http://moneyterms.co.uk/
http://pietersz.co.uk/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Error on loading ICU extension
On Friday 01 August 2008 12:48:49 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 11:10:45 Graeme написал(а): > > > Try to install before > > > libicu-dev > > > libicu38 > > > > Thanks Alexey. I have both those installed. I assume you did not change > > anything else to get it to work? > > No problem in code. Problem with dependencies. > > $ icu-config --ldflags > -lm -L/usr/lib -licui18n -licuuc -licudata -lm > > Do you have libs libicui18n, libicuuc, libicudata in /usr/lib? Yes. They are all there, and I get: $ icu-config --ldflags -lpthread -lm -L/usr/lib -licui18n -licuuc -licudata -lpthread -lm Graeme -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Error on loading ICU extension
On Friday 01 August 2008 11:57:17 Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Friday 01 August 2008 00:49:56 Graeme написал(а):
> > I apparently successfully compiled the ICU extension with:
> >
> > gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so
> >
> > but when I try to load it like this (using the TCL API, linux binary from
> > the site):
> >
> > load tclsqlite-3.6.0.so
> > % sqlite3 db test.db
> > % db enable_load_extension 1
> > % db eval {SELECT load_extension('libSqliteIcu.so')}
> >
> > I get:
> >
> > error during initialization:
> >
> > I am using the Linux binary from the website.
> >
> > I found the same problem (with the same extension) mentioned in the
> > mailing list archives, but with no solution recorded.
> >
> > What do I do next?
>
> I was write about this problem but now I'm can compiling ICU.
> Try to install before
> libicu-dev
> libicu38
>
Thanks Alexey. I have both those installed. I assume you did not change
anything else to get it to work?
Graeme
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Error on loading ICU extension
I apparently successfully compiled the ICU extension with:
gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so
but when I try to load it like this (using the TCL API, linux binary from the
site):
load tclsqlite-3.6.0.so
% sqlite3 db test.db
% db enable_load_extension 1
% db eval {SELECT load_extension('libSqliteIcu.so')}
I get:
error during initialization:
I am using the Linux binary from the website.
I found the same problem (with the same extension) mentioned in the mailing
list archives, but with no solution recorded.
What do I do next?
--
Graeme Pietersz
http://moneyterms.co.uk/
http://pietersz.co.uk/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Limiting the time a query takes
Thanks for having the patient to answer. I really deserved an RTFM for that. On Wednesday 02 July 2008 13:51:29 Igor Tandetnik wrote: > sqlite3_progress_handler -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Limiting the time a query takes
Is there any way to limit the time a query takes? i.e. tell sqlite to give up and return an error is the query is not done within a certain time. >From the limits page of the documentation, it appears not to be possible, but also not to matter too much: the explanation of limits of LIKE and GLOB patterns discusses maliciously constructed patterns, but DOS by a malicious user is not discussed elsewhere, so I guess it is unlikely to be an issue in other circumstances and I should not be too bothered about this. Graeme -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
