Re: [sqlite] WxDevCpp and Sqlite 3.4.1
[cut] Tnx Clay -- Massimiliano Marini - http://www.linuxtime.it/massimilianomarini/ "It's easier to invent the future than to predict it." -- Alan Kay
[sqlite] WxDevCpp and Sqlite 3.4.1
Hi all, Under linux I've no problems with g++ I've compiled sqlite 3.4.1 and created a makefile with the parameters (include,library) where I compile the main.cpp and all is right. I want to compile the same file main.cpp under WxDevCpp but I don't know how setup sqlite 3.4.1. Under linux I've the library libsqlite3.so (generated by the compilation of sqlite) but under windows I don't know how to setup WxDevCpp with sqlite 3.4.1. main.cpp is simple (shell) program that create the db file and populate it with a simple insert. Any help, links, suggests are appreciated. -- Massimiliano Marini - http://www.linuxtime.it/massimilianomarini/ "It's easier to invent the future than to predict it." -- Alan Kay
Re: [sqlite] new uploads
Dennis Cote wrote: Richard, I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error from Hurricane Electric. may is that the link you're looking for: http://www.sqlite.org/contrib Ciao Massimiliano
[sqlite] Locking and concurrency
Hi, I am using sqlite 2.8.5 and I'd like to know if I can have a proces that reads(select) while a proces is writing (insert or update) in the same db. I have read FAQ number 7 but it doesn't help me. Thank you very much. Bye Max * FAQ 7 **Can multiple applications or multiple instances of the same application access a single database file at the same time?* Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at once. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] change db-journal dir ????
ThanksI understand! But is it possible to set that dir? It isn't a big problem for me if I lost some records in case of failure. My rfs is in flash-memory and every transacation take a very long time. I must reduce this time! Thanks. Max Danny Reinhold wrote: Hi I have noticed that during my program execution a file named db-journal is created in the same dir of my db file. How can I change the dir in wich the db-journal file is created ? I want that all db-journal file is created in a dir mounted on ramdisk to improve performance of my application? Is it a bad idea ? Yes, it is a bad idea. The journal file is used to recover data in case of failure. If you open a large transaction and insert thousends of rows and in the middle of the transaction your computer crashes. Then SQLite uses the journal file to restore your database and to undo the half completed transaction... - Danny -- Danny Reinhold Reinhold Software & Services - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] change db-journal dir ????
I have noticed that during my program execution a file named db-journal is created in the same dir of my db file. How can I change the dir in wich the db-journal file is created ? I want that all db-journal file is created in a dir mounted on ramdisk to improve performance of my application? Is it a bad idea ? Thanks very much. Bye Massimiliano Zilio http://www.fracarro.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Can I strip libsqlite.so.0.5.3 ?
I have not clear when I can/can 't strip an object file. Could yuo explane me? Can I strip libsqlite.so.0.5.3 ? -rw-r--r--1 root root 326048 set 2 12:23 libsqlite.so.0.5.3(stripped) -rwxr-xr-x1 root root 1242413 ott 23 14:06 libsqlite.so.0.5.3 (not stripped) It's a big difference of size! Thank you! Max - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]