[sqlite] MingW32 help wanted
Hello, I have found this post: http://marc.10east.com/?l=sqlite-usersm=115689163614925w=2 My target is to get sqlite compiled on my host platform i686 and my target platform mingw32. Could someone get a step by step manual to get the 'precious' dll/.a? When removing the os_unix.c from the Makefile I have everything compiled. But running mkdll.sh doesn't work for me :( Stefan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] MingW32 help wanted
Mike Frysinger wrote: On Tuesday 13 March 2007, Stefan de Konink wrote: My target is to get sqlite compiled on my host platform i686 and my target platform mingw32. Could someone get a step by step manual to get the 'precious' dll/.a? well, this could be autotoolized and force people to do ./configure --host=mingw32 i do that now with a library of my own ... but i cross-compile everything from my Linux host ;) -mike Ok that doesn't work. Because: lemon needs to run on the host system. os_unix doesn't compile because it has undefined 'locks'. removing os_unix leads to unresolved symbols in a lot of files when making the dll. So a step by step tutorial would be nice :) So what I did. ./configure --prefix=/opt/gtk Adapted Makefile and replaced TCC and added a --tag to libtool (because it otherwise complains). make everything is ok until os_unix... Stefan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] MingW32 help wanted
Scott Hess wrote: I took Makefile.linux-gcc, and made the obvious changes (there are mingw lines all over in there). EXE = .exe, SO =dll, SHPREFIX = , [that was nothing for that setting], and TCC, AR, and RANLIB set to the path to the appropriate commands from mingw. I should warn that I haven't actually built using mingw for maybe 9 months! This is just going off of the Makefile that I still have lying around. Thanks Scott! With a little bit of creativity I managed to get it all going! :) Stefan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] announce: libsqlfs
Currently it has been tested on 32-bit x86 and Strong Arm processors, with SQLite 2.8.16 and FUSE 2.3.5. It can be built both as an application library or as an FUSE module. Are you, your company, going to implement a /etc-in-one-file? Or isn't saving settings and small rich-text-files the main target? Stefan de Konink - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Open sqb database in php?
On Thu, 6 Jul 2006, Albert van Bergen wrote: Is it possible to open a sqb database in php? Natively you can open SQLite 2 databases. There is a 'package' avaiable to open SQLite 3 database, but I never tried that. Stefan
Re: [sqlite] SQlite
On Mon, 5 Jun 2006, Cesar David Rodas Maldonado wrote: i am interesting to do something for sqlite, and i was thinking to try to do a multi threading for read and write at the same time, like MySQL, or i would like to do something for fulltext search. Please people answer me giving me ideas!!! Fulltextsearch would be sweet :) Currently my database is too big to do a 'like' in reasonable time. Stefan
Re: [sqlite] SQlite
On Mon, 5 Jun 2006, Cesar David Rodas Maldonado wrote: I am developing something for that. where can i send you my script? (is done in C) I think more people will be interested in it. So if it is not too big send it to the list, otherwise put in on a website :) (or mail me privately) Stefan
[sqlite] Bugreport (minor)
SQLite version 2.8.16 Enter .help for instructions sqlite \; Segmentation fault Probably some minor thing. Stefan
Re: [sqlite] Database locks up on AMD64/PHP
On Tue, 7 Mar 2006, Firman Wandayandi wrote: On 3/7/06, Stefan de Konink [EMAIL PROTECTED] wrote: Hello, We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs our TV Newspaper System. It was running on a PIII-1GHz but due some shifts for rendering performance increase (Inkscape SVG - PNG) we moved the complete application to an AMD64. The last weeks it seems the database got locked very often, and made the apache/php system 'hang', not on query but on insert. Restarting Apache solves the problem making me wonder what I can do to visualize the problem or even fix it. As temporary fix I already tried to decrease the database size (now at 7MB). But this only increase speed (for now). What's this meant? What part isn't clear? Stefan
[sqlite] Database locks up on AMD64/PHP
Hello, We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs our TV Newspaper System. It was running on a PIII-1GHz but due some shifts for rendering performance increase (Inkscape SVG - PNG) we moved the complete application to an AMD64. The last weeks it seems the database got locked very often, and made the apache/php system 'hang', not on query but on insert. Restarting Apache solves the problem making me wonder what I can do to visualize the problem or even fix it. As temporary fix I already tried to decrease the database size (now at 7MB). But this only increase speed (for now). Yours Sincerely, Stefan de Konink